MvIMPORT text with Newlines?

Hi folks -- hope somebody knows the answer to this one:

Suppose I need to MvIMPORT a text file, using a character such as pipe
("|") for the delimiter, but some of the fields contain Newline
characters. Will that work -- I mean, will Miva consider the Newlines to
be part of the fields? Or will the Newlines always force the end of a
record, resulting in a lot of too-short records and empty fields?

Thanks --

Kent Multer | /| P.O.Box 701895, Dallas TX 75370
Magic Metal Productions | / | (214) 570 8264 voice/fax
| | [email protected]
* Web developer/designer http://TheMagicM.com
* E-commerce and Miva
* Author, The Official Miva Web Scripting Book -- available on-line:
<A HREF ="http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA">http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA</A>

MvIMPORT text with Newlines?



Hi,

From my experience new lines always force the end of th record.

Best regards,
Claudiu

-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of Kent
Sent: samedi 30 octobre 2004 08:14
To: Miva Merchant coders list
Subject: [mrc] MvIMPORT text with Newlines?


Hi folks -- hope somebody knows the answer to this one:

Suppose I need to MvIMPORT a text file, using a character such as pipe
("|") for the delimiter, but some of the fields contain Newline
characters. Will that work -- I mean, will Miva consider the Newlines to
be part of the fields? Or will the Newlines always force the end of a
record, resulting in a lot of too-short records and empty fields?

Thanks --

Kent Multer | /| P.O.Box 701895, Dallas TX 75370
Magic Metal Productions | / | (214) 570 8264 voice/fax
| | [email protected]
* Web developer/designer http://TheMagicM.com
* E-commerce and Miva
* Author, The Official Miva Web Scripting Book -- available on-line:
<A HREF ="http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA">http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA</A>

MvIMPORT text with Newlines?



Kent,

I had the same issues. The description field for my products had line
breaks causing havoc during the import. I converted the desription field to
html so that I could use
for line breaks. Now all my test is
essentially one long line with no breaks, but the description is still
formated as I wanted.

John Vercelletto
Director of IT
CSB Commodities, Inc.
64 Division Avenue, Suite 107E
Levittown, NY 11756

516-796-5554
516-796-6655 FAX

[email protected]


-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of Kent
Sent: Saturday, October 30, 2004 2:14 AM
To: Miva Merchant coders list
Subject: [mrc] MvIMPORT text with Newlines?


Hi folks -- hope somebody knows the answer to this one:

Suppose I need to MvIMPORT a text file, using a character such as pipe
("|") for the delimiter, but some of the fields contain Newline
characters. Will that work -- I mean, will Miva consider the Newlines to
be part of the fields? Or will the Newlines always force the end of a
record, resulting in a lot of too-short records and empty fields?

Thanks --

Kent Multer | /| P.O.Box 701895, Dallas TX 75370
Magic Metal Productions | / | (214) 570 8264 voice/fax
| | [email protected]
* Web developer/designer http://TheMagicM.com
* E-commerce and Miva
* Author, The Official Miva Web Scripting Book -- available on-line:
<A HREF ="http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA">http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA</A>