English > Support

How to import 6000 films from movie collector to PVD?

(1/7) > >>

waltdisneypixar:
hi

i really want to use this program but i have a database of 6000 films

and it's way to complicated to import it.

does anyone know how to import from excel?

i have a .txt with only title and year but when opening in excel , it goes to the same column  ??? ???

i have read other posts about people trying but it doesn't show step by step

rick.ca:

--- Quote ---does anyone know how to import from excel?
--- End quote ---

Yes, and I wouldn't characterize it as "complicated" or particularly difficult.


--- Quote ---i have a .txt with only title and year but when opening in excel , it goes to the same column
--- End quote ---

If you open a TXT file from the File menu of Excel, it automatically launches its Text Import Wizard. If used properly, that will properly import most common text file formats into columns.

Before you do that, I suggest you consider more carefully exactly what information you want to capture. If you have a "database of 6000 films," that surely includes more than just Title and Year. You don't need any information you're going to download from IMDb (or elsewhere) anyway, but you should make an effort to retain whatever personal information you may have recorded (e.g., date viewed, rating, comments, etc.). Although you can make changes later, it's easier to consider at the start exactly what is going to be included in the database, what data sources are going to be used, what custom fields need to be included, etc.

If your media is on a HDD, the file scanner should be able to match the files to the database records—if the same Title and Year are used in the file pathnames. If this is not the case, it would be a good idea to include the file pathnames in the import as well. If your media is not on a HDD, it will be even more important to capture whatever it is you use to identify the media (i.e., a label or index number).

buah:
I have imported more than 5k movies from Excel. It's all about how to get proper xls file to be imported.
My first suggestion would be - don't hurry! Make a strategy for importing. I prepared my xls file for almost a month, and than imported it to PVD in less than hour. After that, I downloaded IMDb data for all movies in a day.
To get proper xls file, the best thing is to export from Movie collector to a csv, or xml even better - all possible fields, then import it to Excel, than save as xls.
Inspect PVD fields and recognize correspondent columns in xls. Find which columns have non-existent twin in PVD. In such case you can define Custom Field types in PVD. Be aware what field type in PVD is expected -number, list, memo, text, etc... But, if you ask me, when you reach this point, ask for support on this again. Step by step is the best method.

waltdisneypixar:
i only want title and year

buah:
The method is the same for as many columns you would like to have in xls file.

Navigation

[0] Message Index

[#] Next page