Updating the HHES CSV-to-HTM File Converter19 Dec 2014
This post is for people using the HHES CSV-to-HTM file converter. After some initial testing, we’ve found that the CSV files supplied by the payment processor have a different structure to what was originally supplied as a sample. I’ve made some changes to the program, and it will now process the newer file structure.
Firstly, I’m not sure how to deal with failed transactions. The samples files that were supplied to me previously included some failed transations, but did not include the amount of the failed transaction, which was required for the other file. The workaround that I put in place was to write a list of the failed transactions with, the detailed that were available, to a second file, that could be read by a person, and entered manually.
The sample of the newer file structure that I was given does not include any failed transactions, so I’m not sure how to deal with them yet. As a consequence, failed transactions in files with the newer structure won’t be processed.
Secondly, I have not yet had any confirmation that the output HTM files are actually correct.
The new version can be downloaded from here.