BLOG. SMART PRACTICAL BUSINESS ADVICE

Large-Scale Data Migration? “What could possibly go wrong?”

This Chicago law firm had a choice: migrate their data by themselves and risk running into insurmountable hurdles or get expert help from a dedicated product specialist. The answer won't surprise you, because it's a no-brainer.

1 Shares
WORKetc QuickStart

Losing hundreds of thousands of hours’ worth of work. An immense hit on their reputation. Staggering financial costs just to rebuild their records from scratch.

These were the risks that a law firm* in Chicago had to consider when they wanted to switch from their old CRM system to a new one. They kept asking themselves: Would all of their old data end up in one piece on the new system? Would it be immediately usable, without having to rectify any corruption or mistakes?

They were faced with two options:

  1. Do the migration themselves, spending precious time and effort that they could have used to continue growing their business and risk losing some or even all of their data due to inexperience with the new system.
  2. Have a dedicated product expert with years of experience do it for them.

Of course, they chose the latter.

A Big Client Win

“It looked a bit daunting at first, all those years’ worth of old cases and records, but the import went without a hitch,” says WORKetc Head of Support, Steve Westrop, who assisted the law firm throughout the QuickStart Onboarding Program.

The undertaking started with a call where Steve asked the client exactly what kind of data they needed to bring over to WORKetc and for what they needed that data. Among the important considerations were several custom fields that they absolutely needed to have in WORKetc.

“We can easily add custom fields for every import we do,” Steve explains further. “So for this client, we first built the custom fields on our projects module. We put those in a project so they got all the data and the custom fields that they needed to map to.

“They just added the custom field columns to their import file then added the data in there so they can import into those specific custom fields in WORKetc.

“I then sent the client’s data to my colleague, Justine, who went ahead and ran tests on the actual data migration. We made sure every piece of data in that file would end up exactly where it was supposed to go.”

With both the firm’s data and their WORKetc account itself properly prepared and the migration process fully tested, it barely took two days for the actual import to finish.

“That was a big win for the client, getting all that data into WORKetc. They needed to have those old projects inside the system so they could refer back to them whenever a new, similar project came along.”

WORKetc Projects

Custom Invoices and More

Having the client’s data within the system is just one part of the onboarding process. Steve then proceeded to focus on the client’s current project workflow to figure out a process that would make the most sense for them using WORKetc’s project management software.

Mapping out a streamlined and efficient WORKetc workflow went pretty smoothly since Steve was using their actual data. It was data they were familiar with, plus they knew exactly what they needed.

Steve then moved on to the client’s other requirements: custom invoices, integrations setups, and some general tips and best practices.

“Integration setups are actually among the the most common things we do in QuickStart,” he explains. “For almost every client, we either set up QuickBooks, or Xero, or G Suite, or walk them through the Outlook plugin. For this particular client, the QuickBooks integration was what they needed help with.

A custom invoice based on a sample the client had sent was also created. The client also wanted to show their own clients what was already paid for in a previous month, so Steve came up with a workaround that involved adding a credit to the current invoice to show that a part of it had already been paid in advance.

Steve also helped them add a custom field with a project picker to their invoice template so they could quickly and easily tie an invoice back to the proper project.

WORKetc Invoice Samples

Easy Data Migration

“Usually when I start with a QuickStart client I like to be up front,” Steve says. “I ask what systems they are currently using and what data they need to bring over to WORKetc. Do they need to bring in projects, support tickets, contacts?”

According to Steve, contacts are generally the easiest type of data to import into WORKetc. They’re the most common type of data import that the team handles. Coming in at a close second are project imports.

A data import, no matter how complex it is, is just one of the things we regularly take care of for our QuickStart clients. Other companies charge a fortune for doing this kind of work; in QuickStart it’s just all part of the package.

“If the client has a really easy CSV file to work with and they have clean data, I’ll usually just do it using the contact import tool,” Steve says.

