We need an Access-based utility -- called Assemble/Disassemble Utility (ADU) -- to assemble several "Class" delimited text files into a single "Master" delimited text file. (In the future the ADU must also be able to disassemble the Master table into the separate Class tables). We have a separate file (called [login to view URL]) that contains the parameters for the assembly and the disassembly. These parameters may change with each job. It is absolutely critical that the ADU be driven by the parameters contained in the ADU. None of the parameters should be "hard coded" into the ADU code.
Furthermore, the ADU must be invoked from a command line interface. It will be run from a batch file that is launched automatically by another process. We do not want a user interface for the ADU. There should be no error messages or any other messages requiring a human response. Instead, all error conditions and progress messages should be posted to a log file that is cleared at the start of each job.
The utility should perform the following tasks in this order:
1. Import the tab-delimited text files into Access Class tables.
2. Check the Class tables for specific error conditions (listed below).
3. Assemble the Master table.
4. Export the Master table to master.txt.
Further specifications, an example of the text files, along with their equivalents in Access are contained in the attached zip.
This project is for Phase I, which to assemble the Class files into a Master file. Phase II will be to disassemble Master into Class files. We will decide when and whether to proceed with Phase II depending on the success of Phase I.
## 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
W2K