CSV to DB adding "" character when importing

[JeffreyL]

Hello,

Below is text/code I have in the Product Description field I use when importing data from .csv into eStore.

By: Jeff Staniforth and Dr. Jay Polmar

Edition: MP3 Audio (Instant download)

Samples affirmations:

• All my efforts are focused toward my goals
• I now carefully choose what to focus my mind on
• Every day, my concentration builds
• My thoughts are clear and focused
• I manifest what I focus on
• It’s now easy to focus on what I desire

Sample[wp_eStore_audio_player src =”http://www.affirmationsforthemind.com/Affirmations_sam175/175smpaff/BusinessStrategy/AmazingConcentration_sample.mp3″%5D

Running Time:18 affirmations repeated for 30 minutes

[wp_lightbox_special_anchor_text_pdf link=”http://www.affirmationsforthemind.com/Assets/index.html” width=”640″ height=”750″ title=”Affirmations to Transform Your Thinking & Manifest Change” text=”More Info”]

**** After importing into eStore the Product Description field has the character throughout (11 of them) around the URL’s, text links and some of the LightBox attributes… Whis is causing errors throughout.

By: Jeff Staniforth and Dr. Jay Polmar
Edition: MP3 Audio (Instant download)

Samples affirmations:

• All my efforts are focused toward my goals
• I now carefully choose what to focus my mind on
• Every day, my concentration builds
• My thoughts are clear and focused
• I manifest what I focus on
• It?s now easy to focus on what I desire

Sample[wp_eStore_audio_player src “http://www.affirmationsforthemind.com/Affirmations_sam175/175smpaff/BusinessStrategy/AmazingConcentration_sample.mp3”%5DRunning Time:18 affirmations repeated for 30 minutes
[wp_lightbox_special_anchor_text_pdf link=”http://www.affirmationsforthemind.com/Assets/index.html” width=”640″ height=”750″ title=”Affirmations to Transform Your Thinking & Manifest Change” text=”More Info”]

What is happening?

Any help would be most appreciated.

Regards

Jeff

[admin]

This field has complex data so using the CSV to DB plugin is not the best option. All it takes is one mistake (one unescaped special character and its going to be a mess).

This this option:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[JeffreyL]

Hi,

Yes, I think I am best using PhpMyAdmin for greater flexibility.

FYI, I did work it out. I should not have enclosed any values with the ” character. Your csv to DB plugin see’s those ” character and prefixes them with a character. So I just remove all instances of ” and work fine.

Thanks for your time.

Regards

Jeff

[Author]

Posts