Title: Erro exporting xml file
Last modified: August 31, 2016

---

# Erro exporting xml file

 *  Resolved [SrGato29](https://wordpress.org/support/users/jonadeis/)
 * (@jonadeis)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/)
 * Hi there,
 * I have a problem,when I download my xlsx file is everything ok but when I open
   it, it says **“Excel cannot open open the file because the file format or file
   extension is not valid.Verify that the file has not been corrupted and that the
   file extension matches the format of the file”**
 * Secondly, I have the “Edit data mode” extension and when I edit some texts and
   I press my keyboard enter, the code creates 
    tags, so… Is possible to remove
   these tags?
 * Finally, is possible to hide some buttons like “Delete Column” or “Add Column”,
   for some users with some role?
 * my php version is 5.4.43
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

Viewing 15 replies - 1 through 15 (of 28 total)

1 [2](https://wordpress.org/support/topic/erro-exporting-xml-file/page/2/?output_format=md)
[→](https://wordpress.org/support/topic/erro-exporting-xml-file/page/2/?output_format=md)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7223909)
 * What I think is happening here is that another plugin or theme is generated errors
   or debug output and that is getting injected at the beginning of the export file(
   making it invalid) and injecting HTML text in edit mode (when it re-fetches the
   value from the database).
 * If you actually look at that HTML generated in edit mode, it may give you a clue
   as to the culprit. You could also do a CSV export then look at the file in a 
   text editor to see if text is injected at the beginning.
 * You may be running your site in debug mode. If you turn that off the problem 
   may disappear.
 * The “Delete Column” & “Add Column” buttons cannot currently be configured to 
   only appear for certain roles.
 *  Thread Starter [SrGato29](https://wordpress.org/support/users/jonadeis/)
 * (@jonadeis)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224045)
 * SO, you are saying that my first and second problem are because of another plugin?
 * And for the third one, maybe I can do a custom function, but in what file I can
   find those buttons?
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224050)
 * That is my suspicion. I think the 1st and 2nd issues have the same cause which
   is something else generating debug output.
 * Be sure you have the latest CFDB.
 * You would have to directly edit CFDB Edit plugin code to change the behavior.
   There is no way to write a custom function to do it.
 *  Thread Starter [SrGato29](https://wordpress.org/support/users/jonadeis/)
 * (@jonadeis)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224145)
 * So, I disabled all my plugins and the excel file was correct but Im still having
   problems with “the edit mode”
 *  I wrote Test , then I pressed the key intro and the result is the following 
   line
    `<br>test<br>test<br>`
 * then If I enter to the cell and then get out without modify anything the result
   is the next one
    `<br><br>test<br>test<br>`
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224148)
 * OK, I think there is a bug.
 * Would you email me at [info@cfdbplugin.com](https://wordpress.org/support/topic/erro-exporting-xml-file/info@cfdbplugin.com?output_format=md)?
   I want to send you an bug fix version to try.
 *  Thread Starter [SrGato29](https://wordpress.org/support/users/jonadeis/)
 * (@jonadeis)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224149)
 * I sent you an email
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224150)
 * I sent you a reply with an updated version. Check your spam folder if you don’t
   see it.
 *  Thread Starter [SrGato29](https://wordpress.org/support/users/jonadeis/)
 * (@jonadeis)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224154)
 * Ok it worked, Thanks a lot, this upgrade will be available in the next version??
   and how can I download the next versions of the plugin?
 *  Thread Starter [SrGato29](https://wordpress.org/support/users/jonadeis/)
 * (@jonadeis)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224155)
 * Other thing, you said that in a future upgrade, it will be possible to hide some
   default fields like Submitted Login, How can I do that? and How can I change 
   the label for the cell “Submitted” or “Submitted From”, because with the editor
   mode I can’t , If I change it , in the next submission it creates another column
   with the default label, so , What can I do to make that possible?
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224156)
 * Yes, I’ll put out a new version which will be the same as what you have now. 
   Latest versions can be downloaded at [http://cfdbplugin.com/?page_id=939](http://cfdbplugin.com/?page_id=939)
 * You won’t be able to change the “Submitted” and “Submitted From” labels or hide
   them on the administration page.
 * You can create your own private page with a shortcode like:
    [cfdb-datatable 
   edit=”true” form=”your-form-name” hide=”Submitted,Submitted From”]
 * That would give you an editable table w/o some of the fields. You could also 
   use “headers” to rename those column headers to something else.
 *  Thread Starter [SrGato29](https://wordpress.org/support/users/jonadeis/)
 * (@jonadeis)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224157)
 * ok thanks, I activated and desactivated all my plugins one by one to detect the
   error with the xlsx exportation and the plugin that is making conflict is this
   [https://es.wordpress.org/plugins/wp-editor/](https://es.wordpress.org/plugins/wp-editor/),
   I activated the debug mode but I did not get any results,so could you help me?
   please
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224158)
 * I mean to say to de-activate debug mode to avoid any misc debug output.
 * I doubt I can do anything about it. I can’t stop another plugin from creating
   output. I suggest: open a download file with a text editor. I bet there is a 
   blank line at the top (although it could be other text). I would take that and
   complain on the wp-editor forum.
 *  Thread Starter [SrGato29](https://wordpress.org/support/users/jonadeis/)
 * (@jonadeis)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224159)
 * Yes , The first line of the excel file is in blank
 *  Thread Starter [SrGato29](https://wordpress.org/support/users/jonadeis/)
 * (@jonadeis)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224162)
 * I’m using this function to hide some buttons
 *     ```
       function my_custom_style() {
         echo '<style>
           #addColumnButton {
             display:none !important
           }
         </style>';
       }
       add_action('admin_head', 'my_custom_style');
       ```
   
 * But some of these buttons don’t have an ID , so could you add an ID to your buttons
   in the next upgrade? please
 *  Thread Starter [SrGato29](https://wordpress.org/support/users/jonadeis/)
 * (@jonadeis)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/#post-7224163)
 * Sorry this is the function
 *     ```
       function my_custom_style() {
   
         if (current_user_can('administrativos')) {
         echo '<style>
           #addColumnButton {
             display:none !important
           }
         </style>';
   
           }
       }
       add_action('admin_head', 'my_custom_style');
       ```
   

Viewing 15 replies - 1 through 15 (of 28 total)

1 [2](https://wordpress.org/support/topic/erro-exporting-xml-file/page/2/?output_format=md)
[→](https://wordpress.org/support/topic/erro-exporting-xml-file/page/2/?output_format=md)

The topic ‘Erro exporting xml file’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

## Tags

 * [Hide buttons](https://wordpress.org/support/topic-tag/hide-buttons/)

 * 28 replies
 * 2 participants
 * Last reply from: [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/erro-exporting-xml-file/page/2/#post-7224197)
 * Status: resolved