topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • Thursday December 5, 2024, 4:36 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 901309 times)

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #400 on: January 14, 2008, 03:57 PM »
[edit] After thinking about it, I could use the current item list as a datasource. I'll see how this could work [/edit]
Ah!  I see.  OK, if I am interpreting that correctly, you are working on how to do that and you will tell me later.  Great, I'll wait for it.  Thanks.

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 #401 on: January 14, 2008, 04:01 PM »
Correct

You see, it would be easy just to change to that mode. However, I can see cases where one would want it linked to the grid data source, so I need to support both (so need to add some UI for it)
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 #402 on: January 14, 2008, 06:15 PM »
I'm having some bugs with the html pane.  The problem with the enter key is still happening.  Also, I just entered something in the html pane, and the pane kind of froze, and the same content appeared when I clicked to other items.  Finally, I clicked to another grid and it went away.  Then, I came back to what I typed in the html pane before, and it wasn't there anymore.

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 #403 on: January 14, 2008, 07:24 PM »
I'm having some bugs with the html pane.  The problem with the enter key is still happening.  Also, I just entered something in the html pane, and the pane kind of froze, and the same content appeared when I clicked to other items.  Finally, I clicked to another grid and it went away.  Then, I came back to what I typed in the html pane before, and it wasn't there anymore.
Enter key: see https://www.donation...32.msg95964#msg95964
Lost content: I'll keep an eye open for it. If you can reproduce it, forward the info to me.
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 #404 on: January 14, 2008, 09:34 PM »
Then, I came back to what I typed in the html pane before, and it wasn't there anymore.

Did you try a quick search? (Ctrl + Q)
Or a normal one ? (Ctrl + F)
If it's still there somewhere, it should show up...

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 #405 on: January 14, 2008, 11:33 PM »
@Armando:
Using MSWord as the HTML Editor is an excellent idea. :Thmbsup: Making a full featured editor is a big job which I'd like to postpone if I can. Preliminary test seem good. I can create a word document in a window and load text into it. Menus are OK too. Main thing left to fix: docked toolbars do not show.
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,964
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #406 on: January 15, 2008, 05:13 AM »
@Armando:
Using MSWord as the HTML Editor is an excellent idea. :Thmbsup: Making a full featured editor is a big job which I'd like to postpone if I can. Preliminary test seem good. I can create a word document in a window and load text into it. Menus are OK too. Main thing left to fix: docked toolbars do not show.

would that mean we need to have MS office :tellme:
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 #407 on: January 15, 2008, 07:58 AM »
User option: use built-in or use MS Word
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,964
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #408 on: January 15, 2008, 12:03 PM »
is there a daily build there at the mo Pierre? it's not available here at any rate ...
I'm still with version 0.9.21 Beta 01 was hoping to try out some new stuff  :)
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 #409 on: January 15, 2008, 12:23 PM »
The daily build is always available here:
http://public.sqlnot...t/download/sqlnotes/
Last one is dated jan 12th 2008

[edit]
Current build has only 1 major bug: If a grid contains more than 20 columns or so, it will not open. If users experience this problem, please report it to me. This is fixed in the one to come this week  :P

There are few minor bugs, of course. A bug-tracker system is being put in place with the following twist:
  • Users will be able to use SQLNotes to sync with the bug-tracker and see bug list/status right in SQLNotes !  8) :Thmbsup:
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: January 15, 2008, 12:36 PM by PPLandry »

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,964
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #410 on: January 15, 2008, 12:26 PM »
The daily build is always available here:
http://public.sqlnot...t/download/sqlnotes/
Last one is dated jan 12th 2008

A new one is coming this week  :P
thanks. not sure how I missed that :-\  havent gotten it in a while I guess
Tom

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,964
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #411 on: January 15, 2008, 01:08 PM »
Attention all... I created a Wikipedia page to explain what SQLNotes is. The page is not very different from pages of numerous other software.

However for some reason (I know very little about Wikipedia rules/regulations), it has been marked as proposed for deletions in 3 days. One reason given is that only one person contributed... hence the appeal to all to add to the page. Thanks.

http://en.wikipedia.org/wiki/Sqlnotes

p.s. grap a reference of what you write (and put it ironically into SQLNotes if you wish) in case the deletion is eventually done.

just had a look here,
they seem to be looking for references from other "reliable third party" source
odd in this context - why dont they just download the software to see if it exists !!
Tom

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,964
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #412 on: January 15, 2008, 01:20 PM »
As part of the GTD implementation, new quick Add Item form is now available. CTRL-N to open it. A system-wide shortcut is also available to open it from anywhere (CTRL-ALT-N): (see attachment in previous post)You can enter item text, decide into which folder to put it in (normally, the inbox) and put a due date if required

