Foren

How to add user inside Liferay's database?

Iseng Dong, geändert vor 12 Jahren.

How to add user inside Liferay's database?

New Member Beiträge: 11 Beitrittsdatum: 25.04.12 Neueste Beiträge
Hi all....
I really need help emoticon

So, I have user database from another website which doesn't use Liferay. Now, how do I enter these "huge" amount of users into Liferay's users database?
Well, I tried a few things:
1. I make the user's table's structure as the same as possible with the user_ table in Liferay.
2. Insert the users data into Liferay's table called user_
3. Insert the users data into Liferay's table called contact_
4. Insert the users data into Liferay's table called users_groups
5. Insert the users data into Liferay's table called users_roles

After those 4 things, I tried to check it on the Liferay interface. I checked on the "Users and Organizations", but I can't find anything.

Please.... help me....
by the way, I use Liferay 6.1 emoticon

thanks for your help.... emoticon
thumbnail
Hitoshi Ozawa, geändert vor 12 Jahren.

RE: How to add user inside Liferay's database? (Antwort)

Liferay Legend Beiträge: 7942 Beitrittsdatum: 24.03.10 Neueste Beiträge
That's right. Users' are also assigned default roles and personal public and private pages are also created.

The correct way to do this is to use Liferay's API or web service.

http://www.liferay.com/community/wiki/-/wiki/Main/Web+Service+samples
Iseng Dong, geändert vor 12 Jahren.

RE: How to add user inside Liferay's database?

New Member Beiträge: 11 Beitrittsdatum: 25.04.12 Neueste Beiträge
Hitoshi Ozawa:
That's right. Users' are also assigned default roles and personal public and private pages are also created.

The correct way to do this is to use Liferay's API or web service.

http://www.liferay.com/community/wiki/-/wiki/Main/Web+Service+samples


Thanks for the reply.
So, are you saying all of the steps that I've done so far is correct? And?
thumbnail
Hitoshi Ozawa, geändert vor 12 Jahren.

RE: How to add user inside Liferay's database?

Liferay Legend Beiträge: 7942 Beitrittsdatum: 24.03.10 Neueste Beiträge
So, are you saying all of the steps that I've done so far is correct? And?


No. I'm saying you've wasted your time trying to add users directly to Liferay database.
Iseng Dong, geändert vor 12 Jahren.

RE: How to add user inside Liferay's database?

New Member Beiträge: 11 Beitrittsdatum: 25.04.12 Neueste Beiträge
Hitoshi Ozawa:
So, are you saying all of the steps that I've done so far is correct? And?


No. I'm saying you've wasted your time trying to add users directly to Liferay database.



LOL.... thank you very much. I will try that service emoticon
thumbnail
Hitoshi Ozawa, geändert vor 12 Jahren.

RE: How to add user inside Liferay's database?

Liferay Legend Beiträge: 7942 Beitrittsdatum: 24.03.10 Neueste Beiträge
I've wasted few days trying to update the database too to recover a lost user. Liferay was updating more tables than I originally thought and I decided to give up. After that, I decided to just use the API and that only took few minutes to do. Learned the lesson the hard way.
Iseng Dong, geändert vor 12 Jahren.

RE: How to add user inside Liferay's database?

New Member Beiträge: 11 Beitrittsdatum: 25.04.12 Neueste Beiträge
Hitoshi Ozawa:
I've wasted few days trying to update the database too to recover a lost user. Liferay was updating more tables than I originally thought and I decided to give up. After that, I decided to just use the API and that only took few minutes to do. Learned the lesson the hard way.



I tried the userGetSample.bat ; but, it only creates an empty file. why is that? Is there any specific settings that must be done?
thank you in advance emoticon
thumbnail
Hitoshi Ozawa, geändert vor 12 Jahren.

RE: How to add user inside Liferay's database?

Liferay Legend Beiträge: 7942 Beitrittsdatum: 24.03.10 Neueste Beiträge
I've included all the documentation in the download. The samples is also written for Liferay 6.0.5. You'll probably have to do some modification and rebuild it because user attributes have changed between versions.

Also. you need to specify user/password credentials.
Iseng Dong, geändert vor 12 Jahren.

RE: How to add user inside Liferay's database?

New Member Beiträge: 11 Beitrittsdatum: 25.04.12 Neueste Beiträge
Hitoshi Ozawa:
I've included all the documentation in the download. The samples is also written for Liferay 6.0.5. You'll probably have to do some modification and rebuild it because user attributes have changed between versions.

Also. you need to specify user/password credentials.


Could you tell me which attributes that I need to modify, please? Because, I am still new with Liferay. and, I only have tried version 6.1. So, I don't really familiar with Liferay's attributes.

Thanks in advance.