• 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

Setting Up CSV Templates

You may have a current system that holds your customers, products, equipment, purchase orders, sites and contacts. Most systems allow you to extract into a CSV file, which can be saved into Excel.

Instead of using our default CSV templates, you can now map the fields from the CSV template your current system produces to Clik Service and use them again any time you want. This will stop copy/pasting into the Clik Service CSV files and save you some time.

This article will show you how to set this up.

To view, edit or create a predefined CSV import click on Tools > CSV Import > Setup Predefined Imports.

clik service tools menu, csv import, setup predefined imports

To create a new mapping configuration, click ‘New’, enter a name in the ‘Name’ box and select the type of CSV from the ‘Type’ box.

new equipment csv

You will notice that this populates the “User Column” and the “Clik Column”, with the default CSV headers for the selected import type as well as any user-defined fields assigned to that type.

  • The User Column is where we will eventually see the headers from your custom CSV, headers that are different from the standard Clik headers.
  • The Clik Column shows the standard Clik CSV headers for the selected type.
  • The Converters column is where we can view, edit and create converters for our imported data. For example, our CSV might have “yep” or “nope” but we need to enter “True” or “False”, we can create a rule to convert these values when importing.

Some rows might display icons next to the headers:

  • The plus icon means it is a duplicate field.
  • The link icon is a linked field.
  • The warning icon means are using more than one linked field. The import will work but obviously, both fields aren’t required.

csv import warning icons

If you hover the mouse of any of these cells you will see a tooltip explaining what each icon means.

Currently, the “User Columns” and the “Clik Columns” are both showing the default Clik columns. To load the columns from your own CSV, click on ‘Read CSV Headers’.

read csv headers button

Click ‘Yes’ to continue and select your CSV file. Find your CSV file and click ‘Open’ to receive the headers in that CSV.

The ‘User Column’ will now show all of your headers and the “Clik Column” will show headers where you are using the same header title.

To match your headers to the Clik headers click on an empty cell in the “Clik Column” and select the Clik header that corresponds to your user header.

clik column drop downs

The drop-down will show you all available Clik headers, including icons to indicate if they are links or duplicate headers.

Headers that have been matched show a green circle, and headers that haven’t been matched yet show an empty circle.

Continue matching your headers until they are all done. Your CSV needs to have at least one link header if the Clik CSV type includes a link header.

 

If some of your data appear in a different format from the Clik import format, you can create a converter to correct this.

To do this click on the cell in the “Converters” column for the row that contains this data.

For example, I will click on the “Converters” cell for my user field “(User Field) Is Fire Alarm on?”

csv mapping, converter field

Now you need to select ‘New’.

Type the current record in your CSV. In this case, it’s “Yes” and “No” under the user field ‘is fire alarm on’.

Then select the value in Clik. In this case, because it’s a yes/no value it will be “True” and “False”.

value converters

You will see “Yes” anywhere you have created converters.

is fire alarm on, yes selected

Once you have completed matching your headers and created any required converters click ‘OK’ to close and save the CSV mapping.

csv mapping config, ok button

To import a CSV that contains the headers you created in your mapping you will be able to find your mapping listed under Tools > CSV Import > Imports.

clik service tools menu, csv import, my equipment csv

This will open the usual CSV import window with your mapping selected.

CSV Mapping was added in update v4.331, make sure your software is running the latest version to ensure you have the new improvements and features.

Clik Service

Clik Service

Importing Data

Importing Data From CSV Files
Clik Service

Clik Service

Importing Data

Using CSV Mapping [Video]

Importing Data

  • Using CSV Mapping [Video]
  • Setting Up CSV Templates
  • Importing Data From CSV Files

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