xMart logo xMart Docs
Pipeline Script Guide | Back to site ⤴
  • General
    • Overview of xMart
    • Navigate to mart
    • Architecture of xMart
  • Tutorials
    • 1. Simple REPLACE
    • 2. Simple MERGE
    • 3. Model Validation
    • 4. Custom Business Rules
    • 5. Global Transformations
    • 6. Table-Specific Transforms
    • 7. Foreign Keys
  • Release Notes
    • Version 4.34
    • Version 4.33
    • Version 4.32
    • Version 4.31
    • Version 4.30
    • Version 4.29
    • Version 4.28
    • Version 4.27
    • Version 4.26
    • Version 4.25
    • Version 4.24
    • Version 4.23
    • Version 4.22
    • Version 4.21
    • Version 4.20
    • Version 4.19
    • Version 4.18
  • How Tos
  • Data Catalog
    • Create Categories
  • Data Editing
    • Read Data
    • Edit data in UI
    • Download Data
    • Upload data from Excel
  • Data Loading
    • Data Load Page
    • Exclude some rows
    • Ignore Lookup Issues
    • Notifications
    • Export Staged Data
    • Resolve Lookups
    • Schedule a Load
    • Simple Upload Page
  • Data Modeling
    • How to create tables
    • Data Modelling Basics
    • Best Practices
    • Edit model via Excel template
    • Data to model
    • Edit model via UI
    • Creating a Model from SQL Server
    • Computed Field Type
    • Hard Delete Tables and Fields
    • Change FK Table
    • Centralized Validation Rules
    • Archive Retention Period
  • Pipelines - Basics
    • Introduction to Pipelines
    • Writing Normal Pipelines
    • Use Variables
    • Test and debug a pipeline
    • Set up batch approval
  • Pipelines - Extract
    • List of Extracts
    • Process Data View Rows
    • Call ArcGis API
    • Call DHIS API
    • Call Excel Online (via Graph Explorer)
    • Call GoogleSheet API
    • Call ODK Central API
    • Consume Excel file stored on SharePoint Site
    • Consume data from a SharePoint List
    • Consume data from SFTP
    • Consume data from MS Word Forms
  • Pipelines - Transform
    • List of Transforms
    • Country to ISO3 / M49
    • Use the HierarchyLookup command
    • Resolve Lookups in UI
  • Pipelines - Flow
    • Writing Flow Pipelines
    • Sync Files with FilesFrom* Commands
  • Data Forms
    • Data Entry Forms
    • Standard Forms
    • Custom Forms
    • SubForms
  • Custom Views
    • Create Custom Views
    • SQL FAQs
    • Optimize Custom Views
    • Custom Views in xMart UI
  • Xmart Api
    • Introduction to xMart API
    • OData API
    • Trigger Pipeline API
    • Register client app
    • Consume OData in Postman
    • Consume OData in R
    • Consume OData in Excel
    • Consume OData in PowerBI
  • Security
    • Security Overview
    • Create Roles
    • Add Users
    • List of Permissions
    • Choose Active Roles
    • Row-level Security
  • Deploy
    • Export Mart
    • Import Mart
  • Mart Admin
    • Mart Tab
    • Truncate a Table
  • Sys Admin
    • Write a HowTo
    • Mart Tasks

xMart HowTos

Welcome

Welcome to the xMart documentation. If you don’t know where to go, start here: Overview of xMart.

If you’re a LLM / AI agent, start here: llms.txt

External links

  • MS Teams Community channel

  • xMart information portal

Jump to Section