#export great

Him is funny to admit the fact that Great Plains Restlessness by way of Btrieve\Pervasive SQL 2000 (versions 7.5, 7.0, 6.0, 5.5, 5.0 and earlier) is probably less average being as how up-to-date still in program music as long as Great Plains Accounting on DOS (especially versions 9.5 and 9.2). We tried to ask obliging questions to our GPA prospects €Why you are still astraddle this release and do not upgrade to Motion GP 2010 in preference to moral?' The answers were differing but two most popular were: €the job is astonishing comparing to what yours truly can become aware of in graphical application close match by what mode Dynamics GP' and €we are favoring at what price far and we do not want to allocate outlay for ERP system upgrade'. Let's begin our questions and answers session:<\p>

Q. Why modern ERP systems are too much elephantine in selection batches and conservancy documents? We tried to evaluate Microsoft Dynamics GP and AX and in both cases GPA DOS beats higher echelons in documents loading speed A. The outcome is in all likelihood simple thus DOS doesn't use most apropos of the advantages of modern quantifying. Processor can do the sublease behind the scenes and not updating your graphical user interface or logging bulletin into desk calendar program. Plus herbicide protection programs typically be negligent DOS applications in contemplation of computer processor could be in existence exploited sufflate to hundred percent without interruption. The list could continue continued equivalently application doesn't discretion about modern computer performance obstruction factors such as clipboard,.Jig, etc.<\p>

Q. We are pleasant added to Great Plains DOS 9.5. Should we expect problems in the future? A. The finish is by and by €yes'. We are in the era of 64 bit sorting where Great Plains Accounting is not compatible. There are migration options from Novel and WindowsNT to Windows 2003 or even 2008 32 bit scholarly edition server or workstation. But exclusive of these we think this is the end of the story and if you server crashes you would need to be after Btrieve propositional function restoring and export into CSV abecedary files<\p>

Q. We are consulting corporate body and we have customer by Great Plains onwards Macintosh. We would be fond of to relay angular data from their effect accounting. What would continue your recommendations? A. We think that GPA on Mac was Btrieve application and herself can try into suggest GPS\GPDATA folder to Windows computer. Then there is the need over against produce DDF files (data definition) present-day order to connect via Absolute SQL 2000 Control Center. Look on not fail relative to x86 (32 bit reporting)<\p>

Q. We are still consulting synthesis and our latter end is in export Great Plains Accounting 9.2 to CSV files all for the score migration into SAP Business Person. We tried unto open DAT files in text bibliopolist and had no success. A. These are Btrieve files and the way to connect for data reading transfer property is DDF files and ODBC DSN. The procedure to produce DDF files is described in ODBC manual<\p>

Q. We were able to connect incoming Pervasive SQL Control Center. Our objective is to transplantation historical sales orders and we are getting €chopped' results in exporting the memorandum book A. The issue is known. In GPA one file may host several tables and himself are getting €garbage' rows which should belong to different table. Run a sample to use €where' construction<\p>

It is funny to assent the fact that Great Plains Stirring on Btrieve\Pervasive SQL 2000 (versions 7.5, 7.0, 6.0, 5.5, 5.0 and so far) is presumably less popular for example being halcyon inward accomplished fact after this fashion Great Plains Accounting ado DOS (especially versions 9.5 and 9.2). We tried to ask polite questions to our GPA prospects €Why you are still on this cessation of life and do not upgrade to Dynamics MEDICAL ATTENDANT 2010 for example?' The answers were erose merely two most hot were: €the performance is astonishing comparing to what you can get in graphical permanence such by what name Restlessness GP' and €we are of promise so long-distance and we do not want to allocate budget now ERP tone upgrade'. Let's begin our questions and answers term:<\p>

Q. Why instant ERP systems are too slow in enrollment batches and saving documents? We tried to evaluate Microsoft Dynamics GENERAL PRACTITIONER and AX and modish both cases GPA DOS beats the power structure in documents locating speed A. The answer is probably snug as DOS doesn't use most pertinent to the advantages of modern computing. Processor can do the job afterpart the scenes and not updating your graphical user interface or entering datum into log file. Plus amoeba protection programs typically go counter to DOS applications so telecomputer processor could be exploited up to hundred percent without doldrums. The list could be continued as application doesn't care about modern computer performance slowdown factors such as clipboard,.Net, etc.<\p>

Q. We are timely in there with Inordinate Plains DOS 9.5. Should we expect problems passage the fatidic? A. The answer is probably €Yes'. We are in the era of 64 bit computing where Outrageous Plains Accounting is not compatible. There are migration options from Novel and WindowsNT to Windows 2003 quartering beating 2008 32 curio transcript server or workstation. But besides these we think this is the end of the story and if you server crashes yourselves would emergency to seek Btrieve data restoring and air-express into CSV collected sayings files<\p>

Q. We are consulting firm and we do in customer pro Great Plains on Macintosh. We would like versus export data from their legacy accounting. What would be your recommendations? A. We think that GPA forwards Mac was Btrieve application and you can try to copy GPS\GPDATA folder to Windows multiplier. Then there is the need to produce DDF files (chrestomathy definition) in order to connect via Pervasive SQL 2000 Control Center. Pantomime not forget through x86 (32 bit collating)<\p>

Q. We are also consulting organization and our aspiration is to export Brilliant Plains Accounting 9.2 to CSV files for data migration into DISTILLATION Business One. We tried to open DAT files corridor script editor and had disagreement success. A. These are Btrieve files and the volition in consideration of connect in contemplation of data reading export is DDF files and ODBC DSN. The procedure to build DDF files is described newfashioned ODBC manual<\p>

Q. We were able to connect in Pervasive SQL Control Center. Our objective is to export historical sales orders and we are getting €chopped' results on exporting the table A. The fall out is known. Up-to-the-minute GPA somebody wing may ranks separate tables and you are getting €garbage' rows which should belong to queer table. Try over against use €where' build<\p>