Support » Plugin: WP Issues CRM » Export function not working for me

  • Resolved earrame

    (@earrame)


    Hello again,

    We would like to be able to export data from either a full list of contacts or a filtered part of the list. I believe that I see how to do this, but when I export the csv and open in in a spreadsheet, I don’t see the data. For example if I do a search for every constituent who can display a yard sign, and the go to export and ‘export dump’, I then get a cvs that I open with my spreadsheet. Looking at that spreadsheet, I don’t see the names or addresses of the people that should be there. in addition, in cell A1 it says this:

    <div id="error"><p class="wpdberror"><strong>WordPress database error:</strong> [Incorrect column name 'Yes! Nathaniel's campaign may use my name as an endorsement (custom_field_009)']<code>CREATE TEMPORARY TABLE wp_wic_temporary_constituent_list1555963842

    This will be a very important function in the campaign and need it to work smoothly. I am sure that I have done something incorrectly in the configuration.

    Also, is there a way to export a CSV template so that we can transform spreadsheets we already have and import them?

    Thanks,
    Jason

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Will Brownsberger

    (@will-brownsberger)

    You’ve given the column a long label: ‘Yes! Nathaniel’s campaign may use my name as an endorsement’

    The maximum column_name length in mysql is 64 characters. WP Issues CRM uses the label as a column name in exporting for clarity. It appends the slug ‘(custom_field_009)’ to the label, so you have about 40 characters to work with in the WP Issues CRM column label for a custom field.

    Just use a shorter column label and you’ll be fine.

    Not sure I understand the second question — maybe start a new thread on that.

    Thank you. That was an easy fix, and now that the CSV works, the second question is answered. 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Export function not working for me’ is closed to new replies.