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

Holy · ‎01-17-2018

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

NSE 8

NSE 1 - 7

ede_pfau · ‎01-17-2018

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

Ede Kernel panic: Aiee, killing interrupt handler!

View solution in original post

rwpatterson · ‎01-17-2018

ede_pfau wrote:
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

Showoff. ;)

Bob - self proclaimed posting junkie!
See my Fortigate related scripts at: http://fortigate.camerabob.com

View solution in original post

sylwok · ‎04-11-2018

Hi

Can you ?

I can write the script, but I copy every address

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

Nominate a Forum Post for Knowledge Article Creation