File formats for the FTP import

There are two files you can upload to your FTP for Staffwise to import into your system:

• Jobs
  • Please see this article for the format required to import jobs via FTP: Importing multiple jobs
  • You must ensure the word JOB is included in the filename
  • You must ensure the word SCHEDULE is NOT included in the filename
  • The JOB CODE column for FTP job import file is mandatory
    • The FTP import process uses the JOB CODE as a unique ID to match the schedule to the job
  • You need to ensure that the file names are unique as the same file will never be imported/processed more than once
     
• Schedules
  • Please see this article for the format required to import schedules via FTP: Importing a schedule into multiple jobs
  • You must ensure the word SCHEDULE is included in the filename
  • You must ensure the word JOB is NOT included in the filename
  • The JOB CODE column for the FTP schedule import file is mandatory
    • The FTP import process uses the JOB CODE as a unique ID to match the schedule to the job
  • The SHIFT ID column can be used to overwrite shift data from another schedule import
    • Add a unique SHIFT ID to each row if you would like to overwrite shift data in a consecutive schedule import file.
    • Note that if a SHIFT ID is not added, and another import is performed into the same job, these shifts will be added as additional shifts.
  • You need to ensure that the file names are unique, as the same file will never be imported/processed more than once