InDesign Script Find Change From Spreadsheet

CHANGE LOG

Version 6.3 (231206)
a. Release 6.2.1

Version 6.2.1 (231205)
a. Keep text/GREP change to value null when blank and changing style.

Version 6.2 (231205)
a. Set properties individually rather than properties object.
b. Find and remove when change is empty string.
c. Rebuild i18n.
d. Miscellaneous.

Version 6.1 (231104)
a. Clear grep/text find/change preferences each row of data.
b. Correct flaw when either style find is '[Any Style]'.
c. Set styles find and change once prior to story loop.
d. Miscellaneous.

Version 6.0 (231103)
a. Recognize paragraph style [No Paragraph Style].
b. Recognize paragraph style [Basic Paragraph].
c. Recognize character style [None].
d. Recognize both character style and paragraph style [Any Style].

Version 5.9 (231026)
a. Fix find replace style only and leave content untouched.
b. Add version to error message.

Version 5.8 (230823)
a. Miscellaneous.

Version 5.7 (230817)
a. Restore empty item in drop-down lists.

Version 5.6 (230817)
a. Properly handle regex lookarounds.
b. Clear data always on failure to select csv or txt.
c. Miscellaneous.
d. Rebuild i18n.

Version 5.5 (230717)
a. Data file accept tab delimited text.
b. Miscellaneous.
c. Rebuild i18n.

Version 5.4 (220222)
a. Read script folder for i18n make consistent with AI and PS.
b. Update copyright year.

Version 5.3 (221229)
a. Update function parseCsv.
b. Increase data file maximum to 500K.
c. Update i18n.

Version 5.2 (221102)
a. Folder property 'fsName' use 'fullName' instead.

Version 5.1 (221019)
a. Remove //@target
b. Check app name and warn if wrong app for script.

Version 5.0 (220807)
a. Settings current break apart single return statement.
b. Settings apply and current try/catch/alert errors.
c. Improved done alert or error.
d. Use doneMessage instead of var abort.
e. Close working once at end, before that hide working.

Version 4.9 (220708)
a. Updated function settings.setList.
b. btnFileData.onClick updated function setList.

Version 4.8 (220616)
a. Implement file.openDlg for existing files.

Version 4.7 (220614)
a. Separate declare and define script and UI variables.
b. Miscellaneous.

Version 4.6 (220611)
Publish 4.5.1

Version 4.5.1 (220611)
a. Fix error textFrame undefined when getting layer.

Version 4.5 (220521)
a. Add option ignore locked layers.
b. Rebuild i18n.

Version 4.4 (220430)
a. Add option ignore hidden layers.
b. Rebuild i18n.

Version 4.3 (220307)
a. Replace 'Processing complete' => 'Done'
b. Replace 'User canceled' => 'Canceled'
c. Use variable 'abort' instead of testing if action == cancel
d. Rebuild i18n.
e. Replace function 'progress' with 'working' window.
f. i18n file encoding UTF-8.
g. Settings file encoding UTF-8.
h. Miscellaneous.

Version 4.2 (220211)
a. Add progress.
b. Add zoom buttons.
c. Matches loop check for skip all or cancel and break.
d. After matches loop check for cancel and return.
e. Don't need target.select().
f. Other adjustments to textReplace function.
g. Rename function 'textReplace' => 'confirmChange'
h. Rename function 'userInteraction' => 'confirmChangeWindow'
i. Both functions rename arguments message => task, target => item.

Version 4.1 (220113)
a. Miscellaneous (match Find Change Multi Doc).

Version 4.0 (220112)
a. Miscellaneous (match GREP Replace From Spreadsheet).
b. Miscellaneous UI adjustments.

Version 3.9 (220111)
a. Add option CSV delimiter.
b. Update i18n.
b. Update to i18n[title] in undo.
c. Remove unused var doneMessage.
d. Hoist var settings.
e. Function setList/listSelection rename control => uiList

Version 3.8 (211212)
a. Apply settings implement function getProp.
b. Apply settings updated setList function.
c. Give btnFileData handler its own setList function.
d. Read i18n catch (_) empty variable.
e. Miscellaneous.

Version 3.7 (211129)
a. Flaw allowed keep capitalization when ignore case disabled.
b. UI label columns align left. Windows, poor result with right alignment.
c. Disable keep capitalization if ignore case is disabled.
d. Update i18n.
e. Miscellaneous.

Version 3.6 (211103)
a. Function setList default to null, nothing selected.

Version 3.5 (211029)
a. Fix flaw setList outside if when CSV file selected.

Version 3.4 (211027)
a. Allow blank change, for removal of text found.
b. Include footnotes.
c. Duplicate optimization done to Batch Find Change From CSV.
d. Call setList on selecting CSV file, to set column lists to defaults.
e. Fix overset text not exiting.

Version 3.3 (211019)
a. Columns drop-down lists instead of inputs.

Version 3.2 ()
a. New readData() method of reading CSV.

Version 3.1 (211017)
a. Updated settings code.
b. Miscellaneous.

Version 3.0 (210927)
a. Update settings load function.

Version 2.9 (210917)
a. Miscellaneous.

Version 2.8 (210916)
a. Remove support message with email address.
b. Settings load/save move file.close() to finally.

Version 2.7 (210915)
a. UI adjustments (columns)
b. Miscellaneous.

Version 2.6.5 (210902)
a. Enforce 100K limit on data file.

Version 2.6.4 (210730)
a. Remove polyfill Array.indexOf. Not ever used.

Version 2.6.3 (210730)
a. No need to preserve, set, and restore findChangeGrepOptions
   This script does not use GREP.

Version 2.6.2 (210711)
a. Solution to null userData makes new problem.
   Some users have MyDocuments on a server.
   Only use new solution if userData returns "/Volumes/null", rather than always.
   Rather than 'myDocuments', use value for 'desktop'.

Version 2.6.1 (210608)
a. Fix settings file error userData is null. Use documents and replace path.

Version 2.6 (210425)
a. Improved error handling.

Version 2.5 (210401)
a. Ignore excess data columns.

Version 2.4.2 (210321)
a. Alert and confirm supply all arguments.

Version 2.4.1 (210308)
a. Remove show invisibles and screen mode preview off.

Version 2.4 (210308)
a. Add option keep capitalization.

Version 2.3.2 (201219)
a. Mac open data file recognize alias in Macintosh file filter.
b. Windows open data file use Windows file filter.
c. Open data file validate extension as .csv or .txt

Version 2.3.1 (201013)
a. UI consistency.
b. Miscellaneous.
   (remove excess after JSON code;
    update copyright year;
    update i18n)

Version 2.3 (191220)
a. Fix window button return value problem with Windows close button.
b. Put preserve/restore preferences inside doscript call so all part of undo.
c. No longer restore prior zoom and display preferences.
d. Add 'User canceled' to .i18n for localization.

Version 2.2 (190902)
a. Miscellaneous.

Version 2.1 (190808)
a. Repair flaws in parseCsv and parseTxt functions.

Version 2.0 (190624)
a. Revise settings.
b. Miscellaneous.

Version 19.3.10 (1.4.1)
a. Confirm dialog wrap change text in quotes.

Version 19.3.8 (1.4)
a. Add license.

Version 19.2.24 (1.3.1)
a. Revise inconsistent settings error message.

Version 19.2.23 (1.3)
a. Update settings file error handling.
b. Revise error messages.
c. Internationalization.

Version 19.2.21 (1.2)
a. Test for overset text before UI rather than after OK.
b. Miscellaneous.

Version 19.2.6 (1.1)
a. Preserve whole word option.

Version 19.1.25 (1.0)
a. Initial release.