Elxis CMS Forum

Support => Technical support => Topic started by: Amigamerlin on June 01, 2013, 21:37:41

Title: Bulk insert users inside ELXIS User Table
Post by: Amigamerlin on June 01, 2013, 21:37:41
Hello,
I've an excel file with some users personal data (100 item). I need to create user's account inside ELXIS 2009.3.
Then I'm trying to populate elxis 2009 elx_users table using the sintax below via phpmyadmin 3.4.7.1:

Code: [Select]
INSERT INTO `elx_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendemail`, `gid`, `registerdate`, `lastvisitdate`, `activation`, `params`, `extrafields`, `preflang`, `avatar`, `website`, `aim`, `yim`, `msn`, `icq`, `phone`, `mobile`, `birthdate`, `gender`, `location`, `occupation`, `signature`, `expires`) VALUES
(316,'name  surname','test','test@gmail.com','baf3c3d665638c69ddd434c888ea0d1a','Group 8', 0, 0,34, '2013-06-01 16:27:30', '1979-12-19 00:00:00', NULL, NULL, '2=Nessuno', 'italian', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MALE', NULL, NULL, NULL, '2060-01-01 00:00:00');

The command will execute without problem, I can see the new record inside the table, but in the elxis backend the users just inserted is not present.
What I'm doing wrongly? Any help ?

Thank you you all
Bye
Title: Re: Bulk insert users inside ELXIS User Table
Post by: datahell on June 02, 2013, 10:29:53
User data should be inserted in multiple tables and especially the "acl" ones.
Title: Re: Bulk insert users inside ELXIS User Table
Post by: Amigamerlin on June 02, 2013, 14:40:55
Thanks datahell !!!