Note: This content is specific to NYSDOT clients and environments. |
This guide is meant for AgileAssets implementation engineers implementing content import for NYSDOT. This guide assumes basic knowledge of AMS system jobs and familiarity with NYSDOT CR-13.
The system job is implemented by class com.agileassetsinc.custom.nysb.InspectionDataContentLibraryImport and may be found in the job schedule as 'Import bridge inspection content'.
This system job is intended for and tested against Oracle Web Content Center (WCC) as the content manager in AMS. Our development is server configured similar to NYSDOT's.
WCC connections: It will try to use 5 concurrent connections to import files
Performance: The memory and disk speed of the WCC server hardware are likely be the biggest factors in import performance.
The sole parameter to this import job is the path of the directory that contains BIN directories.
Within the BIN directory each folder hierarchy contributes an element of the content meta-data stored in CONTENT_LIBRARY
Exceptions: Content Type directories named "InspectionReports" and "StandardPhotos" are excluded from import.
Directories nested below content type (2) directories are simply ignored.
5 concurrent connections are used to execute the file imports and exits with just a log statement after completion.
Idempotent: Successful imports are recorded in CONTENT_LIBRARY_IMPORTS (absolute path, file size, timestamp) so they are not re-imported in case of successive runs.
AgileAssets engineers may query performance and see most recent activity in some detail:
-- bytes/hour: -- Whole job SELECT sum(CONTENT_SIZE)/(24*(max(DATE_UPDATE)-min(DATE_UPDATE))) FROM CONTENT_LIBRARY_IMPORTS; -- Past hour SELECT sum(CONTENT_SIZE)/(24*(max(DATE_UPDATE)-min(DATE_UPDATE))) FROM CONTENT_LIBRARY_IMPORTS WHERE DATE_UPDATE > (CURRENT_TIMESTAMP-NUMTODSINTERVAL(1, 'HOUR')); |