importing csv data into fusion charts/powercharts

[steveatmarz]

I know you can export chart data to csv but wanted to know if we can import data in csv format. Anyone do that or have an idea how to import csv data into fusion charts with an intermediary step like csv to xml on upload ?

 

 

 

Any help would be appreciated.

[Guest Madhumita]

Hello,

 

 

 

Welcome to FusionCharts Forum.

 

 

 

Could you please take a look at the following documentation link?

 

http://www.fusioncharts.com/docs/?GUI_CSV.html

 

 

 

I'm sure this will help you.

 

 

 

Do share your feedback with us on this.

[steveatmarz]

Thanks very much for the reply. I had seen and used that gui before but we need a hands-off solution as our clients will be uploading data ad hoc. The data structure will be consistent in some ways in that the first row is always a series of dates and the left most column will always be the items that are plotted. I did fin the xsd files and my asp developer is looking at the xml files we get and is looking into how to automatically transform incoming xml files so that FC can render the charts.

 

 

 

Our product exports data in both csv and xml so we are trying to find a solution that works best for us. I think we will end up allowing both csv and xml data exports from our app, but just xml as the data type when uploading to our web portal where fusion charts is installed.

 

 

 

Any thoughts about whether we are on the right track ?

 

 

 

Bottom line: xml from all of our apps, web based data file upload with a transformation of the incoming xml file based on the xsd files you guys provide all wrapped in asp.net code (our portal is asp.net c#).

 

 

 

Does that sound like a good approach ?

 

 

 

Thanks again for your support!

 

 

 

Steve

[shamasis]

...

I had seen and used that gui before but we need a hands-off solution as our clients will be uploading data ad hoc.

FusionCharts does not natievly support CSV data as of now. However, you can achieve the same using simple JavaScript codes.

There is a very basic example to do the same for a typical scenario, posted at: http://www.shamasis.net/2009/08/generating-pareto-chart-data-for-fusioncharts/

You can refer to the JavaScript there so that you can modify and use the code as per your requirement.