Adding and importing data for a new custom field

  • intouchweb
  • Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
3 years 9 months ago #148122 by intouchweb
We need to add and import data for a new custom field for existing members. Is it simply a matter of importing a csv with two columns - including one identifier (say username or user ID) and the new field? Would this then append the new field record to each user, or will it wipe out the other fields on import? Is it better practice to export the full database and then re-import the lot including the new field data?

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

More
3 years 9 months ago #148128 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Adding and importing data for a new custom field
Hello

Unfortunately, it is not possible to include just two columns. So you need a full export, then add data for that new field and then re-import

Before re-importing, please make sure you make a full backup of the database so that in case something goes wrong, you can restore

In this case, maybe it would be safe to write a script to run this import for new field separately

Tuan

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