topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Tuesday March 19, 2024, 1:16 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Last post Author Topic: SQLNotes...what is it exactly?  (Read 832109 times)

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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
Tom

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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
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)
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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.

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
Tom

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #603 on: February 15, 2008, 11:20 AM »
No rush.

You can make a copy and delete most (or all) items
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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)

second time today:
:Thmbsup: whooHoo!!! :-*

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

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #605 on: February 15, 2008, 12:01 PM »
only thing is I'm running out of colours :P

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: :D

(just added 85 files ..wooHoo.. :D)

[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]
Tom
« Last Edit: February 15, 2008, 12:07 PM by tomos »

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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.  :-[
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #607 on: February 15, 2008, 01:11 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
Tom

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #608 on: February 15, 2008, 01:14 PM »
how it looks here

SQLnotes09.pngSQLNotes...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]
Tom
« Last Edit: February 15, 2008, 01:17 PM by tomos »

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #609 on: February 15, 2008, 01:16 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.
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: February 15, 2008, 01:18 PM by PPLandry »

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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
Tom

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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
Sure, but you need to use user-code for that!  :D
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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
Sure, but you need to use user-code for that!  :D

oh-oh :huh:
Tom

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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
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
Tom
« Last Edit: February 15, 2008, 01:36 PM by tomos »

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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
Tom

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #616 on: February 15, 2008, 02:03 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 :-*
Tom

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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
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!)
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #619 on: February 15, 2008, 06:37 PM »
BTW Version 0.9.22 is out  8)
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #621 on: February 15, 2008, 11:57 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.

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #622 on: February 16, 2008, 12:00 AM »
sent it to Support@ - before I make it unintelligible !!

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

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,958
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« 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...
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:

SQLnotes12.png

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)
Tom
« Last Edit: February 16, 2008, 09:47 AM by tomos »