joyfullservice:
As this project continues to move forward, many changes and updates are being made but not specifically documented in this change log. For details on updates since 2015, please review the commit messages in this repository.
(If you use this project and would find more detailed change logs to be helpful, please let me know, and I will take that into consideration.)
joyfullservice:
- Performed some significant refactoring to use the system as a reference library rather than a collection of modules that need to be added to each project.
- Added support for exporting VBE objects directly, allowing drag-and-drop within projects in the IDE.
- Standardized module names (special prefix no longer needed)
- Source folder name changed to be specific to the current database (avoids unexpected results when working with two databases in the same folder.)
- Source folders only created when they will contain content
- General code cleanup and organization
- Improved debug output in debug mode
- Converted module constants to input parameters for debug mode and tables to save data
- Updated sample database
jwbrookes:
- Added support for Table Data Macros
- Added support for Linked Tables (supports relative paths for linked files)
- Added support for Print Variables in Reports (Page size and orientation)
- Added support for Relation for all types of table
- LoadVCS warnings removed when no object delete is required
- Removed elements from Report export that change constantly but don't affect import
- Fixed query import bug (complex queries being rearranged on import)
- Fixed missing constraints in table export
prmills:
- Added support for bit fields in table Import/Export
- Added support for References without GUIDs
- Export all table data with
INCLUDE_TABLES = "*"
jwbrookes:
- Refactored AppCodeImportExport into several modules
- Added VCS_Loader, a module to import multiple vba modules into a database
jwbrookes:
- Fixed bug in ExportTableDef function
- Removed redundant DeleteFile function (had been left commented out in the module)
matonb:
- Removed DeleteFile function and replaced calls to Kill with FileSystemObject.DeleteFile
matonb:
- Added DoEvents in loops to avoid "Unresponsive" state.
matonb:
- Aggressive Sanitise, moved BaseInfo from "Block" regex to Line level.
- Changed line level skipping to include lines with deeper indendation the follow. This catches split lines mostly found in BaseInfo exports.
matonb:
- Aggressive Sanitise now excludes "BaseInfo" lines. These lines were seen to be randomly switching between being empty, not present or containing SQL on an arbitary basis.
matonb:
- Replaced TempFile function.
- Temporary file names now generated via external MS libraries.
- Functions using TempFile updated to only call TempFile function once.
- Temporary file path and name stored in tmepFileName variable.
- Temporary files deleted when done.
- Changed db declaration in ImportProject to DAO.database.
matonb:
- AppcodeImportExport excluded from ExportAllSource
- Added ImportProject sub-routine,
Deletes all forms, macros, modules and queries before calling ImportAllSource.
By clearing out the existing objects, you know that your database only contains
code from your version control database.
Excludes AppCodeImportExport
matonb:
- All "exclusion" patterns are now matched by regex.
- Added StripPublishOption constant.
If set to True the following lines are also excluded from the export files - dbByte "PublishToWeb" ="1"
- PublishOption =1
- Added DeleteFile(FileName) function
The function tries to delete FileName three (3) times before giving up.
A delay of 100ms is introduced between delete attempts should the first fail.
matonb:
- Added dbLongBinary "DOL" to aggressive sanitize, these statements were appearing in queries and being flagged by git as modified in files that hadn't been touched by developers.
matonb:
- 0.3.1 Patched - Serious Problem: SanitizeTextFiles If logic removed all lines containing "Begin".
- 0.3.2 Replaced if block for skipping code sections in SanitizeTextFiles with regular expression.
bkidwell:
- Sanitize query exports.
- Fixed SERIOUS TYPO in UCS2-to-UTF-8 conversion (wrong threshold for 2 byte versus 3 byte symbol in output stream).
- AggressiveSanitize default True.
matonb:
- Added AggressiveSanitize constant, it's a number to allow for different levels in the future.
Default False. - Added Skipping for GUID & Namemap in aggressive sanitize mode.
If AggressiveSanitize is on, also sanitize query exports.- Append Number of objects imported/exported to information lines in immediate window.
- Updated readme (removed references to terminal window).
- Close all open forms and reports when importing and exporting because you can't import an open form or report.
matonb:
- Added dbLongBinary "DOL" to SkipList in SanitizeTextFiles.
- Added Source directory check to ImportAllSource, pops up a message box if missing.
- Only create source directories if there is something to export.
bkidwell:
- Removed external executable for converting UCS-2-little-endian to and from UTF-8; replaced with VB6 methods.
- Added demo database to the repository.
- Removed the need for a special "export_[name]" query to export and import a lookup table.
- Added check to determine if Queries, Forms, etc. are exported from THIS database (depending on which version of Access created it) uses UCS-2-little-endian, or a legacy 8-bit Windows character set. Skip converting to/from UTF-8 if not using UCS-2, because the point of the conversion was to avoid writing 0x00 bytes in the text files and confuse diff/merge tools.
Initial release