Parsing CSV into database and back
Parsing CSV into database and back I’m in the planning stage of a project currently and we have to make our software work with other client systems. One of these systems is for managing orders within their business, and we need the information regarding stock. Sadly, they have no API, and users can only manually export a CSV file. I can’t come up with the best solution on how to get this CSV data in to our app. At the moment, all I can think of is a manual CSV upload feature that we can use to parse the data in to our database. The main issue is that any changes we make to the data has to be put back into their system, which currently is through CSV upload also. We are supplied no reference data or anything that will help us map the data accurately. All of this on top of the fact that it has to work across multiple devices, probably simultaneously. Can anyone give me an idea of what route to take to solve this problem, and if necessary, should I try to extend the project and recommend ...