Hi,
Why not import it into a table you create yourself. Then you create a View
Form to access the data from the system. This way you can control things much
better, and it is also supported.
Best Regards - Misi, RRR AB, http://rrr.se
> 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] <mailto:[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] <mailto:[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]
> <mailto:[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] <mailto:[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_
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
