EasyPopulate - a gotcha

[mouflon]

Fabulous contribution, I'm using it to upload a database of over 10,000 items. Works a charm, until it finds a "" backslach character as the final character of a field. Here's a sample result:

 

2003-01-01 | 1 | 2.31 | 1 | 2.11 | 2 | | SPRUCE RAN | LUMBER | | | | | | Taxable Go | Active Updated

DateAvail was --2003-01-01 15:42:53--DateAdded was --2003-01-01 15:42:53-- | 2410 | no_picture | 2X4X10 SPR | | 2.83 | 1 | 2003-01-01 | 2003-01-01 | 1 | 2.69 | 1 | 2.60 | 2 | | SPRUCE RAN | LUMBER | | | | | | Taxable Go | Active Updated

1064 - You have an error in your SQL syntax near '')' at line 9

 

INSERT INTO products_description (products_id, language_id, products_name, products_description) VALUES ( '9', 1, '2X4X10 SPRUCE 2&BTR. KILN DRI', ' ')

 

[TEP STOP]

 

Just thought I'd point out something to look out for -- took me a few minutes, then I slapped myself on the forehead (it's getting pretty flat these days) - it's escaping the quote character. I now have my translation software stripping off any trailing backslashes.

 

One typo in one product - whoda thunkit?

[mouflon]

Here's anohter one to look out for. Trailing quotes, as in:

3/4 20GA. PICKET STIFFENER 32"

 

In this case it stripped the 3/ and the trailing quote. My solution was to pad the end of the field with a single space before the TAB.

 

cheers...

[wasson65]

Here's anohter one to look out for. Trailing quotes, as in:

3/4 20GA. PICKET STIFFENER 32"

 

In this case it stripped the 3/ and the trailing quote. My solution was to pad the end of the field with a single space before the TAB.

 

cheers...

 

I'll add this gotcha to the docs.

 

This is a tougher nut to crack, because of the unintentional consequences you've discovered, plus the more it tries to be smart, the more ways it can get tripped up!

 

Tim

[loxly]

:lol: I've been going through all my product descriptions and changing " to inches and fractions to 1-2 instead of 1/2. And stripping apostrophes completely.

 

It isn't grammatically correct, but it uploads!

 

Debbie