Real World to Peachtree

Question

Real World to Peachtree

mcrumpton (TechnicalUser)

(OP)

24 Oct 03 16:56

This may be slightly off-topic but i was wondering if there is anyone out there who might know how to get the dos based Real World Program to print to file so that i can open in excel to import to Peachtree. I have attempted setting up as a text printer but maybe i'm just crazy but i can't get it to work in real world. It works everywhere else but there. I am at my wits end w/ this project. If anyone has any ideas I am open to all suggestions

dgillz (Instructor) · Answer 1 · 2003-10-26 00:25:02

What type of data is real world? Is it btrieve like peachtree?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
www.trianglepartners.com

mcrumpton (TechnicalUser) · Answer 2 · 2003-10-27 13:56:39

I'm not sure what type of data it is. We have no documentation on that program because it is so old. Our Ex-Administrator had set it up at one point for the data to print to file so that we could transfer into Peachtree as a csv file. But since he is not here, we are having considerable problems. We can't figure out how to set up printer even in this program. Dos is making it impossible considering that it is probably older than i am.

dgillz (Instructor) · Answer 3 · 2003-10-27 18:38:02

When you look in the directory where the data files are, do you see .ddf files?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
www.trianglepartners.com

mcrumpton (TechnicalUser) · Answer 4 · 2003-10-28 10:39:10

I just found this in a document file

SY60.013 5/13/91 New Company installation under BTRIEVE, when file PATHFILE locked, no error message displayed.

This makes me believe that possibly is on btrieve database like ptree. What would be the file ext. for these files? I am not sure which files are the data files. There are many files that i am not familiar with such as:

.dbf, .exp, .gnt, .idx, .int, .lbr, .rwc

dgillz (Instructor) · Answer 5 · 2003-10-28 10:44:43

Btrieve has no set file extensions. In Peachtree they are .DAT files while n Macola they are .btr files. In any case you should have some .ddf files that will allow you to read the btrieve files with another tool such as Crystal Reports, MS Access, etc.

Once you get MS Access reading the realworld files you should be able to write a query to update the Peachtree fiels with the desired information.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
www.trianglepartners.com

fdf (MIS) · Answer 6 · 2003-11-28 04:14:42

Is your real world package cobol based?

option 1: use report writer module if installed.

option 2: to print to file, modify the cobol configuration file printer settings

option 3: direct access to files would require real world source or odbc drivers. The data is in packed indexed files with no intrinsic data definition other than record size and key structure. Can use cobol file utilities to dump to fixed format sequential, but you would still need data definitions to parse and unpack results.

fdf@frantzsystems.com

Come Join Us!

Posting Guidelines

Real World to Peachtree