generateCSV (deprecated)

generateCSV was deprecated in version 4.28.0 of the JourneyApps Container and replaced with CSV.

Version compatibility

generateCSV was introduced in version 4.25.0 of the JourneyApps Container.

Format

generateCSV(source, options);

Parameter	Details
source	One of: Array Matrix (array of arrays)
options (Optional)	Object with the following properties: heading: Array of column headings delimiter: Character to separate columns with. Defaults to ,

Returns: the generated CSV as a string.

Examples

main.js

var mx = [['Cell Phone', 'Black'], ['Computer','Red']];
var csv_file.csv = generateCSV(mx, { heading: ['Type', 'Color'] } );

In this case, csv_file is:

csv_file.csv

Type,Color
Cell Phone,Black
Computer,Red

Suppose we have an asset data model object with (amongst others) name and cost as fields, and we want to generate CSV for all assets and their names and costs:

main.js

var allAssets = DB.asset.all().toArray();

var myMx = allAssets.map(function(asset) {
    return [asset.name, asset.cost];
});

var csv = generateCSV(myMx, {heading: ['Name', 'Cost']});