Aloha EDC: Can I Convert the AMEX STL file back to TXN files?

[JJP2]

Amex never got my batch but Aloha EDC thought it did. (I batch out over the internet to FTPHost fsgateway.aex). Aloha EDC then deleted my TXN files for the individual swipes and left a STL file in my EDC/AMEX folder. I notice that the STL file is really just a file made up of all the TXN files that were batched out in the settlement. Since the batch/settlement was not received by AMEX and I no longer have the individual TXN files to resubmit could I recreate the individual TXN files from the STL file? This would mean that I could resubmit without having to re-key all of the AMEX charges for the day from the audit report--a colossal pain.

Also the confirmation files "sub004.105719. a and c" from AMEX do not arrive in my EDC/AMEX folder till the next batch I submit (usually on the next day) though AMEX says they were created and sent within the hour of my batch out. Is there some way to get these two Acceptance and Confirmation files in a more timely fashion?


Any insight/help would be appreciated.

 

[dauphin2]

Yes, there is a utility to do this called splitstl. I think it is run like this "splitstl 20130808.STL"

SPLITSTL.EXE

 

[coorsman]

What version of Aloha are you on?



Cheers,
Coorsman

 

[JJP2]

Thank you dauphin2 It worked like a charm.

It created all the TXN files from the STL. I'm not sure how to test it out in real time though. Since the STL file doesn't exist until I've sent in my batch I'll screw things up if I resubmit a batch that was already sent and received by AMEX. I guess I have to wait for the next batch to disappear into cyberspace which I hope will never happen again.

 

[JJP2]

I'm on version EDC and Aloha Mgr 6.4.30.

 

[coorsman]

I would print out the credit card batch report with the full numbers on them then hand key them in. (you may not have security level to do this but your dealer can print it for you)



Cheers,
Coorsman

 

[JJP2]

Coorsman, I gather that you are talking about the batch report in EDC and not the report in Audit. My print out truncates the credit card numbers in the EDC batch report. I was not aware that my dealer could print out that report un-truncated nor did my dealer suggest it. Instead I patched something together from the audit report which ended up not being a very easy format for data entry. I pay by the call for my tech support so I don't think it's worth it for a cleaner format. Besides now I have this splitstL.exe program which seems/might to work fine.

 

[coorsman]

You may be able to print it out yourself. The setting to mask Edc is in (maintenance system store settings - somewhere in there) if your sec level is high you can turn it off and print the whole number.

Cheers,
Coorsman

 

[JJP2]

I see a place to remove the truncation from the guest check but not from the EDC report. When we close I'll test it out and see if it maybe also applies to the Back of House EDC amex report.

 

[JJP2]

By the way Amex will send the "sub004.105719. B" report immediately when it comes out through email. They set it up for me and I receive my first one today 25 minutes after I settled the batch. The acceptance report at least tells me they received my batch though it doesn't contain the number of debits and the total amount which comes in the "sub004.1a5719. C" report.