En cours

Custom-Data-Extraction May 14 2012

COMPRANET

There are 33 sets of data that list records that vary on size.

The links are:

For the Whole Supplier Database:

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

[url removed, login to view]

For the Supplier Database, by sets where each set stands for a specific State (which is another approach)- Numbers may vary:

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

For Data Set 01: 1,721-records

[url removed, login to view]

...

For Data Set 02: 2,386-records

[url removed, login to view]

...

For Data Set 03: 974-records

[url removed, login to view]

...

[Pls notice the link that states the data set on "entidad=##"]

and data sets 04, 05, 06 ... all the way to 33 ...

...

For Data Set 33: 3,623-records

[url removed, login to view]

...

Pls. notice that data set 09 has 35,650 records, so the number varies per dataset. Total number of records is 134,518.

....

So, the idea is to extract data with the columns:

+ Data Set (from 01 to 33)

+ Comany Name

+ Tax Number

+ Address

+ Address on 5-columns [Address1, Address2, City, State, ZipCode]

+ Phone

+ Fax

+ Email

+ Business Activity

I hope it explains the scope and kind of data-extraction work.

If you have any questions let me know. Also, if you have a better idea on how to approach, your input is welcome.

Pls. notice:

* Its now a DB of more than 134,000 records

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

So, I wonder if MS-Excel would work well for it ... that is on one SpreadSheet all records or if you have to divide it, pls make it as long as possible (50k+), but keeping all STATE records on a single file.

* The ADRESS field contains 6, 7, or even more records.

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

So, I wonder if you could separate in 5(five) columns, going from right to left within the Address:

A - Codigo Postal / ZipCode

B - Estado / State

C - Municipio / City

D - Colonia / Address 2

E - Street / Address 1

For example ... on the first record of your last project(FILE: Sirve+Data+Scraping), for

"10 Quattro Sa De Cv"

the ADDRESS field reads:

3 ERA AVENIDA 700, A, CUMBRES, SEGUNDO SECTOR,MONTERREY,NUEVO LEON 64610

So ... going from right to left ... we would have:

A - 64610

B - NUEVO LEON

C - MONTERREY

D - CUMBRES SEGUNDO SECTOR

E - 3 ERA AVENIDA 700 A

I know that it may vary so that is why it makes sense to go from left to right ...

On the other hand, if you recommend to keep all records on a single ADDRESS field, I understand but if you could divide, pls. take into account that ZIP, STATE, CITY, ADDRESS1 and ADDRESS2 are standard.

Compétences : Exploitation de Données, Traitement de Données, Excel, Leads

Voir plus : the data supplier, may 2, first bit set, data input work, data bit, cv example, custom list in excel, city of hope, bit of data, bit data, monterrey, may, leon, five-to-go, era it, database extraction, data-extraction, data extraction and input, colonia de, database record keeping, zipcode city, activity spreadsheet, state tax, extract name email excel, excel extract email data

Concernant l'employeur :
( 9 commentaires ) Monterrey, Mexico

N° du projet : #1631171

Décerné à :

panfreelancer

Hi, I can extract all 134000+ records into single xlsx file. Please check Inbox for my sample. Thank you.

80 $ USD en 3 jours
(34 Commentaires)
5.1

5 freelance font une offre moyenne de $48 pour ce travail

Toperfection

Dear iglesias, Greetings! Highly experienced with Data scrapping. Please refer to the "PROJECT CLARIFICATION" for a query. Thanks.

40 $ USD en 10 jours
(34 Commentaires)
6.7
diamond247

Expert here, please see the Pm for m ore details

40 $ USD en 0 jours
(62 Commentaires)
6.5
ktrnkatreen

like to do....

40 $ USD en 2 jours
(0 Commentaires)
0.0
shahel008

I understand your project requirement. I am interested to do your work.

40 $ USD en 3 jours
(1 Commentaire)
0.0