CheckDrawingDateTimeStamp Macro

The routine is designed to check the date and time stamp of drawings found in the drawings folder, and the subfolders under the project folder, and to compare the drawings against the master copy stored in the project database.

The routine can be set to run automatically during application initialization. The project administrator must add the user defined directives:

USER_RUNMACROS=YES

USER_CHECKDATETIMESTAMP=YES

When the user defined directives are added and saved to the SQL admin database, the application must be restarted. During initialization, the application checks and compares all the drawings in the project drawing folder against the master copy in the project database.

Note:
The macro can be executed manually by the user with a command defined in the lisp routine: AVVMAC_TIMST.

There are two potential warnings which display if an inconsistency is found.

• If a drawing is found in the file system, but it is not available in the project database.

  Warning: Drawing: [D:\Projects\RHL\Drawings\D014\TESTD.DWG] available at file system is not found at Project database

• If a date time mismatch is found between the master drawing, located in the project database, and a temporary drawing file copy, located in the drawing folder.

  Warning: Drawing: [D:\Projects\RHL\Drawings\TEST_DRAWING\RHL_Test2.DWG] Mismatched time stamp at File System: Monday, Jul 3, 2023, 09:38 AM ,time stamp at project database: Wednesday, Sep 6, 2023, 12:55 PM

If a significant mismatch is reported, more than one minute, assuming the latest drawing is in the file folder, AVEVA recommends using document manager to restore the drawing located in the file folder into the project database to ensure there is no data loss.

If no drawing is found in the project database, carry out a review to see if this is intentional, or if the drawing should be restored to the master project database using the document manager.