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?

    MattMcKenzie

    (@mattmckenzie)

    Issue Not Resolved

    Manoj Trivand

    (@manoj-trivand)

    Even me, i cant export the csv..

    Manoj Trivand

    (@manoj-trivand)

    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”:””}

    MattMcKenzie

    (@mattmckenzie)

    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.

    MattMcKenzie

    (@mattmckenzie)

    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. 🙂

    mjschmidt

    (@mjschmidt)

    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.

    mjschmidt

    (@mjschmidt)

    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.