Meta-Update is a command line tool that automates imports of CSV files (amongst other things).
It is very easy to implement all sorts of imports with no workflow, no staging forms. The whole idea behind Meta-Update is that ARS Administrators - and not programmers! - can harness the power of the API in a simple way using ARS like Queries and field assignments. Simple imports can be automated in under an hour. With Meta-Update, each record in the CSV can create multiple sets of records across different forms based on the data in the CSV. Data from CSV columns (or from almost any source) can be combined, split, translated, used to load other Remedy records and finally these data and loaded records can be used to make assignments to target records. The Merge API can be used, standard server filter processes can be used. Meta-Update has been used to populate the CMDB from legacy spreadsheets where the target classes were determined by data in the CSVs. It is also used to migrate data from ITSM 6 and 5 to ITSM 7, to manage configuration and transaction data in bespoke applications, and to migrate Foundation data from server to server in ITSM environments. Please visit www.softwaretoolhouse.com for more information. Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 Email: mailto:[email protected] Web: http://www.softwaretoolhouse.com A free notepad for Diary fields: http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm An ARS API scripting tool used for migrations, integrations, imports, reports, extracts, batch jobs: http://www.softwaretoolhouse.com/products/SthMupd -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Conny Martin Sent: January 9, 2009 4:31 PM To: [email protected] Subject: AW: How to create many entries in Remedy form at a time from C# code? With the Remedy Import Tool you can import a .csv file and this tool is included in Remedy ARS 6.3. There is also a command line version (arimportcmd) you can use for automated imports. HTH Kind Regards Conny -----Ursprüngliche Nachricht----- Von: Action Request System discussion list(ARSList) [mailto:[email protected]] Im Auftrag von maggie2007 Gesendet: Freitag, 9. Januar 2009 16:22 An: [email protected] Betreff: Re: How to create many entries in Remedy form at a time from C# code? It is Remedy 6.3. in ARSystem.NET.chm, public void BeginBulkEntryTransaction(); " Initiates a bulk entry transaction. Once this call is made - all subsequent create, delete, set, merge entry operations will be batched together and all of them will be issued only when a SendBulkEntryTransaction call is made. To cancel the bulk txn mode without sending the transaction request to server, CancelBulkEntryTransaction method should be used. " BulkCreateEntryReturn is " The result detail of one operation, specifically a CreateEntry operation, within a Bulk entry transaction. " That seems that I still need to call CreateEntry for each record, didn't see the option to import from some .csv or .xml file for Bulk CreateEntry. Somebody told me that "You can create the Bulk entries in the Remedy form, 1. Through AIE (Atrium Integration Engine) you can create as much entry as you want. but for that the CSV file should be prepared first. After that you can upload this manually or through intervals. 2. Thorugh AR Remedy Import Tool, but for this also you should have the CSV/ARX/RPT files ready to import on customers server. " Probably this is the good way, but not sure if "Atrium Integration Engine" is included in Remedy 6.3 and the components are free? -- View this message in context: http://www.nabble.com/How-to-create-many-entries-in-Remedy-form-at-a-time-fr om-C--code--tp21361747p21374317.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
