Yes, the sql server export looks like:
TicketNumberColumn,DescriptionColumn
TicketNumberval,Descriptionval
TicketNumberval,Descriptionval
TicketNumberval,Descriptionval
Thanks> Date: Fri, 21 Dec 2007 08:22:25 -0600> From: [EMAIL PROTECTED]>
Subject: Re: Exported CSV format not valid for Remedy Import Tool> To:
[email protected]> > Is the SQL server export tool creating the CSV with
commas as the> delimiter? If yes, does the data contain commas in places? If
yes, that> will make the CSV invalid.> > -----Original Message-----> From:
Action Request System discussion list(ARSList)> [mailto:[EMAIL PROTECTED] On
Behalf Of Jack Samson> Sent: Friday, December 21, 2007 7:17 AM> To:
[email protected]> Subject: Exported CSV format not valid for Remedy Import
Tool> > ** > All,> > We have another database where records are exported into a
csv file. We> have the need to import these records into Remedy now. We are
using the> ARS 6.3 import tool.The export was performed through SQL server
export> tool. What I have found is the columns and data that was exported>
without double quotes. The AR Import tool does not recognize this> format since
the double quotes are not around ever column and data> value.> > My question is
has anyone run into this issue before and what did you> do? Did you have to
write an API to add the double quotes? > > Thanks in advance!> > Regards,> >
Jackson Samson> Remedy Administrator> > > > ________________________________> >
i'm is proud to present Cause Effect, a series about real people making> a
difference. Learn more>
<http://im.live.com/Messenger/IM/MTV/?source=text_Cause_Effect> >
__20060125_______________________This posting was submitted with HTML in> it___
> >
_______________________________________________________________________________>
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org> Platinum Sponsor:
www.rmsportal.com ARSlist: "Where the Answers Are"
_________________________________________________________________
Share life as it happens with the new Windows Live.
http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_122007
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
