v4.1.0 Open repository button, bug fixes, enhancements
This update adds several important features including a new button the toolbar to easily switch to the source code repository. (i.e. GitHub Desktop, Sourcetree, etc...) Special thanks to @bclothier for his extensive work on command bar support, and @hecon5 for contributing a number of bug fixes. @josef-poetzl shared a tip that solved a long-standing issue with complex workarounds. Thanks, everyone that had a part in this release!
IMPORTANT - Source file changes
- Autogenerated SQL definitions for linked tables are no longer included in source files. Structure changes to linked tables should be tracked through the Database connections, or through exports of the back end database.
New Features / Enhancements
- Add option to install add-in as compiled project (accde). Thanks, @josef-poetzl! #594
- Ribbon toolbar now works for ADP projects! Thanks, @josef-poetzl! #593
- Build out command bar (menu) export and import functions. Thanks, @bclothier!
- Add ribbon button to open source repository! Great idea, Albert Kallal! Supports GitHub Desktop, VSCode, Sourcetree, and TortoiseGit (others can be added.)
- Update testing database with new tests and adjustments to accommodate new Access bug.
- Add support for additional compare tools. #580
- Finish implementing command bar support. Thanks, @bclothier! bd14d8b, 205c27e
- Rework ribbon strings to support translation/localization. d80523d, df25d89, 07d4396
- Improve handling of zero length string in TDF data. #543
- Help generate compatible ADO connection strings for database connections. Thanks, @hecon5 and @bclothier! #546, #547
- Don't generate SQL structures for linked tables. See #540 for discussion on this.
- Performance enhancements. #527, f5f08be, 48c4612
- Build out more scaffolding/framework for future localization/translation of the addin. 52c3e3f, 32491da, 33ef754, 9ee1a8f, etc...
- Expand environment variables in export path. Good idea, @ngmhun! #490
Bug Fixes
- Handle form and import issues more gracefully #586
- Close database objects after running BeforeExport hook. #582
- Simplify sanitize options to avoid confusion. 7b1b06b
- Import modules before queries. Great suggestion, Albert Kallal! 6f075ed
- Improve handling of tables in ADP projects. Thanks, @bclothier! cc4f3a0
- Add error handling around ribbon COM add-in. 28001f9, d2e5f6d
- Fix XML encoding for legacy database formats. #560
- Improve error handling. Thanks, @hecon5! 15c8f7b
- Remove orphaned TableDef *.sql files. #536
- Fix incompatible Access SQL data type. Thanks, @the-Arioch! #533
- Add missing Getter for DigitsAfterDecimal in performance class. Thanks, @Tanarri! #509
- Prevent race condition with multiple operations running at the same time. #508
- Add error handling to warn users of broken references. #495
- Ensure linked table is accessible before exporting. #500
Known Issues
- Automatic export on save is currently experimental, and potentially has issues with older versions of Microsoft Access.
- Command bar support is still somewhat in a beta phase. Please report any issues!
- Clearing of orphaned database connection source file folders does not (yet) happen automatically.
See commit history for details on other changes not listed here.