This is a great script, but I've had to make a few changes.
The readme.md in Policy CSV-rel2.zip still says it requires Python 2.7!
Newlines and commas in comments cause the remaining columns to split to a new line in CSV. Insert the middle 2 lines below (below line 182) to replace newline char with ;LF; text.
for obj in temp['comments']:
obj['comment'] = obj['comment'].replace('\n',';LF;')
obj['comment'] = obj['comment'].replace(',',';')
comment = obj['comment']
Our rules appear to have comments that were added in during a rule import. These comments have no user attached, which crashes the script out.
After line 184 I added:
if not 'name' in obj['user']:
obj['user']['name'] = "Admin_Import"
Result:
date = date.split(".")[0]
if not 'name' in obj['user']:
obj['user']['name'] = "Admin_Import"
user = obj['user']['name']
The above changes force a username into a comment with no user, allowing the script to complete.
Commas in rule name also need sanitisation.
Find (around line 157):
line['name'] = rule['name']
Replace line to show:
line['name'] = rule['name'].replace(",",";")
EDIT1: However the remaining columns don't input until the next line. So there's still some tidying to do on the change. But at least it completes....
EDIT2: Confirmed that newlines within comment were causing issues, added code to replace newline with text. Also replace commas in comments and names.