Plus... now you can show/hide an HTML box. SQLNotes can now much more easily be used as a web-clipping tool:

  • browse to a web page
  • Select some text
  • copy (right-click or CTRL-C)
  • CTRL-ALT-N (will open the above form)
  • paste (right-click or CTRL-V)
  • click Add Item (or Alt-A). An item has been created with your clipping, put in the inbox, ready for you to file it appropriately later-on
  • focus is then restored to the browser (or whereever you were before hitting the hot-key.

ehh, it works nicely ... but how do we bring up the inbox?
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 #413 on: January 15, 2008, 01:24 PM »
It's one of the grids. If not, create a new grid and name it Inbox (or select from the list when creating)
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: January 15, 2008, 01:33 PM by PPLandry »

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,964
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #414 on: January 15, 2008, 02:01 PM »
It's one of the grids. If not, create a new grid and name it Inbox (or select from the list when creating)

yeah, I created a grid called inbox and there they all were :-*
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 #415 on: January 15, 2008, 02:09 PM »
That's because when creating a new grid, if the grid name corresponds to the name of an existing field, SQLNotes automatically sets the grid source to that field.

But don't forget, data and UI are separate things in SQLNotes.

So if you delete the Inbox grid, the inbox data still exist. And the inbox data can be displayed in more than 1 grid. You could for example decide to show the inbox items along with other items in the ToDos grid (add " OR Inbox" to the source and perhaps to the filter)

I hope that this is clear as mud (or as slushy winter streets)  :-[
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,964
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #416 on: January 15, 2008, 04:12 PM »
the inbox data can be displayed in more than 1 grid. You could for example decide to show the inbox items along with other items in the ToDos grid (add " OR Inbox" to the source and perhaps to the filter)

I hope that this is clear as mud (or as slushy winter streets)  :-[

ehh, I'm learning about SQL since trying to implement this (showing inbox in a different grid) but havent been sucessful so far, the filter bar has disappeared (since adding the daily release I think) I can only find date filter in menu..
added "or inbox" to source (of ToDo Grid), no difference,
added column called inbox but that just shows as tick-box after current entries

Got it I think - show Source bar. hmmm
filter says:-
FollowUp or ((( ToDo < now + 15 ) and due is null ) or urgency >= -7 or (due-now<6)) and ( done is null  or int(now) - done < 5)
can I add it there somehow?
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 #417 on: January 15, 2008, 04:14 PM »
put it at the beginning Inbox OR FollowUp ...
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,964
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #418 on: January 15, 2008, 04:18 PM »
put it at the beginning Inbox OR FollowUp ...
:Thmbsup:
could you though introduce them as sub-items to they same grid?
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 #419 on: January 15, 2008, 04:21 PM »
put it at the beginning Inbox OR FollowUp ...
:Thmbsup:
could you though introduce them as sub-items to they same grid?

If you talking about inbox items, they are created without any parent assignment. No parents -> not a sub-item. If you assign parents to them, then yes.
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,964
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #420 on: January 15, 2008, 04:22 PM »
and how would I temporarily change filter to show done items as well
Figured that - just remove the "and ( done is null  or int(now) - done < 5)" from the end..

EDIT overlapped your reply there, thanks
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 #421 on: January 15, 2008, 04:23 PM »
or toggle the filter (left of the filter edit box)
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 #422 on: January 15, 2008, 04:31 PM »
Does the Excel export work yet?  I've tried it but it's not working for me.  Part of the problem may be that I don't have administrator access to my program files directory, so whatever file it's trying to create may be being prevented.

Also, as far as printing, is there a way to be more selective in the printing?  Like, I would like to print only selected items of a grid (with/without children items), along with their html panes.

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 #423 on: January 15, 2008, 04:37 PM »
Does the Excel export work yet?  I've tried it but it's not working for me.  Part of the problem may be that I don't have administrator access to my program files directory, so whatever file it's trying to create may be being prevented.

Also, as far as printing, is there a way to be more selective in the printing?  Like, I would like to print only selected items of a grid (with/without children items), along with their html panes.

1- Export to Excel works fine here. Writes to the same folder as the database, name=gridname.xls. We can examine why it doesn't work for you.
2- To print with the HTML pane info, best is to do a template based HTML export. See this link:
http://sqlnotes.wikispaces.com/Invoices
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,964
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #424 on: January 15, 2008, 04:46 PM »
I've screwed things up :D

discovered the sort bar, dragged two columns in there to sort by (inbox and..?)
then I (without thinking) right clicked these (in sort bar) and clicked hide columns & cant get them to show

ahhh, if I right click a column heading, select "displayed columns" I can choose them there
(BTW while that dialogue box is open the programme doesnt show in Alt-Tab)

I was making the mistake of selecting Manage Fields from same to try show columns  :-[

or toggle the filter (left of the filter edit box)
  :(
when I do that I loose all the sub-items (of the only item with sub-items) and when I click it again
they dont comeback (tried F5) ...
Tom