Update the VOC after upgrade?

View: New views
11 Messages — Rating Filter:   Alert me  

Update the VOC after upgrade?

by John Thompson-15 :: Rate this Message:

| View Threaded | Show Only this Message

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@...
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: Update the VOC after upgrade?

by GCanedy-2 :: Rate this Message:

| View Threaded | Show Only this Message

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
gcanedy@...

(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 <jthompson333@...>
To: U2 Users List <u2-users@...>
Date: 01/30/2012 02:18 PM
Subject: [U2] Update the VOC after upgrade?
Sent by: u2-users-bounces@...



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@...
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@...
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: Update the VOC after upgrade?

by Bill Brutzman-2 :: Rate this Message:

| View Threaded | Show Only this Message

John:

Consider the script at

        ED VOC LOGIN

--Bill

-----Original Message-----
From: u2-users-bounces@... [mailto:u2-users-bounces@...] 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@...
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: Update the VOC after upgrade?

by John Thompson-15 :: Rate this Message:

| View Threaded | Show Only this Message

You mean in the main UV account?  I'm not following...

On Mon, Jan 30, 2012 at 3:59 PM, Bill Brutzman <billb@...>wrote:

> John:
>
> Consider the script at
>
>        ED VOC LOGIN
>
> --Bill
>
> -----Original Message-----
> From: u2-users-bounces@... [mailto:
> u2-users-bounces@...] 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@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> _______________________________________________
> U2-Users mailing list
> U2-Users@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



--
John Thompson
_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: Update the VOC after upgrade?

by David Wolverton :: Rate this Message:

| View Threaded | Show Only this Message

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-bounces@...
[mailto:u2-users-bounces@...] 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
<billb@...>wrote:

> John:
>
> Consider the script at
>
>        ED VOC LOGIN
>
> --Bill
>
> -----Original Message-----
> From: u2-users-bounces@... [mailto:
> u2-users-bounces@...] 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@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> _______________________________________________
> U2-Users mailing list
> U2-Users@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



--
John Thompson
_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users


_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: Update the VOC after upgrade?

by Mitchell, Stewart-4 :: Rate this Message:

| View Threaded | Show Only this Message

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-bounces@... [mailto:u2-users-bounces@...] 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@...
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@...
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: Update the VOC after upgrade?

by Bill Brutzman-2 :: Rate this Message:

| View Threaded | Show Only this Message

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-bounces@... [mailto:u2-users-bounces@...] 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-bounces@...
[mailto:u2-users-bounces@...] 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
<billb@...>wrote:

> John:
>
> Consider the script at
>
>        ED VOC LOGIN
>
> --Bill
>
> -----Original Message-----
> From: u2-users-bounces@... [mailto:
> u2-users-bounces@...] 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@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> _______________________________________________
> U2-Users mailing list
> U2-Users@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



--
John Thompson
_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users


_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: Update the VOC after upgrade?

by John Thompson-15 :: Rate this Message:

| View Threaded | Show Only this Message

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 <billb@...>wrote:

> 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-bounces@... [mailto:
> u2-users-bounces@...] 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-bounces@...
> [mailto:u2-users-bounces@...] 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
> <billb@...>wrote:
>
> > John:
> >
> > Consider the script at
> >
> >        ED VOC LOGIN
> >
> > --Bill
> >
> > -----Original Message-----
> > From: u2-users-bounces@... [mailto:
> > u2-users-bounces@...] 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@...
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > _______________________________________________
> > U2-Users mailing list
> > U2-Users@...
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
>
>
>
> --
> John Thompson
> _______________________________________________
> U2-Users mailing list
> U2-Users@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> _______________________________________________
> U2-Users mailing list
> U2-Users@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> _______________________________________________
> U2-Users mailing list
> U2-Users@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



--
John Thompson
_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: Update the VOC after upgrade?

by Michael Pflugfelder :: Rate this Message:

| View Threaded | Show Only this Message

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-bounces@... [mailto:u2-users-bounces@...] 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 <billb@...>wrote:

> 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-bounces@... [mailto:
> u2-users-bounces@...] 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-bounces@...
> [mailto:u2-users-bounces@...] 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
> <billb@...>wrote:
>
> > John:
> >
> > Consider the script at
> >
> >        ED VOC LOGIN
> >
> > --Bill
> >
> > -----Original Message-----
> > From: u2-users-bounces@... [mailto:
> > u2-users-bounces@...] 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@...
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > _______________________________________________
> > U2-Users mailing list
> > U2-Users@...
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
>
>
>
> --
> John Thompson
> _______________________________________________
> U2-Users mailing list
> U2-Users@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> _______________________________________________
> U2-Users mailing list
> U2-Users@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> _______________________________________________
> U2-Users mailing list
> U2-Users@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



--
John Thompson
_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users

Parent Message unknown Re: Update the VOC after upgrade?

by Boydell, Stuart :: Rate this Message:

| View Threaded | Show Only this Message

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@...
http://listserver.u2ug.org/mailman/listinfo/u2-users



_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: Update the VOC after upgrade?

by John Thompson-15 :: Rate this Message:

| View Threaded | Show Only this Message

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.Boydell@...> 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@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
>
> _______________________________________________
> U2-Users mailing list
> U2-Users@...
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



--
John Thompson
_______________________________________________
U2-Users mailing list
U2-Users@...
http://listserver.u2ug.org/mailman/listinfo/u2-users