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 |
- |