Support » Plugin: Business Directory Plugin » Can't Export CSV file

  • Resolved MattMcKenzie

    (@mattmckenzie)


    Hello hope you can help.

    I recently added your plugin and everything seems to be working fine except for the export. When I hit the export button nothing happens with no errors.

    I have added listings through front-end, back-end, and with import tool with no issues. I added all the categories that I will be using and the output on the website looks good and is functioning.

    The link to the website is http://64.86.220.169/~concept1/enterprisecbs.ca/business-directory/ and this is the page of the business directory. I added links to the BD info, the environment info, as well as a screenshot of my export settings.

    I am hoping I can get this resolved without asking the client to go into phpMyadmin to spit out the data using a sql script. The sooner you could get back to me on this the better. If you need any more info please let me know.

    Matt

    https://wordpress.org/plugins/business-directory-plugin/

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author businessdirectoryplugin

    (@businessdirectoryplugin)

    Hi Matt,

    Can we get a bit more information from you first?
    – Version of BD?
    – Version of WP?
    – Version of PHP?
    – What are your exact export settings? (Screenshot would be best here, use http://imageshack.us if needed)
    – How many listings do you have?
    – Are your images also part of the export? Are they large?
    – Are you on shared, dedicated or VPS hosting?

    Issue Not Resolved

    Even me, i cant export the csv..

    we get a warning after the post(after clicking Export csv)
    the warnign is pasted below:

    Warning: filesize() [function.filesize]: stat failed for /var/sites/t/mysite.co.uk/public_html/wp-content/blogs.dir/2/files/wpbdp-csv-exports/5306f4fb1ba32/export.csv in /var/sites/t/mysite.co.uk/public_html/wp-content/plugins/business-directory-plugin/admin/csv-export.php on line 186
    {“error”:””,”state”:”YTo3OntzOjg6InNldHRpbmdzIjthOjk6e3M6MTg6ImNzdi1maWxlLXNlcGFyYXRvciI7czoxOiIsIjtzOjE2OiJpbWFnZXMtc2VwYXJhdG9yIjtzOjE6IjsiO3M6MTg6ImNhdGVnb3J5LXNlcGFyYXRvciI7czoxOiI7IjtzOjExOiJ0ZXN0LWltcG9ydCI7YjowO3M6MTM6ImV4cG9ydC1pbWFnZXMiO2I6MDtzOjEzOiJpbmNsdWRlLXVzZXJzIjtzOjE6IjEiO3M6MTQ6Imxpc3Rpbmdfc3RhdHVzIjtzOjM6ImFsbCI7czoyMToiaW5jbHVkZS1zdGlja3ktc3RhdHVzIjtzOjE6IjEiO3M6MjM6ImluY2x1ZGUtZXhwaXJhdGlvbi1kYXRlIjtzOjE6IjEiO31zOjc6ImNvbHVtbnMiO2E6MTE6e2k6MDtzOjEzOiJidXNpbmVzcy1uYW1lIjtpOjE7czoxNDoiYnVzaW5lc3MtZ2VucmUiO2k6MjtzOjI2OiJzaG9ydC1idXNpbmVzcy1kZXNjcmlwdGlvbiI7aTozO3M6MjU6ImxvbmctYnVzaW5lc3MtZGVzY3JpcHRpb24iO2k6NDtzOjQzOiJidXNpbmVzcy13ZWJzaXRlLWFkZHJlc3MtKHN0YXJ0aW5nLWh0dHA6LS0pIjtpOjU7czoyMToiYnVzaW5lc3MtcGhvbmUtbnVtYmVyIjtpOjY7czoxMzoiZmFjZWJvb2stbGluayI7aTo3O3M6MjI6ImJ1c2luZXNzLWNvbnRhY3QtZW1haWwiO2k6ODtzOjg6InVzZXJuYW1lIjtpOjk7czoxNDoiZmVhdHVyZWRfbGV2ZWwiO2k6MTA7czoxMDoiZXhwaXJlc19vbiI7fXM6MTA6IndvcmtpbmdkaXIiO3M6MTExOiIvdmFyL3NpdGVzL3QvdGhlZmFtaWx5Z3JhcGV2aW5lLmNvLnVrL3B1YmxpY19odG1sL3dwLWNvbnRlbnQvYmxvZ3MuZGlyLzIvZmlsZXMvd3BiZHAtY3N2LWV4cG9ydHMvNTMwNmY0ZmIxYmEzMi8iO3M6ODoibGlzdGluZ3MiO2E6NjY6e2k6MDtzOjQ6IjM3NDEiO2k6MTtzOjM6Ijc1MSI7aToyO3M6NDoiMzc1NSI7aTozO3M6NDoiMzc1NCI7aTo0O3M6NDoiMzc0MCI7aTo1O3M6NDoiMzY5MCI7aTo2O3M6NDoiMzY4MiI7aTo3O3M6NDoiMzY4MCI7aTo4O3M6NDoiMzY0OSI7aTo5O3M6NDoiMzQ2MyI7aToxMDtzOjQ6IjMzNzciO2k6MTE7czo0OiIzMzYyIjtpOjEyO3M6NDoiMzM2MSI7aToxMztzOjQ6IjMzMjgiO2k6MTQ7czo0OiIyOTA5IjtpOjE1O3M6NDoiMTIxMyI7aToxNjtzOjM6Ijc5NSI7aToxNztzOjQ6IjI4NTUiO2k6MTg7czo0OiIyNjk4IjtpOjE5O3M6NDoiMjY2NyI7aToyMDtzOjQ6IjI1NDkiO2k6MjE7czo0OiIyNDkxIjtpOjIyO3M6MzoiNTk5IjtpOjIzO3M6NDoiMjM0MCI7aToyNDtzOjM6Ijc1NSI7aToyNTtzOjQ6IjIwNDIiO2k6MjY7czo0OiIyMDcyIjtpOjI3O3M6NDoiMjA1MCI7aToyODtzOjQ6IjIwNDMiO2k6Mjk7czo0OiIyMDQxIjtpOjMwO3M6NDoiMjAzOSI7aTozMTtzOjQ6IjIwMzciO2k6MzI7czo0OiIyMDI2IjtpOjMzO3M6NDoiMjAyNSI7aTozNDtzOjQ6IjE4NDAiO2k6MzU7czo0OiIxODIyIjtpOjM2O3M6NDoiMTgyMSI7aTozNztzOjQ6IjE4MTIiO2k6Mzg7czo0OiIxMTYzIjtpOjM5O3M6NDoiMTc4MCI7aTo0MDtzOjQ6IjE3MjUiO2k6NDE7czo0OiIxNzI0IjtpOjQyO3M6NDoiMTY1OCI7aTo0MztzOjQ6IjE0NDYiO2k6NDQ7czo0OiIxNDQ1IjtpOjQ1O3M6NDoiMTMzMSI7aTo0NjtzOjQ6IjEzMzAiO2k6NDc7czo0OiIxMzI5IjtpOjQ4O3M6NDoiMTIxNyI7aTo0OTtzOjQ6IjEyMTAiO2k6NTA7czo0OiIxMjE0IjtpOjUxO3M6NDoiMTIxMiI7aTo1MjtzOjQ6IjEyMDgiO2k6NTM7czo0OiIxMjAxIjtpOjU0O3M6NDoiMTE4OSI7aTo1NTtzOjQ6IjExNTkiO2k6NTY7czo0OiIxMTQwIjtpOjU3O3M6NDoiMTEzNSI7aTo1ODtzOjQ6IjExMzIiO2k6NTk7czozOiI3ODIiO2k6NjA7czozOiI3ODQiO2k6NjE7czozOiI3NjEiO2k6NjI7czozOiI3NTgiO2k6NjM7czozOiI3NTAiO2k6NjQ7czozOiI3NDUiO2k6NjU7czozOiI2MTEiO31zOjg6ImV4cG9ydGVkIjtpOjA7czo4OiJmaWxlc2l6ZSI7YjowO3M6NDoiZG9uZSI7YjowO30=”,”count”:66,”exported”:0,”filesize”:false,”isDone”:false,”fileurl”:””,”filename”:””}

    I re-added the links to with plug-in. I gave the clients developer the sql code you have posted in your support form and hope that it works. I would still like to get the plug-in working as it is supposed to.

    Plugin Author businessdirectoryplugin

    (@businessdirectoryplugin)

    Hi Matt,

    The “resolved” marker is just something I use to determine whether the issue is responded to or not. Sometimes people never reply back, so it’s just a housekeeping thing. I will always respond if you do.

    I still need the information to proceed further. Can you please provide that?

    Plugin Author businessdirectoryplugin

    (@businessdirectoryplugin)

    @manoj: That error indicates a file permission issue. You should contact your hosting provider and ask if they restrict the file permissions for your web server user in the uploads directory for WP.

    Version of BD?
    A) Version 3.3

    – Version of WP?
    A) Version 3.8.1

    – Version of PHP?
    A) Version 5.3.27

    – What are your exact export settings? (Screenshot would be best here, use http://imageshack.us if needed)
    A) I added links to the webpage of the url I sent before that had all the bd database, environment, and export settings earlier. The links are right above the business directory on that page.

    Either way the settings are:
    Which Listings to export? – All
    Export images? – No
    Author Info – No
    Sticky/feature status – No
    Listing expiration date – No
    column Seperator – ,
    Image Seperator – ;
    Category Seperator – ;

    – How many listings do you have?
    A) I have 9 listings in there at the moment. They are just test listings so not important.

    – Are your images also part of the export? Are they large?
    A) I have export images turned off at the moment.

    – Are you on shared, dedicated or VPS hosting?
    A) Shared I think but to be honest it is on the clients dev server. And for whatever reason I can’t log into thier cPanel today.

    link to BD info – http://64.86.220.169/~concept1/enterprisecbs.ca/?p=4841
    link to Environment – http://64.86.220.169/~concept1/enterprisecbs.ca/?p=4839
    link to Export Info – http://64.86.220.169/~concept1/enterprisecbs.ca/?p=4840

    P.S. with the export info i tried exporting with all settings on as well as off.

    Plugin Author businessdirectoryplugin

    (@businessdirectoryplugin)

    Hi Matt,

    Can you provide me admin credentials to get into the site and test that export directly? Send them here: http://businessdirectoryplugin.com/contact/

    Please include a link to this forum post for context–I get a lot of email. 🙂

    Did this get resolved? Was it an easy fix? My site was having the same issues.

    Plugin Author businessdirectoryplugin

    (@businessdirectoryplugin)

    Yes, we have a patch available–contact me to get it: http://businessdirectoryplugin.com/contact/

    Include a link to this forum thread for context.

    okay just sent you a contact message!

    Plugin Author businessdirectoryplugin

    (@businessdirectoryplugin)

    Patch sent. Anyone else who needs the patch, contact me here: http://businessdirectoryplugin.com/contact/

    We’ll have it out in 3.4 for sure.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Can't Export CSV file’ is closed to new replies.