Hi Stephen,
- Are you using a built-in adapter or a custom adapter to export to CSV?
I am using the built-in CSV Export
found under Manage custom Outputs
- What does your adapter configuration look like?
Here is the connection string for the CSV adapter:
ExportPath=PathtoDestination/tmp; InputMeasurementKeys={fd9bd7f1-blabla;0880a7c1-blabla;0318fc6a-blabla;194387d3-blabla;05cc7581-blabla;936ca9e3-blabla;c3799c5a-blabla;62caf16c-blabla;a1b0f69e-blabla;e7642625-blabla;3b9702ac-blabla;9d090545-blabla;77b22ec5-blabla;df2fea3e-blabla;48a707f7-blabla;157a3f6c-blabla;28469ee3-blabla;d689c648-blabla;4812e6b0-blabla;66652897-blabla;70ddae22-blabla;49d92f39-blabla;0b319b1f-blabla;cefcb79c-blabla;a6d76348-blabla;baef7448-blabla}; RolloverSchedule=*/1 * * * *; OffloadPath=PathtoDestination
- What does your output CSV file look like? Also, what do you expect it to look like?
Here is what it could look like:
Timestamp,ID,Value
2019-11-09 00:00:51.4249983,f3ccc120-blabla,0 <—
2019-11-09 00:00:51.4249983,58febc95-blabla,0 <—
2019-11-09 00:00:51.4249983,0318fc6a-blabla,-162.586837513446
2019-11-09 00:00:51.4249983,0880a7c1-blabla,284.739318847656
2019-11-09 00:00:51.4249983,05cc7581-blabla,77.3856881264076
2019-11-09 00:00:51.4249983,194387d3-blabla,285.013061523438
2019-11-09 00:00:51.4249983,c3799c5a-blabla,-42.6271459506236
2019-11-09 00:00:51.4249983,936ca9e3-blabla,284.844573974609
2019-11-09 00:00:51.4249983,a1b0f69e-blabla,179.690447175393
2019-11-09 00:00:51.4249983,62caf16c-blabla,230.60514831543
2019-11-09 00:00:51.4249983,3b9702ac-blabla,63.6789396321069
2019-11-09 00:00:51.4249983,e7642625-blabla,236.001998901367
2019-11-09 00:00:51.4249983,77b22ec5-blabla,-61.2417063824694
2019-11-09 00:00:51.4249983,9d090545-blabla,248.433059692383
2019-11-09 00:00:51.4249983,fd9bd7f1-blabla,59.9873390197754
2019-11-09 00:00:51.4249983,8f43807d-blabla,1.39608759585538E-38 <—
Here is what it could also look like depending on how many times I would issue ReloadConfig
and Initialize the adapter.
Timestamp,ID,Value
2019-11-09 04:07:47.6749973,157a3f6c-blabla,-134.691894150629
2019-11-09 04:07:47.6749973,48a707f7-blabla,123.552314758301
2019-11-09 04:07:47.6749973,d689c648-blabla,105.325314586775
2019-11-09 04:07:47.6749973,28469ee3-blabla,123.519721984863
2019-11-09 04:07:47.6749973,66652897-blabla,-14.6399267321193
2019-11-09 04:07:47.6749973,4812e6b0-blabla,123.541618347168
2019-11-09 04:07:47.6749973,49d92f39-blabla,-156.112064067084
2019-11-09 04:07:47.6749973,70ddae22-blabla,44.8208999633789
2019-11-09 04:07:47.6749973,cefcb79c-blabla,76.0225736133698
2019-11-09 04:07:47.6749973,0b319b1f-blabla,29.9991512298584
2019-11-09 04:07:47.6749973,baef7448-blabla,-29.5293839529103
2019-11-09 04:07:47.6749973,a6d76348-blabla,29.2774887084961
2019-11-09 04:07:47.6749973,df2fea3e-blabla,59.9652328491211
I was expecting:
Timestamp,ID,Value
2019-11-09 04:07:47.6749973,157a3f6c-blabla,-134.691894150629
2019-11-09 04:07:47.6749973,48a707f7-blabla,123.552314758301
2019-11-09 04:07:47.6749973,d689c648-blabla,105.325314586775
2019-11-09 04:07:47.6749973,28469ee3-blabla,123.519721984863
2019-11-09 04:07:47.6749973,66652897-blabla,-14.6399267321193
2019-11-09 04:07:47.6749973,4812e6b0-blabla,123.541618347168
2019-11-09 04:07:47.6749973,49d92f39-blabla,-156.112064067084
2019-11-09 04:07:47.6749973,70ddae22-blabla,44.8208999633789
2019-11-09 04:07:47.6749973,cefcb79c-blabla,76.0225736133698
2019-11-09 04:07:47.6749973,0b319b1f-blabla,29.9991512298584
2019-11-09 04:07:47.6749973,baef7448-blabla,-29.5293839529103
2019-11-09 04:07:47.6749973,a6d76348-blabla,29.2774887084961
2019-11-09 04:07:47.6749973,df2fea3e-blabla,59.9652328491211
2019-11-09 04:07:47.6749973,0318fc6a-blabla,-162.586837513446
2019-11-09 04:07:47.6749973,0880a7c1-blabla,284.739318847656
2019-11-09 04:07:47.6749973,05cc7581-blabla,77.3856881264076
2019-11-09 04:07:47.6749973,194387d3-blabla,285.013061523438
2019-11-09 04:07:47.6749973,c3799c5a-blabla,-42.6271459506236
2019-11-09 04:07:47.6749973,936ca9e3-blabla,284.844573974609
2019-11-09 04:07:47.6749973,a1b0f69e-blabla,179.690447175393
2019-11-09 04:07:47.6749973,62caf16c-blabla,230.60514831543
2019-11-09 04:07:47.6749973,3b9702ac-blabla,63.6789396321069
2019-11-09 04:07:47.6749973,e7642625-blabla,236.001998901367
2019-11-09 04:07:47.6749973,77b22ec5-blabla,-61.2417063824694
2019-11-09 04:07:47.6749973,9d090545-blabla,248.433059692383
2019-11-09 04:07:47.6749973,fd9bd7f1-blabla,59.9873390197754
- What are these measurements you didn’t select? Or perhaps more to the point, what measurements did you select, how did you select them, and what is showing up in your CSV file that you didn’t expect to see?
See Above for the results of the files. I put an arrow at the measurements I didn’t want.
I used the GUI to select measurements, I also tried creating a new adapter and copypasting the connection string directly.
Here is the config as found in SystemConfiguration.xml
:
<OutputAdapters><ID>17</ID><AdapterName>TEST3</AdapterName><AssemblyName>CsvAdapters.dll</AssemblyName><TypeName>CsvAdapters.CsvExportAdapter</TypeName> <ConnectionString>ExportPath=PathtoDestination/tmp; RolloverSchedule=*/1 * * * *; OffloadPath=PathtoDestination/; InputMeasurementKeys={fd9bd7f1-blabla;df2fea3e-blabla;48a707f7-blabla;157a3f6c-blabla;28469ee3-blabla;d689c648-blabla;4812e6b0-blabla;66652897-blabla;70ddae22-blabla;49d92f39-blabla;0b319b1f-blabla;cefcb79c-blabla;a6d76348-blabla;baef7448-blabla;0880a7c1-blabla;0318fc6a-blabla;194387d3-blabla;05cc7581-blabla;936ca9e3-blabla;c3799c5a-blabla;62caf16c-blabla;a1b0f69e-blabla;e7642625-blabla;3b9702ac-blabla;9d090545-blabla;77b22ec5-blabla;}</ConnectionString> </OutputAdapters>