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