Upload of PHAS Shop Labour

General

A bulk upload feature exists in the shops database allowing the simultaneous upload of all hours in a given billing period. Note this has to be done shop by shop i.e. M-shop, E-Lab, STS and HPC separately
This feature makes most sense in the M-shop as there are (A) the largest number of staff reporting hours and (B) the M-shop generally has the most work orders in a single billing period.

revised 2015-01-16 (Mark, Martin)

Open the "consolidated billing" spreadsheet with MS Excel
Navigate to the correct worksheet (tab) and save the worksheet in CSV (CSV (comma delimited)) format appending the date range to the filename
Open the CSV file with Notepad, then save it as *.txt file
Call the upload script on the PHAS Intranet at Forms > Shops Database > Import Hours (tab), then browse for the newly created *.txt file
Clean up by deleting the CSV file, it is only required to create the txt file
The script will reject invalid data (e.g. unknown tech, non-existent work order) as well as an incorrectly formatted *.txt file