Customer X just informed us that we need to churn out a code enhancement ASAP for a new project. Here is what they need:
1. We need a Java application that will consume a CSV file, parse the data and insert to a SQLite In-Memory database.
a. Table X has 10 columns A, B, C, D, E, F, G, H, I, J which correspond with the CSV file column header names.
b. Include all DDL in submitted repository
c. Create your own SQLite DB
2. The data sets can be extremely large so be sure the processing is optimized with efficiency in mind.
3. Each record needs to be verified to contain the right number of data elements to match the columns.
a. Records that do not match the column count must be written to the bad-data-<timestamp>.csv file
b. Elements with commas will be double quoted
4. At the end of the process write statistics to a log file
a. # of records received
b. # of records successful
c. # of records failed
Data for the project is included in the sample CSV file, attached.
Hello.
I have rich experience on Windows driver development and .NET framework.
This project is very interested to me.
I know all the tricks of Windows system.
I highly recommend that C++ for dll is good for this.
If you want C# api, I can integrate it.
Hope your kind contact.
----------------
Hello
I did read your project detail carefully
I can develop java app that parse csv
I can work on your project and I will try my best.
I can provide most quality and high speed.
If you want to success, please contact me.
Then, I will give you good result to the proposals.
Please contact me
Best regards