A Simple Perl program should do the trick....(but any other language is totally acceptable) This is basically de-duping multiple delimited text files based on one column being identified by the user (in this case the primary use would be email. The output should be a CSV file easily opened with excel with all columns of data from all specified input files. with the first column being the unique identifier, followed by all other data. All input files should be expected to have a header row which should be retained in the output file Any configuration for the program should be able to be saved and editable in plain English for non IT personnel No input file will have all unique identifiers and all columns that have no data should remain blank in the output file possible revisions in the future so long term rent-a-coders would be given preference.
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).
* * *This broadcast message was sent to all bidders on Tuesday Jun 5, 2007 7:39:15 AM:
just a quick note to everyone as a few people have asked and I wanted to make sure everyone was bidding on the same information
There could be up to 20,000 records in a file (though if this worked for more, that wouldn't be a bad thing...)
Right now we foresee the use of up to 4 files.
Sample input and output files are now on the bid request page
Anyone else have any clarifying questions I'll try to keep everyone updated.
Thanks again for your intrest
Windows XP, Vista