CSV or Excel via Web Form
It would be great if there was a way to create a web form that users can use to upload a CSV or Excel file which would populate a table in Caspio Bridge accordingly.
Its like import tool (apend) but for front end.
Users with bulk updated due to lack of internet connectivity will benefit from it and the type of job that can be easily done by excel and need to upload it for centraliztion purpose.
Keith Harrison-Broninski commented
This feature would be very useful indeed and is available in most leading databases. However, to be fully viable, it would need to allow for denormalized data - i.e., data stored in more than one table. For example, uploading people details into a table PERSON (primary key PERSON_ID) will also need to store information in other tables - for example, their job(s) in a separate table JOB which has primary key JOB_ID and a foreign key PERSON_ID.
Tom Templeton commented
Yes, agreed. It also would need to be fully associated with the project, or order, with which it is uploaded.
Bob Barker commented
This is a great idea. It would save me a lot of headache cos I do this all the time. Would be a great addition to the product.