Import Settings File Utility

The Import Settings File Utility merges the Standard DBCustom Definition (File: <Ifas7>\XML\Schema\DBCustom.xml) with the Custom DBCustom Definition (File: <Ifas7>\XML\Schema\Custom\DBCustom.xml), then inserts the merged DBCustom.xml file into the database. The Custom DBCustom Definitions are added to the end of the merged file, and any pre-existing table relationship definitions in the standard file are replaced with the respective custom definitions.

If the Custom DBCustom Definitions were not added to the end of the merged file, then the Custom DBCustom file is malformed. Fix the file and run the Import Settings File utility again. There is no alert when Custom DBCustom Definitions fail to merge. It uses the Standard DBCustom Definition to ensure workflow runs properly. 

Import the Custom DBCustom File

1. Open Workflow Designer.
2. Go to Tools, then select Import Settings File. After the utility is executed, a Workflow Designer message appears: Workflow Settings File successfully loaded in IFAS Data.
3. Execute the following SQL from Admin Console SQL Query: select * from ifas_data where name ='dbcustom';
4. Click View Data to confirm that the merged definitions are included. The import process copies the base DBCustom file and inserts it into the database. If a custom DBCustom file exists, it removes all parent table definitions from the base file that exist in the custom DBCustom file, and then appends all the table definitions from the custom DBCustom file. Finally, the merged file is inserted into the database. This process prevents duplicate table definitions when the files are merged.
5. After you confirm the custom table definitions have been merged, restart the Workflow Service, or wait 15 minutes for the cache to be cleared.
6. Test the outcome of the imported file.