Moving users from an old site to merge with users in another site

Sorry for the delay, I'm just getting back to this.

I exported the full list and went line by line to match the date fields and get them into the right format. I saved the file as .csv in UTF-8, and checked with a text editor to be sure the fields are comma-separated.

I set the import to "Overwrite existing entries with records matching IDs", and "Ignore emails for new entries".

Now, for some reason, every record is failing with "Cannot import row [xxx] because: Username in use."

If it's set to overwrite, why would I get this error?

Thank you,
Ernie

It loads by and overrides by user id. So for it to update existing rows it needs to have matching user ids. Will review adding support to match and load by username or email address as well since both of those are unique too.

forge.joomlapolis.com/issues/9668

I'm glad I could point this out so that others can benefit from it.

But all the ids were retained from the exported records, so it should have matched by the id and overwrote the records. I didn't change any user names or email addresses or remove any records.

What do you recommend that I do in the meantime?

I can't delete all the records and re-import them. The passwords would be lost and are not part of the export file.

Thank you,
Ernie



 

Are you sure every import record is throwing that? It's possible you have an import that doesn't match. It should skip over errored rows and continue on with the import.

Yes, every record was skipped and returned the same message "Cannot import row [xxx] because: Username in use."

Here's what I did:

I exported all 306 records from the site. It included the native records and those that I imported that were missing the dates because I had them formatted wrong. I realized that when I open the exported .csv file, that Excel tries to convert the date format. When I edited the records, thinking that by removing unused columns that were all blank, etc.) then saving as a .csv, that the formatting in the .csv would not be changed.

After you showed me the date format, I looked at the original .csv and saw that the original file was correct, and that when I edited the file and saved my changes (as a new file), Excel changed the date format, even though I didn't edit those fields.

I imported the file, and all but three records imported - I didn't take note of the error message for them. But again, Excel had converted the date format. But now ALL the records had the registerDate and lastvisitDate blank!

After changing the date format for all the date fields back to mm-dd-yyyy hh:mm:ss, I saved it as a UTF-8 .csv.

And that's where I am now - the .csv has the dates in the right format, but now every record is being rejected with that new error. I just seem to keep making it worse.

All the data (except passwords) is retained and cleaned up in the .csv file, and the date fields are all saved correctly, I just can't seem to get past the error messages to get those fields back into the website.

Thank you,
Ernie
 

Strange. I'm not sure what more to suggest at this point. Retested importing and seams to be overriding fine in my tests. Will review the code further and see if some improvements can be made to maybe catch edge cases.