Schedule CSV Upload

The CSV upload module can be opened by selecting Scheduling in the main menu, then Production tab and clicking 'Upload'.

Files to be uploaded can be either dragged and dropped straight from a folder and into the upload box (1.). Or by clicking anywhere on the box and selecting the file from the browser.

Once the file is selected all schedules meeting requirements will appear in the upload preview list (2).

If all entries appear correctly in the preview, click 'Save Entries' to upload or 'Cancel' to make any necessary changes to the file.

Guidelines for CSV files

CSV headings

• id - should be left blank, this is used by Busroot to update existing entries if modified

• station_code - mandatory

• sku_code - mandatory, unless using SKU Grouip

• sku_group_code - mandatory, unless using SKU

• work_order_ref - mandatory

• planned_quantity - optional, if left blank a 'Continuous' schedule will be created

• cycle_time_override - optional, will be used instead of SKU or Station cycle time

• planned_start_at - mandatory, using the formats below

• planned_end_at - optional

Click 'Download as CSV' to download a schedule template.

Date Formats

Busroot will accept files using the following date/time formats

• DD/MM/YYYY HH:mm

• DD-MM-YYYY HH:mm

• YYYY-MM-DD HH:mm

• YYYY-MM-DDTHH:mm:ssZ - ISO 8601

General Requirements

• Any entry that has exactly the same Station, SKU and Planned Start as another in the file or that has been previously uploaded will not be accepted and displayed as a duplicate.