Import Job Capture
Click the select File Button to open the “open file dialog” which will allow you to navigate to your file in order select it.
Click the Upload button to upload the file onto the server.
Click the Import button to start the import process.
Please Note:
Your file must be in a *.CSV file format.
Any errors are found will be written to the report log, please correct the errors and start the import process again.
Below is a template of the CSV File:
|
No |
Column Heading |
Column Data Requirements |
|
1 |
Job |
Require valid job number |
|
2 |
AddAsCTC |
1/0 |
|
3 |
LogDate |
Require valid log date eg 2020-04-15 |
|
4 |
ItemCode |
Valid stock code |
|
5 |
ItemType |
Stock / Service / Custom |
|
6 |
Quantity |
Required must be greater than 0 |
|
7 |
Warehouse |
Required when a stock item is entered |
|
8 |
Employee |
User first adn last name with correct spelling and spaces |
|
9 |
Rate |
Requuired when a service item is entered |
|
10 |
Department |
If the employee is linked to a department |
|
11 |
Functions |
If the employee is linked to a function |
|
12 |
Notes |
|
No Comments