Clik
  • Products
    • Clik ServiceClik Service
    • Clik RemoteClik Remote
    • Clik JobsClik Jobs
    • NICEIC Cert SoftwareNICEIC Cert Software
    • Clik Cert ElectricalClik Cert Electrical
    • Clik CertClik Cert
    • Clik Cert (Field)Clik Cert (Field)
    • Clik AC CalcClik AC Calc
    • Clik TrainingClik Training
  • Features
    • Asset ManagementAsset Management
    • Bespoke CertificatesBespoke Certificates
    • Catering CertificatesCatering Certificates
    • CRMCRM
    • Customer PortalsCustomer Portals
    • DiaryDiary
    • Electrical CertificatesElectrical Certificates
    • Engineer PortalsEngineer Portals
    • F-GasF-Gas
    • Fire and Security CertificatesFire and Security Certificates
    • Fleet ManagementFleet Management
    • Gas CertificatesGas Certificates
    • InvoicingInvoicing
    • Job ManagementJob Management
    • Job SchedulingJob Scheduling
    • Manager PortalManager Portal
    • Mobile Job SheetsMobile Job Sheets
    • NotificationsNotifications
    • Planned MaintenancePlanned Maintenance
    • Print TemplatesPrint Templates
    • Purchase OrdersPurchase Orders
    • QuotingQuoting
    • ReportingReporting
    • Service IncidentsService Incidents
    • Stock ControlStock Control
    • Third Party IntegrationsThird Party Integrations
    • ValidationValidation
  • Industries
    • CateringCatering
    • Facilities ManagementFacilities Management
    • LiftsLifts
    • ElectricalElectrical
    • Plumbing and HeatingPlumbing and Heating
    • Air ConditioningAir Conditioning
    • GeneratorsGenerators
    • Building ServicesBuilding Services
    • Fire and SecurityFire and Security
    • Doors, Gates and BarriersDoors, Gates and Barriers
    • Grounds MaintenanceGrounds Maintenance
    • RoofingRoofing
    • PoolsPools
    • CleaningCleaning
    • Renewable EnergyRenewable Energy
    • PAT TestingPAT Testing
    • GasGas
    • Pest ControlPest Control
    • DrainageDrainage
    • TelecommunicationsTelecommunications
    • Audio VisualAudio Visual
    • Laboratory EquipmentLaboratory Equipment
    • Water ServicesWater Services
    • HVACHVAC
    • ConstructionConstruction
    • EnvironmentalEnvironmental
    • Healthcare and MedicalHealthcare and Medical
    • Property MaintenanceProperty Maintenance
    • Office EquipmentOffice Equipment
    • CarpentryCarpentry
    • FencingFencing
    • Waste and RecyclingWaste and Recycling
    • Traffic ManagementTraffic Management
  • Pricing
  • Case Studies
  • Blog
  • Newsletters
  • Support
Contact Us Try for FREE
Clik phone
  • Products
    • Clik ServiceClik Service
    • Clik RemoteClik Remote
    • Clik JobsClik Jobs
    • NICEIC Cert SoftwareNICEIC Cert Software
    • Clik Cert ElectricalClik Cert Electrical
    • Clik CertClik Cert
    • Clik Cert (Field)Clik Cert (Field)
    • Clik AC CalcClik AC Calc
    • Clik TrainingClik Training
  • Features
    • Asset ManagementAsset Management
    • Bespoke CertificatesBespoke Certificates
    • Catering CertificatesCatering Certificates
    • CRMCRM
    • Customer PortalsCustomer Portals
    • DiaryDiary
    • Electrical CertificatesElectrical Certificates
    • Engineer PortalsEngineer Portals
    • F-GasF-Gas
    • Fire and Security CertificatesFire and Security Certificates
    • Fleet ManagementFleet Management
    • Gas CertificatesGas Certificates
    • InvoicingInvoicing
    • Job ManagementJob Management
    • Job SchedulingJob Scheduling
    • Manager PortalManager Portal
    • Mobile Job SheetsMobile Job Sheets
    • NotificationsNotifications
    • Planned MaintenancePlanned Maintenance
    • Print TemplatesPrint Templates
    • Purchase OrdersPurchase Orders
    • QuotingQuoting
    • ReportingReporting
    • Service IncidentsService Incidents
    • Stock ControlStock Control
    • Third Party IntegrationsThird Party Integrations
    • ValidationValidation
  • Industries
    • CateringCatering
    • Facilities ManagementFacilities Management
    • LiftsLifts
    • ElectricalElectrical
    • Plumbing and HeatingPlumbing and Heating
    • Air ConditioningAir Conditioning
    • GeneratorsGenerators
    • Building ServicesBuilding Services
    • Fire and SecurityFire and Security
    • Doors, Gates and BarriersDoors, Gates and Barriers
    • Grounds MaintenanceGrounds Maintenance
    • RoofingRoofing
    • PoolsPools
    • CleaningCleaning
    • Renewable EnergyRenewable Energy
    • PAT TestingPAT Testing
    • GasGas
    • Pest ControlPest Control
    • DrainageDrainage
    • TelecommunicationsTelecommunications
    • Audio VisualAudio Visual
    • Laboratory EquipmentLaboratory Equipment
    • Water ServicesWater Services
    • HVACHVAC
    • ConstructionConstruction
    • EnvironmentalEnvironmental
    • Healthcare and MedicalHealthcare and Medical
    • Property MaintenanceProperty Maintenance
    • Office EquipmentOffice Equipment
    • CarpentryCarpentry
    • FencingFencing
    • Waste and RecyclingWaste and Recycling
    • Traffic ManagementTraffic Management
  • Pricing
  • Case Studies
  • Blog
  • Newsletters
  • Support
iconreturn to Support Centre
icon

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.

icon

Clik Service

Importing Data

Importing Data From CSV Files
icon

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

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
A Training Masterclass From Our Experts
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
more more

4.4

Certifications
  • 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
    • Cookie Policy

Copyright Clik Limited © 2000-2023 – All Rights Reserved

more more more more more more