English > Support

Can user-defined star ratings be exported?

(1/2) > >>

Roy22:
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?

rick.ca:
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...


--- Code: ---%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}

--- End code ---

Roy22:
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

rick.ca:
Open the file with Excel's Text import wizard.

Roy22:
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

Navigation

[0] Message Index

[#] Next page