Jump to content


Photo
- - - - -

Newbie with a few questions


14 replies to this topic

#1 Moose74

Moose74

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 23 August 2005 - 05:42 PM

Hi,

I've just started a new job and they have a ProIV system in place handling a lot of the day to day information processing. Only problem is no has any documentation on the system itself appart from the licensing.

Would anyone be able to point me in the direction of some tutorials on ProIV or refer me to some books? I'm trying to find out how to find what sort of back end database it is connecting to.
Also is it possible to export the database?
There doesn't seem to be any backups done of this database at all so i need to located the actual database the application is using!

Any help much appricated!

#2 Joseph Bove

Joseph Bove

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 756 posts
  • Gender:Male
  • Location:Ramsey, United States

Posted 23 August 2005 - 08:10 PM

Moose,

Are you on a Windows or Unix Server?

If Unix, are you connecting in character or GUI?

Regards,

Joseph

#3 Moose74

Moose74

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 25 August 2005 - 06:02 AM

Moose,

Are you on a Windows or Unix Server?

If Unix, are you connecting in character or GUI?

Regards,

Joseph

Hi Joseph,

Its a Windows system using a range of clients (Win NT workstation through Win98,W2k,WXP)

There is a graphical front end to the system through which users log in.

I can't find any files on the server that look like database files that i know. Does ProIV have its own database structure or does it have to use a 3rd party database?

Cheers,
Moose

#4 Phil

Phil

    Expert

  • Members
  • PipPipPipPip
  • 187 posts
  • Gender:Male

Posted 25 August 2005 - 06:55 AM

Whats the "in-house" system name, that could provide a fast track to solving your problems ?

Edited by Phil, 25 August 2005 - 06:55 AM.


#5 Moose74

Moose74

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 25 August 2005 - 07:20 AM

Whats the "in-house" system name, that could provide a fast track to solving your problems ?

Hi,

System is called "WMCOM" , i've got a .piv file thats run on the client machines to gain access to the system. I'm assuming this is some sort of scripting file?

A short cut calls the Proiv.exe file and passes the parameters
"wmcom.piv -P LOG LOG HDATA"

#6 Richard Bassett

Richard Bassett

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 696 posts
  • Location:Rural France

Posted 25 August 2005 - 09:46 AM

If you can't find anything you recognize as a database it is quite likely the system is using Pro-ISAM.
Pro-ISAM is a very simple, proprietary ISAM filesystem that is bundled with ProIV on Unix and Windows.
ProIV uses Pro-ISAM for its own "runtime files" (commonly referred to as the "bootstrap").
Applications can use Pro-ISAM for their data files (and many do).
Pro-ISAM files almost always have their default extension, which is ".pro".
ProIV's own runtime files include functdef.pro, genfile.pro, msgf.pro, logonf.pro and security.pro (and usually many others).
Application data files would almost always be put in a separate directory from the ProIV runtime files.
Maybe this will help you find things :D
Nothing's as simple as you think

#7 Moose74

Moose74

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 25 August 2005 - 03:13 PM

Pro-ISAM files almost always have their default extension, which is ".pro".

Aha!

Yup got a ton of these files, some of them very large which i would imagine would be database files!

You any idea what default folder would be used for database files?

Also anyone know if its possible to open these files in some other application,
(Excel, Access, SQL server or other) and check the contents?
Obviously only would attempt this with copies of the files in a safe location! lol

Cheers, Thats been a great help!
:D

#8 Vol Yip

Vol Yip

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 393 posts
  • Gender:Male
  • Location:Hong Kong

Posted 25 August 2005 - 03:19 PM

Try dig into the Window server and search the file pro4.ini

It probably tells you where is PROPATH (the folder which stores the bootstraps) and PRODATA (the folder of data files, if your system uses PRO-ISAM). Or else, it tells your what database you are using and how to connect to it.

#9 Moose74

Moose74

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 25 August 2005 - 03:25 PM

Try dig into the Window server and search the file pro4.ini

It probably tells you where is PROPATH (the folder which stores the bootstraps) and PRODATA (the folder of data files, if your system uses PRO-ISAM). Or else, it tells your what database you are using and how to connect to it.

Cheers,

Yeah that gives me a datafolder, looks like it is using the ISAM.
Also from the looks of this none of it is backed up as its listed in the backup software.... hmmm


Cheers for all the help guys!

#10 Joseph Bove

Joseph Bove

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 756 posts
  • Gender:Male
  • Location:Ramsey, United States

Posted 25 August 2005 - 06:22 PM

Moose,

Also anyone know if its possible to open these files in some other application,
(Excel, Access, SQL server or other) and check the contents?
Obviously only would attempt this with copies of the files in a safe location! lol


You can usually see some data if you open a ProISAM file in notepad. The quality of what you is slightly better than terrible, but not much.

If you wanted to get at the data in a meaningful way, you'd have to use ProIV or a the Transoft ProISAM ODBC driver.

Regards,

Joseph

#11 Vol Yip

Vol Yip

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 393 posts
  • Gender:Male
  • Location:Hong Kong

Posted 26 August 2005 - 02:52 AM

Years ago, there was a software PROTRACK. But I don't know if this still exists in the market.

#12 Chris Pepper

Chris Pepper

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 369 posts
  • Gender:Male
  • Location:United Kingdom

Posted 26 August 2005 - 10:56 AM

If nothing is being done about reorganising these files (once you have them backed up of course!) then this might be a good idea. It will need to be done when there are no ProIV users using the system. You use the "ispack" utility for this. Not sure what the rules are on a Windows server for running this. I'm sure someone will chip in with the relevant info.

#13 Moose74

Moose74

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 26 August 2005 - 02:22 PM

Cheers for all the help and info guys!

have got a much clearer view on everything now! :D

#14 notchpaguia_062208

notchpaguia_062208

    Newbie

  • Members
  • Pip
  • 6 posts
  • Gender:Male
  • Location:Philippines
  • Interests:Programming

Posted 28 August 2005 - 05:15 AM

Hi there guys!

I'm also a newbie in PROIV... although i've also had my share of experiences in other languages... hehehe...

just reading the forum helped me on some things that somewhat confuse me...

keep up the good work guys!

hope i could pass the training... :D
It's better to ask than to commit mistakes...

#15 Guest_Guest_*

Guest_Guest_*
  • Guests

Posted 29 August 2005 - 03:13 AM

The Protrack utility is still available at www.net-aware.com. You can download a demo version of it which includes a very good user manual which describes the structure of pro-isam (.pro) files. Also available is demo version of Protext utility which can be used to extract text files of the pro-isam file content. Lots of available info at NetAware Technologies.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users