[Emerald] ICVerify Batching in Emerald 2.5.278

Beachlink Administrator ( (no email) )
Wed, 24 Nov 1999 10:47:23 -0500

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