CSV Uploader
Topics discussed
The CSV Upload Tool can be used to upload a csv file which has more than 100,000 rows or size greater than 3 MB. The tool splits the file and uploads it in Zoho DB.
Please note that this tool uploads only CSV files. All the other file formats are not supported.
The CSV Uploader Tool can be downloaded from the below url,
http://css.zohostatic.com/db/api/v1_0/m5/CSVUploadTool_linux.zip
http://css.zohostatic.com/db/api/v1_0/m5/CSVUploadTool_windows.zip
Proxy Configuration
- Open <Tools_Home>/conf/params.conf
- The tool assumes that you have a direct internet connection. Else follow the following steps
- Specify USEPROXY as true
- Specify PROXYHOST as <your_proxy_host>
- Specify PROXYPORT as <your_proxy_port>
- Specify PROXYUSERNAME as <your_proxy_username>
- Specify PROXYPASSWORD as <your_proxy_password>
Uploading Data
GUI Mode
- Run CSVUploadGUI.bat / CSVUploadGUI.sh under <Tools_Home>\bin
- Provide the required inputs in the GUI.
Console Mode
- Run CSVUploadConsole.bat / CSVUploadConsole.sh
Parameters
Mandatory Parameters:
The below parameters should be given as a command line arguments for Console mode execution.
FILENAME
| The CSV file to be uploaded |
| DATABASENAME | The name of the database which has the mentioned table ( Please note that the database should already be present in db.zoho.com). |
TABLENAME
| The table name in which the CSV file to be uploaded
|
| Import Type | Can be any one of APPEND/UPDATEADD/TRUNCATEADD.
- APPEND - appends the data to the end of the table.
- UPDATEADD - updates existing data and appends new data. For this you also need to configure
ZOHO_MATCHING_COLUMNS in params.conf under the conf directory.
- TRUNCATEADD - Deletes the existing data and adds new data.
|
| USERNAME | Your Zoho account login name |
| PASSWORD | Your password for accessing your account. |
Optional Parameters:
Please
refer the below link to see all the import parameters available. These
parameters should be configured in the params.conf present under
<Tool_Home>/conf/ directory.
http://zohoreportsapi.wiki.zoho.com/Importing-CSV-File.html
Viewing the data online
- Login to http://db.zoho.com
- Click on the corresponding Database name under "My Databases"
- Click on the corresponding table on the LHS to view the uploaded data.
