5/27/2020: Client paying downpayment to get in queue. Wants it to work by 7/1/2020, but we are pretty far out in our queue. 1. We would need to know the exact format - columns, numbers, and layout. >> 2. I've included a raw sample of what it looks like. If you look, you >> will see that there are no column headings and tons of blank data (back to back commas) 3. A CSV (comma separated values) file has data separated by commas. For example: column 1,column 2, column 3,,,, - we would need to know what every possible column needs to be mapped to. In the example, we can see data in columns 1-3, however columns 4-7 are blank. We still need to know what would go there if there was data. >> 4. Once we know the real format, we can then build a tool to pull in the data, parse it (break it apart into usable pieces), and then do bulk inserts into the database.
|