----- Original Message -----
From: David Moore <moored@romtech.com.au>
To: <emerald@iea-software.com>
Sent: Sunday, 2 May 1999 02:13
Subject: Re: [Emerald] Importing a calls table
> How or where do you install the tasks?
>
> ----- Original Message -----
> From: Dale E. Reed Jr. <daler@iea-software.com>
> To: <emerald@iea-software.com>
> Sent: Sunday, May 02, 1999 12:38 PM
> Subject: Re: [Emerald] Importing a calls table
>
>
> > > David Moore wrote:
> > >
> > > I have killed my 2.2 on (SQL 6.5) to 2.5 upgraded version of emerald.
> > > Reinstalled SQL 7 and installed the production version of emerald, I
> > > have re-keyed all the users and wish to transport the old calls table
> > > and Call history, SQL 7 has the capability to export to Excel which I
> > > have done. I have exported the calls tables taken out erroneous
> > > entries and generally massaged the data.
> > >
> > > I had to do this because consolidation did not work at the end of each
> > > month. What I intend to do is copy the callshistory table from the old
> > > system in to the new system. This table stops in December because of
> > > the consolidation problems I intend to restore all of my calls records
> > > export them add them all together de duplicate them and re import them
> > > into the new emerald 2.5.
> > >
> > > I have noticed that generally the records start with an AcctSessionID
> > > of 1 and stop with an AcctSessionID of 2 some records don't have the
> > > corresponding start or stop record, ie have an account session of 1
> > > but no stop record or have a stop record but no start record if I
> > > import this table will I have further problems or will the
> > > consolidation procedure ignore the errant records.
> >
> > I assume you mean AcctStatusType above, not AcctSessionID.
> > Consolidation
> > only looks at Stop records. Start Records are not used and generally
> > deleted during a nighly scheduled task in Emerald 2.5 (if you install
> > the tasks).
> >
> >
> > --
> >
> > Dale E. Reed Jr. Emerald and RadiusNT
> > __________________________________________
> > IEA Software, Inc. www.iea-software.com
> >
>
>