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.

Importing with "Update matching record in found set" changes the point to comma

Featured Replies

  • Newbies

I am importing data from Tab separated text file to one of the tables in FM file hosted on FM13 server. One of the fields in the table is "Price", defined as the number field.
When I import Tab text file with "Add new records" option checked out, the "Price" fields are populated with the correct price in form xy.z (example 23.4).
When I use the same Tab text file and set "Update matching record in found set", "Add remaining data as new records" and import the file, the "Price" field values change the values to xy,z (so 23.4 becomes 23,4 and so on). The system settings on FileMaker Pro side and Server Side are identical and set to use point as decimal symbol and comma as grouping symbol.

I tried every possible encoding option, but the result is always the same - the point is changed to comma.

Any ideas why this is happening? I searched the support forums but was not able to find and similar issue.


I tried to import Tab text file to Excel, and save it as Excel file, then repeat the same import with Excel file (first import with Add new records, then in second run set "Update matching record in found set", "Add remaining data as new records") - no issues exist. The "Price" field keeps the form xy.z

 

Thanks

Create an account or sign in to comment

Important Information

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

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.