problem in csv when in comment column several lines or special characters

[pepjm]

Hi
problem in csv when in comment column several lines or special characters

• For example
  • if several lines in comments of the rules the CSV is cutted in several lines
  • if several lines in description of the objects the CSV is cutted in several lines
• check also with host having a space in name ( Checkpoint convert it to special characters ) could be potentiel a issue
  Thank you

[chkp-edenbr]

Hi @pepjm ,
Could you please upload examples? Are you experiencing any failures due to this?
Regards,
Eden

[pepjm]

This happens in fields
object description
rules comments,
rules additionalfiled1, filed2, field3
Because you can insert several lines .
In the CSV the line is cut in the place of the ‘\n’ . Therefore the csv is cutted

I have done a quick and dirty hack to solve it replacing \n with something here ‘%0d’.
It could be that some other special characters or not UTF-8 conduct to other issues
In utils.py function write_data:
for oneline in res:
for col in oneline:
if '\n' in col:
col=col.replace('\n',' %0d ')

Example

RULE 1:
Accept,false,,any,false,Any,, POC,,false,true,Policy Targets,,5,false,,false,Any,,false,none,false,false,false,None,Any,export_error_CpmiVsClusterNetobj_b2fd6-cc1c-42ca-95f0-2e5df2_fw00,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,snmp,snmp-trap,icmp-requests,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Example1 Server,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

RULE 2: cutted in the comment
Accept,false,"Ticket 000937
RFC 0087 (removal)
C0044",any,false,Any,,IM00018,,false,true,Policy Targets,,6,false,,false,Any,,false,none,false,true,false,Log,Any,export_error_checkpoint-host_569732-6860-11d8-8795-c0a0a0_fw02,fw01,export_error_CpmiVsClusterNetobj_b2fdc9d6-cc1c-42ca-95f0-2e5f46227df2_fvfwc7aslb00,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,FWmanagePorts,ssh,ftp_,https,icmp-requests,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,export_error_checkpoint-host_569dd732-6860-11d8-8795-c0a8c902a0a0_fw02,pcadmin,groupBackup,grouptele,export_error_CpmiVsClusterNetobj_b2fdc-cc1c-42ca-95f0-2e27df2_fw00,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
RULE 3:
Accept,false,"needed ND …….. …. … … … … … …