Importing myhtpc-data into XLobby?

Help each other out

Importing myhtpc-data into XLobby?

Postby Poru3 on Wed Apr 26, 2006 9:54 pm

Hi!


I am using a new frontend-solution for my movies as meedio went down...
However, a big problem for me might be that I have created so-called .my-files for each of my movies including the specifics about the movie (e.g. director, actors, duration etc.). Is there any way how I could import such .my-file information along with the cover-art included in the movie folder into XLobby? (I tried to do searches for the forum, but didn't find an answer)

Thanks for any info,


Poru3
Poru3
 
Posts: 8
Joined: Wed Apr 26, 2006 9:49 pm

Postby jowaldo on Wed Apr 26, 2006 10:28 pm

what kind of format does this .my file save it in?

If its any type of xml, or clear text... it might be do-able

If it is, post a section of it here, and maybe we can figure out a way
jowaldo
 
Posts: 903
Joined: Wed May 21, 2003 7:17 pm

Postby Poru3 on Wed Apr 26, 2006 11:07 pm

Yes, the way I have my movie on my hard drives, is that each .avi is included in a separate folder and the folder's name is the title of the movie "Movie Name". The folder includes also "Movie Name.avi"-file and a "Movie Name.my"-file. The .my-file is like this if I open it up in a notepad (I illustrate this with a movie entitled "Very Good Movie", it would then have in the folder Very Good Movie.avi -file and the name of the .my-file would be "Very Good Movie.my", the folder's name would be "Very Good Movie":

------------and here's what it looks like in the notepad -------------------
[1]
title=Very Good Movie
subtitle=Strange things happen in this very good movie
category="Director","John Doe"
overview=This very good movie tells a story about 2 cops, each with its own pros and cons.
produced=2006
duration=102
category="Genre","Drama","Romance"
review=9
rating=PG
people="Actors","John Doe","John Doe 2","John Doe 3"
images="Very Good Movie.jpg"
chain="Feature","very good movie.avi"
------there's nothing more included in the file according to notepad------


I cannot rewrite the descriptions, it would just not be simply doable with reasonable efforts... I truly hope there would be a way to import them. Thanks for any help!



Poru3
Poru3
 
Posts: 8
Joined: Wed Apr 26, 2006 9:49 pm

Postby dalanik on Thu Apr 27, 2006 7:48 am

You would have to write a script in order to export that data to XLobby's database. While this might be possible, IMHO, it would be easier to start fresh and reimport data into XLobby database - there are at least 2 ways, and they're pretty automated.

First one is to use XLobby spiders; unfortunately, I use the ther method :-) so I can't give yu any advice on that, maybe someone else can.

Second one is to use Ant movie Catalogue and xAnt plugin.

both methods simply download all relevant movie info from the internet, i.e. director, actors, plot, year, genre, description, even cover.

D.
dalanik
 
Posts: 885
Joined: Mon Apr 19, 2004 12:35 pm
Location: Prague, Czech Republic

Postby art on Thu Apr 27, 2006 1:47 pm

Poru3 wrote:------------and here's what it looks like in the notepad -------------------
[1]
title=Very Good Movie
subtitle=Strange things happen in this very good movie
category="Director","John Doe"
overview=This very good movie tells a story about 2 cops, each with its own pros and cons.
produced=2006
duration=102
category="Genre","Drama","Romance"
review=9
rating=PG
people="Actors","John Doe","John Doe 2","John Doe 3"
images="Very Good Movie.jpg"
chain="Feature","very good movie.avi"
------there's nothing more included in the file according to notepad------


I cannot rewrite the descriptions, it would just not be simply doable with reasonable efforts... I truly hope there would be a way to import them. Thanks for any help!



Poru3


Are all those files the same, meaning you have 2 'category' fields - 'Director' & 'Genre' are there any other categories or only those 2, etc, etc?
art
 
Posts: 284
Joined: Sat Mar 20, 2004 8:40 am
Location: Allen, TX

Postby Poru3 on Thu Apr 27, 2006 3:52 pm

Yes, GetMy -application import the information from IMDB. So the director can be whatever, the genre is what IMDB tells as the genre being, duration, production year, rating e.g. "PG", "PG-13", review makes reference to the points given IMDB - all the information comes straight from IMDB, but I have handpicked the cover-pictures from IMPAwards to get some more resolution in them (GetMy usually only receives 7 KB thumbnails...). .my files have the categories "Director", "Genre", "Actors","Feature" automatically included. I never use such features for sorting, so I am not that familiar with that. What I like though, is to be able to read the additional information in a summary with the coverpicture.



Poru3
Poru3
 
Posts: 8
Joined: Wed Apr 26, 2006 9:49 pm

Postby art on Thu Apr 27, 2006 11:07 pm

Well, I understand that values of categories can be anything, the question was if you have any other categories in your files, like category="screenplaywriter","bla-bla", anyway try downloading this file - click on 'Add' button and pick your 'drive\movies' folder (you can have multiple locations) and than 'Generate' button, prog should scan all folders and subfolders for all *.my files and create 'movies.xml'. Rename it if you want and place in your 'xlobby\databases' folder.
art
 
Posts: 284
Joined: Sat Mar 20, 2004 8:40 am
Location: Allen, TX

Postby tswhite70 on Fri Apr 28, 2006 3:40 am

