The data file to import Asset Warranty information must consist of seven (7) comma separated columns. The columns must be in the following order:
Column |
Field |
Required/Optional |
Description |
|
1 |
Asset Number |
Required |
If no asset number is supplied, the row will not be imported. |
|
2 |
Parts Supplier |
Optional |
This is the name of the supplier, and must already exist in the Suppliers table. If the supplier name does not exist, it will NOT be added. |
|
3 |
Parts Expiry Date |
Optional |
|
|
4 |
Parts Comments |
Optional |
|
|
5 |
Labour Supplier |
Optional |
This is the name of the supplier, and must already exist in the Suppliers table. If the supplier name does not exist, it will NOT be added. |
|
6 |
Labour Expiry Date |
Optional |
|
|
7 |
Labour Comments |
Optional |
|