Socep has asked for the wisdom of the Perl Monks concerning the following question:

How i can convert .rep repository database into the text file. using unix or windows perl program.

Replies are listed 'Best First'.
Re: ESP+ Storage .rep repository
by jepri (Parson) on May 26, 2004 at 06:41 UTC
    The example for the ESPPlus module makes it look like you could cut and paste the code and get what you want.

    Not having used ESP (or ESPPlus), I can't say if the example is sufficient, but it looks like a good place to start.

    ____________________
    Jeremy
    I didn't believe in evil until I dated it.

Re: ESP+ Storage .rep repository
by diotalevi (Canon) on May 26, 2004 at 13:55 UTC

    Was the documentation unclear? Tell me more. It has enough information to export the records out to files. When I saw an ESP+ Storage database the records were binary Xerox Metacode files and they required separate handling. Maybe your records are text... maybe they aren't. You'll have to post more information before I can help you.

    Also, I commented out the original snotty comment I made. You can see the original comment here.

      Thanks for your anwser. The documentation was clear. At this moment i am VB and VFP programmer under windows, and i don't know Perl. My problem is that i have an ESP+ storage repository (.rep), that was copy from solaris system two years ago and i need recover the information. When i open the file with bynary editor, the file is binary. My questions are: Can I convert the .rep to text file under windows with your programm? How i can transform binary metacode into text metacode? When you say: "they required separate handling.", what do you want to say exactly? Thanks for your help Socep

        You have two problems - the first is that the .REP file is sort of like a .ZIP file in that it is just a container for files. The purpose of the code you have asked me about is to unpack the contents of this archive. Each individual record in an ESP+ Storage database is compressed with LZW. In the documentation I make note of a function that you must provide - it is a wrapper around what on a Unix machine would be /usr/bin/uncompress. There is no natural analogue on a Windows machine so you will have to fetch UnxUtils and get uncompress.exe from that.

        Now you pick up Randal Schwartz' book Learning Perl on Win32 Systems and find out how to write the wrapper function around your newly acquired uncompress.exe executable.

        The last step, maybe... go run the example code. It is sufficient to extract the contents of an ESP Storage database out to a separate disc file per record. You probably still don't have readable text in those files but now you can tackle the next step which is to make sense of whatever format the data is really stored in.

        Good luck and let me know how this goes. By the way, is there something happening to the makers of this ESP+ Storage software? I also got an e-mail or two from other people about getting text back from an ESP+ Storage database. It makes a person wonder.