Hi Peter, Thanks. Our source actually is not from another DB but from a csv file. That is why we are looking for a way to import the csv file without using the dataimport tool as it takes us sometime to load the data inside the DB.
Thanks again :) Sent from Samsung Mobile <div>-------- Original message --------</div><div>From: Peter Romain <[email protected]> </div><div>Date:03/07/2014 19:58 (GMT+08:00) </div><div>To: [email protected] </div><div>Subject: Re: Import CSV on DB level in Remedy ARS 7.5 </div><div> </div>** Yes, but on each record you will need to set the Request ID (Field 1) to a unique number (padded up to 15 characters if you need to sort on this field) and also set the other core fields. If real data isn’t needed in the core fields you could set them to dummy values. If your source database is accessible to the Remedy database then you could use a view form to access the data directly rather than import it. You’d still need to identify a unique key though. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Wesley Reyes Sent: 03 July 2014 12:29 To: [email protected] Subject: Re: Import CSV on DB level in Remedy ARS 7.5 ** Hi Peter, Thanks. I will check on that. Can I just use a straight data import from oracle to insert on the T Table once the status History is disabled? Sent from Samsung Mobile -------- Original message -------- From: Peter Romain Date:03/07/2014 18:06 (GMT+08:00) To: [email protected] Subject: Re: Import CSV on DB level in Remedy ARS 7.5 ** Hi Wesley, Yes, in ARS 8.1 it’s in the Basic area of the Definitions tab of the form – Disable Status History In earlier versions I think you’ll find it in the form properties Cheers Peter From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Wesley Reyes Sent: 03 July 2014 10:24 To: [email protected] Subject: Re: Import CSV on DB level in Remedy ARS 7.5 ** Hi Missy, Thanks for the help. We are currently using the DataImport tool already and it is still a bit slow. Hi Peter, Thanks for the help. How can I turn-off the H table? Is it in the parameters or in the properties of the form? Thanks, Wesley On Thursday, 3 July 2014, 17:00, Peter Romain <[email protected]> wrote: ** You could use AI to do this. If this is a custom form and you don’t need the status history you could turn this off which would remove the H table making the import a little easier. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Wesley Reyes Sent: 03 July 2014 08:58 To: [email protected] Subject: Import CSV on DB level in Remedy ARS 7.5 ** Hi, Would like to know if you do have any DB import script that I can import a 500K rows of data to the Remedy DB (T and H table) on a DB level. Thanks for the reply guys!!! :) _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
