With Meta-Update, no such problems exist. Cheers Ben Chernys
Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. 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/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: October-24-10 03:35 To: [email protected] Subject: Re: v7.5 Import Tool issue on diary type fields Hi, I have experienced big problems with Import Tool 7.5 when doing updates. I think the problem lies in Import Tool and not in the server. When importing with replace or update, the original record is always deleted and recreated. The server has done it that way as long as I remember. I talked to someone at evening with engineering that promised to look into this issue, as it has a very bad impact on performance. How this is done is not controlled by the import tool, but is up to the server. It has a bad impact on performance when importing in place. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * 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 everyone, > > Import Tool v7.5, tested on Patch 3 and Patch 7. > > Simple import to 'Update' 3 fields on existing records. > Character field updates ok. > Date field updates ok. > Diary (audit log) does not. The import wipes out previously saved > diary field entries. Bad tool! > I am using field 1 to match records (named Site ID). > > I've been updating diary fields forever and the import entry was > always just the 'next' entry in the diary field. > > I have a webex recording of what it does that I don't think will go > through as an attachment here. If you have a webex player let me know > and I'll send it too you (763kb). It demonstrates the issue. > > Column has reproduced the problem also but noticed that the Help Text > associated with 'Update' indicates: > "Update Old Record with New Record's Data-Entries are imported using > their existing IDs. If a duplicate ID exists, only the fields being > imported are replaced, merging the record. If you choose this option, > BMC Remedy Data Import actually deletes the record and reinserts it to > perform the "update." > > Is anyone else experiencing this and have a workaround? > > Thanks for your help, > Susan > > Susan Palmer > ShopperTrak > 200 W Monroe St 11th Floor > Chicago, IL 60606 > 312-529-5325 > [email protected] > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
