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: arslist@ARSLIST.ORG 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"