Jump to content
InsanelyMac Forum
  • Announcements

    • Allan

      Solution to create a topic or post.   04/24/2018

      Hello guys. The majority of you are having issues to create a topic or post here. This are a problem with our current theme InsanelyMac.  Now the theme will be the Default IPS. Sorry for any inconvenience.
Sign in to follow this  
shaner3721

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

Recommended 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

Share this post


Link to post
Share on other sites
Advertisement

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.



×