Need full credit card numbers Aloha v6.4

[alohaakamai3]

I had a store that lost internet in a storm stop EDC so that the cards would spool, and then restart EDC to "test" if the Internet was back up.

Well, it wasn't, and Aloha techs no the fun that takes place when this happens. The spooled files dumped to the BOH as "failed to intialize" txns and the transactions did not authorize.

At this point, I had two options.

1- I was actually once able to cut and paste parts of a saved spooled file into a .txn, rename it to .spl and get it to authorize. But it was a while ago and is not working for me this time around (I could probably still get this to work, but am running out of patience).

2- The tried and true method... get the full cc # and expiration date from the Audit and manually enter the cards via the EDC back office.

Here's my problem though.. I know how to get the full number to show up, I'm not asking anyone to post that sensitive information here. But what's weird is that it's only working on TODAY in reports... previous days are showing a lot of the information XXXXX out.

The day in question I need the info from was a few days ago, so I even added hack to get the full #s, reground, and it's still not showing.

The only weird thing is the line was set as =2, I thought it was supposed to be =1 to get the full information.

Anyone have any suggestions of how to get the full # or away to get these txs through?

 

[BIGGBYNinja]

You should be able to view the full card numbers in the audit report for that day from Aloha Manager. Set the date and noncash payments and it should show you every CC transaction with full #s and expiration dates.

At least that's how ours works. We don't use deltrack.

 

[alohaakamai3]

Thanks Biggby, thats how I thought it was supposed to work to, but it's only working for dates AFTER the line of code telling to show full numbers was inserted. Even if I go back and insert and regrind a previous day, it still doesn't show. It really has me stumped and really we need to get these darn charges through.

 

[RokStar]

An audit report reads straight from the trans.log.
hacking and grinding shouldn't change anything.

What version are you running?

ALSO, everyone please sign on (or ask your reseller) to RFC# 85872 - Utility to securely extract data from trans.log for credit card numbers, expiration date and amount.

We used to have a utility for this exact reason, but it was underground and it stopped working with 6.4(.19 I think)

 

[alohaakamai3]

An audit report reads straight from the trans.log.
hacking and grinding shouldn't change anything.

Well, it was from a previous day of business, so I figured I would at least have to add the line in aloha.ini that allowed the full cc numbers to be shown.

Rokstar, do you know the file name for this utility? I'm wondering if it's tucked away somewhere.

 

[coorsman]

Usually you would rename it to .req not .spl. If that dosen't work I have a way around that.


Cheers,
Coorsman

 

[alohaakamai3]

So you're saying if I rename the txn00001 to a .req in the edc folder, stop and a start the service, it should go through?

 

[RokStar]

1) I have the utility, but I don't know what version you're running.
2) Even in dated subs, the audit report applet reads directly from the translog
3) I didn't realize you had the spool files, I've had mixed success with that, but that's the easiest way by far and it should work. As soon as EDCSVR sees a req file, it attempts to authorize.

[The utility is for when the spool files are gone.]

 

[coorsman]

Sonetimes, and depending on the aloha version.

Your spool files "*.spl" are stored on the master terminal when edc processing is stopped. If the edcsvr.exe is logged in with the sale account on the server as then terminal, these files are automatically transferred to the server as request files "*.req" and processed then named txn files for settling. If not then they have to be copied manually to the EDC folder and renamed usually in dos "ren *.spl *.req" they should start processing.

Do you still have a copy of the spl files? just rename them to req and you should have txn's processing.

If that dosen't work,
1. how many do you have and
2. how much money are we talking about thats missing txn's.


Cheers,
Coorsman

 

[RokStar]

Somehow I read that as "how much money do you have?"

Maybe it has something to do with the original Coors tallboy that I'm drinking. In your honor, of course Coorsman!

 

[coorsman]

Well no sorry, trying to do 2 things at once well 3 if you count the beer, 4 5 &6 crying kids. lol .

