Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

[Resolved] Bulk Import doesn’t like commas in fields

by

Tips and Tricks HQ Support Portal › Forums › WP eMember › Bulk Import doesn’t like commas in fields

Tagged: bulk import, Commas not supported

  • This topic has 1 reply, 2 voices, and was last updated 4 years ago by wzp.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • May 2, 2021 at 7:05 pm #82981
    parks
    Spectator

    Just an FYI in case you are not aware of this. I found the bulk import was not importing “random” records even though the message after the import said that all records had been imported successfully. It took me a while to figure out that I had some address fields that included a comma (e.g., 123 Main St., Apt #100). Any record with a comma in the address did not import into the database.

    Once I figured this out, I removed the commas and the records imported just fine. This “feature” drove me nuts for some time before I discovered what was happening.

    It would be helpful if the software either accepted the commas, or produced an error message for records with commas. If I didn’t double check the count of records imported vs. what I expected, I would have never noticed that some records did not import. The import message left me to believe that it worked fine.

    Other than this, the import works great!

    Regards,
    Terri

    May 2, 2021 at 7:48 pm #82983
    wzp
    Moderator

    It would be helpful if the software either accepted the commas, or produced an error message for records with commas. If I didn’t double check the count of records imported vs. what I expected, I would have never noticed that some records did not import.

    CSV = Comma Separated Values. We have no control over the limitations inherent to the CSV standard.

    • This reply was modified 4 years ago by wzp.
    • This reply was modified 4 years ago by wzp.
  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2025 | Tips and Tricks HQ