View Single Post
 
Old 04-09-2014, 07:31 AM
shanemarkley shanemarkley is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Dec 2013
Posts: 29
shanemarkley is on a distinguished road
Default

Thank you for fixing the first part of that script Geoff G. It works great so far.

My apologies to both of you for not explaining this better. The table in the Word Doc contains the following 7 columns:

UserID, AP Name, AP Group, Model, Mounting, MAC Addr, Notes

These columns are where the output pulls the information from. The items in the output in " " need to be pulled from the column tables. Here is what the output template looks like:

provision-ap copy-provisioning-params ap-name "«MAC_Addr»"
provision-ap installation default
provision-ap no external-antenna
provision-ap server-name aruba-master
provision-ap ap-group "«AP_Group»"
provision-ap ap-name "«AP_Name»"
provision-ap no syslocation
provision-ap no remote-ap
provision-ap no fqln
provision-ap reprovision ap-name "«MAC_Addr»"

Here is an example of the first two rows:

provision-ap copy-provisioning-params ap-name 9c:1c:12:c5:a6:c8
provision-ap installation default
provision-ap no external-antenna
provision-ap server-name aruba-master
provision-ap ap-group PollockLocal2-PollockHalls
provision-ap ap-name UP.Beaver-AP003
provision-ap no syslocation
provision-ap no remote-ap
provision-ap no fqln
provision-ap reprovision ap-name 9c:1c:12:c5:a6:c8


provision-ap copy-provisioning-params ap-name 9c:1c:12:c5:a0:78
provision-ap installation default
provision-ap no external-antenna
provision-ap server-name aruba-master
provision-ap ap-group PollockLocal2-PollockHalls
provision-ap ap-name UP.Beaver-AP004
provision-ap no syslocation
provision-ap no remote-ap
provision-ap no fqln
provision-ap reprovision ap-name 9c:1c:12:c5:a0:78

I would need the script to create an output like the ones above for each row in the table. Some of these tables can easily be a couple hundred rows.

Thank you both again very much for your help!
Reply With Quote