Using ProductCart - Data Base name and firstname ending #160

Print Page | Close Window

Data Base name and firstname ending #160

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=899
Printed Date: 22-November-2024 at 5:19pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Data Base name and firstname ending #160

Posted By: JackQB
Subject: Data Base name and firstname ending #160
Date Posted: 20-June-2007 at 6:39pm

I notice that a lot (most) of the customer fields (name and firstname) end with an ascii 160. (535 out of 600) that I checked. I believe that ascii 160 is the extented character a with an accent on top of some sort. I could understand a few whose names with with the accented a but not 5 out of 6.

Does anyone know why this is there or how to remove them?

This may be a non-breaking space character and may have appeared after a move from 1 host provider to another.

-------------
Jack
www.AaaTeX.com QuickBooks Add-ons

Replies:

Posted By: ProductCart
Date Posted: 24-June-2007 at 7:26pm

Did you try exporting the customer list and then reimporting via the Customer Import Wizard?

- Export name, last name, email
- Review
- Reimport to update the current records: ProductCart uses the email field to match existing customer records

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: JackQB
Date Posted: 24-June-2007 at 7:32pm

No, this was when using our QuickBooks Shopping Cart Integrator for a customer. I will mention that to the customer. We put in code to remove the chr(160) but why was it there?

-------------
Jack
www.AaaTeX.com QuickBooks Add-ons