[U2] XMAPAppendRec, XMAPToXMLDoc and nested (child) tables
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 place this in the xml doc. If the zip codes are different, the descriptions come through fine and the xml looks exactly as I expect. If the zip codes are the same then the description is correctly placed on the first parent record but does not appear for the second. Below is an example of what the xml should and and then what it does look like. Different Zip Codes (SuburbName is correctly display on both): ArrayOfPerson PersonDetails PersonId=X1General Title=MR Gender=J Surname=BAUER ZipCode= SuburbName=SUBURB 1// PersonDetails PersonDetails PersonId=X2General Title=MR Gender=H Surname=POTTER ZipCode= SuburbName=SUBURB 2// PersonDetails /ArrayOfPerson Same Zip Codes (SuburbName is only displayed for the first person): ArrayOfPerson PersonDetails PersonId=X1General Title=MR Gender=J Surname=BAUER ZipCode= SuburbName=SUBURB 1// PersonDetails PersonDetails PersonId=X2General Title=MR Gender=H Surname=POTTER ZipCode=// PersonDetails /ArrayOfPerson Has anyone experienced this issue and/or has any suggestions to get this to work correctly? Thanks, Saffa -- View this message in context: http://old.nabble.com/XMAPAppendRec%2C-XMAPToXMLDoc-and-nested-%28child%29-tables-tp34054174p34054174.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is there any way to tell if I am in an EXECUTE level andCAPTURING is turned on?
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 will just fix the problems when they come up. Thanks everyone for their input. Doug -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: Thursday, June 21, 2012 5:22 PM To: U2 Users List Subject: Re: [U2] Is there any way to tell if I am in an EXECUTE level andCAPTURING is turned on? universe or unidata? I don't have a full answer either way, but I seem to recall that unidata holds CAPTURING output in a temporary file. Maybe that file can be checked for. On Jun 21, 2012, at 10:08 AM, Doug Farmer wrote: I just had a situation where a program was printing an error message and waiting for the user to respond by pressing Enter. But, the program was being executed by another program using the CAPTURING option. Is there any way someone knows of to tell if the CAPTURING option is on? If so, I can write the error message to a log file instead of displaying it and waiting for a response. I looked at all the SYSTEM(xx) options and do not see anything there. Thanks in Advance Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ 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 Click https://www.mailcontrol.com/sr/ZHJSQLX+SpPTndxI!oX7Us7Qlo!t9IHt4WE2DA5Hj !kWNSr8qrt6LXg6vr6+3RaGatMIqsrnApW1yubdBaCdqw== to report this email as spam. This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] ACH Functionality in ManFact
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Unix File Recovery
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). Thanks, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/21/2012 8:20 PM *Subject:* Re: [U2] UV Unix File Recovery From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists [antli...@youngman.org.uk] Sent: Thursday, June 21, 2012 6:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV Unix File Recovery On 21/06/12 16:53, George Gallen wrote: We use rdiff-backup for onsite backups, it creates a mirror and keeps differential for Restoring to specific backup date images (although that is a file by file). How easy is it to get back to any particular date? Disk space is cheap (though network bandwidth isn't, if big files get modified). Not saying my way is better, but it gives the appearance of multiple full backups, while only doing an incremental copy. http://www.nongnu.org/rdiff-backup/ Multiple full backups would only occur if you used a backup method to backup the mirror, (excepting the directory which holds the incremental files). To restore a file, you can specify an exact date/time or an estimated date (ie. 3d ago) It also has a pruning utility if you need to free up disk space, by deleteing older incrmental info It actually does a fairly good job at only saving the changes, even to big files. We run our nightly backups off the mirror And update the mirror every 20 minutes - except while the backup runs Yup - on the main server itself, I'd probably run mirrored disks, break the mirror to do the backup, and then resync the mirror. In my case, I don't break the mirror, as it's not a real time mirror, it's an every 20 minute mirror. When I run my tape backup on the mirror, I disable the every 20 minute run until it's done, then restart the mirroring. The mirror can be on the same system, SAN or another network Hmmm... If you can network the mirror, could you mirror it onto that self-same linux box? Mirror the live disk onto the linux box, break the mirror to do a local (probably cross-drive) backup, then resume the mirror. Rinse, repeat, etc. Yup, you can mirror onto itself. Just like tar, you can specify directories to not mirror like the directory that holds the mirror, and anything else you don't want mirrored. Rdiff-backup I believe will work between a linux box and windows Do you really want to spend loads of money on a Windows system just to provide a cheap back-up server? And if the main server is hp-ux, it's easier to keep everything within the nix family. Personally, I'd prefer *nix to *nix, but I thought the OP was going from Windows UV to *nix UV. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is there any way to tell if I am in an EXECUTE level andCAPTURING is turned on?
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. That would solve the problem without worrying about Capturing at all. -Original Message- From: Doug Farmer dfar...@epicor.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 7:16 am Subject: Re: [U2] Is there any way to tell if I am in an EXECUTE level andCAPTURING is turned on? UniData Looks like there is no easy solution. Messages are shown in a generic ubroutine and I do not want to do a lot of IO or CPU time to determine f CAPTURING is on. The subroutine is called thousands of times a day or a user. For the few times this has happened over the years, I guess will just fix the problems when they come up. Thanks everyone for their input. Doug Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark ent: Thursday, June 21, 2012 5:22 PM o: U2 Users List ubject: Re: [U2] Is there any way to tell if I am in an EXECUTE level ndCAPTURING is turned on? universe or unidata? I don't have a full answer either way, but I seem o recall that unidata holds CAPTURING output in a temporary file. Maybe hat file can be checked for. On Jun 21, 2012, at 10:08 AM, Doug Farmer wrote: I just had a situation where a program was printing an error message and waiting for the user to respond by pressing Enter. But, the program was being executed by another program using the CAPTURING ption. Is there any way someone knows of to tell if the CAPTURING option is n? If so, I can write the error message to a log file instead of displaying it and waiting for a response. I looked at all the SYSTEM(xx) options and do not see anything there. Thanks in Advance Doug This e-mail is for the use of the intended recipient(s) only. If you ave received this e-mail in error, please notify the sender immediately nd then delete it. If you are not the intended recipient, you must not se, disclose or distribute this e-mail without the author's prior ermission. We have taken precautions to minimize the risk of ransmitting software viruses, but we advise you to carry out your own irus checks on any attachment to this message. We cannot accept iability for any loss or damage caused by software viruses. Any views nd/or opinions expressed in this e-mail are of the author only and do ot represent the views of Epicor Software Corporation or any other ompany within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users lick ttps://www.mailcontrol.com/sr/ZHJSQLX+SpPTndxI!oX7Us7Qlo!t9IHt4WE2DA5Hj kWNSr8qrt6LXg6vr6+3RaGatMIqsrnApW1yubdBaCdqw== to report this email as pam. --- This e-mail is for the use of the intended recipient(s) only. If you have eceived this e-mail in error, please notify the sender immediately and then elete it. If you are not the intended recipient, you must not use, disclose or istribute this e-mail without the author's prior permission. We have taken recautions to minimize the risk of transmitting software viruses, but we advise ou to carry out your own virus checks on any attachment to this message. We annot accept liability for any loss or damage caused by software viruses. Any iews and/or opinions expressed in this e-mail are of the author only and do not epresent the views of Epicor Software Corporation or any other company within ts group. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] ACH Functionality in ManFact
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 Varney jvar...@soft-target-tech.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 8:35 am Subject: [U2] ACH Functionality in ManFact I've been tasked with writing a bolt on module to give ManFact the ability o utilize ACH processing. Has anyone done this already? If so, any words of isdom? __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] ACH Functionality in ManFact
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 setup costs, monthly costs etc would be above the $0.35 or so per transaction VS: Adding an umbrella insurance policy for $1,000,000.00 for a hundred bucks a year and going direct if there is such a thing via the banks. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -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 11:09 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ACH Functionality in ManFact 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 Varney jvar...@soft-target-tech.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 8:35 am Subject: [U2] ACH Functionality in ManFact I've been tasked with writing a bolt on module to give ManFact the ability o utilize ACH processing. Has anyone done this already? If so, any words of isdom? __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] ACH Functionality in ManFact
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 it's theirs. :-) Bill - Original Message - *From:* d...@pickpro.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/22/2012 9:18 AM *Subject:* Re: [U2] ACH Functionality in ManFact 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 setup costs, monthly costs etc would be above the $0.35 or so per transaction VS: Adding an umbrella insurance policy for $1,000,000.00 for a hundred bucks a year and going direct if there is such a thing via the banks. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -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 11:09 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ACH Functionality in ManFact 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 Varney jvar...@soft-target-tech.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 8:35 am Subject: [U2] ACH Functionality in ManFact I've been tasked with writing a bolt on module to give ManFact the ability o utilize ACH processing. Has anyone done this already? If so, any words of isdom? __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ACH Functionality in ManFact
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 wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 9:31 am Subject: Re: [U2] ACH Functionality in ManFact Of course, if you run 5,000 transactions in a month (billing) that runs o about $1,750 per month! For a small company that's way too much for simple computer-to-computer payment system. Then again, technologists often don't seem to understand the value of a ollar (or whatever) unless it's theirs. :-) Bill Original Message - From:* d...@pickpro.com To:* U2 Users List u2-users@listserver.u2ug.org Date:* 6/22/2012 9:18 AM Subject:* Re: [U2] ACH Functionality in ManFact INTERESTING POINT; The work required would be about the same, shifting *some* of the liability / esponsibility to a 3rd party is interesting. You would still be responsible for transferring $10,000 instead of $1,000.00 owever, if ya miss a MD2/MR2 conversion however! :-) I wonder what the setup costs, monthly costs etc would be above the $0.35 or o per transaction VS: Adding an umbrella insurance policy for $1,000,000.00 for a hundred bucks a ear and going direct if there is such a thing via the banks. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson Sent: Friday, June 22, 2012 11:09 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ACH Functionality in ManFact Don't do it. A must better solution, is to contract with an outside 3rd party, so they can bsorb all the liability that comes with ACH processing. Who cares if they charge 35 cents per transaction, its a fair price to pay to void all the headaches. -Original Message- From: John Varney jvar...@soft-target-tech.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 8:35 am Subject: [U2] ACH Functionality in ManFact I've been tasked with writing a bolt on module to give ManFact the ability o tilize ACH processing. Has anyone done this already? If so, any words of isdom? __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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 __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] ACH Functionality in ManFact
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 real 'pain' was when testing; they charged us a transaction fee for every test - ouch. Mark -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney Sent: Friday, June 22, 2012 8:07 AM To: 'U2 Users List' Subject: [U2] ACH Functionality in ManFact 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.orgmailto: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] UV Unix File Recovery
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 really sure what our base gb Figure is). It doesn't really impact noticeably our system processing speed either when it runs. It either uses rsynch or a modified version of it to determine the differences between the mirror and the Active file - rsynch is pretty fast also. For unix system, it might already be loaded (Redhat has it preloaded), otherwise it's pretty simple to Install, (does require python to be loaded) Load it up, give it a try It does not replace backups - but it does make for those oops moments for restore a file to it's previous State much faster than pulling tapes, assuming you have the incrementals for the time period you want. But to be honest, I've never actually tracked a large file with minor changes to see how large the Change files are. To help save space, the incremental files are stored in a compressed format, great for UV ASCII data. George -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 12:06 PM To: U2 Users List Subject: Re: [U2] UV Unix File Recovery 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). Thanks, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/21/2012 8:20 PM *Subject:* Re: [U2] UV Unix File Recovery From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists [antli...@youngman.org.uk] Sent: Thursday, June 21, 2012 6:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV Unix File Recovery On 21/06/12 16:53, George Gallen wrote: We use rdiff-backup for onsite backups, it creates a mirror and keeps differential for Restoring to specific backup date images (although that is a file by file). How easy is it to get back to any particular date? Disk space is cheap (though network bandwidth isn't, if big files get modified). Not saying my way is better, but it gives the appearance of multiple full backups, while only doing an incremental copy. http://www.nongnu.org/rdiff-backup/ Multiple full backups would only occur if you used a backup method to backup the mirror, (excepting the directory which holds the incremental files). To restore a file, you can specify an exact date/time or an estimated date (ie. 3d ago) It also has a pruning utility if you need to free up disk space, by deleteing older incrmental info It actually does a fairly good job at only saving the changes, even to big files. We run our nightly backups off the mirror And update the mirror every 20 minutes - except while the backup runs Yup - on the main server itself, I'd probably run mirrored disks, break the mirror to do the backup, and then resync the mirror. In my case, I don't break the mirror, as it's not a real time mirror, it's an every 20 minute mirror. When I run my tape backup on the mirror, I disable the every 20 minute run until it's done, then restart the mirroring. The mirror can be on the same system, SAN or another network Hmmm... If you can network the mirror, could you mirror it onto that self-same linux box? Mirror the live disk onto the linux box, break the mirror to do a local (probably cross-drive) backup, then resume the mirror. Rinse, repeat, etc. Yup, you can mirror onto itself. Just like tar, you can specify directories to not mirror like the directory that holds the mirror, and anything else you don't want mirrored. Rdiff-backup I believe will work between a linux box and windows Do you really want to spend loads of money on a Windows system just to provide a cheap back-up server? And if the main server is hp-ux, it's easier to keep everything within the nix family. Personally, I'd prefer *nix to *nix, but I thought the OP was going from Windows UV to *nix UV. Cheers, Wol ___ 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] ACH Functionality in ManFact
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: [U2] ACH Functionality in ManFact INTERESTING POINT; The work required would be about the same, shifting *some* of the liability / esponsibility to a 3rd party is interesting. ou would still be responsible for transferring $10,000 instead of $1,000.00 owever, if ya miss a MD2/MR2 conversion however! :-) I wonder what the setup costs, monthly costs etc would be above the $0.35 or so er transaction VS: dding an umbrella insurance policy for $1,000,000.00 for a hundred bucks a year nd going direct if there is such a thing via the banks. ... david ... David L. Wasylenko resident, Pick Professionals, Inc ) 314 558 1482 l...@pickpro.com Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Friday, June 22, 2012 11:09 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] ACH Functionality in ManFact on't do it. must better solution, is to contract with an outside 3rd party, so they can bsorb all the liability that comes with ACH processing. ho cares if they charge 35 cents per transaction, its a fair price to pay to void all the headaches. -Original Message- rom: John Varney jvar...@soft-target-tech.com o: 'U2 Users List' u2-users@listserver.u2ug.org ent: Fri, Jun 22, 2012 8:35 am ubject: [U2] ACH Functionality in ManFact 've been tasked with writing a bolt on module to give ManFact the ability o tilize ACH processing. Has anyone done this already? If so, any words of isdom? __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] ACH Functionality in ManFact
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 with Month End is bad, that is NOTHING compared to all the employees not getting their pay check! Think pitchforks and burning torches. Create a simple export and let someone else deal with it. John -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:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ACH Functionality in ManFact 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 Varney jvar...@soft-target-tech.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 8:35 am Subject: [U2] ACH Functionality in ManFact I've been tasked with writing a bolt on module to give ManFact the ability o utilize ACH processing. Has anyone done this already? If so, any words of isdom? __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] ACH Functionality in ManFact
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 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:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ACH Functionality in ManFact 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 Varney jvar...@soft-target-tech.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 8:35 am Subject: [U2] ACH Functionality in ManFact I've been tasked with writing a bolt on module to give ManFact the ability o utilize ACH processing. Has anyone done this already? If so, any words of isdom? __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] ACH Functionality in ManFact
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 Subject: Re: [U2] ACH Functionality in ManFact 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: [U2] ACH Functionality in ManFact INTERESTING POINT; The work required would be about the same, shifting *some* of the liability / esponsibility to a 3rd party is interesting. ou would still be responsible for transferring $10,000 instead of $1,000.00 owever, if ya miss a MD2/MR2 conversion however! :-) I wonder what the setup costs, monthly costs etc would be above the $0.35 or so er transaction VS: dding an umbrella insurance policy for $1,000,000.00 for a hundred bucks a year nd going direct if there is such a thing via the banks. ... david ... David L. Wasylenko resident, Pick Professionals, Inc ) 314 558 1482 l...@pickpro.com Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Friday, June 22, 2012 11:09 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] ACH Functionality in ManFact on't do it. must better solution, is to contract with an outside 3rd party, so they can bsorb all the liability that comes with ACH processing. ho cares if they charge 35 cents per transaction, its a fair price to pay to void all the headaches. -Original Message- rom: John Varney jvar...@soft-target-tech.com o: 'U2 Users List' u2-users@listserver.u2ug.org ent: Fri, Jun 22, 2012 8:35 am ubject: [U2] ACH Functionality in ManFact 've been tasked with writing a bolt on module to give ManFact the ability o tilize ACH processing. Has anyone done this already? If so, any words of isdom? __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] ACH Functionality in ManFact
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 Behalf Of Israel, John R. Sent: Friday, June 22, 2012 1:24 PM To: 'U2 Users List' Subject: Re: [U2] ACH Functionality in ManFact 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 with Month End is bad, that is NOTHING compared to all the employees not getting their pay check! Think pitchforks and burning torches. Create a simple export and let someone else deal with it. John -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:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ACH Functionality in ManFact 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 Varney jvar...@soft-target-tech.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 8:35 am Subject: [U2] ACH Functionality in ManFact I've been tasked with writing a bolt on module to give ManFact the ability o utilize ACH processing. Has anyone done this already? If so, any words of isdom? __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ACH Functionality in ManFact
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: Fri, Jun 22, 2012 11:39 am Subject: Re: [U2] ACH Functionality in ManFact Actually no layoffs should occur because of this. Accounting is overworked s it is. :) -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Friday, June 22, 2012 12:57 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] ACH Functionality in ManFact nd factor on the other side, laying off one payment / receivables / data ntry clerk and all the HR expenses of one position. -Original Message- rom: David L. Wasylenko d...@pickpro.com o: U2 Users List u2-users@listserver.u2ug.org ent: Fri, Jun 22, 2012 9:48 am ubject: Re: [U2] ACH Functionality in ManFact NTERESTING POINT; he work required would be about the same, shifting *some* of the liability sponsibility to a 3rd party is interesting. u would still be responsible for transferring $10,000 instead of $1,000.00 wever, if ya miss a MD2/MR2 conversion however! :-) wonder what the setup costs, monthly costs etc would be above the $0.35 or o r transaction VS: ding an umbrella insurance policy for $1,000,000.00 for a hundred bucks a ear d going direct if there is such a thing via the banks. .. david ... avid L. Wasylenko esident, Pick Professionals, Inc 314 558 1482 w...@pickpro.com Original Message- om: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] Behalf Of Wjhonson nt: Friday, June 22, 2012 11:09 AM : u2-users@listserver.u2ug.org bject: Re: [U2] ACH Functionality in ManFact on't do it. must better solution, is to contract with an outside 3rd party, so they can bsorb all the liability that comes with ACH processing. o cares if they charge 35 cents per transaction, its a fair price to pay to void all the headaches. -Original Message- om: John Varney jvar...@soft-target-tech.com : 'U2 Users List' u2-users@listserver.u2ug.org nt: Fri, Jun 22, 2012 8:35 am bject: [U2] ACH Functionality in ManFact 've been tasked with writing a bolt on module to give ManFact the ability o ilize ACH processing. Has anyone done this already? If so, any words of sdom? _ Users mailing list us...@listserver.u2ug.org p://listserver.u2ug.org/mailman/listinfo/u2-users __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] UV Unix File Recovery
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 always wanted to use something simple but can't find anything. One would think your backup method (mirrors, breaking them, backing up the mirror, then re-syncing) would be part of the U2 admin guide (or be on some wiki). I do this with a couple of simple Windows scripts, but it's strickly a full backup operation with no mirrors. I did have to change the scripts and the method of implementation for Windows 2008 R2 from previous windows using ntbackup. Thanks, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/22/2012 9:39 AM *Subject:* Re: [U2] UV Unix File Recovery 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 really sure what our base gb Figure is). It doesn't really impact noticeably our system processing speed either when it runs. It either uses rsynch or a modified version of it to determine the differences between the mirror and the Active file - rsynch is pretty fast also. For unix system, it might already be loaded (Redhat has it preloaded), otherwise it's pretty simple to Install, (does require python to be loaded) Load it up, give it a try It does not replace backups - but it does make for those oops moments for restore a file to it's previous State much faster than pulling tapes, assuming you have the incrementals for the time period you want. But to be honest, I've never actually tracked a large file with minor changes to see how large the Change files are. To help save space, the incremental files are stored in a compressed format, great for UV ASCII data. George -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 12:06 PM To: U2 Users List Subject: Re: [U2] UV Unix File Recovery 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). Thanks, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/21/2012 8:20 PM *Subject:* Re: [U2] UV Unix File Recovery From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists [antli...@youngman.org.uk] Sent: Thursday, June 21, 2012 6:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV Unix File Recovery On 21/06/12 16:53, George Gallen wrote: We use rdiff-backup for onsite backups, it creates a mirror and keeps differential for Restoring to specific backup date images (although that is a file by file). How easy is it to get back to any particular date? Disk space is cheap (though network bandwidth isn't, if big files get modified). Not saying my way is better, but it gives the appearance of multiple full backups, while only doing an incremental copy. http://www.nongnu.org/rdiff-backup/ Multiple full backups would only occur if you used a backup method to backup the mirror, (excepting the directory which holds the incremental files). To restore a file, you can specify an exact date/time or an estimated date (ie. 3d ago) It also has a pruning utility if you need to free up disk space, by deleteing older incrmental info It actually does a fairly good job at only saving the changes, even to big files. We run our nightly backups off the mirror And update the mirror every 20 minutes - except while the backup runs Yup - on the main server itself, I'd probably run mirrored disks, break the mirror to do the backup, and then resync the mirror. In my case, I don't break the mirror, as it's not a real time mirror, it's an every 20 minute mirror. When I run my tape backup on the mirror, I disable the every 20 minute run until it's done, then restart the mirroring. The mirror can be on the same system, SAN or another network Hmmm... If you can network the mirror, could you mirror it onto that self-same linux box? Mirror the live disk onto the linux box, break the mirror to do a local (probably cross-drive) backup, then
Re: [U2] UV Unix File Recovery
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 the linux machine to mirror from the mount directory To a directory on the linux machine I have my rdiff-backup script check a lock file before running (if it exists, It won't run). If you can modify your windows backup script to create a file Prior to running, and delete it after it's done. You could use that as lock File to stop rdiff from attempting to mirror while your backup is running. We run the backup every 20 min against the live files. Occaisionally I will see A message that the file changed while it was mirroring (it uses the prechange for It's mirror), but I yet to have any file corruption because of it. -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:14 PM To: U2 Users List Subject: Re: [U2] UV Unix File Recovery 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 always wanted to use something simple but can't find anything. One would think your backup method (mirrors, breaking them, backing up the mirror, then re-syncing) would be part of the U2 admin guide (or be on some wiki). I do this with a couple of simple Windows scripts, but it's strickly a full backup operation with no mirrors. I did have to change the scripts and the method of implementation for Windows 2008 R2 from previous windows using ntbackup. Thanks, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/22/2012 9:39 AM *Subject:* Re: [U2] UV Unix File Recovery 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 really sure what our base gb Figure is). It doesn't really impact noticeably our system processing speed either when it runs. It either uses rsynch or a modified version of it to determine the differences between the mirror and the Active file - rsynch is pretty fast also. For unix system, it might already be loaded (Redhat has it preloaded), otherwise it's pretty simple to Install, (does require python to be loaded) Load it up, give it a try It does not replace backups - but it does make for those oops moments for restore a file to it's previous State much faster than pulling tapes, assuming you have the incrementals for the time period you want. But to be honest, I've never actually tracked a large file with minor changes to see how large the Change files are. To help save space, the incremental files are stored in a compressed format, great for UV ASCII data. George -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 12:06 PM To: U2 Users List Subject: Re: [U2] UV Unix File Recovery 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). Thanks, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/21/2012 8:20 PM *Subject:* Re: [U2] UV Unix File Recovery From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists [antli...@youngman.org.uk] Sent: Thursday, June 21, 2012 6:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV Unix File Recovery On 21/06/12 16:53, George Gallen wrote: We use rdiff-backup for onsite backups, it creates a mirror and keeps differential for Restoring to specific backup date images (although that is a file by file). How easy is it to get back to any particular date? Disk space is cheap (though network bandwidth isn't, if big files get modified). Not saying my way is better, but it gives the appearance of multiple full backups, while only doing an incremental copy. http://www.nongnu.org/rdiff-backup/
Re: [U2] ACH Functionality in ManFact
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 Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney Sent: Friday, June 22, 2012 11:07 AM To: 'U2 Users List' Subject: Re: [U2] ACH Functionality in ManFact That's pretty much what we're doing here. I've talked to the bank and have their specifications in hand. Did you run into any issues while setting this up? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Unix File Recovery
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 to help out. :-) Thanks, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/22/2012 12:33 PM *Subject:* Re: [U2] UV Unix File Recovery 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 the linux machine to mirror from the mount directory To a directory on the linux machine I have my rdiff-backup script check a lock file before running (if it exists, It won't run). If you can modify your windows backup script to create a file Prior to running, and delete it after it's done. You could use that as lock File to stop rdiff from attempting to mirror while your backup is running. We run the backup every 20 min against the live files. Occaisionally I will see A message that the file changed while it was mirroring (it uses the prechange for It's mirror), but I yet to have any file corruption because of it. -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:14 PM To: U2 Users List Subject: Re: [U2] UV Unix File Recovery 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 always wanted to use something simple but can't find anything. One would think your backup method (mirrors, breaking them, backing up the mirror, then re-syncing) would be part of the U2 admin guide (or be on some wiki). I do this with a couple of simple Windows scripts, but it's strickly a full backup operation with no mirrors. I did have to change the scripts and the method of implementation for Windows 2008 R2 from previous windows using ntbackup. Thanks, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/22/2012 9:39 AM *Subject:* Re: [U2] UV Unix File Recovery 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 really sure what our base gb Figure is). It doesn't really impact noticeably our system processing speed either when it runs. It either uses rsynch or a modified version of it to determine the differences between the mirror and the Active file - rsynch is pretty fast also. For unix system, it might already be loaded (Redhat has it preloaded), otherwise it's pretty simple to Install, (does require python to be loaded) Load it up, give it a try It does not replace backups - but it does make for those oops moments for restore a file to it's previous State much faster than pulling tapes, assuming you have the incrementals for the time period you want. But to be honest, I've never actually tracked a large file with minor changes to see how large the Change files are. To help save space, the incremental files are stored in a compressed format, great for UV ASCII data. George -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 12:06 PM To: U2 Users List Subject: Re: [U2] UV Unix File Recovery 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). Thanks, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/21/2012 8:20 PM *Subject:* Re: [U2] UV Unix File Recovery From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists [antli...@youngman.org.uk] Sent: Thursday, June 21, 2012 6:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2]
Re: [U2] UV Unix File Recovery
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 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 always wanted to use something simple but can't find anything. One would think your backup method (mirrors, breaking them, backing up the mirror, then re-syncing) would be part of the U2 admin guide (or be on some wiki). I do this with a couple of simple Windows scripts, but it's strickly a full backup operation with no mirrors. I did have to change the scripts and the method of implementation for Windows 2008 R2 from previous windows using ntbackup. Thanks, Bill --**--** - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/22/2012 9:39 AM *Subject:* Re: [U2] UV Unix File Recovery 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 really sure what our base gb Figure is). It doesn't really impact noticeably our system processing speed either when it runs. It either uses rsynch or a modified version of it to determine the differences between the mirror and the Active file - rsynch is pretty fast also. For unix system, it might already be loaded (Redhat has it preloaded), otherwise it's pretty simple to Install, (does require python to be loaded) Load it up, give it a try It does not replace backups - but it does make for those oops moments for restore a file to it's previous State much faster than pulling tapes, assuming you have the incrementals for the time period you want. But to be honest, I've never actually tracked a large file with minor changes to see how large the Change files are. To help save space, the incremental files are stored in a compressed format, great for UV ASCII data. George -Original Message- From: u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org[mailto: u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Friday, June 22, 2012 12:06 PM To: U2 Users List Subject: Re: [U2] UV Unix File Recovery 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). Thanks, Bill --**--** - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/21/2012 8:20 PM *Subject:* Re: [U2] UV Unix File Recovery From: u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org[ u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists [antli...@youngman.org.uk] Sent: Thursday, June 21, 2012 6:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV Unix File Recovery On 21/06/12 16:53, George Gallen wrote: We use rdiff-backup for onsite backups, it creates a mirror and keeps differential for Restoring to specific backup date images (although that is a file by file). How easy is it to get back to any particular date? Disk space is cheap (though network bandwidth isn't, if big files get modified). Not saying my way is better, but it gives the appearance of multiple full backups, while only doing an incremental copy. http://www.nongnu.org/rdiff-**backup/http://www.nongnu.org/rdiff-backup/ Multiple full backups would only occur if you used a backup method to backup the mirror, (excepting the directory which holds the incremental files). To restore a file, you can specify an exact date/time or an estimated date (ie. 3d ago) It also has a pruning utility if you need to free up disk space, by deleteing older incrmental info It actually does a fairly good job at only saving the changes, even to big files. We run our nightly backups off the mirror And update the mirror every 20 minutes - except while the backup runs Yup - on the main server itself, I'd probably run mirrored disks, break the mirror to do the backup, and then resync the mirror. In my case, I don't break the mirror, as
Re: [U2] Regarding: UniData dictionaries
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 /DIALOG.DEFN and create one called FRED with text along the lines of:- Your file has been output to (@WORK1) In your routine, set @WORK1 to the path name and CALL SB.PROCESS(DIALOG,FRED) Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko Sent: 22 June 2012 00:10 To: U2 Users List Subject: Re: [U2] Regarding: UniData dictionaries I know nothing of 'SB.DISP()', however, try replacing '\' with '\\' and give it a go. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Thursday, June 21, 2012 6:11 PM To: 'U2 Users List' Subject: Re: [U2] Regarding: UniData dictionaries I could do that but I want to avoid confusing them with C:/WINDOWS/TEMP. They will try that and when it doesn't work for them they will call me. :-( I was playing around with just replacing the backslashes with spaces. I was hoping for better, though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Thursday, June 21, 2012 2:05 PM To: U2 Users List Subject: Re: [U2] Regarding: Unidata dictionaries I used to replace the backslashes with a different character for display in the dialog box. Usually a fwd slash. SB use the backslash as a delimiter in the Disp process. From: Lunt, Bruce Sent: 22-Jun-12 4:25 To: 'U2 Users List' Subject: Re: [U2] Regarding: Unidata dictionaries I have just come across a problem that is sort of related to the problem with UniQuery and single quotes noted in Dan's article. I thought that I would share what is happening to see if there is an answer. We are using Unidata 7.1 and SB+ 5.3. I have written a Basic program to extract a file and when it finishes I will either display the error message or if it was successful I want to print a message that tells them that they can find their file at C:\WINDOWS\TEMP\filename.xml. The method that I use for displaying the messages is CALL SB.DISP(4,message here). When I run the job it does not display the message but if I remove the '\' characters it works fine. Is there some way to get this message to display without removing the '\' characters? I find it very interesting that I have never seen this problem before and then the very next day after reading the article by Dan McGrath it happens to me. Thanks in advance, Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, June 20, 2012 12:25 PM To: U2 Users List Subject: Re: [U2] Regarding: Unidata dictionaries Satya, I have a small write up I did a while ago that might help you: http://u2tech.wordpress.com/tips-hints/dictionary-tips-hints/ Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: Wednesday, June 20, 2012 10:18 AM To: U2 Users List Subject: [U2] Regarding: Unidata dictionaries Hi, Could you let,me know what is the difference between PH- type records, D-type records,V-type records,X-type records Thank you, Satya ___ 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 ___ 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 Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== KOMxE87tyjDC5pJ+Oc0KV8DcaCAs2RChX!bd8XIx2vetQ== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London
Re: [U2] UV Unix File Recovery
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 waltz! However, it I can get the girl to lean into me it'd be worth it. :-) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ACH Functionality in ManFact
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 working with a database. Don't try to turn it into an ACH client or server or anything else. There are a wealth of tools out there for doing ACH (Google ach software). People spend a lot of time to make that technology works, and you don't need to reinvent the wheel, especially since you're not an ACH expert and those other developers are. (Same words apply to anything, whether TAPI, SAPI, XML, ECommerce, Faxing, Emailing, weight scales, and all kinds of other things that people want to do with MV.) Find a utility or service that matches your skillset in terms of writing client-side queries, and call from your app to that. If you later find you need to do something else, your back-end remains relatively unchanged and you just need to swap out the middle tier. Trust me, as many of you focus on inventory management or GAAP, I've been specializing in communications and interfaces between MV and anything else for about the last 15 years. I've written inbound/outbound socket routines, used cURL for web calls, many languages and protocols, and I've dabbled with just about every communications pipe in this industry. For every how do I do 'this' with MV, these days there is a better reason Not to do it with MV, but to use other people's software that is much more rigorous than anything that we could come up with. Our solutions for 'this' will always be inadequate compared to something else that's out there. That's not a statement of the quality of our work but the sheer time and money and knowledge that we can throw into some of these things compared to other people who live and breathe this stuff. Will you pay for third-party solutions? Maybe. If you get FOSS then you'll pay with your time but you may save some effort. If you pay for a service then They will focus on things like regulatory issues, security, and changes in the industry. When your ProjectX is done, will You have the time for things like that? No, we generally need to move on to the next ProjectY. For this reason, in the long run it may cost less to 'buy' than to 'make' as they say in the manufacturing industry. http://Nebula-RnD.com/blog/tech/mv/2009/08/mv-to-anything.html HTH T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] DICT Whacked in VOC
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 UniVerse. Also, I did not try to reboot the HP-Ux host. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DICT Whacked in VOC
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 the entry. -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 3:32 pm Subject: [U2] DICT Whacked in VOC DICT got messed up when I was trying to copy a dictionary... when trying to ecover a file. Now... list DICT SOH 0 records listed. DICT not found. ED VOC DICT ew record. : Q ED DICT SOH nable to open DICT, not a file in VOC. ile name= I did not yet try to stop and restart UniVerse. Also, I did not try to reboot the HP-Ux host. Suggestions would be appreciated. --Bill __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] DICT Whacked in VOC
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) part of a file 0002 20 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -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 5:39 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DICT Whacked in VOC 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 the entry. -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 3:32 pm Subject: [U2] DICT Whacked in VOC DICT got messed up when I was trying to copy a dictionary... when trying to ecover a file. Now... list DICT SOH 0 records listed. DICT not found. ED VOC DICT ew record. : Q ED DICT SOH nable to open DICT, not a file in VOC. ile name= I did not yet try to stop and restart UniVerse. Also, I did not try to reboot the HP-Ux host. Suggestions would be appreciated. --Bill __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] ACH Functionality in ManFact
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 the file-processor. The banking system, generally, is the recipient of the file; so most activity goes through them. Therefore, it is the company's banking relationship that determines how and where the NACHA file is delivered. Again, client/server analytics are ineffective for this issue; which is usually no more than drag'n drop, or upload the file to a web page with an input type='file' textbox. So, you see, the first issue with the process is creating the file (which is the easiest) and the second is how to deliver it to the bank. Many banks have different ways to transmit the file, so for one bank a textbox upload is fine, but for another it's not. :-(The software has to adjust (which makes integration difficult), but it can integrate the file creation because a NACHA file has a standard format. Using someone else for ACH requires your data be replicated elsewhere. This can be automated but it all depends on your banking relationship and presents all of the problems associated with distributing data to disparate systems (it takes more time, money, aggravation, etc). :-) HTH, Bill Untitled Page - Original Message - *From:* 3xk547...@sneakemail.com *To:* u2-users@listserver.u2ug.org *Date:* 6/22/2012 2:16 PM *Subject:* Re: [U2] ACH Functionality in ManFact 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 working with a database. Don't try to turn it into an ACH client or server or anything else. There are a wealth of tools out there for doing ACH (Google ach software). People spend a lot of time to make that technology works, and you don't need to reinvent the wheel, especially since you're not an ACH expert and those other developers are. (Same words apply to anything, whether TAPI, SAPI, XML, ECommerce, Faxing, Emailing, weight scales, and all kinds of other things that people want to do with MV.) Find a utility or service that matches your skillset in terms of writing client-side queries, and call from your app to that. If you later find you need to do something else, your back-end remains relatively unchanged and you just need to swap out the middle tier. Trust me, as many of you focus on inventory management or GAAP, I've been specializing in communications and interfaces between MV and anything else for about the last 15 years. I've written inbound/outbound socket routines, used cURL for web calls, many languages and protocols, and I've dabbled with just about every communications pipe in this industry. For every how do I do 'this' with MV, these days there is a better reason Not to do it with MV, but to use other people's software that is much more rigorous than anything that we could come up with. Our solutions for 'this' will always be inadequate compared to something else that's out there. That's not a statement of the quality of our work but the sheer time and money and knowledge that we can throw into some of these things compared to other people who live and breathe this stuff. Will you pay for third-party solutions? Maybe. If you get FOSS then you'll pay with your time but you may save some effort. If you pay for a service then They will focus on things like regulatory issues, security, and changes in the industry. When your ProjectX is done, will You have the time for things like that? No, we generally need to move on to the next ProjectY. For this reason, in the long run it may cost less to 'buy' than to 'make' as they say in the manufacturing industry. http://Nebula-RnD.com/blog/tech/mv/2009/08/mv-to-anything.html HTH T ___ 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] DICT Whacked in VOC
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 Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: 06/22/2012 6:03 PM Subject: [U2] DICT Whacked in VOC 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 UniVerse. Also, I did not try to reboot the HP-Ux host. Suggestions would be appreciated. --Bill ___ 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] DICT Whacked
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
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 about three hours each evening. I've always wanted to use something simple but can't find anything. One would think your backup method (mirrors, breaking them, backing up the mirror, then re-syncing) would be part of the U2 admin guide (or be on some wiki). I do this with a couple of simple Windows scripts, but it's strickly a full backup operation with no mirrors. I did have to change the scripts and the method of implementation for Windows 2008 R2 from previous windows using ntbackup. Sounds like you want proper mirrored disks on your server. dbpause, break mirror, dbresume. Then you can back up the broken mirror at your leisure before resuming the mirror. Your database won't even be down a moment. As for minor changes to a 2Gb file, that's where btrfs would come in handy. It's a copy on write filesystem, so when you change a file it only updates the bits that have changed. And it cascades those changes up the hierarchy, so that if you snapshot the file system, it will archive the then-root of the filesystem. All new changes go to a new root. Only thing is, if you want to get back to a previous state of the filesystem (ie retrieve a backup), I understand it's a reboot. But if you had the true mirror on your server, you could run an infinite loop of dbpause, break mirror, dbresume, rsync broken mirror to linux btrfs, snapshot btrfs and restore mirror, wait for mirror to resync, rinse and repeat. It would take an awfully long time to fill up the linux backup server's disk... (rsync is the unix command that will sync two file systems, and it's very good at only updating the parts of files that have changed). Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DICT Whacked
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 __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] DICT Whacked in VOC
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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ACH Functionality in ManFact
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 project. I have a few PDF documents pertaining the layouts and the specs. Do you have the specs? Robert Norman ROBERT NORMAN AND ASSOCIATES Address: 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 USA Phone : (951) 541-1668 Email : i...@keyway.net Website: http://users.keyway.net/~ice/ [Affordable UNIVERSE programming services for PICK/BASIC, DATA/BASIC, UniVerse Basic, UniBasic, R/BASIC, jBC] Here are the John Varney wrote: 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 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