Author Topic: SQLNotes...what is it exactly? (Read 902618 times)

tomos · « **Reply #600 on:** February 15, 2008, 10: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

PPLandry · « **Reply #601 on:** February 15, 2008, 10:12 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
-tomos (February 15, 2008, 10:07 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.

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
-tomos (February 15, 2008, 10:07 AM)

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)

tomos · « **Reply #602 on:** February 15, 2008, 11:18 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.
-PPLandry (February 15, 2008, 10:12 AM)

seems like this could be useful to others
How would I send it to you? (not the whole database

)
I'll probably make a few changes to it over the next week as it gets more used

PPLandry · « **Reply #603 on:** February 15, 2008, 11:20 AM »

No rush.

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

tomos · « **Reply #604 on:** February 15, 2008, 11:27 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)
-PPLandry (February 15, 2008, 10:12 AM)

second time today:

whooHoo!!!

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

tomos · « **Reply #605 on:** February 15, 2008, 12:01 PM »

only thing is I'm running out of colours

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”

(just added 85 files ..wooHoo..

)

[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]

PPLandry · « **Reply #606 on:** February 15, 2008, 12:05 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.

tomos · « **Reply #607 on:** February 15, 2008, 01:11 PM »

No rush.

You can make a copy and delete most (or all) items
-PPLandry (February 15, 2008, 11:20 AM)

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

tomos · « **Reply #608 on:** February 15, 2008, 01:14 PM »

how it looks here

SQLNotes...what is it exactly?

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]

PPLandry · « **Reply #609 on:** February 15, 2008, 01:16 PM »

No rush.

You can make a copy and delete most (or all) items
-PPLandry (February 15, 2008, 11:20 AM)

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
-tomos (February 15, 2008, 01:11 PM)

Got it thanks! Very very interesting ! Some advanced stuff in there... you're progessing well!

Database merge is scheduled for version 0.9.23. Superboyac (and others surely) is waiting on this feature.

tomos · « **Reply #610 on:** February 15, 2008, 01:28 PM »

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

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

PPLandry · « **Reply #611 on:** February 15, 2008, 01:30 PM »

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

change the colour when ticked IF "Approved" is NOT selected
-tomos (February 15, 2008, 01:28 PM)

Sure, but you need to use user-code for that!

tomos · « **Reply #612 on:** February 15, 2008, 01:34 PM »

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

change the colour when ticked IF "Approved" is NOT selected
-tomos (February 15, 2008, 01:28 PM)
Sure, but you need to use user-code for that!
-PPLandry (February 15, 2008, 01:30 PM)

oh-oh

tomos · « **Reply #613 on:** February 15, 2008, 01:34 PM »

Got it thanks! Very very interesting ! Some advanced stuff in there... you're progessing well! :Thmbsup
-PPLandry (February 15, 2008, 01:16 PM)

thanks

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

Armando · « **Reply #614 on:** February 15, 2008, 01:47 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

), 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.

tomos · « **Reply #615 on:** February 15, 2008, 02:02 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

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.
-from the wiki

tomos · « **Reply #616 on:** February 15, 2008, 02:03 PM »

Isn't it great tomos?
-Armando (February 15, 2008, 01:47 PM)

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

PPLandry · « **Reply #617 on:** February 15, 2008, 02: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

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.
-from the wiki
-tomos (February 15, 2008, 02:02 PM)

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!)

superboyac · « **Reply #618 on:** February 15, 2008, 06:35 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.

PPLandry · « **Reply #619 on:** February 15, 2008, 06:37 PM »

BTW Version 0.9.22 is out

Armando · « **Reply #620 on:** February 15, 2008, 11:55 PM »

Downloaded it, installed it : wonderful.
I tried to create a new thread at http://www.sqlnotes....abid/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.

Armando · « **Reply #621 on:** February 15, 2008, 11:57 PM »

After that, my transition to SQLNotes will pretty much be finalized.
-superboyac (February 15, 2008, 06:35 PM)

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.

Armando · « **Reply #622 on:** February 16, 2008, 12:00 AM »

sent it to Support@ - before I make it unintelligible !!
-tomos (February 15, 2008, 01:11 PM)

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

Inspiration...

Armando · « **Reply #623 on:** February 16, 2008, 12:27 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.

tomos · « **Reply #624 on:** February 16, 2008, 09:14 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...
Inspiration...
-Armando (February 16, 2008, 12:00 AM)

eh

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)