Version 4.1 (11/3/2022) * Added support for MacOS Ventura Version 4.0728 (1/21/2022) * Added `forceTrimTrailingNullRows` as a configurable argument (set to true/false) to force scribe to ignore null rows at the end of an Excel worksheet when performing the MaxRows() calculation. * Updated documentation to reflect this change. Version 4.0727 (1/10/2022) * Updated the document to show that ScribeDocSubstitute does not support containers by reference. Version 4.0726 (7/20/2021) * Fixed an issue where OCR documents would report RESULTS_NOT_READY when they were in fact complete Version 4.0722 (6/25/2021) * Added support for Apple M1 Architecture Version 4.0716 (12/11/2020) * Fixed an issue with the OCR demo files Version 4.0714 (12/11/2020) * Fixed an issue with sending plugin problem reports Version 4.0713 (11/2/2020) * Fixed an issue where plugins were failing to load on FileMaker Server 19.1 and later Version 4.0710 (5/28/2020) * Fixed an issue where keywords were not properly pulled from some pdfs * Expanded documents are now deleted from the temp directory after processing on Windows * Fixed issue when converting excel files to text with merged cells. Version 4.03 (2/18/2020) * Fixed an issue causing a delay when pulling down Textract results. Results should be pulled down as soon as they are finished. Version 4.02 (2/3/2020) * Fixed an issue where spaces in an image name could cause a corrupt excel document. Version 4.01 (1/20/2020) * Fixed an issue where reading from Excel sheets that had parenthesis in the name threw an error. * Added Textract Demo file to download. Version 4 (1/15/2020) * Added OCR Functionality, integrating with Amazon Textract to extract text from documents. * Added ScribePDFMerge, allowing two pdfs to be merged together * Added ScribePDFSplice, allowing a multi-page pdf to be split up into smaller pdfs * Added ScribeGetPDFAttributes, returning various mata-data about a pdf, including page count * Fixed an issue where reading an empty Excel cell would cause an error * Fixed an issue when using ScribeDocSubstitute where replacing a value with itself would cause an error * Fixed an issue where reading numbers from Excel documents would sometimes return a date instead * Fixed an issue where writing a image to Excel that already had an image would cause Excel to report issues with the workbook Version 3.2 (11/20/2019) * Fixed issues with the registration dialog where registration would not persist * Plugins are now notarized to comply with MacOS Catalina changes * Improved logging, preventing hangups on background logging threads * Better handling of child processes on Windows Version 3.1 (5/14/2019) * Plugin startup and shutdown procedures have been greatly improved. * Fixed issues that caused PSOS calls to return "Host capacity exceeded" * Fixed issues that prevented plugins from autoupdating using the Install Plugin script step * Fixed an issue where multiple server side scripts would cause plugin functions to time out * Fixed issues related to multi user environments (Server side scripts, WebDirect, Custom Web Publishing) * Fixed issues where child processes would not be terminated on shutdown * Reworked GUI framework, so that plugin windows will stay in lock-step with FileMaker windows * Adding images to PDF has better transparent image support Version 3.09 (6/14/2018) * Fixed a problem that caused some plug-ins installed in FMS 17 on Windows to not initialize Version 3.08 (1/21/2018) * Fixed a problem where plug-ins that had just been installed on Windows would not initialize if Internet Security options were set to 'high' Version 3.07 (1/12/2018) * Various improvements to plug-in GUI functions for progress bars and dialogs * Significant improvements to plug-in stability when running in FileMaker Server, on Mac, Windows, and FileMaker Cloud Version 3.06 (12/6/2017) * Now compatible with MacOS High Sierra * License checking code has been improved - fixed several issues related to license checking * Graphical User Interface (GUI) improvements made to progress bars, file choosers, and configuration dialog windows * Better reliability when loading and initializing plug-ins Version 3.05 (6/6/2017) * Fixed cases where server-side scripts could cause the FileMaker Scripting Engine to hang * Fixed some issues with FileMaker Cloud when enabling and disabling plug-ins repeatedly * Fixed some problems on Mac displaying configuration dialog * Fixed an issue for maintenance customers getting an incorrect message that their license was expired * Restored compatibility for 32-bit Windows OS Version 3.04 (5/27/2017) * Many bug fixes, especially for GUI operations, server-side operations, and running multiple plug-ins Version 3.02 (5/12/2017) * Fixed an issue that prevented plug-ins from loading in Windows Server 2012r2 Version 3.01 (5/10/2017) *No longer requires Java installation *Can use plugin functions as script steps with a user-friendly GUI for specifying parameters *Better error reporting in scripts *Compatible with FileMaker Cloud *Better compatibility with FileMaker Server for Perform Script on Server and scheduled scripts *Each plugin runs in a separate process, increasing reliability and stability *Plugins can be reliably unloaded, making it possible to auto-update without restarting FileMaker *Where appropriate, plugin parameters can be selected from pull-down lists and checkboxes *Support for streaming large container data, allowing unlimited amounts of data to be transferred between FileMaker and the plugin without running out of memory. *Compatible with the older plugin API, so you can continue to use your existing scripts and calculations with the new plugins. Version 2.23 *fixed a bug where writing images to Excel caused them to be shifted one column to the right Version 2.2 (5/5/2016) Excel * Specify image width/height when writing images to Excel, e.g. ScribeDocWriteValue("C18" ; my::container ; "width=800" ; "height=300" ) Word * Better support for writing HTML using ScribeDocWriteValue. Version 2.182 (4/7/2016) Word * Appending one .docx to another also copies over named styles which don't already exist in the destination file, and preserves numbered list styles / numbers * Appending text to paragraph-level content control fields supports paragraph creation: pass two consecutive line breaks to create a new paragraph * Appending text supports "newPage=true" optional argument, which includes a page break * Support for .docm macro files * Recovers from docx parsing with missing files Excel * Fixes issue where previously exported excel file could not be deleted, preventing a new one from being exported * Fixes loss of non-US number locale formats when reading from .xls Version 2.16 * Fix for appending images with uppercase extensions Version 2.15 (11/16/2015) * Excel supports word wrap when writing values, e.g. ScribeDocWriteValue("A1" ; "Hello¶there" ; "wrap=true") * Better newline support across all document types * Query number of pages in a PDF using ScribeDocReadValue("PDFPageCount") * Improved image retrieval in Word documents, supports more image types * Fixed bug: changing an Excel cell type from text to numeric, vice versa * Fixed bug: image replacement was not showing up on some Word files * Fixed bug: ScribeDocAppend correctly renames / copies images in appended documents Version 2.11 (9/19/2015) * fixed issue with ScribeRegister Version 2.1 (7/22/2015) * Read and write formulas in Excel sheets * ScribeDocAppend supports appending one .docx to another, or an HTML/plainText string to a .docx * PDF read and write file attachments, XMP Metadata * PDF Get image count, extract images * ==BUG FIXES and IMPROVEMENTS== * .docx files include hyperlinked text in ScribeDocGetAsText Version 2.0 (7/19/2015) * ==NEW FEATURES== * Add images to Excel documents, PDF documents, Word documents, PowerPoint documents * Append word documents to each other using ScribeDocAppend * Read and write specific table cells in Word documents (new cells are created as needed when writing) * Read cell comments, background colors from Excel documents * Query worksheet bounds for Excel documents, * Read entire comments of Excel worksheet as delimited text * PDF support for creating new pages, inserting pictures * Create password-protected PDFs * Read PowerPoint (.pptx) files * ==BUG FIXES and IMPROVEMENTS== * Excel fix for oddly named/numbered sheets, or sheets which contain charts. * Replace text in Word Documents is smarter about matching text to replace Version 1.44 (5/12/2015) * FileMaker 14 compatibility release * Updates to usage with PSOS and server scheduled scripts * Updates to install plugin and auto-update * Excel fix for oddly numbered sheets, or sheets which contain charts. Version 1.43 (12/15/2014) * Full support for Perform Script on Server (PSOS), FileMaker Server 13 feature * 64-bit support for all plugin deployments * Support for Windows Server 2012 * Various fixes and improvements Version 1.41 * Improved index reading for unicode characters * Fixed trailing characters/words in index file * Added support for checkboxes in PDF files Version 1.402 (7/30/2013) * Fix for ScribeDocLoad when using a URL * Fix for ScribeDocSubstitute with carriage returns in Word documents Version 1.401 (7/18/2013) * Fix line breaks not being read in some types of word document fields * Fix for writing multi-value CCF fields in word documents. Version 1.4 (6/21/2013) * 64-bit plugin now included for use with Custom Web Publishing in FMS 12 * New error reporting features in plugin * Compatible with Java 7 update 25 * Fixed support for cells in Excel formatted as 'percentage' using ScribeDocReadValue Version 1.3 (6/18/2012) * Added support for inserting carriage returns into Word documents * Added support in ScribeFileAsText function for Pages and Keynote ('08, '09) Version 1.271 (4/6/2012) * Corrected issue introduced in version 1.27; an incorrect release date prevented some of the portfolio licenses from registering Scribe 1 Version 1.27 (4/4/2012) * FileMaker Pro and Server 12 compatibility release. * If replaceText is null when calling ScribeDocSubstitute, use an empty string instead of generating an error (searchText is still required) * Fixed ability to replace a placeholder with an empty string using ScribeDocReplace * Fixed text boxes being kept in tact * Fixed ability to pull symbols in using ScribeFileAsText with .docx files * Fixed a bug with incompatible characters in filename * ScribeDocReplace now replaces "simple field" types in Word Documents (these are merge fields created by some versions of Word) * Now extracts the name of attached files out Outlook .msg files * Fixed problem extracting from filenames with Japanese characters Version 1.262 (1/12/2012) * Fixed corrupt files being produced on Windows after multiple documents use ScribeDocSubstitute Version 1.26 (12/8/2011) * Fixed loss of formatting with .xlsx files with ScribeDocWriteValue * Fixed loss of formatting with .docs files with ScribeDocSubstitute * Fixed loss of formatting with .docx files with Content Control Fields and ScribeDocWriteValue * Fixed "flatten" flag to work on ScribeDocSaveContainer * Added ability to retrieve PDF metadata: author, creation date, mod date, creator, producer, subject. Functionality is available in ScribeDocReadValue function. Version 1.25 (9/27/2011) Fixed two bugs introduced in 1.23: * When doing a find and replace on a PDF file, you get a NullPointerException when saving the changes if you don't specify a 'flatten' parameter. * ScribeHighlight function doesn't appear to work, because the default highlight color was plain black text Version 1.23 (8/22/2011) * Added support for an additional parameter named flags which controls how regular expressions are processed in the ScribePatternMatchAll, ScribePatternReplaceAll and ScribeHighlight functions. * Fixed potential error message when saving Excel worksheets: com.prosc.scribe.WorkbookModel cannot be cast to com.prosc.scribe.PdfModel Version 1.221 (5/17/2011) * Correctly reads values with superscripts, newlines and other formatting from Word documents. * Loads more variants of .xlsx files * Date format is preserved when writing dates to a pdf. * Reading a non-existent Excel cell returns an empty string instead of an error. * Miscellaneous bug fixes. Version 1.2 (3/30/2011) * Added ScribeDocInsertCustomXml function for advanced users to write XML text directly into the Microsoft Office XML format. * You can now remove a formula in Excel by overwriting it * In Excel, newly created cells pick up the style of the row in which they are created. * Fixed a bug where ScribeDocSaveFile failed on Windows when writing to a path supplied by a FileMaker get function, like Get(DesktopPath) or Get (TemporaryPath) * Added an optional parameter to ScribeFileAsText to skip unrecognized files. Without this parameter, unrecognized files have their entire contents returned. * Now supports tab stops when replacing text in Word .docx files. * Fixed a problem in Excel when overwriting numeric cells with text values * Reading numeric values from Excel no longer applies formatting such as percentages, just returns the number value back to FileMaker. * Numbers and dates are written to Excel as Number/Date objects, not text. Version 1.143 (3/23/2011) * Fixed viewing differences in non-verbose mode where words were replaced with whitespace, hiding the edit. * Now turns invalid ASCII range values for Excel into spaces (ASCII values 0-8,11-12,14-31) * Fixed a bug in Microsoft's XML schema files where anchors in Word documents could result in an unreadable Word doc after processing with Scribe. Version 1.142 * Fixed "Unbalanced Save/Restore state operators" error that some users may have received when calling ScribeDocSave. Version 1.141 (2/8/2011) * Fixed highlighting with ScribeHighlight, which was returning an error. Version 1.14 (1/24/2010) * Fixed issues with Auto-Update on Mac and Windows. Plugins prior to this version will need to be removed from the Auto-Update directory, we've put together an applet to take care of this http://www.360works.com/remove-plugins/. Perviously, FileMaker needed to be restarted after Auto-Update on Mac, and on Windows the update had to be performed manually in some cases; this update takes care of both issues. Version 1.12 (1/18/2011) * Issue was resolved that was only allowing one plugin at a time to load on Windows 7 and Windows Server 2008r2. * Logging is now consolidated to a single log file for all 360Works plug-ins. This should make it easier to report issues to 360Works, and will also significantly reduce the amount of disk space used when running multiple 360Works plugins on FileMaker Server. Version 1.11 (1/7/2011) * When extracting text from .docx files, now respects tabs, inserts one return instead of two for paragraphs. Version 1.1 (1/5/2011) * New feature: ScribeDocWriteValue can now write images to PDF forms (only for PDF, not Word) * New feature: Now extracts message headers from Outlook .msg files * New example: Now includes example script showing how to use ScribeDocWriteValue * Bug fix: when reading .xls files from a URL; they were being treated as .xlsx instead. * Bug fix: reading older .xls files, in some cases they were being treated as .xlsx XML files * Bug fix: When extracting text from a URL, it was caching that result instead of reloading * Bug fix: Reading older .xls files broke on Mac OS X 10.6.5, this is now fixed Version 1.03 (11/3/2010) * Better support for writing FileMaker dates, times and timestamps to excel files * Can now extract text from Outlook .msg files * Now processes headers and footers in Word documents * Fixed a bug where a license key conflict could be incorrectly triggered for single-user licenses. * ScribeFileAsText can now extract text from Outlook .msg files * ScribeFileAsText now extracts the raw contents of any unrecognized file * Fixed a bug where passing in an empty field value as the value parameter to ScribeDocWriteValue would cause an error Version 1.02 (8/14/2010) * ScribeDocValue now works with Content Controls inside table cells * ScribeDocSubstitute now works on text inside Content Controls and table cells. Version 1.01 (8/6/2010) * Fixed a problem reported running in German / Windows OS Version 1.0 (8/5/2010) * Improved documentation * PDF fields are now returned in the order in which they appear * Excel documents now return numeric values for getText() and getIndex() - was previously only returning string values * Fixes to reading percentage and formatted fields from Excel * Added a ScribeDocSaveContainer field to simplify saving back to a container field * Better error reporting when trying to read fields from old non-XML office docs Version 0.9 (5/28/2010) * Added ScribeDocSubstitute function * Numerous fixes to word document reading/writing * Overhaul of difference engine, numerous fixes * Excel workbook support for writing dates as dates * Fix for differencesBetween when one block is empty * Fix for .xls files in the older excel format (non-xml) * Switched version number to an AutoUpdate-friendly format. * Fixed missing functions in documentation. * Improved difference engine, now handles trailing deleted lines correctly, does not insert extra white space after a modification * Support for re-evaluating calculation values in excel upon writing a value using Scribe. * Scribe_Highlight preserves original character styles. * Improved Excel document writing, fixed some problems that resulted in invalid worksheet files * Colors are no longer case-sensitive * xlsm file extension recognized as Excel * Support for mixed-case cell representations in Excel documents (e.g. A3 or a3 both work) * Added ScribeDifferenceReport function, for getting statistics on modifications between two blocks of text * Added support for reading PDF signature fields