Home  »  Upload Tool

Upload Tool

Tags:  

Zoho Reports Upload Tool - Introduction



Users are requested to download the latest version of the Upload Tool released on or after 17th June 2013. Support for older version will be removed soon.

Zoho Reports Upload Tool is a downloadable standalone utility, that enables you to upload data from your local databases such as MS Access, Microsoft SQL Server, Oracle, MySQL, Sybase, PostgreSQL SQLite, DB2, DB2 AS/400, Firebird, SQL Azure and other applications behind firewall into Zoho Reports. The tool can be used in two ways. They are:

  1. Upload Data from CSV Files

    You can bulk upload data in a CSV file format into Zoho Reports using this tool. It is especially useful when you need to upload more than 500,000 rows or whose file size is greater than 50 MB (these import size limits are applicable when you use the Zoho Reports web user interface). This tool splits the data in the CSV file into batches and uploads it to Zoho Reports, making it much more resilient to intermittent Internet connectivity outages or slow connections. It can be invoked in GUI and Console (command line) modes.

  2. Upload Data Directly from Databases behind Firewalls and Cloud Databases

    You can pull data from application databases behind firewall and cloud database to upload the same into Zoho Reports. The tool directly accesses your database, queries for the required data and uploads it to Zoho Reports. Currently supported databases are MS Access, MS Access 2010, MySQL, Microsoft SQL Server, Sybase, PostgreSQL, Oracle, SQLite, DB2, DB2-AS/400, Firebird and SQL Azure (Cloud Database).

You can use the tool in either of the above said ways to suit your requirement. You can also setup the tool for periodic automatic execution, so that you could keep the data synchronized with Zoho Reports.

The following screenshot illustrates how the Upload Tool functions.



In the subsequent sections of this topic, we will discuss in detail about how to use the Upload tool in various modes to upload/synchronize your data with Zoho Reports.

Next: Download and Setup


Esteban Siravegna 1705 - days ago 
There is no way for me to sucefully import dates, I always get the "$ERROR: Invalid Date value</NOBR><br><nobr>The data found at the row 2 has invalid data for the given configuration</NOBR><BR>)" No matter how do I set the date output on my Query. Ideas?

Thanks!!
Manohar Nixon 1703 - days ago 
Hi esiravegna,

You can set the DATE FORMAT as below:

1. Open common_params.conf file under <Tool_Home>/conf/ directory.
2. Add the below text in a new line:
ZOHO_DATE_FORMAT=<your_date_format>
Example:
ZOHO_DATE_FORMAT=dd/MM/yyyy
3. Then start upload using the tool

If the DATE values in your data could not be identified by Zoho Reports or if there is a mismatch between the mentioned DATE FORMAT and the date values in your data, Zoho Reports throws IMPORT ERROR.

If the parameter ZOHO_ON_IMPORT_ERROR set as ABORT, then the import process will be stopped if import error occurs.
You could also set SETCOLUMNEMPTY for ZOHO_ON_IMPORT_ERROR parameter, if you want to set the value as EMPTY, if import error occurs. If this parameter set as SKIPROW, then the row which has import error will not be imported.

For more details on import parameters, kindly refer the below link:

http://zohoreportsapi.wiki.zoho.com/Importing-CSV-File.html#ParametersforspecifyingtheImportOptions

Hope this clears your question.

Best Regards,
Manohar Nixon S
Zoho Reports
Matt (Guest) 1677 - days ago 
I'm getting an exception during the UploadFromDB.bat execution indicating that it "Could not Find File '(unkown)'. Trying to export data from MSACCES 2007 to ZohoReports.


Logs indicate:


TESTRUN :: false

2009-09-18 13:09:15.718 :: Connection Props are :

DBTYPE :: msaccess

HOSTNAME ::

USERNAME ::

PASSWORD ::

PORT ::

DBNAME ::

MDBFILENAME :: C:\Matt\zoho\PivotTable.mdb

