FmPro Script Diff 1.38

FmPro Script Diff 1.38 offers an efefctive tool which helps you to compare, edit, search and store FileMaker ScriptMaker scripts - outside the FileMaker database. Changed scripts are compared on a line-by-line basis and displayed with color coded tags to the left of each modified line. Interline changes are also highlighted to indicate Changed, Added or Deleted text. Each script?s XML source can be manually edited or updated via the Search & Replace feature, and pasted back into FileMaker Pro/Advanced.

Transferring scripts between FileMaker Pro and FmPro Script Diff is done by copying & pasting the scripts via the clipboard. No DDR Export is required. The XML code representing each script is parsed, converted to human-readable text and checked for errors. Selected scripts can then be copied back onto the clipboard as XML for pasting back into FileMaker or as RTF formatted text for project documentation. Each attribute of the script definition is copied onto the clipboard, including Script Name, Script ID, and Include in Menu status.

Use the graphical control flow feature to instantly see the structure of your code (or someone elses) at a glance.
The display of script control flow graphically shows the statements included within each IF/ELSE/END IF/LOOP/END LOOP control flow structure. It is no longer ncecessary to print and mark up scripts with a ruler in order to see the control flow.

FmPro Script Diff improves productivity by helping FileMaker developers
answer questions such as:

1. What changes have been made to this ScriptMaker script?
2. Which scripts have been changed between two database revisions?
3. Where is this global variable modified within each script of my solution?
4. Is this field used by any script in my solution (before I delete, modify
5. or reuse it)?
6. How can I find and change a text string, variable, fieldname or table
7. occurrence within dozens or even hundreds of scripts?
8. How can I meet regulatory compliance and certification IT auditing requirements such as: Sarbanes-Oxley [aka: Sox, Sarbox], FDA 21 CFR Part 11, and ISO 9000?
   

Major Features:

1. Regulatory Compliance and Certifications :
   • Maintain a verifiable audit trail for modifications made to IT systems.
   • Enable companies to quickly document ScriptMaker changes between any two versions of a FileMaker database solution.
   • Have  the TAB key within the Diff screen enables an auditor to instantly advance thru each of the changed scrpt lines, potentially saving hours of work looking for these changes manually.
2. Colorized Line by Line Diff Results :
   • Have scripts that are analyzed on a line-by-line basis.
   • Have changes highlighted in color to make it easy to see whether individual lines have been Added, Deleted or Changed.
   • Have changed text within each line also highlighted.
3. High Performance Diff Feature :
   • Have a checksum calculated for the text of each script as it is transferred from the clipboard into FmPro Script Diff.
   • Compare the checksums between scripts having the same name.
   • Improve the performance of the Diff process because typically only a few scripts within an entire database will be modified between revisions.
   • Have the line-by-line comparison functionality processe the output results from the UNIX diff utility, which only requires about 200mSec to complete for a typical script.
4. Easily Find Changed Scripts :
   • Display only the modified scripts within a large group of scripts by using the Diff screen menu item Changed Scripts.
   • Be a significant time saver to filter the Diff results to display only the Changed, New, Deleted or Unchanged scripts.
5. Search & Replace Text Within Scripts:
   • Find and replace a piece of text like a customer name or product name within dozens or even hundreds of scripts.
   • Perform these types of search and replace tasks within a few seconds.
   • Perform on variable names, Tablename::Fieldnames, Table Occurrences and text strings throughout an entire group of scripts.
   • Have updated scripts  pasted directly into FileMaker.
   • Have all script attributes including Script Name, Script ID and Include in Menu status are retained when transferring scripts via the clipboard.
6. TAB to Highlighted Text :
   • Have the search text highlighted in yellow in the Script Text display field. Pressing the TAB key automatically advances to the next occurrence of the found text within the field. Show script errors highlighted in red.
   • Scroll and highlight the first changed line of text, and pressing the TAB key advances to the next changed lie.
7. Quickly Browse Scripts:
   • Be displayed in a format which is similar to the FileMaker script printout format.
   • Have script step names and comments displayed in bold, options are plaintext, and Tablename::Fieldnames are underlined.
   • Have disabled instructions displayed in italic text.
   • Have complex script steps with many options are displayed in a multi-line format, without requiring the opening of modal dialog boxes within ScriptMaker.
   • Have Import and Export field lists are especially easy to read as a list of fields with Match/Import/Export parameters.
8. Share Scripts Among Developers:
   • Be exported and transferred between developers working on a project.
   • Be archived for historical purposes or imported by other developers into their own copy of FmPro Script Diff.
9. Script Error Check Feature:
   • Be copied from the clipboard it is converted from XML into human-readable text and checked for errors.
10. Edit XML Definition for Scripts:
    • Allow developers to browse and modify the XML definition for any ScriptMaker script.  Have every parameter of a script (including Script ID, Script Name etc) or individual script step be modified by editing the script XML definition.
    • Be generated by external tools and pasted into the Script XML field, for pasting back into FileMaker.
11. Script Grouping Feature:
    • Be pasted into three different screens within FmPro Diff.
    • Enable developers to make comparisons between scripts, have scratchpad work areas and a centralized storage area for commonly used scripts.
    • & Replace tasks. Search & Replace tasks only affect the scripts located within the screen where they are performed.
12. Script Repository Feature:
    • Be considered a longer term storage location where commonly used scripts may be stored in one convenient location.
    • Be copied between each screen by using the same copy and paste mechanism used to transfer scripts between FmPro Script Diff and FileMaker.
13. Persistent and Robust Storage:
    • Utilize a high performance SQLite3 embedded database for storage of all imported scripts and preferences within the application. 
    •  Let Diff results also stored in order to provide persistent storage of these results, and to allow filtering of the Diff results list.
14. Easily Print Diff Results and Scripts:
    • Have Colorized Diff results, Script Text and Script Error text  be printed in color or saved as a PDF file on both platforms.
    • Copy Whole Scripts or Script Steps to Clipboard: Enable the pasting of script steps into an existing ScriptMaker script.
    • Paste Whole Scripts or Script Steps into FmPro Script Diff: Recognize the difference between whole scripts or individual script steps located on the clipboard.
      
15. Available for Mac OS X and Windows: 

Enhancements:

1.  Recompiled for MacOSX, to resolve clipboard data transfer issue.
2. Added support for FileMaker Pro 9 and FileMaker Pro 9 Advanced. 
3. Made cosmetic fixes to labels showing number of scripts and script steps.

Requirements: Windows NT/2000/NT/Vista, MacOSX