- CheckMates
- :
- Products
- :
- Quantum
- :
- Management
- :
- Batch add objects , what is the correct CSV format
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Are you a member of CheckMates?
×- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Batch add objects , what is the correct CSV format
I created a CSV file , the format is below
I then transferred this csv file to the Checkpoint management server, run the batch command, i got the following errors
Can someone please assist?
Thanks
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please see How to import multiple objects into R80.x Management database using .csv file for the accepted CSV format.
When you are showing it in a spreadsheet, we do not know what the delimiters are when it is opened in the text editor.
Additionally, if you are creating this file on Windows, it is likely that the EOL (end of line) characters are incorrect.
You can either compensate it by using dos2unix https://bencane.com/2014/02/11/converting-files-from-windows-format-to-unix-format-with-dos2unix/
or using something like Notepad++ to save the file in the compatible format.
Regards,
Vladimir
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
https://sc1.checkpoint.com/documents/latest/APIs/index.html#cli/add-dns-domain~v1.6
Specifically look under "Parameter Name" as these what you can use in the first line of the CSV.
Note that you do not need to include all of the parameters, only the required ones along with the ones you wish to set to non-default values.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please see How to import multiple objects into R80.x Management database using .csv file for the accepted CSV format.
When you are showing it in a spreadsheet, we do not know what the delimiters are when it is opened in the text editor.
Additionally, if you are creating this file on Windows, it is likely that the EOL (end of line) characters are incorrect.
You can either compensate it by using dos2unix https://bencane.com/2014/02/11/converting-files-from-windows-format-to-unix-format-with-dos2unix/
or using something like Notepad++ to save the file in the compatible format.
Regards,
Vladimir
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you so much. txt works.
Also, what is the format of the file if I need to batch add networks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Depends on what parameters you want to set.
In general, the first line is the name of the parameters you want to set, which must match exactly the parameter name in the API documentation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
https://sc1.checkpoint.com/documents/latest/APIs/index.html#cli/add-dns-domain~v1.6
Specifically look under "Parameter Name" as these what you can use in the first line of the CSV.
Note that you do not need to include all of the parameters, only the required ones along with the ones you wish to set to non-default values.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
but what about the groups, if we want to assign all the list of domain on the paticular group at the same time via csv format
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That will have to be done as a separate API call.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I know this is an old thread, but I found out for service groups on r80.40, the csv-format is:
name,members,members,members,members
"icmp-requests","echo-request","info-req","mask-request","timestamp"
I haven't tried any other type of groups, so I'm not sure that the format is universal - it is per group, but if some groups have more or less members, I'd think the import would fail as those columns are empty.
Instead I created a REST-API-script that did the export/import of service-groups for me. I'll be publishing it on GitHub and Checkmates this week.
My bad, published it on github, but forgot to link it here. Created a new post as not to spam external links:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi!
Can you please check what I am doing wrong
mgmt_cli add dns-domain --batch file
[Expert@smartcenter:0]# cat file
name,is-sub-domain
".example1.com",false
".example2.com",false
I tried to use single quotes, without quotes and nothing is worked for me, I am always receive error
Line 2: code: "generic_err_invalid_parameter_name"
message: "Unrecognized parameter [name]"
Line 3: code: "generic_err_invalid_parameter_name"
message: "Unrecognized parameter [name]"
by the way mgmt_cli add dns-domain name ".example1.com" is-sub-domain false, work just fine
Any help ? Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Please revise correct format for batch file as below, then do command again, thanks.
name,is-sub-domain
.example1.com,false
.example2.com,false
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi , Please revise the correct format as below, then do command again, thanks.
name,is-sub-domain
.example1.com,false
.example2.com,false