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

wp csv to db truncating description on download

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Addon Related › wp csv to db truncating description on download

Tagged: csv to db

  • This topic has 6 replies, 3 voices, and was last updated 10 years, 6 months ago by dwbone.
Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • November 3, 2014 at 12:46 am #11723
    dwbone
    Member

    as title says.. I found that WP CSV to DB 2.0 is truncating the descriptions of my products. It has happen a couple times now.

    When I export the table via myPHP the descriptions are not truncated.

    our descriptions do contain nested divs and short code situations…. perhaps there is a character that breaks the data in csv to db?

    Although come to think of it, it truncates descriptions that only contain text too.

    November 3, 2014 at 1:48 am #66529
    admin
    Keymaster

    How many characters (roughly) are we talking about for the description? I am just thinking that there maybe a limit on that.

    November 3, 2014 at 4:36 am #66530
    dwbone
    Member

    actually the amount of text that is retained varies sometimes a few words sometimes most of a sentence up to two lines.

    ah, taking a closer look, comparing the successful version to to the csv to db version, it appears that the first comma in the description is where the truncating occurs.

    November 3, 2014 at 11:52 am #66531
    wzp
    Moderator

    ah, taking a closer look, comparing the successful version to to the csv to db version, it appears that the first comma in the description is where the truncating occurs.

    CSV = Comma-separated values

    Try replacing the commas with —> & # 4 4 ; <— (ampersand pound four four semicolon) instead.

    November 3, 2014 at 6:15 pm #66532
    dwbone
    Member

    yep, not very “intuitive” for client though, who will write descriptions and have to use the code in place of commas in the writing. I’ll just use myPHP from now on for bulk work.

    thanks.

    November 3, 2014 at 10:27 pm #66533
    wzp
    Moderator

    Try the code anyway, to see if that fixes the problem. If it works, then it means the addon needs to sanitize the data some more.

    November 4, 2014 at 1:57 am #66534
    dwbone
    Member

    will do soon

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 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