Guys, out of impatience and lack of exhaustive knowledge about Joomla, I decided to re-install and re-create my site instead of spending hours and hours of internet research to correct my mistake.
Earlier today, I realized that I was able to make a back-up of jos_users database from my previous work.
My question is: how do I import this "precious list" into my new Joomla website. Using phpMyAdmin, what steps should I do? Do I simply import the file (which is saved as rtf) into my Joomla database? Ayoko nang magkamali kasi nakakapagod magsimula sa wala.
By the way, I've previously posted 3 "SOS" in this Filipino forum. Unfortunately, none of them has been replied to. Hopefully, meron nang makakatulong sa kin sa pagkakataong ito.
How to insert users' list into Joomla
-
- Joomla! Apprentice
- Posts: 13
- Joined: Sat Jul 07, 2007 9:57 am
- pe7er
- Joomla! Master
- Posts: 24929
- Joined: Thu Aug 18, 2005 8:55 pm
- Location: Nijmegen, Netherlands
- Contact:
Re: How to insert users' list into Joomla
Regarding phpMyAdmin: I would recommend searching the Internet for some phpMyAdmin tutorial.
I am afraid that jos_users won't be enough to restore the users in your Joomla site.
The users will only appear in the User Manager if all references in the following tables are correct:
jos_users
jos_core_acl_aro
jos_core_acl_groups_aro_map
These are all needed for managing the users... So you have to copy the 2 other tables as well.
Some SQL queries to find the missing info:
http://forum.joomla.org/viewtopic.php?t=137296#p679956
I am afraid that jos_users won't be enough to restore the users in your Joomla site.
The users will only appear in the User Manager if all references in the following tables are correct:
jos_users
jos_core_acl_aro
jos_core_acl_groups_aro_map
These are all needed for managing the users... So you have to copy the 2 other tables as well.
Some SQL queries to find the missing info:
http://forum.joomla.org/viewtopic.php?t=137296#p679956
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
-
- Joomla! Apprentice
- Posts: 13
- Joined: Sat Jul 07, 2007 9:57 am
Re: How to insert users' list into Joomla
Thanks a lot pe7er for the prompt response. Unfortunately, I only have jos_users. I guess that means the table is useless after all.
This is great. It takes a non-Filipino to answer my inquiry which was posted in the Filipino forum. More power to Joomla! community.
This is great. It takes a non-Filipino to answer my inquiry which was posted in the Filipino forum. More power to Joomla! community.
- pe7er
- Joomla! Master
- Posts: 24929
- Joined: Thu Aug 18, 2005 8:55 pm
- Location: Nijmegen, Netherlands
- Contact:
Re: How to insert users' list into Joomla
You could create jos_core_acl_aro and jos_core_acl_groups_aro_map with the info from the current installation:webapostle wrote:Unfortunately, I only have jos_users. I guess that means the table is useless after all.
E.g. create two new users, both "Registered" users.
Export jos_core_acl_aro and jos_core_acl_groups_aro_map to some spreadsheet.
You could use the info from the two newly created users
to recreate the records for the users that you import to jos_users.
It's difficult, takes some time, but it can be done...
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
- guilliam
- Joomla! Virtuoso
- Posts: 4181
- Joined: Thu Aug 18, 2005 10:27 am
- Location: Sunny City Cebu, Philippines!
- Contact:
Re: How to insert users' list into Joomla
that would be somewhat complicated to work with phpmyadmin if youre not that familiar using mysql commands.
do you have or happen to know any mysql applications like navicat or ems mysql manager(both are not open source apps)? as you mentioned that you dont have the other user mapping tables, so you have to re-create MANUALLY the user maps in your jos_core_acl_aro and jos_core_acl_groups_aro_map.
if it doesnt make sense post back will give you a better explanation with screenshots/visuals.
- g
do you have or happen to know any mysql applications like navicat or ems mysql manager(both are not open source apps)? as you mentioned that you dont have the other user mapping tables, so you have to re-create MANUALLY the user maps in your jos_core_acl_aro and jos_core_acl_groups_aro_map.
if it doesnt make sense post back will give you a better explanation with screenshots/visuals.
- g
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.
http://www.joomlaconsultancy.net
http://www.joomlaconsultancy.net
- day
- Joomla! Explorer
- Posts: 394
- Joined: Tue Mar 14, 2006 12:20 pm
Re: How to insert users' list into Joomla
Lack of 'Members' in the main or top menu is a grave omission. This is what happens when developers neglect the bare essentials and prefer to dabble in gimmicks.
Kunena too doesn't have this provision.
But I am sure that I have read a simple solution long time back. I recall that I have tested it successfully.
Kunena too doesn't have this provision.
But I am sure that I have read a simple solution long time back. I recall that I have tested it successfully.
-
- Joomla! Fledgling
- Posts: 2
- Joined: Tue Jun 21, 2011 4:00 pm
Re: How to insert users' list into Joomla
Have you already solved your issue?
- ashokjoomla
- Joomla! Fledgling
- Posts: 3
- Joined: Sun Oct 16, 2011 1:58 pm
- Location: Mumbai
- Contact:
Re: How to insert users' list into Joomla
Hello friends,
I am going to start my first topic on joomla forum.
I m newbie in joomla,
I want to see from where the record get inserted in db table 'jos_users'.
When user fill the data from the front end.
It will better if someone could tell me how com_user is working?
And where i find the INSERT QUERY ?
Thanks.
Regards,
ASHOK.
I am going to start my first topic on joomla forum.
I m newbie in joomla,
I want to see from where the record get inserted in db table 'jos_users'.
When user fill the data from the front end.
It will better if someone could tell me how com_user is working?
And where i find the INSERT QUERY ?
Thanks.
Regards,
ASHOK.