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

[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 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):





Same Zip Codes (SuburbName is only displayed for the first person):





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?

[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 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

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

Re: [U2] UV Unix File Recovery

[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).


Thanks,

Bill


- Original Message -
*From:* ggal...@wyanokegroup.com
*To:* U2 Users List 
*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?

[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.  That would solve the problem without worrying about Capturing at all.



-Original Message-
From: Doug Farmer 
To: U2 Users List 
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

[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 Varney 
To: 'U2 Users List' 
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

[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 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 
To: 'U2 Users List' 
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

[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 it's theirs.  :-)


Bill


- Original Message -
*From:* d...@pickpro.com
*To:* U2 Users List 
*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 
To: 'U2 Users List' 
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

[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 
To: U2 Users List 
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 
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 
 To: 'U2 Users List' 
 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

[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 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.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

[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 
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 
*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

[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 
To: U2 Users List 
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 
o: 'U2 Users List' 
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

[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 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 
To: 'U2 Users List' 
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

[John Varney]

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?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
Sent: Friday, June 22, 2012 12:38 PM
To: 'U2 Users List'
Subject: 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.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

[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 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 
To: 'U2 Users List' 
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

[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
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 
To: U2 Users List 
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 
o: 'U2 Users List' 
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

[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 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 
To: 'U2 Users List' 
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

[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 
To: 'U2 Users List' 
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 
o: U2 Users List 
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 
: 'U2 Users List' 
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

[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 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 
*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 
*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, y

Re: [U2] UV Unix File Recovery

[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 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 
*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 
> *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.
>>

Re: [U2] ACH Functionality in ManFact

[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 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

[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 to help 
out.  :-)


Thanks,

Bill


- Original Message -
*From:* ggal...@wyanokegroup.com
*To:* U2 Users List 
*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 
*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 
*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

Re: [U2] UV Unix File Recovery

[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 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".
>
> Thanks,
>
> Bill
>
> --**--**
> 
> - Original Message -
> *From:* ggal...@wyanokegroup.com
> *To:* U2 Users List 
> *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.org[mailto:
>> u2-users-bounces@**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 
>> *Date:* 6/21/2012 8:20 PM
>> *Subject:* Re: [U2] UV Unix File Recovery
>>
>>> From: 
>>> u2-users-bounces@listserver.**u2ug.org[
>>> u2-users-bounces@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, an

Re: [U2] Regarding: UniData dictionaries

[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

/DIALOG.DEFN and create one called FRED with text along the lines of:- Your
file has been output to (@WORK<1>)


In your routine, set @WORK<1> 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

Re: [U2] ACH Functionality in ManFact

[Bill Haskett]

NACHA is a fairly straight-forward process that is easily managed once 
set up between a company and their bank.  I am consistently surprised 
with the misconceptions about this process.  NACHA is a file format that 
allows funds transfers from one banking institution to another.  The 
file goes through a "clearing house" which moves the funds from one bank 
account to another with 24 hours.  As an example, "Direct Deposit" uses 
a NACHA formatted file to transfer money from a company's bank account 
to the multiple bank accounts of its employees.  When one looks more 
closely, most of the Accounts Payable direct payments by banks are 
nothing more than the bank printing a check and letting the check travel 
through the previously tested, stable, and error free environment of the 
banking system check-clearing system.


It is a long and arduous process for the banking system to process a 
paper check.  To pay a bill, a paper check needs to be issued and 
delivered.  This paper check would then need to be physically attached 
to a deposit ticket for the recipient and taken to the bank.  The bank 
would run this check through their system and the MICR would be read and 
funds would be transferred from the bank of the check to the bank of the 
deposit.  All of this time and effort (at the guts level of processing) 
is bypassed via a NACHA formatted file, which makes NACHA a 
significantly cheaper process.


As customers understand that a bank is overcharging for NACHA 
processing, the price will come down.  If the price doesn't come down 
(the banks are a monopoly in this area), then customers will be trying 
other methods of funds transfers, which are more insecure, unstable, 
costly, and time-consuming.


Remember, if there are 5,000 item brought into billing, someone had to 
write that check, mail or deliver it, it had to be posted by hand into 
your system, attached to a deposit ticket, taken to the bank, the bank 
has to process it, deliver it to a processing center, it's processed 
there, and returned to the sending bank, where it is either scanned or 
returned to the original issuer. All this is resolved by a single NACHA 
file with 5,000 lines in it (well...maybe 5,008 lines).  Why would the 
first method be free to the bank but the second method cost $.35/line or 
$1,750.  From this perspective I'd think we would all be outraged with 
those greedy bankers, who are not much more than puppets for the Feds 
these days.  :-)


...just a few thoughts.  :-)

Bill


- Original Message -
*From:* jvar...@soft-target-tech.com
*To:* 'U2 Users List' 
*Date:* 6/22/2012 11:06 AM
*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?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
Sent: Friday, June 22, 2012 12:38 PM
To: 'U2 Users List'
Subject: 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.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UV Unix File Recovery

[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 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

[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 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

[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 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

[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 the entry.



-Original Message-
From: Bill Brutzman 
To: U2 Users List 
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

[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) 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 
To: U2 Users List 
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

[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 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 "" 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

[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 Brutzman" 

To: "U2 Users List" 
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

[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

[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 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

[Wjhonson]

Funny stuff.
Dict should be keyword 20

DICT
001 K
002 20





-Original Message-
From: Bill Brutzman 
To: U2 Users List 
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

[Wjhonson]

By the way, these are all stored as well in the NEWACC file





-Original Message-
From: Bill Brutzman 
To: U2 Users List 
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

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

Re: [U2] ACH Functionality in ManFact

[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 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