How to link users after importing CSV file

Hi jjcostello01,

Our workflow doesn’t support the form-based input you mention above. Ours is admin-based (meaning the admin does the CSV import) and it’s usually a one-time operation (although you can do it over and over again to update listings if you wish) What we allow for is the following:

The admin usually creates the CSV from other data sources, starting with our sample CSV to get the exact columns to use. When you use the CSV import file, there are some optional columns you can use to assign listings to existing users in the site. You enter their username under a column called “user_id” (no quotes).

When you do that, and the user already exists, the listing is assigned directly to that user’s profile so they can edit it. If the user doesn’t exist, the listing reverts to the admin as the owner.

Our full CSV import documentation covers that and a lot more detail here: https://businessdirectoryplugin.com/docs/#admin-import Definitely read through that to handle the import.

Thanks for the perfect reply. I now know exactly what I need to do.

The quick response is much appreciated.

John

Just a small request for final clarification.

I have looked at the headers in the WP user database, and it has ID only, and not user_id.

So do I change the user_id in the CSV file to just ID.

I presume that the whatever ID I use it should be the same as in the user database.

My problem lies in the fact that user ID is already decided, and hence my question above.

Thanks.

Hi John,

Just to clarify here.

Our CSV import file doesn’t necessarily match the user table in the database–we use our own column names for clarity when creating the file so you know what it is and how it’s used. ID is a very common name, so if we put that in the CSV file, it wouldn’t be obvious WHAT it belonged to.

Stick with “user_id” in the CSV file.