Custom User Field – Incorrect Data Being Added

  • Resolved hftobeason

    (@hftobeason)


    5 years, 6 months ago

    I have added two Audience fields and *|MERGE|* tags in Mailchimp:

    Field label and type: “Text1” text
    Put this tag in your content: “TEXT1”

    and

    Field label and type: “Text2” text
    Put this tag in your content: “TEXT2”

    I clicked “Renew Mailchimp lists” in WP.

    I added two additional fields in “User Sync”, both from the automatically suggested options given by Mailchimp when I started typing, so I know those fields exist in my database (plus I see them in my php database):

    nickname >> Text1
    wp_2mdz9icapabilities >> Text2

    I then click “Save Changes”.

    When I then force a Manual Synchronization, I do not get the expected results.

    In my Mailchimp Audience listing, I see the two new columns, Text1 and Text2.

    Text1 has, an expected, the nickname data for each Audience contact. For example, “4ctmam”, which matches the php database data for “nickname”.

    Text2, however, does not match the php database data for “wp_2mdz9icapabilities”. Every single Audience contact shows “1” in the Text2 column. The php data for wp_2mdz9icapabilities is always something similar to “a:1:{s:18:”um_registered-user”;b:1;}”, formatted as longtext (note that the data for “nickname” is also formatted as longtext).

    I do not understand why I’m not getting the correct data entered into Text2, and am only getting a “1” in every single case.

    Any advice or help would be very much appreciated.

    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Harish Chouhan

    (@hchouhan)

    Hello,

    Thanks for reaching out to us.

    Please note that because “wp_2mdz9icapabilities” does not contain some text data, wrong details would be sent to MailChimp. I would recommend only syncing data that is saved in a simple text field and not an array.

    Thread Starter hftobeason

    (@hftobeason)

    Thank you for your reply.

    The mysql database structure indicates that the data Type for “wp_2mdz9icapabilities” is “longtext”. Does that not mean that the data *is* text and not an array? Or am I not understanding something? Probably the latter…

    Any ideas how I might be able to extract the “um_registered-user” portion of “a:1:{s:18:”um_registered-user”;b:1;}”, or somehow transfer the entire array as text?

    I’m trying to create Mailchimp Segments organized by the contents of that data field.

    Thank you for any help.

    Plugin Contributor Harish Chouhan

    (@hchouhan)

    Hello,

    Thank you for sharing that. I regret to say this will require custom code is beyond the scope of our support. The data saved in the wp_2mdz9icapabilities is an array so you would first need to use some code to save it in a simpler way.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Custom User Field – Incorrect Data Being Added’ is closed to new replies.