“This is the quickest way to do it. I’ve actually created a sample CSV file that has all the required columns in it as part of QuickStart. Client data imports done using that file usually go fast because the data they send over is in the perfect format.

“For more complex imports, which would be pretty much anything aside from contacts and products, I send those over to Justine. He can import the client’s data by mapping each of the client’s required data fields.”

Project imports are much more complex compared to contact imports due to the larger amounts of data associated with a given project. Be that as it may, moving project data from one system into WORKetc is just part of the “heavy lifting” that WORKetc product specialists do in QuickStart.

“We can basically import entire projects,” says Steve. “The assignee, the start and end dates, what type of billing, and more. When you add in tasks, for example, they’ll show up on the Gantt chart and everything. We can really import anything. It’s very flexible that way.

“A data import, no matter how complex it is, is just one of the things we regularly take care of for our QuickStart clients. Other companies charge a fortune for doing this kind of work; in QuickStart it’s just all part of the package.”

Processes Tailored to YOUR Needs

A CRM will live or die by the data it contains. With the data import services included in the WORKetc QuickStart Onboarding program, you can be sure that your data is brought into WORKetc by experienced product specialists.

Not only that, you also get workflows and processes custom-built to be as efficient and streamlined as possible according to your business’ unique needs. WORKetc product specialists actually take the time to get to know your business instead of just passing out generic, industry-agnostic “best practice” solutions.

That’s what Ivan Collins, P.E., and his team found when Accident Reconstruction Analysis signed up for the QuickStart Onboarding Program:

The response time and the attention that we get from WORKetc staff, especially Steve, is outstanding. WORKetc does what was sold to us and, importantly, what we need.

Finally, all of these personalized services cost you practically $0; 100 percent of the program’s cost is offset against future WORKetc subscriptions.

Register here to find out how QuickStart is made for you.

*Client name and identifying details have been changed to protect privacy.
1 Shares
See all

Featured Posts

New Gmail is Coming For Everyone. What You Need to Know.

Google’s new Gmail redesign packs plenty of productivity-focused features. If I were to describe Gmail’s new design in one word, it would be “divisive”. Some users have praised the clean new interface, while others have condemned the exact same thing for wasting too much screen space. Part of the pushback comes down to a simple […]

One Small Change. 22 Extra Days Per Year.

HOCOA San Diego reclaimed up to a month’s worth of extra work days with WORKetc CRM. Any project manager worth his or her salt knows that communication is key to a successful project. And in today’s world, “communication” usually means email. HOCOA San Diego has built a name for itself as something of a concierge […]

How WORKetc is Helping This Small Business Help Other Businesses Grow

Staircase based on the number sequence introduced by the man Filius Bonacci is named for. Hiring a consultant used to be prohibitively expensive. Unless you were running a multi-million-dollar company yourself, chances are you wouldn’t have pockets deep enough to engage the services of a then-typical consulting firm. But with technology helping small businesses grow […]

4 Tips for Maximum Timetracking Efficiency with WORKetc

Ditch the hourglass; maximize your timetracking efficiency with WORKetc CRM. Timetracking used to be a pretty painful affair, and I admit: I used to hate doing it. I remember this really old timetracker that I used well over a decade ago. All it could do was create a text file of everything I entered into […]

The Secret to Keeping Remote Workers Connected Using One App

From time tracking to collaborations, here’s how WORKetc helps you manage your remote teams. According to the latest State of the Remote Job Marketplace report by remote jobs search site Flexjobs, one thing is clear: The traditional office is dying; the future of business is remote. The report found that 43% of U.S. workers now […]

How To Handle 4X the Support Calls with One Simple Change

IT firm tekRESCUE keeps IT support at “a manageable level of insanity” with WORKetc. IT can be a messy business. Just ask Randy Bryan, the founder of San Marcos, Texas-based IT firm tekRESCUE. “There are a lot of emergencies; always a lot of unknowns,” he told us last year, “A lot of messiness comes out […]