Navigation:  Admin Panel > My Items > Item Types > General Settings >

Import from Excel

Previous pageReturn to chapter overviewNext page

Select Excel from the different possible Connection Types:

clip0103

alert_1818 Please note that only Excel 97 - 2003 Workbook ( .xls extension) files are allowed. The new format ( .xlsx) does NOT work with SSP imports.

 

Field denomination

SSP works with Critical & Secondary Fields when importing data to fill My Items. Critical Fields are required to make a unique Item. The 4 critical fields need to be filled in. If not, the import will skip this item. After 100 errors, the import will stop and return an error message.

Secondary fields are not mandatory, but are used for reporting and statistics. When these fields are not filled in, reporting will show little data. It is therefore advised to complete these fields as well. They will however not stop an import if not filled in.

For each field, the column header needs to be filled in the fields. This must be a 100% match. The column headers need to be on row 1.  The order of the columns is of no interest.

clip0101

Person Unique ID : The unique number of the User. This is normally linked to the LDAP number of the User.
Item Unique ID : The unique number (serial number or auto number) of the Item.
Item Date : The label to identify the date of this data.
Status : can be Active or Not Active. Enter 1 for Active, and 0 for Not Active. Other options are : 
Model : Name of the item, example: iPhone 4, BMW 320D, Fixed Line.
Cost : The Cost of the item, in € or $.
Usage : A number, indicating the usage. This number can be the size of a mailbox in megabytes, the kilometers of a car, bandwidth, ...

 

Buttons:

clip0022: disregards any changes and returns you to the list of all Item Types.
OK: Saves any changes and returns you to the list of all Item Types.
clip0020: Saves any changes but remains on the current page.
clip0093: Saves any changes and clears all fields, allowing you to easily enter another Item Type.