MDBTools - Currency field blank in CSV

posted by sacah on software, fixes,

We use MDBTools to convert an Access DB to CSVs to import into MySQL. Moving a site to another server we tried installing MDBTools via YUM, but continued getting Segment Faults each time we ran mdb-export.
So we downloaded the source and recompiled, everything seemed to work, except the currency column was blank in the CSV. All other types worked, just currency appeared to have a problem.

I did a ldd on mdb-export on the old server that worked and compared to ldd on the new server, and noticed some differences, so I decided to try the RPM avaliable for download at the mdbtools SF page.

On a rpm -i it complained that 'libreadline.so.4 is needed by mdbtools-0.5-1.i386'
I did a yum list readline* and found
readline.i386                            5.1-1.1                installed
Available Packages
compat-readline43.i386                   4.3-3                  base

So I rpm -e mdbtools, yum install compat-readline43.i386, and rpm -i mdbtools from SF.

Now mdb-export correctly exports the currency fields to CSV.