Thanks LJ ... I'll do that search. I don't have much to lose before I spend more time importing data form by form. If I can change that ID I would be ecstatic!
Thanks for your input Guillaume. Susan :) On Wed, Jul 28, 2010 at 10:46 AM, LJ LongWing <[email protected]> wrote: > ** > > 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 > J > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Susan Palmer > *Sent:* Wednesday, July 28, 2010 9:22 AM > > *To:* [email protected] > *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 > > [email protected] > > > > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _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"
