Importing Data
17 guides
Action XLS template fields
Asset Types XLS template fields
Asset XLS template fields
Client & Site XLS template fields
Client, Sites & Users Import - CSV/XLS/Spreadsheet Method
Configuration Change Tracking and Instance Pipeline Management
The article provides a detailed guide on managing configuration changes and synchronization between UAT and production environments for Halo. It explains how to enable configuration change tracking, manage and synchronize instances, and roll back changes when necessary. The system offers a comprehensive audit trail of changes, supports multiple entities, and provides best practices for configuration management. It also details how to manage multiple instances, improve module loading, and configure mailboxes for testing environments. The article emphasizes the importance of syncing, planning changes, and maintaining security measures.
Customers and Importing/Migrating Data
Importing Additional Fields via CSV
Importing Data
This article provides a comprehensive guide on importing data into the Halo platform using spreadsheets. It covers the use of spreadsheet templates, the process for completing imports, and how to handle specific field imports. Key topics include the update of existing entities by including identifiers, managing errors during the import process through the developer console, and steps for adding custom fields. The article also outlines where to find import settings for various entities, such as tickets, assets, clients, and more.
Importing Opportunity Tickets
This article explains how to import opportunity tickets in Halo, detailing the process for both existing and new customers. For existing customers, the ticket import spreadsheet is used, with restrictions on certain fields. It is crucial to use correct column headers to ensure data matching. Custom fields can be added by using a specific prefix. For new customers, opportunities are imported with specific customer data, as they are not yet in the system. Import templates and guidelines for handling custom fields are provided to streamline the process.
Service Catalogue XLS template fields
SQL Imports
This article provides a guide on setting up SQL imports using Halo's integrations. It covers creating new records, choosing integrators, and setting password storage methods. The article discusses the differences between the Halo Integrator and the Halo DB integrator, focusing on how passwords are managed and stored. It also includes detailed instructions on configuring SQL connections and mapping fields for data import into Halo, with considerations for importing large datasets into custom tables. Specific options for managing the behavior of SQL imports are outlined as well.
SQL Imports - Licences and Subscriptions
Supplier Import - CSV/XLS/Spreadsheet Method
Supplier XLS template fields
Ticket XLS template fields
User XLS template fields