Recent Posts

401

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on February 06, 2008, 03:24 PM »

Nice!

I'm getting the following error when I try to connect to the mantis database: (see attachment in previous post)I have a firewall at work, I don't know if that's the problem.  I have internet access, but sometimes stuff like this gets blocked.  For example, I can't use irc.


Also, as far as the pivot table added functionality, when it reads items arranged in a hierarchy, it only seems to read down two sublevels.  So, my items that are in sublevels beyond that won't be read.  Take my transcript grid for example:

Degree program
--Year
----Semester
------Class

It will stop reading at Semester, so the classes won't appear.

-superboyac (February 06, 2008, 12:02 PM)

The mySQL driver uses port 3306 by default. You can change that in the ODBC setting. It may be blocked. You can try another port, though, I'm no expert on ports

As for the pivot, it works fine here, you may need to right-click on a blank area and do "refresh data" (make sure that when you right-click, you get a context menu with just 2 items. If you get more, you've right-clicked in the wrong place. I need to fix that)

402

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on February 06, 2008, 12:03 AM »

See Issue 38 details (here: http://mantis.sqlnotes.net)

403

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on February 05, 2008, 11:55 PM »

@superboyac and Armando:

The following 2 3 issues are now fixed
1- CPU utilisation is now 0 when idle
2- Pivot table/chart are now based on the grid displayed items
3- Item grouping improvements

404

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on February 04, 2008, 07:10 PM »

bug tracking is here: http://mantis.sqlnot...s.net/login_page.php

-PPLandry (January 28, 2008, 11:53 PM)

It was promised, here it is. It is now possible to feed into SQLNotes the feature request/bug tracking data entered into Mantis. With a click of a button, SQLNotes will connect to the mySQL database and obtain all changes to the issues. Steps are:

   1. Download and install the mySQL ODBC driver (version 3.51)
   2. Download the solution zip file from the download area: http://www.sqlnotes....abid/61/Default.aspx [edit] You need to also install the latest build! [/edit]
   3. Copy both the .SNDB and the sync XML file to the same folder
   4. Open the file.
   5. To read-in updates, do Tool>Database management>Sync with external databases (you can customize the toolbar (right-click->customize) to add it to a toolbar)

The Mantis web UI is nice, but SQLNotes is so much nicer and faster to use!

p.s. This feature will be enhanced to be able to sync with more than one database, to sync with data coming from web services, etc. So see this as a first step.

[edit] You can still make changes to the SQLNotes file, add your own notes to issues, even add sub-items and parents (to group them). Your structure and extra info will be preserved on updates [/edit]

405

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on January 30, 2008, 10:49 PM »

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.

-David1904 (January 28, 2008, 06:09 PM)

Would such a setup be a good solution ?
1- Families/members are entered in the AddressBook grid. A flag is used to identify that an entry is a family (not a person)
2- Events are created in the Events grid.
3- To record presence, drag-drop individuals/families from the AddressBook grid to that event in the Events grid (or tag them and add tagged items as subs)

You'll get this:


Currently, the analysis, pivot table/chart, would need to be done using Access. But this would be an interesting addition to be able to analyse such a structure directly in SQLNotes.

The only way to be able to analyse in SQLNotes, would be to create a field for each event. If this is suitable, then I can propose a different solution.

406

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on January 30, 2008, 08:49 PM »

Just a reminder that I'm waiting for the import features (the texnotes one I mentioned earlier, and the import/export grids between files).  I don't mean to rush, I've just put my involvement on hold because I haven't been able to transfer my data into the program.  As soon as it's possible, everything I have is going inside SQLNotes.

-superboyac (January 30, 2008, 06:49 PM)

I haven't forgotten... I've been busy setting-up the bug tracking web site (you can input all your desired features in it if you want) and with some other consulting work.

407

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on January 30, 2008, 05:19 PM »

No problem. I'll work on this today and keep you posted. If you want send what you have to betasupport@sql...

408

Developer's Corner / Microsoft Sync Framework

« Last post by PPLandry on January 29, 2008, 12:43 AM »

Hello everyone,

I'm the developper of SQLNotes (www.sqlnotes.net), an Ecco-like, URp-like information organizer. Part of modern applications is syncing with:
1- other apps (Outlook, Google, etc)
2- replicas from co-workers
3- off-line replicas with on-line master

Microsoft recently released the Microsoft Sync Framework: http://msdn2.microso...us/sync/default.aspx

This seems quite powerful. Any of you have experience using it, or have read positive/negative reviews?

Thanks

409

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on January 28, 2008, 11:53 PM »

oooohhhh... Really nice!!! Thanks Pierre! 
(And I can't wait for the "Outlook like" calendar feature  )

-Armando (January 28, 2008, 11:49 PM)

Check out this thread regarding the new bug tracking software. You'll see the calendar in the Roadmap...
All users are welcome to post suggestions/bugs, etc:
http://www.sqlnotes....e/posts/Default.aspx

bug tracking is here: http://mantis.sqlnot...s.net/login_page.php

410

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on January 28, 2008, 11:27 PM »

As per superboyac suggestion, I can now choose to base the pivot table/chart on the grid source (as before) OR on the displayed items (as suggested). The latter is more "user-friendly".

I'll finalize it tomorrow and publish an updated built with this new feature. right-click on the pivot to toggle mode.

p.s. The difference is due to the outlining features of SQLNotes. What is displayed in the grid is what meets the grid criteria PLUS all items which were expanded. This is often very different and is causing confusion. Perhaps superboyac can explain it better (from a user's perspective)

411

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on January 28, 2008, 10:46 PM »

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

-superboyac (January 28, 2008, 10:45 PM)

I better change the name real quick then

412

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry 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.

413

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry 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

414

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on January 28, 2008, 08:40 AM »

bump -
still happening with daily build from 26th Jan

-tomos (January 28, 2008, 08:36 AM)

Can you send the file, functionlog.txt and if possible the steps to reproduce it ? betasupport@...

415

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry 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)

-David1904 (January 28, 2008, 02:30 AM)

Could you provide an example ?

416

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry 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.

-David1904 (January 28, 2008, 02:06 AM)

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)

417

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry 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.

418

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on January 25, 2008, 04:21 PM »

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

419

General Software Discussion / Re: Inventory Software

« Last post by PPLandry on January 23, 2008, 09:59 PM »

The file was not included in the message, so you can send me the file directly.

420

General Software Discussion / Re: Inventory Software

« Last post by PPLandry on January 23, 2008, 09:33 PM »

Nothing is hard-coded in SQLNotes, so yes, you'll be able to change everything!

I just wanted to get an idea of your inventory requirements:
- Item name
- Item identifier (from bar code ?)
- Qty
- Approx. value or cost (gross, net)
- Location (i.e. room)
- Category
- Comments

It takes about 10 minutes to set it up

421

General Software Discussion / Re: Inventory Software

« Last post by PPLandry on January 23, 2008, 06:33 PM »

Wow, thanks alot!  I cannot wait until I get back in the office on Friday.

-techidave (January 23, 2008, 06:13 PM)

If you want, list the information that you want to record and any other pertinent information. That will help me in creating the template.

422

General Software Discussion / Re: Inventory Software

« Last post by PPLandry on January 23, 2008, 05:51 PM »

I guess I will give the SQLNotes a whirl and see if it is "user friendly".

-techidave (January 23, 2008, 05:45 PM)

I'll update the SQLNotes default template to include an inventory setup for you. Today or tomorrow.

423

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry 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).

424

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry 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  

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)

425

General Software Discussion / SQLNotes: the next generation information organizer

« Last post by PPLandry on January 23, 2008, 03:32 PM »

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