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 )
Bradley bmw rental chicago .. Lockport Chicago limo O’HareAre you a database professional? Do you work with a... Read More
Fortunately one of the most common reasons cited for the... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
What is Software?Software is a set of instruction written to... Read More
For those who are unclear on the differences between the... Read More
If you have been using the Internet for any amount... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
Mike Dunville* had a decision to make. As the new... Read More
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
TikiWiki is open source software - it is written in... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
When you buy a computer, it most likely comes with... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
The stakes are high when considering security, privacy, and savings,... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
Looking at all the ads which promise to get rid... Read More
Microsoft Great Plains is one of the Microsoft Business Solutions... Read More
It's no secret that software companies operate in a very... Read More
Our hosted solution allow you to run your own search... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
prom limo McHenry ..Are you a database professional? Do you work with a... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
When Windows fails to boot it is normally caused by... Read More
Program Flow is what you think it is. How the... Read More
Assertion facility is added in J2SE 1.4. In order to... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
All your software is stored on a hard-drive. But how... Read More
While Adobe is the most known maker of PDF tools,... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
We would like first emphasize the change in the paradigm.... Read More
Not every software testing project can or should be automated.... Read More
Once a business idea is selected, it is highly recommended... Read More
The major reason I recommend getting your hands on real... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
If you have Microsoft Great Plains and support it for... Read More
Now there are Three Steps To Heaven Just listen and... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
XML parser is a software module to read documents and... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
Software |