Personal Video Database
English => Support => Topic started by: waltdisneypixar on March 02, 2010, 11:47:32 pm
-
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
-
does anyone know how to import from excel?
Yes, and I wouldn't characterize it as "complicated" or particularly difficult.
i have a .txt with only title and year but when opening in excel , it goes to the same column
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).
-
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.
-
i only want title and year
-
The method is the same for as many columns you would like to have in xls file.
-
i can't import this:
[attachment deleted by admin]
-
Is this what you expect?
[attachment deleted by admin]
-
how did you do that?
???
yes, that is what i want :o
-
Ok, before I start, will you please tell me first did you ever import any file to any database?
-
i don't know what you mean
i created the .xls file i attached
and i tried to import it to PVD but i got an error
-
Did you configure the Excel import plugin to map the first column onto Title and the second onto Year?
And on a general note... Please try to follow directions already posted for such things. If you have difficulty, don't hesitate to ask, but tell us exactly what you did and what happened. It's difficult to provide support when we have to guess what you're doing and experiencing.
-
Part one
[attachment deleted by admin]
-
Part two - the last one
[attachment deleted by admin]
-
Friend of mine had great success exporting from Movie Collector into Ant and then from Ant to PVD.
He had 3500 movies.
Hope this helps.
-
buah, i did the same and it shows a bug error
i have windows 7 x64
i uninstall the program and same bug error
-
Friend of mine had great success exporting from Movie Collector into Ant and then from Ant to PVD.
He had 3500 movies.
Hope this helps.
how?
-
how?
Please be more specific in your requests. If you have no interest in considering a suggestion, then there's no need to respond to it.
buah, i did the same and it shows a bug error
If you did the same thing, there would have been no error. If you won't tell us what you did or what error occurred, there's little chance we can help you.
-
i did the same in the photos
and i got this
[attachment deleted by admin]
-
Friend of mine had great success exporting from Movie Collector into Ant and then from Ant to PVD.
He had 3500 movies.
Hope this helps.
how did he manage to export to ant and then to export to pvd?
i can't be specific because i don't know how to do it.
-
how did he manage to export to ant and then to export to pvd?
I haven't done it myself, but I imagine it went something like this:
1. Install Ant Movie Catalog (http://www.antp.be/software/moviecatalog/).
2. Determine what format AMC requires for data import.
3. Export data from Movie Collector in required format.
4. Import data into AMC.
5. Install Ant import plugin (http://www.videodb.info/bin/plugins/amc.zip).
6. Run the plugin.
-
I haven't done it myself, but I imagine it went something like this:
3. Export data from Movie Collector in required format.
4. Import data into AMC.
let's see if CAD can help
-
If you want anyone to help, you might extend the courtesy of at least considering the advice that has been given. ::)
-
how?
I'll ask him when I see him next. :D
But I imagine the process is along the lines of ricks outline.
-
i knew iiiiiiiiiiiiiiiiiiiiiiiiit
MY PROBLEM WAS:
I DIDN'T HAVE EXCEL
as soon as i installed it, i could import easily from .xls
-
and now if i select 5 films, how can i update with PVD because i only have title and year
and i want imdb and poster
-
i knew iiiiiiiiiiiiiiiiiiiiiiiiit
MY PROBLEM WAS:
I DIDN'T HAVE EXCEL
as soon as i installed it, i could import easily from .xls
Can you please tell me how did you get xls file you couldn't import into PVD? The one you attached here (http://www.videodb.info/forum_en/index.php?action=dlattach;topic=1767.0;attach=512) and I imported it into PVD for you?
-
Excel files can be created by other spreadsheet programs, but the plugin may require that Excel be installed. These other programs, however, can also save files that can be imported by the CSV plugin.
-
Excel files can be created by other spreadsheet programs, but the plugin may require that Excel be installed.
That's what i thought, but I wanted pixar to confirm it? I think I'll find some time to test if PVD plugin needs Excel to be installed. And if it needs it, I'll try if it's enough to have Excel Viewer only to be installed in order to import xls
These other programs, however, can also save files that can be imported by the CSV plugin.
Of course!
-
i knew iiiiiiiiiiiiiiiiiiiiiiiiit
MY PROBLEM WAS:
I DIDN'T HAVE EXCEL
as soon as i installed it, i could import easily from .xls
Can you please tell me how did you get xls file you couldn't import into PVD? The one you attached here (http://www.videodb.info/forum_en/index.php?action=dlattach;topic=1767.0;attach=512) and I imported it into PVD for you?
i got the films.xls from my dad's pc. because he has microsoft excel and i'm not
so when i tried to import, i couldn't because i didn't have microsoft excel.
-
hi
i imported 6000 films from movie collector to PVD
only title and year
is there a way now to select one or maybe more and update it to get imdb plugin and poster plugin?
In movie collector there was an option to update them automatically
-
I'll try if it's enough to have Excel Viewer only to be installed in order to import xls
That would be good to know. If nosta notices this, he could probably tell us. Those who need the capability but don't have Excel could then use a Google or Open Office spreadsheet application, and still be able to import the result with the Excel plugin.
-
is there a way now to select one or maybe more and update it to get imdb plugin and poster plugin?
Please review the topics presented in the Help Index (http://www.videodb.info/forum_en/index.php?topic=1189.0) and read our excellent Wiki (http://www.nimidia.com/pvd_wiki/tiki-index.php) before asking questions like this.
-
you could answer yes or no and a way to show the road
if like i'm asking directions to a place, and you tell me go to the supermarket and buy a map
thank you
for that, don't bother to reply to my question, maybe someone who is willing to help and write can tell me a bit more
thanks to new topics people gets help and others can check the answers
-
if like i'm asking directions to a place, and you tell me go to the supermarket and buy a map
Pixar, I don't know how old (young) you are, but what you said and I quoted is both right and wrong.
Right:
It is common situation in a world of forums to "send someone to supermarket to buy a map", especially when something is offering for free, like PVD is. It is almost polite first to try to search whole information database before asking a question. In most forums it is a rule like this one for example:
Be sure you read all the stickies and FAQs and have done a search at the forum before asking a question.
And here, there are no rules, as far as I know. And I assume it is so because we are treated as grown, polite beings who hasn't to be told what would be nice to behave.
Wrong:
Every question you asked here is already answered, and the only thing for you to do is to read it. So, what you actually asked Rick is:"Hey, you gave me this cell phone for free, but can you tell me how to use it?" and Rick told you "Here is free manual too". Got it? If you paid for PVD, Rick would be wrong and you would be right.
Please don't be offended by this answer, for my only intention is to keep you as PVD user, since there is no better software of its kind, believe me.
Cheers
-
for that, don't bother to reply to my question, maybe someone who is willing to help and write can tell me a bit more
Well, that's different. Most criticize me for answering too many questions. ;)
I have no objection to questions being asked. What I have asked you to do (several times) is to be more specific and include more information about what your objective is, what you tried to do to achieve it, and what happened. Leaving it up to us to guess about those things is both rude and ineffective. The result is likely a long and confusing thread that won't be of any use to anyone else, even if the matter is eventually resolved.
This is a user group community. It works to the extent participants are willing to help each other. For new users, that willingness can be demonstrated by dropping any pretence of entitlement and extending the courtesy of providing the information others need in order to help.
And here, there are no rules, as far as I know.
Now you know. ;)
If you paid for PVD, Rick would be wrong and you would be right.
This is only partially true. Sure, when a licence fee has been paid, then there is some obligation to provide support. The irony is, few commercial products can afford to offer support at a level anywhere approaching that found in user groups like this one. So the trend seems to be towards some sort of user forum support wherever possible. The ones I'm familiar with are not much different than this one—the same rules seem to apply. The only difference is some of the participants are employed by the developer. Some users have difficultly dropping the attitude of "I paid my fee, where's my help," but those that do quickly realize the benefits.