[Emerald Digest]

emerald-digest-request@iea-software.com
Thu, 21 May 1998 00:00:00 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Brian Johnson: "Taxes"
Next message: Josh Hillman: "Re: Crystal report files 4.5 vs. 5.0"

Message 1: RE: Tables Question
from "Brian Johnson" <brian@hdc.net>

Message 2: RE: Tables Question
from "Greg Keys" <greg@loclnet.com>

Message 3: Emerald Radius File
from will@greennet.net (Will LaSala)

Message 4: Re: Emerald Radius File
from "Victor A." <victor@webjogger.net>

Message 5: Re: Crystal report files 4.5 vs. 5.0
from "Josh Hillman" <admin-maillist@talstar.com>

Message 6: Re: Emerald Radius File
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 7: is your site www.iea-software.com Down???
from "Jorge Pocaterra" <junior@enlared.net>

Message 8: Re: Tables Question
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 9: Re: Tables Question
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 10: Tables question II
from "Rafael Gomez" <rgomez@c-com.net>

Message 11: Can't print all of a sudden
from John Lange <radadmin@palacenet.net>

Message 12: Errors
from "Rafael Gomez" <rgomez@c-com.net>

Message 13: Re: Can't print all of a sudden
from "Josh Hillman" <admin-maillist@talstar.com>

Message 14: Re: Tables question II
from "Josh Hillman" <admin-maillist@talstar.com>

Message 15: Re: Can't print all of a sudden
from John Lange <radadmin@palacenet.net>

Message 16: Re: Can't print all of a sudden
from "Josh Hillman" <admin-maillist@talstar.com>

Message 17: Taxes
from "Brian Johnson" <brian@hdc.net>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Tables Question
From: "Brian Johnson" <brian@hdc.net>
Date: Wed, 20 May 1998 08:03:06 -0500

Dale,
How did you create the CallDetails table, and how do you populate
it(scipt?).

Brian Johnson
Network Administrator
Hard Drive Central
423 Moccasin Drive, Aberdeen, SD 57401

---Brian JohnsonNetwork AdministratorHard Drive Central423 Moccasin Drive, Aberdeen, SD 57401

> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.> Sent: Tuesday, May 19, 1998 11:15 PM> To: emerald@iea-software.com> Subject: Re: Tables Question>>> Rafael Gomez wrote:> >> > When I make the data consolidation the Call table stays with> the old data or> > drops it?>> The old data is dropped. However, I have outlined before on how to create> a CallDetails table to have a table with the same records but without> all the extra records that make the table's size grow. I currently have> a CallDetails table with about 1.5 million records that is only 40mb,> whereas the calls table has 400,000 records and is about 125mb.>>> --> 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: RE: Tables QuestionFrom: "Greg Keys" <greg@loclnet.com>Date: Wed, 20 May 1998 09:18:38 -0400

I have looked and looked and looked - I went to the web site, but there isnot a search feature..... so I scanned message headers of messages prior towhen I subscribed to the list, but I just can not find where you outlinedanything on a CallDetails table.... I..... just ..... can't..... take.....the...... stress...... any..... more......

Seriously, I can not find any reference to this, but I am probably justsearching on the wrong words or something. Could you please repost thisinfo? My HD is filling up as I type :)

P.S. I am not ignoring your request about Tellan PCA formats.... I will berunning a batch of credit cards later today, and will send it all to youdirectly, rather than on the list.

