Using the Remedy Import command line interface Developing AR System Applications: Advanced
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Peketi, Rameshbabu Sent: Thursday, March 08, 2007 11:10 AM To: [email protected] Subject: Re: Import CSV file in Remedy You can import the file directly into the database using DTS packages. We tried in the past and it imported successfully. You have to import into T table, H tables individually... If we import directly into the tables, it doesn't update the next ID in arschema table. So, After all the importing is done, update nextID in the arschema table with the latest requestID of the T table. The T table latest request id and H table's request ID should be same. If you take care of all the above, the import is successful. Regards, Ramesh Babu. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Peter Romain Sent: Thursday, March 08, 2007 1:59 PM To: [email protected] Subject: Re: Import CSV file in Remedy I would create a new import form in Remedy and import the csv files into this form. Filters on merge would then be written to push the data to the correct classes. Harmil writes: > All, > > We need to import some CSV files in to Remedy Database (SQLServer) and it will be a one time dump of data so we don't concern about the performance or any other issues. We have different columns on CSV file goes to different BMC CMDB 1.1 classes in remedy so how do i create a workflow which takes each CSV file's column and import those attributes in Remedy form(Table).Can some one tell me the best way to handle this.I think i need some kind of DB script and step details to create this work flow? > > Environment: > > CM DB 1.1 > ARS 6.x > Windows NT > IT SM 6.x > > Appreciated your quick response. > > Thanks, > > Harmil > Remedy Consultant > > > > --------------------------------- > Don't get soaked. Take a quick peek at the forecast with theYahoo! > Search weather shortcut. > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" -- *****DISCLAIMER***** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *****END OF DISCLAIMER***** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
