Uploading actor context records
After you have compiled the actor
context records, you must upload them to Infor Spreadsheet Designer (ISD).
- From ISD, create a new tab and name it ActorContext.
- Click Insert Upload.
- Select the application data area for adding the actor context: <tenant>_<type>_fsm or <tenant>_<type>_hcm.
-
Specify these upload properties:
- Business Class: Select the Actor Context business class
- Action: Select Create
- Field Map: Select Actor, ContextProperty and Value
- Add a column between ContextProperty and Value and name it ContextProperty.KeyField.
- Click Reset Mapping.
- Populate the spreadsheet with your list of actors and the data in ContextProperty.KeyField and Values. One way to do this is to add all actors for a single KeyField, then adding the vlookup formula (step 11), then adding all actors for the next KeyField and so on.
- Add a formula to all fields in the ContextProperty column for a vlookup. Specify: =VLOOKUP([@[ContextProperty.KeyField]],LISTMAP_TABLEContextProperty,2, FALSE).
- When all data is added, go to the Infor tab and click Upload.
- Validate the records by launching Infor Rich Client or by going to the ActorContext list URL: https//gen-<tenant>-<type>.inforcloucsuite.com/fsm/web/List/ActorContext