Title: Export function not working for me
Last modified: April 22, 2019

---

# Export function not working for me

 *  Resolved [earrame](https://wordpress.org/support/users/earrame/)
 * (@earrame)
 * [7 years, 1 month ago](https://wordpress.org/support/topic/export-function-not-working-for-me/)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fexport-function-not-working-for-me%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Will Brownsberger](https://wordpress.org/support/users/will-brownsberger/)
 * (@will-brownsberger)
 * [7 years, 1 month ago](https://wordpress.org/support/topic/export-function-not-working-for-me/#post-11455616)
 * 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.
    -  This reply was modified 7 years, 1 month ago by [Will Brownsberger](https://wordpress.org/support/users/will-brownsberger/).
 *  Thread Starter [earrame](https://wordpress.org/support/users/earrame/)
 * (@earrame)
 * [7 years, 1 month ago](https://wordpress.org/support/topic/export-function-not-working-for-me/#post-11456156)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-issues-crm_5a5d59.svg)
 * [WP Issues CRM](https://wordpress.org/plugins/wp-issues-crm/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-issues-crm/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-issues-crm/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-issues-crm/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-issues-crm/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-issues-crm/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [earrame](https://wordpress.org/support/users/earrame/)
 * Last activity: [7 years, 1 month ago](https://wordpress.org/support/topic/export-function-not-working-for-me/#post-11456156)
 * Status: resolved