Log job information to Excel

This is an example script that shows how to access information from a job and log it into an Excel spreadsheet.

Information

Supported by: PowerSWITCH (WIN)
Language: Visual Basic Script

Description:

This script defines a Flow Element property for the path to the Excel spreadsheet that needs to be used for logging the requested information.

The following information is retrieved for each job:

• Date/Time  
• Job Name   
• Mac Type   
• Mac Creator Job Type   
• Files in Job     
• Size (bytes)     
• Job State  
• User Name

A new row is added to the Excel spreadsheet for each job that is processed.
The following Excel sheet can be used in combination with this script: download spreadsheet.

Using this script

• Download and save the script on your computer: download script.
• Select the script element in your PowerSWITCH flow and browse to the script in the script package property.
  or
• Open the script in the SWITCHscripter and change it to your needs.

Example flow

• Log job information to Excel
  

  This example flow uses a script that information from a job into an Excel spreadsheet.