Configuration for CSV and Excel files
This section lists the .xml files that must be modified before you can generate the BIF XML files. These xml files are located at [InstallPath]\TMonitor\bin\Configurations. IRC PDE will convert data from the Excel or CSV files to BIF XML format, specifically for the objects mentioned in the Configuration files alone.
Note: By default, these settings match with the template files provided with the utility. If
there is a change in input template file format, these files must be modified.
Each BIF XML format has a separate configuration file.
| Authorizations Insight | Configuration file name |
|---|---|
| SAP | SAPAIConfig.xml |
| Oracle | OracleAIConfig.xml |
| PeopleSoft HR | PeoplesoftHRMSAIConfig.xml |
| PeopleSoft FI | PeoplesoftFISCMAIConfig.xml |
This table lists the nodes and the purpose of nodes, while generating the BIF XML.
| XML node | Attribute | Description |
|---|---|---|
| PreProcessor/PostProcessor | enabled | Set to true for calling pre-processor
hook. This hook gets invoked before start of extraction. Post Processor hook gets invoked after the extraction. |
| PreProcessor/PostProcessor | Assemblyname | Name of the assembly which is to be invoked |
| PreProcessor/PostProcessor | Classname | Name of the class in the assembly specified |
| PreProcessor/PostProcessor | Parameters | Parameters passed to the assembly |
| BIFXMLFile | Name | Name of the xml file generated after the extraction. This name is IRC standard, hence should not be changed |
| BIFXMLFile | Worksheet | Name of the worksheet in the input excel file or name of the input CSV file. Worksheet/CSV contains input data for the corresponding BIF XML File |
| Field | Name | Name of the field present in the corresponding BIF XML File.
Name attributes should not be changed. |
| Field | Value | Sets the default values for the fields. Some fields contain the unique data, so default values should not be set to those fields. Primary key fields are listed in to the Appendix. |
| Field | Column | This attribute is used for mapping of field and column from the specified worksheet/CSV. |
Note: To implement the PreProcessor and PostProcessor hook, you must implement the
LDLInterfaces.dll in the hook project. This
dll is located at [Install
Path]\TMonitor\bin.