CONNECTION URL :: jdbc:odbc:DRIVER=Microsoft Access Driver (*.mdb); DBQ=C:\Matt\zoho\PivotTable.mdb;UserCommitSync=Yes; Threads=3; SafeTransactions=0; PageTimeout=5; MaxScanRows=8; MaxBufferSize=2048; DriverId=281;

TOTAL NUMBER OF QUERIES :: 1

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Logging in...

Logged in successfully...


Exception occured while establishing connection to the database server

java.lang.RuntimeException: Exception occured while establishing connection to the database server

at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:292)

at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.main(ZohoReportUploadDataFromDB.java:66)

Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)

at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)

at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:281)

... 1 more
Manohar Nixon 1675 - days ago 
Hi,

From the error message you got, we guess that this error occurred because of the mdb file mentioned is not found in the given location. If the file is available, please check whether the file(*.mdb file) has read permission.

Kindly check the above and if you are still facing the issue lets have an online meeting to resolve the issue. Send us your contact number to support [at] zohoreports [dot] com. We will call you and assist you in resolving the issue.

Thanks & Regards,
Manohar Nixon S
Zoho Reports
alfernandez26 1650 - days ago 
I have this problem:

C:\>rem $Id: UploadFromDB.bat,v 1.6 2009/04/10 14:00:48 manoharnixon Exp $
"Usage : ZohoReports\UploadTool\bin\UploadFromDB.bat <username> <password>"
C:\>C:\ZohoReports\UploadTool\bin\UploadFromDB.bat sa adidas

C:\>rem $Id: UploadFromDB.bat,v 1.6 2009/04/10 14:00:48 manoharnixon Exp $
Could Not Find C:\temp\queryOutput_*
Exception in thread "main" java.lang.NoClassDefFoundError: com/adventnet/zoho/cl
ient/report/tool/ZohoReportUploadDataFromDB
Caused by: java.lang.ClassNotFoundException: com.adventnet.zoho.client.report.to
ol.ZohoReportUploadDataFromDB
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
Could not find the main class: com.adventnet.zoho.client.report.tool.ZohoReportU
ploadDataFromDB. Program will exit.
Manohar Nixon 1650 - days ago 
Hi,

Sorry for the issue you have faced.

Could you please go to <Tool_Home>/bin/ directory and then execute:
UploadFromDB.bat <you_zoho_username> <your_zoho_password>

Please get back to support [at] zohoreports [dot] com if you have further clarifications.


Best Regards,
Manohar Nixon S
Zoho Reports
jmusayon (Guest) 1551 - days ago 
I want update several tables at the same time, then I use ZOHO_MATCHING_COLUMNS but only works with 1 table. I can't use it to update 2 or more table. Can you say me how can I do it?
I tried with a ZOHO_MATCHING_COLUMNS by table like this:
ZOHO_MATCHING_COLUMNS=field1table1,field2table1
ZOHO_MATCHING_COLUMNS=field1table2,field2table2

Also I tried with
ZOHO_MATCHING_COLUMNS=field1table1,field2table1,field1table2,field2table2

and not work


Can anyone help me?
Saminathan Arumugam 1551 - days ago 
Hi,

Currently you cannot specify multiple table information in a single common_params.conf file. However, you can have more than one common_params.conf file associated for different tables.

For example, you can have two common_params.conf file(say common_params_for_table1.conf, common_params_for_table2.conf) within the <Tool_Home>/conf directory. Within the specific conf files you can have the corresponding table's ZOHO_MATCHING_COLUMNS alone. In this case of multiple conf files, you can edit the file bin/run.sh and change the parameter "-DCONFFILE=conf/common_params.conf" based on the table(use the corresponding conf filename).

We believe that the above will help you. You can also send us your queries to support[at]zohoreports[dot]com. We will be more than happy to assist you.

Regards,
Saminathan,
Zoho Reports
Gustavo globerp 1523 - days ago 
hi, I have this problem:

/ZohoReports/UploadTool/bin/UploadFromDB.sh: line 15: java: command not found

Can anyone help me?
Manohar Nixon 1523 - days ago 
Hi,

