While importing into ARS 4.5.2, I'm getting an error that there is a "pipe"
"|" symbol and it won't import. Help....any ideas as to what it could be
seeing. It is an Excel spreadsheet that I've saved as comma delimited to be
used as CTI's.

Thanks,

Terri


UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org.(Support: support@arslist.org).ARSList is hosted by QMX Support Services at www.QMXS.com

Good morning Teresa!

Try disabling filters SHRCA:SHR-NoPipes01 - 04. I know in version 4.03
this is what we needed to do ONLY during imports.

~Heidi



"Lewis, Teresa
E." To: ARSLIST@ARSLIST.ORG
AIC.COM> Subject: "Pipe" in Import
Sent by: "Action
Request System
discussion
list(ARSList)"
ORG>


01/27/2003 07:43
AM
Please respond to
arslist






While importing into ARS 4.5.2, I'm getting an error that there is a "pipe"
"|" symbol and it won't import. Help....any ideas as to what it could be
seeing. It is an Excel spreadsheet that I've saved as comma delimited to
be
used as CTI's.

Thanks,

Terri



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org.(Support:
support@arslist.org).ARSList is hosted by QMX Support Services at
www.QMXS.com


UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org.(Support: support@arslist.org).ARSList is hosted by QMX Support Services at www.QMXS.com

There has been a known issue with this.
It's been said that the problem is that Excel does not export
CVS files with commas at times. The solution is to import
that same Excel Sheet into MS Access as a table and then
Export from the Table.

Be sure to read all the options as you export. I don't remember
what but there is a gotcha in there somewhere. I think the
problem was that MS Access by default does not export
the field names, just the data.

Jose Leon




Internet
TERESA.E.LEWIS@SAIC.COM@ARSLIST.ORG - 01/27/2003 07:43 AM


Please respond to arslist@ARSLIST.ORG

Sent by: ARSLIST@ARSLIST.ORG

To: ARSLIST

cc:


Subject: "Pipe" in Import


While importing into ARS 4.5.2, I'm getting an error that there is a "pipe"
"|" symbol and it won't import. Help....any ideas as to what it could be
seeing. It is an Excel spreadsheet that I've saved as comma delimited to
be
used as CTI's.

Thanks,

Terri



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org.(Support:
support@arslist.org).ARSList is hosted by QMX Support Services at
www.QMXS.com





This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.


UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org.(Support: support@arslist.org).ARSList is hosted by QMX Support Services at www.QMXS.com

Teresa:

Re-examine the CSV file. I expect that you will find the PIPE symbol
somewhere in the file. If necessary, use a text editor like Notepad, not
Excel which might hide this character.

James Mckenzie

-----Original Message-----
From: Lewis, Teresa E. [mailto:TERESA.E.LEWIS@SAIC.COM]
Sent: Monday, January 27, 2003 5:43 AM
To: ARSLIST@ARSLIST.ORG
Subject: "Pipe" in Import


While importing into ARS 4.5.2, I'm getting an error that there is a "pipe"
"|" symbol and it won't import. Help....any ideas as to what it could be
seeing. It is an Excel spreadsheet that I've saved as comma delimited to be
used as CTI's.

Thanks,

Terri



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org.(Support:
support@arslist.org).ARSList is hosted by QMX Support Services at
www.QMXS.com


UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org.(Support: support@arslist.org).ARSList is hosted by QMX Support Services at www.QMXS.com

**

Part of the problem is that Excel does not save into csv correctly. Excel will only put in the double quotes around strings if there is a carriage return in them and that will cause problems. Import the Excel spreadsheet into Access and then export from there. Set the options for comma, Text Qualifier ("), and include field names on 1st row and the import should then work.

Fred

-----Original Message-----
From: Lewis, Teresa E. [ mailto:TERESA.E.LEWIS@SAIC.COM]
Sent: Monday, January 27, 2003 6:43 AM
To: ARSLIST@ARSLIST.ORG
Subject: "Pipe" in Import


While importing into ARS 4.5.2, I'm getting an error that there is a "pipe" "|" symbol and it won't import. Help....any ideas as to what it could be seeing. It is an Excel spreadsheet that I've saved as comma delimited to be used as CTI's.

Thanks,

Terri


UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org.(Support: support@arslist.org).ARSList is hosted by QMX Support Services at www.QMXS.com

UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org.(Support: support@arslist.org).ARSList is hosted by QMX Support Services at www.QMXS.com. This posting was submitted via the Web interface