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

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

  • jamesmillere's avatar
    jamesmillere
    Icon for Nimbostratus rankNimbostratus
    Mar 16, 2023

    It sounds like you are having trouble importing an Excel sheet with a mix of hosts and networks into a GUI. Here are a few steps you can take to troubleshoot the issue:

    1. Check the file format: Make sure the file is saved in a compatible format for the GUI. While CSV is a common format for importing data, some GUIs may require a specific file format such as XLSX or TXT. Double-check the documentation or contact the support team for the GUI to determine the correct file format.

    2. Check the data format: Ensure that the data is properly formatted for the GUI. In some cases, the GUI may require a specific format for IP addresses and networks. For example, some GUIs may require the network to be specified as 10.12.214.0/255.255.255.0 instead of 10.12.214.0/24. Check the documentation or contact the support team for the GUI to determine the correct data format.

    3. Use a different tool: If you are still having trouble importing the data using the GUI, try using a different tool to import the data. For example, you could use a script or command-line tool to import the data. This may require some additional configuration and setup, but could be a more flexible and powerful option.

    4. Split the data: If the file is too large to import all at once, consider splitting it into smaller chunks. This may make it easier to import the data into the GUI or other tools.

    Overall, the key to importing data into a GUI is to ensure that the file format and data format are compatible with the tool. By following the steps above, you should be able to troubleshoot and resolve the issue with importing the Excel sheet. Still facing the same problam i would like to refer this source- msbi