Welcome Guest.   Make a donation to an author on the site September 18, 2014, 08:44:05 AM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
The N.A.N.Y. Challenge 2012! Download dozens of custom programs!
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: Prev 1 ... 20 21 22 23 24 [25] 26 27 28 29 30 ... 47 Next   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: SQLNotes...what is it exactly?  (Read 399480 times)
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #600 on: February 15, 2008, 10:07:07 AM »

Now I have this setup

I add files as I start working on them
When ticked Done they go blue
When Change Requested is ticked they go Yellow and the date gets added to notes field
When I tick Checked (i.e. changes made) they go Purple and the date gets added to date field

which I'm quite happy with

some queries

when filtering do I use the Actual name of field or the column heading?

In the “Auto-assign rules” how do I change the date to just date as opposed to date/time?

Is it possible to add many files at once ? Say select 20 in filemanager, drag n drop to grid -
I'm afraid to try that in case it really screws things up
Logged

Tom
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #601 on: February 15, 2008, 10:12:24 AM »

Now I have this setup

I add files as I start working on them
When ticked Done they go blue
When Change Requested is ticked they go Yellow and the date gets added to notes field
When I tick Checked (i.e. changes made) they go Purple and the date gets added to date field

which I'm quite happy with
Great! If you think that this solution can help other, do not hesitate to send it to me, I'll put it in the download area.

some queries

when filtering do I use the Actual name of field or the column heading?

In the “Auto-assign rules” how do I change the date to just date as opposed to date/time?

Is it possible to add many files at once ? Say select 20 in filemanager, drag n drop to grid -
I'm afraid to try that in case it really screws things up
1- Actual Field name must to be used everywhere. Heading is a display friendly caption, particularly useful as the number of fields grows
2- Auto-assign: use int(date) to get just the date
3- You can drag-drop as many files as you wish. Try it on a scrap item first (or better still in a temp database)
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #602 on: February 15, 2008, 11:18:48 AM »

Great! If you think that this solution can help other, do not hesitate to send it to me, I'll put it in the download area.

seems like this could be useful to others
How would I send it to you? (not the whole database tellme)
I'll probably make a few changes to it over the next week as it gets more used
Logged

Tom
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #603 on: February 15, 2008, 11:20:27 AM »

No rush.

You can make a copy and delete most (or all) items
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #604 on: February 15, 2008, 11:27:51 AM »

3- You can drag-drop as many files as you wish. Try it on a scrap item first (or better still in a temp database)

second time today:
Thmbsup whooHoo!!! Kiss

works a treat, each is gets it's own item
Logged

Tom
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #605 on: February 15, 2008, 12:01:57 PM »

only thing is I'm running out of colours tongue

Blue is DONE
Yellow in Change Requested
Purple is changes made (still has to be approved)

Red could be in Progress or To be Done.. or maybe no colour for that
Then a separate Tick box for Approved/Finalised I guess (Hows about a green colour for that ?)

I guess when an item has a colour it can only have one..
what I mean/thinking is:
it's not usually a problem but if you tick something by mistake that changes the colour*
and you then untick it -
it would be nice if it automatically went back to previous colour - is there an equation for that in the “Auto-assign rules” tellme cheesy

(just added 85 files ..wooHoo.. cheesy)

[edit] this can happen for example, something is approved and they then decide to change something else
gotta deselect approved, but then I guess it goes back to change rrequested colour. Ahh, logical as usual (I think) [/edit]
« Last Edit: February 15, 2008, 12:07:08 PM by tomos » Logged

Tom
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #606 on: February 15, 2008, 12:05:30 PM »

>it would be nice if it automatically went back to previous colour - is there an equation for that in the “Auto-assign rules”

You can have as many colors as you wish. See Options. Can also enter Hex color directly
It the workflow is know and fixed, you can add it to the auto-assign. Add E:ItemColor=xxx

Otherwise, you'll need to wait for the multi-level undo.  embarassed
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #607 on: February 15, 2008, 01:11:58 PM »

No rush.

You can make a copy and delete most (or all) items

sent it to Support@ - before I make it unintelligible !!
you'll have to extract it from the database -is that difficult to do?
-
I made a temp database to experiment and was surprised by some of the goodies in there
I wouldnt mind getting some stuff from it to my current database if not too difficult
Logged

