179 Posts
carin
3 years ago
7
Topic

When I display the SEBLOD core user content type in a List & Search type in administrator I get only newly added users. But I need a list of users that are already in the system. How do I get those?

The user list tutorial seems outdated, my menu item looks different. Thanks

Get a Book for SEBLOD
57 Posts
KKAAZZOO
3 years ago
3
Level 1

Seblod knows nothing about the users who were created on the site before it was installed. You need to re-save the profiles of existing users using Seblod. How to do this can be found in the manuals

179 Posts
carin
3 years ago
2
Level 2

Thanks. I could not find anything on "re-save the profiles". Do you have a link to the manual page?

57 Posts
KKAAZZOO
3 years ago
1
Level 3

179 Posts
carin
3 years ago
0
Level 4

Thanks. But that is not a solution. I cannot possibly go through 8000 users manually. Surely the seblod devs must have thought of such a situation.

3 years ago
1
Level 1

Hi carin,   

you need to insert an entry, for each user, in the tables:

  • #__cck_core
  • #__cck_store_item_users

For #__cck_core

INSERT INTO `o03b4_cck_core` (`cck`, `pk`, `pkb`, `storage_location`, `storage_table`, `author_id`, `author_session`, `parent_id`, `store_id`, `download_hits`, `date_time`, `app`) VALUES
('user', 232, 0, 'joomla_user', '', 232, '', 0, 0, 0, '2021-04-12 06:57:28', '');

Where `pk` is the ID in the table #__users

For #__cck_store_item_users:

INSERT INTO `o03b4_cck_store_item_users` (`id`, `cck`, `gender`, `last_name`, `first_name`, `about_me`, `avatar`, `address1`, `address2`, `city`, `postal_code`, `region`, `country`, `phone`, `website`, `birthdate`, `birthplace`, `company`, `company_vat_id`) VALUES
(232, 'user', 'M', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '', '');

Just replace 232 by the ID of the user.


Regards.

179 Posts
carin
3 years ago
0
Level 2

That sounds better. Thanks, I will try that approach.

Did you do that via a php script?

How do you keep the users between the Joomla tables and the seblod tables in sync?

2 years ago
0
Level 1

Hi Carin,  

Yes, you can do that with a PHP Script.   

The Toolbox Addon help a lot for that.   

How do you keep the users between the Joomla tables and the seblod tables in sync?

Not sure to understand here.   

A user stay a Joomla User, even if you make the link with SEBLOD.

Regards.

Get a VIP membership