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!!! :) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Import CSV on DB level in Remedy ARS 7.5
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 Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. 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 Archives at www.arslist.org 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
Re: Import CSV on DB level in Remedy ARS 7.5
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: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 level. Thanks for the reply guys!!! :) _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
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 p.romain.arsl...@parsolutions.co.uk 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: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 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
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:arslist@ARSLIST.ORG] 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 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 p.romain.arsl...@parsolutions.co.uk mailto:p.romain.arsl...@parsolutions.co.uk 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:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes Sent: 03 July 2014 08:58 To: arslist@ARSLIST.ORG mailto: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!!! :) _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
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 import can usually be scripted in under an hour. Meta-Update includes a single stepping debugger and robust facilities for every data type in Remedy (attachments, currency, diary fields, even status history fields) and can be used to automate any data operation through the API. As an import tool it can handle poorly quoted CSVs, CSVs with values containing embedded quotes or line feeds, and it can also update multiple records from each CSV row or different forms for each row. It is replete with auditing and logging facilities. Trial licenses are free and come with our Live Install service which usually results in your first business problem being solved. New: We have an ITSM Archiving package – that handles a root request as a single tree of data and will include your own tables and multi-tenant rules. We also have a data migration package that will migrate from 7.0.3 to 8.1 including changing Change to Releases, fixing the CMDB, merging and renaming product and operational catalogues, support groups, even operating companies. For more information visit us at www.softwaretoolhouse.com Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email:mailto:Ben.Chernys_AT_softwaretoolhouse.com Ben.Chernys_AT_softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as the tree of data and forms that it is it is. Pre ITSM 7.6.04? Clarify? Roll your own? No problem! You can keep your valuable data! http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ -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 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 http://www.softwaretoolhouse.com. Best Regards - Misi, RRR AB, http://www.rrr.se http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se http://rrr.se. 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 Archives at http://www.arslist.org www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at http://www.arslist.org www.arslist.org Where the Answers Are, and have been for 20 years - No virus found in this message. Checked by AVG - http://www.avg.com www.avg.com Version: 2013.0.3485 / Virus Database: 3955/7787 - Release Date: 07/03/14 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years smime.p7s Description: S/MIME cryptographic signature
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 div Original message /divdivFrom: Peter Romain p.romain.arsl...@parsolutions.co.uk /divdivDate: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 it in the form properties Cheers Peter From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] 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 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 p.romain.arsl...@parsolutions.co.uk 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: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 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Import CSV on DB level in Remedy ARS 7.5
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:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes Sent: 03 July 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 Original message From: Peter Romain Date:03/07/2014 18:06 (GMT+08:00) To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes Sent: 03 July 2014 10:24 To: arslist@ARSLIST.ORG mailto: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 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 p.romain.arsl...@parsolutions.co.uk mailto:p.romain.arsl...@parsolutions.co.uk 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:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes Sent: 03 July 2014 08:58 To: arslist@ARSLIST.ORG mailto: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!!! :) _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
Re: Import CSV on DB level in Remedy ARS 7.5
** Hi Ben,Thanks for the reply. But unfortunately buying a tool is currently not an option for us. Thanks againSent from Samsung Mobile Original message From: Ben Chernys <ben.cher...@softwaretoolhouse.com> Date:03/07/2014 19:04 (GMT+08:00) To: arslist@ARSLIST.ORG Subject: 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 import can usually be scripted in under an hour. Meta-Update includes a single stepping debugger and robust facilities for every data type in Remedy (attachments, currency, diary fields, even status history fields) and can be used to automate any data operation through the API.As an import tool it can handle poorly quoted CSVs, CSVs with values containing embedded quotes or line feeds, and it can also update multiple records from each CSV row or different forms for each row.It is replete with auditing and logging facilities. Trial licenses are free and come with our Live Install service which usually results in your first business problem being solved.New: We have an ITSM Archiving package – that handles a root request as a single tree of data and will include your own tables and multi-tenant rules. We also have a data migration package that will migrate from 7.0.3 to 8.1 including changing Change to Releases, fixing the CMDB, merging and renaming product and operational catalogues, support groups, even operating companies.For more information visit us at www.softwaretoolhouse.comBen ChernysSenior Software Architect Canada / DeutschlandMobile: +49 171 380 2329 GMT + 1 + [ DST ]Email: Ben.Chernys_AT_softwaretoolhouse.comWeb: www.softwaretoolhouse.comWe are a BMC Technology Alliance PartnerCheck out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet.Meta-Update, our premium ARS Data tool, lets youautomate your imports, migrations,in no time at all, without programming, without staging forms, without merge workflow.Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as the tree of data and forms that it is it is.Pre ITSM 7.6.04? Clarify? Roll your own? No problem!You can keep your valuable data!http://www.softwaretoolhouse.com/ -Original Message-From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi MladoniczkySent: July-03-14 10:45To: arslist@ARSLIST.ORGSubject: Re: Import CSV on DB level in Remedy ARS 7.5Hi,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 Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):* RRR|License - Not enough Remedy licenses? Save money by optimizing.* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.Find these products, and many free tools and utilities, at http://rrr.se. 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 Archives at www.arslist.org "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"-No virus found in this message.Checked by AVG - www.avg.comVersion: 2013.0.3485 / Virus Database: 3955/7787 - Release Date: 07/03/14 _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_
Re: Import CSV on DB level in Remedy ARS 7.5
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 /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 (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:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes Sent: 03 July 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 Original message From: Peter Romain Date:03/07/2014 18:06 (GMT+08:00) To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] 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 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 p.romain.arsl...@parsolutions.co.uk 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: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 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
Re: Import CSV on DB level in Remedy ARS 7.5
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:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes Sent: 03 July 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 Original message From: Peter Romain Date:03/07/2014 18:06 (GMT+08:00) To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes Sent: 03 July 2014 10:24 To: arslist@ARSLIST.ORG mailto: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 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 p.romain.arsl...@parsolutions.co.uk mailto:p.romain.arsl...@parsolutions.co.uk 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:arslist@ARSLIST.ORG] On Behalf Of Wesley Reyes Sent: 03 July 2014 08:58 To: arslist@ARSLIST.ORG mailto: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!!! :) _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