How to make a excel script to add >1000 IP-Adresses to FortiGate?

[Holy]

Hello Guys,

i need to import >1000 IP-Adresses from a Excel Table to FortiGate, so i somehow need to make a script that will convert the IPs to the CLI Add Firewall Adress objects.

Do someone has a excel scriipt for that?

How do you deal with it , if you have to add a large amount of firewall objects?

Thank you

[ede_pfau · Accepted solution]

You may have a look at my tool which I've written in python.

It takes into account that address groups are limited in size, and will create address groups and a super-address group automatically. FQDNs are allowed in the input list (which uses the hosts.deny format) but are converted to static IPs before importing. If you don't like that you are free to change the source code, to be found here: https://beneicke-edv.de/s.../tools/#ext_blacklists

[sylwok]

Hi

Can you ?

I can write the script, but I copy every address