This issue will occur when the UploadFromDB.sh/bat file is executed from other than <Tool_Home>/bin/ folder. So, kindly follow the below steps:

1. Go to the tool home by executing the below command:
cd /<tool_path>/ZohoReports/UploadTool/bin/

where <tool_path> is where you have installed the Upload Tool.

2. From <Tool_Home>/bin folder, run the executable file by executing the below command:
For Linux:
sh UploadFromDB.sh <username> <password>
For Windows:
UploadFromDB.bat <username> <password>


We believe that this will resolve the issue. Kindly get back to support [at] zohoreports [dot] com for further clarifications or still the problem persists.

Thanks for your time. Have a great day!


Best Regards,
Manohar Nixon S
Zoho Reports
BORREGO CONTRERAS FRANCISCO 1428 - days ago 
Hello I can't upload my mdb database, I have setup everithing following your instructions, and don't work. I can't see the information in Zoho Reports.

The log are:
TESTRUN :: false
2010-05-25 19:31:37.098 :: Connection Props are :
DBTYPE :: msaccess
HOSTNAME ::
USERNAME ::
PORT ::
DBNAME ::
MDBFILENAME :: C:\Access\LOGDATA.mdb
CONNECTION URL :: jdbc:odbc:DRIVER=Microsoft Access Driver (*.mdb); DBQ=C:\Access\LOGDATA.mdb;UserCommitSync=Yes; Threads=3; SafeTransactions=0; PageTimeout=5; MaxScanRows=8; MaxBufferSize=2048; DriverId=281;
TOTAL NUMBER OF QUERIES :: 2
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Logging in...
Logged in successfully...

:::::::: ZOHO REPORTS IMPORT PARAMETERS :::::::::

Zoho Reports Database Name :: MyDB1
Zoho Reports Table Name :: mytable1
Import Type :: APPEND
Matching Columns ::
Skip Top ::
Selected Columns ::
Query to be exectuted on local database ::
select * from dbtable1

2010-05-25 19:31:40.864 :: Executing query #1...
Exception in fetching data from db server
Exception occured while executing queries and uploading data
java.lang.RuntimeException: Exception occured while executing queries and uploading data
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:368)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.main(ZohoReportUploadDataFromDB.java:66)
Caused by: java.lang.RuntimeException: Exception in fetching data from db server for query
select * from dbtable1
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.getQueryAsCSV(ZohoReportUploadDataFromDB.java:234)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:322)
... 1 more
Caused by: java.sql.SQLException: [Microsoft][Controlador ODBC Microsoft Access] El motor de base de datos Microsoft Jet no puede encontrar la tabla o consulta de entrada 'dbtable1'. Asegúrese de que existe y que su nombre está escrito correctamente.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.getQueryAsCSV(ZohoReportUploadDataFromDB.java:185)
... 2 more

Please help.
Manohar Nixon 1428 - days ago 
Hi pborrego,

Kindly follow the below steps to resolve the issue:

1. After entering the mdb file in database_connection_params.conf file, you need to configure the database_sql_queries.xml file.
2. Open <Tool_Home>/conf/database_sql_queries.xml
3. Configure the XML as below:
<Queries>
<Query dbname="MyDB1" tablename="mytable1" importtype="APPEND" matchingcols="" selectcols="" skiptop="">
select * from dbtable1
</Query>
</Queries>

where,
MyDB1 is the name of the database in your Zoho Reports account
mytable1 is the table name where the result of the query should be stored
The Query (select * from dbtable1) is the query that should be executed in your .mbd file. i.e., you need to give your own query with the table name that is present in your .mdb file.

We believe that the above said is clear. Kindly get back to support [at] zohoreports [dot] com for further clarifications in this regard.

Best Regards,
Manohar Nixon S
Zoho Reports
elevatechurch 1315 - days ago 
Trying to upload our Access database to ZOHO. It worked up until about a month ago or so. Now it gives an error about the name already exists in ZOHO. We tried several different names that we have never used and still got the same error. Did something change with the upload procedure?

