ldeneken
Mar 15, 2023Nimbostratus
import data from excel into datagroup
Hi,
I have an excel sheet with a mix large numers of hosts and networks;
This is an example of the data I have. The real file is +100's of lines
10.10.128.134 |
10.10.128.136 |
10.10.128.138 |
10.10.128.139 |
10.10.128.145 |
10.10.128.151 |
10.10.128.41 |
10.10.129.31 |
10.10.129.40 |
10.10.129.72 |
10.12.214.0/24 |
10.12.215.0/24 |
I can't to seem to import it via the GUI if I save the file in CSV format.
After digging around I am still unable to do a successfull import.
Hope some one as a solution for me. Thanks in advance
hi ldeneken, you can't upload in that format. The format to upload requires host/network keywords and if you are using key / value pairs, you also need the separator before your values, like this from AskF5 Solution K73862425:
# cat ext_dg_address.txt host 192.168.1.1, host 192.168.1.2 := "host 2", network 192.168.2.0/24, network 192.168.3.0 mask 255.255.255.0 := "network 3", network 192.168.4.0 prefixlen 24,
I created a python script to do this work (for address only) on your behalf, it's here in a gist on GitHub.