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
Trailing twelve month sum
Zoho, I have been unsuccessful at creating the proper query or table to get a trailing twelve month sum for financial reports. Below is an example of the solution in Excel. I am trying to create a line chart report that shows my trailing twelve month billing by month. Month Billings $ T12M Sum of Billings for Chart Jan-08 $50,000 Feb-08 $50,000 Mar-08 $50,000 Apr-08 $50,000 May-08 $50,000 Jun-08 $50,000
create query table from two tables with no lookup between them
I need to create one table with fields from the sales table with similar fields from the expenses table. There is no lookup between them. Both tables are updated via feeds from zoho creator separately. I would like to use the blended table to produce income and expense reports and graphs. JOIN in the query table doesn't seem to work for this. I do not know sql so maybe I'm doing it wrong? Could both tables be edited to include a linked field that could be used to then create a query table?
SQL query to select record having max value in a field by each group.
Hi I would like to select fields in records having max value in "Date" for each group by Code. I executed the following SQL to do it. But It seems that the SQL is not supported by Zoho yet. SELECT T1."Code", T1."Date" , "52 Week High" FROM "hprc" AS T1 INNER JOIN (SELECT "Code" AS F1, MAX("Date") AS F2 FROM "hprc" GROUP BY "Code") AS Q1 ON Q1.F1=T1."Code" AND Q1.F2=T1."Date"; Regards Keita
Addition?
When I try to make a query that has the addition of two numbers: 1+1, I get 11. Is there a way to make it reconize that it's numbers, and not strings, so that it won't concatinate them? Also, is nested selects not supported? I was hoping that any sql code would work, and if this is not supported, how about querying over a query table we created? Thanks
making multiple replacements with the "replace" in a new formula column
I have a column that uses values 0-3 for values low,medium, high, critical. I would like to replace the values with the text equivilent. I can replace one value easily but not all. Example: replace(PRIORITY,'3','critical') works but how do you also have it replace '2','high' and '1','medium' ......etc... can someone provide the example or let me know if this is not possible....
More type of data formats
Hi, Is there any possibility of introducing new data formats in table fields like hyperlinks.. that are available in dabble db. [URL=http://imageshack.us][/URL] [URL=http://g.imageshack.us/g.php?h=369&i=filedsg1.jpg][/URL]
Links inside a table...
Hi, I am testing Zoho DB in order to publish a table of bibliographics item: for this project, it would be mandatory to have a field in which there is an hyperlink such as "see paper" or similar, which points to the electronic paper on the web.. is it possible to have links in a public view? If not, does Zoho Sheet or Zoho creator allow this (I do not intend simply a clickable URL, but also the possibility to specify the words that appear for the link) Thanks in advance, Marco
Links in DB fields
It would be great, if hyperlinks could be included in database fields. This would be a strong argument for using DB in a research environment, where links to larger public databases are essential.
Next Page