Thanks.
drln00 1280 - days ago 
Is there a way to run this tool for non technical people? I try to understand your instructions just to upload an access file and test the db in zoho reports, can't even open your downloaded files...
senthilvel.n 1234 - days ago 
Hi elevatechurch,

Thank you for contacting us. Sorry for the delayed response. Somehow we missed your comment.

Please send the exact error message which you have received during the upload process. If possible kindly send the screenshot of error message which will help us to understand the issue. Also send us the log files which are found within the directory "UploadTool_Home]/logs". You can send the information and files to support [at] zohoreports [dot] com.

Thanks and Regards
Senthilvel N
Zoho Reports
senthilvel.n 1234 - days ago 
Hi drln00,

Thank you for contacting us. Please find below the steps to upload the data using upload tool:

1. Download the tool from the link : https://reports.wiki.zoho.com/Upload-Tool.html (If you are windows user download the tool for windows. If you are a linux user download the linux tool)
2. Extract the ZIP tool.
3. Goto the bin folder. ZohoReports\UploadTool\Bin
4. Start the upload process by executing CSVUploadGUI command.
5. It will open a window like in the below link. https://reports.wiki.zoho.com/Upload-Tool.html#Upload-Data-GUI
6. Refer the above link for uploading data.

We can provide you with a demo for "How to use the upload tool". Kindly send your email address and contact number to support [at] zohoreports [dot] com. We will initiate the call to discuss on this.

Thanks and Regards
Senthilvel N
Zoho Reports
chris maynard (Guest) 1070 - days ago 
You say to download MySQL JDBC Driver from the link below:

http://www.mysql.com/downloads/connector/j/mysql-connector-java-com-3.0.16-ga.tar.gz.


BUT the tool doesnt work unless you change the name of the JDBC driver file to "mysql-connector-java-3.0.17-ga-bin.jar"

Tom 1057 - days ago 
Is multi-tenancy supported in all Zoho services? I plan to have "accounts" for each customer and a bunch of users for each customer. In this case how can I structure the Zoho reports upload/feed services to the "right" account?

Raj
CK Chong 889 - days ago 
Hi, can Zoho upload data from either an ODBC connection or IBM DB2/400 database table?
Subrat sahoo 874 - days ago 
hi i am getting error :-


2011/12/01 17:07:52 IST:Error Occured in uploadData. Error Code: 7103, Error Message: Database not found! Please check whether the database exists

2011/12/01 17:07:52 IST:2011-12-01 17:07:52.17 ::


2011/12/01 17:07:52 IST:Exception occured while executing queries and uploading data


2011/12/01 17:07:52 IST:java.lang.RuntimeException: Exception occured while executing queries and uploading data

at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:412)

at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.main(ZohoReportUploadDataFromDB.java:71)

Caused by: java.lang.RuntimeException: Exception occured while uploading data: Database not found! Please check whether the database exists

at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:405)

... 1 more

Caused by: java.lang.RuntimeException: Database not found! Please check whether the database exists

at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.uploadData(ZohoReportUploadDataFromDB.java:463)

at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:391)

... 1 more

Caused by: ServerException (HttpStatusCode 400 Error Code: 7103 , URI: /api/subrat_cts/CDR_IN/at_cdr_activity_raw, Action: IMPORT, Message: Database not found! Please check whether the database exists)

at com.adventnet.zoho.client.report.BaseClient.sendRequest(BaseClient.java:115)

at com.adventnet.zoho.client.report.ReportClient.sendRequest(ReportClient.java:1231)

at com.adventnet.zoho.client.report.ReportClient.sendImportRequest(ReportClient.java:962)

at com.adventnet.zoho.client.report.ReportClient.importTblData(ReportClient.java:945)

at com.adventnet.zoho.client.report.ReportClient.importDataInBatches(ReportClient.java:823)

at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.uploadData(ZohoReportUploadDataFromDB.java:450)

... 2 more


Please suggest me
dustinromey 855 - days ago 
Is there any support for OSX?
Audrey. BELLEAU 843 - days ago 
Hi,

Nothing happen when I lanch DBupload.bat.
I want to sync a ms access base with Zoho Reports

