CSV to Address External Datagroup File

Thanks Jason! You always seem to find a smart fix for an annoying problem 🙂

For the minority which doesn't master Python yet (like me 😋) I have concocted a Bash version of it:

#!/bin/bash

# read IP addresses from CSV file into array
mapfile -t ipaddrs < dg_ipaddrs.csv

# loop through array and format each IP address
for addr in "${ipaddrs[@]}"; do
  # remove any leading/trailing whitespace
  addr="$(echo -e "${addr}" | tr -d '[:space:]')"

  # split line into fields on comma delimiter
  IFS=',' read -ra fields <<< "$addr"

  # check if first field contains a network mask or prefix length. The ${fields[0],,} syntax is used to convert the contents of the fields[0] variable to lowercase.
  if [[ "${fields[0]}" == */* ]] || [[ "${fields[0],,}" == *"mask"* ]] || [[ "${fields[0],,}" == *"prefixlen"* ]]; then
    # check if second field is empty
    if [[ -z "${fields[1]}" ]]; then
      echo "network ${fields[0]},"
    else
      value="${fields[1]}"
      echo "network ${fields[0]} := ${value},"
    fi
  else
    # check if second field is empty
    if [[ -z "${fields[1]}" ]]; then
      echo "host ${fields[0]},"
    else
      value="${fields[1]}"
      echo "host ${fields[0]} := ${value},"
    fi
  fi
done > dg_formatted.txt

Nice work, lnxgeek ... love seeing solutions in multiple languages.

I do not know if there is an article but with icall script and getting the data from url like the one for office 365 and scheduling the icall to run every hour will make the solution dynamic:

https://github.com/f5devcentral/f5-office365-ip-url-automation

edit:

Also external automation system can use the API to upload the cvs file and then an API for the icall script to trigger the python script as a way to update the files:

https://my.f5.com/manage/s/article/K41763344

https://clouddocs.f5.com/api/icontrol-rest/APIRef_tm_sys_icall.html