English > Support
[SOLVED] How to overwrite date added when importing from Csv
buah:
--- Quote from: deazo on July 19, 2010, 05:33:15 pm ---
I did not realize I could actually try to use "image path" to import the posters...
--- End quote ---
When you import such xls file, and you afterward define for PVD to save images in database, it should work.
--- Quote --- Now my question is how can I export the image path from pvd (I need to export it from the original corrupted database)?
--- End quote ---
If you can do that it could be perfect. But if you can't, you could copy paste a list of posters in a column I described in a post above, and than paste path in every cell of a column (C:/.../Shared documents/PVD/Images/, for instance).
Concatenating two columns (the first is folder path, and the second is image name) is also considerable.
Sorry for my English.
deazo:
Sounds good thanks Buah.
This is not going to be simple as some of my movies do not have a poster file, and also the alphabetic order is not perfect...
Also, what is the name of the "image path" in the import plugin? I can't find it in the list available.
buah:
--- Quote from: deazo on July 19, 2010, 07:06:05 pm --- Also, what is the name of the "image path" in the import plugin? I can't find it in the list available.
--- End quote ---
Honestly, I can't remember, and you have to discover it. That's why I told you to assign some posters with saving 'em outside of PVD option set. Then export only list of entries with posters, edit it in Excel, and you should find out the name of the column.
--- Quote from: deazo on July 19, 2010, 07:06:05 pm --- This is not going to be simple as some of my movies do not have a poster file, and also the alphabetic order is not perfect...
--- End quote ---
I would import then in two steps.
1. Export only entries with posters from the corrupted database - import to a new database (assigning path in xls, previously)
2. Export entries without posters from the corrupted database - import to a new database (without "path" column in xls)
deazo:
Yes the two steps are a good suggestion thanks.
--- Quote ---Then export only list of entries with posters, edit it in Excel, and you should find out the name of the column
--- End quote ---
I have tried that but no export seem to give me any image path, unless I have to build it with the export manual that Nostra has put together?
Still, I cannot find any import field (in the configuration menu for the import plugins) that could even resemble an image path...
rick.ca:
--- Quote from: deazo on July 19, 2010, 02:17:30 pm ---The list of posters that I had generated from the corrupted database contains the name of the movie and the Internal ID...
--- End quote ---
Forget about the "Internal ID"—it has nothing to do with this process and won't help you.
--- Quote ---I have tried that but no export seem to give me any image path...
--- End quote ---
Neither will this. Poster paths cannot be exported or imported.
The only tool available for importing images is IMGbyID. It can only work if the image is named by ID, and the new database has the same ID assigned to the target movie. This is not the case illustrated by your two text files—the ID's do not match.
Hopefully, you still have a copy of the corrupt database—with the images saved in the database. You can then start over and...
1. Delete any existing external images.
2. Reindex movies.
3. Change the option to save images outside the database.
4. Export the data and re-import to create a new database (with the same ID's!)
5. Rename the images from [Title]_[ID].jpg to [ID].jpg.
6. Use IMGbyID to import the images.
Alternatively, use the new database and external images you have now, but rename the images using the current (i.e., correct ID)...
1. Reindex movies—to ensure they all have a unique ID.
2. Export a list of [ID] and [Title], and import this into Excel.
3. Import poster list.txt (assuming this is an accurate list of the externally saved images) into Excel; based on the "_" character, extract [Title] to a new column.
4. In the second sheet, use the vlookup function to lookup the title in the first sheet and get the ID.
5. In a new column, create a batch command to rename the image file (i.e., "rename [original name] [ID].jpg").
6. Copy the batch command column to a text file, rename that file with a .BAT extension and run it in the image directory.
7. Use IMGbyID to import the images.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version