Nathan Haywood
Systems Engineer
DB & SQL Programmer
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Beachlink
Administrator
Sent: Wednesday, November 24, 1999 10:47 AM
To: emerald@iea-software.com
Cc: support@iea-software.com
Subject: [Emerald] ICVerify Batching in Emerald 2.5.278
Yesterday, we performed our first Emerald 2.5 billing after using 2.2
for
quite some time without problems. We were anxious to use the new
ICVerify
batch-in feature, which would eliminate hours of work manually paying
invoices.
We created CC invoices, and batched them out. The batch file came out in
this format:
"C1","5010","Customer Name On CC","5424123456789012","0201","19.95"
Once I saw the new format, I added to and rearranged the "Import
Tansaction"
column list in ICVerify. All of the imported transactions seemed to
take,
and I Processed Offline Transactions in ICVerify. Immediately I saw a
problem with the new format of the Emerald Batch file... as seen below:
"C1","5011","Customer Name On CC, Jr.","4275123456789012","0802","19.95"
The comma in the Customer Name forced ICVerify to think that "Jr." was
the
CC Number, "4275123456789012" was the expire date, and $8.02 was the
amount
(see below). Of course, ICVerify let us know it was wrong and didn't
process
it. No problem, as there were only a few customers with commas in their
CC
Name. But the commas should be filtered out.
Next, I searched the ICVerify Data Directory for some sort of Batched
file
to import into Emerald. The file I found was batchout.bxo, so I copied
it to
a floppy and renamed it batchout.dat... which is what I have set in
Emerald
Administrator. Here is the format of the batchout file from ICVerify
(realizing there are two lines per transaction):
"C1","","5010","5424123456789012","0102","19.95","","","","","","","",""
,"",
"","","","","","",""
"11-23-1999","15:43:39","Y400003","A1995","","004978"
"C1","","5011","Jr.","7542","8.02","","","","","","","","","","","","","
",""
,"",""
"11-23-1999","15:43:39","NNINVALID ACCOUNT NUMBER","X","","004978"
I click "Batch In" and Emerald returns with "560 transactions
processed",
which is odd because there are 280... but 280x2=560 and there are 2
lines
per transaction, so I don't think anything of it. I click OK, and
Emerald
returns with "There were 280 Errors, 0 Duplicate and 0 Unknown
transactions
processed. Delete batch file anyways?" I click cancel because I do not
want
to lose my batch file.
I check the invoices and none are paid.
What do I need to do to resolve this?
Regards,
Gary Walworth Phone: (252) 261-0744 x 46
Network Administrator Fax: (252) 261-1365
Beachlink.com, Inc. Email: admin@beachlink.com
3915 Welch Street Web: http://www.beachlink.com
P.O. Box 1528
Kitty Hawk, NC 27949
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart