• Home
  • Industries
    • HVAC
    • Building Services
    • Catering
    • Electrical
    • Facilities Management
    • Fire & Security
    • Generators
    • Lifts
    • Plumbing & Heating
  • Features
    • Asset Management
    • CRM
    • Customer Portals
    • Electrical Certificates
    • F-Gas
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Planned Maintenance
    • Print Templates
    • 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
    • HVAC
    • Building Services
    • Catering
    • Electrical
    • Facilities Management
    • Fire & Security
    • Generators
    • Lifts
    • Plumbing & Heating
  • Features
    • Asset Management
    • CRM
    • Customer Portals
    • Electrical Certificates
    • F-Gas
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Planned Maintenance
    • Print Templates
    • 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

Data Migration: How to Easily Move Your Data Into Clik Service

There was once a time when most business processes were manual. Every process, every action and every task were completed without any form of automation or technological help. Nowadays, businesses are a lot savvier.

Service industry companies are ditching paper-based management and going paperless. We know there are many benefits to embracing technology for your business and more and more businesses are taking the leap.

Perhaps you’ve already taken the initial switch to service management software, but you need to instead move your data from one system to another. It might seem like a lot to tackle at first, but it can be simple with the right software. We’ll walk through what data migration is and the tools you can use to move your data with ease.

 

What is Data Migration?

Data migration is the process of moving data from one place to another. This involves selecting, exporting and then importing your data, typically from one system or PC to another. This will likely be a one-time process to permanently move your data to a new location. Whether that is a new program, storage system or even a cloud environment.

For service industries, this data can be client details and sites, equipment and historical data for jobs, invoices, contracts and quotes. This could involve moving it all to a different PC/server or just transferring it from one system to another.

illustration showing transfer of files between computers

 

What are the Steps in Data Migration?

There might be several reasons for wanting to move your data. Perhaps your old system is outdated, you want your data in different programs, or you want to start fresh in a new system.

Whatever the reason, the process might seem daunting at first. But with the right tools, you can make the move simple. Here are some ways that Clik Service can help with data migration.

CSV templates

Clik Service has loads of default templates that you can use to import your data. Using these templates, you can import your:

  • customers
  • sites
  • equipment
  • products
  • contacts
  • purchase invoices
  • quotes
  • jobs

Each template has predefined field headers on the CSV. Once you know what you want to move, all you need to do is save the relevant template, open it in Microsoft Excel and fill in the fields you need to import.

Importing is then only a couple of clicks away. The system will scan for duplicates to make sure it doesn’t record the same information twice. This way, you can easily update any existing records and ensure your database is uncluttered and up to date whenever you import.

Moving your data doesn’t have to cause headaches. With the right job management software, you can get everything you need in one place in no time.

clik service, company import

 

CSV mapping

Sometimes you might have fields for your records that don’t match the ones used in Clik Service. Rather than using the default CSV templates, you can map the fields used in your earlier system to the fields in Clik Service.

CSV mapping saves you time copying and pasting from one spreadsheet to another. You can create your own templates to use over and over again. So, it’s useful, not just for transferring data between systems, but can also be used to update supplier price lists and more.

Similarly to using default templates, the mapping tool can check for duplicates when importing. It gives you the option to choose which field it checks for duplicates, making the process unique to your data. This way, you can get the system to check email addresses, quote numbers and more to make sure only the data you need is imported into your database.

You can also link fields and convert records with values that don’t match the ones in Clik Service. For example, the system you previously used might have a different name for quote references. If this happens, you can convert the names of field values using CSV mapping, so nothing gets missed or mixed up in the process

For more information about using CSV mapping in Clik Service, take a look at this video:

 

Looking for a new service management system with easy-to-use migration tools? Try out Clik Service for free today and see how it can transform your business organisation.

clik service software demo sign up

4.3

  • 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
    • Newsletters Archive
    • 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