Integrating the powerful reporting & analytics functionality of Zoho Analytics into Zoho Creator has been one of the most requested feature. We have heard it and enabled the first step towards this goal.

In Zoho Analytics, we have introduced the feature of scheduled periodic import of CSV files from any accessible Web URL. With this feature you could set up Zoho Analytics to periodically fetch data in CSV format from any accessible Web URL. This would be really useful in scenarios where you have new data being published or updated periodically and you would like get those updates inside Zoho Analytics for reporting and analysis. Till now you had to re-import this data manually into Zoho Analytics, every time an update is available. Now you just have to setup up the periodic import feature and Zoho Analytics would do the rest for you.

With this feature you could also (enable Zoho Analytics to) periodically fetch data from your Zoho Creator Application into Zoho Analytics as changes happen to the same. As the latest data is made available inside Zoho Analytics, you could create any type of powerful reports with it. The reports created using Zoho Analytics could also be embedded back inside your Zoho Creator application using the new HTML Page view feature introduced in Zoho Creator 3.0

The following presentation demonstrates how you could periodically import data from Zoho Creator into Zoho Analytics:

Do give the above feature a try and let us know your feedback. This is just the first step in making available the powerful reporting functionality of Zoho Analytics to Zoho Creator users. We are continuing our work on this problem to further simplify the process. A much closer GUI level integration of making report creation features of Zoho Analytics available within Zoho Creator is in development. We will keep you posted once we are ready with it…

Happy Reporting and Keep tab on further development…

