I import a CSV file in to Access, of anywhere from 1 to 150 records.
The file layout is the same for each record for the first 25 or so fields. After the first 25 fields each line contains about 10 fields, and then repeats these 10 fields 20 times on the same line. These 10 fields are line items from an order. So if the order has 4 line items, these 10 fields are on the same record 4 times, one after the other.
Now the problem:
The people who designed the software that creates this CSV file for us, made what I think is a big mistake, and I am not sure how to get around this. So each day I have to manually adjust several lines in Access to account for their mistake.
Of the 10 fields for each line item on the record above, the last field of those 10 is an option attribute from the item. For instance a color. The problem is that if that particular line item does not have any options, then the import does not know it because the import file does NOT leave a blank field in its place. Instead they immidiately start the next item on that row, and thus the next line items get all messed up. And this would then happen for every line on that order. The next row or record starts over and is fine.
I am not sure if this is even fixable through our import routine, but maybe someone out there can help.
I am attaching an excel file with a sample of the line portion of the import file to better show what happens.
## 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
.mdb