English > Support
[SOLVED] How to overwrite date added when importing from Csv
deazo:
Yes I have since switched to using excel import and it's much better.
I will have to modify the template later, I have also read the instructions you pointed me to, I had selected them before, just so you know that I searched the forum before posting!
The problem here that I am having is that the images generated do not contain the Movie ID but another number that I cannot find anywhere in the database.
rick.ca:
--- Quote ---The problem here that I am having is that the images generated do not contain the Movie ID but another number that I cannot find anywhere in the database.
--- End quote ---
Maybe it's mid (the internal database index number), I don't know. If so, you can use the Excel file to create a batch file to rename the images... i.e., rename [Title]_*.jpg [ID].jpg.
deazo:
Hi Rick and all,
I have now successfully created a new database file :) .
The movies ID's are the same than in the original corrupted database.
The list of posters that I had generated from the corrupted database contains the name of the movie and the Internal ID.
This internal movie ID is NOT the same in the new database, even after re-indexing.
So imgid is unable to add the posters to my new file.
I need to rename the image files in order to get them into my new database.
From Buah's post http://www.videodb.info/forum_en/index.php?topic=1734.0 it looks like he is using the ID (and not the internal ID), so I am unsure about what ID I should use when I rename the image files. Would you know?
My main question however is HOW do I rename the files, I am completely useless when it comes to batch files and scripting, can you help me with detailed information?
I am attaching two text files. The first gives you the list of movies with ID's and Internal ID's. The second gives you a list of the image files generated from the folder they are in.
There are sometimes images that belong to the same film.
What is the best way of doing this?
I am so glad I am moving away from using a corrupted database file, but I need these posters so bad, I had invested too much time in finding them!
[attachment deleted by admin]
buah:
I can't remember if it's possible to assign more than one poster to a title this way.
I did use (non-internal) IDs for importing, but I was lucky, because they were exported from CATVids with those IDs.
I think you could try to use technic to sort movies by title, then to export them to excel, then to add a column with paths to images, then te reipmort such xls file to a new database.
It's necessary for you to configure PVD to save images outside database, and to define folders in PVD with images.
I would first try to assign a couple of images in PVD, then to export it to xls, to check out what is the syntax and proper path for images.
Sorry, but it's very hard for me to be mor clear in english about this.
deazo:
I did not realize I could actually try to use "image path" to import the posters...
Now my question is how can I export the image path from pvd (I need to export it from the original corrupted database) ?
Thanks!
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version