Quote Originally Posted by scubasteve View Post
I am having two issues with getting the v_products_description_1 field to update.

1. It seems to load on a completely new product but when I try to update it does not change.
2. I also have issues with it truncating the field at random lengths. I have queries that search and replace all special characters with their HTML friendly equivalent which seemed to help in some instances. These are MEMO fields in Access 2007 and when I export I always go into the export spec file and make sure the field is set to MEMO and has a width of 8000 characters or so.

The text files look good and import the other fields like quantity and call the correct values. I'm currently working trying to update the Manufacturer: Charles Industries on my www.navigatorschoice.com site with is v1.5.0 but have the same problems with www.scubastevesmarine.com which is v1.5.1.

I have attached the file I'm importing currently. A link to one of the items is http://www.navigatorschoice.com/inde...oducts_id=1527, it updated successfully the quantity to zero and product is call to 1. But the description should have had some red text added to it which didn't update.

Any assistance with these issues is appreciated.
I've been thinking about this the last couple of days, but unfortunately haven't been at the right computer long enough to download and review your sample file.
I'm curious though about the lack of updating description 1 after originally uploading it.
What file type is/was used to originally insert it and then what filetype is/was used to try to update it? What type of modification was attempted? Was it just an attempt to add html color coding? (If so, I can't remember if there are tag filters in this plug-in and if there are whether those tags missing are the ones "needed/desired".

Unfortunately there is also an added complexity of all of the substitutions needed for the Access 2007 conversion.

A little more description/clarity is needed (ie. about where all of this "work" is occurring and tests done to possibly determine the cause of the random truncation. Anything consistent about the text file that is updated in relationship to the truncation point? Etc...)