Message 2: Ran out of licenses; need to wipe out old MBRs
from "Josh Hillman" <admin-maillist@talstar.com>
Message 3: Re: Ran out of licenses -- Part 2
from "Josh Hillman" <admin-maillist@talstar.com>
Message 4: Re: Ran out of licenses -- Part 2
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 5: Re: Ran out of licenses; need to wipe out old MBRs
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 6: Error creating payments
from " Olivier Astier " <astier@EchoWeb.net>
Message 7: Re: Ran out of licenses; need to wipe out old MBRs
from "Rudy Komsic" <rudyk@cyberglobe.net>
Message 8: Re: Ran out of licenses; need to wipe out old MBRs
from "Dale E. Reed Jr." <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Calls Consolidation
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Fri, 24 Jul 1998 00:32:10 -0700
Greg Hastings wrote:
>
> As I understand it, the built in Calls Consolidation in Emerald ver. 2.1.11
> does not work correctly. Is there an SQL script available that I can run to
> correctly consolidate calls?
Emerald 2.2 consolidates correctly. YOu have to put to run the consol.sql
script on our FTP site against your database first, though. You can not simply
run a query to consolidate. Its much more complicated than that. You must
do the consolidation through the Emerald client.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Ran out of licenses; need to wipe out old MBRsFrom: "Josh Hillman" <admin-maillist@talstar.com>Date: Fri, 24 Jul 1998 13:30:08 -0400
I ran out of licenses yesterday in Emerald and Emerald (2.1.11) locked outour staff from going into the program. Luckily, I still had it running onanother machine so I could use that to clear out a few MBRs that hadexpired back in 96. Unfortunately, that only freed up 10 MBRs, so we'rejust about to run out again.Is there a decent SQL script that'll perform the same function as hittingDELETE in the MBR search screen in Emerald? I'd rather not sit thereentering in who knows how many old accounts and hitting delete, thenconfirming a few times each time. If this deletes only subaccounts andmasteraccounts where MasterAccounts.maExpireDate < 7/1/97 and ma.customerid= sa.customerid, then I can write the script(s) myself, but I wasn't sureif 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 allinvoices and payments associated with the old accounts since after wipingout the MBRs, I'll have no way of associating any of them with anyone'sname/company...
Josh Hillmanhillman@talstar.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Ran out of licenses -- Part 2From: "Josh Hillman" <admin-maillist@talstar.com>Date: Fri, 24 Jul 1998 15:42:56 -0400
Actually, if possible, is there a way to create a new table in Emeraldcalled "OldAccounts" (doesn't really matter) and copy all/some of the infofrom MasterAccounts to this new table where MasterAccounts.maExpiredate <'7/1/97'? Obviously I don't need it for billing or authenticationpurposes, but I would like to keep at least some of the info around in caseI need to cross reference old invoices/payments with old Names/Companies(via CustomerID).
Josh Hillmanhillman@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) lockedout> our staff from going into the program. Luckily, I still had it runningon> 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 andma.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
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Ran out of licenses -- Part 2From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 24 Jul 1998 13:30:18 -0700
Josh Hillman wrote:> > 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).
Not currently. Emerald 2.5 doesn't count inactive MBRs, so you won'thave a problem with them then.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Ran out of licenses; need to wipe out old MBRsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 24 Jul 1998 14:02:20 -0700
Josh Hillman wrote:> > 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.
More things I shouldn't say, but will. I want people to know wehave been working on issues like this. First, I mentioned earlierthat Emerald 2.5 only counts active MBRs. It also doesn't lock youout when you go over. It will display an annoying message and preventyou from adding new users, but it will not lock you out. :)
> 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...
Actually, its much more complicated than that (see below). > When deleting old MBRs, it has no effect on the following tables, right?:> Payments> InvoiceItems> Charges> Invoices
Yes, it does. Emerald's database is relational. Therfore, you can'tdelete a parent (the MBR) without deleting the related records (youcan't orphan child records, the SQL Server won't allow it). We areworking on ways to resolve this where it will keep the accountingdata but remove the customer information.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Error creating paymentsFrom: " Olivier Astier " <astier@EchoWeb.net>Date: Fri, 24 Jul 98 14:26:44 PDT
Hi.Since this morning, I am not able to create any payement.The invoices show OK but when I try to pay one (one I just created or an older one) I get :SQL Error : Couldn't Insert payment. Account and Invoices not updated.I ran a checkdb from Emerald Admin with no effect.Even if I void the invoice and create a new one I get the same error.