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: V-22 Evolving into 'Software-Defined' Platform National Defense Magazine 30 Largest Software Companies in the World by Market Cap Yahoo Finance 2024.14.3 Official Tesla Release Notes - Software Updates Not a Tesla App Software support chap survived breaking his customer The Register Rocket Software Buys OpenText's App Modernization & Connectivity Business for $2.3B; Milan Shetti Quoted GovCon Wire Durst Announces 1,000th Installation Of Durst Workflow Software | Label and Narrow Web Label & Narrow Web Paycom Software (PAYC) Q1 2024 Earnings Call Transcript The Motley Fool Exclusive: IBM brings its AI, data and automation software to AWS Marketplace in 92 countries VentureBeat Auto Dealership CRM Software: Global Market Analysis and Forecast (2018-2033) by Type, Functionality, Application ... GlobeNewswire Guesty, Short-Term Rental Software Provider, Acquires Rentals United Skift Travel News The power of the power pose: How a software CEO became a better leader Business Observer Epicor Acquires Smart Software for AI-Powered Inventory Planning - Supply and Demand Chain Executive Epicor Acquires Smart Software for AI-Powered Inventory Planning Supply and Demand Chain Executive Investors in Take-Two Interactive Software (NASDAQ:TTWO) have seen decent returns of 40% over the past five years Yahoo Finance Wyoming Senator Slams DOJ's Take on Non-Custodial Crypto Software, Vows to Protect User Rights – Bitcoin News Bitcoin.com News Update from eSync Alliance accelerates software-defined vehicle roadmap ComputerWeekly.com DeepSea Developments Modularizes the RTL-SDR for Multi-Receiver Software-Defined Radio Projects Hackster.io Using my speech issues to improve voice recognition software ALS News Today Supply Chain Management Software: Build the foundation, deliver the value Logistics Management Top ideas in vertical software with valuations over or below 50th percentile - Baird - Seeking Alpha NVIDIA Buys Software Provider Run:AI Silicon Valley Daily IBM Expands Software Availability to 92 Countries in AWS Marketplace The Globe and Mail Carnival Corporation completes fleetwide software rollout Port Technology International Paycom Software Inc (PAYC) Q1 2024 Earnings Call Transcript Highlights: Robust Growth and Strategic Expansions GuruFocus.com Epicor acquires Smart Software Edge Middle East Boeing Advances US Navy MUM-T Aerial Refueling Software With Digital F/A-18 Super Hornet & MQ-25 Stingray Trial Simple Flying Employee Referral Software Market SWOT Analysis by Leading Key Players: Avature, ERIN Technologies, EIN News Lucid Software Announces Whiteboard Integrations with Google Meet Touchscreen Devices InvestorsObserver IBM expands software availability to 92 nations in AWS Marketplace including India India New England Why April Brought Grief To Software Stocks As IGV Index Tumbles Investor's Business Daily Severe Flaws Disclosed in Brocade SANnav SAN Management Software The Hacker News Epicor swoops in for Smart Software - Enterprise Times Boeing Validates MUM-T Refuelling Software Joint Forces Influencer predicts tough times ahead for techies, says software engineering no longer a guarantee of succ The Economic Times Restaurant software leader Schedulefly simplifies staff scheduling with Median.co's mobile app services InvestorsObserver Tesla's stock leaps on reports of Chinese approval for the company's driving software The Associated Press Tesla Cybertruck gains Off-Road modes, locker-enabling software Motor Authority Generative AI Software Sales Could Soar 6,260%: My Pick for the Best AI Stock to Buy Now (Hint: Not Nvidia) The Motley Fool Veeam Extends #1 Market Share and is the Fastest Growing Top 5 Vendor Year-Over-Year in Data Replication and ... CXOToday.com Romanian-born automation software company UiPath signs former Microsoft, Meta exec Romania-Insider.com 2024.3.25 Official Tesla Release Notes - Software Updates Not a Tesla App Marin Software Launches AI-powered Anomaly Detector to Unlock Growth in Performance Marketing Campaigns Business Wire Swiss-designed software steers kamikaze drones - SWI swissinfo.ch SWI swissinfo.ch in English |
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 |