Re: [Emerald] rebatch behind the scenes .... ?

Ed Miller ( (no email) )
Wed, 9 Jun 1999 09:24:54 -0400

When you get it working could you share it with the rest of us. We need the
same
thing. ;-)

> > > > What exactly does emerald do database-wise when in the batch window
i
> > > > click "re-batch" on an cc invoice that failed ? I'm working a
script
> > > > and I need to know what this does so I can batch a group of cc
> invoices
> > > > again.
> > >
> > > It sets the corresponding entry's TransType to 7 in the ExternalTrans
> > > table. Emerald will change that to 8 after its created a new
> > > ExternalTrans
> > > entry for the invoice.
> >
> >
> > Hi Dale,
> >
> > Thanks for the info, I needed that info for an script that will
> > automatically update credit cards that have expired. The idea is to
bump
> > them up a year and try it again, and so forth. We used to do this by
hand
> > when on the old system of typing CC's into the machine. This isn't as
> > clean as sending an invoice for each expired card, but imagine if you
will
> > 7000 CC customers, divide that by 12 months and the # of cards that
expire
> > that year and suddenly you have a lot of invoices to send out every
month
> > on expired credit cards. We'd like to see emerald have some way at
> > guessing what at an expired credit card's new expiration date would be.
> >
> >
> > Alex
> > Online Gateway
> >
>