Page 2 of 3

Posted: 2008-08-27 19:06:08
by bad4u
uhmm.. well, maybe my question was not very clear, or automatic translators tell nonsense or you did get me wrong ;)

Which script(s) do you use to export your mvc catalog to CSV and/or XML ? Please link to this script..
In which folder are movie pictures stored ? I guess it is always ..\Affiches\ , is it?

You probably used a script from mvc forum, but as this is french too, it's hard for me to understand and find it. I ask because it seems quite easy to change these scripts and add the pictures to mvc export - eventually even a direct export to AMC XML format is possible.

Maybe Antoine could help out with a short translation ? ;)

Posted: 2008-08-27 19:36:53
by antp
"divxdvd" >> ce script que tu utilises, tu peux nous le donner ? Comme le dit "bad4u" c'est peut-être facile d'ajouter ce qui manque (enfin, je n'en suis pas si sûr :D)

Posted: 2008-08-27 21:08:12
by divxdvd
thanks at you for your message:Bad4u and antp ! (Youpee !)
merci à bad4u pour son aide.. et grand merci pour la traduction de antp !!!
Non je ne peux pas vous donner ce script car il est integré au logiciel et n'a rien voir avec les scripts allocine, etc..
Mais c'etait une bonne piste, je vais voir si on peut le récuperer son script excel !!!
merci pour votre aide
bonne soiree

Posted: 2008-08-27 21:29:17
by bad4u
I probably will release a script tomorrow night that exports MVC database directly to AMC XML database file including cover pictures (if not tomorrow then friday).

Posted: 2008-08-27 21:38:34
by antp
divxdvd >> comment ça "intégré" ? :??: Il était fourni avec le soft ? Sinon tu as bien dû l'ajouter d'une manière ou d'une autre, non ?
bad4u >> how do you do that ? :??: You learned scripts for that program too ? :D

Posted: 2008-08-27 22:17:46
by bad4u
antp wrote:bad4u >> how do you do that ? :??: You learned scripts for that program too ? :D
Sure :D

That program uses a Windev Hyperfile Database format with lots of indexed .fic files instead of a single file, so it was impossible to access movie information directly from the database. Inside the program I did not find any useful export functionality - you could export to Excel, Word and XML, but ONLY the list with movie titles, no details at all. Maybe I just didn't find it, but I still don't think so. By default there seems not to be a HTML export even.. (or is it missing on the "20 movies testversion" only?)

Visiting their forum, I had the feeling they don't really like to release or at least to document these things (what could be added through scripts) - and that's quite poor for a program that costs 29/38 Euro. But maybe I'm doing them wrong and I've overseen all this (as I said it's all french - and I don't trust Google translator).. ;)

Posted: 2008-08-28 21:40:55
by bad4u
Here is a script for MyVideoSoft that exports the database to AMC's XML file format.

Simply copy the script into mvs scripts folder and run it once. Now you will have a file "AMC_export.xml" in your mvs folder. Copy this file and all your movie pictures together into your \Ant Movie Catalog\Catalog\ folder (or where you want it). Open the XML file on AMC. Enjoy.. if it works ;)

MVS 2 AMC Export Script , Version 0.9 (new version available, see below)

Please let me know if it works for you or if something is missing (as I do not have a big database on mvs, I cannot test it in detail) !

Posted: 2008-08-29 08:03:29
by antp
bad4u wrote:Here is a script for MyVideoSoft that exports the database to AMC's XML file format.
:grinking: well done, I hope it will solve the problem :)

