Author Topic: SQLNotes...what is it exactly? (Read 1,173,506 times)

PPLandry · « **Reply #475 on:** January 21, 2008, 09:36 PM »

Quote from: superboyac on January 17, 2008, 06:38 AM

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

PPLandry · « **Reply #476 on:** January 23, 2008, 04:52 AM »

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.sqlnotes.net/download/SQLNotes/other/ItemsWithHTMLPaneExample.htm
Version 0.9.21 + daily build.

Armando · « **Reply #477 on:** January 23, 2008, 06:06 AM »

Very nice

Darwin · « **Reply #478 on:** January 23, 2008, 06:19 AM »

Wow, Pierre!

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 · « **Reply #479 on:** January 23, 2008, 09:32 PM »

This feature was expanded with more options. Also FF bug on expand/collapse was fixed.

Darwin · « **Reply #480 on:** January 23, 2008, 09: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

PPLandry · « **Reply #481 on:** January 23, 2008, 09:53 PM »

If you would jump in and use it to put all your information, you would have used the jan22nd version

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)

Darwin · « **Reply #482 on:** January 23, 2008, 10:03 PM »

Quote from: PPLandry on January 23, 2008, 09:53 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 · « **Reply #483 on:** January 23, 2008, 11: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 · « **Reply #484 on:** January 23, 2008, 11: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).

Armando · « **Reply #485 on:** January 23, 2008, 11:44 PM »

I was just asking... curiosity.

Integrated email merge... That should be interesting and useful.

tomos · « **Reply #486 on:** January 25, 2008, 01:33 PM »

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?

PPLandry · « **Reply #487 on:** January 25, 2008, 10:21 PM »

I've isolated the "blank pane" bug (occured when opening a collapsed pane). Daily build updated.

Armando · « **Reply #488 on:** January 26, 2008, 03:48 AM »

nice!

PPLandry · « **Reply #489 on:** January 28, 2008, 02:48 AM »

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.

David1904 · « **Reply #490 on:** January 28, 2008, 08: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

David1904 · « **Reply #491 on:** January 28, 2008, 08: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 · « **Reply #492 on:** January 28, 2008, 02:32 PM »

Quote from: David1904 on January 28, 2008, 08:06 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)

PPLandry · « **Reply #493 on:** January 28, 2008, 02:34 PM »

Quote from: David1904 on January 28, 2008, 08:30 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 ?

tomos · « **Reply #494 on:** January 28, 2008, 02:36 PM »

Quote from: tomos on January 25, 2008, 01:33 PM

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

PPLandry · « **Reply #495 on:** January 28, 2008, 02:40 PM »

Quote from: tomos on January 28, 2008, 02:36 PM

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@...

PPLandry · « **Reply #496 on:** January 28, 2008, 05:49 PM »

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

David1904 · « **Reply #497 on:** January 29, 2008, 12:09 AM »

Quote from: PPLandry on January 28, 2008, 02:34 PM

Quote from: David1904 on January 28, 2008, 08:30 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 ?

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 · « **Reply #498 on:** January 29, 2008, 01:38 AM »

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.

superboyac · « **Reply #499 on:** January 29, 2008, 04:45 AM »

I think I am going to have to write a song about SQLNotes.