English > Support
Bulk Import Images to PVD from PC?
lilhill:
Thanks a lot!
If I were to get someone to write a bigger completely automated script like I describe in the previous post, how long do you think it would take? Is that even possible?<br><br>
--- Quote from: lilhill on April 01, 2009, 09:16:20 pm ---In the end, I guess I'm going to need a script that will either extract all the metadata from the video files (WMV and MP4) and pair it with a thumbnail then create a MySQL file that can be imported into PVD.
I have a program called GSpot which I am currently using to extract the metadata from the video file, and another program called VideoCharge which I am using to get a screenshot (cover image) from the video files.
The GSpot metadata extractor I have exports the metadata in a CSV file. I have simple script that will remove the columns from the CSV file that I don't want. I then import the CSV file into MS Excel under headers and import the Excel file into PVD. But I have no way of getting the correct cover image files to pair up with the correct video in PVD.
Is there a way to write a script that will do this all automatically in a couple clicks?
This seems very convoluted and involved for the amount of files I'll be processing in the future. Is it possible to write a script that will either:
A) use the two programs I already mentioned to pair the correct cover image with the correct metadata for each video and compile this information in a MySQL database for PVD import?
or
B) write a script that will extract the metadata and cover image itself and compile this information in a MySQL database for PVD import?
If anyone could help me out in either writing a script that would do this or pointing me in the right direction, that would be great.
I can provide the info for what metadata I would like extracted and more details about my project if anyone is willing to take on this endeavor.
I'm all but clueless when it comes to this kind of stuff...
--- End quote ---
rick.ca:
Welcome to the forum, lilhill.
I understand you're talking about custom videos, but I'm otherwise completed baffled as to why you might want to handle them this way. PVD uses MediaInfo to automatically extract video file information. Is there other metadata in your files that GSpot extracts that MediaInfo cannot? If so, how did it get there? PVD includes a screenshot maker (and 0.9.9 an automatic screenshot maker, although it presently works only for AVI's). If you want to include your existing screenshots, I suggest you consider using them as posters—which don't otherwise exist for custom videos.
Reset, if you're willing to write a script, it should be done in a way that it would be versatile and benefit the most users. This is something that some of us have wanted for some time. My suggestions:
* If you're only going to do one version, it should be one for 0.9.9.
* Match image files first by video filename, then by Title (or Title + Year) if there is no video file.
* Allow the user to specify the image type to be saved as—poster, cover or screenshot. This could be done, of course, by using three different scripts. If that's to much trouble, then I think most users would want this for posters.
* Add the imported images, rather than replacing existing images. If the script can't handle multiple images per video, it could still be run multiple times on different image file sets.
rick.ca:
--- Quote from: lilhill on April 01, 2009, 09:16:20 pm ---I have a program called GSpot...
--- End quote ---
I removed your separate topic which was a duplication of this post. Sometimes starting a separate topic is a good idea, but duplication is not. Let's see where this one goes first.
lilhill:
Hi Rick... Thanks for the welcome!
I'm working on a project which might be very large in a few years. Soon I'll be loading many video clips into PVD. These clips will be anywhere from a few seconds to hours long. The database will continue to grow and grow.
I was not aware of the MediaInfo program (?) or the screenshot maker. Unfortunately the very large majority of the files I'm going to be dealing with will be WMV and AVI. Any idea when the screenshot maker will be able to accommodate other file types?
As for the online part, I am going to need to collaborate with other people about the videos and video clips. I will also need them to be able to add/remove/edit information in PVD as well.
I guess the script that Reset is willing to make will work quite well in integrating with PVD and pairing the correct poster with the correct video.
How do I go about running MediaInfo to extract metadata from the custom files?
Thanks for your help!
Sorry for the duplicate.
lilhill:
I've got to go to work. I'll be back in about 4 hours to check in and answer questions. Maybe sooner.
Thanks for the help guys. I really appreciate it!
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version