Puntogf Antiques.

Chinese Archaic

Dynamics GP eCommerce Custom Programming Notes

Microsoft Dynamics GP, this Corporate ERP application was previously known as Great Plains Dynamics, eEnteprise (and its predecessor was Great Plains Accounting for DOS, Windows and Mac), is good Accounting and Logistics platform for ecommerce integration.  In this paper we assume that you have self designed in-house made custom ecommerce web application with shopping cart and possible such additional features as credit card payment processing, custom B2B items catalogs or simple B2C ecommerce promotions, and also that your ecommerce website was programmed in .Net with MS SQL Server as DB platform, plus we will make some comments on other ecommerce alternatives, such as Linux/PHP/MySQL or Oracle based solutions with ODBC exposures, as Great Plains Dynamics GP is only available on Microsoft Windows and MS SQL Server platforms.  If our assumption seems too restricting, please review first GP ecommerce Add-ons available on the market as out-of-shelf products, directly available from Dynamics GP ISV ecommerce partners.  Again, here we assume that you already made significant investment into custom ecommerce website software development and you do not see the option to redeploy ecommerce on the base of Dynamics ISV partner ecommerce product.  Let's begin our review:

1. Dynamics GP version and support.  Before we jump into your options, please be sure that these options are available to you as if you are on archaic Great Plains version, ecommerce might be very limited in integration and very expensive in design and support.  In our opinion, you should consider ecommerce custom website integration to Dynamics GP, if your GP is on currently supported versions: Dynamics GP 10.0 and 9.0 (we are writing these lines in October 2009).  The reasoning is also simple - GP eConnect ecommerce programming oriented SDK became matured product in our opinion for Dynamics GP version 9.0.  If you are on older Great Plains versions, such as 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 and if you are on Great Plains on Pervasive SQL 2000/btrieve or Ctree (GP 7.5 and earlier) or Great Plains Accounting for DOS, Windows 9.5, 9.2 and earlier, in our opinion you should begin to move toward Great Plains upgrade up to Dynamics GP 10.0.  Upgrade is not something very simple, it might require additional budget and even software license repurchase (if reenrolling into Dynamics GP annual enhancement program cost is too high), plus upgrade requires Dynamics GP consultant help and assistance, where you also should expect reasonable cost, typically by hours.  The good news might be this - if your archaic GP version requires ecommerce integration on text file level (where you export new customers and invoices from ecommerce in text tab or coma delimited format), then the job of feeding ecommerce data into GP could be done by GP Integration Manager module

