Technical Forum
Ask questions. Discover Answers.
cancel
Showing results for 
Search instead for 
Did you mean: 

import data from excel into datagroup

ldeneken
Nimbostratus
Nimbostratus

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

1 ACCEPTED SOLUTION

JRahm
Community Manager
Community Manager

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.

View solution in original post

1 REPLY 1

JRahm
Community Manager
Community Manager

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.