Personal tools

Contact Us 24/7 > 1 866.SIX FEET

Skip to content. | Skip to navigation

Home > Blog > Daylite to SugarCRM: 5 Migration Tips


Daylite to SugarCRM: 5 Migration Tips

written by Calvin Hendryx-Parker on Thursday August 2, 2012

Daylite to SugarCRMOver the last couple weeks I have slowly gotten us up and running on SugarCRM after having spent many years on Marketcircle’s Daylite CRM product for Mac. Generally, I had been very happy with Daylite, but there was quite a lag in development and certain features in Daylite weren’t keeping up or working with the newer Mac technologies such as support for CalDAV calendars.

An even bigger problem was raising its head as well. Using Daylite in online mode worked most of the time, as long as you didn’t switch networks. Our whole team uses Macbooks Pros in their day-to-day operation and sometimes they plug into a wired network, then they go to meetings and are on wireless and then they go home to their own networks. Each day a user will switch networks many times and Daylite wasn’t happy with that: it would crash and not sync back up correctly. We had been using a workaround for a bit by putting the clients in off-line mode, but that started showing some issues as well and didn’t seem to sync as expected, keeping some folks out of the loop as data was sitting locally, but not on the server from time to time.

It was time to move, so we looked at SugarCRM and I found that it was pretty easy to migrate years of Contacts, Accounts and Opportunities into the new platform. If you are using Daylite and looking for a way out, here are some quick tips to help get you going.

1. Make sure everything gets linked back to Organizations in Daylite

SugarCRM and many other CRMs out there rely heavily on Accounts (or Organizations in Daylite speak) to link activity, but Daylite never seemed to stress this behavior. Before exporting the data (more on how later), I had to go into all Contacts and Opportunities and ensure that they were linked to some Default Organization. The Daylite Server tools even help you out a bit by giving you a button to link all Contact’s Activity and Tasks back to the organization.

2. Set Forecasted Close Dates and Totals in Daylite

SugarCRM has a couple required fields out-of-the-box for an Opportunity. You will need to provide an "Expected Close Date" and the "Opportunity Amount", which map to Daylite’s "Forecasted Close Date" and the "Estimate Total". You have a couple options here if you don’t normally use those fields. We had mixed usage so I filled in the dates in Daylite for those that were missing the "Forecasted Close Date". For the "Total", I ended up just setting them all to during the import, but if you do export them, be careful of the comma thousands separators that it will include and not delimit them with quotes. It will throw off the import into SugarCRM.

3. Create your Employee/User accounts in SugarCRM to match Daylite

Take a look at the users in your Daylite CRM and create matching users for all of your Daylite users, even the disabled ones. Make sure you match the usernames of your Daylite users with the SugarCRM users. We will use them later to make sure all of the created by and ownerships are transferred seamlessly.SugarCRM Export Users

Once you have created all of your users, export them to CSV so we can map them in Excel to the "creator" and "owner" fields in your other exports. SugarCRM will give you all of the user’s info including their unique identifier.

4. Import your Organizations first

Everything in SugarCRM relies on them being present and when the other data is imported, it will automatically make the links back to the Account for you. While you are at it, you probably will want to search for duplicates before you do the export of the data and fix up all of those links.

With your data all cleaned up for export, you can do it easily by making a CSV export of the Daylite data. This is pretty much the same process for all of your Daylite data. You will go to the Organizations section of Daylite and select the List view for the results screen.

Daylite Results Pane View Options

Once you have that view selected, you need to add all of the columns that are expected by SugarCRM. You can get a reference CSV file by going to the import screen in SugarCRM and download the template file. Use it as a guide to add your columns to the Daylite export.

Daylite List Column Selector

With the column selector open, drag the columns over to the left and I put them in order with the SugarCRM template to make things easier.

Daylite Choose Visible Columns

Now make sure you select all of your rows and then from the File menu, you can choose Export... > Export Visible Columns and Selected Rows to File.

5. Import the rest of your data

Now that you have Users/Employees and Accounts imported, you can now import just about all the rest of the data and get the proper links between the objects in SugarCRM. I started with the Contacts and moved on to Opportunities from there just following the same pattern of exporting CVS files from Daylite for each kind of thing and then mapping them to the same types of objects in SugarCRM.

Now that we are getting settled into our new CRM home, I’ll post some of our experiences using it and what add-ons we are using with it as well. If you have specific questions about migrating to SugarCRM, don't hesitate to drop me a line.

Posted by John on Aug 13, 2012 01:47 PM
Great article! A couple of quick questions though as our company is just starting to implement Daylight 4 and I would like to know your thoughts on Sugar v. Daylight. Do you feel that the issues that you have run up against have been resolved with the latest release? What is your overall opinion of Sugar v. Daylight? Thanks in advance, John
Posted by Daniel on Mar 07, 2013 10:13 AM
Great to see another Plone company using SugarCRM (as we are), have you found any good ways of linking them up?
Posted by Jim Bartek on Mar 07, 2013 11:26 AM
Hi Daniel, We have done custom CRM to Plone integrations for clients. There is also a new SugarCRM connector project in the collective that was released this year. We have not used it but will be evaluating it soon. 11:20 Best, Jim
Add comment

You can add a comment by filling out the form below. Plain text formatting.


Next Steps

Select a type of support:

Contact our sales team

First name:
Last name:
Phone Number:
Fight spam:
What is + ?
Call Us 1 866.SIX FEET