Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->General: New Users Forum Page: 1 2  Previous   Next
XML export to Movies for iPhone
Author Message
tnys
Registered: August 21, 2009
Posts: 2
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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.
DVD Profiler Desktop and Mobile RegistrantDr. Killpatient
Here's my card
Registered: May 19, 2007
Reputation: Highest Rating
United States Posts: 5,917
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
You may want to click on the "Contact Us" link at the bottom of this page to talk with the programmer/owner himself.
DVD Profiler Unlimited RegistrantMuckl
That's my common name.
Registered: April 9, 2009
Reputation: Great Rating
Germany Posts: 858
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with 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...
 
1.0.1, iPhone 3GS, iOS 4.1.0

Trivia v0.3.1
My HSDB v5 additions, HTML windows and other stuff
DVD Profiler Unlimited RegistrantStar ContributorOldMan56
No Horror Movie is Bad
Registered: March 26, 2009
United States Posts: 1,387
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Quoting nubishasha12:
Quote:
wow gold sale shop here



SPAM!!!
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with 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)?


I would welcome this change also. Just recently a fellow user had problems to import the Profiler XML into CCViewer because of this.


DVD Profiler Unlimited RegistrantMuckl
That's my common name.
Registered: April 9, 2009
Reputation: Great Rating
Germany Posts: 858
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with 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?
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Unlimited RegistrantMuckl
That's my common name.
Registered: April 9, 2009
Reputation: Great Rating
Germany Posts: 858
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with 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 ?)
 
1.0.1, iPhone 3GS, iOS 4.1.0

Trivia v0.3.1
My HSDB v5 additions, HTML windows and other stuff
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
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.
DVD Profiler Unlimited RegistrantIronWaffle
Since April 26, 2001
Registered: March 13, 2007
United States Posts: 145
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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
DVD Profiler Desktop and Mobile RegistrantDr. Killpatient
Here's my card
Registered: May 19, 2007
Reputation: Highest Rating
United States Posts: 5,917
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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.
DVD Profiler Unlimited RegistrantMuckl
That's my common name.
Registered: April 9, 2009
Reputation: Great Rating
Germany Posts: 858
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantIronWaffle
Since April 26, 2001
Registered: March 13, 2007
United States Posts: 145
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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!
DVD Profiler Unlimited RegistrantStar ContributorLewis_Prothero
Strength Through Unity
Registered: May 19, 2007
Reputation: Superior Rating
Germany Posts: 6,730
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantStar Contributorbbbbb
on steroids
Registered: March 14, 2007
Posts: 5,734
Posted:
PM this userDirect link to this postReply with quote
.
Don't confuse while the film is playing with when the film is played. [Ken Cole, DVD Profiler Architect]
 Last edited: by bbbbb
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
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.
    Invelos Forums->General: New Users Forum Page: 1 2  Previous   Next