Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

FM 10 chops numbers when importing from FMSA 10 via ODBC

WestCoaster
in External Data Sources

Featured Replies

Hi all,

I have just discovered that FileMaker 10 running on a Mac chops number values when importing records from a FileMaker Server Adv. 10 via ODBC. Text values are working fine. I can't determine what the pattern is that FM 10 chops the numbers. If the table that is hosted on FMSA 10 has a number field that contains "1717" or "1616" only "11" arrives in FMA 10.

What I have tried to track down the problem is:

- I tested this using FMA 9 on a Mac importing from the very same FMSA 10 via ODBC - the number values show up correct.

- I tested this using FMA 10 on Windows importing from the same FMSA 10 - the number values show up correct again.

- I tested this using Excel on the very Mac on which the number values are chopped in FMA 10 - Excel shows the correct number values when importing from the FMSA 10 server in question.

- I tested this using the DSN as a system DSN and a user DSN - still same error in FMA 10.

So this looks to me that this may not be an issue with the ODBC driver (I use the Sequel Link driver that comes with FMSA 10) but rather is a bug in FileMaker (Adv) 10 client.

Has anyone seen this before? This seems to be a serious issue since values are altered during importing records via ODBC. Is there an update available for the Sequel Link driver?

Just if anybody is wondering why I would import records into an FM client from an FM Server rather than just open up the database from the server: This started as a test setup. I was trying to import records from FMSA 10 into Enfocus Switch (a DTP workflow software) which didn't yield the results I anticipated. So I just wanted to verify the DSN and SQL statement are ok and I tried this simply using FMA 10 as an ODBC client to FMSA 10.

Regards,

Thomas

  • Author

Just a little follow up on this: I just tested importing different number type fields from a mySQL server into FileMaker Adv. 10 using ODBC and the values arrived ok in FileMaker. Still I think that the error in importing the numbers from a FileMaker Server 10 is a serious issue that should be addressed by FileMaker.

Regards,

Thomas

Create an account or sign in to comment

https://fmforums.com/topic/66618-fm-10-chops-numbers-when-importing-from-fmsa-10-via-odbc/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.