Thanks
James WLTH 805 - days ago 
http://css.zohostatic.com/db/api/v3_0/m9/ZohoReportsUploadTool_Windows.zip
Should there be an .exe in this download? How are we supposed to execute on a Windows system?
robert.bosco 698 - days ago 
Hi,

I am using Sql sever for to manage my data base So now i want to connect sql server to ZOHO reports, As I read your manual but i couldn't understand properly so could you please let me know that how to connect from SQL to ZOHO

Thanks & Regards,
Robert Bosco
vmestatus 684 - days ago 
Hello,
I've a date format as 21/05/2012-14:06:45, but zoho is supporting only 21/05/2012 14:06:45. the data is directed from the mdb database and its hectic to edit the date format everytime. please give a solution.
Karolin (Guest) 669 - days ago 
Hi there,

I want to run the sh script but I get the following error:


UploadFromDB.sh: line 21: syntax error: unexpected end of file (expecting "then")

Can anyone help me please?

Thanks.
Prabhakaran S 666 - days ago 
Hi Karolin,

We have executed the UploadFromDB.sh file in our environment successfully without any issues. We suspect that
the problem is with the shell that set to your external sh command. We suggest you to use "bash" shell to execute UploadFromDB.sh file. Kindly try the below command.

/bin/bash UploadFromDB.sh <username> <password>

In case the problem still persists kindly let us know, we will have a web meeting to resolve the problem at the earliest. Kindly let us know your convenient time so that we can call and assist you.

Thanks & Regards,
Prabhakaran,
Zoho Reports.
John Pia 659 - days ago 
Do the databases adn table names on my local network need to match the ones in Zoho... I cant seem to figure out how to upload data from a database that is named differently in zoho from the one on my local network. please help!
janani.t 658 - days ago 
Hi ,

It is not mandatory to name the table in your local network to match with the ones in Zoho Reports database. You can name it differently. To upload data you need to map the data from your local table with that of the table in your Zoho Reports database.
Kindly follow the given steps to upload the data from your local mysql database:

1. Download and unzip the upload tool from the following link.
https://reports.wiki.zoho.com/Upload-Tool.html#Download
2. Open the directory <upload_tool_home>\\ZohoReports\\UploadTool\\conf
3. Open the database_connection_params.conf file
4. Provide the configurations as follows:

• DBTYPE=mysql
• HOSTNAME=ip address or system name
• PORT=3306 (default port is 3306)
• USERNAME=mysql_username
• PASSWORD=mysql_password
• DBNAME=in-house database name

5. Open the database_sql_queries.xml file
6. Configure the following parameters in that file:


• dbname=ZOHOREPORTS_DBNAME // Name of the database available in your Zoho Reports account.
• tablename=ZOHOREPORTS_TABLENAME // Name of table in your Zoho Reports database mentioned above. If the table is not available, the tool will create a new table, with the same name, on data upload.
• importType=APPEND / TRUNCATEADD / UPDATEADD //Mention the type of import.
• Provide the SQL SELECT query to fetch the data from your in-house database table, which needs to be uploaded into the Zoho Reports table specified above.


7. You need to provide separate query for importing data from more than one table from your local database
8. Open a command prompt and change the directory to<upload_tool_home>\\ZohoReports\\UploadTool\\bin
9. Start the upload process by executing the below command

• UploadFromDB.bat zoho_username zoho_password // for windows
• sh UploadFromDB.sh zoho_username zoho_password // for linux


Hope this clarifies your query. Please revert to us if you require any further information/assistance, we will be glad to help you.


Regards
Janani
Zoho Reports
Pompier Christian 610 - days ago 
hello,
is it possible to call request of type "insert.." which is create in my database access ?

thanks
Prabhakaran S 608 - days ago 
Hi,

Thank you for contacting support.

From your comment, we assume that you are working on Access database using Zoho Reports Upload Tool. Kindly note that our tool can execute the select query and upload the data from the result set. Other queries(excluding select queries) are not supported.

