• Home
  • Industries
    • Catering
    • Facilities Management
    • Lifts
    • Electrical
    • Plumbing & Heating
    • HVAC
    • Generators
    • Building Services
    • Fire & Security
  • Features
    • Asset Management
    • Bespoke Certificates
    • CRM
    • Customer Portals
    • Electrical Certificates
    • Diary
    • F-Gas
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Planned Maintenance
    • Print Templates
    • Purchase Orders
    • Quoting
    • Reporting
    • Service Incidents
    • Stock Control
    • Third Party Integrations
  • Products
    • Clik Service
    • Clik Remote
    • Clik Jobs
    • NICEIC Cert Software
    • Clik Cert Electrical
    • Clik Cert
    • Clik Cert (Field)
    • Clik AC Calc
    • Clik Training
  • Pricing
  • Case Studies
  • Blog
  • Newsletters
  • Support
Contact Us Try for FREE
  • Home
  • Industries
    • Catering
    • Facilities Management
    • Lifts
    • Electrical
    • Plumbing & Heating
    • HVAC
    • Generators
    • Building Services
    • Fire & Security
  • Features
    • Asset Management
    • Bespoke Certificates
    • CRM
    • Customer Portals
    • Electrical Certificates
    • Diary
    • F-Gas
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Planned Maintenance
    • Print Templates
    • Purchase Orders
    • Quoting
    • Reporting
    • Service Incidents
    • Stock Control
    • Third Party Integrations
  • Products
    • Clik Service
    • Clik Remote
    • Clik Jobs
    • NICEIC Cert Software
    • Clik Cert Electrical
    • Clik Cert
    • Clik Cert (Field)
    • Clik AC Calc
    • Clik Training
  • 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

CSV Mapping [Video]

Importing Data

  • 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.

4.4

  • 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 & Security
    • Plumbing
    • View All Industries
  • Support
    • Training
    • Service Status
    • Contact Tech Support
    • Software Updates Coming Soon
  • About
    • Blog
    • News
    • Privacy
    • Terms
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
Cookie SettingsAccept All
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
__cfruidsessionThis cookie is set by the provider Cloudflare. This cookie is used for load balancing and for identifying trusted web traffic.
__hssrcsessionThis cookie is set by Hubspot. According to their documentation, whenever HubSpot changes the session cookie, this cookie is also set to determine if the visitor has restarted their browser. If this cookie does not exist when HubSpot manages cookies, it is considered a new session.
__stripe_mid1 yearThis cookie is set by Stripe payment gateway. This cookie is used to enable payment on the website without storing any patment information on a server.
__stripe_sid30 minutesThis cookie is set by Stripe payment gateway. This cookie is used to enable payment on the website without storing any patment information on a server.
AWSALBCORS7 daysThis cookie is used for load balancing services provded by Amazon inorder to optimize the user experience. Amazon has updated the ALB and CLB so that customers can continue to use the CORS request with stickness.
cookielawinfo-checkbox-advertisement1 yearThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Advertisement".
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
JSESSIONIDsessionUsed by sites written in JSP. General purpose platform session cookies that are used to maintain users' state across page requests.
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
CookieDurationDescription
__hssc30 minutesThis cookie is set by HubSpot. The purpose of the cookie is to keep track of sessions. This is used to determine if HubSpot should increment the session number and timestamps in the __hstc cookie. It contains the domain, viewCount (increments each pageView in a session), and session start timestamp.
__zlcmid1 yearThis cookie is used by Zendesk live chat and is used to store the live chat ID.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
CookieDurationDescription
__hstc1 year 24 daysThis cookie is set by Hubspot and is used for tracking visitors. It contains the domain, utk, initial timestamp (first visit), last timestamp (last visit), current timestamp (this visit), and session number (increments for each subsequent session).
CONSENT16 years 4 monthsThese cookies are set via embedded youtube-videos. They register anonymous statistical data on for example how many times the video is displayed and what settings are used for playback.No sensitive data is collected unless you log in to your google account, in that case your choices are linked with your account, for example if you click “like” on a video.
hubspotutk1 year 24 daysThis cookie is used by HubSpot to keep track of the visitors to the website. This cookie is passed to Hubspot on form submission and used when deduplicating contacts.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
CookieDurationDescription
IDE1 year 24 daysUsed by Google DoubleClick and stores information about how the user uses the website and any other advertisement before visiting the website. This is used to present users with ads that are relevant to them according to the user profile.
test_cookie15 minutesThis cookie is set by doubleclick.net. The purpose of the cookie is to determine if the user's browser supports cookies.
VISITOR_INFO1_LIVE5 months 27 daysThis cookie is set by Youtube. Used to track the information of the embedded YouTube videos on a website.
YSCsessionThis cookies is set by Youtube and is used to track the views of embedded videos.
yt-remote-connected-devicesneverThese cookies are set via embedded youtube-videos.
yt-remote-device-idneverThese cookies are set via embedded youtube-videos.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
CookieDurationDescription
m2 yearsNo description available.
SAVE & ACCEPT
Powered by CookieYes Logo