Skip to main content
Hariharasuthan13-Aquamarine
13-Aquamarine
Jan 23, 2023 3:59 AM UTC
Solved

Generate file or reports

dear all 

Generate any file type  or Reports, how to store from System Repository .

 

jenscAnswer
17-Peridot
Jan 23, 2023 3:27 PM UTC

Hello,

 

I would suggest using what @Sathishkumar_C said.

There are no supported ways of creating PDF or excel files on thingworx from what I can understand.

 

You can create a CSV file however using the CSVParserFunctions:

 

 

let params = {
	path: undefined /* STRING */,
	data: undefined /* INFOTABLE */,
	fileRepository: undefined /* THINGNAME */,
	withHeader: undefined /* BOOLEAN */
};

// no return
Resources["CSVParserFunctions"].WriteCSVFile(params);

 

Give it a shot and get back to us if you any further questions.

 

Regards,

Jens

View in thread

5 replies

Sathishkumar_C17-Peridot
17-Peridot
Jan 23, 2023 4:41 AM UTC

try with following extension...

https://github.com/ptc-iot-sharing/DataExportExtensionTWX

 

Translate
jensc17-Peridot
17-Peridot
Jan 23, 2023 8:43 AM UTC

Hello,

 

I'm not sure I understand your question?

Would you just like to store any file type in a system repository?
Or would you like to actually create any file type on thingworx?

 

Regards,
Jens

Translate
Hariharasuthan13-AquamarineAuthor
13-Aquamarine
Jan 23, 2023 12:13 PM UTC

for example database(sql) in some table through convert report file .csv or excel  store to System repository 

Translate
jensc17-PeridotAnswer
17-Peridot
Jan 23, 2023 3:27 PM UTC

Hello,

 

I would suggest using what @Sathishkumar_C said.

There are no supported ways of creating PDF or excel files on thingworx from what I can understand.

 

You can create a CSV file however using the CSVParserFunctions:

 

 

let params = {
	path: undefined /* STRING */,
	data: undefined /* INFOTABLE */,
	fileRepository: undefined /* THINGNAME */,
	withHeader: undefined /* BOOLEAN */
};

// no return
Resources["CSVParserFunctions"].WriteCSVFile(params);

 

Give it a shot and get back to us if you any further questions.

 

Regards,

Jens

Translate
    Terms & ConditionsAccessibility statement