Missing bar in the pipeline and opportunities charts

[dvlancer]

I have a problem displaying "Pipeline by Sales Stage" and "All Opportunities by Lead Source by Outcome" charts in Sugar CRM CE Version 6.0.1 (Build 4143).

Each chart has a bar missing; however the $ value displayed in the place of the bar is correct.
Could you please suggest what the issue may be and point me in the right direction to resolve it?

Thank you

[dvlancer]

I found the cause of the issue, which was the XML data file used by those charts. Fixed SugarChart.php to generate correct data.

[matty102]

Hi,

I have the same problem, would you be able to tell me exactly how you Fixed SugarChart.php?

Many Thanks

Matt

[dvlancer]

Hi Matt

You need to make a one change in SugarChart.php (on line 534) in the function xmlDataGenericChart(). Change the following line:

$sub_amount = $this->formatNumber($this->convertCurrency($new_data[$groupByKey][$i]['total']));

to

$sub_amount = $this->convertCurrency($new_data[$groupByKey][$i]['total']);

It will remove the formatting of the sub_amount and solve the problem.

Kind regards,

Dmitri

[matty102]

Many Thanks Dmitri, that worked great!

[Donato]

I have this same problem when I apply this change to the screen is white !!
could someone help me please, I am suffering for months with these graphics.

thanks

[andopes]

I have this same problem when I apply this change to the screen is white !!
could someone help me please, I am suffering for months with these graphics.

thanks

Which version are you using?
Did you install any package?

Cheers

[Donato]

My values are in another format (point) for thousands and
comma for decimal.

This difference may be causing the error.

Anyone have any solution for this?

[Donato]

My Sugarversion is 6.03, I'm with the package of the Portuguese language.

Also changed the SugarChart according to this link to correct the difference in data format.

http://www.sugarcrm.com/crm/support/...b-4c444dfe175f

Thanks,

Daniel

[Donato]

It appears that version 6 still a bug charts.

As you insert opportunities with values in the millions, these opportunities not be displayed by the pipeline.

We work on projects for oil companies usually register values of this size, but just does not work.
I've been struggling with this problem for months.

Today I did a test with a clean installation and the database demo of sugar, and the problem appeared.



Simply changed the value of an opportunity to 10K 10000K bar and disappeared, just as in our setup.

What is the solution to fix this?