Posted: 2008-08-29 17:46:50
by divxdvd
:grinking: :grinking: :grinking: thousand thanks ! :grinking: :grinking: :grinking:
i'm very bad in english ! Escuse me
your scipt is very good but when i open the "...xml" work with your script: He don't open ?
My work: created the folder in catalogs (AMC) and in the *.xml and the movies pictures. I "open" the fichier xml with AMC
*****(dans le dossier que j'ai cree, il y a un dossier avec toutes les affiches et le fichier xml créé. Est-ce bon ?) *****
The message is:
ERROR
Invalid XML Element: Unexpected character in properties declaration (found)

In my titles, i have a many caracters like:
&, 1...0, ", , , :, @, !, ?, ...

This problem is perhaps here !

Many thanks, your work is magnifical!
Thanks,
thanks,
thanks,
thanks,....

Excuse moi, triste francais, mais je parle anglais comme un cochon !!! snif ! :cry:
Merci aussi à toi, antp, pour la traduction mais toutes mes excuses, je suis vraiment une "tole" en anglais ! :cry:

Posted: 2008-08-29 18:08:27
by bad4u
Could you email me this amc XML file , so that I can do some tests ?
See private message for mail address, please.

Posted: 2008-08-29 18:26:39
by antp
Ou envoie le fichier XML plutôt à moi, ça sera plus facile comme je parle français et que tu as mon adresse :D
(= Or rather send to me the XML file, it will be easier as I speak French and you have my address)

Posted: 2008-08-29 18:26:55
by divxdvd
oui il est completement integre au logiciel mvs !
J'ai recu ce message du webmaster de mvs:
MessagePosté le: Jeu Aoû 28, 2008 10:36 am Sujet du message: Répondre en citant
Hélas, il n'y a pas de script pour l'export Excel, çà fait partie intégrante de MVS.
bad4u wrote:
antp wrote:bad4u >> how do you do that ? :??: You learned scripts for that program too ? :D
Sure :D

That program uses a Windev Hyperfile Database format with lots of indexed .fic files instead of a single file, so it was impossible to access movie information directly from the database. Inside the program I did not find any useful export functionality - you could export to Excel, Word and XML, but ONLY the list with movie titles, no details at all. Maybe I just didn't find it, but I still don't think so. By default there seems not to be a HTML export even.. (or is it missing on the "20 movies testversion" only?)

Visiting their forum, I had the feeling they don't really like to release or at least to document these things (what could be added through scripts) - and that's quite poor for a program that costs 29/38 Euro. But maybe I'm doing them wrong and I've overseen all this (as I said it's all french - and I don't trust Google translator).. ;)

Posted: 2008-08-29 18:30:08
by divxdvd
antp wrote:Ou envoie le fichier XML plutôt à moi, ça sera plus facile comme je parle français et que tu as mon adresse :D
(= Or rather send to me the XML file, it will be easier as I speak French and you have my address)
Je viens de lui envoyer mais veux-tu que je te l'envoie ?
I'm a man qui talk englist like a BIG cow ! :/

Posted: 2008-08-29 18:53:19
by bad4u
It seems to be caused by " " (quotation marks) only, that are used on description fields and get mixed up with the XML structure.

I'll fix that and the import of (Néant) if there is nothing on the field.

Posted: 2008-08-29 19:39:31
by bad4u
Here is a new version 0.9.5 of MVS 2 AMC Export Script . I fixed the quotation marks import and the import of (Néant) if there are no names on actors, director, etc.

Please test again. If there is still a problem I will need the new XML file ;)

Posted: 2008-08-29 19:57:04
by divxdvd
i'll test it and i write the news !
thanks
:grinking:

Posted: 2008-08-29 20:11:42
by divxdvd
always this problem !
The importation pass 1 seconde and ... ERROR ???
:cry:

Posted: 2008-08-30 01:51:42
by bad4u
I hope I found all the problems now :D

MVS 2 AMC Export Script , version 0.9.8 (new version see below)

I fixed the quotation marks (") from description and comments import, but you had these special character even on translated titles and other fields - so the import still failed on last script version.

Posted: 2008-08-30 07:52:08
by divxdvd
YES YES YES YES YES !!
:grinking: :grinking: :grinking: That's the magical scipt !!
many thanks
je te rappelle plus tard, je pars faire dodo (i go to sleep) ! lol !
ciao and many congratulations !
:wink: :grinking: :hihi: :wink: :grinking:

Posted: 2008-08-30 10:46:44
by bad4u
Hint: If you want to assign a field to another field on AMC, you can use "Import from AMC" instead of just opening the XML database file.