Importing Money Field from Postgres Yields ? Question Mark [solution included]

January 11, 201114 yr

Hi, everyone.

I was just about to post the question below and happened upon a solution just before clicking go. Though perhaps not traditional, I thought I'd post the question and resolution in case it's helpful to someone else searching in future.

The quick summary is that an importing problem in FM 11 was solved by updating my ODBC driver.

Here are the details:

Just switching an old file from 8.5 to 11 today and hitting a small roadblock.

The file includes a script with an import step pulling data from Postgres (not using ESS as it's not yet implemented for Postgres). Some of the fields being imported are "money" (AKA currency) field types on Postgres, importing into number fields in Filemaker. In v. 8.5 the import works successfully.

In v. 11, however, "money" fields that include a $ dollar sign are importing with a ? question mark value. While we prefer to keep these as number fields on Filemaker we tried changing the field type to text and got the same result. We also tried setting the field definition to auto-enter a calculated value of getasnumber(item_price) and even Substitute( item_price ; "$" ; "") (and for those tests we did uncheck the "Do not replace existing value" box).

Any ideas or existing threads that might address this please? Feeling like I'm missing something obvious here.

Thanks for your help.

SOLUTION:

Just as I was about to post I realized I should include the ODBC driver type and version I was using (which was ActualTech ODBC Driver for Open Source Databases v. 2.9x). Thinking that might be a bit out of date I updated it to version 3.0.14 and the data seems to import correctly now. It seems the driver's translation may have been updated as Postgres data types were updated.

Hope this is helpful to someone.