MySQL table updates
$100-500 USD
Paid on delivery
I have a need to generate new leads in a MySQL database from existing leads. The leads are part of a ERP system written in c++ with a MySQL backend. The following process would be created to generate new leads:
a. Take existing leads and generate new ones
b. Extract leads based on criteria
c. Eliminate duplicates
d. Continue filtering leads based on additional business rules (i.e. certain business sizes, eliminate churches, etc...)
e. Update existing leads table with new leads
Ideally, I would like to create a ETL process which could be modified down the road as more sales data becomes available.
The existing system has over 50 tables and this part of the system involves under 10 of them. Mainly a leads table, a batch table used to uniquely identify groups of leads, order table, invoice table, etc...
The existing table structure is not desireable but I'm not prepared at this time to modifiy table structures until a rewrite of the system takes place 1st qtr 2007.
## 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
CentOS 4.2
PhP
MySQL
c++
Contel telnet
Project ID: #3919021
