Hi there, thanks for looking at our project!
We have an auto classified ads website. On our site, all the listings are contained in a very simple, tab-delineated text flatfile. I have attached a copy of this file for your reference. The field order of our database is here: [url removed, login to view]
On our site, we also have a directory filled with .AVI files. These are video tours of each vehicle. Each AVI filename is the same as the vehicle ID that each vehicle has in its record in the database. The vehicle ID is field 9, so if a record's field 9 is c4l_M2977A, then there is an AVI file in that directory called c4l_M2977A.avi.
What we need is:
- A script which will upload the AVI files to our YouTube account. For each AVi file, the script must "fill in" the YouTube title, description, and tags with the text contained in the fields of that record of the database.
So, for example, for the YouTube video, the title might be:
[year] [make] [model], [price] at [dealerID] in [city], [state]
and the YouTube description might be:
[city], [state] [zip]
The script should have two other functionalities:
1.) If the required .AVI file is not present in the directory, then it should SKIP the record (i.e., not try to upload it).
2.) If the script has already successfully uploaded a record/AVI in the past, it should also SKIP that record. (i.e., not try to upload it again).
That's it! Thanks and we look forward to working with you.