topic Re: Mgmti_cli import new hosts to an existing group with csv in API / CLI Discussion

Mgmti_cli import new hosts to an existing group with csv

Netadmin2020 — Sun, 24 Jan 2021 12:26:32 GMT

Hello,

I am trying to import from a csv with the below format:

name , ip-address, groups.1

server1, 10.100.12.1, Edge Servers

server2 , 10,100.12.92, Edge Servers

…..

name is the name of the host I want to import, ip-address is the ip of the host , groups.1 is the existing group that I need the new host to be added.

I tried multiple ways to make it happen but nothing worked.

mgmt_cli add host --batch rightone.csv

I received the below messages cause some of the hosts are already saved with other name I suppose.

Line 3xxxx: code: "err_validation_failed"

message: "Validation failed with 1 warning and 1 error"

warnings:

- message: "Multiple objects have the same IP address 10.1.21.82"

errors:

- message: "More than one object named 'server_sql' exists."

What can I do to resolve the problem?

Re: Mgmti_cli import new hosts to an existing group with csv

funkylicious — Sun, 24 Jan 2021 12:52:42 GMT

hi,

you could try adding ignore-warnings, ignore-errors column and set them to true to the csv file.

ignore-warnings	boolean Default: false	Apply changes ignoring warnings.
ignore-errors	boolean Default: false	Apply changes ignoring errors. You won't be able to publish such a changes. If ignore-warnings flag was omitted - warnings will also be ignored.

Re: Mgmti_cli import new hosts to an existing group with csv

Netadmin2020 — Sun, 24 Jan 2021 12:51:17 GMT

I don't want to import duplicated hosts, If it is possible hosts that already exists imported to my group with their current name.

Re: Mgmti_cli import new hosts to an existing group with csv

funkylicious — Sun, 24 Jan 2021 13:06:14 GMT

i think that you would need to sanitize the batch file with everything that's already created

Re: Mgmti_cli import new hosts to an existing group with csv

PhoneBoy — Sun, 24 Jan 2021 18:08:26 GMT

If this is R80.40 or R81: https://sc1.checkpoint.com/documents/latest/APIs/index.html#web/add-objects-batch~v1.7