TilliT
HomepageChangelogDeveloper
  • Home
  • Introduction to TilliT
    • Introduction for New TilliT Customers
    • Videos
  • Getting Started
    • Overview
    • Definitions
    • Set up a Site & Assets
    • Set up an Activity
    • Create an Order
    • Start an Order
    • Next steps
  • Planning
    • Overview
    • Data Gathering
      • Site & Assets
      • Production Orders
      • Activities
      • Shifts & Calendars
      • Materials
      • Process Variables
      • Attributes
      • Articles
      • Checklist
  • Knowledge Base
    • Everyday Usage
      • Layout Overview
      • Login to TilliT
      • Basic functionality
      • Lock screen
      • Pinning Assets
      • Switch Site
      • Next Steps
      • Activities
        • Claiming
        • Completing
        • Manually starting
      • Orders
        • Create adhoc Order
      • Events
        • Raising an Event Using the UI
      • Notifications
    • Scheduler
      • Introduction
      • Feature Overview
      • Scheduler to Digital Operations integration
      • Scheduling
        • Scheduling
        • Orders
        • Scenarios
        • Inventory
      • Configuration
        • Operations
        • Equipment
        • Personnel
        • Materials
        • Availability
        • Optimisation
        • Changeovers
        • Loading data with excel Add-in
      • MVP Setup Guide
    • Insights
      • Activity report
      • Production Report
      • Dashboards
      • Advanced Analytics
        • Sharing dashboard
    • Users
      • User
        • User Confirmation
        • User channels
        • User subscriptions
      • Groups
      • Permissions
      • User authentication with SSO
    • Boards
    • Settings
      • Asset Hierarchy
        • Site
        • Asset
          • Asset Attributes
          • Asset Tolerances
          • Downtime periods
          • Attribute Group
          • Edge data tags
        • Asset class
        • Order Templates
          • Order Template with Unit Conversion
        • Calendar
          • Calendar item
        • Shifts Templates
          • Creating Shift Templates
          • Manual shift patterns
        • Asset Meter
      • Material Definition
        • Material
        • Material group
        • Material attributes
          • Example of material attributes
        • Material tolerance
          • Example of Material tolerance
        • Material component
        • Material conversion
      • Activity Templates
        • Activity template
          • Creating an activity
          • Where
          • When
          • Versioning
          • Building
          • Elements
            • Item types
              • Item properties
                • Active item & hidden expressions
                • Hint
                • Tolerance Source
              • Update Attribute
              • Board Item
              • Raise event
            • Data Types
              • Evaluate Data types & Dynamic Note
              • Note
              • Option list
              • Dynamic option list
              • Barcode
              • GS1 Barcode Scanner
              • Edge data
              • Material Component
              • Image capture
              • Sections
              • Digital Signature
              • Material
              • Dynamic Form Items
              • Inventory Key
        • Activity class
      • Events
        • Event Type
        • Event Relay
        • Event Schedule
      • Articles
      • Integrations
        • Adding Webhook Subscriptions
        • MQTT Integration
        • Receive the TilliT Event
        • Notifications
      • Configuration
        • Attribute
        • Attribute group
        • Tolerances
        • Dashboard group
        • Report Templates
          • Creating and Using Report Templates
        • Process variable
        • Unit of Measure
        • Run Rate Template
      • Translation
      • Audit Log
    • Edge
      • Introduction
      • Before You Start
        • Security / Firewall
        • TilliT Edge
        • Understanding your Networks
        • Common Installation Solutions
        • Managing and Publishing changes
      • Physical Device
        • Setup
      • Using Docker
        • Upgrading a docker container from before 2025
      • Common Data Sources
        • OPC-UA
        • Modbus TCP
        • Ethernet IP
        • Profinet
        • RTLE
        • Simulator
      • Data Tags
        • Data Tag Templates
        • Order Number Tag Template
        • Edge Data Tag Options
      • Edge Triggers
      • TilliT Sensors
        • Connect TilliT Edge to a Wireless Gateway
        • Bind a Wireless Counter to a Wireless Gateway
        • Configure FEN-20 PNP Sensor
      • Troubleshooting
      • Windows Edge Installer
    • History
    • OEE
      • Two Steps to Availability
      • Two Steps to Performance
      • A Step to Quality
    • Track and Trace
      • Before you begin
      • Transaction Types
      • Movement Types
      • Movement Types Field
      • Adding Material Movement to an Activity Template
      • Completing the Activity
      • Reporting
    • Mobile View
      • Device shortcut
      • Unable to enter Negative Numbers
    • Importing, Exporting and Cloning Entities
    • Troubleshooting
  • Tools
    • Excel add-in
      • How to Install the Excel Add-in
        • Excel Online
        • Desktop
      • How to Update the Excel Add-in
      • Loading multiple orders
      • Maintaining Master Data in Bulk
      • Downloading Time-Series Data
    • Staging Environment
    • Ignition Module
      • Installation
      • TilliT Tag Provider
        • Data From TilliT to Ignition
        • Data From Ignition To TilliT
      • Scripting Using the TilliT Module
      • Network Security
  • INFRASTRUCTURE
    • FAQ
    • Architecture
    • Disaster Recovery
    • Software Quality Assurance
