ant movie catalog

Help each other out

ant movie catalog

Postby ricoceleron on Tue May 18, 2004 2:08 pm

Hi everybody..please i need help on how to import my movie database created with antmoviecatalog in xlobby?
http://www.antp.be/software/moviecatalog
i have no clue on how to export it then re-import it in xlobby??has somebody already done it?
thanx for our help...
ricoceleron
 
Posts: 8
Joined: Sat May 01, 2004 12:06 pm

Postby dalanik on Tue May 18, 2004 2:35 pm

I tried but failed.... Everything seemed OK, the XML file seemd OK, but XLobby would read up to 30% and than just stop responding. I can send you the definition file I used if you want to try. The only thing that you have to do manually is to remove all references to <img src= in resulting xml file (Ant inserts those and I didn;t find a way to remove it except manually) - that is - if you want to use cover art from ant.

just save this as a html template in your ant templates folder and go to export->html.

I guess that in Ant, there are some forbidden characters, so when it reaches them, xlobby just locksup. I didn;t have time to investigate further.


<?xml version=1.0 encoding=UTF-8?>
<database>
<sortorder>sorttitle</sortorder>
<sortable>
<sort>title</sort>
<sort>sorttitle</sort>
<sort>genre</sort>
<sort>director</sort>
<sort>year</sort>
<sort>rating</sort>
</sortable>
<template>movies</template>
<paths>
<path>D:\My Documents\BURN</path>
<path>D:\My Documents\Video</path>
</paths>
$$ITEM_BEGIN
<item>
<parameter>F:\$$ITEM_ORIGINALTITLE.avi</parameter>
<coverart>D:\Covers\$$ITEM_PICTURE</coverart>
<display>$$ITEM_ORIGINALTITLE</display>
<type>movie</type>
<offline>True</offline>
<information>
<name>$$ITEM_ORIGINALTITLE</name>
<title>$$ITEM_ORIGINALTITLE</title>
<sorttitle>$$ITEM_ORIGINALTITLE</sorttitle>
<director>$$ITEM_DIRECTOR</director>
<runtime>$$ITEM_LENGTH</runtime>
<plot>$$ITEM_DESCRIPTION</plot>
<year>$$ITEM_YEAR</year>
<genre>$$ITEM_CATEGORY</genre>
</information>
</item>
$$ITEM_END
</database>



Here is an example of output file:



<?xml version=1.0 encoding=UTF-8?>
<database>
<sortorder>sorttitle</sortorder>
<sortable>
<sort>title</sort>
<sort>sorttitle</sort>
<sort>genre</sort>
<sort>director</sort>
<sort>year</sort>
<sort>rating</sort>
</sortable>
<template>movies</template>
<paths>
<path>D:\My Documents\BURN</path>
<path>D:\My Documents\Video</path>
</paths>

<item>
<parameter>F:\One Flew Over the Cuckoo's Nest.avi</parameter>
<coverart>D:\Covers\<img src="videos_133.jpg"></coverart>
<display>One Flew Over the Cuckoo's Nest</display>
<type>movie</type>
<offline>True</offline>
<information>
<name>One Flew Over the Cuckoo's Nest</name>
<title>One Flew Over the Cuckoo's Nest</title>
<sorttitle>One Flew Over the Cuckoo's Nest</sorttitle>
<director>Milos Forman</director>
<runtime>133</runtime>
<plot>Murphy has been dating a fifteen year old (fifteen going on thirty) and is sentenced for a short term for contributing to the delinquency of a minor. Rather than spend his time in jail, he convinces the guards that he's crazy enough to need psychiatric care and is sent to a hospital. He fits in frighteningly well, and his different point of view actually begins to cause some of the patients to progress. Nurse Ratched becomes his personal cross to bear as his resistence to the hospital routine gets on her nerves.</plot>
<year>1975</year>
<genre>Drama</genre>
</information>
</item>

<item>
<parameter>F:\No Man's Land.avi</parameter>
<coverart>D:\Covers\<img src="videos_132.jpg"></coverart>
<display>No Man's Land</display>
<type>movie</type>
<offline>True</offline>
<information>
<name>No Man's Land</name>
<title>No Man's Land</title>
<sorttitle>No Man's Land</sorttitle>
<director>Danis Tanovic</director>
<runtime>90</runtime>
<plot>In 1993 during the war in Bosnia, a relief unit of Bosinian soldiers gets lost in the night fog and in the morning, inadvertantly find themselves in the direct line of Serbian forces. The unit is quickly cut down except for one soldier, ici, who was lucky enough to fall into a trench in no man's land with only a relatively minor wound. While working out his situation, a veteran Serb solider and his green partner, Nino, survey the site and prepare a landmine boobytrap under the body of ici's comrade, era. ici attacks and kills the veteran and captures Nino even though they are both in danger between the warring sides. The situation is made much worse when ici is revealed to be alive, but remain on top of the mine to prevent the death of them all. Now, this trio must find some way to escape this hopeless situation even while other factors like Sergeant Marchand of the UN Peacekeeping forces wages his own frustrating effort to rescue the trio with the help of an aggressive TV reporter. Yet the situation looks bleak while indifferent UN officers, superficial reporters and especially the deep seated mutual ethnic hatred of the trench dwellers work to undermine any chance of a sane solution in this absurd theatre of war.</plot>
<year>2001</year>
<genre>Comedy</genre>
</information>
</item>


