Re: Data Import Suggestions
BMC Migrator can be used to migrate the data. Just identify all the required forms and migrate the data for them From: Rüdiger Tams [mailto:ruedi...@tams.de] Sent: 09 May 2013 03:53 Subject: AW: Re: Data Import Suggestions ** Atrium Integration Engine in 7.6.04 is the recommended way to Import Data into CMDB classes. Is the Source Data in flat file Format or in DB tables AIE is usable but has some minor restrictions. Regards Rüdiger From: Jim Coryat (jcoryat) mailto:jcor...@micron.com>>; To: mailto:arslist@ARSLIST.ORG>>; Subject: Re: Data Import Suggestions Sent: Wed, May 8, 2013 9:39:58 PM Agreed, but not everyone has an understanding of how to utilize an API level interface. For those, the Remedy Data Import Tool suffices. Jim Coryat x34655 From: Alan Truelove [mailto:truelove.a...@yahoo.com] Sent: Wednesday, May 08, 2013 12:25 PM Subject: Re: Data Import Suggestions ** Use Remedy Java API -- I have done this precise task (Inputting large batch CI -- Access db, EXCEL, csv files, etc etc into Asset forms) several times over the past few years, it is much faster and less troublesome than the standard Remedy tool(s). 571 242 0153. Best wishes. From: Abdullah Baytops > To: arslist@ARSLIST.ORG Sent: Wednesday, May 8, 2013 11:50 AM Subject: Data Import Suggestions ** I wanted to know what suggestions anyone would have on the easiest way to import information into the (Asset Module ) specifically the AST: Equipment form of ITSM 7.6.04? V/R Abdul Baytops CONFIDENTIALITY NOTICE: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. This information is intended only for the use of the individual to whom this e-mail is addressed. If you are not the intended recipient, or the employee or agent responsible to the intended recipient, please notify us by return email or by telephone, and destroy this email along with any attachments. _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"
AD: Data Import Suggestions
Meta-Update offers the speed and flexibility of API - without the programming or API skills required AND with lots of features for data transformations etc. It is designed for Remedy developers and administrators using a language they already know: Queries and assignments. With Meta-Update you can launch server or client processes - including the special filter processes, handle input and output files, make multiple server connections, use CSVs as LookUp files, cache records from ARS, create several types of auditing logs. A further automatic feature when importing files, is the creation of a like file containing only those original source records that failed. Meta-Update includes a debugger. You can single-step a script, examine records and data in memory, set breakpoints. So, for example, a script that imports a CSV to different CMDB classes - based on a LookUp of data in that row against another CSV - and adjusting attributes such as 1TB to a number (as in disk sizes) took an hour to write and is described in a presentation here <http://www.softwaretoolhouse.com/product/SthMupd/2012-RUG-de.html> . The data import tool will typically be used to import into a staging form that must be created with appropriate filters to validate data and push to the required forms. Any lookups are coded in filters and the lookup data itself must be in a remedy form. This can take a long time to develop and test. API programming also requires skills and efforts and take considerable time. Meta-Update give you the power of the API without the need for programming. Meta-Update, on the other-hand, requires absolutely no changes to the server. No staging forms, no workflow. Once a script is developed it can be used over and over again on different files and can be fired through the OS scheduling tools or by Remedy itself. There are no charges for scripts already developed and we have many such scripts for almost all requirements of ITSM imports, data migrations, validations, changes. The efforts to write a script from scratch for what Abdul is talking about would be around 15 minutes. >From one of our customers: "I recommend Meta-Update for all those who want the flexibility of a scripting language to handle bulk ARS data." For a trial or presentation, please contact us. Cheers Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: 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 out Freebies Section for a ITSM 7.6.04 and 8.0.0 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. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jim Coryat (jcoryat) Sent: May-08-13 23:40 To: arslist@ARSLIST.ORG Subject: Re: Data Import Suggestions ** Agreed, but not everyone has an understanding of how to utilize an API level interface. For those, the Remedy Data Import Tool suffices. Jim Coryat x34655 From: Alan Truelove [mailto:truelove.a...@yahoo.com] Sent: Wednesday, May 08, 2013 12:25 PM Subject: Re: Data Import Suggestions ** Use Remedy Java API -- I have done this precise task (Inputting large batch CI -- Access db, EXCEL, csv files, etc etc into Asset forms) several times over the past few years, it is much faster and less troublesome than the standard Remedy tool(s). 571 242 0153. Best wishes. _ From: Abdullah Baytops To: arslist@ARSLIST.ORG Sent: Wednesday, May 8, 2013 11:50 AM Subject: Data Import Suggestions ** I wanted to know what suggestions anyone would have on the easiest way to import information into the (Asset Module ) specifically the AST: Equipment form of ITSM 7.6.04? V/R Abdul Baytops CONFIDENTIALITY NOTICE: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. This information is intended only for the use of the individual to whom this e-mail is addressed. If you are not the intended recipient, or the employee or agent responsible to the intended recipient, please notify us by return email or by telephone, and destroy this email along with any attachments. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.3272 / Virus Database:
Re: Data Import Suggestions
Agreed, but not everyone has an understanding of how to utilize an API level interface. For those, the Remedy Data Import Tool suffices. Jim Coryat x34655 From: Alan Truelove [mailto:truelove.a...@yahoo.com] Sent: Wednesday, May 08, 2013 12:25 PM Subject: Re: Data Import Suggestions ** Use Remedy Java API -- I have done this precise task (Inputting large batch CI -- Access db, EXCEL, csv files, etc etc into Asset forms) several times over the past few years, it is much faster and less troublesome than the standard Remedy tool(s). 571 242 0153. Best wishes. From: Abdullah Baytops mailto:abayt...@onefederalsolution.com>> To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Sent: Wednesday, May 8, 2013 11:50 AM Subject: Data Import Suggestions ** I wanted to know what suggestions anyone would have on the easiest way to import information into the (Asset Module ) specifically the AST: Equipment form of ITSM 7.6.04? V/R Abdul Baytops CONFIDENTIALITY NOTICE: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. This information is intended only for the use of the individual to whom this e-mail is addressed. If you are not the intended recipient, or the employee or agent responsible to the intended recipient, please notify us by return email or by telephone, and destroy this email along with any attachments. _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: Data Import Suggestions
Use Remedy Java API -- I have done this precise task (Inputting large batch CI -- Access db, EXCEL, csv files, etc etc into Asset forms) several times over the past few years, it is much faster and less troublesome than the standard Remedy tool(s). 571 242 0153. Best wishes. From: Abdullah Baytops To: arslist@ARSLIST.ORG Sent: Wednesday, May 8, 2013 11:50 AM Subject: Data Import Suggestions ** I wanted to know what suggestions anyone would have on the easiest way to import information into the (Asset Module ) specifically the AST: Equipment form of ITSM 7.6.04? V/R Abdul Baytops CONFIDENTIALITY NOTICE: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. This information is intended only for the use of the individual to whom this e-mail is addressed. If you are not the intended recipient, or the employee or agent responsible to the intended recipient, please notify us by return email or by telephone, and destroy this email along with any attachments. _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"
AD: Data Import Suggestions
Meta-Update is the easiest way. You can create as many records as you like from the import (associations, relationships, etc). You can validate the data and reject records that you don't like - automatically creating a copy of the file with only those rejected records in it. All with no Remedy changes at all. No staging forms, no AIE or AI jobs. The import in this presentation <http://softwaretoolhouse.com/product/SthMupd/2012-RUG-de.html> is more complex than your needs and the Meta-Update development for it was about two hours. There are plenty of scripts available and these are no charge. A trial license is free and dated, and gives you all the functionality of the product, along with a Live Install WebEx presentation. The Management Overview <http://www.softwaretoolhouse.com/product/SthMupd/mupd_mgmt_smry.html> is a 12 minute "movie". For more information, please contact me directly. Cheers Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: 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 out Freebies Section for a ITSM 7.6.04 and 8.0.0 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. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Abdullah Baytops Sent: May-08-13 17:50 To: arslist@ARSLIST.ORG Subject: Data Import Suggestions ** I wanted to know what suggestions anyone would have on the easiest way to import information into the (Asset Module ) specifically the AST: Equipment form of ITSM 7.6.04? V/R Abdul Baytops CONFIDENTIALITY NOTICE: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. This information is intended only for the use of the individual to whom this e-mail is addressed. If you are not the intended recipient, or the employee or agent responsible to the intended recipient, please notify us by return email or by telephone, and destroy this email along with any attachments. No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.3272 / Virus Database: 3162/6308 - Release Date: 05/08/13 _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" <> smime.p7s Description: S/MIME cryptographic signature
Data Import Suggestions
I wanted to know what suggestions anyone would have on the easiest way to import information into the (Asset Module ) specifically the AST: Equipment form of ITSM 7.6.04? V/R Abdul Baytops CONFIDENTIALITY NOTICE: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. This information is intended only for the use of the individual to whom this e-mail is addressed. If you are not the intended recipient, or the employee or agent responsible to the intended recipient, please notify us by return email or by telephone, and destroy this email along with any attachments. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"