...
The 'Approval Recovery' link redirects to the following page:
Database Changes
Export status field
Any table (exception made for Issue Approvals and Approval History ) will have a new field EXPORT_STATUS that can be “” , “Draft” or a timestamp representing the import date.
The Export Status field allows to ensure that it is possible to revert the import if the process doesn't complete successfully.
If data having status Draft exist, these data will be deleted before to start a new import or by performing an Approval Recovery.
Entity Id Mapping table
A new table maintains the mapping between the Old tuple Id and the new tuple ID for each entity.
...
ID
...
New Id
...
Insert Approval Data on the database by example
Import into Table: AO_D195E9_CONDITIONAL_RULE
INSERT INTO public."AO_D195E9_CONDITIONAL_RULE"
("CONDITIONAL_NAME", "CONDITIONAL_RULE", "USER_EVALUATOR", EXPORT_STATUS)
VALUES taken from the CONDITIONAL_RULE_XML xml file
- For each new record, maintain a map CONDITIONAL_RULE_MAP between the new CONDITIONAL_RULE.ID and the CONDITIONAL_RULE_XML.ID_EXPORT
- Set Export status = Draft
Import into Table: AO_D195E9_LANGUAGE_PACK
INSERT INTO public."AO_D195E9_LANGUAGE_PACK"
("DESCRIPTION", "ENABLED", "LOCALE", "MODIFIED_DATE", "MODIFIED_USER", "NAME",)
VALUES taken from the LANGUAGE_PACK_XML xml file,
- For each new record, maintain a map LANGUAGE_PACK_MAP between the new LANGUAGE_PACK.ID and the LANGUAGE_PACK_XML.ID_EXPORT
- Set Export status = Draft
Import into Table: AO_D195E9_LANG_PACK_KEY_VAL
INSERT INTO public."AO_D195E9_LANG_PACK_KEY_VAL"
("LANGUAGE_PACK_ID", "PROPERTY_KEY", "VALUE", ID_EXPORT)
VALUES taken from the LANG_PACK_KEY_VAL_XML xml file by replacing LANG_PACK_KEY_VAL_XML .LANGUAGE_PACK_ID_EXPORT with the LANGUAGE_PACK_MAP.IMPORT_ID
- For each new record, maintain a map LANG_PACK_KEY_VAL_MAP between the new LANG_PACK_KEY_VAL.ID and the LANG_PACK_KEY_VAL_XML.ID_EXPORT
- Set Export status = Draft