WordPress.org

Ready to get started?Download WordPress

Forums

Business Directory Plugin
[resolved] CSV import (8 posts)

  1. MattFord
    Member
    Posted 1 year ago #

    I have tried a number of times to upload my CSV file into the directory - it has about 500 rows. It is cutting off the 'long description' on some of the imports but not on others. Is there anyway to sort this?

    http://wordpress.org/extend/plugins/business-directory-plugin/

  2. businessdirectoryplugin
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Matt,

    Sorry that you're running into issues here. We need to gather a bit more information first.

    - What version of BD are you running?
    - What version of WP?
    - Can you provide a sample CSV with no more than 3 rows, that shows this problem?

    Is there some pattern to the break? I'm guessing that your description fields MAY be including commas in them, which is considered a breaking character for a CSV file. Try putting that description field enclosed in quotes to allow the full import of that field.

  3. MattFord
    Member
    Posted 1 year ago #

    Hi,

    Still having issues after putting quotations around the description. Doesn't seem to cut at the commas just random points.

    I am using BD version - 3.0.2 - and WP version - 3.5.1

    Where would you like me to upload the CSV file to?

    I've attached a link to the site so you can see how the descriptions are cutting off when you click one of the results.

    http://perfectnortheastwedding.co.uk/business-directory/wpbdm-category/bands/

  4. businessdirectoryplugin
    Member
    Plugin Author

    Posted 1 year ago #

    Is it cutting fields at a comma? Is that where the break happens? (Just to be clear)

    I would suggest putting the simple 3-row CSV file on your site and linking to it here. That would be easiest, I think.

  5. MattFord
    Member
    Posted 1 year ago #

    No its not cutting where commas are present its cutting at random times in a sentence.

    I have upload a 3 row CSV file here
    http://perfectnortheastwedding.co.uk/business-directory/bands3-2/

    With the results of this here:
    http://perfectnortheastwedding.co.uk/business-directory/wpbdm-category/bands/

    So that you can compare what it should be and what it actually is.

    Thanks for the help

  6. businessdirectoryplugin
    Member
    Plugin Author

    Posted 1 year ago #

    OK, looking at the file directly, have you tried eliminating the embedded quotes (e.g. 'THE' becomes THE, etc)? Since you reuse embedded quotes in multiple places, it may prematurely terminate the description field.

    That may fix things for you.

  7. MattFord
    Member
    Posted 1 year ago #

    Hi,

    I have tried that been through and removed any quotes from the text still making no different, seems to be randomly cutting off at certain points.

    Any other ideas?

  8. businessdirectoryplugin
    Member
    Plugin Author

    Posted 1 year ago #

    What is the source of your data? Are you just hand-entering these fields or scraping it from somewhere? Or is something else generating them?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.