Seeking a simple method to convert pro-isam files
#1
Posted 15 November 2001 - 05:26 PM
I am trying to extract the data from an old application written in Pro-IV that is no longer supported by the vendor (SCT/Mentor.) I have no previous experience with Pro-IV.
It appears that the files are in the proprietary pro-isam format (they have .pro extensions).
Can anyone suggest an inexpensive tool or method for extracting the data from these files? I'd prefer not to buy a developer's license just for this task, as all I need to do is move the data to the new application.
If no tools are available for a reasonable price, is there anyone who would be willing to do such an extraction for me for a reasonable fee? Essentially, I just need to get the pro-isam data into a flat ASCII file.
Thanks!
-Nick Fankhauser (nick@fankhausers.com)
#3
Posted 16 November 2001 - 12:26 PM
Thanks for your help so far!
-Nick
#4
Posted 16 November 2001 - 01:25 PM
If they're titled 'FILE DOCUMENTATION' and have a section headed 'RECORD LAYOUT' then they'll be the file defs :-)I *do* have a stack of paper that appears to be the field layout for each table/file.
I'm not sure whether I have the corresponding definitions on disk.
It's important to have them in order to understand the content of the different record types used by the application. In ISAM these can occasionally contain subtleties such as repeating groups and redefines (discriminated unions).
If you're hoping to get someone to do this for you in ProIV, you'll obviously save a lot of time having the file defs in electronic form.
Would the [file] definitions be one per data file?
Sometimes yes, but equally often not. It is possible and not uncommon to store multiple record types in one physical ISAM data file using ProIV. It is also common to access the same record type using more than one file definition (for various reasons, mostly of convenience).
If so what is the file extension [for a file def I assume you meant]& would the first part of the name correspond to its matching .pro file?
ProISAM files have a .pro extension by default. As you have determined, some of these are very probably your data files.
Something you may not have realised is that ProIV source does not exist as individual (text) files. The source (if you have any) is itself stored as (many) records within a set of ISAM files known as the 'bootstrap'. These are functdef.pro, genfile.pro, msgf.pro and so on and are typically located in a different directory to your data files. If you have any source, you would expect to have a logic.pro file and for it to be quite large compared to the other bootstraps.
So.. there is no 'file extension' for a file definition.
However, in simple cases, the file definition name a developer uses (FILE NAME: on your paper docs) will often correspond to the data file name without the .pro extension.
Hope this helps.
Can you tell us what version of ProIV your application is running on and what database you want to move the data into for your new application?
Regards, Richard B.
#5
Posted 16 November 2001 - 01:51 PM
I'll have to wait until Monday when I can go sit at the console to respond to the question about Pro-IV version. The system has been unsupported for several years, so I expect it is fairly old.
The data will be going into Informix, but because the old system is an isolated (no network services) SCO box, I'm hoping to simply extract the data into flat ASCII files for transfer over a serial line. I'm aware that Pro-IV should be able to write C-ISAM files readable by Informix, but a set of flat ASCII files is what the vendor of the new system is asking for.
-Nick
#6
Posted 16 November 2001 - 04:49 PM
There are three basic options:
1) If you have inherited a PRO-IV Development system we can step you through writing a trivial PRO-IV function to output the data in the format you want.
2) If you only have a run-time system then you could get someone else to write the routines for you and send them to you. (This would have a cost).
3) I know of various people who have written 'C' routines to extract the data. It's a variable length format.
When you find out the version, try and see if you have a development license. After logging in the CTL-C and see if you get a ? prompt in the top Left hand corner. Then type @MOD (return). If you get a screen displayed then you have a development system, if you get an error message then you haven't.
#8
Posted 17 November 2001 - 05:33 PM
#9
Posted 18 November 2001 - 03:35 PM
export pro4 recs to text easily. I use protrack daily to
check the integrity of our pro4 and cisam files.
Their tech support is great.
Using protrack Nick would just need the pro4 filedefs in order to know what all the extracted fields are.
#10
Posted 19 November 2001 - 04:19 PM
Those strange system crashes or hangups, inconsistent reports and other problems you have seen over the years are almost always the result of hidden corruption in your file system.
#11
Posted 19 November 2001 - 05:57 PM
Nick - I was going to offer to write you some C but I can't do it for $450 :-)
Aprile - I downloaded your demo so I could read the doc. Seems like a very useful product but possibly that it doesn't support variable-length C-ISAM (ProIV CISAMV file type). Can you confirm that or not? If not, is there any plan to provide such support? TVM.
#12
Posted 19 November 2001 - 06:46 PM
We did, however, recently add support for floating point c-isam numerics for a few platforms. Thanks for looking at our products.
#13
Posted 20 November 2001 - 02:22 AM
A few folks have contacted me directly via e-mail about this & expressed an interest in submitting a quote for the work. At this point the utility for extracting that the net-aware folks have seems like a good option, but I'll look at a the quotes & might consider that having a person who understands it all working with the files is worth a few extra dollars. If I missed sending my system information to anyone who is still interested in quoting the job, please contact me. (Richard- I assumed you were no longer interested based on your last forum post.)
The pointers I got here really helped me with the basics I needed to at least find my way around the system to get basic information. Your help is much appreciated!
-Nick
#14
Posted 26 December 2001 - 07:03 PM
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users