Availability-Group Report as CSV has additional lines and meaningless empty columns at the end

book

Article ID: 128410

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction



Exporting the Availability-Group Report in CSV format the file contains after the last field value a new line with several comma (,,,,,)
example:
<some-customer-name>-<home>-wap-045.W1-F05-AP-4OG-137.jmue,Pingable,5 Days + 19:18:03,2,81.277%,
,,,,,                                        
<some-customer-name>-<home>-sw2-539.W3-R5-ES-1OG-01.jmue,SwCiscoIOS,1 Day + 05:03:10,5,96.095%,
,,,,,    
Why? Is it possible to remove these new lines?

 

Environment

Jaspersoft 6.4.3, Spectrum 10.3

Resolution

The Linefeed at the end of each row in the csv format are due to Jasper limitation.

---> When exporting the Jasper Report to a .csv file, each line has a "Linefeed" at the end. (It is because of the condition status what we show in Red/Green/Yellow color in a text field inside a text field. It is the Jasper design limitation.)
---> Because of the design (where the Condition color is placed in the text field inside a text field), to maintain the gap and distinguish between two rows (two colors) the inner text field is adjusted to fit in the row textbox and maintained a gap to top and bottom alignments.. Jasper creates a new row when it finds this kind of gap and translates this as the Row splitter when we export to Excel / CSV.

This is a know anomaly in Jasper Design.

This has been discussed with CABI team also. If we want to remove that extra line then the UI look and feel will be changed. In attachment you can find a screenshot of both current and new changes. With that new design, the new line feeds/extra line in the csv / excel will be removed.
This modification will require a patch. If you need it, please open a case and contact the support.

<Please see attached file for image>

User-added image
 

Attachments

1558689530378000128410_sktwi1f5rjvs16fxs.png get_app