We believe that the above explanation answers your question. In case our understanding on your requirement is not correct, please do correct us and do elaborate the same.

Thank you for your time and understanding.

Assuring the best of our support.


Regards,
Prabhakaran,
Zoho Reports.
David Eichner 593 - days ago 
I need a sample of how to upload data from PostgreSQL. If possible to do this, we would have a lot of clients that could use Zoho Reports.
Prabhakaran S 593 - days ago 
Hi,

Thank you for your interest in Zoho Reports.

Yes, it is possible to pull the data from PostgreSQL database and upload into Zoho Reports. Please follow the below steps to upload the data from your local PostgreSQL database:

1. Download and unzip the upload tool from the following link.
Linux: http://css.zohostatic.com/db/api/v3_0/m14/ZohoReportsUploadTool_Linux.zip
Windows: http://css.zohostatic.com/db/api/v3_0/m14/ZohoReportsUploadTool_Windows.zip
1. Open the directory <UPLOAD_TOOL_HOME>ZohoReports/UploadTool/conf
2. Open the database_connection_params.conf file
3. Provide the configurations as follows:
i) DBTYPE=postgresql
ii) HOSTNAME=<ip address or system name>
iii) PORT=5432 (default port is 5432)
iv) USERNAME=<postgresql_username>
v) PASSWORD=<postgresql_password>
vi) DBNAME=<in-house database name>
4. Open the database_sql_queries.xml file
5. Configure the following parameters in that file:
i) dbname - =ZOHOREPORTS_DBNAME // Name of the database available in your Zoho Reports account.
ii) tablename=ZOHOREPORTS_TABLENAME // Name of table in the specified database. If the table is not available, the tool will create a new table on data upload.
iii) importType=APPEND / TRUNCATEADD / UPDATEADD // type of import Provide the SELECT query to retrieve the data from your in-house database.
6. You will need to provide a separate query for importing more than one table from your local database
7. Open a command prompt and change the directory to <UPLOAD_TOOL_HOME>ZohoReports/UploadTool/bin
8. Start the upload process by executing the command below:
UploadFromDB.bat zoho_username zoho_password

Kindly check the below help documentation to know more information on Upload Tool:

https://reports.wiki.zoho.com/Upload-Tool.html#Upload-Data-Inhouse-DB
https://reports.wiki.zoho.com/Upload-Tool.html#FAQ


We hope the information provided above was beneficial. Kindly get back to support@zohoreports.com for further clarification in this regard.

Regards,
Prabhakaran,
Zoho Reports.
James Converse 546 - days ago 
Hello,

I'm getting the below error when running UploadFromDB.bat. I'm attempting to upload from MS Access.

"The system cannot find the path specified."

Here is my configuration info:

database_connection_params
# $Id$
DBTYPE=msaccess
HOSTNAME=
PORT=
USERNAME=
PASSWORD=
DBNAME=
MDBFILENAME=C:\Clients\Cultivate\Cultivate.mdb
SQLITEFILENAME=


database_sql_queries
<?xml version="1.0" encoding="UTF-8"?>

<!-- $Id$ -->
-<Queries> <Query skiptop="" selectcols="" matchingcols="ItemNumber,Location" importtype="UPDATEADD" tablename="tblInventory" dbname="dbCultivate"> select * from tblInventory </Query> </Queries>



UploadFromDB
rem $Id$
@echo off

if "%1" == "" goto usage_error
if "%2" == "" goto usage_error

set TOOL_HOME=%~dp0%\..
call setEnv.bat

set TEMP_DIR=temp

del /F %TEMP_DIR%\queryOutput_*

set CLASSPATH=%CLASSPATH%;lib\mysql-connector-java-3.0.17-ga-bin.jar;lib\ojdbc14.jar;lib\postgresql-8.2-505.jdbc3.jar;lib\jtds-1.2.jar;lib\db2jcc.jar;lib\db2jcc_license_cu.jar;lib\sqlitejdbc-v056.jar;lib\jt400.jar

