Recent Posts
Ok, I have got past the initial fear and I too am impressed.Thanks! While it can, SQLNotes is much more than to manage tasks. It is a flexible database and as such can handle all sorts of information management.
Suggested alternative names
- TaskSheets
Brett-brett (November 03, 2007, 04:20 PM)
but the MSSQL database was installed as a service and is running all the time. This occasionally causes some burps in that PC's system.You know how to prevent SQLServer from starting automatically at startup don't you? Admin>Services, ...
It doesn't work when I double click on the first column (and there is no item number in the column when the item consists of a linked documents.)Fixed. Clicking on the number column now works even if empty (it should not be empty, that is a long-standing bug that I need to fix. F5 to refresh and you'll get the number)-Armando (November 02, 2007, 02:36 PM)
A good place to double-click is on the first column, the item numberbump-PPLandry (November 02, 2007, 02:28 PM)
Signed in and tried to download sqlnotes, but all I get is You Do Not Have Permission To View The Requested FileIf you are still having problems, I can send it to you by email.-Dormouse (November 02, 2007, 01:06 PM)
I don't have to install am SQL database app or server? Are you sure it isn't included in the setup for SQL Notes?SQL in the name refers to the powerful search/filter that is built-in SQLNotes. The back-end database could be anything. Currrently use JET because it is installed on every PC and it does the job. Plus Office apps can readily link to SQLNotes data without installing a separate ODBC link. (Each grid in SN is visible to any ODBC enabled app -- Word for mail-merge, e-mail-merge, Excel, Access, etc) It is therefore easy to share SN data with users that don't have it.-J-Mac (November 01, 2007, 02:30 AM)
So how do you see people using SQLNotes in cunjunction with Outlook (or even thunderbird, the bat !) email feature? Drag and Drop possibilities (to the calendars or todo lists)? Or more officially implement the solution you offered to the customer your refered to?... Just wondering.I've postponed this to much later since I've got more urgent matters (d'autres chats à foutter pour l'instant).
Is there a way (potentially) to automatically "colorcode" or format items depending on the content (item name, etc.)?Yes you could use color coding based on file extension. A simple user-defined function would do it and it would be automatic. Use the FileName field which is automatically filled in on drag-drop.-Armando (October 31, 2007, 10:39 PM)
I share the same point of view : I don't like to store files (different file types) in one database. I've always disliked it, for many reasons.Glad to see we're on the same wavelength. Plus file management becomes more difficult. Your hard disk IS a database with a UI fine-tuned to effectively manage files. To replicate this in another program is redundant. Not much is gained by having the file inside the database. Many tools can be used to effectively manage your files (i.e. I personally like synctoy for worry-free backups on external HD). All this is only my opinion of course. I'm interested in hearing other views ...
Sadly, one thing that I find is missing from all database I've tried, is a file tracking system to track finame changes, file moving, etc. when they're only linked to the database and reside outside of itSurely one could tap into an Windows event or message to update the database. Shortcuts are now automatically updated when a file is moved, so it is feasible. I'll look into it!
Of course, one doesn't need that eature if the files are completely transfered inside the databaseI could certainly store files in the database, but am relunctant to do it. If someone gives a good reason to do it perhaps...
some big jobs I try keep track of the drawings in tables (*.doc file again) or spreadsheets -You could drag-drop those file in a grid to create a link (double-click to launch) and then fill fields with relevant values add notes (in a note field, as a sub-item or in the HTML pane, it's your choice). Link that with your project or with individuals.
eg. Figure#123: based on working drawing#ABC, modification requests, outstanding work, final approval given, etc.
I work on my own, selfemployed, but very few clientsThat is exactly what I do. I have an agenda where I enter the work I do (start, duration or end) project. If you get paid by the hour, then billing is easy. The pivot table (or select durations and right-click>info) will give you the hours to bill.
The problem for me is that there's no calendar right now (and no gantt charts). But according to Pierre, there will be!It's coming. But it is a complicated task to do it right. And things are changing quickly in that area due to on-line calendar (aka Google, Airset, Zoho, etc). The SN needs to have live links to Outlook for the people at work and with web calendars for calendar sharing (you, your wife, friends, kids, etc)
Creating a new grid is not very intuitive right now : you have to go in View —> Manage grids and in the list of grids, click and write in the “New view” space.This is fixed in the next version. Plus I was using a split button. Neat feature but not well known, so I changed for a more conventional menu item.
But I'd also probably store notes and various data into it, and use it as a general database (something I don't do with Outlook), and I'd manage more complex projectsYou described it pretty well. At the basis, you have an Ecco framework. Folders (fields in SN) you open them by double-clicking on them in the properties pane. And you can start putting information in that folder. The grid and forms are the basic entry.
The only thing I probably wouldn't do with it is… manage emails… it doesn't seem to be a very “developed” feature. But maybe am I mistaken?No you are not mistaken. SN is already a massive project and the general philosophy is to complement Office, not go head on. For a customer however (CRM app), I added an interface with Outlook to import e-mail into SN along with a semi-automated e-mail reply mecanism. Statistics were updated (# of calls, emails, etc) so managers could see monthly reports of activity.
@tomos: Yes, I had looked at SQLNotes already and I don't think that will do it for me. Thanks!I'm the author of SQLNotes and before being a PIM (which is it is not quite yet), it IS a flexible, simple to use database. From what you described, it should be a prefect match. Perhaps I can help in setting it up.
is this software gonna be shareware when beta end?As in try before you buy? Yes, the planned distribution is twofold:-Kuntau (October 27, 2007, 06:43 PM)
