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 > spal...@shoppertrak.com > > _______________________________________________________________________________ > 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"