Forum GLPI-Project

Jeckt

Member

Registered: 2023-09-22

Posts: 11

Is it possible - partially import from other instance of glpi

Hello,

Just question, is it possible to partially import sql from one glpi instance to second.

What I have:

1 glpi serwer 9.5.7

1 glpi server 10.0.13

What I need:

From 9.5.7 need to import racks/networking devices/cables/devices to 10.0.13 and only those items, nothing more.

Is it posssible? If so, which tables in sql I need to copy to keep all relations up etc..

Thanks in advance

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,287

Re: Is it possible - partially import from other instance of glpi

It' Quite impossible to copy directly from database form an instance to another  :
ie if your rack is assigned to a technician "john doe"  it is written in the db witth is ID : are you sure john doe exists in the new database and has the same ID ?
you have to check this for each link (location, users, model, type, ....)

Instead of copying tables i would use API to GET items and links  and the loop through itemps to POST in the new database (and check for IDs)

---

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