Introduction
- Users might be interested in specifying jobs and dependencies from Microsoft Excel® spreadsheets.
- In a situation when business staff is in charge of specifying jobs then Excel® is a frequently used tool.
- As a no-code approach this allows to specify jobs and dependencies by users without detailed know-how of JS7 - Workflows.
- The solution explained from the article creates jobs and workflows from Excel® spreadsheets ready for import into JS7.
- The solution makes use of a PowerShell cmdlet for Linux and Windows.
Prerequisites
The following PowerShell modules are used for this purpose:
- ImportExcel PowerShell Module (3rd party) to read Excel® spreadsheets on Linux and Windows.
- Optionally the JS7 PowerShell Module to access the JS7 - REST Web Service API for automated import and deployment.
- If the module is not used then users can manually import resulting workflows using the JOC Cockpit user interface.
Download
The following files are used for the solution:
- Sample Excel spreadsheet: jobs.xlsx
- PowerShell cmdlet: New-JS7WorkflowFromExcel.ps1
Getting Started
Excel® Job Specification
Overview
Content Tools