Quote:
Originally Posted by mfaine
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