Perl and OPACs

Posted on 2002-04-09
Last Modified: 2010-03-05
hello to everybody

the question is (maybe) not difficult but it may employ long time to resolve.

please go to

this is the on line catalogue of a university (sorry for the italian language) made with ALEPH. You can find other info and english demos about this software at:

all that I want is a dynamic perl page that passes to the catalogue some string search (IE a perl page that automatically finds all the books that have the word "mathematics" on the title) and returns a list of the matching headers

in other words something like "click here to find all the mathematics books of the university" with "here" hyperlinked to the perl page in question.

I think that the difficult is on the large use of dynamic session-ids inside this software.
bye and thanks

Question by:fabianope

Expert Comment

by:christopher sagayam
ID: 6927750
listening to other's answers....
LVL 51

Expert Comment

ID: 6928457
could you please post the code which needs to be changed

Author Comment

ID: 6930589
I know that this is an ORACLE solution, but I've not an administrative access to the server and I don't know the
database structure, so I must work only with the (dynamic) HTML interface.
I've thought to the following scenario:

1) with a first interrogation to the html interface the script fetch the session ID(s)

2) with a "second passage" the script builds the right url for the search.

please note that you can "fix" the search to a pre-defined search term: I.E.

<a href="">math books</a>

where is the page I desired...

the script should be build from scratch: if this is difficult I can increase the points.


Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Expert Comment

ID: 6930752

If you want to know how to use patterns,
You will get links to perlre and perlre tutorial.

I could not open the english site :( and I dont understand
 italian :(

Well, where is the data lying? Is it in oracle or it is coming from HTML form?

If the data is lying in Orcale, then I think you need to know database structure.

Do you know how to connect to oracle using perl?

Also to read database and knowing a database structure does not need administrator access.

LVL 51

Accepted Solution

ahoffmann earned 330 total points
ID: 6932129
#! /usr/bin/perl
use CGI;
use HTTP::Request;
use LWP::UserAgent;
$::query = new CGI;
$url = "http://your-URL-here";
$usr = LWP::UserAgent->new();
$req = HTTP::Request->new(GET=>"$url");
$txt = $usr->request($req);
undef $/;
$x = $_= $txt->content();
$sessionid =~s/(regular-expression-to fetch-sessionid)/$1/;
# no you need to put $sessionid to $url like
$url .= "?sessionid=$sessionid";
$req = HTTP::Request->new(GET=>"$url");
print $usr->request($req);
exit 0;
# very basic script, to be improved in many ways

Author Comment

ID: 6947582
thanks a lot for the solution.
sorry for the delay in answering (I was away for work)
in the next hours I'll try it and if successfull I'll accept it.



Author Comment

ID: 6985781
excuse the delay in answering (I've added 30 points)

LVL 51

Expert Comment

ID: 6986855

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel to CSV conversion with specific columns 5 87
Perl Write to Specific line in a file 15 106
Perl tar error 8 67
Perl File::Find alternative 1 78
I've just discovered very important differences between Windows an Unix formats in Perl,at least 5.xx.. MOST IMPORTANT: Use Unix file format while saving Your script. otherwise it will have ^M s or smth likely weird in the EOL, Then DO NOT use m…
I have been pestered over the years to produce and distribute regular data extracts, and often the request have explicitly requested the data be emailed as an Excel attachement; specifically Excel, as it appears: CSV files confuse (no Red or Green h…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question