Jumat, 24 Juni 2011

Great Plains DOS Exporting Data via ODBC connection or Pervasive SQL Control Center

Some of the smaller and mid-market ERP customers are still implementing Great Plains Accounting version 9.5, and 9.2 for DOS, Windows or Macintosh. There are many plants frozen GPA data query only, it is also useful if you can look forward to future revisions. From time to time we hear the GPA requirements for opening a database for the ODBC connection, usually when IT developer's project to create several reports from the old accounting data. Of course, the internet is a place where you are looking for free advice or instruction. We will try to give you both:

1 DDF files. Btrieve tables opened via the so-called data definition files (DDF). If you still have your old GPA installation media, floppy disks, please read Btrieve manuals, available on the documentation folder on your Great Plains Accounting CD. There should not be able to find instructions to create DDF files for your version of accounting software. There is, of course, some embarrassment, as you'll need to mount your floppy drive and run DDF generation from one of the install disks

2 Pervasive SQL 2000 Server and client installation. We did not test the GP for DOS on a 64 bit platform, we know that it is compatible with 32-bit Windows XP, Vista or Windows 7 We also tested the ODBC connection to an older version of Pervasive SQL 2000 on 32 bit operating system. Most computers sold in the warehouse are on 64 bit Windows 7 We recommend you to be something really small, the Intel Atom Netbook with Windows XP 32-bit, for example, for the job. Go ahead and install Pervasive SQL 2000 servers and workstations (Pervasive Control Center with the SQL query tool). Then, make sure you copy the DDF files in the folder GPData (or if you have multiple companies, at the root of the target company). Open the Pervasive Control Center and create a new database with your GPA company name and specify a folder, when it switched to create ODBC DDF, DDF files check box. If you have everything right, the new DB will be created and you are now able to see your tables listed in the right part of the

3 ODBC connection to Crystal Reports, MS Access, Excel. Please keep in mind that there are older modules GPA, where the introduction of a Btrieve file on the table (GL, accounts receivable, accounts payable), a newer mode, where several tables can be hosted in a Btrieve file (order entry module, for example ). One table-Btrieve file is opened for that is connected via ODBC, including Crystal, MS Access. For Multitab hosting files there is a chance that the ODBC driver will give you an error message related to, and you have to do the job directly to Pervasive SQL Control Center queries the screen. This technology is next. Try to first export a table to text file and import into Excel, or Access, but chances are high that you will get the column moving mess. If this approach fails, try to create a SQL query, where the selection of only the necessary columns (please note that the date columns to be drunk in your living room, especially when you see an error message in the ODBC connection "Invalid date"). Through Pervasive SQL Control Center goal is to export the table to a text file (with a good column only), and then import this text in MS SQL, Access, MySQL, Oracle or another database platform for reporting purposes

Tidak ada komentar:

Posting Komentar