Welcome Guest.   Make a donation to an author on the site July 31, 2014, 08:36:21 AM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
The N.A.N.Y. Challenge 2014! Download dozens of custom programs!
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: Prev 1 2 3 [4] 5 6 7 8 9 ... 47 Next   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: SQLNotes...what is it exactly?  (Read 389516 times)
iphigenie
Supporting Member
**
Posts: 1,166


curiosity FTW!

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #75 on: November 07, 2007, 02:50:53 AM »

Equations?
Niiice, I'm jumping in now

Except I don't have MS Office except on my work laptop and I won't install betas or unlicensed anything on that.

I have about a zillion office suites - the old smartsuite, an middle aged version of the wordperfect one (pre-corel), the one ashampoo lists and of course open office, so there is most likely a way
« Last Edit: November 07, 2007, 03:10:02 AM by iphigenie » Logged
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #76 on: November 07, 2007, 08:33:26 AM »

Equations?
Niiice, I'm jumping in now

Except I don't have MS Office except on my work laptop and I won't install betas or unlicensed anything on that.
Equations don't require MS Office!

Only the pivot table and chart. Open Office Calc can be used to do the same thing

Finally, a truly built-in pivot (i.e. not needing Office installed) will be integrated in a few months.
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
superboyac
Charter Member
***
Posts: 5,625


Is your software in my list?

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #77 on: November 07, 2007, 10:39:11 AM »

I've updated the wikispace to include a detailed step by step tutorial on how to do this:
http://sqlnotes.wikispaces.com/BasketballStats

Don't forget to get the latest SQLNotes build. That sample is now part of the default template. File > New to create a new file based on the template
Thanks, that's really cool.  Your effort is appreciated.
Logged

PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #78 on: November 08, 2007, 03:56:55 PM »

Thanks, that's really cool.  Your effort is appreciated.
Did you try the sample? Does it do what you want?
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
superboyac
Charter Member
***
Posts: 5,625


Is your software in my list?

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #79 on: November 08, 2007, 04:53:56 PM »

Did you try the sample? Does it do what you want?

I think it does, I haven't finished playing with it yet.  I'm still trying to understand how all the data works together in the program, I don't have my head around it yet.
Logged

PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #80 on: November 08, 2007, 07:43:10 PM »

I think it does, I haven't finished playing with it yet.  I'm still trying to understand how all the data works together in the program, I don't have my head around it yet.
Think of it as:
1- a large spreadsheet. The grid is used to filters which row are displayed and which column is displayed, and/or
2- As a filing cabinet. You place items in folders (fields here). Selecting a field as a grid source, displays items in the folder (This is the Ecco Pro metaphor)

Hope this helps!
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
J-Mac
Supporting Member
**
Posts: 2,844


see users location on a map View Profile Read user's biography. Give some DonationCredits to this forum member
« Reply #81 on: November 09, 2007, 12:17:14 AM »

Pierre,

I'm looking at SQLNotes now for the document tracking database, as we discussed in another thread. I must say, though, the proposed pricing is more than I had expected. That's not to say it is out of line with what it should be -- I guess I just didn't know the price range for this type of application. I might have to take another hard look at Access for my database since I already own that!
Jim
It all depends on how you value your own time...
Also the price is very approximate and will be in line with comparable products. May end-up being less. Finally, contributing beta testers, translators and solution providers get a free licence!

Thank you Pierre.  Maybe I will give it a try using a relatively small sample of my data.

Sorry not to have seen your reply earlier. I most likely did get the DC email notification, but I was overloaded with a lot of spam - my ISP's server spam filter died (or broke down?) and I was getting literally a few hundred spam messages dropped into my inbox daily! Had to do some major adjusting to my own spam filters to compensate and I'm sure I missed responding to a lot of good messages in the rush.

Thanks again!

Jim
Logged

"I am getting so tired of slitting the throats of people who say that I am a violent psychopath."
tomos
Charter Member
***
Posts: 8,369



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #82 on: November 09, 2007, 03:55:17 AM »

Think of it as:
1- a large spreadsheet. The grid is used to filters which row are displayed and which column is displayed, and/or
2- As a filing cabinet. You place items in folders (fields here). Selecting a field as a grid source, displays items in the folder (This is the Ecco Pro metaphor)

Hope this helps!

this is helpful

I've been struggling with the underlying concept
not having used database type software before is probably a handicap...

If I follow the logic and metaphor of point one -
lets see... using SQL-Notes, I dont understand (yet) how (exactly) you filter things so it's probably too soon to be asking questions -
but I'll have a go anyways smiley

  • Would it be possible to filter one item+subitems (i.e. one of many items) for example from ToDo to another grid?
  • Is it possible to make new columns - I see there's a long list of them already.
  • Is it possible to open a new "spreadsheet" ?
Logged

Tom
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #83 on: November 09, 2007, 07:03:48 AM »

