MBS FileMaker Plugin Example Databases

Repair Text Encoding Problems

All examples are included with download of MBS FileMaker Plugin.

Repair Text Encoding Problems.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts1
Value Lists0
Custom Functions0
Custom Menus33
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= Admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layoutOff
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
Repair Text Encoding Problems
2 fields defined, 1 record
Repair Text Encoding Problems

Fields

Table Name: Repair Text Encoding Problems - 2 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
BadTextNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      FixedTextNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German

          Layout Objects: Repair Text Encoding Problems

          Regular Fields

          Field Name: Repair Text Encoding Problems::BadText
          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
          • Top: 24 pt
          • Left: 138 pt
          • Bottom: 152 pt
          • Right: 391 pt
          • Anchoring: Left, Top
          Field Format:
          • Edit Box
          Field Behavior:
          • Allow field to be entered: In Find mode, In Browse mode
          • Touch keyboard type: System Default
          • Go to next field using: Tab key
          Yes

          Field Name: Repair Text Encoding Problems::FixedText
          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
          • Top: 156 pt
          • Left: 138 pt
          • Bottom: 248 pt
          • Right: 391 pt
          • Anchoring: Left, Top
          Field Format:
          • Edit Box
          Field Behavior:
          • Allow field to be entered: In Find mode, In Browse mode
          • Touch keyboard type: System Default
          • Go to next field using: Tab key
          Yes

          Group Buttons

          Button PropertiesCoordinatesScript/Script Step
            Type:
          • Text: Make UTF-8 read as Latin1
            Additional Properties:
          • Change to hand cursor over button
          • Rectangular
          • Top: 24 pt
          • Left: 408 pt
          • Bottom: 49 pt
          • Right: 643 pt
          • Anchoring: Left, Top
          Set Field [ Repair Text Encoding Problems::BadText; MBS("Text.DecodeFromHex"; MBS("Text.EncodeToHex"; "German for bye: Tschüß!"; "UTF-8"); "Latin1") ]

          Fields:


          Button PropertiesCoordinatesScript/Script Step
            Type:
          • Text: Make Windows-Ansi read as Mac Roman
            Additional Properties:
          • Change to hand cursor over button
          • Rectangular
          • Top: 54 pt
          • Left: 407 pt
          • Bottom: 79 pt
          • Right: 644 pt
          • Anchoring: Left, Top
          Set Field [ Repair Text Encoding Problems::BadText; MBS("Text.DecodeFromHex"; MBS("Text.EncodeToHex"; "German for bye: Tschüß!"; "Windows"); "Mac") ]

          Fields:


          Button PropertiesCoordinatesScript/Script Step
            Type:
          • Text: Make UTF-8 read as DOS
            Additional Properties:
          • Change to hand cursor over button
          • Rectangular
          • Top: 84 pt
          • Left: 408 pt
          • Bottom: 109 pt
          • Right: 643 pt
          • Anchoring: Left, Top
          Set Field [ Repair Text Encoding Problems::BadText; MBS("Text.DecodeFromHex"; MBS("Text.EncodeToHex"; "German for bye: Tschüß!"; "UTF-8"); "DOS") ]

          Fields:


          Button PropertiesCoordinatesScript/Script Step
            Type:
          • Text: Fix Latin1 as UTF-8
            Additional Properties:
          • Change to hand cursor over button
          • Rectangular
          • Top: 156 pt
          • Left: 408 pt
          • Bottom: 181 pt
          • Right: 643 pt
          • Anchoring: Left, Top
          Set Field [ Repair Text Encoding Problems::FixedText; MBS("Text.DecodeFromHex"; MBS("Text.EncodeToHex"; Repair Text Encoding Problems::BadText; "Latin1"); "UTF-8") ]

          Fields:


          Button PropertiesCoordinatesScript/Script Step
            Type:
          • Text: Fix MacRoman as Windows-Ansi
            Additional Properties:
          • Change to hand cursor over button
          • Rectangular
          • Top: 186 pt
          • Left: 408 pt
          • Bottom: 211 pt
          • Right: 643 pt
          • Anchoring: Left, Top
          Set Field [ Repair Text Encoding Problems::FixedText; MBS("Text.DecodeFromHex"; MBS("Text.EncodeToHex"; Repair Text Encoding Problems::BadText; "Mac"); "Windows") ]

          Fields:


          Button PropertiesCoordinatesScript/Script Step
            Type:
          • Text: Fix DOS as UTF-8
            Additional Properties:
          • Change to hand cursor over button
          • Rectangular
          • Top: 216 pt
          • Left: 408 pt
          • Bottom: 241 pt
          • Right: 643 pt
          • Anchoring: Left, Top
          Set Field [ Repair Text Encoding Problems::FixedText; MBS("Text.DecodeFromHex"; MBS("Text.EncodeToHex"; Repair Text Encoding Problems::BadText; "DOS"); "UTF-8") ]

          Fields:


          Script Hierarchy

          Clear

          Script NameClear
          Run script with full access privilegesOff
          Include In MenuYes
          Layouts that use this script
            Scripts that use this script
              Script Definition
              Script Steps
              • Set Field [ Repair Text Encoding Problems::BadText; "" ]
              • Set Field [ Repair Text Encoding Problems::FixedText; "" ]
              Fields used in this script
              Scripts used in this script
                Layouts used in this script
                  Tables used in this script
                  Table occurrences used by this script
                  Custom Functions used by this script
                    Custom menu set used by this script

                      Download example: Repair Text Encoding Problems

                      Used functions:




                      Links
                      MBS Xojo Plugins