Guest
Login
Register
Home
Help
Search
Login
Register
more G-Labs products
This forum is soon going to be read-only.
Please join the new
HomeGenie community on Google+
HomeGenie Forum
Development
Feature request
CSV logfile
« previous
next »
Print
Pages: [
1
]
Go Down
Author
Topic: CSV logfile (Read 866 times)
December 22, 2015, 04:01:17 PM
Read 866 times
kevin1
Information
Hero Member
Posts:
330
CSV logfile
Should we make the logfile field separator a comma since it is a CSV file? If it were proper CSV file it would load directly into excel without having to split text to columns. Empty lines are problematic for data filter too.
Logged
December 22, 2015, 04:06:01 PM
Reply #1
bkenobi
Information
Global Moderator
Posts:
1525
Re: CSV logfile
Not sure if that works since some of the output of logs includes debug data which both could include commas as well as multi-line. I would prefer csv, but I don't think it's as easy as changing the separator from space to comma.
Logged
https://github.com/bkenobi/HomeGenie_Apps
December 22, 2015, 05:44:38 PM
Reply #2
Gene
Information
Administrator
Posts:
1472
Tangible is the future!
Re: CSV logfile
Do not use the space char as the seperator. The separator is the [Tab] character "\t".
There's actually an issue with the timestamp that will result merged to the log level and the event source.
This issue can be fixed by adjusting the
NLog.config
file to have the "\t" separator as well:
https://github.com/NLog/NLog/wiki/CsvLayout
All other fields will be splitted consistently.
Cheers,
g.
Logged
December 22, 2015, 06:14:37 PM
Reply #3
kevin1
Information
Hero Member
Posts:
330
Re: CSV logfile
If comma is needed in a field, the field can be surrounded by double quote to allow comma (for excel anyway).
Logged
Print
Pages: [
1
]
Go Up
« previous
next »
HomeGenie Forum
Development
Feature request
CSV logfile