Peachtree Quantum
Posted December 21st, 2007 by gbyerly
I have a client that is using the Peachtree Quantum accounting package. They would like to be able to extract info from the package for use elsewhere, and modify existing Peachtree data by adding detail to the records. One of your consultants suggested that the Pervasive Tools should allow me to do so.
I copied the data directory from the Peachtree system to my machine. How do I set up a database on my PC which does not have Peachtree on it, so the files (both DDF and DAT) are recognizable by the Tools? I tried creating a new database usiong that directory, but it did not recognize the files, and I could not find any way to associate them with the database.
Your transaction secured by high-grade AES-256 encryption.
RE: Peachtree Quantum
Hi gbyerly,
Pervasive DataTools offer several available options for getting data out of the Peachtree application. These options are described in the "Reading Source Data" section of the Applications Solutions page of our web site.
One of those options (entitled Reading from Legacy Data) appears to be the methodology you have chosen; i.e., use the Data Parser for Btrieve to read and parse the data from the .DAT and .DDF files. In order to connect to these Btrieve files with the Data Parser for Btrieve, you must either have the originating application (Peachtree Quantum) OR a Pervasive PSQL (Btrieve) runtime engine installed and configured properly on your workstation. Proper configuration typically means that the install path to the runtime engine must be entered into the PATH statement in your system environment. If you do not already have an application that uses Pervasive PSQL as the record manager installed on your workstation, you may obtain (try or buy) a Workgroup Engine from the Pervasive PSQL download page.
Hope this helps!
- Jo
Peachtree Quantum
Jo,
Thanks for your response.
Based on the comments of the Pervasive tech I talked to, I was attempting to use the Pervasive Tools to get to the Peachtree data. I am open to using any methodology and would prefer one that did not require the presence of the workgroup engine, e.g., an ODBC or OLE connection.
I originally had downloaded the Pervasive for Workgroups software, but once again, as stated in my original posting, after creating the database, I am unable to associate the existing DAT and DDF files with it.
Perhaps, I just need some instruction in how to do so.
Glenn
RE: Peachtree Quantum
Hi Glenn,
In order to connect to your Peachtree files with DataTools, it is not necessary to "create the database" with the Pervasive Workgroup Engine first. The DataTools simply need to be able to find a PSQL/Btrieve runtime engine on your workstation.
The most common reason for DataTools to NOT find the PSQL/Btrieve engine is that the install path of the PSQL/Btrieve engine is not included in the PATH statement in your system environment variables. Check your PATH statement and add it if it is not entered OR if it is entered incorrectly (i.e., wrong folder or misspelled, etc.).
The second most common reason for the workgroup engine to not be found is that it has not been started. Open the workgroup engine admin console on your workstation and start the engine.
Once DataTools can find the workgroup engine, you should be able to select the source connector and then connect to your DAT file.
Please let us know if this does not resolve the issue.
Alternative methods of pulling the data out of Peachtree are discussed in the "Reading Source Data" on the Application Solutions page of our web site. We can provide additional details that are specific to your scenario, if needed.
- Jo