The import file must be a comma delimited (.csv) file. An excel file can easily be saved as a comma delimited (.csv) file by selecting the File >> Save As option and changing the Save As Type field to “CSV (Comma Delimited) (*.csv)”. Each column heading needed for the import file is listed below. The import file must follow the exact order as presented below; if this order is not exact the import will be unsuccessful. The import logic expects the column headings to be in the first row/line of the import file. The second row/line of the file is the first row that it tries to import. If an error occurs on any row, it will skip that row and process whatever rows it can. The import screen will display any errors that occur and will provide record counts.

If you just leave the field blank, the import will skip that field and not change the data that exists in that field. If you try to import data into a text field and that data is longer than what the text field can accept, your data will be imported but the excess data will be truncated. For example, move management reference number field is limited to 100 characters. If you try to import a number that exceeds 100 characters, the excess characters will get cut off.

This import is for updating household goods detail and can only be successful when a service order for moving or moving/storage insurance is created and authorized.