topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • Friday March 29, 2024, 8:28 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 834491 times)

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #475 on: January 21, 2008, 03:36 PM »
Have fun Pierre, you deserve a break!

I can't help it, here are some topics for you when you get back:
What is the Scratch Pad for and does it function any differently from any other grid?
What is the timeframe for adding the import feature which will allow me to import grids from other SQLNotes databases into the current one.  I have some grids I work on at work, and I have some I work on at home.  Eventually, I'd like to combine them.
Thanks!

ScratchPad: Armando described it perfectly
Import: this week
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: February 07, 2008, 08:49 AM by PPLandry »

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #476 on: January 22, 2008, 10:52 PM »
Just a heads-up regarding a feature request by a number of users: Items with HTML Pane Export

  • Can now select to export the HTML pane content with the items (when using Export with settings).
  • Option to append a (...) at the end of the tree-column (normally the items column) to allow for expand/collapse of the HTML content.
  • Per level Item font size and HTML prefix added (to bold, italic, etc. items).

Example available here (taken from the Welcome grid of the default template): http://www.public.sq...hHTMLPaneExample.htm
Version 0.9.21 + daily build.
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: February 07, 2008, 08:49 AM by PPLandry »

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #477 on: January 23, 2008, 12:06 AM »
Very nice  :up:

Darwin

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,984
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #478 on: January 23, 2008, 12:19 AM »
Wow, Pierre!  :Thmbsup:

I'm really struggling to keep up here! I'm amazed at how far SQLNotes (don't change the name for me, I like it!) has come in such a short time. Every build brings little tweaks and additions that enhance the whole. Very impressed.

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #479 on: January 23, 2008, 03:32 PM »
This feature was expanded with more options. Also FF bug on expand/collapse was fixed.
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: February 07, 2008, 08:49 AM by PPLandry »

Darwin

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,984
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #480 on: January 23, 2008, 03:46 PM »
See! This illustrates my point - I updated to the January 22 build and it's been superseded... Yet I hadn't even had a chance to take it for a spin. Let's hope for better luck with today's build  :o

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #481 on: January 23, 2008, 03:53 PM »
If you would jump in and use it to put all your information, you would have used the jan22nd version   :harhar:

Sorry for making improvements. It is my main/only information management tool, so when I require some new feature, I code it. This new feature was coded to create a testimonial page from SQLNotes users (will be published when I get required consentments)

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: February 07, 2008, 08:50 AM by PPLandry »

Darwin

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,984
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #482 on: January 23, 2008, 04:03 PM »
Sorry for making improvements. It is my main/only information management tool, so when I require some new feature, I code it. This new feature was coded to create a testimonial page from SQLNotes users (will be published when I get required consentments)

No need to apologise! It's awesome - I'm just a bit breathless from trying to keep up. Note to self: make a concerted effort to dabble in SQLNotes this week.

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #483 on: January 23, 2008, 05:25 PM »
Pierre, this is fantastic. It's also very stimulating to see a programmer working so fast, adapting his work to users needs etc.
BTW, how's the MS Word integration process going ? And did you find some of my other suggestions valuable? (I'm talking about the various suggestions I made earlier in my crazy long posts : "dock" the image viewer like other panes, be able to set and save different views for the same Grid, adding the “Customize (hotkeys)” option to the “tools” menu, “refreshing rate” of the UI, etc.)

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #484 on: January 23, 2008, 05:35 PM »
Hi Armando,
I've been busy with other stuff in the last few days (non-SQLNotes consulting).

You had great suggestions and have put them on my priority list. I'm now adding small features that I've postponed but happen to need right now. Next one on the list is integrated email-merge (can use Word/Outlook with SQLNotes but it takes too long to use).
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: January 28, 2008, 12:19 PM by PPLandry »

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #485 on: January 23, 2008, 05:44 PM »
I was just asking... curiosity.  :)
Integrated email merge... That should be interesting and useful.

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #486 on: January 25, 2008, 07:33 AM »
I'm not sure what's going on here...
in html pane: simply typing, out of the blue I get

---------------------------
SQLNotes
---------------------------
Run-time error '3704':

Operation is not allowed when the object is closed.
---------------------------
OK   
---------------------------
had this twice in the last two days - with different builds
any ideas?
Tom

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #487 on: January 25, 2008, 04:21 PM »
I've isolated the "blank pane" bug (occured when opening a collapsed pane). Daily build updated.
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: January 28, 2008, 12:19 PM by PPLandry »

Armando

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 2,727
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #488 on: January 25, 2008, 09:48 PM »
nice!  :)

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #489 on: January 27, 2008, 08:48 PM »
Just a heads up... I'm finishing up the Email merge and will then release the next version (0.9.22). I'll immediately concentrate on the much overdue Outlook-style Calendar view.
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz

David1904

  • Supporting Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 43
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #490 on: January 28, 2008, 02:06 AM »
Pierre,

