Youtube Data Extractor (to mysql)
Project ID:
546031Project Type:
FixedBudget:
$30-$250 USD
Project Description:
1. Okay guys i don't know how to get the solution but i can give you the problem..Problem:
1. We save youtube video ids into our database.. Example (id= yT-F5QznjrA )
2. We also save the videos (thumbnail, description, tags, and title) into our database. Each one is saved on a database table.. (table=thumbnail) (table=description) (table=image) (table=tags)
3. Some files have been cached to our database with no problem. But some haven't
Bug: Our file used to crawl was poorly coded and now we have the (video id) but missing all the other details for the database tables (title, description, tags)
Solution: I can give you a list of the (youtube id) that are missing. But we need the (description, tags, and titles) for these videos ids.
However i need to figure out how to keep the current structure of our videos and get those details saved to our database..
Warning: There is thousands of missing details (possibly 10,000 ) plus.. I need these details inserted into the database.. Without messing up our database..
Skills required:
Data Processing, Perl, PHPAdditional Files:
snapshot.JPG snapshot2.JPG
Public Clarification Board
3 messages
-
F21Inc
http://media.friends21.com/youk/flv_video.sql
here is the sql file guys.. Now that's all i got.. but notice the snapshots (some videos have all tables contents) some dont
You can download it (it's 150mb) and 200,000 tablesover 2 years ago
-
F21Inc
http://media.friends21.com/flv/
http://media.friends21.com/flv2/
http://media.friends21.com/flv3/
These are the video ids,, these are the video we need the (description, tags, titles) saved in the db
Some of these flv's have the details and some dont, ,some don't.. (all were modified after July 11th)over 2 years ago
-
F21Inc
* I can provide the winner of the bid (mysql cpanel details)
* Some of the db tables are old. And can be erased . The database tables older than July 13th.
* I can only provide you with phpmyadmin details. When you login and view the database table, you will see the missing contents from the tables..
This is all i can do for you.. You can always organize the files in phpmyadmin. But you would have to see how to get all the details with little help from me..over 2 years ago
Awarded Bids
All Bids ()
SigmaVisual
|
SigmaVisual
From Pakistan
Gold Member
Offline
|
General Freelancer Orientation (80%, 90th percentile)
Foundation EUFreelance.com Member
$250
in 4 days
over 2 years ago
We can help in your project, please check PMB to see our related experience.
rsdsoft
|
rsdsoft
From Russian Federation
Offline
|
Foundation EUFreelance.com Member
$100
in 2 days
over 2 years ago
I already developed such tool. Please check PMB.
guarantee job done , please check pmb
Please check for my credentials. Thank you
zhukaster
|
zhukaster
From Ukraine
Offline
|
General Freelancer Orientation (75%, 81st percentile)
Foundation EUFreelance.com Member
$100
in 3 days
over 2 years ago
I've worked with youtube api.
don't hesitate to contact me.
Thank you.
wangfei001
|
wangfei001
From Australia
Offline
|
Foundation Freelancer.co.uk Member
$200
in 2 days
over 2 years ago
hi,please check pmb,
peteruk
|
|
peteruk
From United Kingdom
Offline
|
US English Level 1 (98%, 88th percentile)
Freelancer Orientation (80%, 97th percentile)
HTML Level 1 (85%, 92nd percentile)
JavaScript Level 1 (93%, 99th percentile)
PHP Level 1 (78%, 89th percentile)
SQL Level 1 (83%, 45th percentile)
Unix Level 1 (93%, 77th percentile)
Employer Orientation (80%, 99th percentile)
General Freelancer Orientation (95%, 100th percentile)
Foundation EUFreelance.com Member
Foundation TycoonTalk.Freelancer.com Member
$200
in 1 day
over 2 years ago
Should be able to easily do this for you. I own a site which grabs data from youtube like this and have a lot of SQL experience.
Peter
grap6b
|
grap6b
From India
Offline
|
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$100
in 2 days
over 2 years ago
***PLEASE CHECK PMB***
vsona
|
vsona
From India
Offline
|
General Freelancer Orientation (75%, 81st percentile)
$150
in 5 days
over 2 years ago
Greetings! Thank you very much for giving us an opportunity to bid for your project. Please refer to PMB for our detailed bid.
Please check PM
The bug your crawler has most likely experienced was YouTube blocking it by asking for a captcha (image verification) form. I have done what you are asking for before although for a different purpose.
onlinehub
|
|
onlinehub
From India
Offline
|
General Freelancer Orientation (75%, 81st percentile)
Foundation EUFreelance.com Member
$50
in 2 days
over 2 years ago
i can do this.. please see pmb
developer84
|
|
developer84
From Cuba
Offline
|
Foundation EUFreelance.com Member
$40
in 0 days
over 2 years ago
Hi
I can do this job professionaly.
check pm please
InnoConsulting
|
|
InnoConsulting
From India
Offline
|
Foundation LimeExchange Member
$250
in 7 days
over 2 years ago
We can help you in this for sure.
ITHacker
|
ITHacker
From Canada
Offline
|
General Freelancer Orientation (75%, 81st percentile)
$200
in 5 days
over 2 years ago
Your problem can be solved by a Perl script that reads through your database looking for YouTube Ids that do not have the metadata information (title, description, keywords). For each id with missing info, bring up th... more
Your problem can be solved by a Perl script that reads through your database looking for YouTube Ids that do not have the metadata information (title, description, keywords). For each id with missing info, bring up the You Tube page for that video and parse the web page source to get the metadata information. Update the record with the found information. Alternatively if you don't want the database updated directly, write a csv file with the You Tube id and the metadata. This program could take a long time to execute if You Tube places barriers to "spider" programs meaning the progam would need to insert delays every time it went to You Tube to get the info.
This project sounds like fun. I can do this.
IT Hacker less
sharara
|
sharara
From Morocco
Offline
|
Foundation EUFreelance.com Member
$120
in 7 days
over 2 years ago
i'm new in this web site , but i have a large experience in web programing . i hope get this project
Hi!
I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.
I have 2 year experience in this field .
esayward
|
|
esayward
From United States
Offline
|
Freelancer Orientation (75%, 94th percentile)
$100
in 7 days
over 2 years ago
All I have to do is read your table, find all records missing info, then for each record check youtube for the missing info, and then update the table.. then move on to the next record.. I would just require the curren... more
All I have to do is read your table, find all records missing info, then for each record check youtube for the missing info, and then update the table.. then move on to the next record.. I would just require the current script to see how it was written, I may want to update that as well, otherwise you will not solve the root of the problem. I estimate 7 days only because I am busy, however this is a simple task. feel free to call me 6087821677 -Eric less
gapz101
|
|
gapz101
From Philippines
Offline
|
Foundation EUFreelance.com Member
$250
in 10 days
over 2 years ago
hello,
i can do this script customization with youtube, extracts data like tags, comments, etc..
Please check your PM
Worked on youtube stuff earlier.
I can do it in 1 day
towork4u
|
|
towork4u
From India
Offline
|
Foundation EUFreelance.com Member
$125
in 5 days
over 2 years ago
Hi,
i did about to same type of work earlier for youtube.
Please have a look to your PMB
Thanks,
Ashish
bipinjnath
|
bipinjnath
From India
Offline
|
Freelancer Orientation (80%, 97th percentile)
General Freelancer Orientation (90%, 98th percentile)
$150
in 5 days
over 2 years ago
Hello Sir,
I am interested in working on your project.If you offer me the job, I will do my level best to give you the 100% accurate result within the given time.
I am happy to discuss further. You can reach me a... more
Hello Sir,
I am interested in working on your project.If you offer me the job, I will do my level best to give you the 100% accurate result within the given time.
I am happy to discuss further. You can reach me anytime on skype and Google Talk. Waiting for your reply
Thank You,
Bipin J Nath less
