How large can a table grow?
Hi I have an application that can have tables with several 100 million entries. What are the limits on the Zoho tables size? By number of rows or size of the table or total number of data elements. Please advise if there is any special way to handle such large data stores. Thanks Anand
Problem referencing one query table from another
The screen shot above shows that I am trying to reference one query table from another and getting the message "Unknown table or alias" can you explain why this is and is there a workaround? Trevor
RSS feed or Scheduled email from Zoho DB
Hi, I have created a table in zoho db and it get updated with data ( more rows added) every hour. I need to get an RSS feed or a scheduled email that contains a report with the new rows. Can you please point to an example of how this can be accomplished ? I will be happy to pay you a fee to help me with this. Thank you Anand
Import from Zoho creator issue
I can't get the import working at all. I can get it working but the database can't display columns properly. From creator: export as csv feed, copy html (no login prompt) in DB & Reports: import csv (url) Then I can't get the database in the right format at all, be it by comma, semi-colon, tab... doesn't matter what I select it is all wrong. Interesting thing is that if I export from creator as xls (not csv), open in Excel, save as csv and THEN import in DB & Reports it is all fine. But I lose the
Subquery issue
I have a table called STATUS that has a column named BUILD. The build column is integer and populated with values between and 1 and 6. The following subquery in a NEW_QUERY_TABLE: select build from ( select build from status ) subquery returns the error 'Invalid column 'build' used in SELECT query.' This is valid SQL that I have tested in PostgreSQL. Is this unsupported?
Remove "ticket" from mandatory parameters on EXPORT API calls
I want to display data from my Zoho Reports database on my website. My plan was to use <script> tags for the API call (i.e. the HTTP request) and then, by specifying a JSON callback function, to manipulate the data in the response using Javascript. However, this isn't possible because I need to include a "ticket" parameter in the API call. I can't request the "ticket" programmatically because I think that would mean storing my Zoho username and password openly on my web server (unless anyone can
Zoho Reports and Word Docs
HI All, Loving the features of both Zoho Reports and Zoho Creator. Could anyone assist me with the following.... I have a Word document that i have to send out to a client once a week that looks all pretty (uses client logos and a weekly preamble blah blah blah). Many of the Graphs and Data Tables that i can create on Zoho Reports also need to be placed into this volumous Word Doc. Is there any easy way to either populate the Word doc automatically with these Graphs and Data Tables or even an easy
Reports is not running under Firefox 3.5.2
I have a problem with zoho reports running on FF3.5.2. I get the left hand navigation bar that shows my recently used reports but I do not get the report view in the centre pane. None of the menu items work (new save edit design etc) but home | what's new etc are still active. I can either run this in IE8 or run it in FF in IE mode both of these options are frustrating because I have to log in on the different browser regards Trevor
Refetch from Creator not working.
Dear Sirs, I'm reporting an issue where I haven't been able to refetch information from zoho creator. It has been working successfully before, but now it isn't . The issue is that it says that the host is unknown or not reachable. This function has been excellent for my apps and necessary for the data to be updated in the reports. In await of your prompt response. Best Regards, Denis
Performing "SELECT * FROM table" with &ZOHO_SQLQUERY
I am able to use the parameter &ZOHO_SQLQUERY=SELECT * FROM table but the results are not correct. In my table, I have two columns (col1, col2), but all columns are named the same (they are named the first column in the table) <result> <rows> <row> <column name="col1">text</column> <column name="col1">text</column> </row> <row> <column name="col1">text</column> <column name="col1">text</column> </row> etc... All the columns are named col1. Please help! Thanks!
ZOHO_SELECTED_COLUMNS doesn't work
The parameter ZOHO_SELECTED_COLUMNS doesn't work for several OUTPUT_FORMATs (CSV, XML, HTML) but it works for PDF. The following works, and will create a PDF with only the "name" column: http://reports.zoho.com/api/<name>/<DB>/<table>?ZOHO_ACTION=EXPORT&ZOHO_OUTPUT_FORMAT=PDF&ZOHO_ERROR_FORMAT=XML&ZOHO_API_KEY=<api_key>&ticket=<ticket>&ZOHO_API_VERSION=1.0&ZOHO_SELECTED_COLUMNS=name I tried to change the OUTPUT_FORMAT to XML and it outputs all the columns, but I only want the "name" column: http://reports.zoho.com/api/<name>/<DB>/<table>?ZOHO_ACTION=EXPORT&ZOHO_OUTPUT_FORMAT=XML&ZOHO_ERROR_FORMAT=XML&ZOHO_API_KEY=<api_key>&ticket=<ticket>&ZOHO_API_VERSION=1.0&ZOHO_SELECTED_COLUMNS=name
Help
Hi Are there any tutorials showing how to create a simple application for my website. I have an xls document with a list of companies, names and other information. I would like to be able to have my viewers be able to search this list and have the results show. I apologize I have no database experience and this site was recommended. Thanks Ant
No Refetch/Schedule Import menu option is available
Hi I am trying Schedule Imports Periodically function, But there is no Refetch/Schedule Import menu option si appeared Import Button on tables as you see in the attached screenshot. Could you kindly show how to access the menu option for Refetch Schedule Import Function? Regards Keita
Possible to upload docs into a database field/cell ?
Hello to everyone. I have read the help about data types, but I will ask anyway: Can I upload a pdf document (or any other file type for that matter) into a database "cell"? As a teacher I would like to upload worksheets into an "English worksheet" database and then publish this database in my website. Parents could then download them. If this is not possible now, how about later? Any chance for a "file" datatype? Thanks.
Selecting multiple items from a lookup column.
Is this possible? If so, anyone have any insight into how to get it done? Thanks beforehand.
Filtering a chart based on a column of type decision box
It looks like filtering data in a chart based on a column of type Decision Box does not work. You always get No Available Data. To reproduce: 1) Create a table with at least one column of type Decision Box 2) Populate some data with both Yes and No 3) Create a chart on the table without any filter. The chart returns data 4) Add a filter for the decision box and set one condition: no available data. In the filter, the values are displayed as true or false, while in the table they are entered as Yes
Date filter
Can I create a prompt and/or filter based on a date range - e.g. between 01-01-2009 to 31-12-2009 in Zoho Reports? Thanks
Zoho Reports, Pivot-Table Embedding and Sorting:
Question1: How can I allow the user to apply filters and modify columns and rows with an IFRAME-embedded zoho pivot table report? Question2: How can I change the sort order of columns in a zoho pivot table report, so that the sort order is "customized" instead of "alphabetical" (for example, instead of Fall Spring Summer Winter ... I would like the sort order of the columns to be Fall Winter Spring Summer )
Chart Axis Ranges
New User to Zoho. I have two date/time fields on a form and then a formula field that returns the number of hours between these two dates. Since I am tracking at the time level, almost every value is unique which is fine. I created a bar chart of this hour discrepancy column and I get a lot of values on the X-Axis. What I want to show is only two bars (one for values that are less than 24 hours, and one for more than 24 hours). I thought the 'ranges' section under 'filter' was going to help
Automating Report Updates
I have an access table with the data from our quoting application. I want to automate extracting the data from here into the Reports data sheet and then update specific reports for our suppliers to see about their individual product performance. Can anyone help with how I can go about this. It would be ideal if they had a link to the report without a login that they just kept and we just updated the backend data for this.
Pivot View Grand Summarys
Hello, I have noticed that when you run a pivot view chart, at the bottom there always is a total bar and grand summary. This is a good feature and all, but when information is taken from adwords and placed into this chart, the averages do not match up. Example: This is what is given out of Adwords Date Campaign Clicks Avg CPC Cost Conversions (1-per-click) Cost/Conv. (1-per-click) 9-Jun 800 all 6958 $0.70 $4,891.48 773 $6.33 9-Jun 800 frames 637 $0.83 $527.51 51 $10.34 9-Jun 800 futons 778 $1.04
Grand Total Calculations
The following SQL produces the following table SELECT "REGION_NAME" as "Region", sum("TOTAL_STAFF") as "Total Staff",sum("NO._MEMBERS") as "Total Members",abs(sum("NO._MEMBERS")/sum("TOTAL_STAFF") * 100) as "Penetration (%)" FROM "Schools Master List" GROUP BY "REGION_NAME" GO Region Total Staff Total Members Penetration (%) Eastern Metro 71 63 88.73 Western Metro 164
Moving DB to another user
Is it possible to move a database and all it's associated reports to another user? If so, will all the existing permissions stay? Reason is that a user has setup many reports from a database and they are leaving but have the reports in their personal zoho account.
Bugs in query?
Hi, I've a Db with 4 records but if I launch this query: select * from "DB CONTATTI" the query gives me only 2 results! Thanks for all your feed back jacopo
Pivot view displaying to 16 decimal places
I have used the pivot view in my report and have decimal data in the row entries which are only 1 decimal place. however I find that the 'total for' row is calculated to 16 decimal places. Is there any way I can change this from 16 to 1 decimal place?
do not want zoho output format xml to show up
hello maybe my brain is fried, but can you help me with this issue, on the sample for "Bulk Adding / Updating via CSV" on reports via the api, the sample url: http://reports.zoho.com/api/demouser/EmployeeDB/EmployeeDetails?ZOHO_ACTION=IMPORT &ZOHO_OUTPUT_FORMAT=XML&ZOHO_ERROR_FORMAT=XML &ZOHO_API_KEY=adss&ticket=ssfs&ZOHO_API_VERSION=1.0 has "&ZOHO_OUTPUT_FORMAT=XML" so all works excellent to the point i get the xml, how do i remove this? i dont want a result displayed just want to upload my
Merge information between Zoho Reports and Zoho CRM
How do you merge information in Zoho Reports with Zoho CRM. Also noticed it CANNOT be done with Zoho Contacts. Please suggestions and feedback would be greatly welcomed Thanks
data: analysis / exploration / mining / robust visualization - wish list
Thank you for an exciting offering of services. Any plans to integrate this kind of functionality into your product suite? Features would provide the ability to carry out exploratory data analyses - data visualization (scatter matrix, radviz, polyviz, 'motion' charts), data mining algorithms (association, clustering, time series, regression, SVM, Naive Bayes, decision trees), a mining model development & evaluation platform. These kinds of platforms are currently available as open source platforms
Query / Union of tables with date column
Hi, I want to create a new query table based on Table1 and Table2: Table1 Column1 (Text) Column2 (Date) X 30 Apr, 2009 23:15:34 Y 12 May, 2009 23:15:47 Table 2 Column1 (Text) Column2 (Date) Z 18 May, 2009 23:15:34 Using this SQL Select Query: SELECT "Column1", "Column2" FROM "Table1" UNION ALL SELECT "Column1", "Column2" FROM "Table1" Executing the Query the result is OK: Column1 (Text) Column2 (Date) X
Reports: update, import, deleting records.
Reports: update, import, deleting records. Hi, How do I proceed for my problem, database classification, placing game résults. In this case my database contains from one to fifteen records, rows (with indentification and résults from dogs game) A new records, data no problem "importing data - add records at the end" But updating I must work eround, can it be done in one time? Explanation: offline I workout all the individual résults, with a macro in a spreadsheet, and put all the data from the records
Chart width when using a single iframe (embed) for multiple charts
Hello, I use a single iframe to display charts depending on which one the user wants to see (links on a page). Is it possible to still define the chart width using a URL which targets the iframe? I tried sticking "&WIDTH=700" into the url but it doesn't seem to work like it does in the iframe src attribute. Thanks.
how to avoid ZOHO_OUTPUT_FORMAT=XML
hello i have succesfully uploaded csv using your sample in: Bulk Adding / Updating via CSV but i do not want the xml to show up at the end how do i get rid of it? since i am forced to have ZOHO_OUTPUT_FORMAT ??please help
Interconnect of zohoDB with MySQL with zohoDOCS
Hello, what I am interested in is a feature I am not sure if it is possible to do. I would like to connect my MySQL database (the list of users) with zohoDB to create list of users there and assign rights to these users to view certain documents. So the scheme would look like this: 1. - register at website 2. - assign group in MySQL 3. - sync users with zohoDB (cloudSQL) 4. - add users in zohoDB to users that are allowed to access zohoDOCS 5. - these users can access zohoDOCS through Internet Browser
Zoho Reports: Sharing to new users will alone be temporarily unavailable between Sun 17 May 2009 05:30:00 AM GMT to Sun 17 May 2009 11:30:00 AM GMT
Dear Users, We are upgrading the sharing feature. Due to this, sharing to new users or modifying existing shared details will alone be temporarily unavailable in Zoho Reports between Sunday, 17th May, 2009 05:30 AM GMT and Sunday, 17th May, 2009 11:30 AM GMT. Saminathan, Zoho Reports Team.
Neophyte questions on lookups and fetch
Greetings, I am new to reports (and databases in general) and can't seem to figure out the lookup and data fetch process. I have a series of tables with data setup. I created a new table and used the design view to create new columns. Each column is a lookup, referencing a column in another table. But when i save, the columns in the new table are empty. When I click on the column heading, it says fetching data but nothing shows up. What am I doing wrong? Any help would be appreciated. Thanks, BH
Neophyte's question about lookups and data fetch
Greetings, Trying out Reports and can't seem to figure out how the look and fetch process works. I have several tables setup. I setup a new table and in the design view, I setup four new columns. Each is a lookup, referencing data from two other tables. When I save, there is no data, and when I click on the columns, it says fetching new data, but nothing shows up. Any assistance would be appreciated. Thanks, BH
Automatic data update in zoho Report from zoho Sheet
Hello, My need is to share the chart in zoho Report... but I would like that the data are automatically updated when someone read my chart. the data are in Zoho Sheet... and I can change this data several times per day. can we update automatically the data ? => ex : the link related to the chart reads in real time the data in Zoho Sheet ? Thanks in advance for you feedback
Physical records (files/boxes)
Hi, is there any plan to develop a physical records tracking application? Andrew
Accessing a Published Table/View
Please bear with me as I am new and learning. My Primary Goal: I would like to create a site where my approved users can see data (read only), filter and sort. I have a table in Zoho Reports. I understand that I probably need to PUBLISH the table. But I don't know what happens next. Which Zoho Application do I use for accessing the published table? Do I use Zoho Creator? Zoho CRM? Or Zoho Wiki? I think once I have that gentle nudge, I will be able to play and learn - Thank you - Marion
Creator and Reports Integration
Hello - I am reading a post from Clarence of Zoho Reports written in January 18, 2009 about a new release for 1st quarter 2009 FOR SMOOTH INTEGRATION BETWEEN Creator and Reports. That Reports would be right within Creator (ie, Forms, Views adn REPORTS) I am VERY VERY eager to know the status of this integration! Thank you Marion in NY
Next Page