Loading inline CSV string instead of JSON string

posted on March 7th, 2016

Closed

David Chen asked on March 7, 2016

this code loads json string, but could we load a csv string instead? like A,B,C,D,...,...,...

var jsondata = [{
"Color": "green",
"M": "September",
"W": "Wed",
"country": "Canada",
"state": "Ontario",
"city": "Toronto",
"Price": 174,
"Quantity": 22
}, {
"Color": "red",
"M": "March",
"W": "Mon",
"Time": "1000",
"country": "USA",
"state": "California",
"city": "Los Angeles",
"Price": null,
"Quantity": 19
}];
var report = {
configuratorActive: false,
data: jsondata,

3 answers

Public

Roman Petrusha ⋅ Flexmonster ⋅ March 8, 2016

Hi!

The best way is to use the following syntax:

var report = {
configuratorActive: false,
filename: "path_to_my_csv_file.csv",
dataSourceType: "csv"
}
Does it work for you?

Public

David Chen ⋅ March 8, 2016

so it has to load a physical csv file?
it can't load a csv string?
like
name,studentid,grade
david,SD1111,5
john,SD1112,5
tom,SD1113,5

Public

Dmytro Zvazhii ⋅ Flexmonster ⋅ March 9, 2016

Hi! There's no way to load csv data as a string in the component. It can be done only with json string. There are two options with csv loading. Firstly, as you've already said, you can load data using physical csv file. Secondary, you can use a server script which will be generating csv file for you. Thus you should pass the url in the report, smth like http://localhost/csvGenerator. It will serve as the "path" to your script.
Hope it will help.

This question is now closed