Message 2: Re: Bulk Table copy.
from Ian Pizey <ifpizey@kenora.com>
Message 3: Re: Bulk Table copy.
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 4: Re: Bulk Table copy.
from Ian Pizey <ifpizey@kenora.com>
Message 5: Calls online not showing up
from "Greg Hastings" <greg@hwy97.net>
Message 6: Re: Calls online not showing up
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 7: Re: Calls online not showing up
from "Greg Hastings" <greg@hwy97.net>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject:
From: "Peggy Stokes" <pstokes@Trellis.net>
Date: Wed, 15 Jul 1998 13:03:53 -0400
leave Emerald pstokes@trellis.net
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Bulk Table copy.
From: Ian Pizey <ifpizey@kenora.com>
Date: Wed, 15 Jul 1998 13:14:55 -0500
Looks like this method will work for future uses before I consolidate.
However the current isue is that i Have no call details for the previous
months that were consolidated.
So what I want to do is restore the data from a backup and copy all the
call details information into this table and then i can point the web page
to this page.
Obviously our current data has been consolidated into the call history table.
It should look like this.
OLD emerald database pre consolidation ----- into ----- new call details
table
Any Ideas....
At 03:09 PM 7/14/98 -0700, you wrote:
>See this post in the archives:
>
>http://www.iea-software.com/lists/9804/emerald/00001065.htm
>
>Ian Pizey wrote:
>>
>> Does any one know how to copy the calls table within the emerald
>> database to another
>> table that can be used for archive purposes. That in turn can be used for
>> user time look ups.
>>
>> The table would have a different name and contain the same structure and
>> data as the current table. i asssume that once the table is created a
>> nightly trigger can update this table and therefore have near on line time
>> available for the users. I realize that the purpose of the consolidation
>> process is to reduce the amount of data in the calls table. However the
>> need for online time checking does save a needless administrative burden
>> and provides the customers with better service.
>
>Many sites are using this and it works well.
>
>--
>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
>
__________________________________
Ian Pizey
Technet of Kenora Inc.
924 5th Street South
Kenora, ON P9N 1L8
Ph 807-468-8900
Fx 807-468-7700
email:ifpizey@kenora.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Bulk Table copy.
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Wed, 15 Jul 1998 12:48:45 -0700
Ian Pizey wrote:
>
> It should look like this.
>
> OLD emerald database pre consolidation ----- into ----- new call details
> table
Create a Database Called EmeraldCallDetails. Restore your calls table
into that database and create the CallDetails table in there as well.
Then do the Insert into CallDetails from Calls to put the records you
want in. Finally, delete the CallsTable from the new database.
Now, just modify the trigger, so that its like this:
Insert into EmeraldCallDetails..CallDetails(field, field,)
VALUES (value, value)
You can just adding the "EmeraldCallDetails.." in front of
the table name in the Emerald database, Calls table trigger.
This has the advantage of keeping the data seperated.
-- 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 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Bulk Table copy.From: Ian Pizey <ifpizey@kenora.com>Date: Wed, 15 Jul 1998 15:55:36 -0500
Thanks, that's looks like the ticket.
Let you know how it works out...
At 12:48 PM 7/15/98 -0700, you wrote:>Ian Pizey wrote:>> >> It should look like this.>> >> OLD emerald database pre consolidation ----- into ----- new call details>> table>>Create a Database Called EmeraldCallDetails. Restore your calls table>into that database and create the CallDetails table in there as well.>Then do the Insert into CallDetails from Calls to put the records you>want in. Finally, delete the CallsTable from the new database.>>Now, just modify the trigger, so that its like this:>>Insert into EmeraldCallDetails..CallDetails(field, field,)>VALUES (value, value)>>You can just adding the "EmeraldCallDetails.." in front of>the table name in the Emerald database, Calls table trigger.>>This has the advantage of keeping the data seperated.>>-- >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> __________________________________Ian Pizey Technet of Kenora Inc. 924 5th Street South Kenora, ON P9N 1L8Ph 807-468-8900Fx 807-468-7700email:ifpizey@kenora.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Calls online not showing upFrom: "Greg Hastings" <greg@hwy97.net>Date: Wed, 15 Jul 1998 16:00:23 -0700
I'm using emerald 2.1.11
Recently, calls online have randomly started to not show up on the "on-line"page. There doesn't appear to be any pattern to this. If I telnet into theNAS (computone powerrack) to see who is actually online, most of the timethere will be a couple of users on who do not show up in the callsonlinetable.
What event(s) maintain this information?
This problem has only recently started happening. Months earlier, I had theopposite problem of people still showing online after they had disconnected.Some changes to a trigger solved that.
Thanks,Greg Hastings
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Calls online not showing upFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 15 Jul 1998 15:57:21 -0700
Greg Hastings wrote:> > I'm using emerald 2.1.11> > Recently, calls online have randomly started to not show up on the "on-line"> page. There doesn't appear to be any pattern to this. If I telnet into the> NAS (computone powerrack) to see who is actually online, most of the time> there will be a couple of users on who do not show up in the callsonline> table.> > What event(s) maintain this information?
Its accounting information. Check the length of the user name. Areall the ones who are not showing up the ones with long usernames?
-- 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 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Calls online not showing upFrom: "Greg Hastings" <greg@hwy97.net>Date: Wed, 15 Jul 1998 17:14:13 -0700
>Its accounting information. Check the length of the user name. Are>all the ones who are not showing up the ones with long usernames?>
No. The most recent examples range from 5 to 9 characters. Example: "rross"