FileMan Advanced User Manual

Table of Contents

• Orientation
• Introduction
  • What is VA FileMan?
• Part I: Tools
  • Chapter 1: Import and Export Tools
    • What Applications Can You Exchange Data With?
    • How Data is Moved Between Applications
    • Dependency on Correct Data Communication
    • Data Formats
      • Delimited Data Format
      • Fixed-Length Data Format
    • How to Export Data
      • 1. Make Sure a FOREIGN FORMAT File Entry is Available
      • 2. Select Fields for Export Option
      • 3. Create Export Template Option
      • 4. Choose Entries/Export Data
      • Special Considerations: Exporting Numbers
      • Special Considerations: Multiples
      • About EXPORT Templates
    • How to Import Data
      • 1. Generate ASCII Source File
      • 2. Specify Data Format, Source File, and Destination File
      • 3. Match Source to Destination Fields
      • 4. Run the Import
      • Special Considerations: Multiples
      • Importing from VMS Files
    • Foreign Formats
      • FOREIGN FORMAT File Attributes Reference
      • Print Format Documentation Option
      • Define Foreign File Format Option
  • Chapter 2: Relational Navigation
    • Simple Extended Pointer
      • Simple Extended Pointer Syntax (Short form)
      • Simple Extended Pointer Syntax (Long Form)
      • Examples
      • How to Navigate With a Variable Pointer Field
    • Relational Jumps Across Files
    • Backward Extended Pointer
    • Join Extended Pointer
      • Limitations
      • Example
    • Multiline Return Values
      • WORD-PROCESSING Field
      • Multiples
      • Backward Pointer
  • Chapter 3: Advanced Edit Techniques
    • Field Value Stuffing
      • Set Field Default (2 //)
      • Stuff/Delete Field Value (3///)
      • Unvalidated Stuffs: (4////)
      • Variable Stuffs
      • WORD-PROCESSING Field Stuffing
      • Looping (^LOOP)
    • INPUT Templates
      • Overview
      • Branching Within INPUT Templates
    • Edit Qualifiers
      • Forcing Special Prompts
      • Duplicating Input Values
      • Forcing Required Input
    • Text Formatting in Word Processing Fields
      • Word Wrapping
      • Tabs
      • Formatting Text with Word Processing Windows (Frames) | |
      • Text Formatting Expressions in Word Processing Windows
  • Chapter 4: Computed Expressions
    • Syntax
      • Elements of Computed Expressions
      • Operators in Computed Expressions
      • DATA TYPEs in Computed Expressions
      • Using Functions as Elements in Computed Expressions
    • Where to Use
      • Using Computed Expressions in COMPUTED Fields
      • Where to Use Computed Expressions "On the Fly"
  • Chapter 5: VA FileMan Functions
    • How to Use VA FileMan Functions
    • Documentation Conventions for VA FileMan Functions
    • VA FileMan Functions
    • Date/Time Functions
    • Environmental Functions
    • File and File Data Functions
    • Mathematical Functions
    • Printing Related Functions
    • String Functions
    • Temporary Data Storage Functions
    • M-Related Functions
  • Chapter 6: Statistics
    • How to Generate Statistics from Reports
    • Descriptive Statistics
    • Scattergram
    • Histogram
  • Chapter 7: System Management
    • Setup
      • ^DINIT
      • Security
    • Standalone VA FileMan
      • Device Handling for Stand-alone VA FileMan
      • NEW PERSON File for Stand-alone VA FileMan
    • ^%ZOSF Nodes
      • Manually Setting ^%ZOSF Nodes
    • Alternate Editors
      • Setting Up Alternate Editors
    • COMPILED ROUTINE File
      • COMPILED ROUTINE File Cleanup: ENRLS^DIOZ( )
• Part II: File ManagementII-IV
  • Chapter 8: List File Attributes
    • List File Attributes Option
      • Brief Data Dictionary
      • Condensed Data Dictionary
      • Standard and Modified Standard Data Dictionaries
      • Custom-Tailored Data Dictionary
      • Templates Only Format
      • Global Map
      • Indexes and Cross-References Only
      • Keys Only
      • Map Pointer Relations Option
      • Check/Fix DD Structure Option
  • Chapter 9: Creating Files and Fields
    • Creating a File
    • Creating Fields
      • Field DATA TYPEs
      • Screen Mode Field Editing
      • DATE/TIME DATA TYPE
      • NUMERIC DATA TYPE
      • SET OF CODES DATA TYPE
      • FREE TEXT DATA TYPE
      • WORD-PROCESSING DATA TYPE
      • COMPUTED DATA TYPE
      • POINTER TO A FILE DATA TYPE
      • VARIABLE-POINTER DATA TYPE
      • MUMPS DATA TYPE
    • Multiple-Valued Field (Multiples)
    • Making a Field Mandatory
    • Field Number Sequences
    • NUMBER (.001) Field
    • Changing and Deleting Fields
      • Changing Field Attributes
      • Changing a Field's DATA TYPE
      • Deleting an Existing Field
    • Examples of File and Field Creation
      • File Creation
      • DATE/TIME Field
      • SET OF CODES Field
      • FREE TEXT Field
      • WORD-PROCESSING Field
      • COMPUTED Field
      • POINTER TO A FILE Field
      • VARIABLE-POINTER Field
      • Creating a Multiple
  • Chapter 10: File Utilities
    • Verify Fields
    • Cross-Reference a Field or File
      • Types of Traditional Cross-references
      • Edit a Traditional Cross-reference
      • Create a Traditional Cross-reference
      • Delete a Traditional Cross-reference
      • New-Style Cross-references
      • Edit a New-Style Cross-reference
      • Create a New-Style Cross-reference
      • Delete a New-Style Cross-reference
    • Identifier
    • Re-Index File
    • INPUT Transform (Syntax)
    • Edit File
    • OUTPUT Transform
    • Template Edit
    • Uneditable Data
    • Mandatory/Required Field Check
    • Key Definition
      • Create a Key
      • Edit a Key
      • Delete a Key
      • Verify a Key
• Part III: Security
  • Chapter 11: Auditing
    • Auditing a Data Field
      • Setting a Data Field Audit
      • Turning Data Field Audit On/Off
      • Reviewing the Data Field Audit Trail
      • Tracking Data Field Audits
      • Purging a Data Field Audit Trail
    • Auditing a Data Dictionary
      • Setting Up a Data Dictionary Audit
      • Reviewing the Data Dictionary Audit Trail
      • Tracking Audited Data Dictionaries
      • Purging a Data Dictionary Audit Trail
  • Chapter 12: Data Security
    • Security at the File Level
      • Access Code Security on Files
      • File Access Security (Formerly Part 3 of Kernel)
    • Protection for Fields in a File
    • Protection for Templates
• Part IV: Archiving
  • Chapter 13: Transferring File Entries
    • Transfer File Entries Option
    • Transferring Data Within the Same File
      • Transferring Entries Between Files
      • Transferring Entries into a New File
    • Compare/Merge File Entries Option
      • Comparing Entries
      • Merging Entries
  • Chapter 14: Extract Tool
    • Extract Overview
    • Important Items to Note
      • Source File
      • Destination File
    • Mapping Information
    • ARCHIVAL ACTIVITY File
    • Extract Steps
      • Select Entries to Extract Option (1 of 9)
      • Add/Delete Selected Entries Option (2 of 9)
      • Print Selected Entries Option (3 of 9)
      • Modify Destination File Option (4 of 9)
      • Create Extract Template Option (5 of 9)
      • Update Destination File Option (6 of 9)
      • Purge Extracted Entries Option (7 of 9)
      • Cancel Extract Selection Option (8 of 9)
      • Validate Extract Template Option (9 of 9)
  • Chapter 15: Filegrams
    • FILEGRAM-type Templates
    • Filegram and Archiving Relationship
    • Using Filegrams
    • Filegram Steps
      • Create/Edit Filegram Template Option
      • Display Filegram Template Option
      • Specifiers Option
      • Generate Filegram Option
      • Receiving Filegrams with MailMan
      • View Filegram Option
      • Install/Verify Filegram Option
      • Deleting a Filegram
  • Chapter 16: Archiving
    • Considerations Before Archiving
    • Archiving Process, including Archiving Options (1-9)
      • Select Entries to Archive
      • Add/Delete Selected Entries
      • Print Selected Entries
      • Create Filegram Archiving Template
      • Write Entries to Temporary Storage
      • Move Archived Data to Permanent Storage
      • Purge Stored Entries
      • Cancel Archival Selection
      • Find Archived Entries
      • ARCHIVAL ACTIVITY File
• Glossary
• Index