Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
How many words are in this question?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

Posted by: Roy22
« on: June 13, 2011, 06:21:53 pm »

Quote
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
Posted by: rick.ca
« on: June 13, 2011, 12:09:51 am »

Place the cursor at the end of the last line, and press <Enter>. ;)
Posted by: Roy22
« on: June 12, 2011, 11:13:29 pm »

Yes, but how?  Wasn't sure how Asci 13 was specified?

Roy22
Posted by: rick.ca
« on: June 12, 2011, 10:03:29 pm »

Add a carriage return at the end of the template file.
Posted by: Roy22
« on: June 12, 2011, 06:01:07 pm »

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
Posted by: rick.ca
« on: June 12, 2011, 05:49:09 pm »

Open the file with Excel's Text import wizard.
Posted by: Roy22
« on: June 12, 2011, 04:44:32 pm »

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
Posted by: rick.ca
« on: May 09, 2011, 06:36:16 am »

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: [Select]
%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}
Posted 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?