Flat File Integration

This article will help you with the steps needed to setup flat file integrations and a bit of an insight on how flat file integrations work

Flat File Setup and Access

Drop Point folders will be utilized for the import of applicable files and requires some setup to access the service.

Complete each of the following steps:

  1. Generate a SSH Key pair.
  2. Request Access to Drop Point by sending the public SSH key.
  3. Install and Configure Filezilla.
  4. Review the Requirements and Guidelines.
  5. Review the Applicable Data Types, Import Templates and File Paths.

Generate a Public SSH Key

SSH stands for Secure Shell and is a method used to establish a secure connection between two computers. SSH works by authenticating based on a key pair, with a private key being on a remote server (yours) and the corresponding public key on a local machine (Shiftboard). When the keys match, access is granted to the remote user.

You will need to generate a SSH key pair, and you will need to send us the public SSH key so we can add it to the Drop Point service so it will match your private key.

Request Access to Drop Point

Once you have generated your SSH Keys, follow these instructions.

  1. Send a request to our support team at support@shiftboard.com with the subject line Request to enable SFTP service and containing the following information:
  • Your organization name.
  • Your designated IT point of contact (name and email address) for us to work with.
  • The email address of the person tasked with monitoring the completion of SFTP imports.
Someone in your organization should be tasked with monitoring successful completion of import jobs. You will need to decide who that person will be. The email address of that person will be linked to the Drop Point service and will receive notifications of the status of the import job.
  1. Shiftboard will assign someone to work with your IT person. We will contact that person and send them the Drop Point setup and access instructions.
  2. Shiftboard will add the email address of the designated job import monitor.
  3. After SFTP service activation is completed, you will start receiving notifications of job runs.
  4. Once we receive the public SSH key, we will create your Drop Point access and we will email you the necessary information to connect to the sFTP servers.

Email Sample:

Host: drop.shiftboard.com

Port: 22 

Username: [username] Username is based on the Organization GUID and will be prefixed with ‘spro’ . Example: spro5d32ab66-d9e7-4051-a333-4ae947f1ec06

Directories: based on the integration you will be setting up.

  1. Shiftboard will set up a meeting with your organization to do a test of a sample file drop to make sure everything is working as expected.

Install and Configure Filezilla

  1. Download Filezilla win64.zip.

  1. Once it’s been downloaded, extract all and run the filezilla.exe file.
  2. Go to Edit > Settings.
  1. Select SFTP and then Add key file.
  2. Choose your SSH Keys folder and select Private Key and then select OK.

Requirements and Guidelines

  • Only Integration Flat File Templates can be used.
  • Files are required to match the template formatting (including the header names) , see the Documentation tab for formatting guidelines. If the data at origin doesn't match the formatting expected in SPro, a pre-work will be needed on your side (middleware) to get the files in the format that SchedulePro expects.
  • Customizations are not permitted.
  • Files are required to be in .CSV file extension format.
  • File names cannot contain spaces.
  • Files will be imported immediately once uploaded into Drop Point. Any cadence you want to set to import the files into SchedulePro will need to set on your side pre-drop.
  • Importing data will only add/update data to the database, it will not delete records. Deletion of records must be conducted manually.
  • 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.

Applicable Data Types, Import Templates and File Paths

Click any Integration Flat File Template link to download the template.

{filename} is the name you give your file.

Data Type

Integration Flat File Template

Import Folder Path

Employees

Employee Import

/Employees/{filename}

Employee Jobs

Employee Jobs

/EmployeeJobs/{filename}

Employee Shift Pattern from Library

Employee Shift Pattern from Library

/ShiftPatternsFromLibrary/{filename}

Employee Seniority

Employee Seniority

/EmployeeSeniority/{filename}

Employee Permissions Group

Employee Permissions Group

/PermissionsGroup/{filename}

Employee Approval Managers

Employee Approval Managers

/ApprovalManagers/{filename}

Employee Secondary Locations

Employee Secondary Locations

/EmployeeSecondaryUnits/{filename}

Employee Secondary Positions

Employee Secondary Positions

/EmployeeSecondaryRanks/{filename}

Employee Qualifications & Proficiencies

Employee Qualifications and Proficiencies

/QualificationsProficiencies/{filename}

Employee Team Codes

Employee Team Codes

/TeamCodes/{filename}

Employee Skill Codes

Employee Skill Codes

/EmployeeSkills/{filename}

Employee Overtimes

Employee Overtimes

/EmployeeOvertimes/{filename}

Employee Notification Preferences

Employee Notification Preferences

/EmployeeNotificationPreferences/{filename}

​Daily Core Staffing Requirements

Daily Core Staffing Requirements

/RequirementTemplates/{filename}

Leave Requests

Leave Requests

/LeaveRequests/{filename}

Position (Rank) Codes

Position (Rank) Codes

/RankCodes/{filename}

Location (Unit) Codes

Location (Unit) Codes

/UnitCodes/{filename}

Leave Account Yearly Allowances

Leave Account Yearly Allowances

/LeaveAccountYearlyAllowances/{filename}

Leave Account Balances

Leave Account Balances

/LeaveAccountBalances/{filename}

Work Records

Work Records

/WorkRecords/{filename}

Time Entries

Time Entries

/TimesheetEntries/{filename}

The imports you need to integrate your organization with SchedulePro will depend on the data that exists in your system and the scheduling solution that has been setup for you in SchedulePro. Talk to your Implementation Consultant or Customer Success Manager to help you make those decisions. Also have a look at the diagram below and our recommendations.

How flat file integration work

Not for real time data flows.


How did we do?


Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)