I have used archgid for both forms and fields and it works. Actually what I do is to set the next ID to the correct ID before I import a new form (Use TOAD to do a direct update to the control table in the database), and then set it back afterwards.
Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Wednesday, July 28, 2010 10:46 AM To: arslist@ARSLIST.ORG Subject: Re: ARS v7.5 - importing forms changed Table ID ** You could use archgid, it can change table ID's too....it goes through the system and updates all appropriate references.....while I've never used it for forms, I have used it for fields successfully in the past. Do a search for recent posts regarding where to get the latest version from the jar files :) From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Susan Palmer Sent: Wednesday, July 28, 2010 9:22 AM To: arslist@ARSLIST.ORG Subject: ARS v7.5 - importing forms changed Table ID ** Hi Everyone, We gave up trying to do the ARS v7.5 platform upgrade on our servers. Five months was enough time to waste on that. Yes, we tried everything ... that's not my question here today. Sooooo, we decided to build a new server (vm) and start from scratch with a brand new ARS v7.3 P3 install. That worked great. ITSM is NOT involved in this process at all. Then I exported forms and other workflow objects and did the imports. Kind of a long job because the new server database is on a very slow SAN (nothing I can fix right now). It had not occurred to me that I would loose my original Table ID associated with that form on another server. This is a problem since there is workflow with SQL statements which of course I can change. But, we also have numerous programs pulling data from Remedy that use the Table ID's created by another development group. This would require them to change their programs, possibly dblinks etc. Not a prospect I'm looking forward to. I've only imported data in a couple of forms so far (12 hours worth) and don't want to proceed if I'm going to delete it anyway. I'm using rrrChive for the data and thankfully it's bringing over the correct field 1 values. I do have to figure out how to use rrrChive to include a date modified parameter to get updates. Has anyone been successful at changing a Table ID and how did you do it? Were there any ramifications? Appreciate your help, thanks, Susan Oracle 10g ARS 7.5P3 Solaris 10 Susan Palmer ShopperTrak 200 W Monroe St Floor 11 Chicago, IL 60606 312-529-5325 spal...@shoppertrak.com<mailto:spal...@shoppertrak.com> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
