Re: [U2] Update the VOC after upgrade?
Thanks all for the help. I think this is enough to avoid the headache of logging into every account each time I do an upgrade. On Mon, Jan 30, 2012 at 5:58 PM, Boydell, Stuart stuart.boyd...@spotless.com.au wrote: You could run find with xargs at the nix shell... find / -name VOC -type f -print|dirname|xargs uv UPDATE.ACCOUNT Caveat emptor: I have not tested this! Stuart From: John Thompson Sent: 31-Jan-12 6:18 To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Update the VOC after upgrade?
Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
We recently created a UNIX script to loop through a list of UniVerse account paths (any account that has a VOC file) and then let the script loop through them. Still requires manual input, which I wanted, to verify each account prior to updating. It works pretty quick. First ran this command to build a file of paths: find ./ -name VOC -print /script_path/UpdateVOCPaths I edited this file and removed the /VOC from the end of each line so the path has just the account name. There's probably a better way to refine the find command to strip out the /VOC part of the output, but this got the job done. I then use a UNIX script (called mine UpdateVOCFiles): clear echo Starting update of UniVerse accounts to 11.1.4 /script_path/UpdateVOCLog for i in $(cat /script_path/UpdateVOCPaths) do echo /script_path/UpdateVOCLog echo Updating Account: $i echo Updating Account: $i /script_path/UpdateVOCLog cd $i /u1/uv/bin/uv (path of your uv installation) done Again, I set it up to have to answer 'Y' that I wanted to update each account. Gary P. Canedy Senior Database Analyst P: 617.757.6775 F: 617.428.9803 gcan...@coverys.com (Embedded image moved to file: pic25102.jpg) 101 Arch Street, 4th Floor Boston, MA 02110 www.coverys.com Toll Free: 800.225.6168 From: John Thompson jthompson...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Date: 01/30/2012 02:18 PM Subject:[U2] Update the VOC after upgrade? Sent by:u2-users-boun...@listserver.u2ug.org Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
John: Consider the script at ED VOC LOGIN --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 2:18 PM To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
You mean in the main UV account? I'm not following... On Mon, Jan 30, 2012 at 3:59 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: John: Consider the script at ED VOC LOGIN --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 2:18 PM To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
I think he means to 'include' the 'update' to the VOC as part of each accounts LOGIN script?? Am I reading that right? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 3:37 PM To: U2 Users List Subject: Re: [U2] Update the VOC after upgrade? You mean in the main UV account? I'm not following... On Mon, Jan 30, 2012 at 3:59 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: John: Consider the script at ED VOC LOGIN --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 2:18 PM To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
The VOC is just a file like any other file in UV. 1. Update at least one account. 2. Create a Q pointer to the VOC in another account 3. Copy the updated records. ** The trick is understand what has been changed in the VOC during an update (step 1) ** Regards, Stewart Mitchell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Tuesday, 31 January 2012 5:48 AM To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Effective October 2011 Symbion Pharmacy Services has changed its name to Symbion. My email address has changed from @symbionpharmacy.com to @symbion.com.au. The company's ABN (25 000 875 034) remains the same. This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
Yes... that is the right way to read my first response. It is not clear to me if that approach is workable... it was merely a possible angle. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Monday, January 30, 2012 4:49 PM To: 'U2 Users List' Subject: Re: [U2] Update the VOC after upgrade? I think he means to 'include' the 'update' to the VOC as part of each accounts LOGIN script?? Am I reading that right? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 3:37 PM To: U2 Users List Subject: Re: [U2] Update the VOC after upgrade? You mean in the main UV account? I'm not following... On Mon, Jan 30, 2012 at 3:59 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: John: Consider the script at ED VOC LOGIN --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 2:18 PM To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
Oh ok. I was asking specifically how to call the utility from Rocket that updates the VOC from one release to another. For example, if I upgrade from Universe 10.3 to 11.1. Sorry, I probably wasn't clear on that. On Mon, Jan 30, 2012 at 5:04 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: Yes... that is the right way to read my first response. It is not clear to me if that approach is workable... it was merely a possible angle. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Monday, January 30, 2012 4:49 PM To: 'U2 Users List' Subject: Re: [U2] Update the VOC after upgrade? I think he means to 'include' the 'update' to the VOC as part of each accounts LOGIN script?? Am I reading that right? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 3:37 PM To: U2 Users List Subject: Re: [U2] Update the VOC after upgrade? You mean in the main UV account? I'm not following... On Mon, Jan 30, 2012 at 3:59 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: John: Consider the script at ED VOC LOGIN --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 2:18 PM To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
John, The UniVerse utility that you are looking for is updaccount. This is found in the UV Bin directory. If you, or anyone else would like it, I have a script that will do a series of things to help avoid errors. From memory, this is what it does: You generate a file using find, called vocfiles, of all accounts that you want to update. You run the script which loops over vocfiles doing the following: * skip certain keywords where voc might live * make a backup of VOC * clear TEMP as this is where modified VOC items go after an update * Update the account * Check a list of verbs that may have been modified. Ignore some, copy others back from TEMP * If a verb isn't in either list, it will consolidate the results and let you know which ones to look at I got tired of doing UV upgrades and having to manually update each account, copy back certain verbs that we modify from the original, over and over again for at least 18 accounts on our development system, QC, test and other servers... If you would like a copy, e-mail me off list. If I get enough requests, I'll post to pickwiki or other suggestions. -Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 5:17 PM To: U2 Users List Subject: Re: [U2] Update the VOC after upgrade? Oh ok. I was asking specifically how to call the utility from Rocket that updates the VOC from one release to another. For example, if I upgrade from Universe 10.3 to 11.1. Sorry, I probably wasn't clear on that. On Mon, Jan 30, 2012 at 5:04 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: Yes... that is the right way to read my first response. It is not clear to me if that approach is workable... it was merely a possible angle. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Monday, January 30, 2012 4:49 PM To: 'U2 Users List' Subject: Re: [U2] Update the VOC after upgrade? I think he means to 'include' the 'update' to the VOC as part of each accounts LOGIN script?? Am I reading that right? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 3:37 PM To: U2 Users List Subject: Re: [U2] Update the VOC after upgrade? You mean in the main UV account? I'm not following... On Mon, Jan 30, 2012 at 3:59 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: John: Consider the script at ED VOC LOGIN --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 2:18 PM To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
You could run find with xargs at the nix shell... find / -name VOC -type f -print|dirname|xargs uv UPDATE.ACCOUNT Caveat emptor: I have not tested this! Stuart From: John Thompson Sent: 31-Jan-12 6:18 To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users