To move root entity to sub entity

d_inoue · 2024-09-24 08:07:02

Hello,

I use GLPI as root entity only.
Now, I have to make another entity which is not included current one
but completely separated old (current) one.

It means...
<Now>
[root] = [current]

<To be>
[root]
- [current]
- [new one]

So I searched this forum,
I found a solution, moving assets in current root entitiy to new sub-entity.

But I have too many assets and also tickets and users, etc.

I want to do that by changing records with SQL query on the GLPI database table, glpi_entities.
Please help me to show sample query.

Thank you.

InvisibleJim · 2024-09-28 10:01:31

Probably a safer way than manipulating the database directly would be to use the REST API update Items

***https://github.com/ramylson/glpi/blob/master/glpi/apirest.md#update-items***

d_inoue · 2024-09-30 04:48:14

InvisibleJim, thank you for your reply.

But is it possible changing the root entity itself to sub one?
As I wrote, I have too many items and tickets etc. under the current root entity,
so, I don't want to change the items but the root entity itself.

cconard96 · 2024-09-30 11:54:03

No, you cannot create a new root entity and move the original as a child entity. If you try to force it by changing things directly in the database, it will cause issues.

d_inoue · 2024-10-01 03:51:21

cconard96, Thank you.

So is there any solution to move all of the things -- items, tickets, dropdowns and whatever I've not recognize -- in the root entity to new child entity?
I think changing entity hierarchy is easier...

Last edited by d_inoue (2024-10-02 07:09:01)

cconard96 · 2024-10-03 15:10:58

You can add items to the entity transfer list in bulk using massive actions (Select all from search results, click actions button, select Add to transfer list).
It is still a manual process though.

Sico31 · 2024-10-11 08:39:25

Hi, i will have the same problem and try to move in my test instance.
I have this
ROOT
- E1
- E2
- E3

and want
NEW ROOT
|- old ROOT
| |- E1
| |- E2
|-E3

So i create a new sub entity and indicates it as father for E1 and E2
I rename the root
In database, i use a script thaht change the entity_id present in many tables to move them from root (id 0) to new root (id 5)
This had works fine. I just too manage some few users and group to be in the root entity (SA user, 1-2 techniciens group, few forms)

Forum GLPI-Project

Announcement

#1 2024-09-24 08:07:02

To move root entity to sub entity

#2 2024-09-28 10:01:31

Re: To move root entity to sub entity

#3 2024-09-30 04:48:14

Re: To move root entity to sub entity

#4 2024-09-30 11:54:03

Re: To move root entity to sub entity

#5 2024-10-01 03:51:21

Re: To move root entity to sub entity

#6 2024-10-03 15:10:58

Re: To move root entity to sub entity

#7 2024-10-11 08:39:25

Re: To move root entity to sub entity

Board footer