Push Workflow Tasks to Objects & Projects via Spreadsheet Upload
Items to be included in the workflow can be selected and downloaded. A download link on the Edit Workflow Template screen will take you to a list of searches. Choose the appropriate search based on the object type selected for this workflow (e.g. if you've selected Risks in the Object Type drop-down, then use the Risks search.) The searches will allow you to select the fields to include in the download as well as any filtering criteria. Searches can be saved for re-use. Certain fields are required for processing the spreadsheet. These fields are denoted by a "REQ" or "ENTER" prefix.
Certain fields are required for processing the spreadsheet. These fields are denoted by the "REQ" prefix.
Fields beginning with RESET should be included based on the type of reset to be performed.
The Project RCM objects will be ignored while performing the Selective Reset.
Click Download.
Note: Select the Download Spreadsheet with Existing Users Data check box to include the existing user information in the spreadsheet.
Populate the Excel upload spreadsheet (see Spreadsheet Population Notes below), and save the file to your hard drive.
Return to the Governance Portal and click Browse on the Population screen.
Locate the modified upload spreadsheet.
Click Process Spreadsheet.
Check the Processing Results box for any errors that may have occurred during import. If an error occurs the spreadsheet processing will fail, no records will be created. Return to the Excel template, and make necessary modifications as directed through the Processing Results box.
Upon a successful upload, workflow tasks become action items for users in the system. These action items can be viewed via the Action Items list in the left navigation pane, the My Portal/Action Item Dashboard or through the Monitoring tab/Workflow sub-tab/Dashboard. Assigned task owners will also receive an email notification with a direct link to complete the assigned task.
Column Headings – Entries
Action
Select Columns
No entry. Columns selected by the user when creating the search and downloaded to the spreadsheet. .
ENTERProjectName
Required. Enter the project name.
ENTERProjectStartDate
Required. Enter the project start date.
REQObjId
No entry. Organization unit id number automatically generated by portal
REQObjTyp
No entry.
Validation
Portal Reaction
Suggested Corrective Action
The object Id was not found for the object type specified