Import Data

You can import data into your Zoho Creator apps. This data can be in files stored in your computer or in the cloud (Dropbox, Google Drive, Zoho Docs, etc), or from your MS Access application. The Import Data option will be displayed only to the application administrator and not for shared users of that app. Shared users may make use of the migration tool to import data.

Import Data from files stored in your Computer

  1. Access your Zoho Creator application. Open the Report to which you wish to import data into. Click on the More Options menu - the top-rightmost option (as show in the below screenshot). Select the Import Data option.
  2. Select the File Type as XLS, CSV or TSV.
  3. Set the Data Location as Local Drive.
  4. Click Browse and select the required file to upload. The supported file-formats are - .CSV, .TSV, .XLS, .XLSX and .TXT.
  5. Click Next. You will reach Step 2 of 3 where the data stored in the selected file will be displayed.
    • The data in the first row will be displayed as the default Label Name for each column. If the option First row of data is field label names is checked as "Yes", the first row values will be displayed as label names.
    • Select the appropriate field for each column from the drop-down displayed below the label names.
    • Select the appropriate option from the On Import Errors list box:
      • Skip corresponding rows: If there is any conflict found in any of the row values, Zoho Creator will skip the corresponding rows. Eg. If a row containing an email field type has text, then ZC will not import that row alone and the rest of the rows will be imported.
      • Set empty values for the column: If there is any conflict found in any of the column values, Zoho Creator will set empty(NULL) values for the corresponding columns.. Eg : If a integer column has text, then ZC will not import that column value alone and the rest of the columns of that particular row will be imported.
      • Don't import the data: If there is any error in the data to be imported, the entire data will not be imported.
  6. Click Import Data to create the application with the form data. The existing report will be updated with the new records.

Note:

  • Make sure column names in the data are same as the field label names.
  • Data size should be less than 5MB and the number of rows should be less than 100000, for the data to be imported properly.
  • The "Import Data" option will only append new records. You cannot update existing records using this option

Also watch this video to help you get started with importing data from your XLS file.

Import Data from Cloud

Zoho Creator offers importing data from files stored in various cloud storage services. The supported services include -

  • Google Drive
  • Zoho Docs
  • OneDrive
  • Dropbox
  • Box

To import your files from any of these cloud storage services,

  1. Navigate to Import Data option on your Zoho Creator Reports page.
  2. Click on Cloud -> Choose files from Cloud and click on "Next".
  3. Now select the cloud service, which contains your files, from the left pane. You will have to authenticate yourself, for the cloud storage service provider, to access your files.
  4. Once authenticated, select your file that needs to be imported and click onAttach. 
  5. The selected file now gets attached. Click on Next to fill the form with the data present in the attached file.

Paste Data from XLS file

  1. Navigate to Import Data option on your Zoho Creator Reports page.
  2. Select the File Type as Excel, CSV or TSV.
  3. Select the Paste Data radio button.
  4. Copy the data from your .xls file or from other file formats that store comma separated values or tab separated values.
  5. Paste the data copied from your .xls/.csv/.tsv file.
  6. Click Next to go to the next screen. The next screen will display the data in the following format:
    • The data in the first row will be displayed as the default Label Name for each column. If the option First row of data is field label names is checked as "Yes", the first row values will be displayed as label names.
    • Select the appropriate field for each column from the drop-down displayed below the label names.
    • Select the appropriate option from the On Import Errors list box:
      • Skip Corresponding Rows: If there is any conflict found in any of the row values, Zoho Creator will skip the corresponding rows. Eg. If a row containing an email field type has text, then ZC will not import that row alone and the rest of the rows will be imported.
      • Set Empty Values for the column: If there is any conflict found in any of the column values, Zoho Creator will set empty(NULL) values for the corresponding columns.. Eg : If a integer column has text, then ZC will not import that column value alone and the rest of the columns of that particular row will be imported.
      • Don't Import the data: If there is any error in the data to be imported, the entire data will not be imported.
  7. Click Import Data to create the application with the form data. The existing report will be updated with the new records.

Note:

  • Make sure column names in the data are same as the field label names.
  • Data size should be less than 5MB and the number of rows should be less than 100000, for the data to be imported properly.
  • The "Import Data" option will only append new records. You cannot update existing records using this option.

Import Data by using the MS Access & Excel Migration Tool

Please refer this page to know about using the migration tool to import data.

Import Data with hyperlinked text

To import data with hyperlink, use the following format in your import sheet:

< a href= "http://www.zoho.com" >Visit Zoho < /a >

where,
Visit Zoho is the hyperlinked text
http://www.zoho.com is the link to which the hyperlinked text redirects 

Export Data

The Export Data feature in Zoho Creator enables you to export your data anytime in the formats - Grid (excel format), PDF, HTML, RSS, JSON, CSV and TSV. You can - export data as spreadsheet and take it to Zoho Sheet if you want to do some analysis, export it as PDF if you want to print/email the data, export as HTML to view data in your browser, use RSS feed to subscribe to changes in the data, or javascript based JSON feed, use CSV, TSV formats when required.

To export your data to different formats,

  1. Click on Export option displayed on the top-right corner of the view header, in Live mode.
  2. Select File Download tab and click on the required format to download the file.

Zoho Creator does not currently support disabling the Export option in the view. However, if the view is embedded in a website, the Export option will not be available to the users.

Supported Export formats

  • Spreadsheet: Data can be viewed in Microsoft Excel, Openoffice, Spreadsheet and Zohosheet.
  • HTML Document: Data can be opened in internet browsers like Internet Explorer, Firefox, Safari etc.
  • PDF Document: Portable Document format is a printer-friendly document format supported by Adobe Reader, Foxit Reader, PDF XChange, etc. Currently ZOHO Creator supports PDF rendering for List views and HTML views only.
  • CSV Feed: This format is used for exchanging data between various spreadsheet programs.
  • TSV Feed: Flat-file format commonly used for inter-application data transfer.
  • JSON Feed: A javascript-based, lightweight data exchange format.
  • RSS Feed: XML-based format for allowing people to subscribe to changes in the data. Supported by Bloglines, Google Reader, Netvibes, etc.  To get the RSS feed URL -

1. Click on Settings - Links - Permalink option from the top-right corner of the report in live mode. If your report is private, use the Publish option in the Permalink dialog, to get the public permalink. The permalink will be displayed in the format given below.

https://creator.zohopublic.com/<application_owner_name>/<app name>/view-perma/<view_name>/<encrypted code>

2. Reframe the above url in the format given below to get the RSS feed URL.

https://creator.zoho.com/<application_owner_name>/<app name>/rss/<view_name>/<encrypted code>

Once you copy the link and submit it in a RSS feed reader you will be able to see the latest 25 records submitted. To see the entire records, add complete=true at end of the link.

The RSS feed is automatically updated. The frequency with which the RSS feed is updated depends on the Feed reader used and how often the feed reader is configured to fetch the updates from the form/view. We have performed some tests on various Feed Readers and the update time varied from one to another. On an average the RSS update time limit varies between 5-10 minutes.

Export Page to PDF

Zoho Creator provides a feature called Page, which is a customized report created using HTML tags and Deluge Scripting. In addition to exporting data from Reports, data presented in Pages can be exported as a PDF file. To enable this,

  1. Edit your application. Go to your Dashboard and select the intended Page (for which the PDF-export is to be enabled).
  2. Click on Settings and choose Header Option (as shown in the screenshot below).
  3. In the Editing the task - 'Header Option' window, check the PDF option and click Done​.

The above mentioned steps detail one way of exporting Page data to a PDF. The same can also be done using Functionality based URLs - Convert Page to PDF.