Unable to import properly quoted fields with comma

  • Resolved MyAllForChrist

    (@myallforchrist)


    3 years, 8 months ago

    I have a CSV file generated from another program. Note how the last row of data contains commas in the name.

    
"name","slug"
"Ask in Faith","ask-faith"
"Ask, Seek, and Knock","ask-seek-and-knock"

    When I attempt to import this record, it breaks it into multiple terms. The industry-standard way for programs to deal with this type of situation is to use quoted text in the CSV encasing the value. Any commas inside the quotes are considered part of the value and not treated as delimiters.

    Question 1 – Why is the plugin not reading the quoted text as a single value? It seems like this would be the proper way to resolve this issue.

    Question 2 – If the plugin does not handle quoted values in the CSV, and I was to use an alternate delimiter, such as a Unicode character, how can I tell the plugin to split the values based on the custom delimiter? I didn’t see anything in the documentation or options that would let me specify a delimiter.

    Thanks!

    – Adam

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor Smackcoders Support

    (@smacksupport)

    Hi,

    Hope my technical support team has helped you in resolving the issue through email support.

    I am resolving this support thread for now. You can create new support thread anytime for more help.

    Thanks.

    Yes, support did patch the plugin to resolve this issue! (Fixing a bug in the “wp-ultimate-csv-importer-pro/importExtensions/TaxonomiesImport.php” file). Are you planning to role out the patched version of the plugin to everyone soon?

    Plugin Contributor Smackcoders Support

    (@smacksupport)

    Hi,

    This is the free plugin support forum. To get more details about the future upgrades for the pro plugin, kindly contact our support team with your order ID. Our technical team will help you.

    Thanks.

    HW

    (@hannahmwool)

    Hi,

    Same issue here. Can you share the patch. I’m currently working with support on another issue.

    Thanks!

    HW

    (@hannahmwool)

    I actually solved this myself by changing the explode character from a comma to a straight line and used the straight line to separate out multiple categories assigned to a post since some of my categories have a comma in their name which was breaking the import. Adjusted in “wp-ultimate-csv-importer-pro/importExtensions/TermsandTaxonomiesImport.php” file starting line 280:

    if (strpos($cat_value, '|') !== false) {
     $get_category_list = explode('|', $cat_value);
} else {
     $get_category_list[] = $cat_value;
}
    • This reply was modified 3 years, 7 months ago by HW.
    Thread Starter MyAllForChrist

    (@myallforchrist)

    @hannahmwool – You are on the right track there! I am not sure what I am technically allowed to share, but I am not sure why you would ever want to explode a
    category value     on a comma…

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Unable to import properly quoted fields with comma’ is closed to new replies.