topic Re: Management API - Using CSV to bulk add objects - Doubled Items in API / CLI Discussion

Management API - Using CSV to bulk add objects - Doubled Items

Linus_Espach — Thu, 09 May 2019 15:45:41 GMT

Hi CP-Team,

I am trying to add a bunch of network-objects at a time. I have a csv-file with this syntax:

name, comments, subnet, mask-length, color

<nam_1>, <com_1>, <x.x.x.x>>, 16, forest green

If I no call the csv via <mgmt_cli add network --batch test_add.csv> I get warnings if a object is reached, which has the same network-definition.
I would like the API to just skip these elements, but process the others instead of stopping and discarding all. (the --ignore-errors would just ignore the warning and double objects, what is not my intension).

Best regards

Re: Management API - Using CSV to bulk add objects - Doubled Items

PhoneBoy — Thu, 09 May 2019 17:01:10 GMT

Add set-if-exists true to your command line.

Re: Management API - Using CSV to bulk add objects - Doubled Items

Linus_Espach — Fri, 10 May 2019 06:31:28 GMT

Hi PhoneBoy,
thanks for your fast reply.
I didn`t see the <more> options, nice 2 have. In this case I am more looking for a <skip-if-exists> option, but probably it doesn`t exist.
Best regards,

Re: Management API - Using CSV to bulk add objects - Doubled Items

Linus_Espach — Fri, 10 May 2019 14:41:23 GMT

That did not resolve the issue. If i add set-if-exists true to my command, I still get the warning and the validation failed. If I add an additions ignore-warnings true, the object is not updated, but a second with same subnet and mask is created.

Re: Management API - Using CSV to bulk add objects - Doubled Items

PhoneBoy — Sat, 11 May 2019 22:35:04 GMT

There is not a skip-if-exists option.
The set-if-exists option will update the existing object, assuming you're using the same name,
But it sounds like you have two different object names with the same network definition.
And, at the moment, your options are to remove the offending entries from the CSV or use ignore-warnings true and have multiple definitions of the same network.