WCMp bundle is available at a slashed price

Grab It Now

Export all submissions into Excel

Export all submissions into Excel2019-02-20T10:04:08-05:00

Home Support Forum WCMp Catalog Enquiry Export all submissions into Excel

WCMp Catalog Enquiry

Export all submissions into Excel Open

  • Author
    Posts
  • katie.dunn
    Participant
    Post count: 15

    Hi guys,

    How do I export the enquiry details submitted on the website into an Excel spreadsheet please?

    Thanks,
    Katie

  • NerdySupportExpert Moumita
    Keymaster
    Post count: 2562

    Hi @katie.dunn, nice to hear from you.

    In order to export the enquiries, goto WP-admin >> Tools >> Export and select “WC Catalog Enquiry Details”, like this screenshot – https://prnt.sc/mnrqn8

    Let us know if you have any further query.

  • katie.dunn
    Participant
    Post count: 15

    Hi,

    I have tried this, it is in an XML format, which isn’t very readable for my client.

    I would like it in an excel spreadsheet as mentioned above please?

    Regards
    Katie

  • NerdySupportExpert Moumita
    Keymaster
    Post count: 2562

    Hi @katie.dunn, as the export flow is WordPress’s feature, they by default creates this in xml format.

    However, you can use some plugin like this – https://wordpress.org/plugins/wp-all-export/

  • katie.dunn
    Participant
    Post count: 15

    I’ve tried this plugin, the custom fields are exported in XML, unreadable fields.

    Does your plugin not feature any kind of export? It seems a bit crazy your plugin doesn’t have an export function?

    Can you please tell me how I am supposed to successfully export the submissions as a CSV.

    Thanks
    Katie

  • katie.dunn
    Participant
    Post count: 15

    See attached screenshots.

    Attachments:
  • katie.dunn
    Participant
    Post count: 15

    Another screenshot.

    Attachments:
  • NerdySupportExpert Moumita
    Keymaster
    Post count: 2562

    Hi @katie.dunn, please make sure you have followed this flow to generate the csv- https://prnt.sc/mo4p85

    Becasue, we have generated the csv in .csv format, see the attached file.

  • katie.dunn
    Participant
    Post count: 15

    Hi,

    The CSV works, but all of the custom fields look like the attachment in this image:
    https://11fo813dsg4jqjl4374eoxz8-wpengine.netdna-ssl.com/wp-content/uploads/2019/02/export-2.jpg

    I need them to be readable, they currently are not.

    Thanks
    Katie

  • katie.dunn
    Participant
    Post count: 15

    See attached the unreadable csv file, field “_user_enquiry_fields”

    Thanks

  • NerdySupportExpert Moumita
    Keymaster
    Post count: 2562

    Hi @katie.dunn, it seems like this plugin doesn’t support _user_enquiry_fields fields. So, you need to do custom code and add this compatibility.

    So, kindly contact their plugin author on how you can add support of another field. Please note, you can fetch the enquiries from the product meta.

  • katie.dunn
    Participant
    Post count: 15

    Hi,

    Are you not able to do the custom code, after all, it’s your plugin that isn’t exporting properly?

    I need to be able to export the enquiry fields in a readable format, that was the whole point in us buying this plugin from you. please can you send me some code and tell me how I can actually get this working please?

    Thanks
    Katie

  • NerdySupportExpert Moumita
    Keymaster
    Post count: 2562

    Hi @katie.dunn, currently we only support WordPress’s default export format.

    However, we will add the .csv file support in our future version.

    I will keep you posted.

  • katie.dunn
    Participant
    Post count: 15

    How much money would it cost for you to develop this feature, as we need it?

  • NerdySupportExpert Moumita
    Keymaster
    Post count: 2562

    Hi @katie.dunn, our service team handles the customization related query.

    Kindly get in touch with them via – https://wc-marketplace.com/custom-development/

  • katie.dunn
    Participant
    Post count: 15

    Hi Nerdy,

    Looking at your data output, it is what is called Serialized PHP, or a straight dump from the SQL database using var_dump(serialize($obj)

    so the output is a mixture of XML from WordPress and SerPHP from your form, so a program capalbe of reading XML such as Excel can’t because it treats the SerPHP field as text. If you change the format of your output to XML then the standard WP output will work.

    You need to add a few lines of code to your process to convert the Serialized PHP into XML so that the standard WP XML output will process it correctly.

    see here for help: https://www.unserialize.com

    Thanks
    Marcus

  • NerdySupportExpert Moumita
    Keymaster
    Post count: 2562

    Hi @katie.dunn, we will add a fix in our next update of Catalog plugin.

    I will keep you posted.

  • katie.dunn
    Participant
    Post count: 15

    Hi,

    When is your next update please?

    Thanks

  • Tech Tycoon Debleena
    Keymaster
    Post count: 455

    Hi @katie.dunn, after hearing from you, we have looked into this further.

    WordPress by default supports any post type to be exported as XML and our enquiry is also a post type. Now, the meta fields are saved in serialized format. That is why, when you will export the enquiry details via WordPress tool, it will generate the xml in serialized format.

    You can also check product/other post from WordPress export, it also adds serialized format.

    So, the solution will be to use the export plugin and ask them how you can make another post type compatible with this plugin i.e. whether they have any such filter for this.

    Alternatively, you have to create a custom flow to generate this csv.

    Let us know if you have any further query.

Please LOGIN to reply to this topic