set JAVA_OPTS=%JAVA_OPTS% -DCONN_PARAMS_FILE=conf\database_connection_params.conf -DIMPORT_OPTIONS_FILE=conf\database_sql_queries.xml -DTEMP_DIR=%TEMP_DIR% -DTESTRUN=false

"%JAVA_HOME%\bin\java" %JAVA_OPTS% com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB "%1" "%2"

cd bin

goto end_of_page

:usage_error
echo "Usage : %0 <MyUsername> <MyPassword>"

:end_of_page

Please help. Thank you!

~ James C.
janani.t 540 - days ago 
Hi James,

Thank you for posting question.

Please check the file path for MDBFILENAME. It should be specified as follows:

C:\\Clients\\Cultivate\\Cultivate.mdb

Note that you have to provide double slash (\\) instead of single slash (\) in the file path.

Hope the above will resolve your issue. In case the issue still persist, please write to us at support@zohoreports.com. We will help you solving the issue.

Regards
Janani
Zoho Reports
Sascha Koslowsky 540 - days ago 
Dear Sirs: I am trying to upload data from a second oracle database, but the FAQ instructions - https://reports.wiki.zoho.com/Upload-Tool.html#Is it possible to fetch data from multiple database using Upload Tool? - do provide two download links to get example configuration files, but both download links are not working. Could you update those example download links please. Many thanks SK
janani.t 538 - days ago 
Hi,

Sorry for the inconvenience caused. We have fixed the issue in the link. Please check the links now, you will be able to download the sample configuration files.

Regards
Janani
Zoho Reports
offgrid 526 - days ago 
Hi,

I have a question regarding to exporting data from Postgree database accessible via SSL. With JDBC driver I have to use the following connection string:

jdbc:postgresql://mydomain.com:5632/dbname?user=XXX&password=XXX&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory

But upload tool does not allow to set up properties ssl and sslfactory, so in result it generates connection string (according to log) jdbc:postgresql://mydomain.com:5632/dbname.

Connection error occurs

org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "mydomain.com", user "XXX", database "dbname", SSL off

How I can resolve this? Thanks.
offgrid 526 - days ago 
Hi,

Have found answer for my question myself - you need to add parameters to database name like

DBNAME=dbname?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory

in this case connection string will be generated correctly.
borgo_etico 400 - days ago 
I have modified my T-SQL query in order to select a DATE without TIME --> SELECT CAST(mydate as DATE) FROM ..

Into CSV, the date date is now like 2013-03-01

I have added the configuration option ZOHO_DATE_FORMAT=yyyy-MM-dd
to my common_params.config file, but the setting IS NOT HONORED.
I still have into log warnings indicating that the date has not been recognized
>> [Riga: 65 Campo: 26] (2012-11-13) -RESET : valore data non valido

How can i resolve this issue ?
Prabhakaran S 400 - days ago 
Hi,

Thank you for contacting us.

Currently Zoho Reports does not support the ZOHO_DATE_FORMAT property for DB Upload Tool. The default date format for a date column expected by the tool is dd/MM/yyyy HH:mm:ss, and hence kindly use the below SQL function to convert your date value to the required date format in your Query.

DATE_FORMAT(DATE(<date_field>), '%d/%m/%Y 00:00:00')

Note : From your post, we understand that the <date_field> in your table is of varchar type and hence we converted your string date value to date type using the DATE function in the above expression, and then the desired format is applied to that date value. If your date value is of Date type then you may ignore the DATE function used in the suggested expression.

Please do the above changes in your query and run the tool. If you require further clarification, kindly get back to us at support@zohoreports.com. We will be glad to assist you.

Regards,
Prabhakaran,
Zoho Reports.
Afia Walking Tree 383 - days ago 
Where do I start downloading my databases with this tool? I will only get confused if I try to read lots of steps, where can I just copy and click??
janani.t 379 - days ago 
Hi Alfia,

Sorry for the delayed response.

You can pull data from your local database and upload the same into Zoho Reports by following few simple steps.

1. Download the appropriate Upload Tool for your OS and extract the same.
https://reports.wiki.zoho.com/Download-and-Setup.html

