×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Real World to Peachtree

Real World to Peachtree

Real World to Peachtree

(OP)
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

RE: Real World to Peachtree

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

RE: Real World to Peachtree

(OP)
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.

RE: Real World to Peachtree

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

RE: Real World to Peachtree

(OP)
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

RE: Real World to Peachtree

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

RE: Real World to Peachtree

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close