Inventory data to be injected

The plugin injects data in the current entity.
Data are imported or not depending on the user's profile on the current entity.
  • if the user has no right to create dropdowns (for example location) then it won't be imported
  • if the user has all rights, then it can import everything

The CSV injector needs one file per type and per entity.
The injection order is important : if you want to import and computer, and associate is with a supplier, then the supplier needs to be still present in the database.

Types allowed for import are :
  • computer
  • monitor
  • printer
  • network device
  • phone
  • peripherals
  • devices
  • user
  • group
  • entity
  • contract
  • supplier
  • contact
  • financial informations
  • network ports
  • cartridges types
  • cartridges
  • consumable types
  • documents
Please note that the plugin cannot import :
  • softwares / versions / licences
  • knowlege base articles
  • tickets

Injection

Specific fields formats

  • Yes/No : 0 = No, 1 = Yes
  • Locations : each element is separated by ' > ' . For example 'Location 1 > Building 1 > Floor 1 > Room 12'
  • Global / unit management : 0 = unit, 1 = global
  • User : the field can be
    - the user's login
    - lastname + firstname
    - firstname + lastname
  • IP Address : it must be XXX.XXX.XXX.XXX where X is an integer
  • MAC Address : it must be XX:XX:XX:XX:XX:XX
  • Date : it must be : DD/MM/YYYY or MM/DD/YYYY or YYYY/MM/DD. You can use the delimiter that you want, even if – or / are better
  • Type : an integer. It represents the GLPI's internal item identifier. Types are defined in config/define.php file
  • each plugin add his own type
  • Entity hierarchy : each entity is separated by ' > '. For exemple 'Entity 1 > Sub-entity 2'

Items

Computers

Name Type Special format
Name Text -
Serial number Text -
Inventory number Text -
OS Product Key Text -
OS Product ID Text -
OS Text -
OS Version Text -
OS Service Pack Text -
Location Text Location
Contact Text -
Contact number Text -
Manufacturer Text -
State Text -
Type Text -
Model Text -
Auto update OCSNG Integer Yes/No
Network Text -
Domain Text -
Is template Integer Yes/No
Template name Text -
Notes Text -
comments Text -
Group Text -
Technician Text User
User Text User
Contract Text -

Monitors

Name Type Special format
Name Text -
Serial number Text -
Inventory number Text -
Location Text Location
Contact Text -
Contact number Text -
Manufacturer Text -
State Text -
Type Text -
Model Text -
Is template Integer Yes/No
Template name Text -
Notes Text -
comments Text -
Group Text -
Technician Text User
User Text User
Contract Text -
Taille Text -
Microphone ? Integer Yes/No
Speakers ? Integer Yes/No
SUB-D ? Integer Yes/No
BNC ? Integer Yes/No
DVI ? Integer Yes/No
Management type Integer Global / unit management

Printers

Name Type Special format
Name Text -
Serial number Text -
Inventory number Text -
Location Text Location
Contact Text -
Contact number Text -
Manufacturer Text -
State Text -
Type Text -
Model Text -
Is template Integer Yes/No
Template name Text -
Notes Text -
comments Text -
Group Text -
Technician Text User
User Text User
Contract Text -
Size Text -
Serial port ? Integer Yes/No
USB port? Integer Yes/No
Parallel port? Integer Yes/No
Domain Text -
Initial page counterl Integer -
Management type Integer Global / unit management

Phones

Name Type Special format
Name Text -
Serial number Text -
Inventory number Text -
Location Text Location
Contact Text -
Contact number Text -
Manufacturer Text -
State Text -
Type Text -
Model Text -
Is template Integer Yes/No
Template name Text -
Notes Text -
comments Text -
Group Text -
Technician Text User
User Text User
Contract Text -
Marque Text -
Number of lines Integer -
Headerphones ? Integer Yes/No
Speakers ? Integer Yes/No
Firmware Text -
Management type Integer Global / unit management

Network devices

Name Type Special format
Name Text -
Serial number Text -
Inventory number Text -
Location Text Location
Contact Text -
Contact number Text -
Manufacturer Text -
State Text -
Type Text -
Model Text -
Is template Integer Yes/No
Template name Text -
Notes Text -
comments Text -
Group Text -
Technician Text User
User Text User
Contract Text -
Mémoire RAM Text -
Firmware Text -
Network Text -
IP Address Text IP Address
MAC Address Text MAC Address

