![]() | |
![]() | |
![]() |
Software Information |
|
![]() |
Microsoft CRM: Data Conversion - Import from Act!
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; ? 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 ? 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(); File.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 )
MORE RESOURCES: Why These 15 Software Stocks Are Skyrocketing So Far in 2025 Insider Monkey What OpenAI’s Sales Automation Software Can Do—and What It Can’t The Information DMV rolls out new 605Drive software Dakota News Now Replit and Anthropic’s AI just helped Zillow build production software—without a single engineer VentureBeat Chip design software maker Cadence forecasts annual profit below estimate, shares down - Reuters.com DARPA Gets Word Out on Secure Software for Military National Defense Magazine FTC settlement requires disconnection of hardware from all no longer supported software Data Protection Report Iodine Software Launches Appeals Management Workspace Supporting Denials Management, Alongside GenAI Platform Enhancements Business Wire Telos Alliance Announces Axia Quasar V3.2 Software Update Sports Video Group The Impending Disruption That Will Transform IT and the Workforce: “Service-as-Software” Logistics Viewpoints Iodine Software Launches Appeals Management Workspace - HIT Consultant Commissioners approve new software for Lebanon Justice Court lebanonlocalnews.com Regula Software Now Supports the Latest Standard for Biometric Passport Verification - Business Wire Terma to supply C2 software for Slovakia’s Barak MX Airforce Technology CobbleStone Software Offers CobbleStone Contract Insight® CLM Solution Via Texas DIR Contract PR Web Raynault VFX, Stability AI Join the Academy Software Foundation Animation World Network FSF Opens Nominations For Free Software Awards iProgrammer 10 Hot Software Stocks with High Upside Potential Insider Monkey ECI Software Solutions Appoints Hildebrand CIO Quality Magazine Regula Software prend désormais en charge la dernière norme de vérification biométrique des passeports The Hastings Tribune Lucid Dream Software details benefits of new consumables platform Label & Narrow Web Researchers approach industry for commercial software dashboard to link legacy databases for decision-making Military & Aerospace Electronics Regula Software unterstützt jetzt den neuesten Standard zur biometrischen Reisepassprüfung The Hastings Tribune Regula Software unterstützt jetzt den neuesten Standard zur biometrischen Reisepassprüfung The Bakersfield Californian Blaize Holdings: Why I Am Betting On This AI Hardware And Software Small Cap (NASDAQ:BZAI) Seeking Alpha ezPaycheck Payroll Software Eliminates the Daunting Task of Tax Calculations for Business Owners Longview News-Journal Accenture: SDV requires transformational software mindset Automotive World France’s Cycloid gets €5M to promote efficient software delivery along with digital sobriety Silicon Canals Robot Software Market Hits New High | Major Giants Universal Robots, Yaskawa Motoman, Siemens openPR Electronic Signature Software Market Is Booming Across the Globe:: DocuSign, Adobe Sign, HelloSign openPR AIDA64 now supports Radeon RX 9070 series, software drops support for Windows 95/98 - VideoCardz.com Creator Of New Open-Source Game Boy Disagrees That FPGA Is Superior To Software Emulation Time Extension 2025.2.6 Official Tesla Release Notes - Software Updates Not a Tesla App Outside expands its outdoors media empire with acquisition of booking software developer The Colorado Sun PAC Programming Software Market Growth Outlook (2023-2032): Emerging Technologies Driving Innovation openPR |
![]() |
![]() |
![]() |
RELATED ARTICLES
Microsoft CRM Integration with IBM Lotus Notes Domino - Machinery Dealership Example IBM Lotus Notes with Domino email server is traditional document workflow management solution for large corporate business, where you need audit trail on approval cycle and decision making. Microsoft Business Solutions CRM is very cost efficient solution to automate sales process. Corel WordPerfect 7 Macro Programming Example Case study:A secretary using Corel WordPerfect 7 is often required to carry out calculations and insert the values into invoices or other documents.She does this by entering calculations into either a real calculator and transcribing the answer, or the Microsoft calculator and copying then pasting the result into the document. Great Plains Dexterity: Customizations & Source Code Programming Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on GPS proprietary programming language and development environment - Great Plains Dexterity. When Microsoft bought Great Plains Software, Dynamics was renamed into Microsoft Great Plains, but Dexterity is still the architectural base, there were trends to move MS Great Plains to . Great Plains DOS Support - Notes for Consultant Great Plains Accounting, accounting package for mid-size and small companies was in its peak of popularity back in earlier 1990th. It first had DOS interface, later on migrated to classic Windows version (remember earlier event driven Windows and its strange and at the same time revolutionary programming model - guys who remember Borland C++ and Microsoft C++). Beware of The Pirated Software E-Mail Scams! You have gotten those E_Mails buy software at deep discounts. It is very tempting to save 85% to 95% on your favorite Software Titles. What is Fleet Maintenance Software? Simply put, fleet maintenance allows companies to monitor and maintain their fleets of commercial vehicles more efficiently.Fleet maintenance requires a great deal of organization and management skills. Huddle Up; Groupware on Three It could just be me, but my experiences with document collaboration remind me of a football game. It sounds crazy, I know, but working with a group and sending emails off to other members of the group caries with it that familiar uneasy sensation of Thanksgiving Day football games, where I often play quarterback and just as often wonder whether members of my family will catch the pass, and if they do, what they will do with the ball. Put Some Pizazz in Your Software Arsenal The software giants don't do everything and don't always produce the result that we want. At least if you're like me, and you're not where you would like to be (profitwise). How To Identify, Cure and Prevent Spyware/Adware Infections Just when you thought you were Web savvy, one more privacy, security, and functionality issue crops up - spyware. Installed on your computer without your consent, spyware software monitors or controls your computer use. Microsoft Great Plains Oil & Gas - Implementation & Customization Highlights Microsoft Great Plains serves the wide spectrum of horizontal markets. Great Plains could be considered as ERP platform, which you could expand with third party modules or advance with your own in-house custom functionality. Keeping Track One of the things we can be as certain of as death and taxesis that in every meeting at least one person will hand out adocument for comments and discussion.But think of the huge workload this gives rise to for theauthor. Great Plains Dexterity Development: FAQ Microsoft Business Solutions Great Plains is Dexterity-written application and currently we see increased interest for Great Plains customers to do in-house Dexterity development and customization. Dexterity itself is written on C programming language and its initial architecture was based on the Graphical and Database platform independence, which C programming language was believed to provide. Microsoft Great Plains Customization and Development - Overview for Programmer When Great Plains Software was designing and developing Great Plains Dynamics/Dynamics CS+/eEnterprise - it placed several fundamental principles into the system1. Computer platform independence. Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing Microsoft Great Plains is now targeting large and midsize businesses and being matured ERP has advanced, but still very simple in use modules and features: Lockbox Processing for Accounts Receivables, Customer/Vendor Consolidation, Multicurrency etc. We'll try to cover these features in the series of small articles to help decision maker and end user understand the feature and how does it work to make a decision to purchase additional nice modules. Internet Faxing Service Review The Internet is reshaping every form of communications medium, and faxing is no exception. The latest twist: Internet faxing services that let you send messages to any fax machine from any Web browser or email, and others that give you a "personal fax phone number," then forward any documents sent there to your e-mail inbox. SyncUp - A File/Folder Synchronizer For Windows SyncUp, a file synchronizer is designed to assist the home and advanced users. The product has a simple and familiar windows explorer type interface for easy file handling. Groupware and Version History: Collaboration Series #1 This article is the first of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware. How to Evaluate Staffing Software If you are in the market for new staffing software, I suspect that one of the most daunting of tasks will be to sift through the many vendors that are now servicing the staffing industry.You will find many very qualified companies with good staffing software products. Great Plains Dexterity History and Programming Overview As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into Microsoft Great Plains and Microsoft Business Solutions is in process of merging all its accounting applications: Great Plains, Solomon, Navision and Axapta into somewhat granular: Microsoft Financials, Microsoft HR, Microsoft Distributions, Microsoft Project Accounting, etc. So the original design of Great Plains should be deemphasized. Choose your Java Wisely Java has come along a long way. Many would agree with this. ![]() |
home | site map |
© 2006 |