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.

Troi File Plug in - character conversion

Featured Replies

We use Troi File Plug-in with our FileMaker 6.0 Pro database to import text files into the FileMaker database field. Our text files could be larger than 64K, and the plugin imports text file in 64K chunks.

We find it very useful, and it worked OK until recently. We have a new

collection of files that contain accented characters, in ANSI format - French characters, as well as Registered Trademark sign, degree, etc..

All text files are located on our Sun computer, and the FileMaker Server 5.5 is

on the Mac OS X.

Troi File Plug-in imports the data as MAC characters, i.e. it thinks that the original file is Mac, and converts it to ANSI. When the text is viewed in FileMaker, it's completely wrong. I can, probably, use Substitute to convert characters back to ANSI, but this is a production database, and we process up to 50,000 records a month. Substitution will significantly slow the process. I can convert all text files to Mac format before importing, but it is undesirable, because data entry staff have to review text files before importing.

Is there any way that I can set Troi File Plug-in to import data as ANSI? What if the server is Win 2000? Would it make a difference?

This is really crucial - this is production application, and we do not have any other tool that can import data from text files into FileMaker.

Thank you

Leah

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.