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 Business Solutions Small Business Manager is Great Plains Dexterity... Read More
Which Type of Shop Can Rely On A Home Built... Read More
After almost two decades of existence, Quark has become the... Read More
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
There are several kinds of software piracy. The bottom line... Read More
Microsoft Business Solutions main middle market ERP application - Microsoft... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More
Mike Dunville* had a decision to make. As the new... Read More
Spyware and malware are large problems for Internet users today... Read More
New post-recession era has new features, which didn't exist in... Read More
While several preventive maintenance software manufacturers offer free trials for... Read More
IntroductionDuring the early years of our modern computer era, very... Read More
User interfaces and accessibility are some of the most important... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
I have yet to see a business that, sometimes in... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
Are you a database professional? Do you work with a... Read More
While Adobe is the most known maker of PDF tools,... Read More
Almost all new and major brand of PCs come with... Read More
While I was preparing some personal background information for a... Read More
If you have been using the Internet for any amount... Read More
Although statistics often is blamed for various deadly sins --... Read More
Whether you have used Microsoft Word for years, have just... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
Let's say that you have a software project that's under... Read More
Microsoft Word is one of the most popular office applications... Read More
Spyware is like the new technological nuclear weapon on the... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
Well, even if the combination might look very unusual, we... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
Current Microsoft Business Solutions Great Plains has more that 10... Read More
When it comes to running an office, the SOHO entrepreneur... Read More
Microsoft Business Solutions ? Great Plains is designed to meet... Read More
If you copy something from a Web site or elsewhere...... Read More
There are certain pluses and minuses in both cases and... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
Did you ever want to erase everything on your computer?... Read More
If there still are few unprotected computers left, I haven't... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Looks like Microsoft Great Plains becomes more... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
The research in the field of Natural Language Processing usually... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Anti-virus software is used to find, remove or fix files... Read More
The vast majority of us will have, at some point,... Read More
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
Program Flow is what you think it is. How the... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
#5 All your hardware components like Printers, PCs etc come... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
How do you run a program on a remote server... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
This article will not attempt to advocate the use of... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Research bears that less than 70 percent of development projects... Read More
No matter how much you enjoy your favorite screensavers, sometimes... Read More
Software |