Forum GLPI-Project

afauvin

Member

Registered: 2022-08-12

Posts: 14

Injection of data into databases directly

hello,

I am injecting data from our CRM into our brand new GLPI database; especially in the entities and users tables.
At first everything is going well, I can clearly see all my data via the GLPI interface. My problem happens when I disconnect and reconnect, I only view entities that have been added manually via GLPI.

I compared the lines: identical; I activated the full log on mysql to see what is happening, what I see:

[...] FROM `glpi_entities` WHERE ( `glpi_entities`.`id` IN ('0', '1', '3', '456') [...]

This is because a search in the entities table is made only on a list of IDs passed as a parameter. I do not find in the logs the request to obtain only this list of IDs.
At the level of my DB in the entities table nothing has moved all the data is present.

So I presume there is a table or some other method to perform this filter.

If anyone has any leads, I'm all ears.

Thank you in advance for your answers

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,813

Website

Re: Injection of data into databases directly

You should avoid adding data directly into the database unless you are doing a complete migration from another GLPI installation.
Several item types have cache fields that contain the IDs of their parents and the IDs of their children (may be part of your issue with entities).
Several item types add/modify data to other tables when created.

If you need to bulk-add data, the supported options are the Data Injection plugin and the API.

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.