Clarence
Zoho Analytics – Online Reporting & BI Service

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  1. Simon Holden

    This doesn’t seem to work anymore…

    • Derek

      Did you ever find a good solution for this?

      All I want to do is use Zoho Forms to add data to a Zoho Sheet or Zoho Database which I can then use to generate a Zoho Report(s). What am I missing? This seems like it is much harder than it should be…

      Thanks for any info.

      • Arvind

        Simon, Derek: The scheduled import from Zoho Creator to Zoho Analytics works fine, as explained in the slide show. I’m giving the steps here once again.

        1. Get the permalink from Zoho Creator, from Links -> Permalink
        2. In Zoho Analytics, give the URL in Import from Files/Feeds’ option
        3. Choose ‘HTML Content’ as ‘File Type’ and ‘Web’ as ‘Data Location’ option
        4. In the next screen, choose the correct HTML table which contains the Creator form data (typically, it is the last table, Table 10)
        5. Zoho Analytics auto identifies the columns and the data types to be imported
        6. Click ‘Create’ and the table gets created in Zoho Analytics, with the imported data from Zoho Creator
        7. You can also use the ‘Schedule This Import’ option to get the data imported periodically

        Refer to the below page to know about more ways to integrate Zoho Creator with Zoho Analytics:
        https://www.zoho.com/analytics/reporting-on-zoho-creator-applications.html

        Let me know if this helped, and if you are still facing issues.

        ps: We are also working on an in-built integration with Creator, as another option. Will post about it once it is available.

  2. Steven Bell

    Was there any further development in linking Zoho DB to Zoho Creator?

  3. Steven Bell

    Was there any further development in linking Zoho DB to Zoho Creator?

  4. kadost

    Before we go into using zoho fulltime I would like to know how stable the company is? Can anyone give me a heads up on your experience and if you know any financial information about Zoho?Thanks,John

  5. kadost

    Before we go into using zoho fulltime I would like to know how stable the company is? Can anyone give me a heads up on your experience and if you know any financial information about Zoho?Thanks,John

  6. danae.shell

    Just for information, if you’re getting a random bit of HTML in your Report when you try to import from Creator, it’s because you need to click the option for a URL “without login” on the Creator export screen. It’s at the top of the window.

  7. danae.shell

    Just for information, if you’re getting a random bit of HTML in your Report when you try to import from Creator, it’s because you need to click the option for a URL “without login” on the Creator export screen. It’s at the top of the window.

  8. pavan.keerthi

    Hi,
    I am getting errors in import wizard after it fetched the rss feed.basically al lthe html code is ending up as junk column data in preview grid

  9. pavan.keerthi

    Hi,
    I am getting errors in import wizard after it fetched the rss feed.basically al lthe html code is ending up as junk column data in preview grid

  10. Deepa Govind

    Is the CSV import only way to connect to report?Is it possible to use API and enter data into report/table via the zoho creator form.I am trying to learn. So please bear with me if i am asking the obvious.
    Regards
    Deepa

  11. Deepa Govind

    Is the CSV import only way to connect to report?Is it possible to use API and enter data into report/table via the zoho creator form.I am trying to learn. So please bear with me if i am asking the obvious.
    Regards
    Deepa

  12. shibu_alexis

    Hi Vacapdk9,
    Please follow the below steps to schedule the importSteps:
    1. Open the table that you want to schedule importing from the same URL which the table is created.2. Click on import > Schedule/Refetch Import option from the toolbar3. Click on the Edit button and input the schedule timing details.Note: If you want to fetch the updated information immediately, click on the Refetch Now button.4. Click on Save buttonImporting is Scheduled.Thanks & Regards,
    Shibu Alexis
    Zoho DB & Reports

  13. shibu_alexis

    Hi Vacapdk9,
    Please follow the below steps to schedule the importSteps:
    1. Open the table that you want to schedule importing from the same URL which the table is created.2. Click on import > Schedule/Refetch Import option from the toolbar3. Click on the Edit button and input the schedule timing details.Note: If you want to fetch the updated information immediately, click on the Refetch Now button.4. Click on Save buttonImporting is Scheduled.Thanks & Regards,
    Shibu Alexis
    Zoho DB & Reports

  14. vacapdk9

    I already had an import set from the csv feed but I forgot to set the schedule. How do I edit my table to set the schedule?

  15. vacapdk9

    I already had an import set from the csv feed but I forgot to set the schedule. How do I edit my table to set the schedule?

  16. Ricky

    This is exciting. This has been one of my main wishes when I first saw Zoho DB and Reports.I only hope that the integration would be user-friendly / easy to learn for non-IT person like me.Keep up the good work!

  17. Ricky

    This is exciting. This has been one of my main wishes when I first saw Zoho DB and Reports.I only hope that the integration would be user-friendly / easy to learn for non-IT person like me.Keep up the good work!

  18. Ramesh

    Zoho Sheet already has integrated Zoho DB’s reporting capabilities. Zoho Sheet’s Pivot tables and Pivot charts functionality, launched in April, actually integrates Zoho DB’s reporting capabilities. You can easily create pivot tables and charts from your existing data in Zoho Sheet. Let us know what kind of integration you are looking at.

  19. Ramesh

    Zoho Sheet already has integrated Zoho DB’s reporting capabilities. Zoho Sheet’s Pivot tables and Pivot charts functionality, launched in April, actually integrates Zoho DB’s reporting capabilities. You can easily create pivot tables and charts from your existing data in Zoho Sheet. Let us know what kind of integration you are looking at.

  20. Eric Schultz

    How about integrating DB & Reports with Zoho Sheet? I mean Sheet is like a DB so what I really want is the power of the Reports using a Sheet as my source.It seems to me the DB part of DB & Reports is having the hardest time gaining traction – how do you get the data into the DB? Of course there’s the API but within Zoho itself it’s not used (common beef of mine: companies that don’t integrate their own products).It would be cool if Sheet had way to use Reports from DB & Reports; and if Creator an option to “store data in DB” (not sure how this would affect Marketplace apps, but you guys are smart, you’ll figure it out).

  21. Eric Schultz

    How about integrating DB & Reports with Zoho Sheet? I mean Sheet is like a DB so what I really want is the power of the Reports using a Sheet as my source.It seems to me the DB part of DB & Reports is having the hardest time gaining traction – how do you get the data into the DB? Of course there’s the API but within Zoho itself it’s not used (common beef of mine: companies that don’t integrate their own products).It would be cool if Sheet had way to use Reports from DB & Reports; and if Creator an option to “store data in DB” (not sure how this would affect Marketplace apps, but you guys are smart, you’ll figure it out).

  22. Clarence

    Hi Mark,Sorry I missed your comment. Yes we will keep you posted on the progress early November. Mail us if you need any clarifications to support at zohodb dot comClarence

  23. Clarence

    Hi Mark,Sorry I missed your comment. Yes we will keep you posted on the progress early November. Mail us if you need any clarifications to support at zohodb dot comClarence

  24. Mark

    Clarence,I would appreciate any news or updates you can give me on the progress of the integration around that time. I will be doing a presentation to our company in early December and this will help make the case for us to adopt for larger corporate opportunities as well as the small/medium business that I know creator was designed for.my registered username is TPN_DEV so feel free to drop me a mail at my registered address or my zoho mail tpn_dev (at) zoho dot comThanks
    Mark

  25. Mark

    Clarence,I would appreciate any news or updates you can give me on the progress of the integration around that time. I will be doing a presentation to our company in early December and this will help make the case for us to adopt for larger corporate opportunities as well as the small/medium business that I know creator was designed for.my registered username is TPN_DEV so feel free to drop me a mail at my registered address or my zoho mail tpn_dev (at) zoho dot comThanks
    Mark

  26. Clarence

    Hi Earl,That’s a very good idea. We do not have any immediate road map of releasing any ERP application, although that cannot be ruled out for the future.Do let us know if you need any assistance in your development.Thanks,
    Clarence

  27. Clarence

    Hi Earl,That’s a very good idea. We do not have any immediate road map of releasing any ERP application, although that cannot be ruled out for the future.Do let us know if you need any assistance in your development.Thanks,
    Clarence

  28. Earl Rudolfo

    Hi Clarence,Here’s what also on my wish list. To develop small business ERP functionality utlizing Zoho DB & Reports. Is this something that Zoho is contemplating?

  29. Earl Rudolfo

    Hi Clarence,Here’s what also on my wish list. To develop small business ERP functionality utlizing Zoho DB & Reports. Is this something that Zoho is contemplating?

  30. Clarence

    Thanks Earl for the feedback’s. Do let us know if you require any assistance in building your Financial Dashboards. We would be more than happy to help you out.Thanks,
    Clarence
    Zoho DB & Reports

  31. Clarence

    Thanks Earl for the feedback’s. Do let us know if you require any assistance in building your Financial Dashboards. We would be more than happy to help you out.Thanks,
    Clarence
    Zoho DB & Reports

  32. Earl Rudolfo

    Great feature Zoho. I remember seeing this feature available with Zoho Sheet and Zoho DB some time ago, but it’s a great idea moving forward to make this avalable through Creator as well as from an accessible Web URL. Since I’m looking to develop Business Intelligence Financial Dashboards utilizing Zoho DB, this is very exciting news. Keep up the good work Zoho!

  33. Earl Rudolfo

    Great feature Zoho. I remember seeing this feature available with Zoho Sheet and Zoho DB some time ago, but it’s a great idea moving forward to make this avalable through Creator as well as from an accessible Web URL. Since I’m looking to develop Business Intelligence Financial Dashboards utilizing Zoho DB, this is very exciting news. Keep up the good work Zoho!

  34. Clarence

    Hi Mark,Thanks for the comments. We would have a better visibility on the estimated delivery time lines early November. If you might be interested we could keep you posted during that time (early November) on the estimations.Thanks,
    Clarence
    Zoho DB & Reports.

  35. Clarence

    Hi Mark,Thanks for the comments. We would have a better visibility on the estimated delivery time lines early November. If you might be interested we could keep you posted during that time (early November) on the estimations.Thanks,
    Clarence
    Zoho DB & Reports.

  36. Mark

    This is an important step forward to closer integration.Just to be able to show this working to some interested parties in the short term is gonna drive interest for me.Not trying to nail you down to a time of day but ballpark estimate for full integration? Q4 2008/Q1 2009???Nice one Zoho.Mark

  37. Mark

    This is an important step forward to closer integration.Just to be able to show this working to some interested parties in the short term is gonna drive interest for me.Not trying to nail you down to a time of day but ballpark estimate for full integration? Q4 2008/Q1 2009???Nice one Zoho.Mark

  38. Sridhar Vembu

    Right now, user has to go through the CSV feed steps. We are working on automating the whole chain, and integrating it. That should be available in a future update.Charting engine: they use the same engine, but not the same version. They will be syncing up in due course.

  39. Sridhar Vembu

    Right now, user has to go through the CSV feed steps. We are working on automating the whole chain, and integrating it. That should be available in a future update.Charting engine: they use the same engine, but not the same version. They will be syncing up in due course.

  40. Eric Schultz

    How would this work for Creator Apps that are published in the Market Place and installed by other users? Would they be responsible for creating their own CSV feeds and building their own DB & Reports? Would they have to modify the code in the applications HTML Views to point to their own DB & Reports analysis?And do Creator, DB & Reports, and Sheets use the same charting engine?

  41. Eric Schultz

    How would this work for Creator Apps that are published in the Market Place and installed by other users? Would they be responsible for creating their own CSV feeds and building their own DB & Reports? Would they have to modify the code in the applications HTML Views to point to their own DB & Reports analysis?And do Creator, DB & Reports, and Sheets use the same charting engine?