Exporting to RSS

iBoy · Post by **iBoy** » Fri Dec 07, 2007 3:37 pm

I am trying to make my own xml text template to export an RSS feed. But the RSS tags require the date format in correct RFC 822 format, for example Aug, 22 2004 00:12:30. Is there a way to make DVDpedia export with this format?

Post by **Conor** » Sat Dec 08, 2007 7:29 am

Change the format for the dates in the DVDpedia preferences before exporting, then you can change it back to something more human readable. In this case the format you want is:

Code: Select all

%b, %d %Y %H:%M:%S

iBoy · Post by **iBoy** » Sat Dec 08, 2007 12:28 pm

Thank you for the help. I didn't even know that DVDpedia stored the exact time for adding all my entries. But even if I log in to my Mac with English language, DVDpedia still exports days and months in Norwegian; the RSS needs English abbreviations. Is there a way to fix this?

I think I also need three letter abbreviations for the weekdays:
http://www.w3.org/Protocols/rfc822/#z28

Post by **Conor** » Mon Dec 10, 2007 11:31 am

I think it has to do with your format setting, in the system preference panel under International; you don't have to switch to English but switch the date format to an English language. You should only need to restart DVDpedia. The abbreviated weekday is %a.

iBoy · Post by **iBoy** » Mon Dec 10, 2007 3:05 pm

Thank you very much! Now I've got the date format correct. But still I have problems with the text encoding. For example the Norwegian letter "ø" written by DVDpedia during the export from the [key:] tags don't look the same as an "ø" already written in the document.

An example from my template:
Kjøpt/lånt fra: [key:purchasedAt]

After export:
Kjøpt/lånt fra: Videofilm H�yden (should be: Videofilm Høyden)

I use Adobe GoLive's XML editor and have tried to change the encoding in the template from UTF-8 to ISO-8859-1, both with different, but wrong results. With UTF-16, the letters look like in the exported text file, but it won't open in any browser.

I'm sorry to bother about this, but do you have an idea about what's wrong? What encoding to DVDpedia export text files in?

Post by **Conor** » Mon Dec 10, 2007 4:49 pm

DVDpedia lets Apple decide on the best encoding to export the file in. However to tell DVDpedia to choose UTF8, add the words UTF8 as part of the name of your template: MyGreatUTF8RSSTemplate.xml. It's likely that if no encoding is set in the future I will be exporting all files as UTF-8 because I like standardization and UTF-8. However I am far from an expert so I have to figure out if that is a wise choice; especially for all our Japanese users.