Peripherals

Name Type Special format
Name Text -
Serial number Text -
Inventory number Text -
Location Text Location
Contact Text -
Contact number Text -
Manufacturer Text -
State Text -
Type Text -
Model Text -
Is template Integer Yes/No
Template name Text -
Notes Text -
comments Text -
Group Text -
Technician Text User
User Text User
Contract Text -
Management type Integer Global / unit management

Type of cartridges

Name Type Special format
Name Text -
Référence Text -
Location Text Location
Manufacturer Text -
State Text -
Type Text -
Notes Text -
comments Text -
Technician Text User
Alarm threshold Integer -

Cartridges

Name Type Special format
Consummable type Text -
Creation date Date Date
Use date Date Date
End date Date Date
Printer Text -
Notes Text -
comments Text -
Technician Text User

Consumable types

Name Type Special format
Name Text -
Référence Text -
Location Text Location
Manufacturer Text -
State Text -
Type Text -
Notes Text -
comments Text -
Technician Text User
Alarm threshold Integer -

Network ports

Name Type Special format
Name Text -
Numéro de port Integer -
IP Address Text IP Address
MAC Address Text MAC Address
Mask Text IP Address
Subnet Text IP Address
Gateway Text IP Address
Network point Text -
VLAN Text -
Interface Text User
Connected to : Device name Text -
Connected to : Device MAC Address Text MAC Address

Financial informations

Financial informations

Name Type Special format
Date of purchase Date Date
Startup date Date Date
Warranty duration Integer -
Warranty information Text -
Value Namebre flottant -
Supplier Text -
Invoice number Text -
Delivery form Text -
Immobilization number Text -
Amortization duration Integer -
comments Text -
Order number Text -
Budget Text -
Alarms on financial information ? Integer Yes/No

Contracts

Name Type Special format
Name Text -
Number Text -
Cost Namebre flottant -
Contract type Text -
Start date Date Date
Duration Integer -
Supplier Text -
Account number Text -
Renewal Integer -
Invoice period Text -
Start support hour (week) Integer -
End support hour (week) Integer -
Support on saturday ? Integer Yes/No
Start support hour (saturday) Integer -
End support hour (saturday) Integer -
Support on sunday and holidays ? Integer Yes/No
Start support hour (sunday and holidays) Integer -
End support hour (sunday and holidays) Integer -
Max number of items (0=unlimited) Integer -
Email Alarms Integer Yes/No
Recursive ? Integer Yes/No

Suppliers

Name Type Special format
Name Text -
Address Text -
Code postal Text -
Town Text -
State Text -
Website Text -
Phone Text -
Fax Text -
E-mail Text -
Notes Text -
Type Text -
Recursive ? Integer Yes/No

Contacts

Name Type Special format
Lastname Text -
Firstname Text -
Phone Text -
Phone 2 Text -
Cellphone Text -
Fax Text -
E-mail Text -
Notes Text -
Type Text -
Recursive ? Integer Yes/No

Documents

Name Type Special format
Name Text -
comments Text -
User Text User
Filename Text -
Category Text -
MIME Type Text -
Associate with : type Text Type
Associé with : name Text -
Recursive ? Integer Yes/No

Administrative data

Users

Name Type Special format
Login Text -
Password Text -
Phone Text -
Phone 2 Text -
Cellphone Text -
Fax Text -
E-mail Text -
Notes Text -
Location Text Location
Name Text -
Firstname Text -
Group Text -
Recursive ? Integer Yes/No
comments Text -

Groups

Name Type Special format
Name Text -
comments Text -
User attribute containing its groups Text -
LDAP Value Text -
Group DN Text -

Entities

Name Type Special format
Name Text -
comments Text -
Parent entity Text Entities hierarchy
Address Text -
Postal code Text -
Town Text -
State Text -
Website Text -
Phone Text -
Fax Text -
E-mail Text -
Notes Text -
Admininistrator email Text -
Administrator reply-to Email (if needed) Text -
Entity TAG Text -
Entity DN Text -