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 2329 GMT + 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:[email protected]] On Behalf Of Misi Mladoniczky Sent: July-03-14 10:45 To: [email protected] 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
