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->DVD Profiler Mobile: Mobile Feature Requests Page: 1  Previous   Next
Partial workaround for Android
Author Message
DVD Profiler Unlimited Registrantg0ukb
Registered: July 25, 2007
Posts: 12
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
There is a nice database program for the Android - Memento (http://luckydroid.com/) which will import CSV databases. I took the export of my 1600+ DVDs from DVD Profiler and wrote some Python code to parse the  collection.xml file and produce a csv file with basic information -Title, Collection Number, Media type, Production Year, Running Time, Director(s), 5 Actors and Overview. I'll probably add Purchase Info (data/price/place). I then defined similar fields in Memento, uploaded the csv file and imported. Import takes 3 or 4 mins for my collection but not too bad.

This runs nicely on the Android, scrolls fairly fast and the search and sort work well. Memento will support images but not sure I wanted to add 1600+ images to the phone, might reduce memory card size and performance. Also I restricted Actors to 5 to reduce the size of the colllection.xml file out of DVD Profiler and and the size on the phone.

Obviously no where near as good as DVD Profiler on the Android but it does allow me to check my collection when tempted to buy more DVDs and give me a quick check on running times/plot overview when deciding what to watch.

If anyone is interested in this sort of solution I may try and find time to do something for general consumption - currently it is just a Python script running on my Ubuntu machine. Also be interested to know what folks think are key fields/requirements of such a stop-gap solution.

Brian
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting g0ukb:
Quote:
I took the export of my 1600+ DVDs from DVD Profiler and wrote some Python code to parse the  collection.xml file and produce a csv file with basic information -Title, Collection Number, Media type, Production Year, Running Time, Director(s), 5 Actors and Overview. I'll probably add Purchase Info (data/price/place). I then defined similar fields in Memento, uploaded the csv file and imported.


There is a CSVExport plug-in that may save you a little time getting the data out of Profiler. 
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantRobAGD
Registered: June 3, 2007
United States Posts: 706
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Sounds interesting.

-R
DVD Profiler Unlimited Registrantg0ukb
Registered: July 25, 2007
Posts: 12
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Rats!! Thanks for that Mark - didn't know it existed    Still at least I got to learn how to parse XML in Python which is a  bonus (and it's always fun to hack a bit of code)

Still, whichever extraction method Memento isn't a bad front end database on the Android. It will serve my immediate needs anyway.

So tell me - do I need to continue to work on code that determines what entries have changed since the last export and only upload those to the phone or is there already a plug-in for that too? 

Brian
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting g0ukb:
Quote:
So tell me - do I need to continue to work on code that determines what entries have changed since the last export and only upload those to the phone or is there already a plug-in for that too? 


You can flag the ones you're interested in and just export those profiles if you like.  I do that all the time.  You can also configure which fields get exported.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Desktop and Mobile RegistrantFalquian
Registered: April 5, 2007
Posts: 45
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I'm quite interested in your development since I am more and more concerned aboutthe lack of an Android port of DVDPM.

At this point I would really love even a simple Excel file with the names of my DVDs and BDs collection. Just with the possibility of indexing and searching. For all the additional data (director, cast, etc.) I could wait till the official app.

Please, keep us informed.

Best regards
DVD Profiler Unlimited RegistrantRobAGD
Registered: June 3, 2007
United States Posts: 706
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Well, I stuffed most of my collection on my Evo using this method.

Worked reasonably well, I would like to not have to use the same tags as the files use.

Sort Title vs Title, Location - 1 vs Location, Slot - 1 vs slot etc

also it would be interesting if we could also export thumbnail images from profiler

-R
DVD Profiler Unlimited Registrantg0ukb
Registered: July 25, 2007
Posts: 12
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Mark - just downloaded your plugin - Neat - Thanks. Its easier than exporting the whole XML file and post-processing as my code does.

Rob -  both Mark's export and Memento use the first line of the CSV file to describe the fields. So use Sort Title in the CSV Export plugin and then edit the first line of the CSV file to say "Title" rather than "Sort Title" and Memento will use it for the Title field. Of course if you do this you either have to not export Title or rename that to something different like "Original Title" in the first line of the CSV file otherwise you have two fields with the same name.

I'm fairly happy with Memento as an interim solution - it searches across my 1650+ DVD collection pretty quickly and has already stopped me buying duplicate DVDs 

Brian
DVD Profiler Unlimited RegistrantRobAGD
Registered: June 3, 2007
United States Posts: 706
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Yep played with it a bit also played a bit with My Collections...

Workable

-R
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting g0ukb:
Quote:
Mark - just downloaded your plugin - Neat - Thanks. Its easier than exporting the whole XML file and post-processing as my code does.


Glad to hear it's working out well for you.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Desktop and Mobile RegistrantMB17
Registered: September 29, 2009
Posts: 65
Posted:
PM this userDirect link to this postReply with quote
Hi Mark,

I managed to export my collection, but I have never used Memento. Is there a tutorial for noobs? I mean, a step by step guide from the moment I copied the collection.csv file to my Android with Memento.

I appreciate any help.

Thanks.
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting MB17:
Quote:
Hi Mark,

I managed to export my collection, but I have never used Memento. Is there a tutorial for noobs? I mean, a step by step guide from the moment I copied the collection.csv file to my Android with Memento.

I appreciate any help.

Thanks.


You'd want to ask Brian.  I just did the plug-in to get the data into CSV format.  Beyond that, I don't have an Android phone or know anything about Memento (beyond it being an awesome movie).
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Desktop and Mobile RegistrantMB17
Registered: September 29, 2009
Posts: 65
Posted:
PM this userDirect link to this postReply with quote
You are right! Thanks anyway. The adds-on works nicely!

Then, Brian, could you help me on this?

Thanks.
 Last edited: by MB17
DVD Profiler Unlimited Registrantg0ukb
Registered: July 25, 2007
Posts: 12
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
There is a template on Memento for DVDs but I created my own. I don't have access to my computer now so don't have all the details but if I remember correctly ...

When I exported from DVDProfiler i only exported fields I wanted on the droid, Title (actually sort title), Collection No., Media Type, Production Year, Director(s), Actors (max of 5), overview. So I created a new database on Memento with the same fields, it was quite easy.from the Menu button select "Add Library" and it should give you a list of templates. I used "custom" , entered a name for the library (something like MyDVDs) and then used the "Add a field" button to add fields. Most were just text fields.

Also when you export from DVDProfiler the first line of the CSV is a title line - ie it is like "Sort Title", "Collection Number" ....."Overview" - the names here must match the Memento names so I edited my DVDProfiler CSV first line to match the names I chose for Memento, e.g. I changed "Sort Title" to just "Title".

Click on the newly created database icon in memento and use Menu / More / Edit the Library to allow you to specify a file to import Point it at the CSV file you've uploaded to the droid and if you've got it right the file should import. My 1600 entries takes a couple of mins.

I hope this helps

Brian
DVD Profiler Desktop and Mobile RegistrantMB17
Registered: September 29, 2009
Posts: 65
Posted:
PM this userDirect link to this postReply with quote
I'll try that soon, and let you know. Thanks!
DVD Profiler Desktop and Mobile RegistrantMB17
Registered: September 29, 2009
Posts: 65
Posted:
PM this userDirect link to this postReply with quote
Well... Did try. After laborious work with Memento fields, no luck. I guess I'm not up for the task.  It lists all the fields alright, but when I  import I get some error 

If anyone can share the Memento template, I would appreciate. Otherwise, thanks for the help anyway.
    Invelos Forums->DVD Profiler Mobile: Mobile Feature Requests Page: 1  Previous   Next