Setting up Periodic Upload / Synchronization - Task Schedule in Windows Server

Setting up Periodic Upload / Synchronization - Task Schedule in Windows Server

Hi to all,

I had an issue that i just solve. And i think writing this solution will be usefull to other users.

I want to schedule a task in windows server for uploading data from Relational Database To Zoho Reports.
I set up the setting in /conf/common_params.conf and /conf/database_connection_params.conf

And when i schedule a task for starting /bin/UploadFromDB.dat file with the instructions on https://reports.wiki.zoho.com/Uploading-Data-from-Relational-Databases.html#Setting%20up%20Periodic%20Upload it doesn't work :)

So here is how i fix the issue and make a task schedule for uploading data periodicly.
  • Click Start -> Settings -> Control Panel ->Scheduled Tasks.
  • Click Add Scheduled Task. The "Schedule Task" wizard will open.
  • Click Action > Create Task to open the Create Task dialog.
  • Open Action tab and then click New.
  • Click Browse button and select the upload tool command line batch file UploadFromDB.bat in the Program/Script field. Ensure that you have provided the necessary settings in the Upload tool configuration files.
  • Skip blank the  Add Argument field
  • Type your path to UploadFromDB.bat file in the Start in field. (Ex. C:/ZohoReports/UploadTool/bin/ )
    •
And this is all.

And pls zoho team change the instruction on https://reports.wiki.zoho.com/Uploading-Data-from-Relational-Databases.html#Setting%20up%20Periodic%20Upload

Umut