How to set delimited string from dataSource

Answered
Cleyton Barroso asked on February 15, 2017

It is possible to pass a delimited string as a dataSource??
Exemple:
var delimited = "COD;NAME;AGE\n";
     delimited += "1;JOHN;30\n";
     delimited += "2;Mary;23\n";
 
var pivot = $("#pivotContainer").flexmonster({
     componentFolder: "/Content/js/flexmonster/",
     toolbar: true,
     report: {
     dataSource: {
    data: delimited
    }
 },
 

5 answers

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster February 17, 2017

Hello Cleyton,
Thank you for the detailed explanation. Such approach is not available for the CSV strings now. We added your request to the customers wishlist. Right now, you can use such approach for the JSON objects (http://www.flexmonster.com/doc/json-data-source/). If you need to load CSV data you can do it with a file or with file url (http://www.flexmonster.com/doc/csv-data-source/).
Please let us know if it works for you.
Best regards,
Dmytro.

Public
Cleyton Barroso February 17, 2017

Thank you for help

Public
Ankit Agarwal September 28, 2017

Flexmonster team, any update on this request. Since JSON is very verbose, having the ability to return CSV data and using it on the grid will be very helpful in reducing the size of the data being returned.

Public
Tanya Gryshko Tanya Gryshko Flexmonster September 29, 2017

Hello, Ankit and Cleyton,
We would like to inform you that we decided to add the ability to set inline CSV data. This feature will be available as part of minor release 2.407, ETA Nov 6.
Please let me know if you have questions.
Regards,
Tanya

Public
Tanya Gryshko Tanya Gryshko Flexmonster November 7, 2017

Hello, Ankit and Cleyton,
We would like to show you our new approach to reduce the size of the data being returned. Previously Flexmonster supported only array of objects JSON format. Starting from version 2.407, it is possible to use an array of arrays format. Please refer to the following example to see how it works: http://jsfiddle.net/flexmonster/scro38mr/.
We are waiting for your feedback.
Regards,
Tanya

Please login or Register to Submit Answer