Tom
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #608 on: February 15, 2008, 01:14:32 PM »

how it looks here



The presumed sequence is:

Done = Blue
ChangeRequest = Yellow + DateRequest
Checked (changes implemented) = Purple + DateChanged
Approved = Custom colour (dark blue)
[Working left to right]

if a box is unticked it goes back to logical previous colour, except for
Approved - this goes back to Blue when unticked

[edit] think some colour advise is required to make pretty! [/edit]
« Last Edit: February 15, 2008, 01:17:32 PM by tomos » Logged

Tom
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #609 on: February 15, 2008, 01:16:10 PM »

No rush.

You can make a copy and delete most (or all) items

sent it to Support@ - before I make it unintelligible !!
you'll have to extract it from the database -is that difficult to do?
-
I made a temp database to experiment and was surprised by some of the goodies in there
I wouldnt mind getting some stuff from it to my current database if not too difficult
Got it thanks! Very very interesting ! Some advanced stuff in there... you're progessing well!  Thmbsup
Database merge is scheduled for version 0.9.23. Superboyac (and others surely) is waiting on this feature.
« Last Edit: February 15, 2008, 01:18:45 PM by PPLandry » Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #610 on: February 15, 2008, 01:28:29 PM »

but going back to the colour thing is there a way to say:

change the colour when ticked IF "Approved" is NOT selected
Logged

Tom
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #611 on: February 15, 2008, 01:30:39 PM »

but going back to the colour thing is there a way to say:

change the colour when ticked IF "Approved" is NOT selected
Sure, but you need to use user-code for that!  cheesy
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #612 on: February 15, 2008, 01:34:04 PM »

but going back to the colour thing is there a way to say:

change the colour when ticked IF "Approved" is NOT selected
Sure, but you need to use user-code for that!  cheesy

oh-oh huh
Logged

Tom
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #613 on: February 15, 2008, 01:34:23 PM »

Got it thanks! Very very interesting ! Some advanced stuff in there... you're progessing well!  :Thmbsup
thanks smiley
it's a joy to get off the ground a bit,
especially now I'm going back to this job with hundreds of drawings after a long break (and I thought I left it in an organised state but I didnt have anything like this programme then..)

Re the grid I sent -
I forgot to add notes describing what happens when field clicked or whatever
[edit] I mean in the Manage Fields box
« Last Edit: February 15, 2008, 01:36:29 PM by tomos » Logged

Tom
Armando
Charter Member
***
Posts: 2,674



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #614 on: February 15, 2008, 01:47:00 PM »

Clever solutions you found there... Isn't it great tomos? I hope more and more people will start to dig into SQLNotes (hint hint), and help with the development (with suggestions and bug reports) as it is a VERY exciting project. Yes, it might take some time to get used to it (it is a bit geeky, in some respect  smiley ), but, apart from all the subtleties, its organizing principles and UI are in fact simple. Those with a bit of computer knowledge shouldn't have any problems with it.
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #615 on: February 15, 2008, 02:02:25 PM »

thanks for the tips Pierre
you say -

>I'd rename the grid and change the source to enable many projects shown in the grid.

I'm unsure of the best approach
This grid actually started off within the Billing grid which has a yes/no "Projects" field as the source
Now theres naturally going to be an overlap with projects here, but I dont fully understand how to approach that

Maybe if I had a yes/no "Drawings" field, I could include "projects" and exclude any NON-drawings thereby include various other projects too
That would be done in the filter presumably?
Speaking of which I cant seem to filter yes/no fields atall -
for "Checked" I get nothing
for "Checked is null" I get everything

Quote from: from the wiki
Checkboxes are a little different than you might expect (unless you know SQL). For example, for the Checkbox field Followup you would use Followup if you want to search for checked or Followup is null if you want to search for unchecked.
Logged

Tom
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #616 on: February 15, 2008, 02:03:53 PM »

Isn't it great tomos?

tell me about it !!
I've been struggling for years trying to organise this stuff and finally I can see the light Kiss
Logged

Tom
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #617 on: February 15, 2008, 02:15:15 PM »

Speaking of which I cant seem to filter yes/no fields atall -
for "Checked" I get nothing
for "Checked is null" I get everything

