All,
I'm working with support but wanted to check here if anyone else has run
in to a problem with the 6.3p14 import tool where it strips backslashes (\)
from .csv data. I tried it using both the GUI and arimportcmd tools, and
on MSSQL and Oracle. It will be cumbersome to modify the source data so a
workaround is not an ideal solution.

Thanks in Advance,
-Brian Luke


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

**

Brian,

Upto the previous version (patch 13) there was an issue with the \ character acting as the escape character, in a .csv file - maybe what you are experiencing is their attempt to fix the previous drawback of how the import tool handled \'s ?? Just a wild guess..

I haven't really used patch 14 as yet so can't really offer you my experience with it..

Rgds

Joe D'Souza
Remedy Developer / Consultant,
Shyle Networks,
New Jersey.

Brian Luke wrote:

All,
I'm working with support but wanted to check here if anyone else has run
in to a problem with the 6.3p14 import tool where it strips backslashes (\)
from .csv data. I tried it using both the GUI and arimportcmd tools, and
on MSSQL and Oracle. It will be cumbersome to modify the source data so a
workaround is not an ideal solution.

Thanks in Advance,
-Brian Luke



Do you Yahoo!?
With a free 1 GB, there's more in store with Yahoo! Mail. 20060125This posting was submitted with HTML in it

Someone will correct me if I am wrong, but I believe a backslash is an
escape character. If so then to import a backslash, you would have to
escape it with another backslash(\\).

--- Brian Luke wrote:

> All,
> I'm working with support but wanted to check here if anyone else
> has run
> in to a problem with the 6.3p14 import tool where it strips
> backslashes (\)
> from .csv data. I tried it using both the GUI and arimportcmd tools,
> and
> on MSSQL and Oracle. It will be cumbersome to modify the source data
> so a
> workaround is not an ideal solution.
>
> Thanks in Advance,
> -Brian Luke
>
>

> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>


K. R. Gallagher
Mailto: krgallagher@yahoo.com
http://www.krgallagher.com


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

Yes, this is my very recent experience. This weekend we imported
several files. One of the files contained URLs in every row.

For a line that looks like File:\\servername\share\path\test.doc in a
CSV file, change it to the following before importing:

File:\\\\servername\\share\\path\\test.doc

Yes, that's four slashes after "File:"
Hope that helps,
Michelle

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kevin Gallagher
Sent: Wednesday, January 25, 2006 1:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Backslashes removed from csv imports

Someone will correct me if I am wrong, but I believe a backslash is an
escape character. If so then to import a backslash, you would have to
escape it with another backslash(\\).

--- Brian Luke wrote:

> All,
> I'm working with support but wanted to check here if anyone else
> has run
> in to a problem with the 6.3p14 import tool where it strips
> backslashes (\)
> from .csv data. I tried it using both the GUI and arimportcmd tools,
> and
> on MSSQL and Oracle. It will be cumbersome to modify the source data
> so a
> workaround is not an ideal solution.
>
> Thanks in Advance,
> -Brian Luke
>
>


> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>


K. R. Gallagher
Mailto: krgallagher@yahoo.com
http://www.krgallagher.com



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org