[U2] XMAPAppendRec, XMAPToXMLDoc and nested (child) tables

2012-06-22 Thread saffa
Hi there, I have an issue with retrieving and placing child data into an xml document. I will do my best to explain what the issue is. I have 2 parent records. Within these parent records I have a zip code which is a foreign key. I map to the foreign table to get the description in order to

Re: [U2] Is there any way to tell if I am in an EXECUTE level andCAPTURING is turned on?

2012-06-22 Thread Doug Farmer
UniData Looks like there is no easy solution. Messages are shown in a generic subroutine and I do not want to do a lot of IO or CPU time to determine if CAPTURING is on. The subroutine is called thousands of times a day for a user. For the few times this has happened over the years, I guess I

[U2] ACH Functionality in ManFact

2012-06-22 Thread John Varney
I've been tasked with writing a bolt on module to give ManFact the ability to utilize ACH processing. Has anyone done this already? If so, any words of wisdom? ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] UV Unix File Recovery

2012-06-22 Thread Bill Haskett
George: If you update a few records in a 2Gb file, isn't the incremental backup going to save the entire 2Gb file? So, your entire database will most likely be saved each time the incremental backup is run. Or is this some kind of imaging backup (I didn't get this from their website).

Re: [U2] Is there any way to tell if I am in an EXECUTE level andCAPTURING is turned on?

2012-06-22 Thread Wjhonson
You can fillet the fish in another manner. If this is a *subroutine* being *called* then why do you also have an Execute going on? If the Execute...Capturing is the only Execute, then just use @LEVEL and for the level in question (say 3) you do this and if it's less than that, you do that.

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread Wjhonson
Don't do it. A must better solution, is to contract with an outside 3rd party, so they can absorb all the liability that comes with ACH processing. Who cares if they charge 35 cents per transaction, its a fair price to pay to avoid all the headaches. -Original Message- From: John

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread David L. Wasylenko
INTERESTING POINT; The work required would be about the same, shifting *some* of the liability / responsibility to a 3rd party is interesting. You would still be responsible for transferring $10,000 instead of $1,000.00 however, if ya miss a MD2/MR2 conversion however! :-) I wonder what the

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread Bill Haskett
Of course, if you run 5,000 transactions in a month (billing) that runs to about $1,750 per month! For a small company that's way too much for a simple computer-to-computer payment system. Then again, technologists often don't seem to understand the value of a dollar (or whatever) unless

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread Wjhonson
The other thing about shifting the responsibility is that generally with ACH you will also get other advantages. Like 24-7 online bill payment for example. And as a side-effect, automatic backup of your bills and billing transactions. -Original Message- From: Bill Haskett

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread Mark Eastwood
We don't use ManFact - but did it for Accounts Payable in our system (instead of sending checks to vendors, transfer via ACH). It's not too difficult - I would suggest you call your Bank and tell them what you want to do (ours was BoA). They were very help with sending layouts etc. The only

Re: [U2] UV Unix File Recovery

2012-06-22 Thread George Gallen
I don't know the method it uses, but if figures out what changed in the file and saves just that part. I have a 300gb partition set for our backups, and it can hold apx 8 months of 20 minute interval diff checks Granted, that figure would depend on the size of your database files (I'm not

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread Wjhonson
And factor on the other side, laying off one payment / receivables / data entry clerk and all the HR expenses of one position. -Original Message- From: David L. Wasylenko d...@pickpro.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 9:48 am Subject: Re:

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread Israel, John R.
I agree! Think of this: you spend all the time and effort to re-invent the wheel (that a 3rd party should already do very well). A year down the road, something goes wrong. You are now in a crisis to get paychecks out on time with code that you are not familiar with. If you think a problem

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread John Varney
I like the idea of a 3rd party but it isn't feasible due to the CFO being a penny-pincher. We DO use an outside firm for payroll, and I'd advise against trying to do that processing in house. Essentially we're just paying vendors and bolting this functionality onto the AP module. -Original

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread John Varney
Actually no layoffs should occur because of this. Accounting is overworked as it is. :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, June 22, 2012 12:57 PM To: u2-users@listserver.u2ug.org

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread John Varney
I agree with using a 3rd party processor for payroll. Been in the scenario you talked about before and it was NOT fun. This is for AP and will probably be used to pay vendors. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread Wjhonson
If you're only using this for AP then sure. I think it's more typical that ACH questions come up for AR purposes, that's of what I had assumed you were speaking. -Original Message- From: John Varney jvar...@soft-target-tech.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent:

Re: [U2] UV Unix File Recovery

2012-06-22 Thread Bill Haskett
George: Unfortunately, I'm on Windows. I do full backups each day, but the 15Gb backup files shut down the dbms for about 30 minutes each night. We're not a 24/7 shop by any means, but we do span a number of time zones, so our window for backups is about three hours each evening. I've

Re: [U2] UV Unix File Recovery

