----- 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
>