Import CSV on DB level in Remedy ARS 7.5

2014-07-03 Thread Wesley Reyes
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!!! :) ___ UNSUBSCRIBE or access ARSlist

Re: Import CSV on DB level in Remedy ARS 7.5

2014-07-03 Thread Misi Mladoniczky
Hi, I would recommend API-based tools such as the Data Import tool. Or if you need more flexibility write your own tool. Or maybe buy the scripting tool from Ben Cherneys @ http://www.softwaretoolhouse.com. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the

Re: Import CSV on DB level in Remedy ARS 7.5

2014-07-03 Thread Peter Romain
Reyes Sent: 03 July 2014 08:58 To: arslist@ARSLIST.ORG 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

Re: Import CSV on DB level in Remedy ARS 7.5

2014-07-03 Thread Wesley Reyes
) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes Sent: 03 July 2014 08:58 To: arslist@ARSLIST.ORG 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

Re: Import CSV on DB level in Remedy ARS 7.5

2014-07-03 Thread Peter Romain
] On Behalf Of Wesley Reyes Sent: 03 July 2014 10:24 To: arslist@ARSLIST.ORG 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

Re: Import CSV on DB level in Remedy ARS 7.5

2014-07-03 Thread Ben Chernys
/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: July-03-14 10:45 To: arslist@ARSLIST.ORG Subject: Re: Import CSV on DB level in Remedy ARS 7.5 Hi, I would recommend API-based tools

Re: Import CSV on DB level in Remedy ARS 7.5

2014-07-03 Thread Wesley Reyes
:03/07/2014 18:06 (GMT+08:00) /divdivTo: arslist@ARSLIST.ORG /divdivSubject: Re: Import CSV on DB level in Remedy ARS 7.5 /divdiv /div** 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

Re: Import CSV on DB level in Remedy ARS 7.5

2014-07-03 Thread Peter Romain
2014 12:29 To: arslist@ARSLIST.ORG 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

Re: Import CSV on DB level in Remedy ARS 7.5

2014-07-03 Thread Wesley Reyes
ct: Re: Import CSV on DB level in Remedy ARS 7.5 ** Thanks Misi,Meta-Update will handle 500k files no problem. It has a “light footprint” not requiring any changes to the Remedy server’s forms or workflow and can completely eliminate the need for staging forms and workflow for imports.A simple file

Re: Import CSV on DB level in Remedy ARS 7.5

2014-07-03 Thread Wesley Reyes
Original message /divdivFrom: Peter Romain p.romain.arsl...@parsolutions.co.uk /divdivDate:03/07/2014 19:58 (GMT+08:00) /divdivTo: arslist@ARSLIST.ORG /divdivSubject: Re: Import CSV on DB level in Remedy ARS 7.5 /divdiv /div** Yes, but on each record you will need to set the Request ID

Re: Import CSV on DB level in Remedy ARS 7.5

2014-07-03 Thread Misi Mladoniczky
: 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