• Contents
  • Search
  • Welcome
  • Copyright Notice
  • Introduction
    • What pasTransfer is
    • How pasTransfer works
  • Deployment
    • Prerequisites
    • Installation
    • Configuration
    • Licensing
  • Administration
    • Navigation
    • Command Line
    • Guided Tour
    • Common Pages
      • Welcome
      • XML Schema Definitions
      • Finished
    • Account Wizard
      • Pages
        • Configuration
        • Select Source and Destination Connection Types
        • Connection Type Identification
        • Import Source Data and Review Warnings
        • Summarization Configuration Options
        • Summarize Results
        • Destination Data Processing Settings
        • Destination Connection Mappings
        • Validate and Review Mappings
        • Write Data to Destination
        • Mapping Providers
          • Working with Mapping
          • Excel Workbook
            • Excel Workbook Mapping Provider Options
          • pasPortal
            • pasPortal Mapping Credentials
            • pasPortal Mapping Selections
            • pasPortal Lookup Selections
          • Database Query
            • Database Query Mapping Provider Connection
            • Database Query Mapping Provider Options
      • Connections
        • Sources
          • Excel Spreadsheet
          • JSON File
          • ODBC
          • OLEDB
          • pasTransfer Account XML Source
          • Sample Source
          • SQL Server
          • Text File
          • XML File
        • Destinations
          • Excel Spreadsheet
          • ODBC
          • OLEDB
          • pasTransfer Account XML Destination
          • Sample Destination
          • SQL Server
          • Text File
          • XML File
      • Account and Attribute Summary
    • General Wizard
      • Pages
        • Configuration
        • Select Source and Destination Connection Types
        • Connection Type Identification
        • Import Source Data and Review Warnings
        • Summarization Configuration Options
        • Summarize Results
        • Destination Data Processing Settings
        • Destination Connection Mappings
        • Validate and Review Mappings
        • Write Data to Destination
        • Mapping Providers
          • Working With Mapping
          • Excel Workbook
            • Excel Workbook
          • pasPortal
            • pasPortal Mapping Credentials
            • pasPortal Mapping Selections
            • pasPortal Lookup Selections
          • Database Query
            • Database Query Mapping Provider Connection
            • Database Query Mapping Provider Options
      • Connections
        • Sources
          • Excel Spreadsheet
          • HL7 Admission Discharge Transfer
          • JSON File
          • ODBC
          • OLEDB
          • pasTransfer General XML Source
          • Sample Source
          • SQL Server
          • Text File
          • XML File
        • Destinations
          • Excel Spreadsheet
          • ODBC
          • OLEDB
          • pasTransfer General XML Destination
          • Sample Destination
          • SQL Server
          • Text File
          • XML File
      • Attribute Summary
    • Ledger Wizard
      • Guided Tour
      • Pages
        • Configuration
        • Select Source and Destination Connection Types
        • Connection Type Identification
        • Source Data Processing Settings
        • Import Source Data and Review Warnings
        • Summarization Configuration Options
        • Summarize Results
        • Destination Data Processing Settings
        • Destination Connection Mappings
        • Validate and Review Mappings
        • Write Data to Destination
        • Mapping Providers
          • Working with Mapping
          • Excel Workbook
            • Excel Workbook Mapping Provider Options
          • pasPortal
            • pasPortal Mapping Provider Credentials
            • pasPortal Mapping Selections
            • pasPortal Lookup Selections
          • Database Query
            • Database Query Mapping Provider Connection
            • Database Query Mapping Provider Options
      • Connections
        • Sources
          • Excel Spreadsheet
          • JSON File
          • ODBC
          • OLEDB
          • pasTransfer Ledger XML Source
          • PayChex Employee Time
          • Sample Source
          • SQL Server
          • Text File
          • XML File
        • Destinations
          • Excel Spreadsheet
          • ODBC
          • OLEDB
          • pasTransfer Ledger XML Destination
          • Sample Destination
          • SQL Server
          • Text File
          • XML File
      • Account and Attribute Summary
    • Vendor Wizard
      • Guided Tour
      • Pages
        • Configuration
        • Select Source and Destination Connection Types
        • Connection Type Identification
        • Import Source Data and Review Warnings
        • Summarization Configuration Options
        • Summarize Results
        • Destination Data Processing Settings
        • Destination Connection Mappings
        • Validate and Review Mappings
        • Write Data to Destination
        • Mapping Providers
          • Working With Mapping
          • pasPortal
            • pasPortal Credentials
            • pasPortal Mapping Selections
            • pasPortal Lookup Selections
          • Database Query
            • Database Query Mapping Provider Connection
            • Database Query Mapping Provider Options
      • Connections
        • Sources
          • Excel Spreadsheet
          • JSON File
          • ODBC
          • OLEDB
          • pasTransfer Vendor XML Source
          • Sample Source
          • SQL Server
          • Text File
          • XML File
        • Destinations
          • Excel Spreadsheet
          • ODBC
          • OLEDB
          • pasTransfer Vendor XML Destination
          • Sample Destination
          • SQL Server
          • Text File
          • XML File
      • Attribute Summary
    • Macro Designer
    • Query Designer
    • Regular Expression Designer
  • Troubleshooting
    • Basic Guidelines
    • Frequently Asked Questions
  • Reference
    • Date and Time Format Strings
    • Numeric Format Strings
    • Options
    • Regular Expressions
    • Wildcards
    • XML
    • Macros
      • Working with Macros
      • Macro Expressions
        • Attribute
        • Blank
        • BusinessDate
        • Case
        • Coalesce
        • Column
        • Connection
        • Copy
        • DateFormat
        • DateMath
        • DateTime
        • Environment
        • Error
        • Escape
        • ExcelLookup
        • Exception
        • FormatAmount
        • If
        • In
        • Increment
        • IndexOf
        • IsDate
        • IsNumeric
        • IsWhitespace
        • LastOfTheMonth
        • Left
        • Length
        • Lookup
        • Lower
        • Mapping
        • MappingLine
        • Math
        • Option
        • PadLeft
        • PadRight
        • Period
        • Random
        • Regex
        • Replace
        • Resolve
        • Reveal
        • Right
        • SQLLookup
        • Stuff
        • Substring
        • TextRow
        • TransactionDOW
        • Trim
        • TrimEnd
        • TrimStart
        • Upper
        • XPath
    • Enumerations
      • AccountType
      • AmountProcessingStyle
      • Indicator
      • PaymentFormat
  • Glossary of Terms
  • Technical Support
Match: