HR Manager - Export CSV file
From All n One's bxp software Wixi
Contents
1 Overview
For integration with other tools and software solutions it is possible to export data from bxp for direct import into other platforms.
For this reason the HR Manager module facilitates a direct CSV export utility.
2 Setup
The fields are placed into Main Menu > HR Manager > System Management > Primary Settings > Details > CSV File > CSV Field List
The fields are a list of Comma Separated Values which are the field names. These fields are from the approved list of system fields from the Client and HR tables.
An example would look like:
strClient_CompanyStaffIdNumber,strClient_Firstname,strClient_Surname,strHR_Personal_Home_Address1,strHR_Personal_Home_Address2,strHR_Personal_Home_Address3,strHR_Personal_Home_Address4
3 Usage
The file generates and is available from the interface from Main Menu > HR Manager > System Management > Export CSV file >
You are presented with a screen which shows which fields will be included in the output
The filename will be XX-YYYY-MM-DD-HH-MM-SS.CSV where
- XX is the Id of the user generating the file
- YYYY is the year the file is generated
- MM is the month
- DD is the day
- HH is the hour
- mm is the minute
- SS is the second
4 Notes
The data generated removes commas from within the data as the file is created, so for example an Address with a , in it will not have the , in the file but it will remain in the data. This ensures compliance to strict CSV layout.
