Creating a script that will recursively parse out users, and move them
to a seperate database. So that Emerald could be used to view the old
database or the new one.. or using sql or access could as well.. but
we are still in the very early stages of the ideas, plus I don't want
to do anything until I know for absolute sure that it won't cause too
many problems, for me.
Jason
From: "Josh Hillman" <admin-maillist@talstar.com>
To: <emerald@iea-software.com>
Subject: Re: Ran out of licenses -- Part 2
Date sent: Fri, 24 Jul 1998 15:42:56 -0400
Send reply to: emerald@iea-software.com
> Actually, if possible, is there a way to create a new table in Emerald
> called "OldAccounts" (doesn't really matter) and copy all/some of the info
> from MasterAccounts to this new table where MasterAccounts.maExpiredate <
> '7/1/97'? Obviously I don't need it for billing or authentication
> purposes, but I would like to keep at least some of the info around in case
> I need to cross reference old invoices/payments with old Names/Companies
> (via CustomerID).
>
> Josh Hillman
> hillman@talstar.com
>
> ----------
> > From: Josh Hillman <admin-maillist@talstar.com>
> > To: emerald@iea-software.com
> > Subject: Ran out of licenses; need to wipe out old MBRs
> > Date: Friday, July 24, 1998 1:30 PM
> >
> > I ran out of licenses yesterday in Emerald and Emerald (2.1.11) locked
> out
> > our staff from going into the program. Luckily, I still had it running
> on
> > another machine so I could use that to clear out a few MBRs that had
> > expired back in 96. Unfortunately, that only freed up 10 MBRs, so we're
> > just about to run out again.
> > Is there a decent SQL script that'll perform the same function as hitting
> > DELETE in the MBR search screen in Emerald? I'd rather not sit there
> > entering in who knows how many old accounts and hitting delete, then
> > confirming a few times each time. If this deletes only subaccounts and
> > masteraccounts where MasterAccounts.maExpireDate < 7/1/97 and
> ma.customerid
> > = sa.customerid, then I can write the script(s) myself, but I wasn't sure
> > if the Delete button had any other effects...
> >
> > When deleting old MBRs, it has no effect on the following tables, right?:
> > Payments
> > InvoiceItems
> > Charges
> > Invoices
> >
> > Before wiping out the old accounts, I will print out a listing of all
> > invoices and payments associated with the old accounts since after wiping
> > out the MBRs, I'll have no way of associating any of them with anyone's
> > name/company...
> >
> > Josh Hillman
> > hillman@talstar.com
Jason Robertson Computer Pages / Better.Net
Technical Support Team 253 Sheppard Ave. West
support@cpol.com Toronto, Canada M2N 1N2
support@better.net Ph: +1 416 225 3030
http://www.cpol.com Fax: +1 416 225 6737
http://www.better.net