2012-06-22 Thread George Gallen
Not sure if this would work for you Install a 1000mbs NIC card on your windows machine Do a direct connection to a linux machine (flavor you pick) Share your drive that contains your UV files Use samba to mount a directory on the linux machine to your windows share Then run rdiff-backup on

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread Mark Eastwood
Well, it's been about six years now, and time has a way of making you forget the pain. I do recall some confusion over 'debit' vs 'credit'. If my company would allow it, I would publish the program (it's only about 300 lines), but that's not going to happen. Mark -Original

Re: [U2] UV Unix File Recovery

2012-06-22 Thread Bill Haskett
That's quite a waltz! However, it I can get the girl to lean into me it'd be worth it. :-) I'll play with this concept and maybe I can get something like this running in my dev environment. I do have an extra server I could install linux on. Hmmm...maybe I could even find a linux person

Re: [U2] UV Unix File Recovery

2012-06-22 Thread Horacio Pellegrino
We do *EMC replication manager* for snapshots in Windows and make a backup out of it. It halts IO for 2-4 seconds only. hp On Fri, Jun 22, 2012 at 3:13 PM, Bill Haskett wphask...@advantos.netwrote: George: Unfortunately, I'm on Windows. I do full backups each day, but the 15Gb backup files

Re: [U2] Regarding: UniData dictionaries

2012-06-22 Thread Lunt, Bruce
That did it! It works perfectly. Thanks, Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: Thursday, June 21, 2012 4:28 PM To: U2 Users List Subject: Re: [U2] Regarding: UniData dictionaries

Re: [U2] UV Unix File Recovery

2012-06-22 Thread George Gallen
As long as she doesn't decide to lead... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Friday, June 22, 2012 3:45 PM To: U2 Users List Subject: Re: [U2] UV Unix File Recovery That's quite a

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread Tony Gravagno
From: John Varney I've been tasked with writing a bolt on module to give ManFact the ability to utilize ACH processing. Has anyone done this already? If so, any words of wisdom? Having read the other comments here, I find my approach would still be the same as for everything else. You're

[U2] DICT Whacked in VOC

2012-06-22 Thread Bill Brutzman
DICT got messed up when I was trying to copy a dictionary... when trying to recover a file. Now... list DICT SOH 0 records listed. DICT not found. ED VOC DICT New record. : Q ED DICT SOH Unable to open DICT, not a file in VOC. File name= I did not yet try to stop and restart

Re: [U2] DICT Whacked in VOC

2012-06-22 Thread Wjhonson
Starting and stopping Universe, and rebooting will do nothing to fix your problem. ED VOC SOH (not voc dict) The third line in SOH is a pointer to the dict location generally the VOC entry will read 001 F 002 SOH 003 D_SOH probably your third line is just screwed up, you can edit it and fix

Re: [U2] DICT Whacked in VOC

2012-06-22 Thread David L. Wasylenko
Logging out and back in actually can fix this issue... has for me. You should have a 'DICT' item in your VOC however, THIS from my main account CT MD DICT DICT 0001 K 0002 20 And this from my 'UV' account: CT MD DICT DICT 0001 Keyword - Specify the dictionary (distinct from the data)

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread Bill Haskett
G-man: NACHA isn't a client/server framework. It's more of a file-formatting framework; like tab-delimited, CSV, XML. So it's, perhaps, inappropriate to apply a client/server analysis to a file-formatting problem. One of the main challenges with NACHA processing is the file has to get to

Re: [U2] DICT Whacked in VOC

2012-06-22 Thread Susan Lynch
If you have another account, logto it and check to see what VOC DICT looks like, then set a pointer to the VOC in which DICT got damaged, and copy the correct VOC DICT to the VOC with the damaged record. Susan Lynch F. W. Davison Company, Inc. - Original Message - From: Bill

Re: [U2] DICT Whacked

2012-06-22 Thread Bill Brutzman
ReBooting HP-Ux did NOT fix the problem. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UV Unix File Recovery

2012-06-22 Thread Wols Lists
On 22/06/12 20:13, Bill Haskett wrote: George: Unfortunately, I'm on Windows. I do full backups each day, but the 15Gb backup files shut down the dbms for about 30 minutes each night. We're not a 24/7 shop by any means, but we do span a number of time zones, so our window for backups is

Re: [U2] DICT Whacked

2012-06-22 Thread Wjhonson
Funny stuff. Dict should be keyword 20 DICT 001 K 002 20 -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 4:39 pm Subject: Re: [U2] DICT Whacked ReBooting HP-Ux did NOT fix the problem. --Bill

Re: [U2] DICT Whacked in VOC

2012-06-22 Thread Bill Brutzman
Thanks to Susan, David, and Will. I did a LOGTO SAVEBOX.. a somewhat arbitrary account here ED VOC DICT 0001: K 0002: 20 LOGTO METAL ED VOC DICT ... and I just inserted these two keyword lines back in to my main METAL account... and Victory. --Bill

Re: [U2] ACH Functionality in ManFact

2012-06-22 Thread Robert
Not that long ago I had to modify a piece of software that I wrote for a client (SEND-STERLING-TRANS) to create a NACHA-format ACH file to be sent to CHASE BANK. I found out that there were variations to the file format on the internet, so make sure that you get the exact specs for your