Applescript for getting data from a spreadsheet

Bob Sneidar bobs at twft.com
Tue Dec 13 13:58:35 CST 2011


Thanks to all who offered help on Applescript and Shell access. I now have a functioning stack that will query a Procurve switch for mac addresses, and compare it to my Spreadsheet data to show me what device is using that mac address, and on which port on the switch it is. 

Next phase: Go through a list of Procurve switches and plot the path to get to the endpoint. At some point I can add the functionality of querying different kinds of switches. Each switch *can* use a different CLI syntax to get the addresses, and some switches (even managed ones) do not even have a command for that. Some Dell switches come to mind. Some do not allow telnet, so it is not going to be a perfect system, but it will work for my purposes at least, and I will give anyone who wants it a copy of the stack. 

Bob


On Dec 9, 2011, at 4:35 PM, zryip theSlug wrote:

> The problem should be in the unix path.
> 
> Try:
> set myPath to POSIX file "/Volumes/data/LogosAdmin/TechData/Tech
> Documents/DHCP Clients.xlsx"
> open workbook workbook file name myPath
> 
> 
> Best regards,
> -- 
> -Zryip TheSlug- wish you the best! 8)
> http://www.aslugontheroad.co.cc




More information about the use-livecode mailing list