| Author |
Message |
| Registered: July 25, 2007 | | Posts: 12 |
| | Posted: | | | | 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 |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 3,321 |
| | Posted: | | | | 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. |
|
| Registered: June 3, 2007 | | Posts: 706 |
| | Posted: | | | | Sounds interesting.
-R |
|
| Registered: July 25, 2007 | | Posts: 12 |
| | Posted: | | | | 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 |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | 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. |
|
| Registered: April 5, 2007 | | Posts: 45 |
| | Posted: | | | | 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 |
|
| Registered: June 3, 2007 | | Posts: 706 |
| | Posted: | | | | 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 |
|
| Registered: July 25, 2007 | | Posts: 12 |
| | Posted: | | | | 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 |
|
| Registered: June 3, 2007 | | Posts: 706 |
| | Posted: | | | | Yep played with it a bit also played a bit with My Collections...
Workable
-R |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | 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. |
|
| Registered: September 29, 2009 | | Posts: 65 |
| | Posted: | | | | 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. |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | 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. |
|
| Registered: September 29, 2009 | | Posts: 65 |
| | Posted: | | | | You are right! Thanks anyway. The adds-on works nicely!
Then, Brian, could you help me on this?
Thanks. | | | | Last edited: by MB17 |
|
| Registered: July 25, 2007 | | Posts: 12 |
| | Posted: | | | | 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 |
|
| Registered: September 29, 2009 | | Posts: 65 |
| | Posted: | | | | I'll try that soon, and let you know. Thanks! |
|
| Registered: September 29, 2009 | | Posts: 65 |
| | Posted: | | | | 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. |
|