Elance: Assembly of a M

[Roiesh]

Assembly of a M
Fixed Price: $500 - $1,000 | Data Entry | Posted: 2h, 12m ago | Ends: 14d, 21h | 8 Proposals
I need 1 database delivered for me which has about 80,000 records. The records need to be delivered in a MySQL database. The URL is in the attachment. The MYSQL table structures are attached. We call each record a "prospect" which will help you when you see the attached MySQL database structure. Payment terms: Full amount in escrow on engagement. 100% on delivery of 80,000 records. There are 4 tables included: sub_categories, suburbs, prospects, prospects_sub_categories. Two tables are reference tables (suburbs and sub_categories) The remaining two need to be filled with new prospect data. I have included a sample record below so that you can see how the data is structured once you have loaded the attached sql file. If you have any questions, please ask. Sample record: "insert into prospects (name, street_address, suburb_name, postcode, suburb_id, phone, fax, mobile, email, website_url, source_url, status, created_at, provider_account_id, source_type, source_id, band) values('ABC Plumbing', '21 Bulwara Rd", "Pyrmont", "NSW", "2009", 11484, '0404040404', NULL, '0404040404', '[sample email address]', '[URL of business from website which i will provide you by private msg]', 'new', current_timestamp, NULL, NULL, NULL, NULL); insert into prospects_sub_categories (prospect_id, sub_category_id) values(select id from prospects order by id desc limit 1, 168); insert into prospects_sub_categories (prospect_id, sub_category_id) values(select id from prospects order by id desc limit 1, 152);" Additional Notes These columns can be set to NULL when adding new prospects: * prospects.phone, prospects.mobile (although at least one of these cannot be NULL) * prospects.fax (unless a fax is provided) * prospects.provider_account_id (always NULL) * prospects.source_type (always NULL) * prospects.source_id (always NULL) * prospects.band (always NULL) * prospects.suburb_id needs to be an ID from the suburbs table. * prospects_sub_categories.sub_category_id needs to be an ID from the sub_categories table. It needs to correspond to the category/categories of work that the business does. If, for example, the business does work in 3 categories, then 3 categories needs to be added to the prospects_sub_categories table for the one prospect record (i.e. normalised tables). I have had an offer to complete this work for $700 AUD so if you are around this price, i will consider your quote. This work needs to be done within 7 days from selection of the winning bidder.
Skills: Data Entry, Research, Computer
https://www.elance.com/?rid=2G575