YAOS – Yet Another Ofiller Script (to import IP addresses into MDS or SmartCenter)

Probably 1000 of these, and yes it is a hack but I like learning new tools.

ofiller/odumper is a great tool for large enterprises that need to extract/enter LARGE number IP address and rules into MDS/SmartCenter in an automated way fashion. odumper extracts data into CSV, you can edit and import via ofiller from CSV. This could be especially cool if you want to upgrade/import and get rid of a lot of crap by editing CSV’s and not through the GUI.

So do you have a list of IPs that have to be inputted into MDS or SmartCenter? Well the hump is getting that list of IP addresses into ofiller format.

Here is a VBscript/Excel macro to do just that.

1) INPUT: List of IPs in CSV


2) Run this VB script inside of Excel


3) Voila!!! The output. Ofiller formatted file




4) Input into ofiller

./ofiller.lin -f ~/mds_import.csv -i csv -o dbedit_input.txt

5) Input into MDS (or smartcenter)

dbedit -f dbedit_input.txt


NOTE: R80 will have this built in, but ofiller will still be have a warm place in my heart.


Ofiller OUT,



Post a comment or leave a trackback: Trackback URL.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Helen's Loom

"Peculiar travel suggestions are dancing lessons from God." - Kurt Vonnegut

Life Stories from Dreez

These are stories from my travels. Generally I like to write stories about local people that I meet and also brag about living the retirement dream with my #1 wife Gaby. She is also my only wife.

%d bloggers like this: