• Products
    • Clik Service
    • Clik Remote
    • Clik Jobs
    • NICEIC Cert Software
    • Clik Cert Electrical
    • Clik Cert
    • Clik Cert (Field)
    • Clik AC Calc
    • Clik Training
  • Features
    • Asset Management
    • Bespoke Certificates
    • Catering Certificates
    • CRM
    • Customer Portals
    • Diary
    • Electrical Certificates
    • Engineer Portals
    • F-Gas
    • Fire and Security Certificates
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Notifications
    • Planned Maintenance
    • Print Templates
    • Purchase Orders
    • Quoting
    • Reporting
    • Service Incidents
    • Stock Control
    • Third Party Integrations
    • Validation
  • Industries
    • Catering
    • Facilities Management
    • Lifts
    • Electrical
    • Plumbing and Heating
    • Air Conditioning
    • Generators
    • Building Services
    • Fire and Security
    • Doors, Gates and Barriers
    • Grounds Maintenance
    • Roofing
    • Pools
    • Cleaning
    • Renewable Energy
    • PAT Testing
    • Gas
    • Pest Control
    • Drainage
    • Telecommunications
    • Audio Visual
    • Laboratory Equipment
    • Water Services
    • HVAC
    • Construction
    • Environmental
    • Healthcare and Medical
    • Property Maintenance
    • Office Equipment
    • Carpentry
    • Fencing
  • Pricing
  • Case Studies
  • Blog
  • Newsletters
  • Support
Contact Us Try for FREE
  • Products
    • Clik Service
    • Clik Remote
    • Clik Jobs
    • NICEIC Cert Software
    • Clik Cert Electrical
    • Clik Cert
    • Clik Cert (Field)
    • Clik AC Calc
    • Clik Training
  • Features
    • Asset Management
    • Bespoke Certificates
    • Catering Certificates
    • CRM
    • Customer Portals
    • Diary
    • Electrical Certificates
    • Engineer Portals
    • F-Gas
    • Fire and Security Certificates
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Notifications
    • Planned Maintenance
    • Print Templates
    • Purchase Orders
    • Quoting
    • Reporting
    • Service Incidents
    • Stock Control
    • Third Party Integrations
    • Validation
  • Industries
    • Catering
    • Facilities Management
    • Lifts
    • Electrical
    • Plumbing and Heating
    • Air Conditioning
    • Generators
    • Building Services
    • Fire and Security
    • Doors, Gates and Barriers
    • Grounds Maintenance
    • Roofing
    • Pools
    • Cleaning
    • Renewable Energy
    • PAT Testing
    • Gas
    • Pest Control
    • Drainage
    • Telecommunications
    • Audio Visual
    • Laboratory Equipment
    • Water Services
    • HVAC
    • Construction
    • Environmental
    • Healthcare and Medical
    • Property Maintenance
    • Office Equipment
    • Carpentry
    • Fencing
  • Pricing
  • Case Studies
  • Blog
  • Newsletters
  • Support
return to Support Centre

Importing Boards, Circuit Details and Test Results

This article will show you how to import boards, circuit details and test results from a CSV file.

You may have other software that allows you to export board details, circuit details and test results, you can copy and paste into CSV and import them into a certificate.

 

Creating the CSV file

First, you need to be in the certificate you want to import your boards, circuits and test results.

From the certificate select Tools > Import Boards, Circuit Details and Test Results.

import boards, circuit details and test results tools option

Now you can decide to either create a CSV that we provide to fill in or copy and paste your board, circuit details and test result to or select a CSV you have already created, if its different column names you will need to contact us to discuss your CSV being a mapped option for future use.

In this case, we are going to ‘Create a CSV’ and copy-paste results from another sheet.

import, create csv file

Below is an example of one board with multiple circuits I want to import. It’s important that all circuits are linked to a board by having the ‘DistributionBoard|Designation’ filled in so the circuits link to that board. As you can see below this is one board with 30 circuits.

It’s also worth noting you don’t need to put the same information in for the board, you can do this on one row.

*Please note, there are more columns for distribution boards. For this article, the CSV is shortened, however, this would still work, and you can cut down on the columns you use if necessary.

circuits csv spreadsheet

Once you’re happy with the CSV, you can save it and look to import it into a certificate.

 

Importing Boards, Circuits and Test Results

Now you can use the CSV you have created and import this into a cert.

Go back to the certificate and go to Tools > Import Boards, Circuits and Test Results.

import boards, circuit details and test results tools option

Now click ‘Select CSV’ and browse to the location you have saved the CSV file.

selecting csv file

You will have the option to clear all existing boards, in this case, we will not be selecting this.

clear all existing rows

The last section on this screen allows you to ‘Select Import Mapping’. As we are using the default CSV we have provided you won’t need to select an import mapping.

However, if you export your current boards, circuits and test results from other software into another CSV file, then please contact your account manager and we can look to map those fields with the board, circuit and test result fields we provide.

Once you’re happy click ‘Next’.

You can now preview the boards and circuits, you can click on the + sign to see all the circuits. Once you’re happy click ‘Finish’.

import complete

The board or boards will now be imported. Let’s have a look at the circuit details page.

circuit details page with circuit details filled out

NICEIC Cert Software

NICEIC Cert Software

Circuit Details

Importing Board Templates

Circuit Details

  • Adding Circuits to Certs
  • Rearranging and Removing Circuits
  • Using the Circuit Wizard
  • Exporting Circuit Details
  • Setting Circuits as Spares
Show more

Ask Tech a Question

Did you find what you were looking for? Don’t worry if not, you can get in touch with our tech support team.

Contact Tech Support
PERSONALISED LEARNING

A Training Masterclass From Our Experts

You’ve got the software. Now get the expert knowledge straight from the experts. If you want to know more about Clik Service or the NICEIC Cert Software, maybe you want to drill down into a specific module, or a run-through for a new engineer, we’ll walk and talk you through it in the way that suits you.

Learn More

4.5

  • Products
    • Clik Service
    • Clik Jobs
    • Clik Remote
    • NICEIC Cert Software
    • Clik Cert
    • View All Products
  • Features
    • CRM
    • Invoicing
    • Job Management
    • Job Scheduling
    • Quoting
    • View All Features
  • Industries
    • Air Conditioning
    • Electrical
    • Facilities Management
    • Fire and Security
    • Plumbing
    • View All Industries
  • Support
    • Training
    • Service Status
    • Contact Tech Support
    • Product Roadmap
  • About
    • Blog
    • News
    • Privacy
    • Terms

Copyright Clik Limited © 2000-2023 – All Rights Reserved