Looks like Art beat me to it :cry: ..... I wrote a little vbscript to do the imports, just run it at the commandline with the path to your movies as a variable:

myfile_xlobbyimport.vbs "c:\whatever"

It will output a movies.xml you can copy into the Xlobby\Databases folder. If Windows just opens the vbs when you try and run the script then do:

cscript //nologo myfile_xlobbyimport.vbs "c:\whatever"

http://home.comcast.net/~twhite644/spid ... Import.zip

Updates:
v1.1 - Modified code to only change bad characters in information fields, excluding the Parameter and Coverart fields.

If Xlobby won't load the XML file then chances are you have a folder or file name with an invalid XML character ',&,#. Open the XML with Internet Explorer and scroll to the bottom of the page - you should see the error there. You'll need to rename the file or folder on disk and then rerun the script.

good luck,
tsw
Last edited by tswhite70 on Tue Nov 06, 2007 5:45 pm, edited 3 times in total.
tswhite70
 
Posts: 318
Joined: Tue Jan 06, 2004 3:44 pm
Location: Houston, Tx

Postby Poru3 on Fri Apr 28, 2006 4:34 pm

Great news! Million thanks guys!
I will try the programs out as soon as possible.



Poru3
Poru3
 
Posts: 8
Joined: Wed Apr 26, 2006 9:49 pm

Postby Poru3 on Sun May 14, 2006 5:13 pm

Hi!

I Finally managed to do the tests.

Tswhite70´s vbscript works ok, but for some reason the .xml-file generated by art's program freezes XLobby when "setup"-text was displayed in the start of the program.

Thanks again guys, now I can start to further my hobby with XLobby!


Poru3
Poru3
 
Posts: 8
Joined: Wed Apr 26, 2006 9:49 pm

Postby bfauska on Sun May 14, 2006 7:56 pm

I know that a "Start all over" aproach is not what you are looking for but just to see if you can get even beter results you might want to check out DVDprofiler. It will get more information for your movies than the getMY did. It is worth looking into because it loads into XLobby easily and you would not have to do any wierd multi-part processes to add NEW movies to you collection. It is also free unless you want really hi quality cover scans and no forced ads in the aplication. I used the free happily until I hooked my HTPC up to a projector and then I wanted better cover scans.

Worth a look at least.

Later,
Brian
bfauska
 
Posts: 94
Joined: Thu Jul 21, 2005 10:50 pm

Postby tswhite70 on Wed May 17, 2006 6:08 pm

Poru3 - Glad the script worked for you. The behaviour you describe from using Art's generated XML file is typical of an XML file with bad characters in it. You can test this by opening the XML file in Internet Explorer. Scroll all the way to the bottom and you should see the error. My script does some checking for bad characters which may NOT have been a good idea in this case.

Let's say you have a movie that exists at C:\Movies\Adam & Eve\

My script will replace the "&" (an invalid XML character) with "&". That's great because it lets the XML file load in Xlobby, but it also means that the Parameter field that has the link to the actual movie is now wrong!

Actual Path: C:\Movies\Adam & Eve\Adam&Eve.avi
Parameter Field: C:\Movies\Adam & Eve\Adam&Eve.avi


Below are the character substitutions I perform in the script:
----------------------------------------------------------------------------------
Code: Select all
             XMLoutput_str= regrep(XMLoutput_str,""",""",", ")
                XMLoutput_str= regrep(XMLoutput_str,"…","...")
                 XMLoutput_str= regrep(XMLoutput_str,"—","-")
                 XMLoutput_str= regrep(XMLoutput_str,"–","-")
                 XMLoutput_str= regrep(XMLoutput_str,""",Chr(34))
                 XMLoutput_str= regrep(XMLoutput_str,"'","'")
                 XMLoutput_str= regrep(XMLoutput_str,"ö",Chr(246))
                 XMLoutput_str= regrep(XMLoutput_str,"é",Chr(233))
                 XMLoutput_str= regrep(XMLoutput_str,"ë",Chr(235))
                 XMLoutput_str= regrep(XMLoutput_str,"&","&")
                 XMLoutput_str= regrep(XMLoutput_str,"'","'")


On the one hand we want to make sure the paths are correct, on the other hand we need to make sure the other text (movie name, plot, director, etc) doesn't have bad characters in it without you having to manually parse through it. I'm going to change my script to NOT modify characters in the Parameter or Coverart variables. I'll upload it tonight.

tsw
tswhite70
 
Posts: 318
Joined: Tue Jan 06, 2004 3:44 pm
Location: Houston, Tx

Postby art on Wed May 17, 2006 8:57 pm

Poru3 wrote:... but for some reason the .xml-file generated by art's program freezes XLobby when "setup"-text was displayed in the start of the program...


Can you e-mail me this file art2crazyATyahooDOTcom.
art
 
Posts: 284
Joined: Sat Mar 20, 2004 8:40 am
Location: Allen, TX

Postby Naylia on Wed May 17, 2006 11:16 pm

Why not catalog your movies using DVDProfiler? It's free and easy to use.
Naylia
 
Posts: 530
Joined: Tue Oct 19, 2004 7:50 pm
Location: Boston, MA

Postby tswhite70 on Thu May 18, 2006 12:17 am

Updated the .vbs - see first post for link.

tsw
tswhite70
 
Posts: 318
Joined: Tue Jan 06, 2004 3:44 pm
Location: Houston, Tx

Next