topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • Tuesday November 11, 2025, 2:49 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

Recent Posts

Pages: prev1 ... 18 19 20 21 22 [23] 24 25 26 27 28next
551
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 10, 2007, 01:27 PM »
Yes, the number column "should" always show the correct value. It does not currently. F5 to refresh it.
552
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 10, 2007, 12:36 PM »
Okay --> Pierre, I just saw your comment on the wiki page concerning live sync between SQLNotes and Outlook. So I guess I'll have to wait for that.
No, a proper Outlook import is also required. I'll check who's to blame (Outlook of SQLNotes) and find a solution.
553
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 10, 2007, 12:34 PM »
I think I found a bug:
In the Options, where it says "Create backup on program close", I keep changing it to "Yes" and it keeps going back to No.  That's why I didn't have backups saved that one time.  The setting doesn't stick.
This is now fixed in the daily build
554
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 10, 2007, 12:01 PM »
I'd be interesting to determine if it's Outlook that can't generate properly formatted tab and csv delimited files or SQLNotes that doesn't read them correctly... ;)
555
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 10, 2007, 11:57 AM »
Yes, more formats will be added, but if tab-delimited does not work, can you try comma separated ?
556
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 10, 2007, 11:48 AM »
confirmed, I'm working on it right now
557
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 10, 2007, 11:39 AM »
Copy: This will be added, for sure.

Passwords: Currently you can password protect/encrypt the entire database, not individual items/grids.
It is planned to add item/grid permission management, based on the itemOwner
558
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 10, 2007, 11:25 AM »
All... This is not what you want to do?
559
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 10, 2007, 10:55 AM »
This feature will be added. Currently, you can do with in Field Properties:
1- Select the item field
2- In Equation enter = MusicItem
3- Click Update
4- Remove the equation from the Equation field
5- Close the Field Properties dialog.
560
Coding Snacks / Re: structured plaintextfile based note taker
« Last post by PPLandry on December 06, 2007, 09:51 PM »
a notetaker app that opens and structures a series of textfiles in a folder structure. At the moment most people either use software like onenote or evernote to keep all notes together, or plain text files scattered over their system. What I am looking for is to keep the flexibility of plain text (being able to edit/copy/rename/sync the node anywhere), but with some organising features - just some kind of tree structure where every node is an actual plain text file. Not the proprietary or database format used by all notetakers.
make sense, please tell me if I don't :D

Armando proposed SQLNotes and being the developer, I'd say that it can do that right now. Simply drag-drop files from windows explorer onto a grid and you can have 1 click access to your files. In such cases, the file is not stored in SQLNotes, but on your disk, as a file. You can organize the file links in outlines (with fonts, colors, etc) (plus folders, plus other stuff which you do not seem to need for now)

SQLNotes comes with a build-in editor so you have the choice of using your editor or the built-in one. If using the built-in editor, an autosave mode does just that. No prompts, just edit, change item, edit, etc. Nothing to stop the flow.

A number of improvements are coming which may be useful for you:
1- folder monitoring: tell it which folder to monitor and it will create entries automatically as files are created
2- file link through a windows shortcut: big advantage is if you move the file, the link is maintained

And if it doesn't do just what you want, I can certainly make small changes to accomodate your needs:
www.sqlnotes.net
561
General Software Discussion / Re: General brainstorming for Note-taking software
« Last post by PPLandry on December 06, 2007, 01:35 PM »
One reason why many programs have inaccurate clipping (unlike Evernote) is that these use an RTF editor, not an HTML editor and the conversion from HTML to RTF is very problematic. SQLNotes uses a native HTML Editor so I expect good results. Grabbing this DC page for example looks identical except for missing borders (quick tweak of the html code fixed it) and font sizes (which most likely reference styles sheets)

It should also be possible to clip in MHT (or EML) format which would also clip images and styles (and not simply reference them)
562
General Software Discussion / Re: General brainstorming for Note-taking software
« Last post by PPLandry on December 06, 2007, 01:07 PM »
Great! There are a few things missing to be an Evernote replacement, one of which is IE and FF (and hopefully Opera) right-click menu to copy content...

Does anyone at DC know how to do that? Initial search of the web did not give much...
563
General Software Discussion / Re: General brainstorming for Note-taking software
« Last post by PPLandry on December 06, 2007, 12:53 PM »
>Will the filter-as-you-type be able to search the html pane?

The HTML pane uses a field just like all others (ItemHTML, a text field), but with a specialized editor. So yes it will work. A related field is ItemHTMLText which contains the text part of the HTML (without all the markup). I recommend using that one for searching since formatting markup will not get in the way.
564
General Software Discussion / Re: General brainstorming for Note-taking software
« Last post by PPLandry on December 06, 2007, 10:44 AM »
Filter-as-you-type will filter the focused grid field. But since you can display any field in the grid, that means that you can filter live any one field. To filter on many fields, the other methods will work (source, filter, alpha-filter, date-filter, column filter)

