Upload

The User selects and uploads a file from the webpage.

If the file is not in a valid MS Excel format the user will be prompted of this. If it is the upload will begin.

Once the upload is complete the data will be parsed from the Excel file and placed into a dataset. The data will then have a set of basic validation checks.

Once the basic validation checks have been completed a check is performed to retrieve the number of errors, if there are any the file is not processes into the database and all records in the file are returned to the user, with any corresponding errors.

If there have been no errors then the services will be uploaded and customers created (if necessary). If any of these jobs have been added before, the process will check this and add this to the list of errors processing the file.

Once the processing has finished either through error or successful upload, the Excel file is deleted.

The screen then displays the log with all messages, success or failure.

Note: There are some limitations with using the upload, most notably that if formatting is used with the Excel spreadsheet for dates and times and the data within the field is not valid to this format the system with respond on import advising that this is not a valid conversion. If no formatting is used this is not be an issue.