View Single Post
Old 01-07-2011, 02:37 PM   #379
GRiker
Comparer of the Ephemeris
GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.
 
Posts: 1,496
Karma: 424697
Join Date: Mar 2009
Device: iPad
Quote:
Originally Posted by mfaine View Post
For CSV output (and maybe others) it would be nice if we could order the columns and provide alternate labels for them. Also, it would good if we could set the date format that will be output to CSV for date columns. Also, why is the rating based on 10 being the highest. The rating output should be / 2
The CSV and XML output formats are intended to be used as input to other programs. CSV is intended for spreadsheets, where you can easily manipulate column order and sorting.

The rating is actually stored in the database as a number from 0-10. I left it in that range to mirror the true contents of the database. My instinct is to leave the content with a correct representation of the database content, and leave it to the spreadsheet to manipulate the number for compatibility. I believe that the original reason was to potentially support half ratings at some point, e.g. 7 would be a 3.5.

I used the lookup name of the custom columns to be consistent with the standard column names - they are the exact name you would type when searching by column. That way, it's easy to see what content will be output to the file.

What date format are you looking for? I'd consider adding a formatting string option if there's enough interest.

G

Last edited by GRiker; 01-07-2011 at 02:48 PM.
GRiker is offline