For more information regarding the security incident at F5, the actions we are taking to address it, and our ongoing efforts to protect our customers, click here.

Forum Discussion

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

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

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.

1 Reply

  • 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.