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
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Real World to Peachtree
- Thread starter mcrumpton
- Start date
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
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Thread starter
- #3
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.
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
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Thread starter
- #5
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
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
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
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
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
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
- Status
Similar threads
- Locked
- Question
- Locked
- Question