Plus Great
Plus Great
Microsoft Great Plains Installation Highlights
Current version of Microsoft Dynamics GP, 10.0 is available on Microsoft SQL Server 2005 and 2000. If you are on older version, we’ll also give you advise on where to find information. We’ll begin with Microsoft Great Plains architecture and technology inside:
1. Application Dictionary. Core dictionary is DYNAMICS.DIC, the dictionaries and their products are listed in Dynamics.set file. These dictionaries are interpreted by Dex.exe application. GP proprietary architecture is Microsoft Dexterity: Dex forms, reports, fields, string and other objects as well as Dex sanscript scripts are stored in the Dex dictionary. Often we have this question asked – what is DEX_ROW_ID. The answer – this is unique identifier, required by Great Plains Dexterity internal logic
2. Connection to SQL Server. GP talks to MS SQL Server databases via ODBC connection. If you are on Windows 64 bit platform, at this time you will have to deploy 32 bit ODBC DSN
3. SQL Server Databases. DYNAMICS is system database, which stored users and security, company definitions plus currencies and system-wide multicurrency settings among other system things. Company database stores settings, master records, work, open and historical transactions for one legal entity – company. You may install unlimited number of companies at this time. SQL objects: tables, stored procedures and so-called atomic stored procedures (their names begin with zdp_). GP doesn’t use SQL referential integrity, “integrity” is programmed on business logic level
4. Installation process. First GP installing copies GP user application with or without SQL objects (SQL objects are required to load Dynamics and company database if you are doing fresh install or initiate upgrade process if this is your purpose). You can do GP workstation initial installation on the server – this will allow you to load GP server side faster, but this is not required – you can install first workstation on Vista or XP machine and load server side remotely. When you install first GP workstation, Great Plains Utilities applications starts automatically to begin Server installation process
5. Additional GP products: Project Accounting, Fixed Assets, Manufacturing, Collection Management are good examples – each of these products has its own Dexterity dictionary file – you can recognize its name by reviewing Dynamics.set file
6. Additional GP workstations install. For end users you do not install SQL objects, plus GP Utilities synchronize Dynamics dictionary with GP database settings (GL account format)
7. Customization install. If somebody did Great Plains Dexterity customizing for you, they typically provide you with so-called Dexterity chunk file, this file you copy into GP workstation folder and when you launch Great Plains next time, this chunk file will be integrated (.cnk file will be transformed into Dex dictionary file and its record will be added to Dynamics.set file)
8. Integration Manager installation. IM is currently under the process of being rewritten in eConnect (integration tool, which is written in SQL encrypted stored procedures with various interfaces to be exposed to BizTalk, Web Services, ADO.Net, etc), so if you will decide to install eConnect connector, you will need to specify your domain user account for eConnect security
9. Great Plains Software old versions installation notes. If you have Great Plains Dynamics 5.0, 5.5, 6.0, 7.0 or 7.5, these versions were available on Btrieve, later on purchased by Pervasive Software and renamed into Pervasive SQL 2000 and Ctree/Faircom. Pervasive/Btrieve Client-Server version requires altering for Pervasive SQL Server settings, so if you just need single user GP workstation for transactions lookup only, we recommend you to follow single user workstation installation instructions. Both Ctree and Btrieve versions have Location Translation technology, please give us a call on location translation as it is no longer supported by Microsoft Tech support and is not trivial in its consideration
10. Great Plains Accounting for DOS, MS Windows and Mac. This dinosaur support was terminated in around 2001, however there is migration path to Microsoft Dynamics GP, plus you should get discount on GP modules purchase. It is not practical to try GPA migration to GP on your own, we recommend you to have Great Plains technical consultant to do the migration job.
If you like us to help you with GP upgrade, integration, software licenses, reporting, please give us a call
About the Author
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale
Is there a capture card out there better than Dazzle Plus?
Dazzle Plus is great so far as plug and play, but many reviews I’ve read say its great if you DON’T want high quality DVDs. I want to transfer my wedding from VHS to DVD so I want to achieve the best quality possible. Any suggestions?
I’ve done commercial editing on high end equipment as well as home editing. For personal home use, Dazzle has been perfectly good. Technically, there is better equipment than Dazzle, but for capture devices, you’re just spending more money for better POTENTIAL quality, but no real ACTUAL improvement.
The reason why is that you won’t achieve any higher quality than your source. No matter what capture device you use, VHS quality is still VHS quality. Nothing will ever make it better.
While mini-DV is much better than VHS, you won’t degrade it enough to notice through casual viewing by using Dazzle. Maybe you could have a side-by-side, high intensity shoot-out to compare differences, but even then, you’ll realize that the small amount of quality improvement doesn’t warrant the large amount of extra cost.
And if you’re using mini-DVD, then find some other way to transfer the material for editing rather than a capture card of ANY kind.
Bottom line is, I wouldn’t use Dazzle for commercial high quality production, but I wouldn’t use any capture card for commercial high quality production. Anything that needs a capture card is done well enough with Dazzle. After that, it’s just nerd argument for argument’s sake.
|
|
Mammoths of the Great Plains Plus Writin (Paperback) $10.1 Ever since a Woman of the Iron People won the first Tiptree Award in 1991, Eleanor Arnason has been celebrated as the heir to SF`s revolutionary feminist legacy. Her Mammoths of the Great Plains presents a radical new vision of the Old West.In … |
|
|
Callaway HX Hot Plus Golf Balls (Case of 24) $36.49 This 3-piece distance golf ball has been redesigned with a new high-speed core for even longer distance and a Speed Layer for better feel and increased ball speed. The Callaway HX Hot Plus is a great golf ball for the average golfer with any swing speed. |
|
|
Super Island Plus with Raised Panel Doors & Drop Leaf $755.99 Catskill has taken their Super Island to the next level with raised panel doors and added drop leafCart adds work surface and also makes a great breakfast bar |
|
|
The Best Used Boat Notebook $21.64 With the used boat market growing and becoming more complex, here is the new book that used boat buyers have been waiting for. John Kretschmer`s Used Boat Notebook has been one of the most popular features in Sailing Magazine. Each month Kretschmer pro… |
|
|
Super Island Plus w/ Raised Panel Doors $619.99 Catskill has taken their Super Island to the next level with raised panel doorsCart adds work surface and also makes a great breakfast bar |