mtbvfr — 2012-11-11T20:36:09-05:00 — #1
The application needs to be able to update its local database (CoreData/SQLlite) from a CSV file, downloaded via USB from a Laptop or Desktop computer, or directly from a Central Database Server via a Web Server (ASP.Net application) and Wi-Fi connection.
After tasks have been performed with the application, data (CSV file) needs to be uploaded to the Central Database Server either directly, via a Web Server (ASP.Net application) and Wi-Fi connection, or by uploading a CSV file to a Laptop or Desktop computer that can connect to the Central Database Server.
Which iPhone Application Development features need to be used to enable these scenarios?
What methods/classes need to be used by the application to create a CSV file on the iPhone?
Will File Transfer applications from Third Party sources be able to manage the movement of the CSV files via a USB connection to a Laptop or Desktop computer?
Can these scenarios be achieved using HTML5?
Thank you, Michael.
wwb_99 — 2012-11-15T13:03:33-05:00 — #2
I'd start with not using CSV -- it is an antiquated format best left to the mainframe guys.
If you are on iOS 5 or better JSON is the easy option, before that it is a pick your poison.
mtbvfr — 2012-11-15T15:58:47-05:00 — #3
Can JSON be imported into an MS SQL Server database?
wwb_99 — 2012-11-15T16:50:43-05:00 — #4
Sure, json is parsable and if you can parse it you can INSERT it. Most likely you'd build a web service to take the submitted JSON, sanitize things and push into your database server.
Check out the ASP.NET WebAPI bits.