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.
How can i generate new query table from 2 database? just like vlookup function
I have 2 database file. I wants to create new query table & wants to append data from both database, which has one or two common field. so, is there specific function available? or is there requirement to write any specific query/programme just like vba macro? If there any available specific example ? or how to create new query? Can i get same data in zoho sheet or zoho creator on periodical interval? Please help
Forms
How can I build a nice looking data entry form from Zoho DB other than entering data in the spreadsheet like form.
Database not found
I'm getting the error below, but the database name isn't incorrect. What may be occurring? ServerException (HttpStatusCode 400 Error Code: 7103 , URI: /api/antoniojspassos@yahoo.com.br/JContatosDB/contato, Action: ADDROW, Message: Database not found! Please check whether the database exists) Thanks! Antonio Passos
Error occured during importing a CSV into Zoho DB
Hi An Error is occured when I am importing a CSV containing about 5000 rows. Error message on GUI says: Processing time exceeds the allowed time limit. Please try it after some time. Error log on API is: 2009/03/19 10:15:22 org.apache.commons.httpclient.HttpMethodBase getResponseBody 警告: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended. Exception in thread "main" ServerException (HttpStatusCode 500 Error Code: 7017 , URI: /api/keitayone/keita/hrat,
DB Processing Time Exceeds Allowed Time
Dear Sirs, I'm uploading information for my online DB. However it gives an error of: "Processing time exceeds the allowed time limit. Please try it after some time." I don't know what the limits are exactly, but I'm uploading 1.000 records and the page says it should be less than 10.000. Is there a solution? Thanks and best regards,
Zoho DB & Reports Scheduled Maintenance - 17th March, 2009 11:00 PM PDT to 18th March, 2009 1:00 AM PDT (2 Hours)
Dear Users, Zoho DB & Reports will not be available for a couple of hours for an update. Downtime details (2 Hours) : From : Tuesday, 17th March, 2009 - 11:00 PM PDT To : Wednesday, 18th March, 2009 - 1:00 AM PDT We regret the inconvenience caused. Saminathan, Zoho DB & Reports Team.
Is there a function that works like vlookup or a way to relate tables by matching fields?
The "Looked Up Column" data type is neat, but not exactly what I'm looking for. I'm starting with a simple task in order to learn how to use Zoho DB & Reports. I have 2 tables: Appointments to View Apartment: ViewNo. (Auto Number), Contact Date, First, Last, Phone, Date to View, Time to View and Rental Applications: AppNo. (Auto Number), ViewNo. (Looked Up Column), Date, First, Last, Phone, etc. In Rental Applications, I want "First", "Last", and "Phone", to automatically fill in once the "ViewNo."
Won't let me enter a formula and what formulas are available?
In "Edit Design" mode, there is a column labeled "Formula" but I can't get into a cell in that column in order to actually enter a formula. How do I enter a formula? Also, what formulas are available?
My table isn't displaying
at http://lawshucks.com/layoff-tracker/#rawdata it's been working for weeks but today it doesn't
Is it possible to read from text-files stored in Zoho docs that are not shared or published?
Is it possible to import from text files (csv or tsv) that are stored in zoho-docs and are only accessible to the current user? If I were to use periodic import in dbreports could I assume that the zoho-id that imports has access to the same users documents in zoho docs ? Can I either import URL https://docs.zoho.com/<filename+location>; or import in some other way without having to have my pc switched on or read from insecure external sites etc.? thanks. Yost
No clue how to do a Lookup Coloumn
I must be missing something here: how in the world do I make a field show a CHOICE of let's say THREE possibilities? I assume it must be a LOOKUP COLUMN? When I try to add a LOOKUP COLUMN, it won't work, since I can only choose NONE from the file dialogue. It would be better I think if you could define the field as e.g. a CHOICE field (I don't know another word for it). Thanks,
Scheduled import
The tutorial shows a scheduled import option but this option doesn't appear to be available when using Zoho DB.
Find the query that zoho autocreated?
How do I find the query that was automatically used to create a very helpful table when I imported some spreadsheets? It's almost exactly what I need and I suck at MYSQL, so I'd rather just edit the existing query than try to recreate it from the ground up. I want to be able to share filtered results from this table and I understand that I need to create a new table view with the filter built in.
Associating documents with a recods
Many databases today allow records to be associated with scanned images or other documents such as order forms. Is there a way to do this in ZohoDB?
lookedup column - view multiple values
Is it possible to view multiple fields within a lookedup column For example: MEMBERS database ID ...other fields... Member name ...other fields... PAYMENTS database ID ...other fields... Payment ...other fields... The PAYMENTS ID field is a lookedup field to the ID column in the MEMBERS database. When entering the payments ID, I would like to see the ID and Member name from the members database. Currently only the MEMBERS ID is displayed. This would help me select the correct member.
'Data' format during table definition and data import
Hi, I have an excel file with a 'Date' column. The format of the date is dd/MM/yy. In zoho db when defining a table,the default 'Date' format as MM/dd/yy. I go ahead and change it to dd/MM/yy so that it matches my excel file. However, when I import data, zoho DB again defaults to the format MM/dd/yy and asks me to change it to the appropriate format. I have to change the date format to dd/MM/yy every time I import data. If I defined the date format I require during the table definition, then why
Report from data in multiple tables
Is there a way to create a report that displays data from multiple tables? I have 3 data tables in my database and want to build a report that combines data from all 3. Thanks.
XML request
Can we expect XML request, maybe ppl be able to build a xml structure of a table and request it via a URL for integration with other software/websites (ex: rss feeds, custom XML based applications, etc).. if possible allow private and public access to those XML requests via some sort of key?
Copy and Paste Records
For data entry, I often need to enter a new record, where I use a previous record as my source. In MS Access or MS Excel, I would just highlight the row and go to the new entry row and paste, and then alter whichever fields were different. How can I do this in ZOHO db ? An alternative would be to have my old template field as the last one and then Ctrl+' in the new field and the one above would be magically copied into the new field. There may be ways to do this in ZOHO, but they have escaped me
help needed re: links
Does anyone know how to set up a one-to-many relationship between categories/tables? For instance, I have the name of a contact and want to be able to add multiple phone numbers for the one contact (without creating fields like Phone Number 1, Phone Number 2, etc.) I am used to working with Access and don't understand how to set up the relationships here. Thanks -
Selecting most recent record
Hi, I have a table that lists status, date and ID. I am trying to return the most recent status for each ID with a query like this SELECT K."Clinic ID", K."Stauts Date", K."Status" FROM "Status" AS K WHERE K."Stauts Date"=(SELECT MAX(J."Stauts Date") FROM "Status" AS J WHERE J."Clinic ID" = K."Clinic ID") ORDER BY K."Clinic ID" ASC Howver I get the error Invalid column 'Clinic ID' used in SELECT query. * If its not true, kindly enclose the column name(s) within double quotes (" ") if it has any special
Multi-line Graph?
Greetings, I have 3 columns in a table. Total Source Date I can create a line graph with the x-axis being the date, the y axis being the total, which looks great. But, I don't see how to create a multi-line graph with several lines, each one representing a 'source'. I think I can work around this by creating a total column for each source, but I would have thought that there would be an easiser way to do this. Am I overlooking something?
Question about summing rows up
Hi, If I have a table like this: Date Deposit/Withdraw --------------------------------- 01/01 +5,000.00 01/12 -500.00 02/14 +1200.00 03/15 -300.00 Then how to build a report based on the table above with a column which displays the balance automatically? Date Deposit/Withdraw Balance -------------------------------------------------- 01/01 +5,000.00 +5,000.00 01/12 -500.00 +4,500.00 02/14 +1200.00 +5,700.00 03/15 -300.00 -5,400.00 Thanks! Matheus
Next Page