Project Configuration

Project Data Load Configuration

ØAfter the configuration of Classification and System Tables is completed, Project Data Load Procedures in SQL Server need to be modified per Project Requirements.

Important Sections in Project Load Procedure p_X4DAdmin_Project_DataLoad are:

•Import Classification Tables in X4D as defined in t_X4DAdmin_LinkedServerTables

•Import System Tables in X4D as defined in t_X4DAdmin_LinkedServerTables

•Fill the Classification of Tags based on multiple search criteria

•Import the Document List and Links from the Document Management System

•Update the Primary Keys of the imported tables for fast system access

•Consolidate all the Classification Tables, CONS_DATA, Primary Key [TAG NO]

•Consolidate all the System Tables, CONS_TYPE, Primary Key [COMP_ID]

•Correlate System and Classification Tables to make TAG_COMP relationship

•Update Model Status of Classification tables

•Rule based mapping of Tags and Document List TAG_DOCS

•Some project based search updates

•Re-Build of Indexes for fast searches in SQL

•Audit Trail of all above steps in t_log table

ØTest the procedure few times on the project. Perform a few Audits on Classification Data, System Data, Document List, TAG-Document relationship etc. in X4D to make sure data is getting imported plus it’s not getting duplicate. In case of any ambiguity, recheck the p_X4DAdmin_Project_DataLoad procedure. Proceed only after gaining good confidence in multiple imports.

ØCreate a Batch file to execute p_X4DAdmin_Project_DataLoad procedure. This batch file shall now be scheduled to run daily/weekly as required by the project. This keeps system tables, classifications tables, document tables and their relationship tables, all in Sync.

ØAfter the procedure, check the t_log file created by procedure for errors or warnings if any.