{"id":4131,"date":"2019-11-01T04:08:33","date_gmt":"2019-11-01T04:08:33","guid":{"rendered":"https:\/\/when2work.com\/help\/guide\/?page_id=4131"},"modified":"2020-09-15T22:50:14","modified_gmt":"2020-09-15T22:50:14","slug":"uploading-shifts-from-file","status":"publish","type":"page","link":"https:\/\/when2work.com\/help\/guide\/uploading-shifts-from-file\/","title":{"rendered":"Uploading Shifts From File"},"content":{"rendered":"

Upload shifts into any Unpublished schedule week<\/h2>\n

\"\"<\/a>Rules and tips for uploading a file of shifts.<\/strong><\/span><\/h2>\n

Upload file must be csv<\/strong> format – from Excel you can export your file in csv format.<\/p>\n

To create a sample upload file you can go to the Calendar Weekly schedule view in your account and use Export and save that as a file.\u00a0 Then open that file in your spreadsheet program to see the fields and use that as the basis for your upload file.<\/p>\n

If open the Upload page while filtered on a position or category this will be ignored when you upload<\/strong>..\u00a0<\/p>\n

Uploading is done one week at a time<\/strong>. (Note you can upload once and then save that week as a template and import that template into future weeks if needed.)<\/p>\n

All shifts in the file for the week you are on will be uploaded from the file. Shifts in the file with dates outside that week will be skipped. <\/strong>You can use the same file to upload into a number of weeks by uploading the same file into each week separately.<\/p>\n

Either “date” or “day of week” must be provided<\/strong> otherwise the shift will not be uploaded.<\/p>\n

If entering a “date”<\/strong> for shift this will override<\/strong> the “day of week” if both are included.<\/p>\n

If using a number for “day of week” our system uses 0-6 with 0 being the first day<\/strong> of your schedule week.\u00a0(i.e, if START DAY is Wednesday, then use numeric 0 to add shift on Wednesday, 1 for Thursday, etc.)<\/p>\n

Must provide a valid position<\/strong> id number or position name, otherwise the shift will not be uploaded.<\/p>\n

Shift category is optional, but must be valid<\/strong> if provided, otherwise shift will not be uploaded.<\/p>\n

If helper name or number not valid<\/strong> the shift will be uploaded as unassigned<\/strong>.<\/p>\n

If assigned shift start or end time overlap<\/strong> an already existing shift for that helper the shift will be uploaded as unassigned<\/strong>.<\/p>\n

 <\/p>\n

import shifts importing shifts add file of shifts multiple shifts<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Upload shifts into any Unpublished schedule week Rules and tips for uploading a file of shifts. Upload file must be csv format – from Excel…<\/p>\n

MoreUploading Shifts From File<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/when2work.com\/help\/guide\/wp-json\/wp\/v2\/pages\/4131"}],"collection":[{"href":"https:\/\/when2work.com\/help\/guide\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/when2work.com\/help\/guide\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/when2work.com\/help\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/when2work.com\/help\/guide\/wp-json\/wp\/v2\/comments?post=4131"}],"version-history":[{"count":7,"href":"https:\/\/when2work.com\/help\/guide\/wp-json\/wp\/v2\/pages\/4131\/revisions"}],"predecessor-version":[{"id":4439,"href":"https:\/\/when2work.com\/help\/guide\/wp-json\/wp\/v2\/pages\/4131\/revisions\/4439"}],"wp:attachment":[{"href":"https:\/\/when2work.com\/help\/guide\/wp-json\/wp\/v2\/media?parent=4131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}