That said, I'm not pretending that SQLNotes auto-search matches Evernote's. I just wanted to point to you that feature, in case you hadn't seen it. Evernotes search is excellent and reminds me of my old DOS InfoSelect (simple but effective). The Auto-filter will be an incremental improvement.:
filterontype.gif
565
General Software Discussion / Re: General brainstorming for Note-taking software
« Last post by PPLandry on December 05, 2007, 08:44 PM »
Armando wrote:
(BTW : to be as good a "note taker" as... I don't know... EverNote, it should be extremely fast and painless to insert notes and web clips. Those clips should have an automatic reference (web page address, etc.) "attached" to them, + instant creation date and "automatic title", etc. Everything else is already there in SQLNotes : tagging, etc.)
You are quite right that this aspect of SQLNotes does need improvements It should be as simple as: Select text in your browser > right-click > Send as a new item, or > Append to the current item

@ superboyac and Armando: Thank you both for such encouraging words.

@ superboyac: The SQLNotes grid does have a search-as-you-type mode. It is called auto-search. Check it out! Also Filter-as-you-type is coming soon
566
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 04, 2007, 08:11 PM »
2 pages were added to the wikispace:

1- How to use SQLNotes fields
2- How to import data from other programs (in particular Outlook) into SQLNotes

http://sqlnotes.wikispaces.com/
567
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 04, 2007, 12:22 PM »
>Is there any plans to have a more "manual" way of showing what appears in the grid? 

Search has been expanded. Simply type in the list of items (or parts of), or list of IDItem and it will display them.

>Is there a way (now or planned for the future) to be able to pick and choose individual, random items from the database pool and stick it inside a grid?

Yes, simply create a new grid, name it Set1. Open your main grid and have them side-by-side (right-click on tab and choose move to...). Now drag-drop items from one to the other (Press CTRL to not remove it from the first grid). There is some fine-tuning to do on my part ot make it work smoothly, but this is another way.
568
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 04, 2007, 10:33 AM »
1. You're not too far. In your filter, you must say which field to filter:
 MusicItem="Gene harris". You can also use the Alpha toolbar: MusicItem and click the G or type Gene in the associated text box
2. You can use the Check field (or another). Simply check the items you want and set the source (or filter) to Check
569
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 04, 2007, 06:53 AM »
>Do you have a page that explains the field set up screen? There were some options there that don't seem to be used by the default database.

Nothing yet, but I'll add one today. I had been postponing this since that form will be re-worked. It is rather oldish

>Is there a File Requester that can be attached to a field (that is a path type)? Or is drag and drop a possibility? I know you can drop onto the grid and a new record will be created, but it'd be handy to be able to fill specific fields.

The newly added field URL can be used for that. There is also separate fields FilePath and FileName.

>Any thought about having child grids that are different to the parent (similar to how Access will display a related table), so for example you could have an invoice grid with children that are invoice items that display a different set of fields??

This is certainly possible. It is already on the wish list. Currently, you can use separate grids or use forms to view information not in the columns. You could arrange colums to have the common information locked on the left, then basic parent information, then child information in right-most columns. 1-click could be sufficient to scroll columns from parent info to child info. That combined with forms...

But improvements to that aspect is planned.
570
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 04, 2007, 06:27 AM »
Am I right in remembering that Conditional Formating is planned as well?
Yes, conditional column formatting is planned (red if greater than zero, bold if DueDate < now, etc). In fact, very little is left before implementing it... no user request has been the main reason why it is being pushed forward.
571
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 03, 2007, 10:38 PM »
maybe a small tutorial on how to import stuff from Outlook (like contacts, tasks and calendar events) and other database would be nice.
The wikispace has been updated with detailed step-by-step instructions on how to import data into SQLNotes.
n.b. The import module was improved, so please get the latest build to follow the supplied instruction.
572
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 03, 2007, 09:41 PM »
Is there a match properties command for items?  For example, if I've formatted one item (background color, font size, font color, etc.) can I copy just the formatting of it to another item?  Sort of like a "paste special" command?
No but this is a good idea. A format painter
What you can do however, is to select multiple items and apply formatting to them as a group
573
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 03, 2007, 09:36 PM »
I think the importing has a small bug in it.  I was on step 3, and I went back to click off the 1st line is header box, and when I came back to step 3, all the items in the second column were the same (whereas before, it was supposed all the different song titles, now it was all the same song title, the 1st one in the list).
Tried it here a couple of times, and it works... If you can reproduce it, please provide more info and/or a test file.
574
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by PPLandry on December 03, 2007, 09:17 PM »
PPL, is the grid name limited to 20 characters?
PS, I still can't get the ItemParent field to work for me.
For no practical reason, yes, they are limited to 20 chrs. I guess I thought it would be enough  :(. Could be changed ...

ItemParent: Did you try a repair? Send the file to [email protected] and I'll see what's wrong
575
General Review Discussion / Re: Best spreadsheet
« Last post by PPLandry on December 03, 2007, 04:21 PM »
Yeah, but Excel pivots are a pain in the butt to use... the demo makes it look absurdly easy in Quantrix. 

In fact I can easily imagine myself accidently creating a million-cell Quantrix spreadsheet.

If what you're looking for is a grid to import/enter data and perform analysis (pivot tables and charts), SQLNotes will do that. It supports calculations too, even user defined functions (uses VBScript: if then else, do loops, instr, etc.), enforced at the field level (not at individual cell level). It will import spreadsheet data and allow you to save any number of pivot tables/charts on this data (printable and exportable). And the pivot is easier to use than Excel's. Excel and MSAccess can also link to SQLNotes data to create complex reports
www.sqlnotes.net and,
https://www.donation...ex.php?topic=10432.0

Best of all, it is free while in beta (with 500+ testers, it is very stable)
Pages: prev1 ... 18 19 20 21 22 [23] 24 25 26 27 28next