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 )
shuttle from Midway Glen Ellyn ..Not every software testing project can or should be automated.... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
While I was preparing some personal background information for a... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
Whether you need to close a sale, gather end-user feedback,... Read More
During the years of our consulting practice, which comes back... Read More
Almost all new and major brand of PCs come with... Read More
Remember old good days when your company probably had Great... Read More
Microsoft Great Plains may be recommended for international freight forwarding... Read More
How would you like to prevent spyware and adware from... Read More
The world of small business accounting software can be a... Read More
Microsoft Great Plains and Microsoft CRM become more and more... Read More
Find out why Spyware Removal from computers is important and... Read More
1. With mapping software you can create a report that... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
You might think you don't need a firewall... Read More
We don't think about mainframe software pricing anymore, we just... Read More
No matter how much you enjoy your favorite screensavers, sometimes... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
SyncUp, a file synchronizer is designed to assist the home... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
shuttle from O'Hare North Chicago ..This article will not attempt to advocate the use of... Read More
If your company has regional and worldwide operations, you might... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
When you first think about multicurrency ? you probably have... Read More
Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More
Spyware is like the new technological nuclear weapon on the... Read More
Google Inc. has launched a new software package that allows... Read More
Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More
We all already got used to computer monitoring both at... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
When reading an article where some term is used often,... Read More
I've been active in the Cisco Certification track for four... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
Ok... Where to start?Well, I guess I will start at... Read More
Domino server is a buffer between the operation system and... Read More
Software development is a risky business.Many software developers are barely... Read More
When you own a small business, time is money. And... Read More
Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
The most important things you can do for your computer... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
Is your PC is slow and wimpy? Then you need... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
Software |