2. Dynamics GP ecommerce integration tools.  The first option, that in our opinion you should check out is Dynamics GP Integration Manager.  IM for GP 10.0 has two types of connectors: traditional OLE Server connector (if you are Great Plains consultant, OLE server is what IM was using in older versions: 9.0 and earlier, where you have to initiate integration in the context of targeted company) , and second type is eConnect (here you have to specify company database, windows domain user for econnect credentials, for GP 10.0 you should expect some expected problems, for example SOP Returns are not covered for GP 10.0, however we expect this problem to be patched in the next Dynamics GP version).   IM is not only for Text file integration, in Advanced ODBC Data Sources you can count on SQL Views and call IM integration in quasi real time (every twenty minutes or more often).  Second option is really the one for ecommerce programmers (C#, VB, or other Microsoft .Net compliant programming language, where you should be aware that sample codes are available in VB and C# only).  eConnect has reasonable control over the creation or modification of such master records as GP Customer, Vendor, Address, Employee, Inventory Item, plus it has control over GP so-called work transactions and batches.  If you would like to post GP Sales Order Processing batches (and batches of different origin), please consider add-ons, such as Alba Spectrum Posting Server

3. Dynamics GP ecommerce integration philosophy or architecture.  Here we recommend you to speculate about such questions as which application should be chosen as master to create ecommerce inventory items.  If it is GP, then ecommerce web site should pull items into its catalogs.  If this is GP, then Great Plains should be playing the role of sort of slave and pull and synchronize items, catalogs and price lists.  We placed here this paragraph as the example of possible complication factors

4. Dynamics GP ecommerce integration to non Microsoft platforms.  For Java based, please be sure that you have good understanding of such technologies as IDBC-ODBC bridge or native Java ODBC drivers for Microsoft SQL Server 2008/2005/2000 (whichever is your case).  For Linux PHP popular hosting option, please check with your hosting partner if they allow you connection and serving scripts to your Microsoft Dynamics GP SQL Server database.  For Oracle custom database ecommerce application, please consider either link from Oracle or from Microsoft SQL Server (MS SQL Server Linked Server via Oracle ODBC driver)

5. Limited ecommerce integration support for Dynamics GP 8.0, 7.0 and 7.5.  Our product Alba Spectrum Order Connector (written on the level of MS SQL Server Stored Procedures) supports integration to GP Sales Order Processing: SOP Orders, Invoices, Customers, Addresses.  Again, we would rather recommend you GP version update to 10.0, but if you see problems in this recommendation, please consider Order Connector as the way to go

6. Great Plains Accounting and it compatibility status with ecommerce.  In our opinion GPA is not compatible with real time or quasi real time ecommerce program.  You can experiment with GPA integration module, or try to establish ODBC connection to GPA database via DDF files.  And even if you have reasonable tool  (such as Microsoft Access or MS SQL Server Linked Server) for feeding data into GPA Btrieve tables, we do not recommend this as GPA business logic should be considered as reasonably complex

7. How to get help?  Please, feel free to call us: 1-866-528-0577, outside of USA: 1-630-961-5918 or email us help@albaspectrum.com  We are very technical and real Dynamics GP Dexterity, SAP Business One SDK and Microsoft CRM programming gurus.  We have Great Plains Software Development Factory and could support unlimited Dynamics GP Customization and Programming needs.  Plus we speak English, Chinese, Spanish, Portuguese, Russian, and not only as native speaking sales folks, but as real technical consultants.  If you prefer skype: albaspectrum

About the Author

Andrew Karasev, Alba Spectrum , 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, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP and SAP Business One 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, Russia, Central America: Mexico, Honduras, Costa Rica, San Salvador, Panama, Nicaragua, Guatemala , South America: Chile, Argentina, Paraguay, Peru, Uruguay, Venezuela, Colombia, Ecuador, Bolivia

The Archaic $73.92 The Archaic

Archaic Visions $9.99 Archaic Visions

Entourage of the Archaic $15.6 Entourage of the Archaic

Archaic Abattoir $22.23 Archaic Abattoir

Archaic Volumes $16.45 Archaic Volumes

Archaic Societies $55.25 Archaic Societies

Archaic Smile $11.2 Archaic Smile

Handbook for Chinese Archaic Jade: Evaluation and Appreciation $37.05 No Synopsis Available

Archaic $11.18 Description not provided.

Chinese Archaic Women Bamboo Coasters Mats Set of 6 $9.6 Description:Classic design Women Bamboo Coasters Set is a simple way to protect the surface of your table from heat.Made from natural bamboo material, durable and easy to clean.This set of six Women Coasters come with a bamboo holder. Each coaster has a Chinese painting, very charming and beautiful.Suitable for place your coffee cup, mug, bowl, your cup can sit on neat bamboo coaster - a natural way to protect surfaces from heat.This Women Bamboo Mats Set will also beautify your desk, table, even your home.Great for everyday use or to spice up your Oriental decor.Dimension (Each One): ~9.5(L) x 9.5(W) x 0.4(H)cmTotal Weight: 260gPackage Included:6 x Women Mats1 x Bamboo Holder

Set of 6 Chinese Archaic Belle Bamboo Coasters Cup Mats $9.6 Description:Keep you table's surface safe from stains and heat with this Bamboo Coasters Set.It is made of natural bamboo material, healthy and natural for household.The set with six coasters and a bamboo holder, each coaster has a Chinese painting, very charming and beautiful.Unique design Belle Coasters can be used to placed your hot coffee cups, bowls and mugs.Add a nice touch to your table with this Belle Bamboo Mats Set.Great for everyday use or to spice up your Oriental decor.Ideal gift choice for yourself, friends, or collectors!Each coaster is measures approx. 9.5cm long, 9.5cm wide, and 0.4cm thickness.Total Weight: 256gPackage Included:6 x Bamboo Cup Mats1 x Bamboo Holder

Archaic Volumes [LP] $15.98 Archaic Volumes [LP]

FATSO JETSON: ARCHAIC VOLUMES $10.25 FATSO JETSON: ARCHAIC VOLUMES

BORKNAGAR: ARCHAIC COURSE $11.96 BORKNAGAR: ARCHAIC COURSE

BATTLEFIELDS: ENTOURAGE OF ARCHAIC $5.12 BATTLEFIELDS: ENTOURAGE OF ARCHAIC

Development of the Polis in Archaic Greece $33.56 Development of the Polis in Archaic Greece

EXCRUCIATING THOUGHTS: ARCHAIC $13.79 EXCRUCIATING THOUGHTS: ARCHAIC

DARK TRIBE: ARCHAIC VISIONS $17.59 DARK TRIBE: ARCHAIC VISIONS

An Archaic Bronze Food Vessel $49.99 An Archaic Bronze Food Vessel - Giclee Print

La utopia arcaica / The Archaic Utopia $11.19 La utopia arcaica / The Archaic Utopia

Reading of Primitive & Archaic Poetry: Arranged by $14.71 Reading of Primitive & Archaic Poetry: Arranged by

The Archaic (Hardcover) $235.48 "The Archaic takes as its major reference points C.G. Jung`s classic essay, `Archaic Man` (1930), and Ernesto Grassi`s paper on `Archaic theories of history` (1990). Moving beyond the confines of a Jungian framework to include other methodological approaches, this book explores the concept of the archaic. Defined as meaning `old-fashioned`, `primitive`, `antiquated`, the archaic is, in fact, much more than something very, very old: it is timeless, inasmuch as it is before time itself. Arch , Urgrund, Ungrund, `primordial darkness`, `eternal nothing` are names for something essentially nameless, yet whose presence we nevertheless intuit. This book focuses on the reception of myth in the tradition of German Idealism or Romanticism (Creuzer, Schelling, Nietzsche), which not only looked back to earlier thinkers (such as Jacob Boehme) but also laid down roots for developments in twentieth-century thought (Ludwig Klages, Martin Heidegger). The Archaic also includes: - studies of the Germanic dimension of the archaic (Charles Bambach, Alan Cardew) - a discussion of the mytho-phenomenological approach to the archaic (Robert Josef Kozljani ) - a series of articles on Jung`s understanding of the archaic (Paul Bishop, Susan Rowland, Robert Segal). This book will beof interest to psychoanalysts, anthropologists and phenomenologists, as well as students of psychology, cultural studies, religious studies, and philosophy, as it seeks to rehabilitate a concept of demonstrable and urgent relevance for our time"--

The Archaic (Paperback) $81.13 "The Archaic takes as its major reference points C.G. Jung`s classic essay, `Archaic Man` (1930), and Ernesto Grassi`s paper on `Archaic theories of history` (1990). Moving beyond the confines of a Jungian framework to include other methodological approaches, this book explores the concept of the archaic. Defined as meaning `old-fashioned`, `primitive`, `antiquated`, the archaic is, in fact, much more than something very, very old: it is timeless, inasmuch as it is before time itself. Arch , Urgrund, Ungrund, `primordial darkness`, `eternal nothing` are names for something essentially nameless, yet whose presence we nevertheless intuit. This book focuses on the reception of myth in the tradition of German Idealism or Romanticism (Creuzer, Schelling, Nietzsche), which not only looked back to earlier thinkers (such as Jacob Boehme) but also laid down roots for developments in twentieth-century thought (Ludwig Klages, Martin Heidegger). The Archaic also includes: - studies of the Germanic dimension of the archaic (Charles Bambach, Alan Cardew) - a discussion of the mytho-phenomenological approach to the archaic (Robert Josef Kozljani ) - a series of articles on Jung`s understanding of the archaic (Paul Bishop, Susan Rowland, Robert Segal). This book will beof interest to psychoanalysts, anthropologists and phenomenologists, as well as students of psychology, cultural studies, religious studies, and philosophy, as it seeks to rehabilitate a concept of demonstrable and urgent relevance for our time"--

'Archaic Melody' $694.95 Clutching his guitar, an older man sings an archaic melody as his thoughts return to the past. Shadow surrounds the musician, yet sunlight plays across his face and hands, drawing attention to the source of the man's expression. Working with assured brushstrokes, Joaquin Ramos creates a kindly and sensitive portrait. Titled "Melodia arcaica" in Spanish.

The Archaic Course $29.27 Borknagar's 1998 release, The Archaic Course, maintained the bold trajectory the band established on The Olden Domain, taking them even further from their black metal roots. After a series of four cacophonous but highly detailed numbers start the disc off

Dave's 2007 China Trip Beijing (Part 5 - Forbidden City)