Support is offline. We are back Monday 23 November, 09:00.

User Import - Updated or Overwritten? #67837

Open elisa opened this topic Thursday, 29 July 2021 · 5 replies
Author

Hi, When I use RO CSVI for User Import, will existing Data be overwritten or updated? How to control the behaviour? Thank you!
Elisa

Support

Hello Elisa,

will existing Data be overwritten or updated?

What is the difference between overwritten and updated?

How to control the behaviour?

Joomla user import uses email as required field. If a user with given email exists in database the values from import file are updated else a new user is created.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Hello Tharua,
how can I prevent that a password will be overridden afterwards?

Example: I import users
User logs in and changes password
I import the same user again - will the password be overwritten then?

Thanks,
Elisa

Support

Hello Elisa,

I import the same user again - will the password be overwritten then?

If there is no password or password_crypt field in import file, it won't be overwritten. The details in import file are the fields which are updated in database, other field values stays the same.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Hi Tharuna,
but then I have to delete the Passwort value from the already imported users?
Could there be an option for each field to set up the behaviour?
For example only import passwort if its a new record?
thanks

Support

Hello Elisa,
You cannot set behaviour on each field but you can do two imports with one user file.

  1. To import new users set Overwrite existing data to No on File tab in import settings. This will not overwrite or update existing users. Password is required field to import new users.
  2. For existing users set password or password_crypt fields to skip template field so these fields are skipped on import. In this case set Skip new items to Yes on File tab in import settings. Skip new items will not import new users.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.