I will also post to the list the details on the method I am using to batchout of Emerald to PCA (A hint: PCA's Import feature is so flexible that Ihave gotten it to read EVERY CreditCard batch format that Emerald 2.1.1supports)

Gregory E. KeysSystem AdministratorLoclNet (A Division of ESC Inc.)Electro-data Systems Company Inc.Voice: (704)861-1251Fax: (704)861-1870E-Mail: greg@loclnet.com <mailto:greg@loclnet.com>

> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.> Sent: Wednesday, May 20, 1998 12:15 AM> To: emerald@iea-software.com> Subject: Re: Tables Question>>> Rafael Gomez wrote:> >> > When I make the data consolidation the Call table stays with> the old data or> > drops it?>> The old data is dropped. However, I have outlined before on how to create> a CallDetails table to have a table with the same records but without> all the extra records that make the table's size grow. I currently have> a CallDetails table with about 1.5 million records that is only 40mb,> whereas the calls table has 400,000 records and is about 125mb.>>> --> 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 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Emerald Radius FileFrom: will@greennet.net (Will LaSala)Date: Wed, 20 May 1998 09:54:37 -0400

Hi all,I use emerald to create the Radius File by doing the export option.It works great, However, I'd like to be able to run this query nightlyat midnight and create the file on 2 different servers. I can do thisbut I need to now the exact SQL Query used to create the file.I've tried to re-write it but I've always come up short, so I figuredsince you already have it written I thought I'd ask you for it.So if you wouldn't mind could I borrow the SQL script?ThanksWill ,,,=^. .^=,,,WebmasterGreenNet® ========================================"Link Locally ~ Surf Globally©" http://www.greennet.netCome Play On The Best Quake Server in the NortheastServing Eastern Massachusetts and Southern New HampshireTEL: 978-363-8898 FAX: 978-363-1225 email:will@greennet.net===============================================

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald Radius FileFrom: "Victor A." <victor@webjogger.net>Date: Wed, 20 May 1998 10:31:55 -0400

At 09:54 AM 5/20/98 -0400, you wrote:>I use emerald to create the Radius File by doing the export option.>It works great, However, I'd like to be able to run this query nightly>at midnight and create the file on 2 different servers. I can do this>but I need to now the exact SQL Query used to create the file.>I've tried to re-write it but I've always come up short, so I figured>since you already have it written I thought I'd ask you for it.>So if you wouldn't mind could I borrow the SQL script?>Thanks

I'd be interested in that script as well if anyone is willing to share iton the list.

Thanks,

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Crystal report files 4.5 vs. 5.0From: "Josh Hillman" <admin-maillist@talstar.com>Date: Wed, 20 May 1998 10:32:27 -0400

Dale,

I've got CR5.0 running on my home computer (Win95--haven't installed itinto NT there) and am using Emerald 2.1.11. I redownloaded the Inv50.rptfile from the FTP site along with a couple others and reworked them so thatthey have the same basic custom layout that my original 4.x versions had. I can view/print the 5.0 reports from my home computer without any problemnow.This morning, I tried getting one of our machines here at the office (alsoEmerald 2.1.11) working with the customized 5.0 Invoice.rpt and Account.rptfiles, but am running into a small problem. I already put the followingfiles (taken from my home computer's \windows\system directory) into\winnt\system32 overwriting the existing versions: crpe32.dll Crystl32.ocx crystl32.tlb crystl32.dep (couldn't remember if that was needed or not)I also ran regsvr32 crystl32.ocx

When I go to print someone's account info (account.rpt) or an invoice(invoice.rpt), I get the following 2 error messages:First: CRPaige library CRPaige(32).DLL cannot be found. It should be on the path. [Ok]Second: 20500:Not enough memory for operation [Ok][Cancel]

Memory is not the issue--the machine's got 96MB RAM and only 45 of it isbeing used; there's 411MB drive space available on the partition too...

I've looked at the installation files from the CD that I have for CR5.0,but can't find anything named "crpa*.*" Any idea what file(s) it's reallylooking for??

Thanks,

Josh Hillmanhillman@talstar.com

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald Radius FileFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 20 May 1998 10:09:58 -0700

Will LaSala wrote:> > I use emerald to create the Radius File by doing the export option.> It works great, However, I'd like to be able to run this query nightly> at midnight and create the file on 2 different servers. I can do this> but I need to now the exact SQL Query used to create the file.> I've tried to re-write it but I've always come up short, so I figured> since you already have it written I thought I'd ask you for it.> So if you wouldn't mind could I borrow the SQL script?

See the radusers.exe program in the /emerald/beta directory. It willdump the users file to stdio (just redirect it to a file). Check thearchives as several people have detailed how they use it. I am workingon a newer version of it that corrects a couple of problems and itsless stressful on SQL Server when its ran (its for a couple of customers that have over 25,000 MBRs). I'll let the list know whenits done.

-- 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: is your site www.iea-software.com Down???From: "Jorge Pocaterra" <junior@enlared.net>Date: Wed, 20 May 1998 13:15:29 -0400

Hi Dale

Is your site down ?

I have being trying to connect all morning...

Regards

Jorge Pocaterrajunior@enlared.net

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Tables QuestionFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 20 May 1998 10:15:34 -0700

Greg Keys wrote:> > I have looked and looked and looked - I went to the web site, but there is> not a search feature..... so I scanned message headers of messages prior to> when I subscribed to the list, but I just can not find where you outlined> anything on a CallDetails table.... I..... just ..... can't..... take.....> the...... stress...... any..... more......

On the Home page, in the upper left hand corner, there is the word "search".Its a clickable link. Thats a "search feature" and includes the mailing lists as noted on the page the link points to.

just enter the single phrase "calldetails" as one word (the table I notedbelow) and you'll get 8 hits. The bottom one is for this URL in thearchives:

http://www.iea-software.com/lists/9804/emerald/00001065.htm

which is my post I was referring to that details how to setup theCallDetails table.

> I will also post to the list the details on the method I am using to batch> out of Emerald to PCA (A hint: PCA's Import feature is so flexible that I> have gotten it to read EVERY CreditCard batch format that Emerald 2.1.1> supports)

Since I don't have the software and the docs on the batch, I didn't diginto it. Can it also include "strings" rather than just a filler?

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Tables QuestionFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 20 May 1998 10:18:05 -0700

Brian Johnson wrote:> > Dale,> How did you create the CallDetails table, and how do you populate> it(scipt?).

I created it via a script, and its populated via a trigger. You couldcopy your current table into it with a Insert Into CallDetails Select...statement, though. See this URL:

http://www.iea-software.com/lists/9804/emerald/00001065.htm

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Tables question IIFrom: "Rafael Gomez" <rgomez@c-com.net>Date: Wed, 20 May 1998 14:08:38 -0400

Hi Can you tell me the characteristics for the camp AcctSessionTime in thetable Call?. This is because I don't know if I read the data in seconds.

Thanks

Rafael Gomez

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Can't print all of a suddenFrom: John Lange <radadmin@palacenet.net>Date: Wed, 20 May 1998 13:35:07 -0500

Emerald 2.2.38

I have been using Emerald for a LONG time. Today I cannot print. I getthe following error:

20997:???????

I will continue to trouble shoot this, suggestions would be helpful

JOhn :}

John C. Lange, Sr. PALACE dot NET, INC.microjl@palacenet.net MICRO-TECH Computers, Inc.608.742.1601 & 6980 2800 New Pinery Roadhttp://www.palacenet.net/ Portage, WI 53901Visit our online store @ http://www.microt.com/Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html

--- __o --- _-\<,_ Fastest Service in Town --- (_)/ (_)

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: ErrorsFrom: "Rafael Gomez" <rgomez@c-com.net>Date: Wed, 20 May 1998 14:44:26 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_002C_01BD83FD.C9AB4050Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

HiI have Problems with something here. When somebody try to get connected =with us the emerald software response is "Violation of PRIMARY KEY =constraint "pk_Calls": attemp to insert duplicate key in object Call"

Thanks

Rafael Gomez

------=_NextPart_000_002C_01BD83FD.C9AB4050Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

I have Problems with something here. =When=20somebody try to get connected with us the emerald software response is=20"Violation of PRIMARY KEY constraint "pk_Calls": attemp =to insert=20duplicate key in object Call"

Thanks

Rafael =Gomez

------=_NextPart_000_002C_01BD83FD.C9AB4050--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Can't print all of a suddenFrom: "Josh Hillman" Date: Wed, 20 May 1998 15:24:32 -0400> From: John Lange > To: EMERALD@IEA-SOFTWARE.COM> Emerald 2.2.38> I have been using Emerald for a LONG time. Today I cannot print. I get> the following error:> 20997:???????I have no idea what that number represents, but do you have any harddrivespace available for the .tmp file to be created? I had that happen on myhome computer lastnight. I couldn't even access any menus (start,pull-down, right-click, etc.) until I deleted a few files off the system tofree up some space.Josh Hillmanhillman@talstar.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Tables question IIFrom: "Josh Hillman" Date: Wed, 20 May 1998 15:26:20 -0400> From: Rafael Gomez > Can you tell me the characteristics for the camp AcctSessionTime inthe> table Call?. This is because I don't know if I read the data in seconds.I don't know if this is the same for other NASes, but with Ascend, thevalues are measured in seconds, as are all other time-related values (idletimeouts, max session times, etc.)Josh Hillmanhillman@talstar.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Can't print all of a suddenFrom: John Lange Date: Wed, 20 May 1998 14:53:44 -0500HII have 193MB Free - chkdsk & defrag OKJOhn :}At 03:24 PM 5/20/1998 -0400, you wrote:>> From: John Lange >> To: EMERALD@IEA-SOFTWARE.COM>> Emerald 2.2.38>> I have been using Emerald for a LONG time. Today I cannot print. I get>> the following error:>> 20997:???????>>I have no idea what that number represents, but do you have any harddrive>space available for the .tmp file to be created? I had that happen on my>home computer lastnight. I couldn't even access any menus (start,>pull-down, right-click, etc.) until I deleted a few files off the system to>free up some space.>>Josh Hillman>hillman@talstar.com>>John C. Lange, Sr. PALACE dot NET, INC.microjl@palacenet.net MICRO-TECH Computers, Inc.608.742.1601 & 6980 2800 New Pinery Roadhttp://www.palacenet.net/ Portage, WI 53901Visit our online store @ http://www.microt.com/Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html --- __o --- _-\<,_ Fastest Service in Town --- (_)/ (_)..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Can't print all of a suddenFrom: "Josh Hillman" Date: Wed, 20 May 1998 16:49:26 -0400> From: John Lange > I have 193MB Free - chkdsk & defrag OKAre you getting the preview window when trying to print or no?If yes, is your printer functioning correctly (has the printer listingchanged or been removed from your Printers section in the Control Panel?)Do you have Crystal Reports on the machine that you're trying to printfrom? If so, can you pull up the report in there and print?Are you logged into your machine and/or Emerald using a username that youdon't normally use?Can you print anything? invoice.rpt, account.rpt, etc. or is it limited toone report? If it's one report, maybe the file is damaged in some way?I'm just guessing here... As I said before, I don't have any idea what thaterror number represents.Josh Hillmanhillman@talstar.com> At 03:24 PM 5/20/1998 -0400, you wrote:> >> From: John Lange > >> To: EMERALD@IEA-SOFTWARE.COM> >> Emerald 2.2.38> >> I have been using Emerald for a LONG time. Today I cannot print. Iget> >> the following error:> >> 20997:???????> >> >I have no idea what that number represents, but do you have anyharddrive> >space available for the .tmp file to be created? I had that happen onmy> >home computer lastnight. I couldn't even access any menus (start,> >pull-down, right-click, etc.) until I deleted a few files off the systemto> >free up some space.> >> >Josh Hillman> >hillman@talstar.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: TaxesFrom: "Brian Johnson" Date: Wed, 20 May 1998 17:17:46 -0500Shouldn't taxes be associated with a region or a group instead of a service?Is this how it is in 2.5 or will it be this way in a future version.---Brian JohnsonNetwork AdministratorHard Drive Central423 Moccasin Drive, Aberdeen, SD 57401

Previous message: Brian Johnson: "Taxes"
Next message: Josh Hillman: "Re: Crystal report files 4.5 vs. 5.0"