AnsweredAssumed Answered

Pasting UTF code into calc field freezes/crashes Filemaker Pro upon exit

Question asked by JPetersen on Mar 17, 2011

Summary

Pasting UTF code into calc field freezes/crashes Filemaker Pro upon exit

Product

FileMaker Pro

Version

Filemaker Pro Advanced 10.0v3

Operating system version

OS X 10.5.8 - Dual 2-GHZ G5 Tower, 3GB RAM

Description of the issue

UTF text pasted from an external source (e.g., TextEdit) will freeze/crash a Filemaker field calculation upon exiting the calculation window.

The cursor spins indefinitely and the process has to be killed.

Steps to reproduce the problem

METHOD 1:
1. Create FIELD1 that includes UTF source code from a Filemaker WebViewer container.
2. Create a FIELD2 calculation field that processes the FIELD1 source code text (for example, adding spaces or line feeds), leaving the original FIELD1 text intact.
3. Highlight and copy the text to be processed from the Filemaker FIELD1 window in layout mode into the Filemaker FIELD2 calculation window.
4. Exit the calculation window and the field manager to save the new calc.

This works and the processed text (with substitutions such as paragraph markers) displays correctly in Field2.


METHOD 2:
1. Create FIELD1 that includes UTF source code from a Filemaker WebViewer container.
2. Create a FIELD2 calculation field that processes the FIELD1 source code text (for example, adding spaces or line feeds), leaving the original FIELD1 text intact.
3. Highlight and copy the text to be processed from an external application that can handle UTF files (e.g., TextEdit) and paste into the Filemaker FIELD2 calculation window.
4. Exit the calculation window...

At this point Filemaker consistently freezes on my system without exiting the calculation window. The cursor spins indefinitely. The process has to be killed from Finder.

There are many instances in which data from externals sources has to be copied and pasted into calculation fields and it's not always practical to get the data from a Filemaker field, so it's important that Filemaker be able to exit (ideally with an error message) if it thinks it has a malformed UTF-format calc.

Expected result

Filemaker will save the calculation using pasted UTF-format text from an external source just as it can save the visually-identical string from internal Filemaker fields or at least display an error message and not freeze.

Actual result

Filemaker freezes upon trying to exit the field calculation window and cursor spins indefinitely. Process must be killed from Finder and Filemaker relaunched.

Exact text of any error message(s) that appear

No error messages.

Application freezes with spinning cursor, Filemaker must be killed manually and relaunched.

Configuration information

Since these are UTF-coded files, you can't type the search string in the calculation field--the substitute function won't recognize it as the same text. It must be copied and pasted to preserve the UTF bite-encoding within the string. it works when copying and pasting from within Filemaker from a layout mode field window to the calculation window.

The UTF file in TextEdit came directly from a Filemaker Export File script and in other respects appears to retain the Filemaker file attributes. For example, processing the file with Perl in UTF mode yields expected results, so it doesn't appear that the Filemaker-exported file becomes malformed when opened in TextEdit.

Workaround

None found so far other than to always grab the text from a native Filemaker field, but there are many instances where text must be copied and pasted from external sources since the data to be manipulated in a calc field might be in external files (e.g., text files or URL source files).

FMCalcUTFBugPic.jpg

Outcomes