In the importation scripts (at least the CSV one), I see that there is an option to add a prefix to the user id - presumably to avoid clashing with existing user ids. Let’s say I have current 500 users on discourse and I want to import 1000 users via the CSV script. Let’s say I use a prefix of ‘1’ for the import script so the new users have userid 1000 to 2000. What happens when the organic signups hit userid 1000? Would this create any issue or would the software automatically add the new user to id 2001? I’m trying to work out if I need to put a very high prefix to avoid this issue.

When I looked at the database table for users I saw: id | integer | | not null | nextval('users_id_seq'::regclass) So I think if the importation script doesn’t follow the sequence or reset the sequence higher, then you could get a duplicate key and fail. Hopefully the importation script you use respects the sequence and doesn’t insert into the database ‘blindly’.

The imported users are assigned new Discourse ids. The ids in your csv are saved in a user custom field, but have nothing to do with the discourse user_id.

Importing users

Product Support Migration

pfaffman (Jay Pfaffman) March 18, 2024, 9:41am 2

It doesn’t matter. It’s s problem only if you import from multiple sources and they clash. They be assigned a new Discourse user id, so that’s not a problem.

Topic		Replies	Views
Import keeping old post ids in Discourse Migration kunena	9	1017	October 22, 2018
User experience for imported users? Migration	13	1040	March 19, 2020
Populating a custom user data field Product Support	3	838	May 22, 2023
User data corruption in phpBB3 to WP/Discourse migration Migration	8	1177	June 9, 2023
Account already in discourse SSO openid-connect	1	209	July 25, 2024

Importing users

Related topics