| Author |
Automatic Audit Trail Utility?
|
|
| rmccallion@yahoo.com 2005-01-13, 8:55 pm |
| Is anyone aware of any 3rd party utilities that can be linked into a
Clipper app (dbf backend) to give an automatic audit trail? It would
be wonderful if there was a RDD or something similiar that I could link
into the application and not have to change too much code.
Any ideas?
Thanks,
Rick
| |
|
| When I think of an audit trail it reminds me of something we did on the
mainframes. That being said, I would love to add a rock solid audit
trail to the Oil and Gas Land system that I sell. I can't imagine any
"automated" audit trail to any computer system. A good audit trail will
expose lost records, fraud, data entry errors...
I wish I could get into more detail but I have seen entire books
dedicated to the subject. It is more than record counts!
Mike
| |
| Al Acker 2005-01-13, 8:55 pm |
| Stephen,
That product came out of South Africa... it's long gone now.. I'm sure I
have a copy as I've got a copy of just about every Clipper product ever
created.... but it's buried pretty deep and I couldn't legally give it to
you if I found it <g>..
If you use a class for your table updates or use a common function for all
table edits / saves etc..... it's pretty simple to add in an audit trail.
Al
--
Al Acker, President
Acker Consulting, Inc.
mailto:al@thexbasefiles.com
http://www.ackerconsulting.com
"Stephen Quinn" <steveqNOSPAM@integritynet.com.au> wrote in message
news:34gl9vF493qe0U1@individual.net...
> Rick
>
> There was a package called RDDKit that comprised of 6 RDDs one of which
> (IIRC -
> Journal) allowed you to code something like that.
>
> I have no idea where you'd get it now.
>
> --
> HTH
> Steve
>
>
| |
| Matt Whelan 2005-01-14, 3:55 pm |
| Hey Al,
> That product came out of South Africa... it's long gone now..
If you could track down Russell Stromin he might give one away . . .
> have a copy as I've got a copy of just about every Clipper product ever
> created....
I threw an RDD Kit and a stack of other third-party stuff away recently.
Should have waited.
> but it's buried pretty deep
Buried just as deep somewhere here I have source for a DBFMDX RDD with
transactions that could be made to do journalling pretty easily. :-)
> and I couldn't legally give it to you if I found it <g>..
Oh, yeah, there's always that problem.
-Matt
| |
| Al Acker 2005-01-14, 3:55 pm |
| Hi Matt,
Haven't heard from Russ in a huge amount of time... if you ever find any of
those guys... tell them I said hi. I'm sure Russ would give one away....
the problem is finding him! <g>.
Al
--
Al Acker, President
Acker Consulting, Inc.
mailto:al@thexbasefiles.com
http://www.ackerconsulting.com
"Matt Whelan" <matt@SPAMLESSmesh3.com> wrote in message
news:20050114231400.80EA.MATT@SPAMLESSmesh3.com...
> Hey Al,
>
>
> If you could track down Russell Stromin he might give one away . . .
>
>
> I threw an RDD Kit and a stack of other third-party stuff away recently.
> Should have waited.
>
>
> Buried just as deep somewhere here I have source for a DBFMDX RDD with
> transactions that could be made to do journalling pretty easily. :-)
>
>
> Oh, yeah, there's always that problem.
>
> -Matt
>
| |
| Stephen Quinn 2005-01-15, 8:55 am |
| Rick
There was a package called RDDKit that comprised of 6 RDDs one of which (IIRC -
Journal) allowed you to code something like that.
I have no idea where you'd get it now.
--
HTH
Steve
| |
| Ross McKenzie 2005-01-15, 8:55 am |
| On Tue, 11 Jan 2005 11:33:26 +1100, "Stephen Quinn"
<steveqNOSPAM@integritynet.com.au> wrote:
>Rick
>
>There was a package called RDDKit that comprised of 6 RDDs one of which (IIRC -
>Journal) allowed you to code something like that.
>
>I have no idea where you'd get it now.
>
>--
>HTH
>Steve
>
>
Steve, your memory is much better than mine! But when I read your
message it prompted a search here. Sure enough, RDDKit by Strolevco
Pty Ltd of South Africa for Clipper 5.01 and 5.2...now defunct. And
yes it is the "Journal" RDD that maintains transparently a dbf store
of the target dbf data changes.
Regards,
Ross McKenzie
ValuSoft
Melbourne Australia
valusoft AT optushome DOT com DOT au
Please consider a donation through the Red Cross to our friends affected by the tsunamis.
| |
| Matt Whelan 2005-01-18, 3:55 am |
| Hey Al,
> That product came out of South Africa... it's long gone now..
If you could track down Russell Stromin he might give one away . . .
> have a copy as I've got a copy of just about every Clipper product ever
> created....
I threw an RDD Kit and a stack of other third-party stuff away recently.
Should have waited.
> but it's buried pretty deep
Buried just as deep somewhere here I have source for a DBFMDX RDD with
transactions that could be made to do journalling pretty easily. :-)
> and I couldn't legally give it to you if I found it <g>..
Oh, yeah, there's always that problem.
-Matt
| |
| Al Acker 2005-01-18, 3:55 am |
| Hi Matt,
Haven't heard from Russ in a huge amount of time... if you ever find any of
those guys... tell them I said hi. I'm sure Russ would give one away....
the problem is finding him! <g>.
Al
--
Al Acker, President
Acker Consulting, Inc.
mailto:al@thexbasefiles.com
http://www.ackerconsulting.com
"Matt Whelan" <matt@SPAMLESSmesh3.com> wrote in message
news:20050114231400.80EA.MATT@SPAMLESSmesh3.com...
> Hey Al,
>
>
> If you could track down Russell Stromin he might give one away . . .
>
>
> I threw an RDD Kit and a stack of other third-party stuff away recently.
> Should have waited.
>
>
> Buried just as deep somewhere here I have source for a DBFMDX RDD with
> transactions that could be made to do journalling pretty easily. :-)
>
>
> Oh, yeah, there's always that problem.
>
> -Matt
>
| |
|
| I would ask this in an Oracle ng. It may have the ability to do
transaction logging built in.
Mike
| |
|
| When I think of an audit trail it reminds me of something we did on the
mainframes. That being said, I would love to add a rock solid audit
trail to the Oil and Gas Land system that I sell. I can't imagine any
"automated" audit trail to any computer system. A good audit trail will
expose lost records, fraud, data entry errors...
I wish I could get into more detail but I have seen entire books
dedicated to the subject. It is more than record counts!
Mike
| |
| Al Acker 2005-01-19, 3:55 am |
| Stephen,
That product came out of South Africa... it's long gone now.. I'm sure I
have a copy as I've got a copy of just about every Clipper product ever
created.... but it's buried pretty deep and I couldn't legally give it to
you if I found it <g>..
If you use a class for your table updates or use a common function for all
table edits / saves etc..... it's pretty simple to add in an audit trail.
Al
--
Al Acker, President
Acker Consulting, Inc.
mailto:al@thexbasefiles.com
http://www.ackerconsulting.com
"Stephen Quinn" <steveqNOSPAM@integritynet.com.au> wrote in message
news:34gl9vF493qe0U1@individual.net...
> Rick
>
> There was a package called RDDKit that comprised of 6 RDDs one of which
> (IIRC -
> Journal) allowed you to code something like that.
>
> I have no idea where you'd get it now.
>
> --
> HTH
> Steve
>
>
| |
| Matt Whelan 2005-01-20, 3:55 pm |
| Hey Al,
> That product came out of South Africa... it's long gone now..
If you could track down Russell Stromin he might give one away . . .
> have a copy as I've got a copy of just about every Clipper product ever
> created....
I threw an RDD Kit and a stack of other third-party stuff away recently.
Should have waited.
> but it's buried pretty deep
Buried just as deep somewhere here I have source for a DBFMDX RDD with
transactions that could be made to do journalling pretty easily. :-)
> and I couldn't legally give it to you if I found it <g>..
Oh, yeah, there's always that problem.
-Matt
| |
| rmccallion@yahoo.com 2005-01-20, 3:55 pm |
| Anyone else aware of any utilities/tools out there that would log
database changes?
Any assistance is appreciated.
Regards,
Rick
|
|
|
|