View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|2003||RackTables||default||public||2021-01-08 17:14||2022-08-12 00:06|
|Summary||2003: Reports plugin produces line breaks in exported comments (cvs)|
|Description||This is a report about: https://github.com/RackTables/racktables-contribs/tree/master/|
If there is a line break in comments in Rack Tables, it breaks the exported csv.
|Steps To Reproduce||Have a comment over multiple lines.|
Use the export to cvs function in the reports function: the csv contains line breaks, which makes it hard to import in Excel sheets.
|Tags||No tags attached.|
@infrastation: sorry for the "noise" here in the bugtracker about the plugin code. But I got this as report (and want to work on it) - but did not find the "issue" tab in the corresponding (racktables-contribs) Github repository.
Feel free to assign this issue here to me directly. I will work on it and update the status here later.
Oh, well, OK. I don't remember if CSV allows newlines at all, you might have to use < br > or some other substitute to make it correct. Please take your time. Let's see what to do about issue tracking if there are more of them.
@lrupp: I had trouble importing CSV files with newlines to Excel, but Libre Office is fine with newlines in CSV.
So, i suppose newlines are generally supported in CSV.
There is no single definition of CSV, but there are multiple implementations. As another example, LibreOffice happily opens a UTF-8 CSV file without BOM, and Excel both requires and writes BOM in UTF-8 CSV files.
So if you want to change the code, please remember to specify exactly what your use case is (and maybe test other implementations if you can).
|2021-01-08 17:14||lrupp||New Issue|
|2021-01-08 17:23||lrupp||Note Added: 0004249|
|2021-01-08 19:59||infrastation||Note Added: 0004251|
|2021-01-08 20:00||infrastation||Note Edited: 0004251|
|2022-08-10 15:25||tomium||Note Added: 0004427|
|2022-08-12 00:06||infrastation||Note Added: 0004431|