Re: Batch COA Validation

Hi David,

Communication and Network Services uses Option 1: A Centrally Maintained
Validation Routine and we love it!

We have the validation routines integrated directly into our CNS shopping
cart for immediate chart-string validation upon entry by the campus customer.

We also have a batch script that we run periodically to take all of the
COAs in our system and make sure they are still valid chart-strings (as
funds can close or run out of money).

Terri Kouba
CNS

At 11:16 AM 12/14/2004, Sara Golemon wrote:
>That depends largely on how much work you want to do. I'd start by reading
>up on the (quite good) documentation provided by ASD at
>http://socrates.berkeley.edu:4100/FAS/coa.html
>
>My applications use Option 2 (originally via direct connection, but
>connectivity issues forced me to just periodicly shadow the COA validation
>tables from the FTP source).
>
>Option 1 has the attraction of doing all the logic application for you (So I
>hear -- I've never actually tried using it having an irrational distrust of
>Java), but if you follow the instructions provided (they really are nice and
>explicit) you can code up that part from the source tables easily enough.
>
>-Sara
>
>
>----- Original Message -----
>From: "David Rieger" <drieger@olac.berkeley.edu>
>To: <micronet-list@listlink.berkeley.edu>
>Sent: Tuesday, December 14, 2004 11:04 AM
>Subject: [Micronet] Batch COA Validation
>
>
> > Hello folks,
> >
> > I've an interesting problem: I'd like to periodically validate all of the
> > COA's in our shadow system.
> >
> > Right now when we update a client account our system uses:
> > http://coadbms/coa/COAFull_action.cfm
> >
> > (This URL takes the COA and validates the input and our system screen
> > scrapes the results to reject/accept the changes. This occurs on just that
> > one account).
> >
> > What I'd like to do is perform a query and have that result set (1-500
> > lines) be validated in one fell swoop so that when we perform our recharge
> > operations the accounts that we are set to bill against are validated just
> > one more time before processing.
> >
> > Do you think this is possible?
> >
> > Regards, thanks and will summarize,
> >
> > David
> >
> >
> > ------------------------------------------------------------------------
> > The following was automatically added to this message by the list server:
> >
> > For information about Micronet, including subscribing to
> > or unsubscribing from its mailing list and finding out
> > about upcoming meetings, please visit the Micronet Web site:
> > <http://micronet.berkeley.edu/>.
> >
>
>
>------------------------------------------------------------------------
>The following was automatically added to this message by the list server:
>
>For information about Micronet, including subscribing to
>or unsubscribing from its mailing list and finding out
>about upcoming meetings, please visit the Micronet Web site:
><http://micronet.berkeley.edu/>.

------------------------------------------------------------------------
The following was automatically added to this message by the list server:

For information about Micronet, including subscribing to
or unsubscribing from its mailing list and finding out
about upcoming meetings, please visit the Micronet Web site:
<http://micronet.berkeley.edu/>.
Received on Tue Dec 14 11:32:49 2004