I decided to take another shot a writing a parser in Sparx EA that could covert the XML version of the TBS policy instruments in to Archimate elements for traceability within Sparx EA.
After many days of effort spread out many, many weeks, I managed to get something that I think will be useful to others. The parsing of the XML only took about an hour, what took much longer is writing the logic to interpret the contents of the XML in a way to ensure that the resulting elements each received a unique traceability ID, and fixing issues within the XML.
Currently only the English versions of the instruments have been parsed, I hope to release the french versions in the next few weeks, and if I can have the two versions cross linked.
Some of the nodes in the XML had assigned IDs that were unique, but many more had “inferred” IDs based on their location in the XML hierarchy. There was also the issue of heading tags e.g. <title>…</title> in some XML files instead of parent child nodes to indicate hierarchy requiring that I track heading numbering to determine hierarchy. Luckily these difficulties seem to be legacy issues, the new releases have more easily parsed XML and seem to assign IDs to all nodes.
The majority of the statements in the instruments have been captured as Archimate Requirements elements, with the exception of terms/definitions which I captured as Archimate Meaning Elements.
I will be working on “modelling” instruments as I use them for a project I’m working on. My focus will be security, IM, and IT related instruments. I will be creating the business object, business role, business actor, and business process elements that realize the requirements in each directive.
I also plan to make my parsing script available to other Sparx EA users as part of my release of my EARecordset library (which the parsing script uses). For now the parsed policy instruments can be found on my download page as Sparx EA XMI files, CSV files and Archimate Exchange Files.
The files contain the following 262 policy instruments:
- Accessibility Standard for Real Property
- Acquisition Cards Program – Transfer of operational responsibility for the Government of Canada
- Appraisals and Estimates Standard for Real Property
- Carry-Forward of Capital Funds – TB Circular 1987-53
- Co-development Guidelines
- Common Services Policy
- Contracting Policy
- Controlled Goods Directive
- Data Standard on Classification of Procurement Items
- Defence Scientific Service Group – Pay Plan
- Directive on Accounting Standards GC 1010 Financial Statement Concepts (Materiality)
- Directive on Accounting Standards GC 1100 Financial Statement Objectives
- Directive on Accounting Standards GC 1150 Generally Accepted Accounting Principles
- Directive on Accounting Standards GC 1200 Financial Statement Presentation
- Directive on Accounting Standards GC 1300 Government Reporting Entity
- Directive on Accounting Standards GC 2400 Subsequent Events
- Directive on Accounting Standards GC 2700 Segment Disclosures
- Directive on Accounting Standards GC 3050 Loans Receivable
- Directive on Accounting Standards GC 3150 Tangible Capital Assets
- Directive on Accounting Standards GC 3250-3255 Retirement and Post-Employment Benefits
- Directive on Accounting Standards GC 3300-3310 Contingent Liabilities and Loan Guarantees
- Directive on Accounting Standards GC 3320 Contingent Assets
- Directive on Accounting Standards GC 3390 Contractual Obligations
- Directive on Accounting Standards GC 3410 Government Transfers
- Directive on Accounting Standards GC 4100 Specified Purpose Accounts
- Directive on Accounting Standards GC 4200 Inventories
- Directive on Accounting Standards GC 4300 Non-Monetary Transactions
- Directive on Accounting Standards GC 4400 Departmental Quarterly Financial Report
- Directive on Accounting Standards GC 4500 Departmental Financial Statements
- Directive on Accounting Standards GC 5000 Recording Financial Transactions in the Accounts of Canada
- Directive on Accounting Standards GC 5100 Payables at Year-End
- Directive on Accounting Standards Introduction – Government of Canada Accounting Handbook
- Directive on Accounting Standards
- Directive on Automated Decision-Making
- Directive on Career Transition for Executives
- Directive on Charging and Special Financial Authorities
- Directive on Classification Grievances
- Directive on Classification Oversight
- Directive on Classification
- Directive on Delegation of Spending and Financial Authorities
- Directive on Departmental Security Management
- Directive on Disposal of Surplus Materiel
- Directive on Executive (EX) Group Organization and Classification
- Directive on Executive Compensation
- Directive on Fleet Management Executive Vehicles
- Directive on Fleet Management Light Duty Vehicles
- Directive on Government Contracts, Including Real Property Leases, in the Nunavut Settlement Area
- Directive on Identity Management
- Directive on Information Management Roles and Responsibilities
- Directive on Interchange Canada
- Directive on Internal Audit
- Directive on Leave and Special Working Arrangements
- Directive on Management of Information Technology
- Directive on Official Languages for Communications and Services
- Directive on Official Languages for People Management
- Directive on Open Government
- Directive on Payments
- Directive on Performance Management
- Directive on Personal Information Requests and Correction of Personal Information
- Directive on Privacy Impact Assessment
- Directive on Privacy Practices
- Directive on Public Money and Receivables
- Directive on Recordkeeping
- Directive on Results
- Directive on Security Management
- Directive on Service and Digital Appendix A Mandatory Procedures for Enterprise
- Architecture Assessment
- Directive on Service and Digital Appendix B Mandatory Procedures on Application Programming Interfaces
- Directive on Service and Digital Appendix C Examples of Acceptable Network and Device Use (non-exhaustive list)
- Directive on Service and Digital Appendix D Examples of Unacceptable Network and Device Use (non-exhaustive list of examples)
- Directive on Service and Digital Appendix E Mandatory Procedures for Privacy and Monitoring of Network and Device Use Information Notices
- Directive on Service and Digital
- Directive on Social Insurance Number
- Directive on Terms and Conditions of Employment for Certain ExcludedUnrepresented Employees
- Directive on Terms and Conditions of Employment
- Directive on the Administration of Required Training
- Directive on the Business Number
- Directive on the Harassment Complaint Process
- Directive on the Implementation of the Official Languages (Communications with and Services to the Public) Regulations
- Directive on the Management of Communications
- Directive on the Management of Projects and Programmes
- Directive on the Performance Management Program (PMP) for Executives
- Directive on the Sale or Transfer of Surplus Real Property
- Directive on Transfer Payments
- Directive on Travel, Hospitality, Conference and Event Expenditures
- Directive on Union Dues
- Directives and Standards – General – Occupational Health and Safety
- Employment Equity Policy
- Financial Information Strategy Accounting Manual
- Fire Protection Standard
- Flying Accidents Compensation
- Foundation Framework for Treasury Board Policies
- Framework for the Management of Compliance
- Framework for the Management of Risk
- Future Asset Restoration Liability A Supplement to the Financial Information Strategy (FIS) Manual
- Governance and Expenditure Management Policy Area
- Guide to a Project Brief
- Guide to Administering Low-Value Amounts
- Guide to Claims
- Guide to Cost Estimating
- Guide to Delegating and Applying Spending and Financial Authorities
- Guide to Fleet Management, Chapter 2 Executive Vehicles
- Guide to Interest and Administrative Charges
- Guide to Investment Planning – Assets and Acquired Services
- Guide to Management of Materiel
- Guide to Requesting Capacity-Based Real Property Transaction Approval Limits
- Guide to the Management of Movable Heritage Assets
- Guide to the Review of Management of Government Information Holdings
- Guideline for Employees of the Government of Canada Information Management (IM) Basics
- Guideline for the Policy on Internal Control
- Guideline on Accountable Advances
- Guideline on Chief Financial Officer Attestation for Cabinet Submissions
- Guideline on Collection of Receivables
- Guideline on Common Financial Management Business Process 11 – Manage Planning And Budgeting
- Guideline on Common Financial Management Business Process 31 – Manage Procure to Payment
- Guideline on Common Financial Management Business Process 32 – Manage Travel
- Guideline on Common Financial Management Business Process 33 – Manage Other Payments
- Guideline on Common Financial Management Business Process 41 – Manage Other Capital Assets
- Guideline on Cost Estimation for Capital Asset Acquisitions
- Guideline on Defining Authentication Requirements
- Guideline on Departmental Chart of Accounts Line Object Codes
- Guideline on Developing a Departmental Security Plan
- Guideline on Financial Management of Pay Administration
- Guideline on Identity Assurance
- Guideline on Performance Measurement Strategy under the Policy on Transfer Payments
- Guideline on Recipient Audits Under the Policy on Transfer Payments and the Directive on Transfer Payments
- Guideline on Security for Debts
- Guideline on Self-Insurance
- Guideline on Service Agreements An Overview
- Guideline on Service Agreements Essential Elements
- Guideline on Service Management
- Guideline on Service Standards
- Guideline on the Application of Goods and Services TaxHarmonized Sales Tax
- Guideline on the Attribution of Internal Services
- Guideline on the Management of Public Key Infrastructure in the Government of Canada
- Guideline on the Payment, Recording and Rebate of the Quebec Sales Tax
- Guideline to Implementing Budget 2011 Direction on Public-Private Partnerships
- Guidelines for Discipline
- Guidelines for Essential Services Designations
- Guidelines for Labour-Management Consultation Committees
- Guidelines for Privacy Breaches
- Guidelines for the Processing of Garnishments
- Guidelines for Two-Tier Bargaining
- Guidelines for Use of Employer Facilities
- Guidelines on Contractual Arrangements
- Guidelines on Costing
- Guidelines on Fleet Management, Chapter 1 Light-Duty Vehicles
- Guidelines on Managerial or Confidential Exclusions
- Guidelines on Streamlining – Statutory Reports to Parliament
- Guidelines on the Proactive Disclosure of Contracts
- Guidelines on the Reporting of Grants and Contributions Awards
- Information Management – Guidelines
- Injury-on-Duty Leave
- Interdepartmental Transfers – Capital Assets A Supplement to the Financial Information Strategy (FIS) Manual
- Interim Directive on the Administration of the Access to Information Act
- Internal Support Services under Section 292 of the Financial Administration Act
- Internet Protocol Version 6 (IPv6) Network Equipment Procurement Guideline
- IT Security Guidelines, ITSG-33 control catalogue
- Long-Term Disability Insurance – Chapter 3-4
- Motor Vehicle Operations Directive – Chapter 2-11
- Notice on Policy on Management of Real Property – November 12, 2013
- Notice on Policy on Management of Real Property – November 16, 2009
- Notice on Policy on Management of Real Property – November 17, 2011
- Notice on Policy on the Management of Projects – November 12, 2013
- Occupational Health Evaluation Standard
- Operational Security Standard – Business Continuity Planning (BCP) Program
- Operational Security Standard – Readiness Levels for Federal Government Facilities
- Operational Security Standard Management of Information Technology Security (MITS)
- Operational Security Standard on Physical Security
- Operational Standard for the Security of Information Act
- Performance Pay Administration Policy for Certain Non-Management Category Senior Excluded Levels
- Performance pay for represented employees in the Administrative and Foreign Service Category
- Pesticides Directive – Chapter 2-15
- Policy Framework for Information and Technology
- Policy Framework for People Management
- Policy Framework for the Management of Assets and Acquired Services
- Policy Framework for the Management of Compensation
- Policy on Acceptable Network and Device Use
- Policy on Access to Information
- Policy on Classification
- Policy on Communications and Federal Identity
- Policy on Conflict of Interest and Post-Employment
- Policy on Decision Making in Limiting Contractor Liability in Crown Procurement Contracts
- Policy on Educational Assistance for Children of Employees – Chapter 7-3
- Policy on Employee Assistance Program
- Policy on Financial Management
- Policy on Government Security
- Policy on Green Procurement
- Policy on Harassment Prevention and Resolution
- Policy on Information Management
- Policy on Interchange Canada
- Policy on Internal Audit
- Policy on Investment Planning – Assets and Acquired Services
- Policy on Learning, Training, and Development
- Policy on Legal Assistance and Indemnification
- Policy on Management of Information Technology
- Policy on Management of Materiel
- Policy on Management of Real Property
- Policy on Occupational Safety and Health
- Policy on Official Languages
- Policy on Privacy Protection
- Policy on Results
- Policy on Service and Digital
- Policy on Service
- Policy on Terms and Conditions of Employment
- Policy on the Duty to Accommodate Persons with Disabilities in the Federal Public Service
- Policy on the Management of Executives
- Policy on the Management of Projects
- Policy on the Planning and Management of Investments
- Policy on Transfer Payments
- Procedures for Liaison with Private Contractors
- Procedures for Publishing
- Procurement Review Policy
- Public Service Income Benefit Plan for Survivors of Employees Slain on Duty
- Reducing Paper Burden on Small Business – A Progress Report for 1995 by the President of the Treasury Board
- Remediation Liabilities Related to Contaminated Sites A Supplement to the Financial Information Strategy (FIS) Manual
- Reporting Standard on Real Property
- Salary administration policy – Mediation Conciliation Officer Sub-group
- Security and Contracting Management Standard
- Security Organization and Administration Standard
- Self-Funded Leave Policy
- Service outside Canada
- Staff engaged locally outside Canada
- Standard for Electronic Documents and Records Management Solutions (EDRMS)
- Standard for fire safety planning and fire emergency organization – Chapter 3-1
- Standard for Organizational Project Management Capacity
- Standard for Project Complexity and Risk
- Standard on Customer Record
- Standard on Email Management
- Standard on Enterprise Resource Planning Systems
- Standard on Geospatial Data
- Standard on Identity and Credential Assurance
- Standard on Metadata
- Standard on Optimizing Websites and Applications for Mobile Devices
- Standard on Privacy and Web Analytics
- Standard on Quarterly Financial Reports for Crown Corporations
- Standard on Security Screening
- Standard on Vendor Record
- Standard on Web Accessibility
- Standard on Web Interoperability
- Standard on Web Usability
- Standards on Knowledge for Required Training
- Student Employment Policy
- TBITS 03 Coded Character Set for Information Interchange – Implementation Criteria
- TBITS 05 Canadian Government Keyboard Standard for Information Technology Equipment – Implementation Criteria
- TBITS 0611 Naming and Addressing for Government Handling Applications – Implementation Criteria
- TBITS 069 Canadian Open Systems Application Criteria (COSAC), Telecommunications wiring system in Government-Owned and leased buildings – Implementation Criteria
- TBITS 12 Codes for the Representation of Currencies and Funds – Implementation Criteria
- TBITS 23 Information Technology Vocabulary – Implementation Criteria
- TBITS 25 Materiel Coding – Implementation Criteria
- TBITS 26 Software Product Evaluation, Quality Characteristics and Guidelines for their Use – Implementation Criteria
- TBITS 30 Business Number – Implementation Criteria
- TBITS 36 All-Numeric Representation of Dates and Times -Implementation Criteria
- TBITS 38 Advanced card technologies – Physical parameters and appearance of the Government of Canada employee technology card – Implementation Criteria
- Telework Policy
- Term Employment Policy
- Termination of Employment of Public Service Employees Due to Alternative Delivery Situations
- Terms and Conditions of Employment for Students
- Values and Ethics Code for the Public Sector
- Workers’ Compensation
- Workplace Day Care Centres
- Workplace Fitness Program Policy