Forum GLPI-Project

Signals

Member

Registered: 2024-09-20

Posts: 1

Grab data from a SQL database

Hi,

We have a software that has all the computers that come in to our warehouse, this works with a SQL database, is there a way, plugin or not, that we can use to grab specific data from that SQL database and add it to GLPI?

At the moment we export a xls file with the data we need, convert it to csv and then use the Data Injection plugin to import it to GLPI.

Looking for a more straight forward way of automating this process.

Thanks

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,287

Re: Grab data from a SQL database

using  GLPI's API-REST  and a script you should be able to get your data with a query and injet data with POST method to create objects in GLPI

---

Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9