Need to write Java code for Bulk Load Administration Process where a customer will upload a CSV, JSON or XLS and we need to convert that into bulk object and do object comparison
1. If both are same ignore changing it and
2. Check for any change in data (properties) then the action should be update
3. Check for Id, if it is new then action should be add
4. And if the Id does not exist in new file then the action is delete
Hi
I can do it, I can design and build this software for you according to your requirements.
Can we discuss in detail?
If you have any query please inbox me.
Thanks
I will use Apache POI to convert Excel doc to Java objec, Google GSOn to convert json to Java object and Opencsv to convert csv to Java object. Once this is done for each object will be checked in the database by firing Select statement. The ones that came back from the select query results will be eligible for an update with a second level check for the change in properties, rest will be either added or deleted.