[ic] Import / Export in Excel carriage returns
Andreas, Scott
Scott.Andreas@learningco.com
Fri, 9 Mar 2001 09:09:52 -0800
First question is what version of Ic are you using and second did you
declare in your products database that you are using Excel. You should have:
Database products EXCEL 1
listed in your catalog.cfg file.
-----Original Message-----
From: interchange-users-admin@lists.akopia.com
[mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Alex Lam
Sent: Thursday, March 08, 2001 5:20 PM
To: interchange-users@lists.akopia.com
Subject: [ic] Import / Export in Excel carriage returns
Hi folks...
Have you guys encountered problems after importing / exporting data in
Excel where the end of line characters are taken into the SQL database
and muck up your values ?
For instance, I entered some products thru the web interface into
category abc and when I entered a whole bunch more in Excel, they
appeared as abc^M or abc\r
So, when the category in the left nav bar is clicked I'd get
--------------
| abc |
------------------------------
| products |
------------------------------
--------------
| abc |
------------------------------
| products |
------------------------------
It's because the search sees abc and abc\r as two diff values. I know
I can do a complex search, but that is not getting to the root of the
problem. Any gurus with advice?
Thanks.
Alex Lam
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users