Message 2: client preferences problem - 2.2.38
from "Bill Bongiorno" <bill@systec.com>
Message 3: Re: On Line Calls
from "Richard Sensale" <wolfen@visitus.net>
Message 4: Re: Batch Problems
from "Adam Greene" <adam@webjogger.net>
Message 5: NAS Cisco , Unix etc..
from James <daj4@mcmedia.com.au>
Message 6: RE: Error adding service
from "Bill Bongiorno" <bill@systec.com>
Message 7:
from webmaster@auroranet.nt.ca (Franco Nogarin)
Message 8: Emerald won't run today, Take II
from Jeff Woods <jwoods@delta.com>
Message 9: remove emerald
from webmaster@auroranet.nt.ca (Franco Nogarin)
Message 10: Emerald would not issue a Renewal-Invoice
from "Mohammed Ersan" <ersan@first.net.jo>
Message 11: On Line Calls Revisited
from "Richard Sensale" <richards@visitus.net>
Message 12: Re: Emerald would not issue a Renewal-Invoice
from Jeff Woods <jwoods@delta.com>
Message 13: Re: Emerald would not issue a Renewal-Invoice
from "Richard Sensale" <richards@visitus.net>
Message 14: Re: Emerald would not issue a Renewal-Invoice
from "Mohammed Ersan" <ersan@first.net.jo>
Message 15: Re: On Line Calls Revisited
from Robert Boyle <robert@garden.net>
Message 16: Re: On Line Calls Revisited
from "Richard Sensale" <richards@visitus.net>
Message 17: Re: On Line Calls Revisited
from "Richard Sensale" <richards@visitus.net>
Message 18: Automated on-line subscription of new customers
from "Olivier Astier (Echoweb)" <astier@echoweb.net>
Message 19: credit card error
from "Bill Bongiorno" <bill@systec.com>
Message 20: Re: credit card error
from "Alan D. Criado" <ACriado@elink.net>
Message 21: Re: credit card error
from "Alan D. Criado" <ACriado@elink.net>
Message 22: FW: credit card error
from "Bill Bongiorno" <bill@systec.com>
Message 23: Emerald won't run today, Take III
from Jeff Woods <jwoods@delta.com>
Message 24: Re: Emerald would not issue a Renewal-Invoice
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 25: RE: credit card error
from "Bill Bongiorno" <bill@systec.com>
Message 26: Re: credit card error
from System Operator <sysop@i-star.net>
Message 27: list commands
from webmaster@auroranet.nt.ca (Franco Nogarin)
Message 28: RE: credit card error
from "Bill Bongiorno" <bill@systec.com>
Message 29: RE: Emerald would not issue a Renewal-Invoice
from "Greg Keys" <greg@loclnet.com>
Message 30: Invoices will not print
from "Greg Keys" <greg@loclnet.com>
Message 31: Re: credit card error
from System Operator <sysop@i-star.net>
Message 32: Re: Error adding service
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 33: Run-time error '30009': Invalid Row Value
from "Brian Johnson" <brian@hdc.net>
Message 34: Re: On Line Calls Revisited
from iml@interconnect.net
Message 35: Re: credit card error
from Robert Boyle <robert@garden.net>
Message 36: Some minor problems with 2.5.74
from Robert Boyle <robert@garden.net>
Message 37: Some minor problems with 2.5.74 (II)
from Robert Boyle <robert@garden.net>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: login to the sql server
From: "vincent b" <vincent_911@hotmail.com>
Date: Wed, 03 Jun 1998 01:48:47 PDT
is there somebody who have alredy made a graphic interface whith vb5.0
to access on a sql server and use the sql server's password.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: client preferences problem - 2.2.38
From: "Bill Bongiorno" <bill@systec.com>
Date: Wed, 3 Jun 1998 08:41:19 -0400
When I check and save "Incremental Batch," the selection is not retained.
However, if I select "no time charges" and recall the preferences,
"Incremental Batch" is checked and "no time charges" is not.
Can I assume that checking "no time charges" is actually activating
"Incremental Batch?" Also, the manual does not explain the purpose of "no
time charges" and "don't verify reports." Please explain these options.
Bill Bongiorno
SysTec Computer Associates, Inc.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: On Line Calls
From: "Richard Sensale" <wolfen@visitus.net>
Date: Wed, 3 Jun 1998 09:08:49 -0400
Well. the Max is set to that port for accounting, the timeout is right.But
the online calls section still says 0 users on 0 term severs. Is there
anything else I might be missing?
I was referring to the emerald docs on line call monitor ing section, where
it just says ask your network administrator.
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Tuesday, June 02, 1998 8:48 PM
Subject: Re: On Line Calls
>Richard Sensale wrote:
>>
>> The online accounting is set up in the max. pardon the weird email
address,
>> Im replying from home. I need to know if there are any specific settings
I
>> have to put in the Max. The docs are very vague on this point.
>
>You should configure the MAX to send accounting requests to port 1646 and
>a timeout of atleast 3-5 seconds.
>
>There isn't a tremendous amount of confgiuration envoled, and the
>RadiusNT docs cover this. Can you expand on what is "vague"?
>
>--
>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: Batch Problems
From: "Adam Greene" <adam@webjogger.net>
Date: Wed, 3 Jun 1998 09:25:17 -0400
That must be the problem.
You must enter the date the invoices were generated on the Batch Tab.
Emerald will look for Invoices that were created on the date you enter on
the Batch tab.
Adam
-----Original Message-----
From: Richard Sensale <richards@visitus.net>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: 02 June 1998 16:29
Subject: Re: Batch Problems
>We set the date for about 2 weeks prior and all unpaid.
>-----Original Message-----
>From: Dale E. Reed Jr. <daler@iea-software.com>
>To: emerald@iea-software.com <emerald@iea-software.com>
>Date: Tuesday, June 02, 1998 8:16 AM
>Subject: Re: Batch Problems
>
>
>>Richard Sensale wrote:
>>>
>>> Hi we still seem unable to brint out a batch of invoices and are reduced
>to
>>> printing them out one at a time. When we try to do a batch it seems to
>>> process all necessary invoices but when we try to print it, all we get
in
>>> the preview is a single blank invoice. Are we doing something wrong?
>>
>>Are you changing the date to today's date (or the date the invoices
>>were created)? Using a future date to print will almost always get
>>you a blank invoice, because there were no invoices created in the
>>future (yet). :)
>>
>>--
>>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 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: NAS Cisco , Unix etc..
From: James <daj4@mcmedia.com.au>
Date: Wed, 3 Jun 1998 23:40:24 +1000 (EST)
I have been reading about your product and it looks great but before I get
too enthusiastic can you help me on these few points
1. Can I use cisco products as the NAS?
2. Can I use UNIX radius instead of NT?
3. Can another dactuve atabase be merged into the Microsoft sql database
which is used for Emerald?
Thanks
Daryl
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 6 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Error adding service
From: "Bill Bongiorno" <bill@systec.com>
Date: Wed, 3 Jun 1998 10:19:25 -0400
This corrected the Invalid MasterLog error but I am still getting the
"Emerald Error 76:Path not Found." The other client using Emerald is not
getting this error.
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Tuesday, June 02, 1998 5:32 PM
> To: emerald@iea-software.com
> Subject: Re: Error adding service
>
>
> Bill Bongiorno wrote:
> >
> > We just upgraded to 2.2.38. When we save a service we receive message
> > "Invalid MasterLog entry for External ntmail." When we acknowledge this
> > message we receive "Emerald Error 76:Path not Found". Despite
> these messages
> > everything seems to updating correctly.
>
> Most likely the problem is the "type" of external system. Go into
> the Admin, and change the type from standard/export to NTMail.
>
> --
> 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:
From: webmaster@auroranet.nt.ca (Franco Nogarin)
Date: Wed, 3 Jun 1998 08:43:56 -0600
unsubscribe emerald
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 8 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Emerald won't run today, Take II
From: Jeff Woods <jwoods@delta.com>
Date: Wed, 03 Jun 1998 10:52:29 -0400
Emerald was open last night, functioning properly.
I tried to run a batch invoice run this morning. It CREATED the batches
fine, so it said (and an SQL query shows this to be true). However, when I
tried to print the batch, I was told that I did not have logon permissions
to do so! (I was logged on as SA at the time!) "Self," I said to myself,
"it looks like you need to reboot your workstation.
After rebooting, I got "Error loading from file" when trying to load
Emerald. I can't get into Emerald at all now. (I also rebooted the SQL
server at the same time, just in case).
RadiusNT is still running fine, authenticating and accounting. I can run
SQL Enterprise Manager, and view the databases and make queries from this
workstation. Emerald is not installed on any other workstations, but I
imagine that it WOULD work from there.
I believe that a program I installed yesterday overwrote a critical library
needed by Emerald. Which one, I don't know.
Dale, can you tell me which library being replaced could cause this error,
and where I can find the one YOU require, before Friday morning when I have
to finish this billing cycle?
I spoke to the author of the offending program, which DOES do database
accesses of its own, and he claimed these are the DLL files (all *.DLL)
that he installs:
MSVBVM50
OLEAUT32
OLDPRO32
ASYCFILT
MSC40
MSJET35
MSJTR35
MSJINT35
VBAJET32
VBAR332
MSRD2X35
MSREPL35
VB5DB
DAO350
COMCAT
Emerald 2.1.11 on Win95.
Thanks!
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 9 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: remove emerald
From: webmaster@auroranet.nt.ca (Franco Nogarin)
Date: Wed, 3 Jun 1998 09:15:12 -0600
remove emerald
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 10 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Emerald would not issue a Renewal-Invoice
From: "Mohammed Ersan" <ersan@first.net.jo>
Date: Wed, 03 Jun 1998 18:07:19 +0300
Hi dale,
emerald just won't issue a renewal for customer that expired on May 17, it did not issue in the batch process nor on the manual Renewal issuance I've tried 2.2.23 or 2.2.42 and same thing "No new invoices to create!"
<center>M. Ersan
ersan@first.net.jo
firstnet
</center>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 11 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: On Line Calls Revisited
From: "Richard Sensale" <richards@visitus.net>
Date: Wed, 3 Jun 1998 11:47:09 -0700
Okay I have insured that the following is true.
Our term server is set up in the Emerald Admin Config under Radius Config.
I have set the prots to 48, I have isnured that it is using the proper port
in the MAX as well. I re-ported the config as well just to make sure.
Still I get nothing in Emerald under On Line Calls. Are there any other
settings I need to put in radius, Emerald, or the MAX? I am running version
2.11.1 of emerald.
Thanks.
Richard Sensale
Network Administrator
VisitUs Internet, Inc.
5468 Schaefer Road
Dearborn, MI 48126 USA
(313) 945-5588
(313) 945-0202 fax
http://www.visitus.net
richards@visitus.net
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 12 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Emerald would not issue a Renewal-Invoice
From: Jeff Woods <jwoods@delta.com>
Date: Wed, 03 Jun 1998 11:51:30 -0400
Does the customer's MBR have the "Active" box checked?
Are there ANY services with the "Active" box checked, associated with the
MBR?
-------------
If the above both answer yes....
Does this customer have ANY other invoices outstanding? Go to the
INVOICES tab, put the user's name or login there, and UNCHECK "Unpaid
only invoices". Click SEARCH. All past invoices for the customer
should show up. (If they don't, you typed int he login or name
incorrectly -- try again until the old invoices show up -- I'm assuming
there are prior invoices, not a new customer).
Once the invoice list is up, THEN put a check on "Show unpaid invoices
only". Do NOT hit CLEAR before doing this.
Click search again.
If any invoices remain in the list, they must be PAID prior to Emerald
creating a NEW invoice for that customer.
---------------
At 06:07 PM 6/3/98 +0300, you wrote:
>>>>
<excerpt>Hi dale,
emerald just won't issue a renewal for customer that expired on May
17, it did not issue in the batch process nor on the manual Renewal
issuance I've tried 2.2.23 or 2.2.42 and same thing "No new invoices to
create!"
<center>M. Ersan
ersan@first.net.jo
firstnet
</center>
</excerpt><<<<<<<<
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 13 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Emerald would not issue a Renewal-Invoice
From: "Richard Sensale" <richards@visitus.net>
Date: Wed, 3 Jun 1998 11:48:02 -0700
Mine is doing the same thing now. I tried setting the batch for like 4/1/98
and still nothing even though we have multiple unpaid invoices. Im running
2.11.1
-----Original Message-----
From: Mohammed Ersan <ersan@first.net.jo>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Wednesday, June 03, 1998 3:44 AM
Subject: Emerald would not issue a Renewal-Invoice
>Hi dale,
>
>emerald just won't issue a renewal for customer that expired on May 17, it
did not issue in the batch process nor on the manual Renewal issuance I've
tried 2.2.23 or 2.2.42 and same thing "No new invoices to create!"
>
>
>
>
>
>
>M. Ersan
>ersan@first.net.jo
>firstnet
>
>
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 14 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Emerald would not issue a Renewal-Invoice
From: "Mohammed Ersan" <ersan@first.net.jo>
Date: Wed, 03 Jun 1998 19:03:38 +0300
<excerpt>Does the customer's MBR have the "Active" box checked?
Are there ANY services with the "Active" box checked, associated with the
MBR?
</excerpt><<<<<<<<
yes
>>>>
<excerpt>------------
If the above both answer yes....
Does this customer have ANY other invoices outstanding? Go to the
INVOICES tab, put the user's name or login there, and UNCHECK "Unpaid
only invoices". Click SEARCH. All past invoices for the customer
should show up. (If they don't, you typed int he login or name
incorrectly -- try again until the old invoices show up -- I'm assuming
there are prior invoices, not a new customer).
Once the invoice list is up, THEN put a check on "Show unpaid invoices
only". Do NOT hit CLEAR before doing this.
Click search again.
If any invoices remain in the list, they must be PAID prior to Emerald
creating a NEW invoice for that customer.
</excerpt><<<<<<<<
No there aren't any Unpaid invoices for this customer
>>>>
<center>M. Ersan
ersan@first.net.jo
firstnet
</center>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 15 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: On Line Calls Revisited
From: Robert Boyle <robert@garden.net>
Date: Wed, 03 Jun 1998 13:11:47 -0400
At 11:47 AM 6/3/98 -0700, you wrote:
>Okay I have insured that the following is true.
>
>Our term server is set up in the Emerald Admin Config under Radius Config.
>I have set the prots to 48, I have isnured that it is using the proper port
>in the MAX as well. I re-ported the config as well just to make sure.
>Still I get nothing in Emerald under On Line Calls. Are there any other
>settings I need to put in radius, Emerald, or the MAX? I am running version
>2.11.1 of emerald.
In ISQL_W or SEM run the following query:
CREATE TRIGGER calls_insert ON dbo.Calls
FOR INSERT
AS
UPDATE ServerPorts
Set sp.UserName = i.UserName,
sp.AcctStatusType = i.AcctStatusType,
sp.CallDate = DateAdd(Second, 0-i.AcctDelayTime, i.CallDate),
sp.FramedAddress = i.FramedAddress
FROM Servers s, ServerPorts sp, inserted i
WHERE s.IPAddress = i.NASIdentifier AND
s.ServerID = sp.ServerID AND
sp.Port = i.NASPort AND
(DateAdd(Second, 0-i.AcctDelayTime, i.CallDate) > sp.CallDate OR
sp.CallDate IS NULL)
UPDATE SubAccounts
Set sa.TimeLeft = sa.TimeLeft - (i.AcctSessionTime/60 + 1)
FROM SubAccounts sa, inserted i
WHERE sa.login = i.UserName
and sa.TimeLeft <> NULL
and i.AcctStatusType = 2
GO
Robert Boyle Server Co-location,
Garden Networks Internet Access,
50 Diller Ave Development & Consulting
Newton, NJ 07860 (973)300-9211 Ext.103
8AM-8PM Mon-Fri EST http://www.garden.net
Lucent RABU & Software.Com Post.Office VAR
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 16 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: On Line Calls Revisited
From: "Richard Sensale" <richards@visitus.net>
Date: Wed, 3 Jun 1998 13:18:41 -0700
Thanks, I'll see if that works. I really appreciate the help.
-----Original Message-----
From: Robert Boyle <robert@garden.net>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Wednesday, June 03, 1998 5:11 AM
Subject: Re: On Line Calls Revisited
>At 11:47 AM 6/3/98 -0700, you wrote:
>>Okay I have insured that the following is true.
>>
>>Our term server is set up in the Emerald Admin Config under Radius Config.
>>I have set the prots to 48, I have isnured that it is using the proper
port
>>in the MAX as well. I re-ported the config as well just to make sure.
>>Still I get nothing in Emerald under On Line Calls. Are there any other
>>settings I need to put in radius, Emerald, or the MAX? I am running
version
>>2.11.1 of emerald.
>
>In ISQL_W or SEM run the following query:
>
>CREATE TRIGGER calls_insert ON dbo.Calls
>FOR INSERT
>AS
> UPDATE ServerPorts
> Set sp.UserName = i.UserName,
> sp.AcctStatusType = i.AcctStatusType,
> sp.CallDate = DateAdd(Second, 0-i.AcctDelayTime, i.CallDate),
> sp.FramedAddress = i.FramedAddress
> FROM Servers s, ServerPorts sp, inserted i
> WHERE s.IPAddress = i.NASIdentifier AND
> s.ServerID = sp.ServerID AND
> sp.Port = i.NASPort AND
> (DateAdd(Second, 0-i.AcctDelayTime, i.CallDate) > sp.CallDate OR
> sp.CallDate IS NULL)
>
> UPDATE SubAccounts
> Set sa.TimeLeft = sa.TimeLeft - (i.AcctSessionTime/60 + 1)
> FROM SubAccounts sa, inserted i
> WHERE sa.login = i.UserName
> and sa.TimeLeft <> NULL
> and i.AcctStatusType = 2
>GO
>
>
>
>Robert Boyle Server Co-location,
>Garden Networks Internet Access,
>50 Diller Ave Development & Consulting
>Newton, NJ 07860 (973)300-9211 Ext.103
>8AM-8PM Mon-Fri EST http://www.garden.net
>Lucent RABU & Software.Com Post.Office VAR
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 17 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: On Line Calls Revisited
From: "Richard Sensale" <richards@visitus.net>
Date: Wed, 3 Jun 1998 13:27:58 -0700
I tried to run the query and got the following error message..
msg 170, Level 15 State 1
Line 4: Incorrect syntax near ' '
Any ideas?
-----Original Message-----
From: Robert Boyle <robert@garden.net>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Wednesday, June 03, 1998 5:11 AM
Subject: Re: On Line Calls Revisited
>At 11:47 AM 6/3/98 -0700, you wrote:
>>Okay I have insured that the following is true.
>>
>>Our term server is set up in the Emerald Admin Config under Radius Config.
>>I have set the prots to 48, I have isnured that it is using the proper
port
>>in the MAX as well. I re-ported the config as well just to make sure.
>>Still I get nothing in Emerald under On Line Calls. Are there any other
>>settings I need to put in radius, Emerald, or the MAX? I am running
version
>>2.11.1 of emerald.
>
>In ISQL_W or SEM run the following query:
>
>CREATE TRIGGER calls_insert ON dbo.Calls
>FOR INSERT
>AS
> UPDATE ServerPorts
> Set sp.UserName = i.UserName,
> sp.AcctStatusType = i.AcctStatusType,
> sp.CallDate = DateAdd(Second, 0-i.AcctDelayTime, i.CallDate),
> sp.FramedAddress = i.FramedAddress
> FROM Servers s, ServerPorts sp, inserted i
> WHERE s.IPAddress = i.NASIdentifier AND
> s.ServerID = sp.ServerID AND
> sp.Port = i.NASPort AND
> (DateAdd(Second, 0-i.AcctDelayTime, i.CallDate) > sp.CallDate OR
> sp.CallDate IS NULL)
>
> UPDATE SubAccounts
> Set sa.TimeLeft = sa.TimeLeft - (i.AcctSessionTime/60 + 1)
> FROM SubAccounts sa, inserted i
> WHERE sa.login = i.UserName
> and sa.TimeLeft <> NULL
> and i.AcctStatusType = 2
>GO
>
>
>
>Robert Boyle Server Co-location,
>Garden Networks Internet Access,
>50 Diller Ave Development & Consulting
>Newton, NJ 07860 (973)300-9211 Ext.103
>8AM-8PM Mon-Fri EST http://www.garden.net
>Lucent RABU & Software.Com Post.Office VAR
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 18 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Automated on-line subscription of new customers
From: "Olivier Astier (Echoweb)" <astier@echoweb.net>
Date: Wed, 3 Jun 1998 11:57:26 -0700
Hello,
I am excited by the Emerald features but I am also very interested in an
automated on-line subscription of new customers (as Rodopi does). Does
someone know how to do it with Emerald? Will it be integrated in the version
2.5 of Emerald?
Thank you for your attention.
Oliver Astier
EchoWeb LLC.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 19 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: credit card error
From: "Bill Bongiorno" <bill@systec.com>
Date: Wed, 3 Jun 1998 16:08:03 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01BD8F09.C9D37CC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
We are trying to process credit cards for the first time. We are using
ICVerify. The BatchOut worked and the charges were submitted and approved.
When we select BatchIn and click OK to the 3 transactions processed message,
we receive a "three errors encountered" message. Attached is the batchin.dat
file from ICVerify. Does anyone know what's wrong?
Bill Bongiorno
SysTec Computer Associates, Inc.
------=_NextPart_000_0008_01BD8F09.C9D37CC0
Content-Type: application/octet-stream;
name="BATCHIN.DAT"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="BATCHIN.DAT"
"C1","administrator","2","5369939030305000","0799","19.95"
"C1","administrator","3","5115100410736044","0301","19.95"
"C1","administrator","4","372858056491005","0399","19.95"
------=_NextPart_000_0008_01BD8F09.C9D37CC0--
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 20 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: credit card error
From: "Alan D. Criado" <ACriado@elink.net>
Date: Wed, 03 Jun 1998 16:13:54 -0400
Hi Bill.
I don't have an answer to your problem. However, please take it for what's
worth, don't pass out valid credit card numbers and expiration dates on a
mailing list.
Take care.
Alan
At 04:08 PM 6/3/98 -0400, Bill Bongiorno wrote:
>We are trying to process credit cards for the first time. We are using
>ICVerify. The BatchOut worked and the charges were submitted and approved.
>When we select BatchIn and click OK to the 3 transactions processed message,
>we receive a "three errors encountered" message. Attached is the batchin.dat
>file from ICVerify. Does anyone know what's wrong?
>
>Bill Bongiorno
>SysTec Computer Associates, Inc.
>
>
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 21 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: credit card error
From: "Alan D. Criado" <ACriado@elink.net>
Date: Wed, 03 Jun 1998 16:13:54 -0400
Hi Bill.
I don't have an answer to your problem. However, please take it for what's
worth, don't pass out valid credit card numbers and expiration dates on a
mailing list.
Take care.
Alan
At 04:08 PM 6/3/98 -0400, Bill Bongiorno wrote:
>We are trying to process credit cards for the first time. We are using
>ICVerify. The BatchOut worked and the charges were submitted and approved.
>When we select BatchIn and click OK to the 3 transactions processed message,
>we receive a "three errors encountered" message. Attached is the batchin.dat
>file from ICVerify. Does anyone know what's wrong?
>
>Bill Bongiorno
>SysTec Computer Associates, Inc.
>
>
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 22 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: FW: credit card error
From: "Bill Bongiorno" <bill@systec.com>
Date: Wed, 3 Jun 1998 16:16:20 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_000D_01BD8F0A.F1D8BCC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Sorry, I attached the wrong file to the last message. Below is the correct
file.
-----Original Message-----
From: Bill Bongiorno [mailto:bill@systec.com]
Sent: Wednesday, June 03, 1998 4:08 PM
To: emerald mailing list
Subject: credit card error
We are trying to process credit cards for the first time. We are using
ICVerify. The BatchOut worked and the charges were submitted and approved.
When we select BatchIn and click OK to the 3 transactions processed message,
we receive a "three errors encountered" message. Attached is the batchin.dat
file from ICVerify. Does anyone know what's wrong?
Bill Bongiorno
SysTec Computer Associates, Inc.
------=_NextPart_000_000D_01BD8F0A.F1D8BCC0
Content-Type: application/octet-stream;
name="BATCHOUT.DAT"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="BATCHOUT.DAT"
"06-03-1998","15:30:34","Y003675","A1995","","000005"
"06-03-1998","15:30:40","Y003751","A1995","","000006"
"06-03-1998","15:30:45","Y986359","A1995","","000007"
------=_NextPart_000_000D_01BD8F0A.F1D8BCC0--
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 23 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Emerald won't run today, Take III
From: Jeff Woods <jwoods@delta.com>
Date: Wed, 03 Jun 1998 16:19:47 -0400
Didn't see a followup, so perhaps the list bounced me yet again. Last
attempt at this via this forum.....
Emerald was open last night, functioning properly.
I tried to run a batch invoice run this morning. It CREATED the batches
fine, so it said (and an SQL query shows this to be true). However, when I
tried to print the batch, I was told that I did not have logon permissions
to do so! (I was logged on as SA at the time!) "Self," I said to myself,
"it looks like you need to reboot your workstation.
After rebooting, I got "Error loading from file" when trying to load
Emerald. I can't get into Emerald at all now. (I also rebooted the SQL
server at the same time, just in case).
RadiusNT is still running fine, authenticating and accounting. I can run
SQL Enterprise Manager, and view the databases and make queries from this
workstation. Emerald is not installed on any other workstations, but I
imagine that it WOULD work from there.
I believe that a program I installed yesterday overwrote a critical library
needed by Emerald. Which one, I don't know.
Dale, can you tell me which library being replaced could cause this error,
and where I can find the one YOU require, before Friday morning when I have
to finish this billing cycle?
I spoke to the author of the offending program, which DOES do database
accesses of its own, and he claimed these are the DLL files (all *.DLL)
that he installs:
MSVBVM50
OLEAUT32
OLDPRO32
ASYCFILT
MSC40
MSJET35
MSJTR35
MSJINT35
VBAJET32
VBAR332
MSRD2X35
MSREPL35
VB5DB
DAO350
COMCAT
Emerald 2.1.11 on Win95.
Thanks!
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 24 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Emerald would not issue a Renewal-Invoice
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Wed, 03 Jun 1998 13:26:44 -0700
Richard Sensale wrote:
>
> Mine is doing the same thing now. I tried setting the batch for like 4/1/98
> and still nothing even though we have multiple unpaid invoices. Im running
> 2.11.1
> >emerald just won't issue a renewal for customer that expired on May 17, it
> did not issue in the batch process nor on the manual Renewal issuance I've
> tried 2.2.23 or 2.2.42 and same thing "No new invoices to create!"
The typical reason for this is because you moved the expiration
date of the MBR back, and not have an overlapping billing cycle.
You must either void the overlapping invoice, or move the expiration
date to the enddate of the last invoice for it to bill the customer.
Use the history tab on the MBR, find the last invoice, and check the
end date. Then compare that to the expire date. The exipre date
MUST be latter (or equal to) that end date.
-- 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 25 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: credit card errorFrom: "Bill Bongiorno" <bill@systec.com>Date: Wed, 3 Jun 1998 16:32:39 -0400
Oooooooops! Thanks, I just didn't think about it.
> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Alan D. Criado> Sent: Wednesday, June 03, 1998 4:14 PM> To: emerald@iea-software.com; emerald mailing list> Subject: Re: credit card error> > > > Hi Bill.> > I don't have an answer to your problem. However, please take it > for what's> worth, don't pass out valid credit card numbers and expiration dates on a> mailing list.> > Take care.> > Alan> > > At 04:08 PM 6/3/98 -0400, Bill Bongiorno wrote:> >We are trying to process credit cards for the first time. We are using> >ICVerify. The BatchOut worked and the charges were submitted and > approved.> >When we select BatchIn and click OK to the 3 transactions > processed message,> >we receive a "three errors encountered" message. Attached is the > batchin.dat> >file from ICVerify. Does anyone know what's wrong?> >> >Bill Bongiorno> >SysTec Computer Associates, Inc.> >> >> > >
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 26 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: credit card errorFrom: System Operator <sysop@i-star.net>Date: Wed, 03 Jun 1998 16:37:09 -0400
Bill, what version of Emerald are you using?
Dean
Bill Bongiorno wrote:> > We are trying to process credit cards for the first time. We are using> ICVerify. The BatchOut worked and the charges were submitted and approved.> When we select BatchIn and click OK to the 3 transactions processed message,> we receive a "three errors encountered" message. Attached is the batchin.dat> file from ICVerify. Does anyone know what's wrong?
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 27 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: list commandsFrom: webmaster@auroranet.nt.ca (Franco Nogarin)Date: Wed, 3 Jun 1998 15:01:48 -0600
someone please tell me the email address and the command to get off thelists, and dale, they should be clearly marked at the website, most peoplewant off a list in a hurry. They are not listed at all there.
Franco Nogarin
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 28 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: credit card errorFrom: "Bill Bongiorno" <bill@systec.com>Date: Wed, 3 Jun 1998 17:03:31 -0400
2.2.38
> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of System Operator> Sent: Wednesday, June 03, 1998 4:37 PM> To: emerald@iea-software.com> Subject: Re: credit card error> > > Bill, what version of Emerald are you using?> > Dean> > Bill Bongiorno wrote:> > > > We are trying to process credit cards for the first time. We are using> > ICVerify. The BatchOut worked and the charges were submitted > and approved.> > When we select BatchIn and click OK to the 3 transactions > processed message,> > we receive a "three errors encountered" message. Attached is > the batchin.dat> > file from ICVerify. Does anyone know what's wrong?>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 29 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Emerald would not issue a Renewal-InvoiceFrom: "Greg Keys" <greg@loclnet.com>Date: Wed, 3 Jun 1998 17:10:49 -0400
Dale/All
Dale, you were right per our conversation that the dates were overlapping.For anyone interested, here is the script I wrote that lists the offendinginvoices.if this turns up your invoices your problem is overlap.
//**************************************************************select i.invoiceid, i.customerid, i.startdate, i.enddate, ma.maexpiredate, i.sentdate, p.date, i.amount
from invoices i, masteraccounts ma, invoiceitems ii, payments p
where i.customerid=ma.customerid and i.enddate>ma.maexpiredate and (ii.invoiceid=i.invoiceid and ii.paymentid<>null) and ii.paymentid=p.paymentid
order by i.invoiceid
//**************************************************************The offending invoices can be changed with an UPDATE Statement that setsi.startdate=DATEADD(month,-1,ma.maexpiredate) and setsi.enddate=ma.maexpiredate
This does assume that all the offending invoices are for a one month periodand will require some minor adjustment if this is not the case.
> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.> Sent: Wednesday, June 03, 1998 4:27 PM> To: emerald@iea-software.com> Subject: Re: Emerald would not issue a Renewal-Invoice>>> Richard Sensale wrote:> >> > Mine is doing the same thing now. I tried setting the batch> for like 4/1/98> > and still nothing even though we have multiple unpaid invoices.> Im running> > 2.11.1>> > >emerald just won't issue a renewal for customer that expired> on May 17, it> > did not issue in the batch process nor on the manual Renewal> issuance I've> > tried 2.2.23 or 2.2.42 and same thing "No new invoices to create!">> The typical reason for this is because you moved the expiration> date of the MBR back, and not have an overlapping billing cycle.> You must either void the overlapping invoice, or move the expiration> date to the enddate of the last invoice for it to bill the customer.> Use the history tab on the MBR, find the last invoice, and check the> end date. Then compare that to the expire date. The exipre date> MUST be latter (or equal to) that end date.>> --> 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 30 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Invoices will not printFrom: "Greg Keys" <greg@loclnet.com>Date: Wed, 3 Jun 1998 17:23:08 -0400
Here is a fun one for all of you.
1. Went to the Batch tab in Emerald 2.2.382. Put in a date of the 17th of June and an Invoice Type of Renewal3. Created the invoices(so far, no problems: Created a bunch of Invoices)4. Set the date to Todays Date5. Selected Print6. The Invoice Report (CR Screen) Flashed up, disappeared, and a little boxappeared saying "SQL Error"
Now, before anyone asks, I am running CR 6.0 and it is installed on the sameworkstation.The report will run from inside crystal reports.I even went so far as to go to the FTP site and download the CR60Invoice.rpt file and replace my rpt file in case I changed something in thereport that was a booboo. Results??? (See above :)
Hmmmmmmmmm..............
P.S. If I go into CR60 and set the Selection Criteria to check the InvoiceDate=date(xxxx,x,x) and isnull(sentdate) the report still runs from withinCR.If I add Type="Renewal" to the criteria I get and ODBC DriverIncapable............
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
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 31 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: credit card errorFrom: System Operator <sysop@i-star.net>Date: Wed, 03 Jun 1998 17:17:48 -0400
Only batch-out is supported for ICverify with that version.2.5 will have added the batch-in portion.
Dean
Bill Bongiorno wrote:> > 2.2.38> > > -----Original Message-----> > From: emerald-request@iea-software.com> > [mailto:emerald-request@iea-software.com]On Behalf Of System Operator> > Sent: Wednesday, June 03, 1998 4:37 PM> > To: emerald@iea-software.com> > Subject: Re: credit card error> >> >> > Bill, what version of Emerald are you using?> >> > Dean> >> > Bill Bongiorno wrote:> > >> > > We are trying to process credit cards for the first time. We are using> > > ICVerify. The BatchOut worked and the charges were submitted> > and approved.> > > When we select BatchIn and click OK to the 3 transactions> > processed message,> > > we receive a "three errors encountered" message. Attached is> > the batchin.dat> > > file from ICVerify. Does anyone know what's wrong?> >
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 32 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Error adding serviceFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 03 Jun 1998 14:33:51 -0700
Bill Bongiorno wrote:> > This corrected the Invalid MasterLog error but I am still getting the> "Emerald Error 76:Path not Found." The other client using Emerald is not> getting this error.
Emerald is trying to verify/create the user's Home Directory, andthe machine/user Emerald is running on doesn't have access to the path.
Open up a DOS prompt and do a dir of the path and it willshow this.
-- 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 33 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Run-time error '30009': Invalid Row ValueFrom: "Brian Johnson" <brian@hdc.net>Date: Wed, 3 Jun 1998 20:20:42 -0500
When I open Emerald and go to the "On-Line" tab there are no loggied-inusers (Iknow this is false because when I telnet into my PortMaster there itis full. When I click anywhere in the tabe area, I get this message box. Run-time error '30009': Invalid Row Value
When I press "OK," Emerald Closes.
What do I have to do to solve this problem?
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 34 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: On Line Calls RevisitedFrom: iml@interconnect.netDate: Wed, 03 Jun 1998 20:32:52 -0500
Also, do some debugging in the max and see what is going on...also,you may want to run radiusnt in debug mode as well.
Just in case you didn't know in the max go into full access mode theninto debug mode CTRL-D then hit D for debug mode.
Once in debug mode type RADIF this will turn on radius debug mode inhe MAX.
On Wed, 3 Jun 1998 13:18:41 -0700, you wrote:
>Thanks, I'll see if that works. I really appreciate the help.>-----Original Message----->From: Robert Boyle <robert@garden.net>>To: emerald@iea-software.com <emerald@iea-software.com>>Date: Wednesday, June 03, 1998 5:11 AM>Subject: Re: On Line Calls Revisited>>>>At 11:47 AM 6/3/98 -0700, you wrote:>>>Okay I have insured that the following is true.>>>>>>Our term server is set up in the Emerald Admin Config under Radius =Config.>>>I have set the prots to 48, I have isnured that it is using the proper>port>>>in the MAX as well. I re-ported the config as well just to make sure.>>>Still I get nothing in Emerald under On Line Calls. Are there any =other>>>settings I need to put in radius, Emerald, or the MAX? I am running>version>>>2.11.1 of emerald.>>>>In ISQL_W or SEM run the following query:>>>>CREATE TRIGGER calls_insert ON dbo.Calls>>FOR INSERT>>AS>> UPDATE ServerPorts>> Set sp.UserName =3D i.UserName,>> sp.AcctStatusType =3D i.AcctStatusType,>> sp.CallDate =3D DateAdd(Second, 0-i.AcctDelayTime, i.CallDate),>> sp.FramedAddress =3D i.FramedAddress>> FROM Servers s, ServerPorts sp, inserted i>> WHERE s.IPAddress =3D i.NASIdentifier AND>> s.ServerID =3D sp.ServerID AND>> sp.Port =3D i.NASPort AND>> (DateAdd(Second, 0-i.AcctDelayTime, i.CallDate) > sp.CallDate OR>> sp.CallDate IS NULL)>>>> UPDATE SubAccounts>> Set sa.TimeLeft =3D sa.TimeLeft - (i.AcctSessionTime/60= + 1)>> FROM SubAccounts sa, inserted i>> WHERE sa.login =3D i.UserName>> and sa.TimeLeft <> NULL>> and i.AcctStatusType =3D 2>>GO>>>>>>>>Robert Boyle Server Co-location,>>Garden Networks Internet Access,>>50 Diller Ave Development & Consulting>>Newton, NJ 07860 (973)300-9211 Ext.103>>8AM-8PM Mon-Fri EST http://www.garden.net>>Lucent RABU & Software.Com Post.Office VAR>>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 35 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: credit card errorFrom: Robert Boyle <robert@garden.net>Date: Wed, 03 Jun 1998 22:03:29 -0400
At 04:08 PM 6/3/98 -0400, you wrote:>We are trying to process credit cards for the first time. We are using>ICVerify. The BatchOut worked and the charges were submitted and approved.>When we select BatchIn and click OK to the 3 transactions processed message,>we receive a "three errors encountered" message. Attached is the batchin.dat>file from ICVerify. Does anyone know what's wrong?>>Bill Bongiorno>SysTec Computer Associates, Inc.
You should be more careful about sending your customers credit card numbersto a mailing list. :O It looks like the cards are all for the administratoruser? Is that correct? Shouldn't the users login names be listed? I don'treally know, but this is just a guess!
-Robert
Robert Boyle Server Co-location,Garden Networks Internet Access,50 Diller Ave Development & ConsultingNewton, NJ 07860 (973)300-9211 Ext.1038AM-8PM Mon-Fri EST http://www.garden.netLucent RABU & Software.Com Post.Office VAR
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 36 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Some minor problems with 2.5.74From: Robert Boyle <robert@garden.net>Date: Wed, 03 Jun 1998 22:42:00 -0400
Dale/IEA,
This looks VERY nice so far. (Dale, I'm still waiting for the fixed versionof RadiusNT - post 116) I am thinking about deploying this release intoproduction next week. There are still some issues with E2.5/RNT2.5 which are:
1. In Radlogs, the NASIdentifier, NASPort, CallerID are always blankbecause RadiusNT isn't inserting anything.
2. In Emerald, on the Rad Log screen, clicking on the header doesn't sortthe contents of that field: Date, Username, Description, etc...
3. In On-Line, it would be nice if Emerald also displayed the CallerIDfield if available. I can add it to the trigger and view.
4. TSGraph always says that there are 0 calls so it doesn't graph much! :P(Yes there are calls in the calls table!)
I'm still reading the docs trying to get a handle on exactly how 2.5 worksbefore I report things that I think are bugs that I simply don't understandyet. The billing looks better, but far more confusing! ,) Overall, a MAJORupdate. It looks like it makes Emerald everything we want it to be. We'llsee how the billing works later this month.
-Robert
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 37 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Some minor problems with 2.5.74 (II)From: Robert Boyle <robert@garden.net>Date: Wed, 03 Jun 1998 23:09:58 -0400
A few more...
* In the SubAccount, Services Tab, Time On gives a "Error in SQL Statement"message.
* Debug mode doesn't work. I tried to look at the SQL statement above, butit doesn't show anything.
* The top level menu changes when a subaccount is open. This is REALLYannoying since I need to close whatever I'm in to check anything else. Notto mention that the interface is very logical except for this aberration.Everything else allows switching between sub-windows.
-Robert