Well, I used the rrrARSCHEMA form that Misi distributes with rrr|CHIVE to update all 1,558 type 1 forms to new NEXTID values before we opened the upgraded system up for testing. That way ALL new records are deconflicted from the data updates that we run weekly with rrr|CHIVE from production. You can select forms based on ranges of NEXTID values after sorting them, then modify all selected form NEXTIDs at once to a new number, for example, I moved ALL forms where NEXTID was less than 500 (about 1,300 forms) to 1001, between 500 and 1000 to 2001, etc. Using the rrARSCHEMA form made this admittedly manual process quite easy, once I had already decided what I wanted to change each block to. This way there will be no doubt where a record was created - on the current production system or on the new, upgraded system.
Reports was the fun one - the NEXTID was 2,163 on a 7.1 system. After all of the upgrading steps that got me to 7.6.04, it was 20,001,458, so I had to set it to 30,000,001. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Susan Palmer Sent: Tuesday, June 28, 2011 4:17 PM To: arslist@ARSLIST.ORG Subject: New v7.5P4 server needs NextIDs on existing form in v7.0.1P2 server ** Hi Everyone, We are getting ready to cutover to our new server using v7.5P4. I'm looking for a more efficient way to enter the NextID (fieldID 1) for forms other than one by one on the new server at cut over. It's great that the arschema form data is available in the user tool, but it's still a one at a time update. Is there some way to say, 'Update all forms to use the nextID based on highest ID currently on a form'? I've been using rrrchive to do the data updates and it has worked great. But I don't see an option for NextID update, or I missed it. I know I could looks at the NextID the day before and just enter a 'higher' number than I think will be utilized before cut over on the new server, but I'd really like the change to be transparent. Thanks for suggestions you may have. Susan ARS v7.0.1P2 going to v7.5.P4 Oracle 10g Susan Palmer ShopperTrak 200 W Monroe St 11th Floor Chicago, IL 60606 312-529-5325<tel:312-529-5325> spal...@shoppertrak.com<mailto:spal...@shoppertrak.com> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"