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.



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.

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…
On Microsoft Windows, if  when you click or type the name of a .pl file, you get an error "is not recognized as an internal or external command, operable program or batch file", then this means you do not have the .pl file extension associated with …
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

760 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now