Forum Discussion

ldeneken's avatar
ldeneken
Icon for Nimbostratus rankNimbostratus
Mar 15, 2023

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 ...
application delivery
  • JRahm's avatar
    JRahm
    Mar 17, 2023

    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.

JRahm's avatar
JRahm
Icon for Admin rankAdmin
Mar 17, 2023

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.