Hi SPrasad If you are on Linux - chances are you are also using an Oracle database?
If so, take a look at External Tables http://www.psoug.org/reference/externaltab.html for a way to read CSV files directly into the Oracle Database and then perhaps have a VIEW Form looking directly at the external table or a separate table which would be fed using something like:- Truncate table db_table; Insert into db_table as Select * from external table; You would create the original db_table as :- create table db_table as select * from ext_table; You could then iterate over the entries in either of these tables and perform what you want with it. Hope that helps Kindest Regards David Morgan Senior Technical Consultant Tiberone Technologies Limited Golden Cross House 8 Duncannon Street London WC2N 4JF Ph: +44 (0) 207 484 5069 Fax: +44 (0) 870 8310 381 Mob: +44 (0) 7876 450102 www.tiberone.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: 06 March 2009 16:53 To: arslist@ARSLIST.ORG Subject: Re: Data Import using arimportcmd -- Linux O/S CSV is a form of ASCII text file. All you do is format it properly, and = put the .csv extension. =20 If your configuration doesn't allow files with CSV extension, then you = have a different issue, which is not Remedy related. Perhaps you can = format in XML and import that way. XML is a form of ASCII text file, = with the .XML extension. =20 I am not an Linux expert, but I don't think CSV or XML are excluded. =20 Is it possible I'm mis understanding your issue? Thanks, Mark ________________________________ From: Action Request System discussion list(ARSList) on behalf of = SPrasad Sent: Fri 3/6/2009 11:31 AM To: arslist@ARSLIST.ORG Subject: Data Import using arimportcmd -- Linux O/S Hi All, We have to import data into one of our Remedy application every night. = For that I have built one Escalation with necessary information Such as = mapping file info and directories information where i am going to place mapping = file and data file. The problem is Remedy does support only few formats Such = as .CSV, .XML, .arx., .asc and our AR Server is running on Linux O/S and = since we can't place a CSV file in Linux server and it does support only ASCII text files format, if client wants to provide the data in the form of a = CSV file how to import that data into Remedy? Any ideas and help would be greatly appreciated. Thanks SPrasad -- View this message in context: = http://www.nabble.com/Data-Import-using-arimportcmd----Linux-O-S-tp223758= 92p22375892.html Sent from the ARS (Action Request System) mailing list archive at = Nabble.com. _________________________________________________________________________= ______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
