HTML Interface
Download
Report
Transcript HTML Interface
R. E. Gibson Library & Information Center
The Design and Management
of a Dynamically Created
Intranet at Johns Hopkins
Applied Physics Laboratory
Peter LePoer & Judith Theodori
Interlab 2003
11/7/2003
1
Today’s Presentation….
R. E. Gibson Library & Information Center
Overview of APL
HTML Interface for Users
Access Interface for Maintenance
The SQL Back End
ASP Scripting - “The Glue”
Favorites and Other Features
Future Directions
2
JHU Applied Physics Laboratory
R. E. Gibson Library & Information Center
3
Overview of JHUAPL-The Facts
R. E. Gibson Library & Information Center
Not-for-profit division of Johns
Hopkins University
Major sponsors are Navy and NASA
Staff of 3,350. 66% engineers &
scientists
130 specialized research and test
facilities
Located on 360 acres in Laurel, MD
4
Overview of JHUAPL-Cool Stuff
R. E. Gibson Library & Information Center
1942 – Variable-time (aka Proximity) Fuze
1948 – First photo of Earth from Space
1957 – Analyzed Doppler signals,
developing first GPS
Ingestible temperature pill; disposable
syringe; bridge corrosion sensors
2001 – NEAR satellite landed on asteroid
5
HTML Interface
R. E. Gibson Library & Information Center
6
HTML Interface
R. E. Gibson Library & Information Center
Menu allows for
browsing by
assigned
Category….
While the search box
queries full text of
particular fields
7
HTML Interface – Searching
R. E. Gibson Library & Information Center
Either select a menu
item or enter your
search term…
8
HTML Interface – Search Results
R. E. Gibson Library & Information Center
The search results will then be displayed
.
9
HTML Interface – Favorites
R. E. Gibson Library & Information Center
Select the “Add” button to add this
link to your personal favorites
10
HTML Interface – The Research
Portal
R. E. Gibson Library & Information Center
11
HTML Interface – The Sensors Portal
R. E. Gibson Library & Information Center
12
Resource Entry Form
R. E. Gibson Library & Information Center
The same record can
appear on one or more
Web sites
13
Resource Entry Form
R. E. Gibson Library & Information Center
An item such as a calendar
event, announcement,
or a featured resource
can be scheduled to
commence
and then retire
14
Resource Entry Form
R. E. Gibson Library & Information Center
Hyperlinks and other
formatting can be imbedded
into the abstract
15
Resource Entry Form
R. E. Gibson Library & Information Center
Search box on interface
queries the Title, Keyword,
and Abstract fields
16
Resource Entry Form
R. E. Gibson Library & Information Center
Assigning categories to
a resource facilitates
access via menus
17
Resource Entry Form
R. E. Gibson Library & Information Center
Title will appear as a
hyperlink…
Unless Paper has a True
value
18
MS SQL Database Diagram
R. E. Gibson Library & Information Center
19
ASP Prerequisites
R. E. Gibson Library & Information Center
Scripting language – VBScript or
Javascript
Data Access technology – ADO
SQL
HTML
20
ASP Page-Flow for Searching
R. E. Gibson Library & Information Center
21
HTML Interface
R. E. Gibson Library & Information Center
22
Retrieving and Displaying Calendar
Items(1)
R. E. Gibson Library & Information Center
/**
/** open connection to database
/**
<% sConnStr = "Provider=SQLOLEDB; Data
Source=SQLMACHINE; Initial
Catalog=DBNAME; User ID=DBUSER;
Password=XXXXX"
Set DBConn =
Server.CreateObject("ADODB.Connection")
DBConn.Open sConnStr %>
23
Retrieving and Displaying Calendar
Items (2)
R. E. Gibson Library & Information Center
/**
/** retrieve recordset
/**
<% SQL2 = "SELECT
Calendar_Item,Calender_id,Event_Date,Event_Time,
Event_place,Description,Date_commence,URL,Date
_retire,Event_Date from dbo.Calendar where
Event_Date = '" + cstr(date) + "'"
Set RSInfo2 =
Server.CreateObject("ADODB.RecordSet")
RSInfo2.Open SQL2, DBConn, adOpenForwardOnly,
adLockReadOnly, adCmdText %>
24
Retrieving and Displaying Calendar
Items (3)
R. E. Gibson Library & Information Center
<% while not RSInfo2.EOF
if RSInfo2("Date_commence") <= curr_date then
if RSInfo2("Date_retire") >= curr_date then %>
<span
class="APLtodaySubtitles"><%=
RSInfo2("Calendar_Item") %></span><br>
<span class="APLtodayDates"><%=
RSInfo2("Event_date") %></span>
<%= RSInfo2("Event_Place") %><br>
<% end if
end if
RSInfo2.MoveNext
Wend %>
25
Favorites & Image Rotation
R. E. Gibson Library & Information Center
26
Favorites and Image Rotation
R. E. Gibson Library & Information Center
Favorites
User
selects by “add to favorites”
button
Stored in cookies
Client-side and server-side script
Image Rotation
Image
names, URLs in database
Server-side and client-side script
27
Future Directions
R. E. Gibson Library & Information Center
End-User Customization
User registration to allow for storing
subject interests
Conversion to next-generation
Microsoft.Net platform
Filters for external or internal access
28
For More Information:
R. E. Gibson Library & Information Center
Peter LePoer, Systems Librarian
[email protected]
Judith Theodori, Project Manager
[email protected]
Office of Technology Transfer
http://www.jhuapl.edu/ott
443-778-3541
29