topic Re: Import TXT or CSV to an Address Group? in General Topics

Import TXT or CSV to an Address Group?

j_della9 — Tue, 10 Jan 2017 19:50:27 GMT

I have a TXT file (I could also save it as a .CSV) of about 2000 known bad IP addresses I want to block traffic to/from. Is there a way to import this list into an Address Group? I see an option to download a dynamic list but I would then have to host the file somewhere externally and have the palo download it. Is there an easier way to do this?

Re: Import TXT or CSV to an Address Group?

Brandon_Wertz — Tue, 10 Jan 2017 20:27:47 GMT

You can use the migration tool and import a .CSV file specifically for that listing.

I recently did a migration from CheckPoint to a 3020. Migrated about 10000 unique, rules and objects. The process worked perfectly. When I did that migration it was fairly complicated, but I'd think using the .CSV aspect of the tool would be a lot simpler.

You can even use the tool to push the Address Group folder with the objects to your firewall.

Re: Import TXT or CSV to an Address Group?

niuk — Wed, 22 Mar 2017 21:37:33 GMT

You can also use my tool pan-cli , see it described here. Just type 'C:\>pan-cli.exe load -f "address-sample.csv" -u your_login -p "your_password" -d "Panorama or firewall ip address here" -g "name of devicegroup in case target is Panorama' Format of csv file is pretty straighfroward

You can skip address object description. If you skip group name, objects will not be added to group (but created). If you put group name and group doesn’t not exist it will be created for you and objects added to it. The above command was tested with PANOS versions 7 and 8. I included windows binary in the repo, I can upload Linux version, just let me know.

Re: Import TXT or CSV to an Address Group?

bradk14 — Wed, 22 Mar 2017 23:01:21 GMT

all valid responses to be sure. but just to throw it out there, I've done the same sort of thing when manually migrating firewalls and what I did was I figured out the commands I needed for the PA CLI to accomplish what I wanted to do and then I took the IP list in Excel (1 row per IP) and basically used the concatenate function to merge the IP with the full command and then copied and pasted it right into the SSH session.

Re: Import TXT or CSV to an Address Group?

asingh61881 — Wed, 17 Apr 2024 01:10:15 GMT

Hi if we have tick the shared option, how we can do it