23. 12. 2024
Asset Management, Service Management, Uncategorized
30. 09. 2020
Gabriele Cecco
NetEye, Service Management
GLPI – SIM Card Data Migration from Plugin to Core
Beginning with GLPI version 0.83 a very useful plugin to record SIM card data was available.
The plugin was created by Walid Nouh and then updated by Anthony Piesset and Thierry Bugier Pineau, and was very convenient for keeping track of company SIM card data.
In addition to the specific data of the SIM like number, serial, PIN, PUK, size and so on, it was also possible to add relationships to connected assets (phone / PC / wireless router), documents and many other things.
This plugin was regularly updated and remained compatible until GLPI version 9.1.
Starting with GLPI 9.2 version, SIM cards were introduced as “components” in GLPI, and thus the plugin was no longer useful and therefore has not been updated any longer.
However, managing the SIM cards as “components” in GLPI was inconvenient, and Kaya84 created a fork that currently allows you to use the plugin up to GLPI 9.4.4
SIM cards management in GLPI version 9.5 (where it was always managed in “components”) has been improved and even if it is not as easy to use as in the Walid Nouh plugin, we might want to use it and trust that its usability will be further improved in the future.
For those who have updated GLPI to version 9.5, that plugin is no longer available. If you have a lot of data in the plugin unfortunately there is no migration script that transfers the SIM data from the plugin to the core.
However, don’t worry! It’s not necessary to re-enter them manually!
With a little familiarity with MySQL, you can easily migrate the data from the GLPI plugin to the core.
Follow the queries below and you will find your SIM card data transferred from the old plugin to the core. Most likely you will have to make some additions if you use other fields, but you will already have the bulk of the work done.
Query that inserts the SIMs in the new GLPI component table
insert into glpi_devicesimcards (id,designation,entities_id) select id, name, entities_id, from glpi_plugin_simcard_simcards;
Query that inserts the comments of the SIMs in the new GLPI component table
update glpi_devicesimcards gd join glpi_plugin_simcard_simcards gpss on gpss.id=gd.id set gd.comment=gpss.comment;
Query that inserts the SIM data into the GLPI item-device relationship table
insert into glpi_items_devicesimcards (items_id, itemtype, devicesimcards_id, serial, otherserial, states_id, locations_id, pin, pin2, puk, puk2) select gpssi.items_id, gpssi.itemtype, gpss.id, gpss.users_id, gpss.serial, gpss.otherserial, gpss.states_id, gpss.locations_id, gpss.pin, gpss.pin2, gpss.puk, gpss.puk2 from glpi_plugin_simcard_simcards_items gpssi join glpi_plugin_simcard_simcards gpss on gpss.id=gpssi.plugin_simcard_simcards_id;
Query that inserts the data of SIMs not associated with a device in the GLPI item-device relationship table
insert into glpi_items_devicesimcards (items_id, itemtype, devicesimcards_id, serial, otherserial, states_id, locations_id, pin, pin2, puk, puk2) select '0', '', gpss.id, gpss.serial, gpss.otherserial, gpss.states_id, gpss.locations_id, gpss.pin, gpss.pin2, gpss.puk, gpss.puk2 from glpi_plugin_simcard_simcards gpss where gpss.id in (select gd.id from glpi_devicesimcards gd left join glpi_items_devicesimcards gpid on gd.id=gpid.devicesimcards_id where devicesimcards_id is null);
Query that adds to the SIM those documents that were attached in the plugin
update glpi_documents_items set itemtype='DeviceSimcard' where itemtype='PluginSimcardSimcard';
Query that fixes the SIM history
update glpi_logs set itemtype='DeviceSimcard' where itemtype='PluginSimcardSimcard';
Gabriele Cecco
Technical Consultant at Würth Phoenix
I’m Gabriele Cecco, a consultant at Wuerth Phoenix with extensive experience in ITSM processes. Over the years, I’ve worked with various ITSM software tools, and since 2020, I’ve specialized in the Atlassian suite, earning certifications and helping many companies configure their Atlassian products.
In my free time, I enjoy listening to science and entertainment podcasts, watching movies and TV series, and traveling. I’m passionate about exploring the world, and when I’m not traveling abroad, I love spending weekends in South Tyrol with my wife and our minivan, Windy.
Author
Latest posts by Gabriele Cecco
31. 12. 2024
Atlassian, Service Management
How to Use the New ‘Request Type Groups’ Feature in Jira Service Management
30. 12. 2024
Atlassian, Service Management
How to Schedule Issues with the New Calendar View in Jira Service Management
04. 09. 2024
Atlassian, Service Management
“Products and entitlements”: the new Jira Service Management feature
29. 04. 2024
Atlassian, Service Management
How to Add Client Company Details in Jira Service Management
24. 01. 2024
Atlassian, Service Management
How the “Customer and Organization Profile” feature can help you