Pain Point: "please Call Our Helpdesk"

[JonathansCorner.com]

I've run into a pain point in how FusionCharts exports CSV.

 

CSV can be exported to clipboard. However, if this is posted to Excel, Excel respects line breaks but does not respect CSV: everything is posted into the leftmost column, as per the screenshot.

 

There is a song and dance that will let people get the CSV interpreted: click on "Data", then "Text to Columns," then "Next", then uncheck "Tab", then check "Comma", then Finish, and finally the CSV is interpreted as a spreadsheet. I believe the English translation to this song and dance is, "Please call our helpdesk."

 

On setups where JPG/PNG/PDF can be downloaded, could there be an option to download CSV, which Excel would open and interpret as CSV more easily and naturally?

Edited May 27, 2011 by JonathansCorner.com

[FusionCharts Support]

Hi,

 

Could you please try once setting exportDataSeparator='{tab}' in <chart> and try again. My Excel in mac seems to respond well using this.

 

 

The XML that I used is :

<chart caption='Weekly Sales Summary' showExportDataMenuItem='1' exportDataSeparator='{tab}'
  xAxisName='Week' yAxisName='Sales' numberPrefix='$' >
       <categories>
           <category label='Dec'/>
           <category label='Jan'/>
           <category label='Feb'/>
           <category label='Mar'/>
           <category label='Apr'/>
           <category label='May'/>

       </categories>

       <dataset seriesName='current'>
           <set value='123123' />
           <set value='123123' />
           <set value='123123' />
           <set value='123123' />
           <set value='123123' />
           <set value='123123' />
       </dataset>
       <dataset seriesName='2010'>
           <set value='123123' />
           <set value='123123' />
           <set value='123123' />
           <set value='123123' />
           <set value='123123' />
           <set value='123123' />
       </dataset>
</chart>

[FusionCharts Support]

As of now, we do not have the native mechanism to download the CSV directly from chart.

[FusionCharts Support]

Just tested in Excel 2010 - Windows, it works in my Windows Excel 2010 setup too.

 

[JonathansCorner.com]

Thanks for the suggestion. Yes, it works great! (-:

 

Just tested in Excel 2010 - Windows, it works in my Windows Excel 2010 setup too.

 

[Guest Angshu]

Hi,

 

Thank you very much for your appreciation.

 

Keep FusionCharting!