Author |
Message |
Registered: August 21, 2009 | Posts: 2 |
| Posted: | | | | Hi
I'm the author of Movies for iPhone (http://www.netwalkapps.com/content/movies). I recently ran into some issues when customers tried to import an XML generated by DVD Profiler into Movies. It seems the XML generated by DVD Profiler might contain illegal characters when a foreign language (like Swedish) is used in e.g. the movie plot.
Would it be possible to export the XML in UTF-8 encoding (which handles all foreign characters properly, independent of the importing system)?
Thanks a lot,
Tom. |
|
Registered: May 19, 2007 | Reputation: | Posts: 5,918 |
| Posted: | | | | You may want to click on the "Contact Us" link at the bottom of this page to talk with the programmer/owner himself. |
|
| Muckl | That's my common name. |
Registered: April 9, 2009 | Reputation: | Posts: 858 |
| Posted: | | | | Quoting tnys: Quote: Would it be possible to export the XML in UTF-8 encoding (which handles all foreign characters properly, independent of the importing system)? Alternatively, you can convert the XML using e.g. Notepad++ . I do that with my export and the import in Movies always works fine... | | | 1.0.1, iPhone 3GS, iOS 4.1.0
Trivia v0.3.1 My HSDB v5 additions, HTML windows and other stuff |
|
Registered: March 26, 2009 | Posts: 1,387 |
| Posted: | | | | Quoting nubishasha12: Quote: wow gold sale shop here SPAM!!! |
|
Registered: March 13, 2007 | Reputation: | Posts: 2,005 |
| Posted: | | | | Quoting tnys: Quote: Would it be possible to export the XML in UTF-8 encoding (which handles all foreign characters properly, independent of the importing system)? I would welcome this change also. Just recently a fellow user had problems to import the Profiler XML into CCViewer because of this. | | |
|
|
| Muckl | That's my common name. |
Registered: April 9, 2009 | Reputation: | Posts: 858 |
| Posted: | | | | Quoting Muckl: Quote: Quoting tnys:
Quote: Would it be possible to export the XML in UTF-8 encoding (which handles all foreign characters properly, independent of the importing system)? Alternatively, you can convert the XML using e.g. Notepad++ . I do that with my export and the import in Movies always works fine... Since I was asked for help via PM about the XML conversion, I just wanted to post my complete workflow to maybe clarify some things: Quote:
@name: Proper Import of DVD Profiler Data @description: How to import DVD Profiler's Owned, Ordered and Wish List into Movies @version: 0.0.1, 2010-02-19 @author: Muckl (http://invelos.com/UserProfile.aspx?alias=Muckl) @license: (CC) Attribution-Noncommercial-Share Alike 3.0 Unported @tools: [interchangeable with similar software of course] - Notepad++ (http://notepad-plus.sourceforge.net/) - XnView (http://xnview.com/) - a file archiver like 7-Zip (http://7-zip.org/)
1. DVDP: Flag all profiles in Owned and Ordered 2. DVDP: Export flagged profiles to one XML file and only select Overview, Cast (all credits) and Crew (max. 3 credits) 3. Notepad++: Open exported file, go to menu "Format" and choose "Convert to UTF-8 without BOM" 4. Notepad++: In the first line replace "windows-1252" with "utf-8" and save the file 5. Upload file to Netwalk's conversion page and save the result to a new file 6. Repeat steps 1. to 5. with your Wish List items (in DVDP remember to unflag all profiles first) 7. Notepad++: Open the Wish List file and replace all (Ctrl+H) </Year><Length> with </Year><Status>1</Status><Length> 8. Notepad++: Copy (Ctrl+C) everything between <XMM_Movie_Database> and </XMM_Movie_Database> 9. Notepad++: Open the Owned & Ordered file, paste the clipboard (Ctrl+V) right after <XMM_Movie_Database> and save it as export.xml 10. XnView: Go to "Tools" and choose "Batch processing..." 11. Explorer: Open DVD Profiler's image folder (default path is "My Documents\DVD Profiler\Databases\<Your Database Name>\Images"), open the search panel (Ctrl+F) and search for *f.* (be sure Options --> Advanced --> Subfolders is unchecked) 12. Explorer: Mark all files (Ctrl+A) and add them via drag and drop into XnView's "Input" field 13. XnView: Choose an export path, JPG as format and in format options a quality between 60 and 80 14. XnView: Go to tab "Tranformations", expand "Image", choose "Resize", hit "Add >", enter 320 as width, only check "Keep ratio" and finally hit "Go" 15. 7-Zip: Pack the export.xml and the converted covers as one ZIP archive named export.zip 16. Enable WiFi on your iPhone and be sure it's in the same subnetwork as your PC 17. Movies: In settings choose "Clear all", afterwards choose "Restore" 18. Open the address displayed by Movies with a browser, choose your export.zip, hit "Submit" 19. Movies: After the file is available, press "Ready" and waaaiiit ;-)
| | | 1.0.1, iPhone 3GS, iOS 4.1.0
Trivia v0.3.1 My HSDB v5 additions, HTML windows and other stuff |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Is there any reason that one couldn't use the "Save As ..." with the encoding dropdown set to UTF-8 on regular Windows Notepad? | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. |
|
| Muckl | That's my common name. |
Registered: April 9, 2009 | Reputation: | Posts: 858 |
| Posted: | | | | Quoting mediadogg: Quote: Is there any reason that one couldn't use the "Save As ..." with the encoding dropdown set to UTF-8 on regular Windows Notepad? 1) Notepad has problems with large files (perhaps that's fixed in Vista/Win7 ?) 2) Simply saving the file as UTF-8 does not convert some special characters that may appear in overviews (at least in my experience – and again, perhaps that has changed in Vista/Win7 ?) | | | 1.0.1, iPhone 3GS, iOS 4.1.0
Trivia v0.3.1 My HSDB v5 additions, HTML windows and other stuff |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Quoting Muckl: Quote: Quoting mediadogg:
Quote: Is there any reason that one couldn't use the "Save As ..." with the encoding dropdown set to UTF-8 on regular Windows Notepad? 1) Notepad has problems with large files (perhaps that's fixed in Vista/Win7 ?) 2) Simply saving the file as UTF-8 does not convert some special characters that may appear in overviews (at least in my experience – and again, perhaps that has changed in Vista/Win7 ?) Aha, I figured there was a good reason ... thanks. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. |
|
Registered: March 13, 2007 | Posts: 145 |
| Posted: | | | | I'm almost done prepping my export.zip file, but am hoping I can get a last bit of help before pulling the trigger.
Is it possible to upload only the Owned? There's a LOT of detritus in my Wishlist and, with it, a ton of image files that reside in the images folder. All told, I'm looking at 2300 files (101 mb before zip; 87 mb after). That's a lot of iPod real estate.
I know I can create the xml file using just the Owned. If I do that but have all the images am I lucky and only the images with corresponding profiles will be uploaded? Or am I asking for trouble...
Thanks in finger-crossed advance for help. | | | Last edited: by IronWaffle |
|
Registered: May 19, 2007 | Reputation: | Posts: 5,918 |
| Posted: | | | | One option is to use phpdvdprofiler and copy & modify the rss.php script to generate XML in the format that is required for the iPhone app. |
|
| Muckl | That's my common name. |
Registered: April 9, 2009 | Reputation: | Posts: 858 |
| Posted: | | | | Quoting IronWaffle: Quote: I know I can create the xml file using just the Owned. If I do that but have all the images am I lucky and only the images with corresponding profiles will be uploaded? Or am I asking for trouble... Honestly, I don't know if the app deletes unneeded cover images after the import. But I doubt that. But you could make a backup of your Owned collection, import that DVDP file to a new database and then export the XML from the new db and also copy the cover images from the new db's folder. Can't think of an easier way... | | | 1.0.1, iPhone 3GS, iOS 4.1.0
Trivia v0.3.1 My HSDB v5 additions, HTML windows and other stuff | | | Last edited: by Muckl |
|
Registered: March 13, 2007 | Posts: 145 |
| Posted: | | | | Thank you both for the suggestions. I think this weekend I'll try creating an "Owned only" collection since it seems simpler. I've long been tempted by php but even all this xml, xn, zip, etc. stuff leaves me a touch Of course, the simplest thing would be for Ken to release the official app already! |
|
Registered: May 19, 2007 | Reputation: | Posts: 6,730 |
| Posted: | | | | EDITED (by user) because the spam-posting the OP referred to got removed by Forum Moderator | | | It all seems so stupid, it makes me want to give up! But why should I give up, when it all seems so stupid?
Registrant since 05/22/2003 | | | Last edited: by Lewis_Prothero |
|
Registered: March 14, 2007 | Posts: 5,734 |
| Posted: | | | | . | | | Don't confuse while the film is playing with when the film is played. [Ken Cole, DVD Profiler Architect] | | | Last edited: by bbbbb |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Quoting bbbbb: Quote: Quoting Silence_of_Lambs:
Quote: P*** O** spammer! People like you really are a pain in the a***. Without spam your post is disturbing. He obviously clicked on the wrong thread. There is an adjacent spammed thread. No biggie - we all have keyboard errors from time to time. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. |
|