Anyway, There is another way if that dosen't work. If you have 10 or 20 txn's it's not so hard to edit each one. If you have 100's of txn's - I have written a utility that can read all the txn's and dump them into an excel spread sheet for detailed sorting and diagnosis. And then like last night I had a customer worried about a $15.00 transaction, not really worth the time in my opinion.


Cheers,
Coorsman

 

[alohaakamai3]

I didn't realize you had the spool files, I've had mixed success with that, but that's the easiest way by far and it should work. As soon as EDCSVR sees a req file, it attempts to authorize.

For the record, I don't have the spool files. You're correct, if I'd had these, I'd be golden. The only time I'd ever had a problem with spooled files (which I always back up before I do anything with spooled cards) is when they wouldn't authorize by themselves when EDC was restarted- in which case I'd do something very similar to what you guys have suggested. I'd rename *.spl files to *.hld, put them into the EDC folder, stop/restart processing, and they'd authorize. Just a little different way of doing the same job.

What happened at this particular location is that the manager knew enough to turn off EDC to get the cards to spool when the Internet was done.. but his brilliant solution for checking to see if the Internet was up again- without checking with us first- was to turn EDC back on.

Well, the Internet was not up... and when this is the case, Aloha basically pukes on the whole thing and dumps the spool files as unauthorized TXNS to the back office.

At this point, I would generally tell the store how to retrieve the full numbers in the audit report, show them how to manually enter them into EDC, and then set the phone down while they pissed and moaned about how long it was going to take.

Only this time, the numbers are only showing for days AFTER I added the edit that I'm intentionally not mentioning here, that allows you to get all the credit info.

The last and final option... I once was able to do something like you are saying, Coorsman... I made a TXN file look like enough of an SPL file by editing it with notepad, and got it go through.
Yes, it was a pain, but it was better than nothing. Either I'm not doing it how I remembered doing it or it's not working with this version, because I'm not having any success. I'm not sure I wanted to keep messing around on this front.

In total, I'd say it's maybe 20-30 transactions.

And I know what you mean, Coorsman, we're approaching that "golden hour" on two aspects... you can only invest so many hours in something before it just looks bad... and the second aspect is, the transactions are probably approaching 8 or 9 days old. You can only run them through so many days later before customers start placing angry phone calls about how they didn't eat there on that day.

I used to get those calls routinely when I worked for a dealer... at 1am, explaining to me that a server accidentally deleted a payment for $25 and the customer is now gone. Uhm, you realize the dealer is going to charge you $150 for the phone call, right? LOL.

Let me know if you guys can think of anything else that might work.

I think the version is 6.4?

Can you guys tell me the name of the utility or link it, to at least see if the store has it?

Any suggestions

 

[coorsman]

The utility I wrote I haven't released yet, still needs a little work b/c they keep changing the file layouts, I'm re-writing it to span all versions of EDC. It is a script that strips out the following lines from the TXN.

TRACK1
TRACK2
STANDALONE
RESEND
LASTSEND
ORIGDATE
ORIGTIME
CRCY

This procedure will usually allow you to process them as a txn file, you really don't have to authorize them just get them into edc then settle them. I've used an earlier version of edc, drop the ini and txt files and settle them. Unfortuantly the adjust files won't go thru this way.

I also like to use a text file search and replace program after renaming them to txt files - this one is great - MultifindPro from

http://www.midlinesoft.com/

you can search and replace multiple txt files in a directory.

I'ts really frustrating, Aloha EDC problems, I had a power outage on friday at a a bar that had >100 using saved named tabs/cards - they came in Sat and all had been settled to cash and nothing in audits for cc #'s. My theroy, I deleted the EOD and closed check's in the trans.log file this morning and basically restarted the trans.log - all tabs appeared and was able to close each one out then do an EOD. A very happy customer.

Gluck


Cheers,
Coorsman