Dynamics GP Consultant Newsflash: Importing into Great Plains


by Andrew Karasev - Date: 2009-02-01 - Word Count: 388 Share This!

Dynamics GP has multiple data import and export options andin this small publication we would like to give you initial GP integrationhighlights:

 

1.      Dynamics GP Integration Manager.  This tool is really great and you can setupthe integration simply by reading IM user manual.  It integrates text files: CSV, Tab andspecial character delimited.  Also, youcan get advantage of more flexible ODBC data sources integration, where you candeploy such ODBC compliant constructions as SQL Views, includingcross-platform: Oracle, Lotus Notes, Pervasive SQL, Ctree, Microsoft Access,Excel, PHP mySQL (including bridges to Linux or Unix) to give you the idea.  Plus, IM allows you to alter integrationlogic in VBA scripts: before integration, before document commit, and otherexecution points.  You may say, that itis all great, the only problem for you is ERP implementation and support budget(especially now in 2009, when we are supposed to be in deep recession) -Integration Manager doesn't come free with GP purchase (however Dynamics GPBusiness Ready license gives you, at least now the IM conversion license - thisis temporary license, assuming that you need few month to conversion legacyaccounting and MRP data to Dynamics GP Great Plains)

 

2.      Dynamics GP Macros.  This technique is a bit creative and notnecessary known to every Dynamics GP programmer or consultant.  Macros work even if you have add-ons, orthird party Dynamics GP ISV partners customizations.  The idea of macro deployment is simple andstraightforward: open the window of the object to be integrated (customermaintenance for instance) and start recording macro inTools->Macro->Record.  Entermanually two new customers and then stop playing macro.  Look at the macro file, open Excel file withyour customers (coming from legacy system: PeachTree, MYOB, QuickBooks, LotusNotes Domino) and add macro commands as Excel columns (in between your customerrelated fields).  Then save your Excelfile in text format and give the new text file macro extension.  Now you are ready to play macro.  Macro playing requires computer sessiondedication - do not try to switch to another application while macro is inprogress - simply take lunch or cup of coffee

 

3.      eConnect programming.  If you are on Dynamics GP 10.0 or 9.0, and ifyou classify yourself as Microsoft Visual Studio C# or VB.Net programmer withgood skills in SQL and XML, then you can program integration on your own.  eConnect is especially great tool forecommerce programmer, who needs to expose Dynamics GP as back end ERP forecommerce application

Source: Free Articles from ArticlesFactory.com


Related Tags: consultant, great, into, plains, dynamics, gp, importing, newsflash

Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com 1-866-528-0577, http://www.albaspectrum.com.  Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta.  Information portal: http://www.pegasplanet.com  We serve you USA and Canada nationwide from our Dynamics GP call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England.  International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Central America  Your Article Search Directory : Find in Articles

© The article above is copyrighted by it's author. You're allowed to distribute this work according to the Creative Commons Attribution-NoDerivs license.
 

Recent articles in this category:



Most viewed articles in this category: