Message 2: Re: Database Size.
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 3: Re: SQL Errors
from "Richard Sensale" <wolfen@visitus.net>
Message 4: Database Schema
from Albert Churba <Albert@dialisdn.com>
Message 5: Re: SQL Errors
from "Richard Sensale" <richards@visitus.net>
Message 6: RE: Database Size.
from "Scott Burch" <sburch@bmni.com>
Message 7: Re: SQL Errors
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 8: Re: SQL Errors
from "Richard Sensale" <richards@visitus.net>
Message 9: SQL Errors from Emerald Admin
from "Pat Augustine" <ereth@ilnk.com>
Message 10: Re: Importing bookkeeping data
from Daniel Mpolokoso <daniel@zamnet.zm>
Message 11: Re: Importing bookkeeping data
from "Boyd Goodin" <boyd@planetc.com>
Message 12: Re: Database Size.
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 13: RE: Database Size.
from "Scott Burch" <sburch@bmni.com>
Message 14: Re: Database Schema
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 15: CR 6.0 Graphs
from "John Dodd" <jmdodd@mychoice.net>
Message 16: Re: Database Size.
from "Dale E. Reed Jr." <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: SQL Errors
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Wed, 17 Jun 1998 01:07:19 -0700
Richard Sensale wrote:
>
> Hi lately when adding users in Emerald. I have been getting errors like the
> following.. These are all SQL errors. adding MBRs.
If you run the below SQL statement in ISQL_W against your Emerald
database, what error do you get?
> INSERT MasterAccounts(ReferredBy, FirstName, LastName, Company, Address1,
> Address2, City, State, Zip, PhoneHome, PhoneWork, PhoneFax, SalesPerson,
> Region, CreateDate, StartDate, maExpireDate, Extension, Active, PayPeriod,
> PayMethod, PayInfo, PaidThru, LastReceived, PONumber, PrePaid,
> CreditCardNumber, CreditCardExpire, CreditCardAuth, CreditCardAutoBill,
> Comments, LastModifyDate, LastModifyUser, Balance, OverDue, SendMethod,
> GroupID) VALUES('','Denyaz', 'Farhat','', '15030 Colson','',
> 'Dearborn','MI', '48126','(313) 582-3238', '','', '','Dearborn',
> '6/16/98','6/16/98', '6/30/98',0, 1,'6 Mons Spec', ' Invoice','',
> '6/16/98','6/16/98', ' ','', '','', '',0, '','6/16/98 1:34:15 PM', 'sa',0,
> 0, 0, 1)
I don't see any issues from the statement. YOu might want to run the
checkdb.sql script to see if it reports an ident problem on your
MasterAccounts table.
-- 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: Database Size.From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 17 Jun 1998 01:10:09 -0700
Scott Burch wrote:> > So... The question is...How do I do a calls consolidation.
If you are running Emerald 2.2, run the consol.sql script in isql_wonce against your database (the script is in /emerald/beta on theftp site and only install the two procs 2.2 needs).
I do recommend using 2.2, but 2.1 should work as well. For 2.2, onthe batch tab, click the summary button. When the select list ispoopulated, select teh highest number in the left hand column (usuallythe last entry) and click charges. Repeat for each number in the lefthand column (in reverse order).
-- 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: Re: SQL ErrorsFrom: "Richard Sensale" <wolfen@visitus.net>Date: Wed, 17 Jun 1998 09:08:51 -0400
I'll try that.
-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: emerald@iea-software.com <emerald@iea-software.com>Date: Tuesday, June 16, 1998 11:07 PMSubject: Re: SQL Errors
>Richard Sensale wrote:>>>> Hi lately when adding users in Emerald. I have been getting errors likethe>> following.. These are all SQL errors. adding MBRs.>>If you run the below SQL statement in ISQL_W against your Emerald>database, what error do you get?>>> INSERT MasterAccounts(ReferredBy, FirstName, LastName, Company, Address1,>> Address2, City, State, Zip, PhoneHome, PhoneWork, PhoneFax, SalesPerson,>> Region, CreateDate, StartDate, maExpireDate, Extension, Active,PayPeriod,>> PayMethod, PayInfo, PaidThru, LastReceived, PONumber, PrePaid,>> CreditCardNumber, CreditCardExpire, CreditCardAuth, CreditCardAutoBill,>> Comments, LastModifyDate, LastModifyUser, Balance, OverDue, SendMethod,>> GroupID) VALUES('','Denyaz', 'Farhat','', '15030 Colson','',>> 'Dearborn','MI', '48126','(313) 582-3238', '','', '','Dearborn',>> '6/16/98','6/16/98', '6/30/98',0, 1,'6 Mons Spec', ' Invoice','',>> '6/16/98','6/16/98', ' ','', '','', '',0, '','6/16/98 1:34:15 PM','sa',0,>> 0, 0, 1)>>I don't see any issues from the statement. YOu might want to run the>checkdb.sql script to see if it reports an ident problem on your>MasterAccounts table.>>>-->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: Database SchemaFrom: Albert Churba <Albert@dialisdn.com>Date: Wed, 17 Jun 1998 10:02:58 -0400
Does anyone know where a list of the database schema for the Emerald Suite can be found? What I'm looking for is similar to the RadiusNT documentation section ODBC Database Schema Table Layout.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL ErrorsFrom: "Richard Sensale" <richards@visitus.net>Date: Wed, 17 Jun 1998 10:01:45 -0700
This is a multi-part message in MIME format.
------=_NextPart_000_001E_01BD99D6.EF9AE9C0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: 7bit
Dale, where should this script be located. It doesn't seem to be on eithermy local machine or the main radius server.
Richard SensaleNetwork AdministratorVisitUs Internet, Inc.5468 Schaefer RoadDearborn, MI 48126 USA(313) 945-5588(313) 945-0202 faxhttp://www.visitus.netrichards@visitus.net-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: emerald@iea-software.com <emerald@iea-software.com>Date: Tuesday, June 16, 1998 8:07 PMSubject: Re: SQL Errors
>Richard Sensale wrote:>>>> Hi lately when adding users in Emerald. I have been getting errors likethe>> following.. These are all SQL errors. adding MBRs.>>If you run the below SQL statement in ISQL_W against your Emerald>database, what error do you get?>>> INSERT MasterAccounts(ReferredBy, FirstName, LastName, Company, Address1,>> Address2, City, State, Zip, PhoneHome, PhoneWork, PhoneFax, SalesPerson,>> Region, CreateDate, StartDate, maExpireDate, Extension, Active,PayPeriod,>> PayMethod, PayInfo, PaidThru, LastReceived, PONumber, PrePaid,>> CreditCardNumber, CreditCardExpire, CreditCardAuth, CreditCardAutoBill,>> Comments, LastModifyDate, LastModifyUser, Balance, OverDue, SendMethod,>> GroupID) VALUES('','Denyaz', 'Farhat','', '15030 Colson','',>> 'Dearborn','MI', '48126','(313) 582-3238', '','', '','Dearborn',>> '6/16/98','6/16/98', '6/30/98',0, 1,'6 Mons Spec', ' Invoice','',>> '6/16/98','6/16/98', ' ','', '','', '',0, '','6/16/98 1:34:15 PM','sa',0,>> 0, 0, 1)>>I don't see any issues from the statement. YOu might want to run the>checkdb.sql script to see if it reports an ident problem on your>MasterAccounts table.>>>-->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
------=_NextPart_000_001E_01BD99D6.EF9AE9C0Content-Type: text/x-vcard; name="Richard A Sensale.vcf"Content-Transfer-Encoding: quoted-printableContent-Disposition: attachment; filename="Richard A Sensale.vcf"
BEGIN:VCARDN:Sensale;Richard;AFN:Richard A SensaleORG:VisitUs Internet, Inc.;Engineering, OperationsTITLE:Network AdministratorTEL;WORK;VOICE:(313) 945-5588TEL;WORK;FAX:(313) 945-0202ADR;WORK:;;5468 Schaefer Road;Dearborn;MI;48126;USALABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:5468 Schaefer =Road=3D0D=3D0ADearborn, MI 48126=3D0D=3D0AUSAURL:http://www3.visitus.net/wolfenEMAIL;PREF;INTERNET:richards@visitus.netEMAIL;INTERNET:webmaster@visitus.netEMAIL;INTERNET:hostmaster@visitus.netEMAIL;INTERNET:info@visitus.netEMAIL;INTERNET:postmaster@visitus.netEND:VCARD
------=_NextPart_000_001E_01BD99D6.EF9AE9C0--
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Database Size.From: "Scott Burch" <sburch@bmni.com>Date: Wed, 17 Jun 1998 08:22:33 -0700
What risk are associated with running this script. Can I run it while thesystem is up?
Scott BurchBenchmark Networking, Inc.sburch@bmni.com
-----Original Message-----From: emerald-request@iea-software.com[mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.Sent: Wednesday, June 17, 1998 1:10 AMTo: emerald@iea-software.comSubject: Re: Database Size.
Scott Burch wrote:>> So... The question is...How do I do a calls consolidation.
If you are running Emerald 2.2, run the consol.sql script in isql_wonce against your database (the script is in /emerald/beta on theftp site and only install the two procs 2.2 needs).
I do recommend using 2.2, but 2.1 should work as well. For 2.2, onthe batch tab, click the summary button. When the select list ispoopulated, select teh highest number in the left hand column (usuallythe last entry) and click charges. Repeat for each number in the lefthand column (in reverse order).
--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: SQL ErrorsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 17 Jun 1998 09:59:28 -0700
Richard Sensale wrote:> > Dale, where should this script be located. It doesn't seem to be on either> my local machine or the main radius server.
Its on our ftp server:
ftp://ftp.iea-software.com/Emerald/beta/checkdb.sql
PS, can you not include the v-card at the bottom of yourmessages? When converter to text its like 20+ lines andreally annoying (and doesn't follow the "text only" rule ofthe mailing list.
-- 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 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL ErrorsFrom: "Richard Sensale" <richards@visitus.net>Date: Wed, 17 Jun 1998 12:56:08 -0700
Sorry about that. I removed it.
Richard SensaleNetwork AdministratorVisitUs Internet, Inc.5468 Schaefer RoadDearborn, MI 48126 USA(313) 945-5588(313) 945-0202 faxhttp://www.visitus.netrichards@visitus.net-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: emerald@iea-software.com <emerald@iea-software.com>Date: Wednesday, June 17, 1998 4:52 AMSubject: Re: SQL Errors
>Richard Sensale wrote:>>>> Dale, where should this script be located. It doesn't seem to be oneither>> my local machine or the main radius server.>>Its on our ftp server:>>ftp://ftp.iea-software.com/Emerald/beta/checkdb.sql>>PS, can you not include the v-card at the bottom of your>messages? When converter to text its like 20+ lines and>really annoying (and doesn't follow the "text only" rule of>the mailing list.>>-->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 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: SQL Errors from Emerald AdminFrom: "Pat Augustine" <ereth@ilnk.com>Date: Wed, 17 Jun 1998 13:10:39 -0400
Dale, We are (and have been for some time) using Emerald Admin 2.1.0. We recentlyinstalled the new Radius NT 2.5. When I went to change some Radiusattributes in the Admin I got the following message:
Insert error: column name or number of supplied values does not match tabledefinition.
Radius NT 2.5 added some new columns to RadATConfig and apparently we can'tinsert new rows into it with the current administrator. The only updatedAdministrator I see on the web site is for Emerald 2.2 and you've long saidnot to get 2.2 unless you absolutely had to. Would that Administrator solvethis (with or without upgrading to Emerald 2.2)? If not, do you have a newone, or should we wait for Emerald 2.5?
Thanks.
Pat AugustineInterlink America
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Importing bookkeeping dataFrom: Daniel Mpolokoso <daniel@zamnet.zm>Date: Wed, 17 Jun 1998 20:50:01 +0200
Dale,
Don't you think it would be of benefit to provider a user-friendly interfaceinto Emerald for importation of data? For example, why not have a fixedformat record definition for MBR which can then be imported directly intoEmerald? Post.Office, for example, uses templates for account creation andmodification.
Another example could be importation of billing information generatedoutside of Emerald. Surely the interface isn't that complex, so long ascertain rules are adhered to. I realise there may be a level of complexityin the inner-workings of Emerald and interaction with the database, butsurely, end-users shouldn't have to be SQL Server gurus as well?
Regards,
Daniel.
Dale E. Reed Jr. wrote:> > Olivier Astier wrote:> >> > I want to import data from my current Bookkeepping software : QuickBook> > I have recovered the quickbook data in text and excel format.> > The problem is that I don't know how to import them in the Emerald SQL> > database. I think I could create a SQL query by inserting the right SQL> > commands between the database fields in Excel, but I don't know wich> > commands and maybe there's an easier way to do this.> > If you already faced this problem could you help me with that? Please assume> > that my SQL skills are limited ; but I learn quickly.> > This is not a trvial task to accomplish and without in depth SQL> experience and knowledge, I can only recommend you talk to us> about doing it for you. It typically takes about 5-6 hours of> consulting to convert a CSV or excel type user information into> Emerald. The cost is minimal compared to the time and effort> you would put into it yourself trying to accomplish this.> > Please don't take this the wrong way, as I am not saying you> couldn't do it. Its just that we have had a lot of customers> who were in-experienced in SQL Server try, and they all eventually> just asked us to do it. I'm trying to save you from going down> that same road. :)> > --> 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
-- ------------------------------------------------------------------------Daniel Mpolokoso - Technical Manager, Email: daniel@zamnet.zmZAMNET Communication Systems Limited, Phone: +260 - 1 - 751751P.O. Box 32379, Lusaka, Zambia. Fax: +260 - 1 - 290358
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Importing bookkeeping dataFrom: "Boyd Goodin" <boyd@planetc.com>Date: Wed, 17 Jun 1998 17:34:04 -0400
-----Original Message-----From: Daniel Mpolokoso <daniel@zamnet.zm>To: emerald@iea-software.com <emerald@iea-software.com>Date: Wednesday, June 17, 1998 2:53 PMSubject: Re: Importing bookkeeping data
>Dale,>>Don't you think it would be of benefit to provider a user-friendlyinterface>into Emerald for importation of data? For example, why not have a fixed>format record definition for MBR which can then be imported directly into>Emerald? Post.Office, for example, uses templates for account creation and>modification.
This I would have to agree with. With 3000+ customers it would be niceto have an import utility. As just evailuating the software now I would notwant to have to add them all in to accomodate the number of NAS's that wehave. This is one of the things that I will have to take into account whenit comes time to tell the boss to buy it or not.
Boyd GoodinPlanet systems Inc. Usenet News via Satellite!Both North America and Europe feeds!Technical Director423-623-8300Web: www.planetc.com/satellite
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Database Size.From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 17 Jun 1998 14:36:19 -0700
Scott Burch wrote:> > What risk are associated with running this script. Can I run it while the> system is up?
It just installs the proc. It doesn't actually do the consolidation.
> If you are running Emerald 2.2, run the consol.sql script in isql_w> once against your database (the script is in /emerald/beta on the> ftp site and only install the two procs 2.2 needs).> > I do recommend using 2.2, but 2.1 should work as well. For 2.2, on> the batch tab, click the summary button. When the select list is> poopulated, select teh highest number in the left hand column (usually> the last entry) and click charges. Repeat for each number in the left> hand column (in reverse order).> > --> 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
-- 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 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Database Size.From: "Scott Burch" <sburch@bmni.com>Date: Wed, 17 Jun 1998 14:35:12 -0700
I guess what I should have said is, what risk is there to doing theconsolidation. Our database has crashed on us a few times this last week andI don't need anymore problems. But, I sure would like to shrink the size ofour database. 900MB is a little ridiculous. Suggestions?
Scott BurchBenchmark Networking, Inc.sburch@bmni.com
-----Original Message-----From: emerald-request@iea-software.com[mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.Sent: Wednesday, June 17, 1998 2:36 PMTo: emerald@iea-software.comSubject: Re: Database Size.
Scott Burch wrote:>> What risk are associated with running this script. Can I run it while the> system is up?
It just installs the proc. It doesn't actually do the consolidation.
> If you are running Emerald 2.2, run the consol.sql script in isql_w> once against your database (the script is in /emerald/beta on the> ftp site and only install the two procs 2.2 needs).>> I do recommend using 2.2, but 2.1 should work as well. For 2.2, on> the batch tab, click the summary button. When the select list is> poopulated, select teh highest number in the left hand column (usually> the last entry) and click charges. Repeat for each number in the left> hand column (in reverse order).>> --> 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
--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 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Database SchemaFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 17 Jun 1998 14:41:04 -0700
Albert Churba wrote:> > Does anyone know where a list of the database schema for the Emerald Suite> can be found? What I'm looking for is similar to the RadiusNT documentation> section ODBC Database Schema Table Layout.
I just copied the technical.doc from Emerald 2.5 to the /emerald/betadirectory on the FTP site. It should answer all the questionson the database schema and is in the same format at the RadiusNT2.5 manual.
-- 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 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: CR 6.0 GraphsFrom: "John Dodd" <jmdodd@mychoice.net>Date: Wed, 17 Jun 1998 18:05:14 -0500
Does anybody know what files are used by emerald to display graphsor charts in Crystal Reports 6.0???
My reports look fine if I open them from CR 6.0, but if I open themfrom Emerald, I get all the info for the report except the graph.
I'm running Emerald 2.1.11, SQL 6.5, and of course CR6.0.....
Thank You,JohnMyChoice.Net
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Database Size.From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 17 Jun 1998 17:04:44 -0700
Scott Burch wrote:> > I guess what I should have said is, what risk is there to doing the> consolidation. Our database has crashed on us a few times this last week and> I don't need anymore problems. But, I sure would like to shrink the size of> our database. 900MB is a little ridiculous. Suggestions?
You can either do a consolidation, delete the older data, or truncatethe table. All will greatly affect your SQL Server during the operation(except maybe the truncate). I explained the consolidation in my previous post. If You wan todo one of the others, let me know.
-- 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