Can't inject users with groups

[kabassanov]

Hi,

There is a failure when one tries to inject users with groups from a csv file. The plugin wants a username and a groups_id, but when the Group_User relation is made, this groups_id is treated through findID as if it was a completename and of course, it doesn't return any ID.

The issue was wrongly mentionned in #306

[jcervantes-sipecom]

Hi, I have the same issue here, I'm getting this error when trying to Import/Inject Users with groups:

SQL Error "1366": Incorrect integer value: 'TALENTO HUMANO' for column `glpi`.`glpi_users`.`groups_id` at row 1 in query "INSERT INTO `glpi_users` (`name`, `realname`, `firstname`, `usertitles_id`, `locations_id`, `usercategories_id`, `groups_id`, `entities_id`, `is_active`, `profiles_id`, `password`, `authtype`, `auths_id`, `is_deleted`, `date_creation`, `date_mod`) VALUES ('[email protected]', 'USERLASTNAME', 'USERNAME', '47', '872', '3', 'TALENTO HUMANO', '87', '1', '28', 'USERPASSWORD', '1', '0', '0', '2024-02-06 12:17:41', '2024-02-06 12:17:41')"

I'm on GLPI 10.0.11 and Plugin version: 2.13.4 downloaded from Marketplace.

[stonebuzz]

There has been no activity on this issue for some time and therefore it is considered stale

If this issue is related to a bug, please try to reproduce on latest release (GLPI and plugin). If the problem persist, feel free to open a new issue.

If it is related to a new feature, please open a topic to discuss with community about this enhancement on suggestion website.

You may also consider taking a subscription to get professionnal support or contact GLPI editor team directly.