Okay
  Public Ticket #2817466
Importing customer data
Closed

Comments

  • Adam Smith started the conversation

    Hi, I am considering purchasing the Amelia plugin for a dog training business. They currently use DogBizPro and I want to switch them over. I will need to create custom fields for the customer/registrant so they can fill in dog license number, membership numbers and vaccine records. My question is, would I be able to import customers from a CSV and map the fields to the customer fields in Amelia? Or do I have to manually input field data to transfer existing customers? Thank you -Adam

  • [deleted] replied

    Hi Adam,

    thank you for reaching out to ussmile.pngI apologize for the later response as we don't work on weekends.

    At the moment, it's not possible to import data to Amelia, I'm afraid.

    You can only import customers, you could do it manually, but it's a bit cumbersome. The CSV file needs to have a specific structure.

    So, you need to populate the first 7 columns, and leave the remaining 10 as NULL. When you add the data, remove the first row (header), and then import the file into wp_amelia_users table in your database.

    Make sure not to repeat any ID (if you already have some users in that table), because the import will fail.