2. Specify the Connection setting in the database_connection_params.conf file as said in the following help document.

https://reports.wiki.zoho.com/Uploading-Data-from-Local-in-house-Databases.html#Configure%20Local%20Database%20Connection%20Settings

3. Specify the SQL query to fetch data from your local database and upload the same into the corresponding column in Zoho Reports table in the database_sql_queries.xml file . A part of the query you also need the provide details about the Zoho Reports database into which the data that is fetched from executing the SQL SELECT query is to be uploaded.

4. Run the UploadFromDB.bat / UploadFromDB.sh file under <Tools_Home>bin directory along with the required parameters. You have to provide Zoho Reports User Name and Password in the order shown below.


UploadFromDB.bat <zohoreports_username> <zohoreports_password>

5. Data will be uploaded into Zoho Reports table.

Hope this clarifies your doubt. In case you have any difficulty in configuring the tool, please do let us know. We will help you on the same. If you require, we can also schedule a call to help you upload data from your database. If this is your preference, please send us your contact number and a convenient time for the call to support@zohoreports.com.


Sincerely,
Janani | Zoho Cares
André Boavistta 373 - days ago 
There are a tool to import from other databases, but there aren´t a tool to import direct from Zoho Creator? It´s necessary to export a csv from Zoho Creator and them, import to Zoho Reports?
janani.t 372 - days ago 
Hi Ander,

Thank you for raising your question.

Zoho Reports does support importing data directly from Zoho Creator. Two type of integration are supported between Zoho Creator-Reports. They are:


1. Synchronizing data from your Zoho Creator Application into Zoho Reports. For more details, refer to the following link.
https://show.zoho.com/embed?id=28547000000008003&loop=false&menu=true&toolbar=true&full_screen=false&slide=1

2. Creating Web Forms using Zoho Creator and saving the data into Zoho Reports. For more details, refer to the following link.
https://reports.wiki.zoho.com/Creating-Data-Entry-Forms-for-Zoho-Reports-using-Zoho-Creator.html

Believe that the above information is beneficial. For further clarification, please do write to us at support@zohoreports.com. We will help you on the same.

Sincerely,
Janani | Zoho Cares
autoforms1 357 - days ago 
Hi,

I'm trying to simply import a CSV file from our server to Zoho, but I am getting an 'invalid URL' error message. It seems the upload tool is logging into Zoho correctly, but then the import process stops and the error msg is displayed.

Can you please tell me what the problem is and how to correct it.


Thanks

John Bound
Prabhakaran S 355 - days ago 
Hi John Bound,

Thank you for contacting us. Sorry for the delayed response.

Please send the exact error message which you have received during the upload process. If possible kindly send us the log files which are found within the directory "UploadTool_Home]/logs". You can send the information and files to support@zohoreports.com


Regards,
Prabhakaran.
samanvitha (Guest) 307 - days ago 
bitlasoft@bitlasoft-desktop:~/zohopro/ZohoReports/UploadTool/bin$ CSVUploadConsole.sh zohopro/data_backup.csv workbook stands append samanvitha makemywishtrue

While executing this command i am getting an error like command not found --------CSVUploadConsole.sh: command not found-----------
("OS => LINUX")
janani.t 306 - days ago 
Hello samanvitha,

The example snippet added in the document illustrates uploading data in Windows machine. To upload data from Linux, please add a "sh" before the execute file.

Ex:

sh CSVUploadConsole.sh <full_path_of_the_csv_file> workbook stands append samanvitha <password>


Believe this will help, if the issue persists, please get back to us with the log file at support@zohoreports.com. We will help you solve this.
sara 230 - days ago 
hii

would you please share with me and teach what to do?
Anand Narayanan 230 - days ago 
Hello Sara,

For assistance with configuring and using the upload tool, please send an e-mail to our Support Team at support@zohoreports.com - they would be happy to assist.

Regards,

Anand N | Zoho Reports
Post a comment

Your Name or E-mail ID (mandatory)

Note: Your comment will be published after approval of the owner.





 RSS of this page