cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

download csv file

AP_9587236
17-Peridot

download csv file

var params1 = {
infoTableName : "InfoTable",
dataShapeName : "EntityReference"
};

var AllEntities = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params1);

AllEntities =Projects["XXXXXX"].GetEntities();


var params2 = {
path: undefined /* STRING */,
data: AllEntities /* INFOTABLE */,
fileRepository: CustomServices /* THINGNAME */,
withHeader: undefined /* BOOLEAN */
};

Resources["CSVParserFunctions"].WriteCSVFile(params2);

 


This code is not working. I have provided ThingName for fileRepository. What else should i provide for fileRepository??

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
slangley
23-Emerald II
(To:AP_9587236)

Hi @AP_9587236 

 

Without knowing which extension you're using, here's a link to the ThingWorx Help Center on the extension that used to be available on the download site.

 

A CSV file is nothing more than a text file with a delimiter between fields, so you will be able to read it in any text editor.  You can import it into Excel or other software packages for changing the format.

 

Regards.

 

--Sharon  

View solution in original post

5 REPLIES 5
PaiChung
22-Sapphire I
(To:AP_9587236)

I think on the repository itself there is a WriteCSV or Text service, perhaps try that one instead.

You mentioning WriteToTextFile service in CSVDataFileRepository??

 

I need to download a infotable datas in csv or excel file!! Guide me.

slangley
23-Emerald II
(To:AP_9587236)

Hi @AP_9587236.

 

You can use the CSV Parser extension maintained and supported by our partner IQNOX.

 

Regards.

 

--Sharon

1. Can you please tell me what added functionalities "CSVParser_extensions" will provide than "CSVParserFunctions". What is the use of "CSVParser_extensions"?

 

2. And i tried this code, and iam able to download the entities list as a file.
var params1 = {
infoTableName : "InfoTable",
dataShapeName : "EntityReference"
};
var AllEntities = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params1);
AllEntities =Projects["XXXXXX"].GetEntities();
var params2 = {
path: "/ALL_ENTITIES_FILE/" /* STRING */,
data: AllEntities /* INFOTABLE */,
fileRepository: "SystemRepository" /* THINGNAME */,
withHeader: undefined /* BOOLEAN */
};
Resources["CSVParserFunctions"].WriteCSVFile(params2);

 

3. The downloaded file is a notepad. But i want it in a table format. How to do that?

slangley
23-Emerald II
(To:AP_9587236)

Hi @AP_9587236 

 

Without knowing which extension you're using, here's a link to the ThingWorx Help Center on the extension that used to be available on the download site.

 

A CSV file is nothing more than a text file with a delimiter between fields, so you will be able to read it in any text editor.  You can import it into Excel or other software packages for changing the format.

 

Regards.

 

--Sharon  

Top Tags