!!!EXTRACT USER CALCS

The Extract User Calcs (XMUC) screen is designed to extract UserCalcs from an Personality database.

Before the XMUC can be run there are [site preferences|SYSTEM PREFERENCE] that must be defined. Within [IMST], the administrator must define where the Extract and Load files are located and where the load functions are to write the exception files to. These locations are used by the functions to create and retrieve information. The customer can modify these values to represent any directory on their system.

The extract directory is defined using the [EXTRCT DATA FLDR|EXTRCT DATA FLDR(System_Preference)] preference. The load directory is defined using the [LOAD DATA FLDR|LOAD DATA FLDR(System_Preference)] preference. The [ATTACHMENTS FLDR|ATTACHMENTS FLDR(System_Preference)] must be specified so the load functions know where to write the report exceptions log to. 

Once the XMUC function has been run, it will have created an .xml and .data file, it is suggested that the user reviews the .xml file to ensure the correct data was extracted.

The user will then load this data file into the receiving database via the [LMDATA] process.

%%warning When exporting a WF UserCalcs using XMUC, the foreign key references to Workflow actions may cause issues when attempting to load the data file into another instance using [LMDATA]. The ID numbers of the Workflow actions in the second instance may be different and may not match up with the ID numbers in the original instance. For this reason, for Workflow UserCalcs, any Workflow action references in their UserCalc needs to be re-associated to the Workflow actions in the new environment, or the Workflows may not work correctly.%% 

----

!!Report Parameters
||Report Parameters||
|File Name|Mandatory. This is the name of the file that will be created by the XMUC. The name should be representative of the data that is to be extracted
|Product|The user may select a specific product from the available LOV to narrow the list of user calcs to be extracted as user calcs. For example, the user may specify PR to narrow the list of user calcs to all the Payroll related user calcs. 
|User Calcs|The user may select a specific user calc to extract from the available LOV. 
|Exception Level|Mandatory, LOV available (‘0 – 9’ available)


----
![Notes|Edit:Internal.XMUC] 	
[{InsertPage page='Internal.XMUC' default='Click to create a new notes page'}]