sigfox upload - pnpscada

Avatar

wicus_smit
2022-05-19 14:20

Please specify format for Kamstrup Sigfox uploads


Tags: #sigfox
Avatar

sdg.matiaan
2022-05-19 16:44

The files should be as you receive them from Kamstrup.

The weird thing with the CSV file is that it uses semicolons to split the columns.
Excel South Africa doesn't handle this well.
I prefer using LibreOffice Calc for CSV file operations.

If you open the CSV file in a text editor like notepad, it should look something similar to this:
"Data";"Device ID";"Timestamp"
"c01b4dd289f07f6b9fffffff";"74555555";"2022-05-01 02:58:14"
"c018929269ff1caba9ffffff";"74888888";"2022-05-01 02:58:16"

Notice that the semicolons are after the closing quote and before the next opening quote.
If the semicolon is before the closing quote, the file cannot be interpreted.

Please log in to post a comment