If I follow the logic and metaphor of point one -
lets see... using SQL-Notes, I dont understand (yet) how (exactly) you filter things so it's probably too soon to be asking questions -
but I'll have a go anyways smiley

  • Would it be possible to filter one item+subitems (i.e. one of many items) for example from ToDo to another grid?
  • Is it possible to make new columns - I see there's a long list of them already.
  • Is it possible to open a new "spreadsheet" ?

1- To uniquely filter a single item put [Edit] "IDItem = xxx" [/Edited] in the source of a grid. ID Item of the item is seen in the properties pane. The source is the left-most box on the source bar (Grid > View source bar to show it)
2. Columns are fields. Fields can be displayed as a column in a grid, or in one or many forms. View>Manage fields to add a new. Once created, in your grid: Grid > Displayed column to display it (or drag-drop from the properties pane to the grid)
3. To create a new grid: View > Grids > New Grid
« Last Edit: November 09, 2007, 10:02:04 PM by PPLandry » Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #84 on: November 11, 2007, 12:47:46 PM »

The SQLNotes wikispace is being enhance to include beginners guide to introduce new users (especially those without Ecco Pro expertise) to the SQLNotes concept:
http://sqlnotes.wikispaces.com/

It is open to all! No need to register to view, comment and make changes. You are all welcomed to visit and contribute. A new Q & A page was added specifically for users questions:
http://sqlnotes.wikispaces.com/Q+%26+A

