Callstack: at (Enterprise_Tools/Additional_Tools/Shiftboard_Drop_Point_Service), /content/body/pre, line 2, column 45
Welcome to the Drop Point Service from Shiftboard. Your user account has been created and is ready for you to test connectivity. To connect to the Drop Point service, please use SFTP to connect using the following information:
Example SFTP commands
Unix/Mac: sftp sbd1234567@srop.Shiftboard.com
Windows: psftp -i shiftboard_droppoint.ppk abd1234567@drop.Shiftboard.com
Interaction with the service:
When you connect, you will find the following four directories already exist.
|incoming/||Where you place CSV files you want us to process.|
|outgoing/||Where we will place files for you to pick up.|
|processed/||Contains files that were once in incoming/ but have since been processed by the system.|
|.ssh/||Contains authorized keys which you can update to add or remove keys which have access to your account.|
Files uploaded by you into incoming should be CSV files and named according to the following structure:
- <Function> - <Date YYYY-MM-DD> - <Counter>. csv
The counter should be incremented with each upload for a given function per day.
Files we place for pickup will follow the format:
- <Function> - <Date/Time YYYYMMDDTHHMM>.csv
Sample file format:
|Shiftboard ID||Last Name||First Name||Day Phone||Account Status|
To update a user, file must have Shiftboard id or external id associate with the upload.
If a user is not in Shiftboard- Upon upload, a user will be created regardless if the user id is in the file.
If a user is in Shiftboard- Shiftboard will update that user based on the matching user id.
If the file is sent with no matching user id then the line(s) in that file will error out and the user will not be updated.
Please contact us via firstname.lastname@example.org or 1-800-746-7531 ext 2 if you have any questions or issues.