Jump to content

Using Automator to populate certain cells in an excel spreadsheet with System Profile data


  • Please log in to reply
1 reply to this topic

#1
shaner3721

shaner3721

    InsanelyMac Protégé

  • Members
  • Pip
  • 2 posts
Hello All,

I am new to automator, but I have learned to use it to some extent.

What I need to do is take an inventory of certain machines (i.e.: serial number, computer name, ip address, mac address, etc.) and put it in an excel spreadsheet to be uploaded to an asset management system.

I have written a vbscript to do this on the windows machine, but I am unable to use that for Mac OS X.

Using Automator I would like to look up the system information and then place it in specific cells within an already created excel spreadsheet. Any insight on how to do this would be greatly appreciated.

Please keep in mind, I am new at this so may need some additional explanations/information.

Thank you,
Shane

#2
shaner3721

shaner3721

    InsanelyMac Protégé

  • Members
  • Pip
  • 2 posts
Update:

I have decided to try and use applescript for this process. I was able to pull the system information into an xml file by using the following line:

do shell script "system_profiler -detailLevel full -xml > /users/skroening/systemInfo.xml"

What I did was save it to my home directory. Now what I would like to do is tell applescript to look through the xml file and pull out certain information to put it in excel.

Does anyone have any insight about doing this???

Thank you,
Shane





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

© 2014 InsanelyMac  |   News  |   Forum  |   Downloads  |   OSx86 Wiki  |   Mac Netbook  |   PHP hosting by CatN  |   Designed by Ed Gain  |   Logo by irfan  |   Privacy Policy