Managing Flat File Integration
Overview
SchedulePro can now automatically import the following data from external sources such as HRIS, LMS, and ERP systems at your desired frequency:
- Employee data including names, employee number, active status
- Employee skills, qualifications, proficiencies, plus permitted positions and jobs
- Employee assigned shift patterns
- Approved leave requests
- Time entries
Full definitions for all currently available imports can be found on our Integration templates website.
After completing the required setup these self-service integrations allow you to:
- Reduce the manual work required to maintain data across multiple systems.
- Create error-free schedules with timely and accurate data.
- Run SchedulePro reports such as Work Rule Audit and Qualification and Proficiencies with external data sources.
Monitoring Job Completion
The designated job import monitor will start receiving notifications of the result of the job imports right after the SFTP service is active. That person will receive an email after each job run with the import results.
If there is an error with the import, you will receive an email notification with the affected rows that caused the import failure and the issue that caused it. You will need to review the origin of the error and take the necessary steps to fix the problem.
Email Example:
Troubleshooting Errors
The most common errors can be split in two sections:
- Individual Record Errors
- File Level Errors
Individual Record Errors
- Duplicated employee IDs.
File Level Errors
- Dropping files into the wrong folder. There are strict conventions for paths within the user’s folder on Drop Point. The folder path determines the type of import process used for the data. Content placed in a wrong folder will result in an error during processing.
- File names cannot contain spaces.
- File contains incorrect column headings and does not conform to the expected file template.
- File doesn't have the right extension: all files need to be type CSV.
- Columns in the imported file must match the expected headers from the import templates. Review the Documentation tab for data formatting requirements.
