1 of 1 people found this helpful
There is OTTB shared workflow to build hierarchical key structure/validate/promote records loaded into most of the forms you mentioned. However, this workflow is triggered by certain values in 'zTmp_Object_Operation' field (for example 'zTmp_Object_Operation' = "TriggerPromote") and, as far as I know, there is no console/documentation on how to use it.
So, you may want to take a look at the workflow, import the records from csv file and manually set the needed zTmp_Object_Operation value to trigger the process. I did this for the older version of Case HR (v4.5) and it was a bit buggy, but eventually I got it to do what I needed.
Thank you very much for this information. I have attempted to repeat what you did with version 4.5, however, I've had limited time and haven't yet loaded any data. I'll continue when I have time. If you have any more notes on this they could be very useful. Do you know if there are any plans to develop this into a supported and documented process?
Most of these LOAD forms were added in HRCM 4.7 to support the solution export/import. Export/Import is done using D2P console provided by AR.
When solutions are exported from the source server, some of the related data is also exported and imported. There are some exclusions, for example people related data is not exported/imported.
When you use the D2P console to import solutions, a series of triggers are sent to the data staged in the LOAD forms to validate the data and then "Promote" the data to the production forms.
If you are trying to import data directly from the spreadsheets to the production forms, you will need the keys to be regenerated.
You can try the following:
1. set the zTmp_Object_Operation field in the csv file to "Merge_Gen_Key"
2. Create a filter guide and attach it to the form into which you are importing data.
Check COL:CASE:Solution-Merge_Gen_Key, COL:CORE:Menu-Merge_Gen_Key, COL:CORE:MenuValues-Merge_Gen_Key filter guides on the server. You can create filter guides similar to these filter guides if the form you are importing data into doesn't already have this filter guide.
3. Add your form to the filter COL:GLBL:FUNC-AAA300-G-CGD-Merge_Record.