I created a new field called attendance date and put yesterdays date in it - about a dozen entries. Previously I had created a grid with a Date field in it with two entries having a date about 2 weeks earlier.
I deleted that column from showing in the grid, so the only field/column showing with a date in it is Attendance date.
However, when I try and create a pivottable, it insists on finding the old deleted dates (as well as the new ones) whenever I put Date into the pivot table - there is no Attendance date field showing in the field pick list.
Can you help me out here - I can't seem to find anything addressing this in the wiki etc.

Thanks,

David 8)

David1904

  • Supporting Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 43
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #491 on: January 28, 2008, 02:30 AM »
Sorry Pierre,

When I put the original Date field back I realised I had not deleted all the dates out of that column.
Closing and then re opening seemed to allow the Attendance date to show in the field pick list this time (didn't seem to on earlier attempts)
Is it possible to have hierachies/sub items within dates AND within some text grouping at the same time (ie thinking of the basketball scoring - can there be groups of players as well as groups of dates)
Thanks,

David

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #492 on: January 28, 2008, 08:32 AM »
However, when I try and create a pivottable, it insists on finding the old deleted dates (as well as the new ones) whenever I put Date into the pivot table - there is no Attendance date field showing in the field pick list.
Can you help me out here - I can't seem to find anything addressing this in the wiki etc.
Keep in mind that grids are just views of your data. Removing a column from a grid does not delete the column data. It just removes it so you don't see it (this is not Excel!)
To delete some data, you can
  • select the dates (in this case) and press the delete key
  • Delete the field (View>Manage Fields)
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: January 28, 2008, 12:18 PM by PPLandry »

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #493 on: January 28, 2008, 08:34 AM »
Is it possible to have hierachies/sub items within dates AND within some text grouping at the same time (ie thinking of the basketball scoring - can there be groups of players as well as groups of dates)
Could you provide an example ?
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: January 28, 2008, 12:18 PM by PPLandry »

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #494 on: January 28, 2008, 08:36 AM »
I'm not sure what's going on here...
in html pane: simply typing, out of the blue I get

---------------------------
SQLNotes
---------------------------
Run-time error '3704':

Operation is not allowed when the object is closed.
---------------------------
OK   
---------------------------
had this twice in the last two days - with different builds
any ideas?

bump -
still happening with daily build from 26th Jan
Tom

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #495 on: January 28, 2008, 08:40 AM »
bump -
still happening with daily build from 26th Jan
Can you send the file, functionlog.txt and if possible the steps to reproduce it ? betasupport@...
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: January 28, 2008, 12:18 PM by PPLandry »

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #496 on: January 28, 2008, 11:49 AM »
Thanks Tomos for pin-pointing the bug. It is now fixed in the daily build.

To reproduce the bug:
in html window,
press return button and start typing on the second line
Type the double quote symbol i.e. ["] without brackets of course!
then type any word
then press space bar

This is due to an yet-to-be-released wiki-style hyperlinks feature in the HTML pane. Will soon release this feature.
The wiki-style links will work in one of 2 ways
  • 1- enter [ID lists] will create a hyperlink. Click on the hyperlink and those items will be displayed
  • 2- enter [a wiki tag] will create a hyperlink. Click on the hyperlink and all items with that wiki tag will be displayed
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: January 28, 2008, 12:18 PM by PPLandry »

David1904

  • Supporting Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 43
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #497 on: January 28, 2008, 06:09 PM »
Is it possible to have hierachies/sub items within dates AND within some text grouping at the same time (ie thinking of the basketball scoring - can there be groups of players as well as groups of dates)
Could you provide an example ?

Yes, where you have a situation of families attending a regular event and you want to be able to record both the presence of family units at one or more events and also individual presence at one or more events (when sometimes only some family members are present). It would be be good to be able to produce a pivot table/chart showing attendance by family and/or individual on a per week/month/year basis. A further refinement is where individuals might also belong to one of three or four age brackets and you want to analyse attendance by either family representation, or perhaps individual participation, within those age brackets.

Thanks,

David


PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
SQLNotes: the next generation information organizer
« Reply #498 on: January 28, 2008, 07:38 PM »
There are a number of ways to do this, each with advantages and disadvantages. The first way that comes to mind is to:
1- In the "AddressBook" grid, create families and members as sub-items. Add pertinent information (age group, etc)
2- In an "Events" grid, create events with all pertinent information (date, location, etc)
3- To link the two, select participants (families or individual persons) and add them as sub-items of the event (tag the items and add tagged items as subs). More details if desired.
Visually, it will work quite well.
As for the pivot table analysis, a proposed modification (by superboyac) will allow the pivot table to compile statistics for such a grid (the current pivot cannot since the source is not well defined).

I can build such a solution if you wish. Approx time: 10-15 min.
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: February 07, 2008, 08:50 AM by PPLandry »

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: SQLNotes...what is it exactly?
« Reply #499 on: January 28, 2008, 10:45 PM »
I think I am going to have to write a song about SQLNotes.