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 )
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
This short paper will expand on two key reasons to... Read More
Are you a database professional? Do you work with a... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
The cornerstone of successful automated office systems is the ability... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
This article will not attempt to advocate the use of... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
Is your PC is slow and wimpy? Then you need... Read More
When you double-click a layer in the Layer Palette, you... Read More
Sometimes your PC will start acting strange for no apparent... Read More
Looking at all the ads which promise to get rid... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
Research bears that less than 70 percent of development projects... Read More
Microsoft Business Solutions ? Great Plains is designed to meet... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
New post-recession era has new features, which didn't exist in... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
The Internet is reshaping every form of communications medium, and... Read More
I provide, here clear explanations and a count of function... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
A UNIX Shell is in simplest terms, a command line... Read More
If you have Microsoft Great Plains and support it for... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
We all already got used to computer monitoring both at... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Since its release in 1987, QuarkXpress had made an immediate... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
So, why should you use any O/R mapping tool? I... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
Software Engineering is the Systematic Approach for analysis design implementation... Read More
If you are in the market for new staffing software,... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
XML parser is a software module to read documents and... Read More
We would like first emphasize the change in the paradigm.... Read More
Not all of us have the luxury of working both... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
All your software is stored on a hard-drive. But how... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
Homeland security, airport security, Internet security â?" these days weâ??re... Read More
If you have Microsoft Great Plains as main accounting and... Read More
Usually workflow & messaging is realized in CRM and then... Read More
Spyware is like the new technological nuclear weapon on the... Read More
1. What determines the software price? Is it Per Seat... Read More
Now is the time to look at an alternative to... Read More
In this short FAQ style article we would like to... Read More
Adobe Photoshop is one of the world's leading graphics editing... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
What is Software?Software is a set of instruction written to... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
Remember back in the days where screensavers were the coolest... Read More
Pirated software is on the increase and now accounts for... Read More
The purpose of one of our projects was MS Exchange... Read More
As seeing large number of implementations ? in our case... Read More
This article illustrates the best practices to improve the performance... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
Software |