Telemetry Signal Format

[abdullah123456789]

Hi everybody,

I created Telemetry Signal List in Geo Scada Expert 2021. When I export the signal list and open it with Notepad, I see the yellow quotation marks in the image below. 

But I need to export all data like below image. (Quotation marks must only be before and after values)

I'm adding the SQL query I used below;

SELECT
"His15MAvg"."RecordTime" AS " CurrentTime", "WLM_ID", "His15MAvg"."Value" AS "CurrentValueAsReal", "His15MAvg"."Quality"

FROM

"HistoricView"."His15MAvg" AS "His15MAvg" INNER JOIN CDBPOINT ON "His15MAvg".ID = CDBPOINT.ID

WHERE
"WLM_ID" = '2190528_LE-15-44-Omerli_Art_24000_Depo_Su_Seviye' AND "His15MAvg"."RecordTime" BETWEEN TIMESTAMP '2022-01-01 00:00:00' AND TIMESTAMP '2022-07-20 23:00:00'

[BevanWeiss]

How are you 'exporting' this data?

Provide screenshots of the configuration of the object that you're using for this.

[abdullah123456789]

I'm using 'SQL Export Module' and sharing SQL query screen.

[sbeadle]

Your output image has extra quotes wrapping entire lines of the output, then causing inner quotes to be doubled.

But I just tested this myself and I don't see it, even by using the Swedish locale and selecting Comma Separated.

CurrentTime,FullName,CurrentValueAsReal,Quality
2022-07-26 11:00:00.000,Test.New Analog Point,"3,24",524480
2022-07-26 11:15:00.000,Test.New Analog Point,,2097152
2022-07-26 11:30:00.000,Test.New Analog Point,,1075838976
2022-07-26 11:45:00.000,Test.New Analog Point,,1075838976

Has the output file been modified by another tool?

[abdullah123456789]

No, i didnt use another tool. The data I exported is in historic type, not current datas. I view the signal list wit Excel properly, but when i view the signal list with Notepad ++  i encounter this problem. Because of i need to know if the data type is string or not string.

[sbeadle]

Somehow each record has acquired additional quotation marks. Perhaps try setting the export to tab-separated?

You may need to contact the support team.