topic Re: Why is batch import rules failing? in API / CLI Discussion

Why is batch import rules failing?

Keith_Richards — Sat, 04 Nov 2017 09:11:24 GMT

Any idea what is going wrong with this batch operation to add a couple of rules?

C:\Users\admin>mgmt_cli -m 172.27.254.180 -u api_user -p ****** add access-rule -b rule2.csv
Error occured during parsing of CSV file.
Line 1 column 6: Unexpected character in the end of line.
Failed to read parameters file [rule2.csv]: Invalid format



C:\Users\admin>more rule2.csv
layer,position,source,destinaton,service,action
Network,bottom,keith,lab.local-ad,http,accept
Network,bottom,lab.local-ad,keith,smtp,drop

Re: Why is batch import rules failing?

Robert_Decker — Sun, 05 Nov 2017 16:03:40 GMT

Please ensure that each line ends with CRLF characters -

"endline can be \n - in Linux or \r\n - in Windows, therefore after \r we expect \n othrwise input is invalid"

Re: Why is batch import rules failing?

Vladimir — Sun, 05 Nov 2017 16:44:07 GMT

Probably end of the line issue.

What editor have you used to create the CSV?

Take a look here for possibilities to modify the EOLs:

excel - CSV End of line - Stack Overflow

Re: Why is batch import rules failing?

Keith_Richards — Mon, 06 Nov 2017 13:25:33 GMT

Thanks Robert - turns out that Notepad++ had created my file encoded with UCS-LE BOM. I don't recognize it so switched to UTF-8 and the errors disappeared!