Personal Video Database
English => Support => Topic started by: Roy22 on May 08, 2011, 01:04:16 pm
-
Is there a way to export the user defined star rating alongside other data? I know that I can filter the database view down by star rating, one rating at a time, and then export each sub view, but is there a way to create a single export with, say, filename, file size & user star rating?
-
You can export anything by configuring the template used by the Plain Text Export plugin. You could do this with a CSV template, for example...
%OPTIONS%
encoding="UTF8BOM"
replace=";<->,"
replace=""<->"
replace="#13#10<-> "
replace="#13<-> "
replace="#10<-> "
filter="CSV Files|*.csv"
%OPTIONS%
%HEAD%Filepath;Size;Rating;
%HEAD%{%value=path};{%value=size};{%value=rating}
-
rick,
Belated thanks for your reply. I've been playing around with options similar to what you suggest, but one small problem is driving me mad.
How do you ensure the exported test is treated as one movie line per line of Excel? I tried removing the #13#10 replace in the example, and with adding/removing the semicolon on the end of the last line, but Excel keeps treating it as one long series of fields, not a new movie per line, and complaining about the size. I know this must be simple, please enlighten me?
Cheers,
Roy22
-
Open the file with Excel's Text import wizard.
-
I've played around with the Text Importer quite a lot already. It makes sense to say it's delimited with semi colons, which it takes fine. It just doesn't seem to react to 'new line', making all the exports tab endlessly across row one. Does your export plugin place any kind of 'end of line' characters after each movie row exported?
Roy22
-
Add a carriage return at the end of the template file.
-
Yes, but how? Wasn't sure how Asci 13 was specified?
Roy22
-
Place the cursor at the end of the last line, and press <Enter>. ;)
-
Place the cursor at the end of the last line, and press <Enter>
Oh, how 1980s. Stupidly, I thought Enter would just bring me onto another line in the template editor, 'cos if it's inserting a control character (aka Enter) then it's not otherwise visible. But yes, it certainly works and it explains some haphazard behaviour whilst I played with templates.
Cheers,
Roy22