(but you can continue to use this forum too. It's your choice!)
« Last Edit: November 11, 2007, 03:54:42 PM by PPLandry » Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,674



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #85 on: November 11, 2007, 03:41:06 PM »

Very nice!
Thanks Pierre.
(Will have to take SQLnotes for another serious ride very soon...)
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
Darwin
Charter Member
***
Posts: 6,979



see users location on a map View Profile Read user's biography. Give some DonationCredits to this forum member
« Reply #86 on: November 11, 2007, 05:24:50 PM »

Yes - this will help me a LOT. Not that SQLNotes is hard exactly, but I'm pretty new to the genre so am still "coming up to speed"  Thmbsup
Logged

"Some people have a way with words, other people,... oh... have not way" - Steve Martin
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #87 on: November 12, 2007, 05:57:36 PM »

Don't we all have zillions of digital photos. And each camera we buy comes with this semi-useless software to manage your photos...

Long time ago, I added an image viewer to SQLNotes. It was not updated and hence disabled. Well it's back:

    * Drag-drop files from Explorer to create items with links to the files.
    * In a grid, you have user-defined columns to describe the photo (date, who's there, where, rating, etc)
    * You can add additional information as sub-items (click on the + to see the details, as in Windows Explorer)
    * You can sort, filter, group easily
    * A built-in image viewer, which rotates to show constant size (portrait vs landscape)
    * Double-click on the image will lock the viewer on this photo. Open another viewer to view other photos. You can open as many as you wish (Now you'll like that 21" screen!)
    * If many viewers are opened, as you scroll in the photo list, a different viewer is selected to show the photo. So the last few photos are always visible. Great when a group of people are looking at them.

    * Image file is not imported, SQLNotes creates a link, so the SQLNotes file remains real small
    * No imaging editing tool included (would be second rate anyway). You use the editing tools that you prefer! Double-click the item in SQLNotes to open it.
    * You can create many grids where you see some or all of your pictures. Great to view the same photo in different contexts (without making copies)
      i.e. The grid of the best photos of my 4 year-old and the grid of photos of our trip to the east-coast, some of the photos will be the same. No problem!

Plus, coming soon 3 additions which will be useful for this task:

    * Automatic folder monitoring. Tell it which folders (i.e. my pictures/*.jpg)  to monitor and any new files will be added to your SQLNotes database automatically, in a separate grid so you know that they need to be documented.
    * File date will be imported into the database (currently only file name and path are imported).
    * Option to create a windows shortcut when linking to the file. Hence moving the file will not break the link (Windows monitors shortcuts automatically)
www.sqlnotes.net

An example will be added very soon in the wikispace
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
CWuestefeld
Supporting Member
**
Posts: 930



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #88 on: November 12, 2007, 06:19:53 PM »

File date will be imported into the database (currently only file name and path are imported)

If you want this feature to be really useful, I'd suggest allowing for the import of EXIF/IPTC data from image formats that support tagging. (I'm pretty sure there's code on CodeProject.com for this, to save you some time)
Logged



Armando
Charter Member
***
Posts: 2,674



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #89 on: November 12, 2007, 08:43:23 PM »

Pierre... you're giving birth to a monster. A friendly one, of course.  Thmbsup
I find that the multimedia aspect is lacking from other free-form databases/organizationnal tools (for instance, I don't think that asksam has any direct support for images -- but I might be wrong -- jimdoria could probably tell). So, at first sight, it seems good to have image support in... SQLNotes (oups, caution! caution! semantically streched name  Wink ).
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
Armando
Charter Member
***
Posts: 2,674



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #90 on: November 12, 2007, 09:00:43 PM »

Just tried it. Really cool.

Would be nice to be able to cycle through the pictures with a shortcut key (if not already possible).

    * Automatic folder monitoring. Tell it which folders (i.e. my pictures/*.jpg)  to monitor and any new files will be added to your SQLNotes database automatically, in a separate grid so you know that they need to be documented.
    * File date will be imported into the database (currently only file name and path are imported).
    * Option to create a windows shortcut when linking to the file. Hence moving the file will not break the link (Windows monitors shortcuts automatically)

These will be great additions.
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #91 on: November 12, 2007, 09:03:30 PM »

SQLNotes (or whatever it is finally called) aim at helping you manage your information.
And nowadays, picture files are one hell of an information nightmare. Integrating that with your other information (people, calendar, tasks) is a win-win situation.

Did you try the multi-viewer? Open 4 and as you change picture item, each window gets updated in rotation (best on dual-screen, my second screen is 21" !). No more will you have people say: "Wait, go back to that last one!". And the auto-rotation (portrait-landscape)?
(Double-click to lock a window on an image. )
« Last Edit: November 12, 2007, 09:18:07 PM by PPLandry » Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #92 on: November 12, 2007, 09:04:19 PM »

> Cycle keys..

What do you mean?
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Armando
Charter Member
***
Posts: 2,674



see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #93 on: November 12, 2007, 09:08:49 PM »

> Cycle keys..

What do you mean?

"cycle through the pictures with a shortcut key" : Like alt+tab does for witching between windows,  or ctrl+tab, etc., in some apps.

Have to go but will post again later,
Logged

"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #94 on: November 14, 2007, 09:04:13 PM »

Just to keep you updated:

1- SQLNotes is now capable of printing 1-many relationship data. Examples are sales receipt (sale - sale details),  Consultant billing (Client - Work done), etc. You can even print multiple invoice, for different clients, in 1 step. Use syntax Parent.Fieldname to show the parent value

2- I'm now working on a Date Filter toolbar. This will allow SQLNotes to be used to manage time (i.e. a calendar) and tasks (i.e. todos) more effectively (View schedule for today, this week, this month, etc,  view undone todo's due this week, etc). But it could be used to filter any date related field (want to see items created last month, sales in July, etc)


(in this screenshot, appointments from oct 1 to 22 will be shown  -- 21 days as set in the duration box)
« Last Edit: November 14, 2007, 09:22:48 PM by PPLandry » Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
superboyac
Charter Member
***
Posts: 5,625


Is your software in my list?

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #95 on: November 15, 2007, 01:28:46 PM »

Damn, this program sounds good.  If only I could figure out how to use it.  granted, I haven't put in the time.  I should do that one day!
Logged

PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #96 on: November 15, 2007, 01:31:12 PM »

Damn, this program sounds good.  If only I could figure out how to use it.  granted, I haven't put in the time.  I should do that one day!
Did you try reading the doc at http://sqlnotes.wikispaces.com/ ? It would be a good start. Otherwise, I'm offering a free phone conversation to get you going...
« Last Edit: November 15, 2007, 01:32:59 PM by PPLandry » Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
superboyac
Charter Member
***
Posts: 5,625


Is your software in my list?

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #97 on: November 15, 2007, 03:36:31 PM »

That's very generous of you, I might have to take you up on that.  However, before I do, I have to give it an honest effort.  I just haven't tried all that hard yet, I'm too freakin busy.  But I'll get around to it.
Logged

Darwin
Charter Member
***
Posts: 6,979



see users location on a map View Profile Read user's biography. Give some DonationCredits to this forum member
« Reply #98 on: November 15, 2007, 05:21:22 PM »

I'm in more or less the same boat as superboyac. I'll try to give it a more comprehensive appraisal this weekend.
Logged

"Some people have a way with words, other people,... oh... have not way" - Steve Martin
PPLandry
Supporting Member
**
Posts: 691


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #99 on: November 15, 2007, 06:11:20 PM »

I'm in more or less the same boat as superboyac. I'll try to give it a more comprehensive appraisal this weekend.
If you want to see what inspired SQLNotes, you can download Ecco Pro 4.0, which is now freeware (discontinued since 1997).
You'll get a calendar, phonebook and notepads (which are like SQLNotes Grids)
http://www.compusol.org/ecco/

Of course, SQLNotes is NOT a clone of Ecco. It can handle rich text and data much better. Plus Ecco's I/O was limited. At the same time, some features are still missing in SQLNotes for now... but they'll be added!
Logged

Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
Pages: Prev 1 2 3 [4] 5 6 7 8 9 ... 47 Next   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.051s | Server load: 0.03 ]