Best Software Act! is very popular CRM for small and mid-size organization. This system attracts business owner by its low price, plus system is very easy to use. However if your business is growing you should reach the moment to implement more advanced CRM solution. Natural question is ? how do we convert the data from Act! to new CRM solution and the mapping of your objects for conversion. You would probably like to avoid operator data entry with potential numerous errors and mistypes. Assuming that you are IT specialist, we'll give you technical side of Act to MS CRM data migration:
? First you need to download Act! SDK from Best Software website
? Install Act! SDK on the computer, where you plan to do programming
? We'll use asynchronous data export/import model, this means that we'll design the system, containing two parts: export into XML and this XML file import into the CRM
? Lets code Act! data export application, we'll use C# to address Act Framework classes, we'll need these libraries:
using Act.Framework;
using Act.Framework.Activities;
using Act.Framework.Companies;
using Act.Framework.ComponentModel;
using Act.Framework.Contacts;
using Act.Framework.Database;
using Act.Framework.Groups;
using Act.Framework.Histories;
using Act.Framework.Lookups;
using Act.Framework.MutableEntities;
using Act.Framework.Notes;
using Act.Framework.Opportunities;
using Act.Framework.Users;
using Act.Shared.Collections;
? To connect to Act! database:
ActFramework framework = new ActFramework();
framework.LogOn("Act Username", "password", "SERVER", "Database");
? Now we need Act field names to map them with the fields in the MS CRM:
private void ShowContactsFieldsDescriptions(ActFramework framework) {
ContactFieldDescriptor[] cFields = framework.Contacts.GetContactFieldDescriptors();
ContactFieldDescriptor cField;
for(int x = 0; x < cFields.Length; x++)
{
cField = cFields[x];
Console.WriteLine("Table Name: {0}", cField.TableName);
Console.WriteLine("Column Name: {0}", cField.ColumnName);
Console.WriteLine("Display Name: {0}", cField.DisplayName);
Console.WriteLine("ACT Field Type: {0}", cField.ACTFieldType);
Console.WriteLine("");
}
}
? Let's get contact list and create the file for import instructions to MS CRM:
ContactList cList = framework.Contacts.GetContacts(null);
FileInfo t = new FileInfo("Contacts.xml");
StreamWriter stw = t.CreateText();
? Now we form export data:
for (int i = 0; i < cList.Count; i++) {
string strContactXml = "";
ContactFieldDescriptor cField;
Object oValue;
// First Name
cField = framework.Contacts.GetContactFieldDescriptor("TBL_CONTACT.FIRSTNAME");
oValue = cField.GetValue(cList[i]);
if (oValue != null && !(oValue.ToString().Trim().Equals("")))
strContactXml += "[CDATA[" + oValue.ToString() + "]]";
// Last Name
cField = framework.Contacts.GetContactFieldDescriptor("TBL_CONTACT.LASTNAME");
oValue = cField.GetValue(cList[i]);
if (oValue != null && !(oValue.ToString().Trim().Equals("")))
strContactXml += "[CDATA[" + oValue.ToString() + "]]";
else
strContactXml += "" + "N/A" + "";
// Salutation
cField = framework.Contacts.GetContactFieldDescriptor("TBL_CONTACT.SALUTATION");
oValue = cField.GetValue(cList[i]);
if (oValue != null && !(oValue.ToString().Trim().Equals("")))
strContactXml += "[CDATA[" + oValue.ToString() + "]]";
// Job Title
cField = framework.Contacts.GetContactFieldDescriptor("TBL_CONTACT.JOBTITLE");
oValue = cField.GetValue(cList[i]);
if (oValue != null && !(oValue.ToString().Trim().Equals("")))
strContactXml += "[CDATA[" + Regex.Replace(oValue.ToString(), " ", "
") + "]]";
? This is only portion of the data, that could be transferred into CRM, the whole list of fields is too long for small article, but your could design the whole list of desired fields. Please, pay special attention to replace
HTML tag ? this is required for text data transfer into CRM
? Next is import application creation. We will not describe here connection to MS CRM details ? please read Microsoft CRM SDK if you need this examples. We'll concentrate on the nature of the import.
The XML export file should look like this:
[CDATA[John]][CDATA[Smith]][CDATA[John]][CDATA[1234 W. Big River]][CDATA[Chicago]][CDATA[IL]][CDATA[123456]][CDATA[Toy Corporation]]{4F1849C3-9184-48B5-BB09-078ED7AB2DAD}
? Reading, parsing and MS CRM object creation look is relatively simple:
Microsoft.Crm.Platform.Proxy.BizUser bizUser = new Microsoft.Crm.Platform.Proxy.BizUser();
ICredentials credentials = new NetworkCredential(crmUsername, crmPassword, crmDomain);
bizUser.Url = crmDir + "BizUser.srf";
bizUser.Credentials = credentials;
Microsoft.Crm.Platform.Proxy.CUserAuth userAuth = bizUser.WhoAmI();
// CRMContact proxy object
Microsoft.Crm.Platform.Proxy.CRMContact contact = new Microsoft.Crm.Platform.Proxy.CRMContact ();
contact.Credentials = credentials;
contact.Url = crmDir + "CRMContact.srf";
CorrectXML("Contacts.xml", userAuth.UserId);
StreamReader reader = File.OpenText("Contacts.xml");
string input = null;
while ((input = reader.ReadLine()) != null)
{
string strContactId = contact.Create(userAuth, input);
Console.WriteLine("Contact {0} is created", strContactId);
log.Debug("Contact " + strContactId + " is created");
}
? Just consider in more details CorrectXML function ? it places OwnerId into XML contact tree:
private void CorrectXML(string fileName, string userId) {
File.Move(fileName, fileName + ".old");
StreamReader reader = File.OpenText(fileName + ".old");
FileInfo t = new FileInfo(fileName);
StreamWriter writer = t.CreateText();
string input = null;
while ((input = reader.ReadLine()) != null)
{
input = Regex.Replace(input, "{_REPLACE_ME_}", userId);
writer.WriteLine(input);
}
reader.Close();
writer.Close();
Fi le.Delete(fileName + ".old");
}
? Finally, we are launching export, import, opening MS CRM and looking at the contact list, transferred from Act!
? Separate task would be Sales data from Act!, Notes etc. ? we plan to describe them in the future articles
Good luck with integration! If you want us to do the job - give us a call 1-630-961-5918 or 1-866-528-0577! help@albaspectrum.com
Andrew Karasev is Lead Software Developer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, Houston, Atlanta, Phoenix, New York, Los Angeles, San Francisco, San Diego, Miami, Denver, UK, Australia, Canada, Europe and having locations in multiple states and internationally ( http://www.albaspectrum.com )
![]() |
|
![]() |
|
![]() |
|
![]() |
Have you ever noticed that when you look at your... Read More
Bar charts, bar graphs, and any other chart or graph... Read More
Manufacturing in the USA is far away down from mid... Read More
Once upon a time not so long ago, there was... Read More
If you have been using the Internet for any amount... Read More
Ok... Where to start?Well, I guess I will start at... Read More
In linux, one of great commands for finding out information... Read More
People often ask me: What image file formats will Photoshop... Read More
Now that spyware is the single most dangerous threat to... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
With thousands of web pages added to the Net every... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
New post-recession era has new features, which didn't exist in... Read More
Remember back in the days where screensavers were the coolest... Read More
I suggest that you do not spend a lot of... Read More
With any good luck and a good amount of hard... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Software Engineering is the Systematic Approach for analysis design implementation... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
After seeing many people complain about their weak Internet security... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
It could just be me, but my experiences with document... Read More
Finally, you have some time to personalize your desktop with... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
Fortunately one of the most common reasons cited for the... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Intro This concise article will tell you in plain English... Read More
Did you ever want to erase everything on your computer?... Read More
There are certain pluses and minuses in both cases and... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
In our small article we'll consider Microsoft Business Solutions Great... Read More
Manufacturing in the USA is far away down from mid... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
With thousands of web pages added to the Net every... Read More
The stakes are high when considering security, privacy, and savings,... Read More
In the Clinton era the status quo was simple: you... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
This is a short article, written in question/answer/FAQ style to... Read More
After seeing many people complain about their weak Internet security... Read More
Words we choose to describe things and phenomena often show... Read More
If you company is small or mid-size special products or... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More
Let's first look at your ERP system selection (without Retail... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
First we had the original Google search that evolved into... Read More
Usually workflow & messaging is realized in CRM and then... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Around the same time Microsoft made its move with .Net... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
Spyware, what it is and what it does. Basically, spyware... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
Enabling Chinese input is quick and easy, there are only... Read More
Are you one of those people that keeps track of... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
Software |