FAQ
My date columns are imported as a string column. How do I resolve this?
Do ensure that the column type is set as DATE, DATETIME or equivalent types in the source table. In case your column type is set as string or similar types, then your data column may get imported as a string column. In this case you can convert it ...
I want to sync data more frequently than 3 hours. How can I do this?
Yes, you can. It is possible to sync your data more frequently than 3 hours. Do write your exact requirement to us at support@zohoanalytics.com. We'll get back to you on this.
Can I change the cloud data source of my Workspace?
Yes, you can change the cloud database from which you are importing data into your workspace. Follow the steps below to change the data source of your reporting database. From Workspace Explorer, click Data Sources. In the Data Sources section, ...
I get this error - 'Sorry, problem in connecting to your database server.' How do I overcome this?
This error occurs in the following scenario: Incorrect connection settings are specified - Ensure that the correct Endpoint, Port and user credentials are specified. Your cloud database service does not recognise Zoho Reports as an authenticated ...
My scheduled import from a cloud drive has failed continuously. Why?
Scheduled import from a cloud drive may fail due to one of the following reasons. File has been deleted - Ensure that the source does exist in your cloud drive. You have signed in as different user - You cannot map two account from the same cloud ...
I get this error - 'Sorry, Zoho Analytics was unable to import this file' while importing Excel files. How do I overcome this?
This error occurs in the following scenario: Invalid Excel file has been selected for import. Any conditional format is specified with infinite range. For Eg: A:A Any pivot view is created in the Excel workbook. Invalid Lookup or any reference error ...
Some of the records are not imported into Zoho Analytics table. Why?
Zoho Analytics will auto identify the data type of the column based on the first fifty records. In case there are any incompatible records ., import errors will be generated. Zoho Analytics will handle the error conditions as you have set in On ...
Can I schedule my import in every N minutes?
Yes, it is possible to enable scheduling EveryN minutes. Do write your exact requirement to us at support@zohoanalytics.com. We'll get back to you on this.
Will columns added to my source table automatically added in Zoho Analytics when the scheduler runs?
Yes, new columns added in your source table can automatically get added into the Zoho Analytics table to which data is being added. To do this, you need to select the Import any new columns added subsequently in the Data URL option in the scheduler.
Can I set up an import scheduler with a dynamic web URL?
Scheduling import of data from a dynamic URL is currently not supported. This could be achieved by the following workaround. Write a script (or an application) that will hit the dynamically constructed URL to retrieve the data from the web at regular ...
What are all the import options available in Zoho Analytics?
The following import options are available in Zoho Analytics: Import from Files - Zoho Analytics allows you to import data stored in tabular file formats like CSV, XLS (Excel), JSON, OData, and HTML files in your system. Import from Feeds - Zoho ...
How to upload large data into Zoho Analytics?
If you have a large amount of data (greater than 100 MB or 1000,000 rows) to be uploaded into Zoho Analytics, loading them using the Web Graphical Interface of Zoho Analytics, might not be the best way. As the upload happens over the Internet, slow ...
Any restriction on the size of data that could be imported?
Zoho Analytics has the following restrictions on the size of data import. You can upload a maximum of 1,000,000 rows and the file size should not exceed 100 MB. However, you can upload huge CSV files using the Databridge. Zoho Databridge is a ...
How to upload/push/import data periodically into Zoho Analytics?
You can periodically upload/push/import of data into Zoho Analytics through any of the following supported means: Setup periodic import of data from Web URL based CSV data. Read for more details. Use Zoho Databridge and setup periodic schedules. Use ...
How to upload/push data from in-house and hosted applications into Zoho Analytics?
Refer to the solution page "How to upload/push data from in-house applications" for details.
What are the file formats from which you can import data?
You can import tabular data from the following file formats: Excel Spreadsheets (.xls) CSV (Comma Separated Values) TSV (Tab Separated Values) Any tabular data in text file format HTML files MS Access (.mdb) files Odata Web URLs which generates data ...