...

so you see that <img src=" has to be deleted, and also closing ". I do this by searching for .jpg" and replace it with .jpg

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

Postby ricoceleron on Wed May 19, 2004 11:08 am

thanx for trying anyway..it doesn't work..... :cry:
i left a message on antmovie catalog forum..willl see..
:wink:
ricoceleron
 
Posts: 8
Joined: Sat May 01, 2004 12:06 pm

Postby C-moi on Wed May 19, 2004 12:42 pm

Badubo has found a solution in french forum
Change your line
<coverart>D:\Covers\$$ITEM_PICTURE</coverart>

by
<coverart>D:\Covers\$$ITEM_PICTUREFILENAME</coverart>

Then you must change all "&" and ' include in the xml file
' -> &apos;
& -> (i forgot, excuse me)
You must delete the movies.xml file in the template folder.
Hope Badubo help you.
C-moi
 
Posts: 164
Joined: Fri Apr 23, 2004 6:58 am
Location: France

Postby dalanik on Wed May 19, 2004 12:57 pm

C-moi wrote:Badubo has found a solution in french forum
Change your line
<coverart>D:\Covers\$$ITEM_PICTURE</coverart>

by
<coverart>D:\Covers\$$ITEM_PICTUREFILENAME</coverart>

Then you must change all "&" and ' include in the xml file
' -> &apos;
& -> (i forgot, excuse me)
You must delete the movies.xml file in the template folder.
Hope Badubo help you.


I kew I was close to the solution.... I solved the PICTURE with search/replace of tags in xml file, but i supposed that there are some forbidden characters but didn't know which ones...

BTW, why must the template be deleted?
dalanik
 
Posts: 885
Joined: Mon Apr 19, 2004 12:35 pm
Location: Prague, Czech Republic

Postby C-moi on Wed May 19, 2004 6:00 pm

the template show the path to an .xml file created by DVD profiler and the folder of DVD profiler.
If i delete this file all works : if the file is in the template folder, it don't work !
C-moi
 
Posts: 164
Joined: Fri Apr 23, 2004 6:58 am
Location: France

Postby badubo on Wed May 19, 2004 8:04 pm

Hi,

one thing you need to do is to convert the exported file to UTF-8 (usefull if you use non-english caracters)

You can download a little utility I made :
http://users.skynet.be/fa426932/temp/ant2xlobby.exe

then, invoke :
"ant2xlobby ant.html ant.xml"

where ant.html is the exported base

note that this soft converts by itself the caracters like ' and &, so do not convert them before (or you will have a bad formated dba)

before trying this base,test it with your browser.

Hope this help
badubo
badubo
 
Posts: 505
Joined: Mon May 03, 2004 7:33 pm
Location: Belgium

Postby dalanik on Thu May 20, 2004 8:58 am

Whoa! It works! :-) I believe also that : sign is not allowed in filenames :-) So I had to delete it from ANT database manualy... but otherwise fine!

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

Postby badubo on Thu May 20, 2004 10:57 am

Hello Dalanik,


Did you encounter any problem with ':' ?
Because in my base I let it and I've no problem at all.
I you had problems, please tell me which, and I will adapt the converter.
badubo
 
Posts: 505
Joined: Mon May 03, 2004 7:33 pm
Location: Belgium

Postby dalanik on Thu May 20, 2004 12:22 pm

badubo wrote:Hello Dalanik,

Did you encounter any problem with ':' ?
Because in my base I let it and I've no problem at all.
I you had problems, please tell me which, and I will adapt the converter.


No, not the converter - but i use film name as a filename for .avi files. and ofcourse, the : sign is not allowed there :-)
dalanik
 
Posts: 885
Joined: Mon Apr 19, 2004 12:35 pm
Location: Prague, Czech Republic

Postby dalanik on Fri Jul 21, 2006 12:17 pm

Hello there, hopefully French users or other Ant (advanced) users :-)

I have a question. Since I'm changing the server wheich holds my movies (moving it from a PC to Network Hard Drive) I'd need to change paths in all my movies for XLobby.

path to the film is stored (as standard in ant) in URL field. now i have, i.e.

\\VISUAL02\htpc\movies\film\film.avi

and I need to change that to new net drive

\\NETCENTER\htpc\movies\film\film.avi

so the question is:

Is there a way to batch change all paths in the URL field? If I have to do it manually for 600 films, I'll just kill myself :-)

I can always do it in the exported XML (by XAnt) in text editor with search/replace, but that would not be automated...

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

Postby sagitaz on Fri Jul 21, 2006 3:14 pm

hi !!

open AMC and go to the scripting. create a new script and paste this :

// GETINFO SCRIPTING
// Replace URL

program ChangeURL;
var
s: string;
begin
s := GetField(fieldURL);
s := StringReplace(s, '\\VISUAL02\', '\\NETCENTER\') ;
end.


save the script on you're script folder. close and reopen scripting windows and execute the script for all movies ( check the url checkbox ).
sagitaz
 
Posts: 114
Joined: Mon Jul 05, 2004 11:17 pm

Postby dalanik on Sat Jul 22, 2006 6:19 am

Oh boy, You guys are great, and AMC is great! I tried along the lines of exporting to CSV and changing in editor and thein importing back csv but it always imported as new records...

I didn't even know about scripting in AMC.... Cool!

thanx! Merci!

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