Migrating data between services is a pain, regardless of the services. We’ve always been for simplifying these tedious tasks, because most of Zoho Creator users have the need to synchronize data from in-house applications (ERP system for example), with their custom apps in Zoho Creator.
The Zoho Creator migration tool was a result of a conscious effort to simplify data migration. The tool made it easy to create new apps during migration or migrate data into existing apps. Now, we have enhanced the tool to support command line option for uploading data from files. This version of the tool allows you to perform tasks on Zoho Creator, right from within the command line interface. You can
Create an application
Create a form
Add or Update
This makes way for cron jobs; customers can schedule synchronization of data from in-house apps like MS Access or MS Excel, with their custom Zoho Creator application, without manual intervention. The tool reads popular XLS, XLSX, CSV, MDB and ACCDB formats. Here is a detailed guide on how to do it. Try it out.