Skip to main content
H
Hariharasuthan13-Aquamarine
13-Aquamarine
January 23, 2023
Solved

Generate file or reports

  • January 23, 2023
  • 2 replies
  • 1906 views

dear all 

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

 

Best answer by jensc

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

2 replies

S
17-Peridot
Sathishkumar_C17-Peridot
17-Peridot
January 23, 2023

try with following extension...

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

 

J
jensc17-Peridot
17-Peridot
January 23, 2023

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

H
Hariharasuthan13-AquamarineAuthor
13-Aquamarine
January 23, 2023

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

J
jensc17-PeridotAnswer
17-Peridot
January 23, 2023

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

    Terms & ConditionsCookie settingsAccessibility statement