Generate CSV

[christian.hegland@caverion.com]

Hi,

I've been trying the examples from openrb, regarding CSV file generation locally and over FTP. This seems to work flawlessly.
But I would really like to split up the buffer string, so that each object.value goes to each own column.
Anybody got a suggestion?


Best regards
Christian

[Erwin van der Zwart]

Hi,

The buffer string is already comma separated so you should have multi column.

Did you opened the file as csv comma separeted in excel?

[admin]

Can you provide an example of how resulting CSV should look like, should it look like this?

Code:

12

Obj1,Obj2,Obj3 Val1,Val2,Val3

[christian.hegland@caverion.com]

Hi Guys,

Sorry for the delay. Really appreciate your effort to help me out.

My csv now looks like this:

[ column A
address,"name","date","value"
0/6/16,"Heating Active Energy","2019.02.05 23:53:54","4.38843238774139e-40"
0/6/17,"Heating Active Power Total","2019.02.05 23:54:35","2213.32983398438"
]

But would like to have "address" in cloumn A, "name" in Column B, "date" in Column C, and "value" in Column D.

I use the standard ftp script from openrb examples.

Also notice the value from GA 0/6/16, which is raw format. Is it possible to only log decoded values?

best regards
Christian

[admin]

You need to replace two lines:

From:

Code:

1

buffer = { '"date","address","name","value"' }

To:

Code:

1

buffer = { '"address","name","date","value"' }

From:

Code:

1

csv = string.format('%q,%q,%q,%q', logdate, knxlib.decodega(row.address), object.name, tostring(data))

To:

Code:

1

csv = string.format('%q,%q,%q,%q', knxlib.decodega(row.address), object.name, logdate, tostring(data))

As for 4.38843238774139e-40 it not a raw format it's scientific notation. This is used for very small floating point numbers which would be too long if displayed in 0.000... format.

[christian.hegland@caverion.com]

You need to replace two lines:

From:

Code:

1

buffer = { '"date","address","name","value"' }

To:

Code:

1

buffer = { '"address","name","date","value"' }

From:

Code:

1

csv = string.format('%q,%q,%q,%q', logdate, knxlib.decodega(row.address), object.name, tostring(data))

To:

Code:

1

csv = string.format('%q,%q,%q,%q', knxlib.decodega(row.address), object.name, logdate, tostring(data))

As for 4.38843238774139e-40 it not a raw format it's scientific notation. This is used for very small floating point numbers which would be too long if displayed in 0.000... format.

Thank you very much for you help! I've already done these changes, but the generated csv, still have all data in one column :/

[admin]

What are using to open CSV?

[christian.hegland@caverion.com]

What are using to open CSV?

Microsoft Excel 2010

[Daniel]

Upload your csv here

[admin]

Excel might require semicolon instead of comma. See this for more info: https://stackoverflow.com/questions/1014...-semicolon

You can either change regional settings locally, modify script to use semicolon or use LibreOffice which can open any kind of CSV

[Daniel]

In Excel you have to open empty sheet and then go to DATA and from CSV/text. Then you select your file and you can select separator which is coma by default. Excel will also by default display group as a data so changing to text make sense. In 2010 it might be slightly different I have 365.