Re: [U2] UniVerse Import XML data [not-secure]
snip And at this point, Mark (the original poster) has probably stopped paying attention which is totally my fault. I apologize. /snip I am absolutely paying attention. I hadn't even considered using a 3rd party tool to read the XML. As I said, we're starting at square 1... CONFIDENTIAL INFORMATION: The information contained in this e-mail may be confidential and protected from general disclosure. If the recipient or reader of this e-mail is not the intended recipient or a person responsible to receive this e-mail for the intended recipient, please do not disseminate, distribute or copy it. If you received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. We will take immediate and appropriate action to see to it that this mistake is corrected.[*LD*] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Redback Connection Problem
We finally got a solution from Rocket for the Redback connection issue from last week. Here is a quick recap: We have 3 web sites (TEST, PILOT LIVE) all running off a single web server. We have 3 ePortal accounts (TEST, PILOT LIVE) on our UNIX box. We have 3 Avanté accounts (TEST.DATA, PILOT.DATA LIVE.DATA) on our UNIX box. When Redback tries to connect to an ePortal account, it uses syntax like this where account is the ePortal account: myCart.Open2 account,SF:oPreOrder When Redback tries to connect to an Avanté account, it uses syntax like this where accnt is the Avanté account: oOrder.Open2 accnt,SF:oOrder,userid,passwd (note the addition of a login password) Solution: When connecting to Avanté, it looks in the VOC file for a record called APP.IDS. F2 of this record is a multi-valued list of file types to open (for example: SF^CFG). If it can open the SFxxx files it wants, everything is good and it does not appear to test the other files. In my TEST and PILOT accounts, VOC APP.IDS 2 = II^SF^CFG^ICN. This worked. In my LIVE account, VOC APP.IDS 2 = ICN^SF^CFG. This failed, apparently because we do not have ICNxxx files. I backed up VOC APP.IDS to APP.IDS.ORIG, then changed APP.IDS 2 to SF^CFG. Everything worked!!! To be consistent, I backed up APP.IDS in TEST and PILOT and then set APP.IDS to match what worked in LIVE. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, January 23, 2012 4:17 PM To: U2 Users List Subject: Re: [U2] Redback Connection Problem I'm just making sure that what you have on site is the same as what we have (and our storefront, also heavily customized) has been up and running for years. One question, just to rule out everything we can before you get a tech on the line... have you tried it with a different browser and/or from a different computer? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, January 23, 2012 1:05 PM To: 'U2 Users List' Subject: Re: [U2] Redback Connection Problem If this is driving YOU crazy, you can imagine how I feel. I have very little hair left on my already balding head. This is a 6 month project that is due next week that is held up on this one issue (so far). Anyway, the connections to the ERPAccount (i.e LIVE.DATA) is only used by ePortal in the checkout process once a basket has been successfully populated by the user. From that point on, I believe all the connections go against the Avanté account. Why? I have no clue. So long as the program and files that are needed are there, who cares? The only place I could see this making a difference is when the order is actually built as an XML file and pushed through Avanté via the iConnect suite (which is also global like Redback). Since I have not gotten that far, iConnect is not in the picture at this point. I MIGHT be able to switch everything to work from just the ePortal accounts, but my hesitation is: 1) I did not need to do this in TEST/PILOT so why should I need to in LIVE? 2) If changing DOES work up until the end, why did Epicor write it this way (I am not expecting a great answer here)? 3) If the final filing that kicks in the iConnect stuff DOES need it that way, I will have re-written a bunch of code that I have to put back anyway. The bottom line to all this is: WHAT IS DIFFERENT BETWEEN TEST/PILOT AND LIVE!!! I will happily post the solution to this when Epicor finally gets back to me. In the words of the profit, John Belushi: My advice to you is to start drinking heavily. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, January 23, 2012 3:48 PM To: U2 Users List Subject: Re: [U2] Redback Connection Problem Ok, this is driving me crazy, so when you figure it out, I'd love to know. But going back to your last email - It is almost like there is something set up SOMEWHERE that says rbadmin can access everything except LIVE.DATA. - we know that's not true (so ignore my last email), because your eportal site is using the rbadmin uid/pw successfully. Sooo We know it's not the password because eportal (your site not the account) can use it. We know it's not the account setup because your eportal can use it. We know this works: account=Application(Account). myCart.Open2 account,SF:oPreOrder And this doesn’t: accnt=Application(ERPAccount). oOrder.Open2 accnt,SF:oOrder,userid,passwd The only difference it seems between your eportal working in live and your storefront not working in live the ERPAccount variable which I don't remember being used in epicor's eportal, only storefront (but haven't verified). Do you have full path in global.asa or just the account name? I'm sure you have it
[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
Re: [U2] UniVerse Dynamic File Question
On UniVerse over Solaris. Do dynamic files on a 32 bit operating system have the 2 gig limit? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dynamic File Question
Yes ... all files on a universe system have a 2 gig limit unless you are doing 64bit files. The advantage of the dynamic file would the the size of the dat file and the size of the over file . Thus in theory would have a 2 gig of each -Dan Dan Goble | IT Senior Software Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney Sent: Monday, January 30, 2012 7:55 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dynamic File Question On UniVerse over Solaris. Do dynamic files on a 32 bit operating system have the 2 gig limit? ___ 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
