Topic-icon Importing users - what should final two settings be?

More
15 Jun 2018 11:26 #6066

Hello,
There are 7 dropdowns in last two fields. first columns for each field are for database tables and you are select the correct database table for both the fields i.e. user_usergroup_map and usergroups respectively.

Next two columns in each field are for the relationship of both the tables e.g.
1. For first field the relationship is between users and user_usergroup_map so the columns would be id and user_id respectively
2. For second field the relationship is between user_usergroup_map and usergroups database tables, so the columns would be group_id and id respectively.

The fourth column in second field is to select group title i.e. title

All the fields are exactly the same what you will find in the profile settings.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • AirGov
  • AirGov's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
14 Jun 2018 18:27 #6063

Following up to my post of a few minutes ago, I am clicking "Import" in your extension's control panel, then for "Data Source Format" in the drop-down I'm selecting "Database", and unchecking "Local Database". I then enter the database details, click the "Continue" button at the top left, and am directed to the second screen. I'm then manually selecting values from the various drop-downs - because it requires me to, there's no ability for it to autoload them - but when I get to the final two in my screenshot, I don't know what values to choose. Again, as per my OP, they are:

#__user_usergroup_map: what to select for Column 1 and Column 2 (I'm selecting user_usergroup_map in the initial drop-down)

group_id: what to select for Column, Column 2, and Title (I'm selecting "usergroups" in the initial drop-down).

Please Log in or Create an account to join the conversation.

  • AirGov
  • AirGov's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
14 Jun 2018 18:20 #6062

I'm not trying to create a profile. I'm trying to use your ready-made Import Joomla Users profile. I'm trying to import the data from a remote database and on the first screen am entering in mysqli, localhost, my MySql username, database name, etc. Then I click "Continue" and come to a page that you can see in my screenshot. I then have to manually click each drop-down and select a value. I don't know what values to choose for the final two. Despite my trying to use your ready-made Profile, I am still being required to enter in all of the values manually by clicking each drop-down. I just don't know what to select for the final two (please see my original post). Thanks.

Attachments:

Please Log in or Create an account to join the conversation.

More
14 Jun 2018 08:10 #6061

Hello,
You don't need to create the Profile to import Joomla Users as we have already created the profile. You get it by default with the package.

Please check the attached screenshot for the settings.


Thanks
Daniel
Attachments:

Please Log in or Create an account to join the conversation.

  • AirGov
  • AirGov's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
13 Jun 2018 18:05 #6060

New to this extension. I guess I thought it was going to be much more automated than it is regarding data import from another site. Anyway, for my first attempt I am trying to import the Joomla users. I thought that made the most sense before importing Articles and Categories. I think I understand most of it (I'm not a mysql database expert), but I don't know what the correct configuration should be for:

#__user_usergroup_map: what to select for Column 1 and Column 2 (I'm selecting user_usergroup_map in the initial drop-down)

group_id: what to select for Column, Column 2, and Title (I'm selecting "usergroups" in the initial drop-down).

So I'm kind of in a holding pattern at this point and unable to proceed forward with the whole-site import. Thanks in advance for any assistance you can give.

Please Log in or Create an account to join the conversation.