Upload inventory data

	Inventory/Upload file
	Learn how to upload inventory data using the import file

A partner or customer can upload partial or full inventory data in mytem360's inventory module (employees, lines, SIM, devices, etc.). 

An inventory import includes the import of dual sim and esim phones, elines, esim and sam cards.

Several kinds of import are available:

• Inventory
• PIN/PUK
• RIO
• BYOD
• BYOL
• Dual Sim - eSim
• Custom employee fields
• Equipment custom fields
• Custom fields line
• SIM/SAM custom fields
• Employee site
• Equipment site
• Line's site
• SIM/SAM site

Here are the steps which are focusing on the Inventory type of import. The other types of import work the same way.

1. Download the import file in mytem360's inventory module.
2. Fill in the file.
3. Upload the file.
4. Read messages regarding the progress of the upload.
5. Check the file for errors (if any).

1. Download the import file.

Click on the icon  found in the Inventory module. A dialogue box opens from which you can download the import file template.

2. Fill in the file.

The table below indicates the fields in the import file and if they are required.

The table below indicates the complete list of the choices available in order to complete the columns "DEVICE CATEGORY" and "DEVICE TYPE". 

 All properties associated with a device, regardless of its category and type, will be standard except in the case of the SIM:

• If the fields "DUAL SIM EQUIPMENT" (column P) and "ESIM EQUIPMENT" (column O) are not set or are set to "NO" while the field "IMEI 1" (column L) is set, then the equipment added will be associated with a "physical SIM" type configuration.

• If the "ESIM EQUIPMENT" field (column O) is not set or is equal to "NO" and the "IMEI 1" field (column L) is filled in with the "DUAL SIM EQUIPMENT" field (column P) equal to "YES", then the equipment added will be associated with a "Dual SIM (physical x2)" type configuration.

• If the field "DUAL SIM EQUIPMENT" (column P) is not set or is equal to "NO" and the fields IMEI 1 (column L) and IMEI 2 (column Q) are filled in with the field "ESIM EQUIPMENT" (column O) equal to "YES", then the equipment added will be associated with a "Dual SIM (physical + eSIM)" type configuration.

• If the "DUAL SIM EQUIPMENT" field (column P) is not set or is equal to "NO" and only the IMEI 1 field (column L) is filled in with the "ESIM EQUIPMENT" field (column O) set to "YES", then the equipment added will be associated with an "eSIM" type SIM configuration.

 The table below shows the complete list of choices available to fill in the "EQUIPMENT CATEGORY" and "EQUIPMENT TYPE" columns.

3. Upload the file.

 Click again on the  icon. 

The dialogue box opens in which you simply drag and drop the completed file.

 

  Once the file has been dropped, processing will take place depending on one of the two conditions:

• The import file consists of less than 1000 lines:

In this case processing will will take place within a few minutes and the data will be uploaded within two hours.

• The import file consists of more than 1000 lines.

Processing will take place in the evening, about 18:30 CET, and the data will be uploaded the following day.

4. Messages showing users how the upload progresses

Once the file has been uploaded to the SAASWEDO servers and processed, three different messages may appear on the bell icon on the upper right page

• The file has less than 1,000 lines.

If the file has been fully uploaded, the message will be: The Import file has been successfully imported. Your Inventory is up to date.

If the file has been partially uploaded, the message will be: The file has been successfully imported: Due to the presence of errors your entire file cannot be processed. Please find the details by clicking on the following link: File

If the file cannot be uploaded, the message will be : Your file is in error and could not be processed. Please find the details by clicking on the following link: File

• The file has more than 1,000 lines.

If the file is fully uploaded, the message will be: Due to the number of rows to be imported the processing of the file takes longer. Please log in tomorrow to view your status.

If the file is partially uploaded, the message will be: Due to the number of rows to be imported the processing takes longer. Please log in tomorrow to view your status. Your file has errors and cannot be processed in full. Please find the details by clicking on the following link: File

If the file cannot be uploaded at all, the message will be: Your file has errors and could not be processed. Please find the details by clicking on the following link: File

Once the log file is open, you will find in column A the message indicating the field or fields affected by errors

The rest of the columns correspond to the columns of the import file.

5. Rules checking for file consistency

There are certain rules in the file that need to be applied in order to validate the consistency of the information contained in it.

If a rule is not applied, the entire row in the upload file containing the error would not be uploaded. For example a row contains an employee ID, employee name, phone line, and IMEI. If the IMEI has an error, the entire row with the employee information and phone line would not be uploaded.

This row containing the error will be the subject of an error message in the log (see item 4 above).

In order for the file to be uploaded correctly, it is also important to pay attention to the points below:

• The empty lines below the last data inserted in the import file must be deleted (this prevents invisible characters from blocking the file processing).
• The number columns e.g. column K (IMEI) must be put in TEXT format (via the Data/Convert menu).
• It is strongly advised to fill in the column MANAGEMENT GROUP (B) when creating an inventory, otherwise a new management group with the name of the instance will be created and the data uploaded into it.
• It is mandatory to fill in the column MANAGEMENT GROUP (B) when updating an existing inventory. If you forget to do so, the data will be imported into a new group replicating the name of the instance.

xyz5678translatedfrompage