Powered by GitBook
On this page
  • Overview
  • Accessing the Master Data
  1. Tools
  2. Excel add-in

Maintaining Master Data in Bulk

PreviousLoading multiple ordersNextDownloading Time-Series Data

Last updated 2 years ago

Overview

To help maintain your configuration, you can bring your TilliT data into Excel via Add-in.

While everything in the add-in is available via the UI, using Excel allows you to edit, copy, paste, backup, etc. all your Master Data.

The video below shows an example of how to use this feature effectively.

Accessing the Master Data

Depending on which environment you're accessing, click the TilliT DO Stage tab (Stage) or TilliT tab (Production), then click the Data button.

A menu will pop up on the right, providing the following options:

There are two (2) types of data you can access. Config data (data defining behaviour of TilliT) and Instance data (data submitted during an order).

  • Asset hierarchy - manage Site, Asset and Shift config data.

  • Material definition - manage Material config data.

  • Activity Template - manage Activity and Option Group config data.

  • Edge - manage Edge config data.

  • Orders - manage Order instance data.

  • Activity Results - manage Activity instance data.

  • Events - manage Event instance data.

  • Shifts - manage Shift instance data.

  • Integration - manage Integration config data.

  • Configuration:

    • Attributes - manage Attribute config data.

    • Dashboard Groups - manage Dashboard Group config data.

    • Event Types - manage Custom Event config data.

    • Process Variable - manage Process Variable config data.

    • Unit of measure - manage Unit of Measure config data.

    • Order Template - manage Order Template config data.

    • Attribute Groups - manage Attribute Group config data.

  • Scheduler Settings - manage Scheduler config data, if you are using the TilliT Scheduler solution.

  • Scheduler Orders - manage Scheduler Order instance data, if you are using the TilliT Scheduler solution.

When you select once of the above Groups, you'll be asked to select an entity. To understand the various entities, you will need to understand the data you're accessing. This is best done by reading through the various articles in Setting up TilliT.For this following example, we'll use one of the most commonly used groups, Activity Template, and click on the Activity Template Item entity.

Once you've selected an entity, you will be asked to define the Page size (how many results should be given per page/excel sheet) and which Page number you wish to load. For example, if there are 20,000 entries in TilliT, setting the Page size to 2,000 will divide the data into 10 pages. Only one (1) page can be loaded at a time, so you would need to choose which page using any number between 1-10.This helps when dealing with a large number of entries.

This will load all Activity Template Items in our data.

You can also refine what is loaded by filtering by a field from the data. In our example, we will look for a specific Item Key.

Now we have only loaded the precise data we wish to work with.