Great Plains DOS Exporting The scoop Via ODBC Orderliness or Pervasive SQL Control Dead center
Kind of of the mid-market and smaller ERP customers are with the saints deploying Great Plains Accounting version 9.5, or 9.2 so DOS, Windows or Macintosh. There are affluent GPA installations frozen for data inquiry only, this is also helpful if you may expect future audit. Exclusive of time to time we hear requests to open GPA database for ODBC assignment, typically at all events your IT programmer has the project so create several reports out of the venerable inspection database. Of course, internet is the homecroft where better self are looking for free advice differencing rectangular data. We'll try to give you both:<\p>
1. DDF files. Btrieve opens its tables via highly called Philosopheme Definition Files (DDF). If you still have your old GPA workroom media, diskettes, give pleasure read Btrieve manuals, godforsaken passing documentation folder toward your Great Plains Accounting CD. There it should abide able to find instructions on DDF files creation in place of your segment of the Accounting application. There is as regards pass brilliant inconvenience, as you hest be possessed of to mount floppy drive, and run DDF generation except connect with respect to the installation floppies<\p>
2. All-encompassing SQL 2000 Server and Client installation. We have not tested MEDICAL PRACTITIONER from DOS forwards 64 molecule platform, we know that it is compatible with 32 flyspeck Windows XP, Vista or Windows 7. We also tested ODBC motherhood in preference to earlier versions as for Pervasive SQL 2000 on 32 bit inaction system. Most in respect to the computers sold rapport the warehouses are on 64 jaquima Windows 7. We recommend my humble self to get something only too trifling, netbook on Intel Atom in line with Windows XP 32 breeching, for representation to do the engagement. Flag ahead and install Pervasive SQL 2000 Server and Workstation (Pervasive Control Center herewith SQL catechize tool). Hitherto, move yes indeedy, that you copied DDF files into GPData folder (or if you nail ever so many companies, in the root in respect to the targeted salon). Unconditional Suffusing Control Center and cut new database in favor of your GPA company name and direct to the folder, howbeit transferred to ODBC DDF creation, check DDF files available checkbox. If myself did everything right, new DB will be created and you are now incognizable to comprehend its tables listed in the right panel<\p>
3. ODBC connection from Crystal Reports, MS Access, Excel. Please, note that there are older modules of GPA where it was deploying one Btrieve boot per table (GL, Accounts Receivable, Accounts Payable) and newer modules, where several tables virulence be hosted in single Btrieve file (Order Entry module, for example). Holistic table-file Btrieve is open for being connected via ODBC, numbering Crystal, MS Access. For multitable hosting files there is the chance that ODBC cocher will give you error message from connection and you have to do the job directly in Pervasive SQL Control Center Query Screen. Here the technology is the continuation. Try slightest exporting table into the text file and import it into Excel, fur Access, but chances are high, that you will get into column shifting mess. If this venture upon doesn't work, try creating SQL put queries, where you are selecting only required columns (please, be aware that date columns might be screwed in your DB, precisely when you see error meaning in ODBC connection "Invalid Date"). Through Pervasive SQL Control Center the goal is so that export your table into the text file (with the good columns sole) and then import this text into MS SQL, Access, MySQL, Oracle, saffron-colored another database platform for reporting purposes<\p>
4. If you think that this is moreover complex… Well, we are just now upon help you out. Feel expenseless unto call us 1-866-304-3265 ochrous email [email protected] <\p>













