Skip to Content Skip to Menu

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

  • ernienet
  • ernienet
  • ONLINE
  • Posts: 133
  • Thanks: 10
  • Karma: 1
8 hours 43 minutes ago #341053 by ernienet
I haven't had to do anything like this is many years, and the process seems to have been automated quite a bit since I last had to do it.

A client had about 170 users. They're shutting down that website and they want all their users to be added to their other website, which is basically the same.

Both have Community Builder, both have pretty much identical custom fields, and I thought I prepared the .csv file properly - removing all non-essential columns to make the process simple.

These are the columns I retained to import:idnamefirstnamelastnameusernameemailavataravatarapprovedlastupdatedateregisteripaddrgidsregisterDatelastvisitDatelastResetTimerequireResetparamscanvaspositionacceptedtermsconsentcb_websitecb_companycb_addresscb_citycb_statecb_phonecb_faxcb_companyinfocb_titlecb_zipcb_suitecb_categoriescb_listordercb_sponsorcb_nolistcb_antispam_ipaddresscb_antispam_captchacb_folderaccess
For some reason, the registerDate and lastvisitDate fields did not import properly - they're all blank. I used .csv to export and import the records.

I had the settings set to "Always create new entries ignoring ids of records to import", and "Ignore emails for new entries". It seems the new names were added and only a few with email addresses already existing in the site I imported into failed to import, which is fine.

I also successfully moved the avatars from the old site and added them to the new site images/comprofiler folder successfully.

Is there any way to re-import these dates properly to correct the records? And in the future, what can I do to ensure the best result? I have other clients who are merging data and consolidating their websites. Some of them will be asking me to do the same thing.

Thank you,
Ernie

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum