System Configurations - DB Export

A System Code, HIDECOMPDB, was added to hide specific companies from being exported via the DB export screen.  

Step 1 - Enter Company Codes

Double-click on the HIDECOMPDB record to open it.  Enter the company code you wish to exclude from the export in the Value field.  Separate multiple company codes by a comma (e.g. BFLTD, KACC).  Save.

System Configurations>>System Codes>>System Codes

Step 2 - Select the Tables

Select the table/s that are company-related (contain company codes e.g. Personnel, Positions, Company Access) you wish to exclude by checking the Enable box next to it.  The default values can be used for the File Format, Encoding and Frequency fields.  Click the Save icon next to each row.  The system will backup and export the files, excluding those checked, based on the frequency.  

System Configurations>>Database Export Config

Step 3 – Export

The files, excluding the stated companies, will be exported in both XML and CSV formats as shown in the following XML screenshot example.  HRplus’ Version Control team will provide guidance on the export.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.