upload tool error while uploading from mysql database
Hello, I'm trying to upload data from my remote MySQL database using Zoho upload tool but I got this error Exception in thread "main" java.lang.NullPointerException at com.adventnet.zoho.client.report.advancedtool.SuggestError.suggestXMLParseException(SuggestError.java:157) at com.adventnet.zoho.client.report.advancedtool.SuggestError.suggestException(SuggestError.java:81) at com.adventnet.zoho.client.report.advancedtool.SuggestError.printAndLogSug(SuggestError.java:169)
Reports unexpected error
Hi, We are getting error in your zoho application. Error for the sample file we are sending. The same query in 2 different report is available. the new copy when we receive the following error we receive.The following error is coming. Video ; https://www.dropbox.com/s/71pkibqnyxtpkti/Zoho%20Reports%20Error.mp4?dl=0
"Almost" duplicate Events showing up in tables (and therefore reports)
Hi, We've sync'd our CRM with Zoho Reports and have noticed that certain of our Events have duplicate entries, although with different Modified Dates and different EventIDs. Not sure where these duplicates came from. When I look at an object in the CRM with that Event, it only shows the one Event. Thanks, Justin
Importing data into zoho report table
Hi, Im importing using uploading tool from a mysql database to a zoho table. Only the data in one column get wrong imported. The column in mysql is defined as longtext. I get these value in the fields (instead of the proper text) [B@100271a [B@100271a I do not have these kind of problems with mysql data type varchar, only with longtext. Can you help me with this issue. Regards, Juan.
Aliasing Tables in Reports
I'm trying to build a Query Table in Zoho Reports using my Zoho CRM data, and I'm running into this error: Whenever a table alias is defined, kindly use table alias name before the respective columns used in SELECT query I'm trying to create a query table that joins several aliases of the Contacts table to the Opportunities table. For example, an Opportunity has a Primary Contact, a Referral Source, a Primary Liaison, and an Agent. All four of these are represented in the Opportunities table
Convert string in date
hello, i have a string field as 15-Nov-2015, how can i convert in date field ? thanks you
iPad - Not Getting Previews
Hi, I just started using the iPad to view my Zoho Reports from Servicedesk. Unfortunately when I view any screen on my iPad I am not seeing any previews. Not on the 'My Databases' screen or drilling into the databases. Any ideas? Thanks,
Uploadtool: Query Problem
Dear Experts. I’m trying to add a new Query from my SAP business one Database to Zoho reports using uploadtool, but when I add following query to database_sql_queries file (as I always do), then Zoho doesn´t upload any data. If I delete the new Query then Zoho starts to import again. Please help me understand where is the problem. Best Regards. Best Regards, Jens Lehmann
Zoho Reports-New features rolled out on Jan.5, 2016
Support to Export/Email Multiple Reports in an HTML Format Zoho Reports now supports exporting/emailing multiple reports in an HTML file format. So far these features were only available for a single report. Now you can export or email multiple views as a single zipped HTML file by clicking Export -> Export Multiple Views -> As HTML (ZIP). So far this multiple export feature was supported for PDF file format.
Lead/Potential Source Analysis
Is there a way of tracking the source of a lead right from initial lead generation through to sale? And visually showing this in a graph? For example 10 leads from google search 20 leads from event 5 google were converted to potential 11 event leads were converted to potential 3 google leads resulted in job 5 event leads resulted in job I seem to loose data when lead is converted into potential and finding it hard to track. Also seems as if there is a lag and it doesn't update all data?
Can not upload from MYSQL using upload tool
Hello, I know this is a common issue so I have looked through the other posts about this but no luck with my specific issue. I am trying to upload from a local mysql instance into zoho using the UploadFromDB .bat file. I have edited all 3 of the configuartion files and made sure that the parameters are correct. I have tried both running the .bat directly and tried running it from the command prompt. On cmd I get the below attached error. Please review if you can and provide some insight. Also
Wrapping SQL Query Error text
When building a new query in Reports, I've notice that you now helpfully produce some suggestions to fix the query when there's an error. But in Chrome at least, this text does not wrap inside the window. Anyway to force it to do that? It would make it much easier to take advantage of this assistance.
Append Records to Existing Data
I have a database which includes: SALE DATE, ITEM CODE, END CLIENT. The END CLIENT field is currently empty. I have a excel sheet on my PC which lists all ITEM CODEs and who the END CLIENT is. I attempted to update all records in Zoho Reports with the END CLIENT name, hoping it would match the ITEM CODE. Unfortunately, it simply added all the records at the end. There are duplicates of ITEM CODE in my database because they are purchased multiple times and have different SALE DATEs. How can I map
FULL OUTER JOIN support
Does Zoho Reports Supports FULL OUTER JOIN? If I need to do a LEFT and then a RIGHT that is a no. Thanks
Wrap Text in description column for dashboard PDF export
I'm creating a report using a combination of dashboard and a tabulated report. Reason for this being that when I export the tabulated report the column widths are the same size, therefore the column with descriptions in it is quite thin and squashed. However if I create a dashboard, insert the report and then export as a PDF there is an option to use proportionate widths, which works great. However when I export the dashboard report to PDF the text in the descriptions column does not wrap do words
Server Locationsd
HI Is there any plans to provide european server hosting in the future?
Summarising data
I have monthly data which I want to summarise into quarterly data. When I use Reports it appears to sum the data for the whole quarter and what I want to see is the data for each quarter end over the year. Could you explain how this is done in reports
Chart based on pivot table
Hi, I have created a pivot table, but now want to create a chart based on that pivot table. Is this possible? I cannot get the information in the required format based on the data in the original query / table. Thanks,
create a dashboard with graphs of different databases
Saludos. Quisiera crear un Dashboard con gráficos provenientes de distintas tablas de datos. Como puedo hacerlo? Gracias.
API Throttling ?
Hi Support, I am processing about 800 rows of data. I am looping through the data and doing a database API call (via Python Reports Client) After about 100 or so calls, I get the following error 2016-01-06 22:28:37,196 q2msgbldr.service DEBUG : Adding IO record [{'SeasonId': 2016, 'TransactionId': '1452119317196', 'ProcessingMessage': 'Queue2MsgBldr: Add / New Initial Create.', 'WeekId': 15, 'AthleteId': 2851}]
Traceback (most recent call last):
File "queueToMessageBuilder.py", line 95, in <module>
How to add custom formula?
I am currently using ZOHO Reports, and would like to add a custom formula. I tried following these instructions in the FAQ (https://www.zoho.com/reports/help/table/add-formulas.html#Custom_Formula), but don't seem to be able to find the 'Add' button in the first place. Please advise, thank you.
New Features rolled out on Jan.8, 2016
Show Involved Columns Option in Reports Designer Recently there was an update to filter, sort or expand the fields in the reports designer. We have now additionally implemented an option to Show Involved Columns. This will be useful to quickly list only the data fields used in creating a particular report. Share your Feedback with a Screenshot We now allow you to take a screenshot of the issue you are facing and attach it while sharing your valuable feedback to the Zoho Reports team. This will help
Pivot table ideas
Are there any plans in the pipeline to be able to show values in rows and colunns similar to excel. Also being able to see more than 100 distinct values?
Zoho Reports - New features rolled out on Dec. 22, 2015
Enhancements in Dashboard Zoho Reports Dashboard has been enhanced with the following feature. Themes Zoho Reports now allows you to apply a range of visually appealing themes over your dashboard. By default Zoho Reports provides six theme layout, which can also be customized as needed. You can choose the required theme by clicking the Themes toolbar option in the Dashboard. You can customize any theme by clicking the Customize option displayed when you mouse over the themes listed. The new
Zoho Reports using Data from Exel Spreadsheet or XML file?
My company's main software platform provides revenue and customer reports in the form of PDF, Exel, or XML, but the report formats do not provide any flexilbity for producing a management report that would compare YTD and monthly data this year vs last year. In order to obtain the data I need for my desired management report. I am currently running 30 to 40 reports each month, and I save them as PDF files, then i type in the required data into an Excel spreadsheet that serves as my management report.
Mantener visible solamente el primer nivel de la vista dinámica.
Saludos. En esta ocasión ocupo su atención para preguntar de que forma puedo mantener solamente visible el primer nivel de la información colocada en el campo filas de la tabla dinámica y que se visualice únicamente esa etiqueta y su consiguiente sub total. En el caso del ejemplo que adjunto, allí quisiera ver los estados con el sub total de cada uno de ellos. Como siempre, Gracias por su atención. Saludos. Adel Bahsas El Maaz.
Zoho Report error
Hi Support, I am logging into Zoho reports using user id: nonregressionuser@test.runmyprocess.com but am unable to create database in my account.Every time I try,I get the below error: Although,I can do the same successfully in my another account(bidisha.fci@gmail.com) without any error. Could you please let me know the cause of the error?
Zoho Reports _ calculate and display average mm:ss
Hi I am trying to calculate and display as a graph the average time for each user to complete a task, each user has 3 results. The data is being imported from a google spreadsheet and recorded in Zoho reports in date format and then converted to mm:ss after formating the column, See below . Name Timer User 1 02:51 User 1 02:47 User 1 02:12 User 2 02:28 User 2 02:25 User 2 02:28 User 3 02:04 User 3 01:55 User 3 01:59 User 4 01:55 User 4 01:56 User 4 02:05 However, when attempting create a graph
Activity Report
Hello. Is i possible to customize a report in Zoho like this spreadsheet?
Is there a backup for Reports?
We've built quite a set of query tables and reports within Zoho Reports, and it would take a significant amount of time to re-create them if anyone accidentally wiped out the account -- is there a backup facility with reports? If not, what does everyone else do to back up their queries and tables?
Update Function
Hi, I have two tables. I want to update one column according to an information of another table. I tried with: UPDATED "VALLESALUD-Por Cerrar" SET "VALLESALUD-Por Cerrar"."Estado"="Auditados por cierre con pendientes"."Estado" FROM "VALLESALUD-Por Cerrar" INNER JOIN "Auditados por cierre con pendientes" ON "VALLESALUD-Por Cerrar"."Caso"= "Auditados por cierre con pendientes"."caso" But I got "Solo se permiten instrucciones de consulta SELECT (SQL)" I appreciate your help to achieve
Date Format Query Table
Dear Experts. I´m trying a Query table and i want to create a new column with date format but when i run the Query the column is not recognize as a date. I have tried 01/10/2015; 01-10-2015 and 01.10.2015. ¿How I must write the SQL sentence to Zoho recognize as a date? case a."mes" when '10' then '01.10.2015' when '11' then '01.11.2015' when '12' then '01.12.2015' end 'Mes Real',
Activity Report
Hello. Is it possible to replicate this spreadsheet to a customized report i Zoho?
Dashboard Count Visits
Dear Users. When we share a Dashboard or publish the link, There is a way to count visits?
Zoho Reports - New features rolled out on Nov. 30, 2015
Enhancements in Query Table Editor Interface: We are introducing a new feature-rich query table editor in this update. The salient features of our new query table editor are as follows. Syntax highlighter support. Syntax Assist to construct your query. Pressing 'Control + Spacebar' in the editor would prompt a list of possible SQL syntaxes that could be used in the query. Line Number support. Add Description for Aggregate/Custom Formula: You can now add descriptions for your Aggregate or Custom
Creación de Filtros Personalizados Interdependientes
Saludos. Al crear un Filtro personalizado existe la opción de colocar varios campos que puedan servir como tal. Sin embargo al seleccionar una opción en el filtro 1, el resto de los filtro poseerán todos los valores correspondientes a ese campo, y no se limitan a aquellos registros relacionados con la opción seleccionada en el filtro 1. Ejemplo: Filtro 1: País Filtro 2: Estado Filtro 3: Región El propósito es lograr que al seleccionar un País en el primer filtro, automáticamente en el resto de
Transaction table logic for declines, refunds, split payments
I have a transaction table - with lookup columns for transaction type (approved, declined, refund) - approved need to leave the "amount" field as is, declined need to zero out the amount field, refunds need to make the amount field negative. I have another lookup column for split transactions - the 2 split records need to be counted together as a single transaction. Where do I start figuring this out?
Import Zoho invoices and Checkfront
p.MsoNormal, li.MsoNormal, div.MsoNormal { margin: 0.0cm; font-size: 12.0pt; font-family: Cambria; } *.MsoChpDefault { font-family: Cambria; } div.WordSection1 { page: WordSection1; } Hi ! Firstable, many thanks for your products !! I am currently running a business using both Zoho Invoices and Checkfront. I am now facing reporting issues and I have a real interest in Zoho reports functions. I was wondering if there were any way to directly import data from both checkfront and Zoho Invoices into
Update table 2 after modified data in Table 1
Hi, I have a Table, which I manually refresh currently (until I can get the API's sorted). I would like to be able to record when the table was modified, and the total number of rows, in order to compare once I've refreshed it. Is it possible to create a second table with two columns (date modified, and count of rows in Table 1) - which automatically updates upon the refresh of Table 1? I need to be able to use the comparison widget on the Dashboard, to show whether the number of rows has
Problem uploading data using UploadFromDB.sh
Since today, during the process of UploadFromDB.sh Im experiencing the following error: Generating CSV File... CSV file generated... Uploading Query #1 data into Zoho Reports... Error is :: The host did not accept the connection within timeout of 15000 ms Trouble Shoot Error!!! If you are connecting through proxy server, please check the proxy settings configured properly in the file '..../UploadTool/conf/common_params.conf' and then try again. If you require assistance to resolve the problem, please
Next Page