Support » Plugin: WP-CRM - Customer Relations Management for WordPress » Import / Extra Data Fields

  • Resolved kwoodall

    (@kwoodall)


    I really like how lean and efficient this plugin is. I need to import some hundreds of users and could use a pointer as to how you store the extra data fields you use in the plugin and the ones the users can configure.

    I’m using WP ALL IMPORT w/USER ADDON to import and it’s not detecting your extra data fields/metadata.

    Help!

    Kermit Woodall

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor MariaKravchenko

    (@mariakravchenko)

    Hello.

    You could find custom attributes in wp_usermeta table in your database.
    Hope that help.

    Regards.

    How would you do that? Open up mysql after I added a user manually got some data but when I import the csv file only email and first name is imported in the wp user visible in the crm but not in the invoice or any other field.

    Hope I made sense here..

    Plugin Contributor MariaKravchenko

    (@mariakravchenko)

    Unfortunately, there is no option right now to import users, information could be found by a developer in the database and moved via some custom script or there should be a special option created in order to import users.

    We could create those features for you by custom request. Feel free to contact Marcus to discuss such requests – https://app.hubspot.com/meetings/marcus-smoot

    Regards.

    The extra user information is kept the wp_usermeta table. I used WP ALL IMPORT to import several thousand users, with custom user fields, into our WP CRM database.

    To discover what fields were named in wp_usermeta I created some sample data and looked for it. I found that WP CRM creates the user field names in a simple why.

    A data field called ‘Digital Subscription Start’ becomes ‘digital_subscription_start’ (minus the quotes).

    Checkbox data items are more complex. Each option becomes its own custom user field. So a custom data field of ‘Subscription Type’ with options ‘Kickstarter,Contributor,Friends,Promotional General,Promotional Review,Website,Promotion’ becomes the following fields:

    subscriptiontypekickstarter
    subscriptiontypecontributor
    subscriptiontypefriends
    subscriptiontypepromogeneral
    subscriptiontypepromoreview
    subscriptiontypewebsite
    subscriptiontypepromotion

    You have to import ‘on’ or ‘off’ (or just blank works as ‘off’ to turn on or off the checkboxes for these.

    Kermit Woodall
    http://woodalldesign.net

    Hi Kermit thanks for the heads up on will be looking at it in the weekend.

    Regards

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Import / Extra Data Fields’ is closed to new replies.