Færdiggjort

Data management application

Looking to have an application that will do the following:

1. Extract data from tables from websites having approx 1,600 locations

2. The data will be extracted either in csv or excel files

3. These files to be compared with each other

4. Create a master excel file of all the unique files

5. Find-replace user defined strings to be run on this master file

6. Split the master file back to as many unique excel files

7. Automaticaly enter the duplicate files zip codes / store ids

## Deliverables

Finer details:

Hello,

We are looking forward to have an application that will do the following:

1. Extract data from tables from 10-12 stores' websites having approx 1,600 locations (based on zip codes / store location / store id). Tables contain product data like description, price, promotion offer, etc.

2. The data will be extracted either in csv or excel files (one file for each zip code / store location / store id)

3. These files to be compared with each other (within one store) and unique / duplicate files (based on cell contents) to be identified

4. Create a master excel file of all the unique files (within one store)

5. Find-replace user defined strings to be run on this master file with prefixed and suffixed wild cards to remove unneeded information in the strings

6. Split the master file back to as many unique excel files (based on zip codes / store id's)

7. Automaticaly enter the duplicate files zip codes / store ids on the just splitted unique files (split in step 6 above)

This may look complicated at first, but not so in reality. We are able to successfully accomplish this with the help of various tools, but now looking to integrate all these in one single application.

We would prefer .net, Java or Perl to create such an application. We use Win XP and MS Office on our systems.

Evner: PHP

Se mere: zip reality, master excel 2010, looking for duplicate data in excel, contents of product description, excel split a cell, description of product management, wild code, stores management, master data, management application, extract tables, application promotion, php split csv files, extract excel files, extract product data csv, looking file management php, net java tools, application zip php, perl split, excel data management

Om arbejdsgiveren:
( 1 bedømmelse ) Indore, India

Projekt ID: #3313327

Tildelt til:

bob1982

See private message.

$76.5 USD in 6 dage
(361 bedømmelser)
6.9

9 freelancere byder i gennemsnit $4783 på dette job

vcdanht

See private message.

$72.25 USD in 6 dage
(96 bedømmelser)
5.3
dpune

See private message.

$76.5 USD in 6 dage
(44 bedømmelser)
5.0
netcochin

See private message.

$68 USD in 6 dage
(15 bedømmelser)
3.4
nerminema

See private message.

$42.5 USD in 6 dage
(5 bedømmelser)
1.9
theonejb

See private message.

$42.5 USD in 6 dage
(5 bedømmelser)
1.4
professionalpvr

See private message.

$42500 USD in 6 dage
(0 bedømmelser)
0.0
vinodkumarb

See private message.

$85 USD in 6 dage
(1 bedømmelse)
0.0
taasaltd

See private message.

$85 USD in 6 dage
(0 bedømmelser)
0.0