Its better to create a table that links to a file, and then creat a vendor form against this table.
Done this with Oracle, and it shuld also be possible with MSSQL -- Jarl On 3/8/07, Peketi, Rameshbabu <[EMAIL PROTECTED]> wrote:
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"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
