Log job information to Excel

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

This flow is compatible with: PowerSWITCH

Information

All incoming files pass though the script element which will log the following information into the Excel spreadsheet:

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

The result looks like this:

Using this flow

• Download the flow and save it on your computer: download zip archive
• Save "Job log.xls" file on a specific location on your computer
• Launch one of the SWITCH products this flow is compatible with
• Use the “Flow > Import…” menu item
• In the dialog that is shown, select the flow file
• Select the "Log job information" element in the flow and select
• On the properties pane, select the "Spreadsheet Path" property and browse to the "Job log.xls" file

The flow now appears in the flow list. You can now examine it or customize it to your needs.