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

The PTC Community email address has changed to community-mailer@ptc.com. Learn more.

Config csv via service

sabharees
13-Aquamarine

Config csv via service

Hi, 

 

Now I am creating daily reports(calculated values which carry numerical values) and writing them as .csv to send my team.

My team is located in Poland and Germany so their local setting in excel for numbers to carry decimal values is a comma'','' but Thingworx creating CSV with dots''.''

The issue is dots are not considered as numbers it considered as strings!! 

Is there any way to resolve this ? or can we generate excel via service? or can I trigger the mashup widget(data export: which has generating excel file option) from the service?

1 ACCEPTED SOLUTION

Accepted Solutions
cmorfin
19-Tanzanite
(To:sabharees)

Hi @sabharees 

 

If you use the CSVParser extension, then https://www.ptc.com/en/support/article/CS237713  should help to change the field separator and decimal marker in the csv.

 

Regards

Christophe

View solution in original post

1 REPLY 1
cmorfin
19-Tanzanite
(To:sabharees)

Hi @sabharees 

 

If you use the CSVParser extension, then https://www.ptc.com/en/support/article/CS237713  should help to change the field separator and decimal marker in the csv.

 

Regards

Christophe