Version 0.9.23 is finally out.

Major new features are:

• Gantt charts for project managements
• External HTML editor support with full support for embedded images (i.e. Word 2002 and up or BlockNote)
• Filter improvements (for tomos  )

Download here: http://www.sqlnotes.net/Download/tabid/61/Default.aspx
Details here: http://mantis.sqlnotes.net/changelog_page.php

[attachthumb=#]

Enjoy!

are images supported in regular html export ?  (is it that you can export as mht file?)
or does one need "Word 2002 and up or BlockNote" for that

1- Web images can be exported in HTML export for regular HTML files (like all web pages, nothing new here)
2- For MHT files, you can embed images and these will export. MHT (email format) is just about as feature rich as DOC. Note that in HTML export, the MHT document height cannot be determined, so a new field (ItemHTMLHeight) allows you to specify the height to allocate for the MHT document.
3- For MHT files, you need an external MHT editor

Gantt charts!!  That is so awesome.

It has been promised a long time ago, so I'm very happy to finally deliver it.

OK, I was trying out the Gantt charts.  I got a couple of errors when I tried to create the default configuration (using the Gantt wizard that pops up).  I used the default button, but my columns did not get added automatically (I don't know if they were supposed to).  Also, that top bar that shows the overall schedule (in your screenshot above) didn't show on mine.  Also, how do we edit and change the details of each item in the Gantt chart?

No columns are not added to the grid (perhaps I can add an option). Editing can be done completely with the Gantt, so they are not required. Simply drag-drop from the properties pane if you want them.
The overall schedule display is an option: Grid>Properties>Gantt>Overview visible
Editing is done by drag-drop or field editing (grid, properties pane). To change the %Complete, position your cursor until you see a % icon.

Feature request:
Since this program is now getting more modules and capabilities, I think it might be important to have layout control per each grid.  For example, in a grid with a Gantt chart, I'll probably want to dock my notes on the bottom instead of the side, so the chart will have more room.  But in other grids, I want the notes on the side.  Instead of turning them on and off all the time, it would be highly useful to set a default layout for each grid.  Other similar situations involve grids with pivot tables.

Yes, this is a great idea. I too find it annoying to move panes around (less so with a second 20"monitor )

even if SQLNotes does not include as much functionality as MS Project (now or in the future), it's still great to have gantt charts. Its soooooo much easier to plan projects when you can actually see everything in a chart. IMO, MS Projects is way too overkill for most people, and there's one thing that always seemed akward to me : the poor Outlook task integration (I don't know about MS Project 2007 though). At least, SQLNotes will allow seamless  project/todos/taks/events/whatever integration. And that's very promising!

OK, thanks (I should probably add that to Mantis).

I'll experiment more with the Gantt charts later.  I'm sure you are aware, but by adding Gantt charts, there are a whole bunch of details in the way the schedules are setup.  Things like creating a work days vs total days schedule, dependancies, etc.  I'm not sure how much functionality your chart has vs something like MS Project.  How bold of you to even include it!

The Gantt capabilities, combined with SQLNotes engine will allow for some pretty nice project management. This is the first cut at it. Coming after off-line mode and calendar are:

1- Task links (start to finish, start to start, finish to finist, etc), drag-drop to create links
2- Multiple bars per task (i.e. optional display for summary tasks)
3- Workload graph: shows when your workload exceeds 100%
4- Text and icons in the Gantt
5- Customizable bars (colors, end shapes)
6- right-click context menu to edit/delete bars, links, etc
7- And many many options, such as user-defined non-working days, ...

For those that haven't seen it, the following features are planned:
http://www.sqlnotes.net/DonationInfo/tabid/74/Default.aspx

I've been wanting to try SQLNotes, as it looks great, but I can't justify the time to play with a new application with my current workload. However, I have a real need for a tool like this on one of my projects, so now, the time would be well spent.

I am going to grab the latest build and start spinning up on this.

that looks very creamy. Good job

Icons are coming soon to a Grid near you 
(see attachment in previous post)
Two types:

• Item icon, shown left of the item text. Can filter for a specific icon. Possibility to have it dynamically attributed (i.e. when a task is late, the icon automatically changes to a red exclamation mark, or when a number is negative, etc
• Within the item text. Place bitmaps anywhere in the cell.

Users will be able to add icons, simply by adding icon and bitmap files in icon specific folders

Version 0.9.23.2 is now available for download
...
Download it here

SQLNotes Installer version 0.9.23.2 7.19 MB 5/16/2008 16h00 EST. SQLNotes version 0.9.23.2 Installer. Please uninstall previous version.

[ just in case! ]

Version 0.9.23.3 is out! New version includes:

• 2nd version of Gantt charts with task dependancies. Visually create links between tasks using the mouse. Dependancies can be created without the Gantt charts, to only show you the next task to do (hide tasks done and those which depend on the current one)
• Properties pane: Show grids and forms where a field is displayed
• Auto item text based on entered HTML
• Some UI improvements
• Bug fixes

Details here: http://mantis.sqlnotes.net/changelog_page.php

Pierre -

I have been trying to reach you at the betasupport address that's on your website, but I'm getting a message that there's an SMTP problem with your server.  I am doing a presentation on personal information organizing software to a group of librarians in 2 weeks.  I would like to give them a peek and overview of SQL Notes, since so many people here like it.  However, I have questions for you, since I don't use it myself, and I need your explicit permission for a couple quotes I would like to use.  Is there another email address I can use?  I don't use Outlook Express - is that what's causing the problem?

Thanks, Pierre.  I've resent the email to support@sqlnotes.net.  Rather long and tedious for others here, I thought.

I'm so glad to hear you say that, Dormouse, because I can't get through to the other email address either - do you have something against Georgia Tech, Pierre? - so will have to post here, exposing my ignorance for all to see.  [Takes deep breath} So here goes.

Dear Pierre,

I was a contributor to the note-taking software discussion on donationcoder, and I have noticed also the thread on SQL Notes.  I am making a presentation on personal information/knowledge management software to a group of other librarians in Seattle in 2 weeks, and I wondered if I could get some screenshots from you to give them an idea of how they could use SQL Notes.

Librarians usually have not just the usual kinds of information (anything from contacts to client tracking), but also personal reference collections (web sites often) and downloaded reports, articles and papers, which can be anywhere from 2 pages to several hundred.

While I am demonstrating a few of the programs, I would like to just mention SQL Notes, since it is still in beta and I don't use it myself.  However, I would like to show them a screenshot of an example that includes a lot of text, since that is one of our particular needs.

To give you some context, I have divided organizers into several types.  Here’s the list with the programs I am going to mention:

Information Mappers: Personal Brain, Topicscape, Compendium
The Digital Reading Pile: Zotero, Surfulater
The Digital Junk Drawer: Evernote
Text-friendly databases: InfoSelect, SQL Notes

So, what I asking is

1. Do you have, and would you share with me so that I can use it for this presentation, screen shots of a database that contains large amounts of text (reports, for example)?  The screen shot would be used in the handout, which will be available online for the conference attendees – typically 5000+ people.  I don’t expect more than 50 to come to this session, but it will be available to everyone online.  I plan to use a Creative Commons license for my presentation, so that people will be able to re-use it, with attribution.  I could however put a standard copyright notice on your screenshots. 

2. To describe what SQL Notes does, may I use the following statement found in the discussion at http://www.donationcoder.com/forum/index.php?topic=10432.0?

“The ideal information management app must be an excellent outliner with multiple parents support (when required), an excellent linker (i.e. like the web), an excellent tagger, an excellent editor supporting rich text editing in the outline AND in a second rich text window, support flat and tree-structured display with or without a data grid, usable as a flexible database supporting user-defined fields, calculations (both equations and user-defined functions), reporting and an have excellent search engine. Finally, it needs to have a customizable UI, support drag-drop and have links to all other major apps. Idealy, it should be able to pull information from external sources as well.”

If I may use it, how should I attribute it? Pierre Landry, designer, SQL Notes, ??
Please let me know how you would like me to cite your name, relationship to SQL Notes, and some kind of contact information, such as an organization and city (Quebec, I believe?). 

Since mutual disclosure is only fair, I will say that I am a librarian at the Georgia Institute of Technology, and my name in that world is Elisabeth Shields.