I think I was probably looking for something different with the formula thing - just a way to total all figures that might appear in a single column (e.g., 4+5+6+7+4 = 26). That way I could total up time spent on a task for instance, or quoted prices etc.

Hmmm...did you see the "Sum column" option when you right-click a column's header?  That will pop up a message box with the total of any numbers in the column.  Is that not what you wanted?

Quote from: Beth UK on January 13, 2011, 12:22 AM

I think I was probably looking for something different with the formula thing - just a way to total all figures that might appear in a single column (e.g., 4+5+6+7+4 = 26). That way I could total up time spent on a task for instance, or quoted prices etc.

Hmmm...did you see the "Sum column" option when you right-click a column's header?  That will pop up a message box with the total of any numbers in the column.  Is that not what you wanted?

No - I missed it completely! But now I have seen it! Is there a way that instead of the total popping up in a window it can be inserted into a cell at the bottom of column in question - perhaps beneath a divider line or something? That would make it perfect for what I need!

No - I missed it completely! But now I have seen it! Is there a way that instead of the total popping up in a window it can be inserted into a cell at the bottom of column in question - perhaps beneath a divider line or something? That would make it perfect for what I need!

My hesitation is that I didn't intend for Snap DB to become a spreadsheet at all.  I mean, it's trivial to do what you want but then that summation line becomes part of the database information and its data would then be used in further calculations unless you were to delete that line.  It just seems a bit kludgy.  Does that make sense? 

Quote from: Beth UK on January 13, 2011, 12:34 AM

No - I missed it completely! But now I have seen it! Is there a way that instead of the total popping up in a window it can be inserted into a cell at the bottom of column in question - perhaps beneath a divider line or something? That would make it perfect for what I need!

My hesitation is that I didn't intend for Snap DB to become a spreadsheet at all.  I mean, it's trivial to do what you want but then that summation line becomes part of the database information and its data would then be used in further calculations unless you were to delete that line.  It just seems a bit kludgy.  Does that make sense? 

Hi,
I totally accept your point. I was thinking that being able to display the total would make it ideal as a 'time logger' for a University course I am doing - I have to declare personal study time - and this would make it near perfect. Currently I use a spreadsheet which is OTT for what I need, and not portable either. My suggestion was more a personal whim and I don't want to drag you away from your overall goal for the project. 

Looks interesting. I will definitely check it out. Thanks! 

I found this weird bug. When I right click the header of the ninth column, I don't have the option to "rename column", instead I got the "Add record.." context menu.

I've seen this occasionally.  Try resizing the columns or swapping positions and back.

Also, it could be a good idea to have the option to use the first row as column headers when you import from a CSV file.

I thought about making this an option since not all CSV files have the headers as their first row.

Thank you for the lastest updates.

You're welcome.  =]

Quote from: skwire on January 14, 2011, 05:43 PM

Can do.  Would you want the duplicated row added to the bottom of the listview or directly below the row you're duplicating?

I haven't really thought about it. From the point of view of my needs, either solution seems fine.

I added that feature in the last build.  It adds the duplicated record below the focused one.  You can also use F5 as a hotkey for that. 

Thanks, I like Snap DB even more now!

Fantastic.  I'm glad you find it useful. 

(Sorry it took me awhile to make it back here) Yes, perfect ... The dynamic column creation is also quite nice. Thank you.

You're welcome.  Great to hear.

Is there any chance of adding an option to the import function to allow the (header row) first line of the file to be used as the column names? Similar to the radio button dialog the Excel sort function uses to keep the column names on top of a spread sheet.

This would interfere with the ability to drop multiple files onto the list so I was thinking of adding an entry to the context menu that would read something like "Convert record data to header names."  Follow me?

The "Convert record data to header names." sounds great (and much smoother), but it might be better to add it to the Edit menu where it can be found & used, and leave the context menu free for the other stuff that people are more apt to do frequently (Keep the menu less busy so they don't have to hunt for stuff).

Well, the Edit menu and the context menu (right-clicking the listview) are the same menu.      It's almost to the unwieldy point but I think we can squeeze one more entry onto it.

I appended two columns, renamed each and drug them to the left between two existing columns.  When I exported to a csv and brought them up in Excel, the appended columns were still on the right side.  Not where I moved them to.

I can confirm this behavior (using a plain text editor), the data is being saved based in the (column created or) row index order, not the order in which it is displayed. IIRC this is also typical ListView control behavior.

I'm thinking there is a function call/API to reindex the rows in a ListView control, but I can't think of it at the moment.

Lovely piece of software again Skwire!   

Would the following be possible:
(I haven't read the whole topic in detail, only a quick read)

If i create a new file (ctrl+n) and I don't change anything, and i drop a csv on it, could it be possible that you check the number of columns from the first row, and then create the exact number of columns and then add the data.

Because what happens now is the following:
I create a new file, and I get 4 columns.
When I drop a CSV on it with 7 columns, I end up with all the records with only 5 columns.

Here's the testdata:

Started On,Completed,Computer,Status,Total files,Infected,Scan Type
6/4/2008 3:17:53 PM,6/4/2008 3:40:09 PM,MYPC,Scan Complete,102660,0,Manual scan
6/4/2008 3:02:28 PM,6/4/2008 3:14:14 PM,MYPC,Scan Aborted,76046,0,Manual scan
6/3/2008 9:03:35 PM,6/3/2008 9:19:14 PM,MYPC,Scan Complete,99824,0,Manual scan

Oh, and could it be possible to define the "separator" per database?
So when I create a new database, I define ',' or ';' as separator. When I then drop a scv on it, it uses the configured separator.

One more thing (probably a bug):
If I drop a scv on it, the status doesn't change to "edited", so when I close snapdb, it doesn't save the data from the scv.

Thanks. :-)