0 Replies Latest reply on Mar 17, 2011 11:33 AM by JPetersen

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

    JPetersen

      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