In our field of business we need to manage and offer to our potential clients our services. The data about our clients come from 3-4 datasources as CSV files. Those files are different as structure and we need to "uniformize" the datat structure, compare them between the sources and with the previous contacts.
What we need: A windows XP software able to process the different list we get as input and able to adapt for different data structures in the future. We need also to process some data in certain fields (ex. convert CAPITALS to Capitalize or minuscules based by a script or template or something)
Datasources are slightly different so, the software should be able to split certain columns in 2 for the final "standard" form.
Standard (final) export should be CSV and will have few columns added based by content. (Ex. If Firstname = John then addresationfiled = "Mr."). The final export is gonna have also other new added columns, based on duplicates and history of contacts.
More details will be available...
I think an experienced Database oriented coder will be able to finish this very quick. We do this data processing in Excel right now but its to time intensive.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows XP