Skip to main content
A
AP_958723617-Peridot
17-Peridot
August 16, 2021
Solved

WriteCSVFile

  • August 16, 2021
  • 1 reply
  • 1322 views

I have 100 rows in CSV File. I want to replace only one row. This snippet: Resources["CSVParserFunctions"].WriteCSVFile(params2); is not accepting one row as an input. Iam getting an error "JavaException: java.lang.Exception: Unable To Convert From com.thingworx.types.collections.ValueCollection to INFOTABLE ". 

1. How to update only one row of csv file?

 

2. Shall i pass arrays tothe input data?

 var params2 = {
path: filePath2 /* STRING */,
data: rowCSV /* INFOTABLE */,
fileRepository: "SystemRepository" /* THINGNAME */,
withHeader: true /* BOOLEAN */
};Resources["CSVParserFunctions"].WriteCSVFile(params2);

 

 

Best answer by slangley

Hi @AP_9587236.

 

You will need to load the whole file into a ThingWorx infotable, Is it a correct assumption that you would want to make the updates via a mashup?  If so, you would need to tie the infotable to a grid, make the change, and then write it back out to the CSV file.

 

If you can provide a better understanding of your application, we might be able to provide a more efficient way of handling it.

 

Regards.

 

--Sharon

1 reply

S
slangleyCommunity ManagerAnswer
Support
August 18, 2021

Hi @AP_9587236.

 

You will need to load the whole file into a ThingWorx infotable, Is it a correct assumption that you would want to make the updates via a mashup?  If so, you would need to tie the infotable to a grid, make the change, and then write it back out to the CSV file.

 

If you can provide a better understanding of your application, we might be able to provide a more efficient way of handling it.

 

Regards.

 

--Sharon

S
slangleyCommunity Manager
Support
August 25, 2021

Hi @AP_9587236.

 

If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.

 

Regards.

 

--Sharon

Terms & ConditionsAccessibility statement