Quote from: from the wiki
Checkboxes are a little different than you might expect (unless you know SQL). For example, for the Checkbox field Followup you would use Followup if you want to search for checked or Followup is null if you want to search for unchecked.
Keep in mind that in your grid MegSurvey, there is only 1 fullly qualified item. All others are subs of it. If you put a filter Checked and your only grid item is not checked, you get 0 items.

You can do either:
1- Change the grid source to Project or Drawing, or whatever will return your current list, or
2- Use the grid filter (not the source bar filter). It works on all displayed items. Grid > Column filter buttons (also a sub-menu allows for some options). Little bug, this setting is not saved. I'll fix it today, in time for rel 0.9.22  (hourra!)
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
superboyac
Charter Member
***
Posts: 5,674


Is your software in my list?

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #618 on: February 15, 2008, 06:35:28 PM »

Oh sh--, tomos!  You're doing some really cool stuff there!  You're giving me ideas...
Thanks Pierre, yes, I'm definitely looking forward to merging some databases.  I'm also waiting for more importing features like the one I mentioned for texnotes.  After that, my transition to SQLNotes will pretty much be finalized.
Logged

PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #619 on: February 15, 2008, 06:37:23 PM »

BTW Version 0.9.22 is out  Cool
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,674



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #620 on: February 15, 2008, 11:55:28 PM »

Downloaded it, installed it : wonderful.
I tried to create a new thread at http://www.sqlnotes.net/F...ums/tabid/54/Default.aspx ,  but it doesn't seem to be possible at the moment.

There's one thing I wanted to ask about... The "export to webpage" : is it broken or am I missing something? I tried to export several grids, but nothing happens. It used to work before 0.9.22 and the last build.
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
Armando
Charter Member
***
Posts: 2,674



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #621 on: February 15, 2008, 11:57:33 PM »

After that, my transition to SQLNotes will pretty much be finalized.

Lucky you... I wish I could do the same (will probably to have to wait quite a bit...). SQLNotes is so much more "me" than, let's say... Outlook.
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
Armando
Charter Member
***
Posts: 2,674



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #622 on: February 16, 2008, 12:00:40 AM »

sent it to Support@ - before I make it unintelligible !!

I can't wait to see what you did tomos...  smiley
Inspiration...
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
Armando
Charter Member
***
Posts: 2,674



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #623 on: February 16, 2008, 12:27:06 AM »

Oh... And BTW, Pierre, I like the new notification on ctrl+E (delete). Most of my grids are too complex to use the "remove from this grid only", but I'm sure it will be MUCH safer for users not willing to use complex filters/sources.
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
tomos
Charter Member
***
Posts: 8,519



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #624 on: February 16, 2008, 09:14:33 AM »

Pierre
I changed "Done" field to new one called "FIN" cause I dont want things marked "done" in other grids going funny colours..
Added a "File" yes/no field, now source of grid
When I add things to grid this automatically selected = RED (= to be done)
can resend you the file if you want

I can't wait to see what you did tomos...  smiley
Inspiration...
eh  embarassed dont think I'd go that far Amando!
I've never been one for using search or filters much and I guess I'm very visual, so,
with lots of files being worked on, I can see progress at a glance (colourwise) and sort by column heading to see what has to be done/checked etc
With files taken from my screenshots folder:



SQLnotes09.png  just added,  (File box gets automatically ticked*) = Red = To be done!
SQLnotes08.png  finished,  FIN = Blue = sent on for approval/return
SQLnotes07.png  ChangeRequest ticked = Yellow + DateRequest (date added automatically)
SQLnotes06.png  Changed ticked (changes implemented) = Purple + DateChanged (date added automatically)
SQLnotes05.png  as #06 but Approved ticked = Dark Blue
SQLnotes04.png  Approved (without any changes requested)

again:-
if a box is unticked it goes back to logical previous colour, except for
Approved - this goes back to Blue when unticked

* I've hidden this column/field, just show it here for clarity (I hope)
[edit] changed the screenshot: "Checked" box now called called Changed, (changes implemented)
« Last Edit: February 16, 2008, 09:47:06 AM by tomos » Logged

Tom
Pages: Prev 1 ... 20 21 22 23 24 [25] 26 27 28 29 30 ... 47 Next   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.05s | Server load: 0.31 ]