Automation and Data Merge Script

Completed Posted Jul 27, 2006 Paid on delivery
Completed Paid on delivery

Data Merge Automation program

What we need is a program that runs on a website or a local computer that will perform a daily task that we are manualling doing. These are the human steps involved that need automated. Preferably all steps will be automated, however, we need at lease the data migration steps done if the FTPing is not automatable:

1. Person logs into remote FTP site and downloads new '[url removed, login to view]' Excel spreadsheet

2. Spreadsheet is loaded in MS Excel on Persons computer

3. User merges to of the columns. (column b and d of attached spreadsheet) This created phase 1 (city and category) phrase that we will later turn into main keyword

4. User goes line by line and replaces category with keyword. This is a statis variable, Meaning, autobodyshops will ALWAYS be changed to AUto Repair Shops as the keyword. There are about 150 possible changes that will apear in this file at a maximum.

5. This keyword list is placed into attached '[url removed, login to view]' excel sheet with associated URLS from previous '[url removed, login to view]' from above.

6. This file is then sent via email to designated email address.

7. A new excel sheet is then created (attached example named [url removed, login to view]) . This excel sheet will contain 2 columns

column A: Search terms (this is the newly created search term

Column B: BTCN number (pulled from original'[url removed, login to view]' excel file)

-So in summary, we will be recieving 1 excel file every day.(ebridge daily batch)

-We need to create 2 files from this

[url removed, login to view]

[url removed, login to view]

We need this process automated as much as possible.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

PHP / ASP / JAVA / Anything will do

Amazon Web Services Engineering MySQL PHP Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #3675563

About the project

4 proposals Remote project Active Jul 27, 2006

Awarded to:

amadel

See private message.

$80.53 USD in 21 days
(170 Reviews)
5.5

4 freelancers are bidding on average $172 for this job

stephencleary

See private message.

$191.25 USD in 21 days
(51 Reviews)
6.6
anilgupta2169

See private message.

$204 USD in 21 days
(11 Reviews)
3.6
securidents

See private message.

$212.5 USD in 21 days
(13 Reviews)
3.6