How to upload items en masse in the Inventory

	Inventory Module / Import
	How to import huge amount of data to the Inventory

You can update your inventory en masse with changes in employees, lines, sim cards, device models.

The import also includes the upload of dual sim and esim phones, elines, esim, and SAM cards.

Plusieurs types d'import sont à votre disposition : There are several import types that can suit your needs:

• Parc Inventory (Fleet)
• PIN/PUK
• Customized fields for employee
• Customized fields for a device
• Customized fields for a line
• Customized fields for SIM/SAM

Here is how to import an Inventory (Fleet)

Note: All the other types of import (customized fields) follow the same idea.

1 - Choosing a management group

1 -Go the management group (pool) where you would like to upload new or modified inventory.

2 - Import or upload en masse the items of interest

The import is done by using an excel file that is available in the mytem interface itself.

2.1 - Once you are in the management group you where you have chosen to upload, click on then Fleet (Inventory), represented by the icon

To make another type of import, simply choose the type corresponding to the list above.

2.2 - A new window opens.

2.3 - Use the example to enter your data in the excel file by clicking "here" in the "Download template here". 

2.4 - Fill in the required items and the rest where you would like to add data.

The information below explains how mytem processes the data, and gives the "rules to follow" for the data to be recognized and processed by mytem.

The employee ID, lines, SIM/SAM, IMEI, and serial number have to be unique- that means that duplicate values may lead to error.

2.5 Once your file is filled, drag and drop it in the upload window, or click on it to search the file from where you saved it.

2.6 The data are now found in the Inventory.

 A confirmation message "Success" will be shown in the same window (see more information in point 4 below).

 If your import file contains more than 1,000 rows processing will take place overnight, and the new data will be available within 24 hours. In you have less than 1000 rows the new data will be uploaded within two hours.

3 - Rules of import

Note that if a row in the file contains an error (for example a duplicate phone line), the clean data will be uploaded while the ones in error will be left out.

The items in error will be recorded in a log file (point 4 below). 

Here are the best practices for a successful import:

• Inutilité à renommer le fichier No need to rename the file
• Make sure that there are no duplicates, and that a user is assigned a unique ID.
• No macros or formulas in the text.
• No customized cell format.
• Items in numbers like IMEI or phone lines need to have Text as a cell format
• Les lignes vides en dessous des dernières données saisies dans le fichier doivent être supprimées (évite que des caractères invisibles bloquent le traitement). Empty rows after the last data need to be deleted to ensure that invisible characters do not block the processing).
• Reminder especially for importing updates to an existing management group (pool): remember to fill in the column Management Group. Otherwise mytem will consider your import to be a new one and will assign a new pool to your data.

Here are the rules per column of the import file:

4 - Messages related to the import

In the notifications zone in mytem (bell), you can see messages regarding your import. Click on the bell icon  with a number to display the messages that have not been read.

The type of messages you will receive:

1 - "File imported"

The import has been successfully carried out.

2 - "Import Failed".

The import has not been processed. Check if the rules and recommendations above have been fulfilled (for example required fields).

If you need help, the support team will be available to help you out [e-mail]. 

3 - File imported with errors.

The import has been seccessful for the most part, but sime data must be in error. The errors are indicated in the log file (written in blue).

Example of a log file

* Column A shows the error.

* In the example below, there is one row that is not imported.

If you need help understanding the error, do send us your log file at [e-mail].

unpublished-duplicate