Fill SQL Lite DB with 270 records, < 1 min record

Completed Posted Dec 2, 2014 Paid on delivery
Completed Paid on delivery

The attached DB must be filled with 270 Football club names, taken from these links:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

the DB have these fileds:

_loid - Auto increment, e.g. 1,2,3,etc.

loname - Name of the Team

lo_image - Logo of the Team

lo_level - icrement of 33, e.g. _loid from 1 to 33 is Level 1, then 34-66 level 2, etc. Every level must have 33 logos

lo_wikipedia - link to Wiki Team page

lo_info - Founded date / taken from Wiki/

lo_player - Team ground / taken from Wiki/

For first 4 levels, e.g. logos till 4x33 you can choose teams from

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

for next 2 levels /e.g. next 66 logos/ you could choose random teams from smaller divisions from

[url removed, login to view]

For next 3 levels /e.g. next 99 logos/ you can choose teams from

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

which are more popular - like the main country divisions.

Also need to post "mahur" in your bid, otherwise will be ignored.

For last 3 levels /e.g. next 99 logos/ you can choose teams from

from all countries, but lower and not so popular divisions.

----------------------

Example:

1. Open [url removed, login to view]

2. Choosing Liverpool FC and open it's wiki page:

2a: From [url removed, login to view] took logo image and resize it to 300x300 and save under some meanfull name, e.g. [url removed, login to view]

2b: Filling the DB with:

_lofid 1

lo_name Liverpool FC

lo_image [url removed, login to view]

lo_level 1

lo_wikipedia [url removed, login to view]

lo_info Founded - 3 June 1892

lo_player Ground - Anfield

AND THATS IT! The record is done only with the info from Wikipedia.

Also there is a Opensource and free tool for editing SQLLite DBs - [url removed, login to view]

Also the first level data is filled - so to understand easily what you need to do...

Data Entry

Project ID: #6815107

About the project

5 proposals Remote project Active Dec 3, 2014

Awarded to:

FirstChoiceWeb

Hello, Read and understood project details. We have a lot of experience of data scarping and data entry. We can do this job very well also we are ready to do sample entries. Hope to getting consider for this. Regards

$30 USD in 3 days
(53 Reviews)
5.3

5 freelancers are bidding on average $28 for this job

sumitsahoo91

hi i am having all the desired qualities to achieve this target and basically the task is fully related to my skills . here in have to create the database according to levels as an 2.5 years sql/plsql developer its a More

$30 USD in 1 day
(1 Review)
1.2
noorzaman1984

A proposal has not yet been provided

$30 USD in 1 day
(1 Review)
0.4
Epy92

Hi! IT engineer ready to work and help you with your job. Very good knowledge of MySQL programing language and others. I will finish in very short time. If you are interested please contact me Thank you!

$25 USD in 2 days
(0 Reviews)
0.0
dataentry032

Hi, I'm Mahbub (Data Entry Expert) - ready to start your project at once. I will provide you 100% success work. ''When I start any work then I never think that it is my client's work, rather I always think it is my ow More

$25 USD in 1 day
(0 Reviews)
0.0