Docstoc

Online Directories

Document Sample
Online Directories Powered By Docstoc
					                        Online Directories – Technical Specification




              Online Directories
                                                   Technical Specification




Document Version      1.0
Document Status       Draft
Author(s)             Emma Reilly


Revision Date
Filename              OnlineDirectories_TechnicalSpec v0.1.doc



Modification History

   Date      Author     Comments
 18/07/06   EJR




                                          Page 1
                             Online Directories – Technical Specification
Contents
Contents ___________________________________________________________________ 2
 1     Introduction ________________________________________________________________ 4
 2     Overview of Technical Design _________________________________________________ 5
     2.1     Documentum ___________________________________________________________________ 5
     2.2     Internet Diagram ________________________________________________________________ 6
     2.3     Intranet Diagram ________________________________________________________________ 7
     2.4     Keyword Search, Print All and Export all to CSV Diagram _______________________________ 8
     2.5     Advanced Keyword Search, Print All and Export all to CSV Diagram _______________________ 9
     2.6     Freetext and Advanced Freetext search diagram _______________________________________ 10
 3     Web Config File ____________________________________________________________ 11
 4     Internet and Intranet look and feel ____________________________________________ 12
 5     Internet Default.htm ________________________________________________________ 13
 6     Intranet Default.htm ________________________________________________________ 14
 7     DirectoryHomePage.aspx ____________________________________________________ 15
     7.1     Page_Load Method _____________________________________________________________ 15
     7.2     LocalizeDetails Method __________________________________________________________ 16
     7.3     HomePage.xslt _________________________________________________________________ 16
 8     SectionPage.aspx ___________________________________________________________ 17
     8.1     Page_Load Method _____________________________________________________________         18
     8.2     LocalizeDetails Method __________________________________________________________      19
     8.3     GetExportXML Method __________________________________________________________         19
     8.4     SectionPageSections.xslt _________________________________________________________     20
     8.5     SectionPagePages.xslt ___________________________________________________________      21
 9     Page.aspx _________________________________________________________________ 22
     9.1     Page_Load Method _____________________________________________________________ 22
     9.2     LocalizeDetails Method __________________________________________________________ 22
     9.3     <DirectoryName>_ContentPage.xslt ________________________________________________ 22
 10         AtoZ.aspx _______________________________________________________________ 24
     10.1    Page_Load Method _____________________________________________________________         24
     10.2    LocalizeDetails Method __________________________________________________________      24
     10.3    drawAtoZ Method ______________________________________________________________         24
     10.4    AtoZ.xslt _____________________________________________________________________        25
 11         Search.aspx______________________________________________________________ 26
     11.1    Page_Load Method _____________________________________________________________         27
     11.2    GetExportXML Method __________________________________________________________         30
     11.3    LocalizeDetails Method __________________________________________________________      31
     11.4    SearchPage.xslt ________________________________________________________________       31
 12         SearchResultsDAL.aspx ___________________________________________________ 32
     12.1    CF_NumberOfKeywordSearchResults ______________________________________________         32
     12.2    CF_SimpleNumberOfKeywordSearchResults _________________________________________        32
     12.3    GetSearchResults_CF____________________________________________________________        32
     12.4    ColumnEqual __________________________________________________________________         33
     12.5    SelectDistinct __________________________________________________________________      33
     12.6    GetSearchResults_LS ____________________________________________________________       33
     12.7    GetKeywordSimpleSearchResults __________________________________________________       33
     12.8    GetKeywordSimpleSearchResults_CF_______________________________________________        34
 13         Postcode.aspx ____________________________________________________________ 34
     13.1    Page_Load Method _____________________________________________________________ 35
     13.2    LocalizeDetails Method __________________________________________________________ 35
     13.3    Postcode.xslt___________________________________________________________________ 35
 14         AtoZcontacts.aspx ________________________________________________________ 37
                                             Page 2
                         Online Directories – Technical Specification
 14.1    Page_Load Method _____________________________________________________________          37
 14.2    LocalizeDetails _________________________________________________________________       37
 14.3    DrawAtoZ ____________________________________________________________________           37
 14.4    AtoZcontacts.xslt _______________________________________________________________       38
15      LBIDirectoryPage.cs ______________________________________________________ 38
 15.1    TransformSource _______________________________________________________________         38
 15.2    Directory _____________________________________________________________________         38
 15.3    ContentTransformFileName _______________________________________________________        38
 15.4    ContentFileLocation _____________________________________________________________       38
 15.5    TableNameRepeating ____________________________________________________________         38
 15.6    TableNameSingle _______________________________________________________________         38
 15.7    dirTitle _______________________________________________________________________        38
 15.8    OutputMode ___________________________________________________________________          39
 15.9    getStyleSheets _________________________________________________________________        39
 15.10      SQLQuery __________________________________________________________________          39
 15.11      AvailableSearchCriteriaNodeIterator ______________________________________________   39
 15.12      TransformXML ______________________________________________________________          39
 15.13      AddAvailableSearchCriteriaToArgList ____________________________________________     40
 15.14      AddRequestParametersToArgList ________________________________________________       40
 15.15      AddSearchCriteria ____________________________________________________________       40
 15.16      readFileText _________________________________________________________________       40
 15.17      initialiseMemberVars __________________________________________________________      40
 15.18      getSubDocumentsAsXML ______________________________________________________          41
 15.19      getSubFoldersAsXML _________________________________________________________         41
 15.20      getNestedSubFoldersAsXML ___________________________________________________         41
 15.21      getFilteredDirectoryClause _____________________________________________________     41
 15.22      getSQLResultsAsXML ________________________________________________________          42
 15.23      getAtoZqueryAsXML _________________________________________________________          42
 15.24      getAtoZcontactsAsXML _______________________________________________________         42
 15.25      getFAQlinksAsXML __________________________________________________________          42
 15.26      getPostCodeAsXML __________________________________________________________          42
 15.27      getContentFilePath ____________________________________________________________      43
 15.28      getFolderPath ________________________________________________________________       43
16      Utility.cs ________________________________________________________________ 43
 16.1    CreateChildElement _____________________________________________________________ 43
 16.2    CreateDocumentWithRootNode ___________________________________________________ 43
 16.3    EscapeSqlString ________________________________________________________________ 43
17      SQL Server Database _____________________________________________________ 44
18      How to add a new directory ________________________________________________ 46
19      APPENDIX______________________________________________________________ 49
A.      Children’s Content Page ___________________________________________________ 49
B.      FAQ Content Page ________________________________________________________ 54
C.      Local Services and Council Services Content Page _____________________________ 59




                                            Page 3
                             Online Directories – Technical Specification


1     Introduction
This document is intended to outline the technical design of the Online Directories

Online Directories is a web application that brings together all the contact information for people living,
visiting or working in Islington. It has been developed as an intranet application used by the Contact
Islington team and it also part of their www.islington.gov.uk web site.

This document is a technical document explaining how online directories work. It is to assist the
developers who will support the application. It will also explain how to add a new directory to the
current system.

This document will not cover a detail technical design for documentum.




                                                  Page 4
                                  Online Directories – Technical Specification


2     Overview of Technical Design
The solution that has been designed for online directories uses documentum, c# web pages and a sql
server database. All the data used in online directories resides in documentum. The following
diagram illustrates how the data in documentum is updated and published.

2.1     Documentum


                                                                                                                                    SQL Server
                                                                                                                                   2000 Intranet
                                                                                                                                     Database
                                                                                                             nt
                                                                                           me
                                                                                        cu
                                                                                    do
                                                                                h es rties
                                                                         b l i s ro p e
                                                                      pu        p
                                                                   m and
                                                                ntu s
                                                              me ation
                                                           cu
                                                         Do loc


                                                              Documentum publishes document                                                   SQL Server
                                                                  locations and properties                                                   2000 Internet
      User creates, updates                                                                                                                    Database
           documents
                              Documentum
                               documents            D o cu
                                                             mentu
                                                                     m pu
                                                                               blish
                                                                                       es xm
                                                                                               l files
                                                                                                                    Pub
                                                                                                                        l   ishe
                                                        Do                                                                         s In
                                                             cu                                                                           dex
                                                                m   en                                                                       ing
                                                                         tum                   Internet Server
                                           Documentum                          pu
                                                                                    blis
                                                                                        he
                                                                                             sx                                       e   xi n g
                                                                                               ml
                                                                                                                             es   Ind
                                                                                                    file                lish
                                                                                                         s
                                                                                                                  Pub                          APR Smartlogics
                                                                                                                                                   Server


                                                                                                Inttranet Server




                                                    Page 5
                                              Online Directories – Technical Specification

The xml files and database published by documentum is then used by the c# online directories code to
produce the web pages for the online directories. The diagrams below show the flow of the code.

2.2       Internet Diagram
                                                                 Default.htm


                                                       Select Directory




        Directory = Local
                                      Directory = children’s Directory
            Services                                                                                       Directory = FAQ              Directory = Council Services

                    1                                    2                                                     3                                  4
          Execute sp                       Execute sp                                                         Execute sp                       Execute sp
   local_services_homepage            sp_getHomePageData                                                 AtoZquery_faq_details          AtoZquery_council_services




             Webcontrol ‘xmlHomePageControl‘
             Transforms returned xml data using
                  DirectoryHomePage.xslt                         Select A-Z           Execute sp
                                                                                 AtoZquery_<directory>
                                                                                                                            Webcontrol Transforms
                                                                                                                            returned xml data using
                           Display
                                                                                                                                   AtoZ.xslt
                  DirectoryHomePage.aspx                Select 123                 Execute sp
                 Select Folder                                            AtoZquery_<directory>_numeric


                                                                                                                                   Display
                                                                                         Select Search                            AtoZ.aspx
                        Execute sp getFolderContents

                                              No records returned from sp                                          Select               Select Page
           records returned
                                                                                                                   Search



                                                   Execute sp
       Webcontrol ‘xmlPagesControl‘
                                              sp_getHomePageData
       Transforms returned xml data
       using SectionPagePages.xslt

                                                                                                    Go To Pages 8
                                                    Webcontrol
                                                                                                   and 9 to show flow
                                            ‘xmlOtherSectionsControl‘
                                                                                                      of code for
                                          Transforms returned xml data
                                                                                                       searching
                                                      using
                                             SectionPageSections.xslt




                    Display SectionPage.aspx


                                                        Select folder
                     Select page

                                                                                                                         5


                                                                                                                            Execute sp
                                                                                                                        getContentFilePath




                     Select Print All                                                                                 Execute sp FAQLinks
      (only available for the Children’s Directory)


                                                                                                                       Webcontrol ‘xmlPage‘
                 Execute sp                 Execute sp                     Create one xml file
                                                                                                               Transforms returned xml data using
                GetFolderPath            GetFolderContents                containing the results
                                                                                                               <directory_name> _contentPage.xslt



         <directory> = ‘Childrensdirectory’
                        ‘faq_details’
                                                                                                                        Display Page.aspx
                        ‘local_services’
                        ‘council_services’




                                                                               Page 6
                                 Online Directories – Technical Specification




2.3      Intranet Diagram
                                                    Default.htm

                                 User selects an option




                                                                                                                                      Keyword
 Local Services   Children’s              Ask Islington FAQs                                                   Ask Isington            Search
    (Quest)       Directory              (view old description)                                                  FAQ’s




   Go to 1
 on Internet      Go to 2 on Internet Diagram
  Diagram
                                                                                                                                     Go to 4
                                                                                                                                   on Internet
                                                                                                                                    Diagram



                                                           Postcode Search                                             Go to 3
                                                                                     Service Contact search
                                                                                                                     on Internet
                                                                                         by service type
                                                                                                                      Diagram



                    Execute sp                             Execute sp
                                                                                           Execute sp AtoZcontacts
                    postcodes                        postcode_service_area




                                                      Webcontrol ‘xmlPage‘                      Webcontrol ‘xmlAtoZ‘
                                                Transforms returned xml data using          Transforms returned xml data
                                                          postcode.xslt                        using AtoZcontacts.xslt




                                  Select a letter            Display                              Display
                                                          postcode.aspx                      AtoZcontacts.aspx



                                                                                                Select Page




                                                                                                   Go to 5
                                                                                                 on Internet
                                                                                                  Diagram




                                                              Page 7
                                      Online Directories – Technical Specification

2.4   Keyword Search, Print All and Export all to CSV Diagram


                                                           Directoryhomepage.aspx Loaded




                                                                   Select Keyword
                                                                       Search




                                                                     Execute SP
                                                                 SimpleKeyword_<dir>




                                                                                                                     Outputmode = xml
                                                                  With returned data
                                                                  Create a class of
                                                                   SearchResults
                                                                                             Outputmode = print


                                              Outputmode = xml
      Webcontrol ‘xmlPagesControl‘                                                                                              Select Export
       Transforms xml data using                                                                       Select Print ALL
                                                                    Create an xml                                                All to CSV
             CSVexport.xsl                                         document from
                                                                  SearchResults.cs
                                         Outputmode = print


             Webcontrol ‘xmlPagesControl‘                        Outputmode = screen
              Transforms xml data using
             <directory>_ContentPage.xslt


                                                            Webcontrol ‘xmlPagesControl‘
                                                         Transforms xml data using search.xslt




                    Display results in
                      new window


                                                                 Display search.aspx



         <dir> = ‘CF’ if in Children’s Directory’
                  ‘FAQ’ if in FAQ
                  ‘LS’ if in Local Services
                  ‘CS’ if in Council Services

         <directory> = ‘Childrensdirectory’
                        ‘faq_details’
                        ‘local_services’
                        ‘council_services’




                                                                  Page 8
                                         Online Directories – Technical Specification

2.5    Advanced Keyword Search, Print All and Export all to CSV Diagram



                                                       Children's                                    Local Services
                                                       Directory                                       Directory




                                                  Execute SP’s:                                       Execute SP’s:
                                        1. CFKeywordsLookup                                 1. CFKeywordsLookup
                                        2. CFCatchmentAreaLookup                            2. Local_services_collections
                                        3. Severity_Level                                   3. postal_district




                                                 Directoryhomepage.aspx Loaded



                                                                          Select Advanced
                                                                          Keyword Search




                                                                        Outputmode = screen



                                                                             Execute SP
                                                                       <dir>_KeywordSearchFull




                                                                                                                              Outputmode = xml
                                                                          With returned data
                                                                          Create a class of
                                                                           SearchResults
                                                                                                     Outputmode = print


                                                    Outputmode = xml
          Webcontrol ‘xmlPagesControl‘                                                                                                   Select Export
           Transforms xml data using                                                                            Select Print ALL
                                                                            Create an xml                                                 All to CSV
                 CSVexport.xsl                                             document from
                                                                          SearchResults.cs
                                                 Outputmode = print


                   Webcontrol ‘xmlPagesControl‘                         Outputmode = screen
                    Transforms xml data using
                   <directory>_ContentPage.xslt


                                                                   Webcontrol ‘xmlPagesControl‘
                                                                Transforms xml data using search.xslt




                          Display results in
                            new window


                                                                         Display search.aspx



      <dir> = ‘CF’ if in Children’s Directory’
               ‘FAQ’ if in FAQ
               ‘LS’ if in Local Services
               ‘CS’ if in Council Services

      <directory> = ‘Childrensdirectory’
                     ‘faq_details’
                     ‘local_services’
                     ‘council_services’




                                                                         Page 9
                            Online Directories – Technical Specification

2.6    Freetext and Advanced Freetext search diagram

                         Directoryhomepage.aspx Loaded




                 Select Freetext                                       Select Advanced
                     Search                                            Freetext Search




           Run Query on semaphorserver                     Display Advanced Search Box on semaphorserver




semaphoreserver.exe?DB=<directory>_directory                semaphoreserver.exe?FILE=search
                       &Stype=SIMPLE                                  &SAVEDB=<directory>_directory
                       &ORGANISE_CODED=%3AF9                          &SAVEORGANISE_CODED=:F9
                       &QUERY00=<user’s query>



                                                      Run Query on semaphorserver




                                             Display list of
                                         documents that match
                                           the search criteria



                                            Select Page



                                               Go to
                                             on Internet
                                              Diagram




                                                 Page 10
                                                                 Online Directories – Technical Specification

3      Web Config File
Below is an explanation of the <appSettings> web config settings:

Web Setting                                                                                 What is it?
<add key="dbConnection" value="Data Source=webcontsql\sqla;Initial                          Database Connection where ‘$userid’ and ‘$password’ are the logon details for
Catalog=WebsiteDirectories_Staging;uid=$userid;password=$password;Pooling=True"/>           the database.
<add key="content_internet" value="http://www.islington.gov.uk/directories/content"/>       The location of the published documentum files used in the internet

<add key="content_intranet" value="http://www.islington.gov.uk/directories/content"/>       The location of the published documentum files used in the intranet

<add key="intranet" value="false"/>                                                         Used to determine whether the solution is running the intranet solution or the
                                                                                            internet. Set value ‘true’ for intranet and ‘false’ for internet
<add key="httpAddress" value=" http://www.islington.gov.uk/directories/"/>                  The web address.

<add key="childrensdirectory" value="/Childrens/"/>                                         Location of the content files for each directory.
<add key="council_services" value="/CouncilServices/"/>
<add key="local_services" value="/LocalServices/"/>
<add key="faq_details" value="/FAQs/"/>

<add key="dctm_childrensdirectory" value="/ChildrensDirectory"/>                            Location of the APR Indexing files for each directory.
<add key="dctm_council_services" value="/Council Services"/>
<add key="dctm_local_services" value="/Local Services/Categories"/>
<add key="dctm_faq_details" value="/FAQs"/>

<add key="email_error_msg_to" value="user@islington.gov.uk"/>                               Email address of who to send the email to of an error occurs when trying to
                                                                                            display one of the documentum xml content pages
<add key="email_error_msg_from" value="user@islington.gov.uk"/>                             From Email address for the error email

<add key="email_error_msg_Server" value="localhost"/>                                       The name of the SMTP Server




                                                                                        Page 11
                             Online Directories – Technical Specification


4     Internet and Intranet look and feel
The Online Directories solution uses xslt stylesheets and css files to present the data. All pages on
the Internet have a 3 column ‘look and feel’, see below. The xslt stylesheets use templates, the
names in the red boxes below are the xslt templates defined in the shared.xslt.




The data populated from documentum xml files resides in column 2.

There is one exception to the above rule the children’s directory home page has a 2 column ‘look and
feel’, it does not have the ‘RightMenu’.

The Intranet look and feel is shown below:
(The names in the red boxes are the xslt templates in the shared.xslt.)




                                                Page 12
                             Online Directories – Technical Specification


CSS files are used to define the look and feel:

                     CSS Name      Description                       Intranet/Internet?
                     Default.css   Islington web site css            Internet
                     Search.css    Online dirctories css             Internet
                     Print.css     Printing styles                   Both
                     Intranet.cc   Intranet online directories css   Intranet

The CSS settings are specified in an application variable to reduce the system resources from having
to reload the information every page visit.

1. InternetHeader.txt – internet settings
2. IntranetHeader.txt – intranet settings

If there are any changes to the CSS files, you will need to modify the ‘Web.config’ file to force
the settings to be reloaded for the changes to appear.

The Intranet & Intranet xslt share numerous xslt templates, these are either in:
      Shared.xslt – contains templates that are shared by all directories, intranet and internet
         versions.
      Shared_Children.xslt – contains only intranet and internet Children’s directory templates.
      Shared_FAQ.xslt – contains only intranet and internet FAQ’s directory templates.
      Shared_Services.xslt – contains intranet and internet, local services and council services
         directory templates.




5       Internet Default.htm
On the Internet there are currently 4 directories on the Default.htm page:

        Directory of Local Services
             o Calls directoryhomepage.aspx with parameters:
                       dir=local_services
                       title = Directory of Local Pages

        Directory of Services
             o Calls atoz.aspx with parameters:
                       dir=council_services
                       title = Directory of Services

        Children’s Directory
             o Calls directoryhomepage.aspx with parameters:
                      dir = childrensdirectory
                      title = Childrens Directory

        Ask Islington – FAQs
            o Calls atoz.aspx with parameters:
                       dir= faq_details
                       title = Ask Islington




                                                  Page 13
                            Online Directories – Technical Specification

6       Intranet Default.htm
The Default.htm for the intranet has the following options:

        Keyword Search
            o This is a council services keyword search
            o Calls atoz.aspx, parameters:
                    dir=council_services

        Service Contact search by service type
             o Calls AtoZcontacts.aspx with no parameters

        Postcode search
            o This is a local services postcode search
            o Calls postcode.aspx with no parameters

        Ask Islington – FAQs
            o Calls atoz.aspx, parameters:
                       dir=council_services
                       title= Ask Islington – FAQs

        Ask Islington – FAQs (view old description)
            o Calls directoryhomepage.aspx, parameters:
                       dir=faq_details
                       title = Ask Islington – FAQs

        Local Services (Quest)
            o Calls directoryhomepage.aspx, parameters:
                      dir=local_services
                      title = Directory of Local Pages

        Children’s Directory
             o Calls directoryhomepage.aspx, parameters:
                      dir = childrensdirectory
                      title = Childrens Directory




                                                Page 14
                                Online Directories – Technical Specification

7      DirectoryHomePage.aspx
The directoryhomepage displays the default folder view for the following directories:
             Local Services (intranet and internet)
             Children’s Directory (intranet and internet)
             Ask Islington – FAQs (intranet only)
Each folder name displayed on the page links to the sectionpage.aspx.

Example of the Local Services Home Page:




The directoryhomepage.aspx has a webcontrol on the page that transforms the xml data returned by
the stored procedures. The xml data contains a list of folders. The webcontrol’s transform source is
the homepages.xslt. There are 2 homepages.xslt files one for the intranet and one for the internet.
The homepage also displays a directory search box on the screen (see above diagram), this is
described in detail in the section explaining the searchPage.aspx.

7.1     Page_Load Method
This method executes the directory relevant stored procedure (see below), performs the webcontrol
transformation and displays the page.


      Stored Procedure Name         Parameters         Directory                 Parameter Value(s)
      Sp_getHomePageData           @FolderPath     Children’s Directory   @FolderPath = '/ChildrensDirectory/
                                   @TableName                             @TableName = childrensdirectory_s

                                                   FAQ’s                  @FolderPath = '/FAQs'
                                                                          @TableName = faq_details_s

      Local_Services_homepage      No parameters   Local Services

Both stored procedures return an xml document that contains a list of folders and their id’s.




                                                   Page 15
                                Online Directories – Technical Specification
The page’s parameters are:

                                Name     Possible Value(s)
                                Dir      Directory name :
                                                  Childrensdirectory
                                                  local_services
                                                  council_services
                                                  faq_details
                                Title    Page Title – shown below the breadcrumb


7.2     LocalizeDetails Method
This method updates the LBIDirectory object with the current directory name and the version of the
application (Intranet or Internet).

7.3     HomePage.xslt
This xslt is used to transform the xml document created in the directoryhomepage.aspx

The returned XML will either be a list of folders (e.g. Local Services Directory) or a list of folders and
their subfolders (e.g. Children’s Directory)

Expected structure of xml document:

      <root>
           <folder ParentFolderName="{object_name}" title="{title}" i_chronicle_id="{i_chronicle_id}">
              <subFolder>
                   <subject> {subject} </subject>
                   <title> {title} </title>
                   <i_chronicle_id> {i_chronicle_id} </i_chronicle_id>
                   <object_name> {object_name} </object_name>
                   <r_object_type> {r_object_type} </r_object_type>
                   <i_full_format> {i_full_format} </i_full_format>
                   <r_folder_path> {r_folder_path} </r_folder_path>
                   <a_webc_url> {a_webc_url} <a_webc_url>
                   <r_object_id> {r_object_id} </r_object_id>
                   <i_contents_id> {i_contents_id} </i_contents_id>
                   <r_version_label> {r_version_label} </r_version_label>
                   <content_id> {content_id} </content_id>
                   <r_modify_date> {r_modify_date} </r_modify_date>
              </subFolder>
           </folder>
      </root>

The XML document can contain multiple subfolders and multiple folders.

The xslt templates in this xslt are defined in the Shared.xslt. The xslt matches on the xml root node.

The parameters passed into the xslt from the directoryhomepage.aspx are:

                  Parameter Name         Description
                  Directory              Directory Name eg. Local_Services
                  sectionhref            Empty String
                  Sectionid              Empty String
                  pageTitle              Empty string
                  dirTitle               Friendly name of directory e.g. Directory of Local Services
                  subFolder              Empty String
                  httpAddress            The website address e.g.
                                         http://www.islington.gov.uk/directories/
                  Intranet               True if intranet, false if internet
                  searchType             Empty String
                  advancedsearchref      Empty String

Note some of these parameters are empty strings but have to be declared because they are in
the shared xslt files, and the code will fall over without them.



                                                     Page 16
                             Online Directories – Technical Specification
8     SectionPage.aspx
The SectionPage.aspx either displays a list of documents or a list of folders.

The sectionpage.aspx has two web controls on the page. Only one of the controls is displayed
depending on what the user has selected on the homepage.

The ‘xmlPagesControl’ web control is displayed when a list of documents is to be displayed. Example:




The ‘xmlOtherSectionsControl’ web control is displayed when a list of folders is displayed. Example:




The xmlOtherSectionsControl is currently only used for the Children’s Directory. Unlike the other
directories the Children’s Directory can contain folders within folders.

                                                Page 17
                             Online Directories – Technical Specification

There are a couple of extra features available for the children’s directory, which are only displayed if a
list of documents are displayed (see example above for the ‘xmlPagesControl’):
       Additional search options can be executed against the returned data. The user can filter the
          data after it’s been initially loaded.
       If the returned data is a list of documents and weblinks then they can print all the documents in
          the list by pressing the ‘Print All’ button.

8.1     Page_Load Method
This method executes the relevant stored procedure and performs the web control transformation.

First time in the code always runs the stored procedure getFolderContents, it has the parameters:

                          Parameter      Value
                          @FolderPath    Folder path
                                         e.g. '/ChildrensDirectory/Services/Childcare'
                          @TableName     e.g. childrensdirectory_s

The stored procedure returns an xml string, which is loaded into a new xml document. There are two
possible scenarios

    1. The document has no data:
        Then this means that the selected folder contains folders rather than documents.
        The stored procedure sp_getHomePageData is executed with the parameters:

                          Parameter      Value
                          @FolderPath    Folder path
                                         e.g. '/ChildrensDirectory/Help/Bereavement'
                          @TableName     childrensdirectory_s

           The returned xml is transformed by the xslt SectionPageSections.xslt. There are two
            SectionPageSections.xslt’s, one for the intranet and one for the internet.


    2. The document has child nodes:
        Then this means that the selected folder contains documents.
        The returned data is transformed by the xslt SectionPagePages.xslt. There are two
          SectionPagePages.xslt’s; one for the intranet and one for the internet. A list of documents
          and weblinks (where applicable) are then displayed on the screen.
        If the user is in the Children’s Directory then the ‘Print All’ button and the additional filters
          box is displayed:




                                                 Page 18
                                 Online Directories – Technical Specification

If the user selects to filter by area or severity or both then the page is reloaded and the code runs the
stored Procedure CF_GetFilteredFolderContents with parameters:

                             Parameter                      Value
                             @ WhereClause                  sql for the filter
                             @ SingleTableName              the name of the webcache _s table
                             @RepeatingTableName            the name of the webcache _r table
                             @FolderPath                    path of folder to filter on

This returns an xml string containing the filtered documents. The returned xml is loaded into an xml
document; this document is then transformed by the xslt SectionPagePages.xslt. A list of filtered
documents and weblinks are displayed on the screen.

If the user is in the Children’s Directory and has selected the ‘Print All Contacts’ button. Then the page
is reloaded and the code calls GetExportXML. This returns an xml document containing the content
for each of the listed documents. The xml document is transformed by the xslt
ChildrensDirectory_ContentPage.xslt. There are two xslt’s one for the intranet and one of the internet.
The transformed data is displayed in a new window.


The table below shows the Page Parameters, they are not all mandatory.
Name             Value
Dir              The current directory the user is in
sectionID         Chronicle Id of the current folder the user is in
sectionTitle     Title of current folder the user is in
sectionName      Name of the previous section the user was in
Title            Directory title
subfolder        If the user is in a folder that is a child folder then set to true. Only applicable to children’s directory
Subsectionid     Only used for children’s directory, and if the user is in a child folder. It is the chronicle id of the parent folder
CatchmentArea    Catchment area to filter, only applicable to children’s directory
SeverityLevel    Severity Level to filter, only applicable to children’s directory


8.2     LocalizeDetails Method
This method is called from the page_load method and updates the LBIDirectory object with the current
directory name and the version of the application (Intranet or Internet)

8.3     GetExportXML Method
Parameter                Description
XmlDocument resultDoc    Xml document containing all the web links for the list of documents on the screen. i.e. the results
                         from the stored procedure getFolderContents

This method is called from the page_load method if the user has selected the Print All Contacts button.
The xmldocument resultDoc contains the locations of the xml documents
(//childrensdirectory_s/a_webc_url). This method opens each document’s xml and appends it to a new
xml document. The method returns the newly created document.




                                                           Page 19
                                Online Directories – Technical Specification

8.4     SectionPageSections.xslt
This xslt is used to transform the xml document created in the SecionPage.aspx, it is currently only
used for the children’s directory (intranet and internet). The returned XML will either be a list of folders
or a list of folders and their subfolders.

Expected structure of xml document:
      <root>
           <folder ParentFolderName="{object_name}" title="{title}" i_chronicle_id="{i_chronicle_id}">
              <subFolder>
                   <subject> {subject} </subject>
                   <title> {title} </title>
                   <i_chronicle_id> {i_chronicle_id} </i_chronicle_id>
                   <object_name> {object_name} </object_name>
                   <r_object_type> {r_object_type} </r_object_type>
                   <i_full_format> {i_full_format} </i_full_format>
                   <r_folder_path> {r_folder_path} </r_folder_path>
                   <a_webc_url> {a_webc_url} <a_webc_url>
                   <r_object_id> {r_object_id} </r_object_id>
                   <i_contents_id> {i_contents_id} </i_contents_id>
                   <r_version_label> {r_version_label} </r_version_label>
                   <content_id> {content_id} </content_id>
                   <r_modify_date> {r_modify_date} </r_modify_date>
              </subFolder>
           </folder>
      </root>

It can contain multiple subfolders and multiple folders.

The xslt has been written using templates. The templates can be found in the Shared.xslt. The xslt
matches on the root

The parameters passed into the xslt from the SecionPage.aspx are:

            Name                  Description
            Directory             Directory Name eg. Local_Services
            sectionName           Name of the previous section the user was in
            sectionTitle          Title of current folder the user is in
            Sectionid             ID of current folder the user is in
            Sectionhref           This is used in the navigational breadcrumb to allow the user to go back to
                                  the previous page. It is made up of the following string:
                                       sectionpage.aspx?dir=" + Directory +
                                                                "&sectionid=" + sSectionID +
                                                                "&sectionName=" + sSectionName +
                                                                "&sectionTitle=" + sSectionTitle +
                                                                "&subsectionid=" + sSubSectionid +
                                                                "&SubFolder=True" +
                                                                "&title=" + sTitle);
            Pagehref              Empty String – needed as parameter as used in the shared.xslt
            pageTitle             Empty String – needed as parameter as used in the shared.xslt
            dirTitle              Directory title
            subFolder             Set to true if the current folder is a child of another folder. Currently only
                                  used in the children’s directory
            subFolderhref         This is used in the navigational breadcrumb to allow the user to go back to
                                  the previous page. It is made up of the following string:
                                      sectionpage.aspx?dir=" + Directory +
                                                               "&sectionid=" + sSectionID +
                                                               "&sectionName=" + sSectionName +
                                                               "&sectionTitle=" + sSectionTitle +
                                                                "&title=" + sTitle
            httpAddress           The website address e.g. http://www.islington.gov.uk/directories/
            Intranet              Set to true if on the intranet, false otherwise
            searchType            Empty String – needed as parameter is used in the shared.xslt
            advancedsearchref     Empty String – needed as parameter is used in the shared.xslt




                                                       Page 20
                              Online Directories – Technical Specification


8.5     SectionPagePages.xslt
This xlst is used to transform the xml document created in the SecionPage.aspx.

The returned xml will be a list of documents. Directory Expected XML Structure:

        <root>
                  < {table_name} >
                           <object_name> {object_name} </object_name>
                           <i_chronicle_id> {i_chronicle_id} </i_chronicle_id>
                           <subject> {subject} </subject>
                           <title> {title} </title>
                           <r_object_type> {r_object_type} </r_object_type>
                           <i_full_format> { i_full_format } </i_full_format>
                           <r_folder_path> { r_folder_path } </r_folder_path>
                           <a_webc_url> { a_webc_url } </a_webc_url>
                           <r_object_id> { r_object_id } </r_object_id>
                           <i_contents_id> { i_contents_id } </i_contents_id>
                           <r_version_label> { r_version_label } </r_version_label>
                           <content_id> { content_id } </content_id>
                           <r_modify_date> { r_modify_date } </r_modify_date>
                  </ {table_name} >
        </root>

Where {table_name} is the table name that the data has come from e.g. for children’s directory it would
be childrensdirectory_s and for local services it would be local_services_s.

It will contain a {table_name} for each returned document.

The xslt has been written using templates. The templates can be found in the Shared.xslt. The xslt
matches on the root

The parameters passed into the xslt from the SecionPage.aspx are:

              Name                   Description
              directory              Directory Name eg. Local_Services
              sectionName            Name of the previous section the user was in
              sectionTitle           Title of current folder the user is in
              sectionid              ID of current folder the user is in
              Sectionhref            This is used in the navigational breadcrumb to allow the user to go
                                     back to the previous page. It is made up of the following string:

                                     sectionpage.aspx?dir=" + Directory +
                                                          "&sectionid=" + sSectionID +
                                                          "&sectionName=" + sSectionName +
                                                          "&sectionTitle=" + sSectionTitle +
                                                          "&title=" + sTitle

              Pagehref               Empty String – needed as parameter is used in the shared.xslt
              pageTitle              Empty String – needed as parameter is used in the shared.xslt
              dirTitle               Directory title
              subFolder              Set to true if the current folder is a child of another folder.
                                     Currently only used in the children’s directory.
              subFolderhref          Empty String
              subsectionid           Empty String
              httpAddress            The website address e.g. http://www.islington.gov.uk/directories/
              sectionFilter          The text displayed to the user to tell them what the current filter is.
                                     Only applicable for the children’s directory
              Intranet               True if intranet, false if internet
              CatchmentArea          The catchment area filter. Children’s Directory
              SeverityLevel          The Severity Level Filter. Children’s Directory
              searchType             Empty String – needed as parameter is used in the shared.xslt
              advancedsearchref      Empty String – needed as parameter is used in the shared.xslt
              PrintAllSQLQuery       SQL Query used to Print All Contacts, only used in the Children’s
                                     Directory
              Output                 Default is ‘Screen’, set to ‘Print’ if in the Children’s Directory and
                                     the user has seleced the ‘Print All’ button


                                                     Page 21
                              Online Directories – Technical Specification




9     Page.aspx
The page.aspx displays the contents of a document.

9.1     Page_Load Method
The code executes the stored procedure getContentFilePath with parameters:

                              Parameter           Description
                              @TableName          the name of the webcache _s table
                              @Chronicle_ID       document id


This returns a complete URL for the passed in document id. The xml document is loaded into
memory.

The stored procedure FAQLinks is executed to check to see if there are any FAQs linked to this
document. It has parameters:

                                         Parameter        Description
                                         @ContactID       Contact ID


It returns xml that contains all FAQ documents whose contacts_detail_id equals the passed in
@ContactID. The returned XML is added to the xml document that resides in memory

The page.apsx has a webcontrol on the page that transforms the xml data returned by the stored
procedures. Each directory has its own transform source:

                               Directory           Xslt name
                               Children’s          Childrensdirectory_contentpage
                               Council services    Council_services_contentpage
                               Faq_details         Faq_details_contentpage
                               Local_services      Local_services_contentpage

For each xslt there is one for the intranet and one for the internet.

See the Appendix for in depth detail for the xml mapping for the content pages.


9.2     LocalizeDetails Method
This method is called from the page_load method and updates the LBIDirectory object with the current
directory name and the version of the application (Intranet or Internet).


9.3     <DirectoryName>_ContentPage.xslt
This xslt is used to transform the xml document created in the SecionPage.aspx. There are two for
each of the directories, one for the intranet and one for the internet.

See the Appendix for the definition and more details about the xml structure.




                                                     Page 22
                              Online Directories – Technical Specification

The parameters passed into the xslt from the SecionPage.aspx are:

   Name                Description
   Directory           Directory Name eg. Local_Services
   sectionName         Section Name
   sectionTitle        Section Title
   sectionhref         This is used in the navigational breadcrumb to allow the user to go back to the previous
                       pages. It is made up of the following string:

                       If the document has come from a subfolder within the children’s directory (i.e. subFolder =
                       true) then

                                 sectionpage.aspx?dir=" + Directory +
                                           "&sectionid=" + sSectionID +
                                           "&sectionName=" + sSectionName +
                                           "&sectionTitle=" + sSectionTitle +
                                           "&title=" + sTitle +
                                           "&SubFolder=True" +
                                           "&subsectionid=" + sSubSectionid
                       Else
                                 sectionpage.aspx?dir=" + Directory +
                                           "&sectionid=" + sSectionID +
                                           "&sectionName=" + sSectionName +
                                           "&sectionTitle=" + sSectionTitle +
                                           "&title=" + sTitle

   Pagehref            This is used in the navigational breadcrumb to allow the user to go back to the previous
                       pages. It is made up of the following string:

                       If the document has come from a subfolder within the children’s directory (i.e. subFolder =
                       true) then

                                   page.aspx?dir=" + Directory +
                                           "&docid=" + sChronicleID +
                                           "&sectionid=" + sSectionID +
                                           "&sectionName=" + sSectionName +
                                           "&sectionTitle=" + sSectionTitle +
                                           "&title=" + sTitle +
                                           "&subFolder=True"

                       Else
                                      page.aspx?dir=" + Directory +
                                                "&docid=" + sChronicleID +
                                                 "&sectionid=" + sSectionID +
                                                 "&sectionName=" + sSectionName +
                                                 "&sectionTitle=" + sSectionTitle +
                                                 "&title=" + sTitle
   pageTitle           The page title
   dirTitle            Directory Title
   subFolder           Set to true if the current folder is a child of another folder. Currently only used in the
                       children’s directory.
   Intranet            True if intranet, false if internet
   httpAddress         The website address e.g. http://www.islington.gov.uk/directories/
   xmlContent          Location of the xml page
   ChronicleID         Unique id for the document
   searchType
   advancedsearchref
   Output
   subFolderhref       This is used in the navigational breadcrumb to allow the user to go back to the previous
                       pages. It is made up of the following string:

                       If the document has come from a subfolder within the children’s directory (i.e. subFolder =
                       true) then

                                  sectionpage.aspx?dir=" + Directory +
                                               "&sectionid=" + sSubSectionid +
                                               "&sectionName=" + sTemp[0] +
                                               "&sectionTitle=" + sTemp[1] +
                                               "&title=" + sTitle




                                                     Page 23
                               Online Directories – Technical Specification

10 AtoZ.aspx
The AtoZ page displays all documents for a particular directory in either alphabetical or numerical
order.

The AtoZ navigation bar (see below) is currently on all the directory home pages.




The user can also select                    from the                               Menu on the Left Hand
Side. If they select this they will be shown a directory listing filtered by the letter ‘A’.

10.1 Page_Load Method
This method executes the stored procedure and displays the returned transformed data. The pages
parameters are:

                               Parameter         Description
                               Dir               The current directory the user is in
                               Letter            The selected letter, defaulted to ‘A’
                               Title             Directory title


Stored Procedures return the data in an xml format. The xml data is transformed by AtoZ.xslt. There
are two AtoZ.xslt files one for the intranet and one for the internet.

        Stored Procedure Name                  Parameters                                    Directory
        atozQuery_childrensdirectory_numeric   None                                          Children’s
        atozQuery_childrensdirectory           @Letter – letter to filter the documents on   Children’s
        atozQuery_council_services_numeric     None                                          Council Services
        atozQuery_council_services             @Letter – letter to filter the documents on   Council Services
        atozQuery_local_services_numeric       None                                          Local Services
        atozQuery_local_services               @Letter – letter to filter the documents on   Local Services
        atozQuery_faq_details_numeric          None                                          FAQ
        atozQuery_faq_details                  @Letter – letter to filter the documents on   FAQ


10.2 LocalizeDetails Method
This method is called from the page_load method and updates the LBIDirectory object with the current
directory name and the version of the application (Intranet or Internet)

10.3 drawAtoZ Method
A method that writes the A-Z list to the ASPX page. i.e.




                                                    Page 24
                             Online Directories – Technical Specification

10.4 AtoZ.xslt
This xslt is used to transform the xml document created in the AtoZ.aspx. The returned xml is a list of
documents that start with a particular letter

Expected XML Structure for Council Services, Local Services and Children’s Directory:

             <root>
                  < {table_name} >
                        <PID></PID>
                        <Title> </Title>
                  </ {table_name} >
             </root>

Where {table_name} is:

       council_services_s for council services directory
       local_sercices_s for local services directory
       childrensdirectory_s for children’s directory

It will contain a {table_name} for each returned document.

Expected XML Structure for FAQ directory:

             <root>
                <lgsl>
                    <Title> {vchServiceType} </Title>
                   <faq>
                         <PID> {i_chronicle_id} </PID>
                         <title> {title} </title>
                 </faq>
                </lgsl>
             </root>

The AtoZ for FAQ’s are displayed differently from the other directories:




                                                Page 25
                              Online Directories – Technical Specification

11 Search.aspx
Directory searching is available in the following areas:
1. On all the home pages (intranet & internet).
2. On the internet it is also available by selecting                      from the
    Menu on the Left Hand Side.

Currently there are 4 types of searching available:
             Keyword
             Advanced Keyword
             Freetext
             Advanced Freetext (not available on the intranet)

The search results returns up to 20 records at a time. (Note this can be changed by changing the
value of the variable maxRowCount in the function page_load.)

The results are displayed in the following format:

              Search Results: <start page> – <end page> of <total> documents returned

Where:
 <start page> is the variable iStartPage in the code and first time in defaults to 1
 <end page> is the variable iLastPageCount in the code and first time in defaults to 20
 <total> is the variable total in the code and is the total number of records returned from the search.

Example:

The search navigator takes the format of


If the user presses the next button then it will take them to the next page in the list, which in the
example above would be 11:




The selected page is black and in bold. (In the code the variable for the currently selected page is
iSelectedPage, default is 1)

Each page hyperlink is linked to the searchpage.aspx

                               Parameter     Description
                             dir             the current directory
                             title           The document title
                             searchType      Search type i.e. Keyword or Advanced
                             selectedPage    The current selected page
                             startPage       The current navigational start page
                             lastPageCount   startpage + 9

Example:


If the user selected page 13, then the searchpage.aspx hyperlink for page 13 would contain the
following parameters:
                  selectedPage = 13
                  startPage = 11
                  lastPageCount = 20

The code in the search.aspx is only used for the Keyword and Advanced Keyword searches.


                                                  Page 26
                            Online Directories – Technical Specification
The search code is also executed when a user selects either the buttons ‘Print all Contacts’ or ‘Export
contacts to Excel’.

11.1 Page_Load Method
This method runs the relevant stored procedures and either:
      When the user selects ‘Go’ displays a list of documents that match the search criteria: See
        Example Below:




       When the user has selected ‘Print All Contacts’ displays in a new window the contents of the
        documents that match the search criteria. See Example below:




       When the user has selected ‘Export contacts to Excel’, creates a csv file containing the
        content search results, displays all the document results in a separate window. See Example
        below:




                                                Page 27
                               Online Directories – Technical Specification
The parameter ‘output’ defines which mode the user is in. See possible scenarios below. All output
modes use the same stored procedures to return the data in an xml format. The xml data is then
processed by the SearchResultsDAL.aspx. The resulting xml data is then transformed by the xslt to
be displayed on the screen.

           Action                                               Output       Xslt
           Performed a search (keyword or Advanced Keyword)     Screen       searchPage.xslt
           Selected ‘Print all Contacts’                        Print        <directory>_ContentPage.xslt
           Selected ‘Export contacts to Excel’                  xml          CSVexport.xsl
                                             <directory> - name of directory e.g. childrensdirectory

There are two files for each of the searchPage and <directory>_ContentPage xslt’s, one for the intranet and one
for the internet.

Keyword Search
Keyword search is the default search and is available to all the directories on their home pages.




(The above diagram is taken from the internet version. The intranet version does not have ‘Advanced
Freetext’ but the rest is the same.)

The page parameters required for this keyword search are:

                             Name           Possible Value(s)
                             dir            Directory name :
                                                     Childrensdirectory
                                                     local_services
                                                     council_services
                                                     faq_details
                             title          Page Title – shown below the breadcrumb
                             searchType     Keyword
                             Keyword        user’s keyword data that they have entered
                             searchTitle    User’s search title that they have entered

Depending on which directory the user is in then the relevant stored procedure is ran (see below). The
stored procedures return xml that is then transformed by either the internet or intranet search.xslt and
the results are displayed on the screen.

             Stored Procedure Name             Parameters                                Directory
             SimpleKeywordSearch_CF            @Title - entered keyword data             Children’s
             SimpleKeywordSearch_FAQ           @Title - entered keyword data             FAQ
             SimpleKeywordSearch_LS            @Title - entered keyword data             Local Services
             SimpleKeywordSearch_CS            @Title - entered keyword data             Council Services




                                                     Page 28
                               Online Directories – Technical Specification

Advanced Keyword Search
Advanced Keyword search is currently only available to the Local Services Directory and the children’s
Directory.

Local Services Directory Advanced Keyword Search




(The above diagram is taken from the internet version. The intranet version does not have ‘Advanced Freetext’
but the rest is the same. )

The multi select lists are populated by the following stored procedures; these lists are populated in
LBIDirectoryPAge.cs method availableSearchCriteriaNodeIterator.

        Type              Sp name                         Parameters
        Keywords          CFkeywordsLookup                @dirName – directory name i.e. LocalServices
        Collections       Local_Services_Collections      None
        Postal District   postal_district                 None



The Search page parameters required for this keyword search are:

                            Name               Value(s)
                            dir                local_services
                            title              Page Title – shown below the breadcrumb
                            searchType         Advanced
                            searchTitle        search title that has been entered
                            SeeAlso            keyword(s) that have been selected
                            Collections        Collection(s) that have been selected
                            PostalDistrict     PostalDistrict(s) that have been selected
                            searchAdvanced     Go

The code runs the stored procedure LS_KeywordSearchFull with parameters @Title, @Keywords,
@PostalDistrict, @Collections. The stored procedures return xml that is then transformed by either
the internet or intranet search.xslt and the results are displayed on the screen.




                                                       Page 29
                               Online Directories – Technical Specification

Children’s Directory Advanced Keyword Search




(The above diagram is taken from the internet version. The intranet version does not have ‘Advanced Freetext’
but the rest is the same. )

The multi select lists are populated by the following stored procedures; these lists are populated in
LBIDirectoryPAge.cs method availableSearchCriteriaNodeIterator.

          Type              Sp name                        Parameters
          Keywords          CFkeywordsLookup               @dirName – directory name i.e. ChildrensDirectory
          Catchment Area    CFCatchmentAreaLookup          None
          Severity Level    severity_level                 None



The Search page parameters required for this keyword search are:

                           Name                 Value(s)
                           dir                  Childrensdirectory
                           title                Page Title – shown below the breadcrumb
                           searchType           Advanced
                           searchTitle          search title that has been entered
                           SeeAlso              keyword(s) that have been selected
                           CatchmentArea        Catchment Area(s) that have been selected
                           SeverityLevel        Severity Level(s) that have been selected
                           searchAdvanced       Go



The code runs the stored procedure CF_KeywordSearchFull with parameters @Title, @Keywords,
@Catchment, @SeverityLevel. The stored procedures return xml that is then transformed by either
the internet or intranet search.xslt and the results are displayed on the screen.

11.2 GetExportXML Method

Parameter               Description
XmlDocument resultDoc   Xml document containing all the web links for the list of documents on the screen. i.e. the results
                        from the stored procedure getFolderContents

This method is called from the page_load method if the user has selected the ‘Print All’ method. The
xmldocument resultDoc contains the locations of the xml documents childrensdirectory_s/a_webc_url).
This method opens each document and appends it to a new xml document. The method returns the
newly created document.

                                                       Page 30
                            Online Directories – Technical Specification

11.3 LocalizeDetails Method
This method is called from the page_load method and updates the LBIDirectory object with the current
directory name and the version of the application (Intranet or Internet)

11.4 SearchPage.xslt
   Name                Value(s)
   Directory           Directory name
   sectionName         Set to ‘section name’
   sectionTitle        Set to ‘section title’
   Sectionid           ID of current folder the user is in
   Sectionhref         Empty string – needed is parameter as used in the shared.xslt
   Pagehref            Empty string – needed is parameter as used in the shared.xslt
   pageTitle           Title of page
   dirTitle            Friendly name of directory e.g. Directory of Local Services
   subfolder           Set to true if the current folder is a child of another folder. Currently only used in the children’s
                       directory
   subFolderhref       This is used in the navigational breadcrumb to allow the user to go back to the previous page.
   httpAddress         The website address e.g. http://www.islington.gov.uk/directories/
   Intranet            Set to true if on the intranet, false otherwise
   searchResults       Xml document containing the results, it has the format:
                       <SearchResults>
                         <result Title="{title}"
                                   ChronId="{i_chronicle_id}"
                                   URL="{wc_web_url}"
                                   Position="{position}" />
                       </SearchResults>

                       There can be more than one result

   startPage           The current navigational start page
   totalResults        The total number of results that the search returns
   selectedPage        The current selected page
   maxRowCount         The number of results to be shown.
   paramQuery          The query string used to call the page, this takes the following format for Advanced Keyword
                       Search children’s directory:
                       SearchTitle={search title}
                       SeeAlso={keywords}
                       &CatchmentArea={catchment area}
                       &SeverityLevel={severity levels}

                       And takes the following format for Advanced Keyword Search children’s directory:
                       SearchTitle={search title}
                       SeeAlso={keywords}
                       &Collections={collections}
                       &PostalDistrict={postal district}

                       And takes the following format for Keyword search for all directories:
                       SearchTitle={keyword}&

   endPage             Empty String
   lastPageCount       startPage + 9
   searchType          Set to ‘Keyword’ if keyword search
                       Set to ‘Go’ if advanced keyword
   goType              For advanced Keyword Search, set to : searchAdvanced=Go
                       For simple Keyword Search, set to : searchSimple=Go

   Advancedsearchref   Empty String
   keyword             User’s keyword data that they have entered on the simple keyword search




                                                      Page 31
                                Online Directories – Technical Specification

12 SearchResultsDAL.aspx

The functions in SearchResultsDAL class run the stored procedures for the keyword search and
Advanced Keyword Search. These functions return the searchResults class containing the results of
the searches.


12.1 CF_NumberOfKeywordSearchResults
This function returns the number of results for an advanced keyword search for the children's
directory. It has the following paramters:

           Parameter          Description
         sSearchTitle         search title to search - looks in the document title for documents that contain the
                              search title
         sKeyword             a comma delimited list of keywords
         sCatchmentLevel      a comma delimited list of catchment areas
         sSeverityLevel       a comma delimited lists of serverity levels

The function runs the stored procedure CF_NumberOfKeywordSearchResults. The stored procedure
uses the function parameters Title, Keywords, Catchment and Severity Levels. The stored procedure
returns the number of records that contain the @Title in the column title in the childrensdirectory_s
table.




12.2 CF_SimpleNumberOfKeywordSearchResults
This functon returns the number of results for a keyword search for the children's directory. It has one
parameter; sSearchTitle – the text to look for in the document title.

The function runs the stored procedure: CF_NumberOfSimpleKeywordSearchResults , its uses the
function parameter title. The stored procedure returns the number of records that contain the @Title in
the column title in the childrensdirectory_s table.

12.3 GetSearchResults_CF
This function returns the results of the advanced keyword search for the children's directory. It has the
following paramters:

             Parameter          Description
          maximumRows           maximum number of records to return, or any negative number for unrestricted
          selectedPageIndex     Selected page number
          sSearchTitle          search title to search - looks in the document title for documents that contain the
                                search title
          sCatchmentLevel       a comma delimited list of catchment areas
          sKeyword              a comma delimited list of keywords
          sSeverityLevel        a comma delimited lists of serverity levels
          Directory             Directory Name
          recordCount           returns number of records returned from the query

The function runs the stored procedure CF_KeywordSearchFull with the parameters:

             Parameter          Description
          SearchTitle           search title to search - looks in the document title for documents that contain the
                                search title
          Keyword               a comma delimited list of keywords
          CatchmentLevel        a comma delimited list of catchment areas
          SeverityLevel         a comma delimited lists of serverity levels


                                                         Page 32
                                 Online Directories – Technical Specification
This stored procedure returns a list of type SearchResult containing the results of the requested
search


12.4 ColumnEqual
This method determines the distinct rows in a datatable.

                                           Parameter        Description
                                          A                 A - Object to compare
                                          B                 B - Object to compare

Return true/false depending on whether or not the objects match each other</returns>

12.5 SelectDistinct
This function determines how many distinct rows exist in a datatable.

                                           Parameter        Description
                                          TableName         Table Name
                                          SourceTable       Source Table
                                          FieldName         Field Name




12.6 GetSearchResults_LS
This function returns the results of the advanced keyword search for the local service's directory. It
has the following parameters:

              Parameter          Description
          maximumRows            maximum number of records to return, or any negative number for unrestricted
          selectedPageIndex      Selected page number
          sSearchTitle           search title to search - looks in the document title for documents that contain the
                                 search title
          sPostalDistrict        comma delimited list of postcode districts
          sKeyword               a comma delimited list of keywords
          sCollections           a comma delimited lists collections
          Directory              Directory Name
          recordCount            returns number of records returned from the query



The function runs the stored procedure LS_KeywordSearchFull with the parameters:

       Parameter       Description
      Title            search title to search - looks in the document title for documents that contain the search title
      Keywords         a comma delimited list of keywords
      PostalDistrict   a comma delimited list of postal districts
      Collections      a comma delimited lists of collections

This stored procedure returns a list of type SearchResult containing the results of the requested
search.

12.7 GetKeywordSimpleSearchResults
This function returns the results of the keyword search. It has the parameters

                                                          Page 33
                               Online Directories – Technical Specification

             Parameter         Description
          maximumRows          maximum number of records to return, or any negative number for unrestricted
          selectedPageIndex    Selected page number
          sSearchTitle         search title to search - looks in the document title for documents that contain the
                               search title
          Directory            Directory Name
          recordCount          returns number of records returned from the query
          spName               Stored Procedure Name

This function runs one of the following stored procedures:

                              Stored Procedure Name             Directory
                              SimpleKeyword_CF                  Children’s Directory
                              SimpleKeyword_FAQ                 FAQ’s Directory
                              SimpleKeyword_LS                  Local Services Directory
                              SimpleKeyword_CS                  Council Services Directory

The stored procedures all have one parameter; sSearchTitle - search title to look for. The stored
procedures searchs the document title for documents that contain the search title. They return a list of
type SearchResult containing the results of the requested search.




12.8 GetKeywordSimpleSearchResults_CF
This function returns the results of the keyword search for the Children's Directory. It has the following
parameters:

             Parameter         Description
          maximumRows          maximum number of records to return, or any negative number for unrestricted
          selectedPageIndex    Selected page number
          sSearchTitle         search title to search - looks in the document title for documents that contain the
                               search title
          Directory            Directory Name
          recordCount          returns number of records returned from the query
          spName               Stored procedure name

The function runs the stored procedure: SimpleKeywordSearch_CF with one parameter; sSearchTitle
- the search title to look for. It returns a list of type SearchResult containing the results of the
requested search.


13 Postcode.aspx
The postcode.aspx page is only available on the intranet. It provides the user with a list of postcodes:




                                                        Page 34
                             Online Directories – Technical Specification
If they select a particular postcode they are shown a list of the boroughs in that postcode. For
example if the user selects SE3 they will then be shown:




13.1 Page_Load Method
This method has one page parameter - postcode.

The Postcode.aspx has one page parameter – postcode.

Depending on what the user has selected the code runs one of the following stored procedures:

        First time in, the code runs the stored procedure ‘postcode_service_areas’, this has no
         parameters and returns a list of all the available postcodes.
        When the user has selected a postcode, then the stored procedure ‘postcodes’ is run – this
         has one parameter postcode and returns a list of all boroughs in that postcode area.

13.2 LocalizeDetails Method
This method is called from the page_load method and updates the LBIDirectory object with the current
directory name and the version of the application (Intranet or Internet)




13.3 Postcode.xslt
This xslt is used to transform the xml document created in the Postcode.aspx.

The returned xml is either:
     a list of all available postcodes, this has the following xml structure

                      <root>
                         <council_services_r>
                           <service_areas>{postcode}</service_areas>
                          </council_services_r>
                      </root>

         It will have multiple <council_services_r> nodes.

        a list of boroughs in the selected postcode area, this has the following xml structure

                     <root>
                        <s>
                            <i_chronicle_id>{i_chronicle_id}</i_chronicle_id>
                            <object_name>{object_name}</object_name>
                            <title>{title}</title>
                            <a_webc_url>{a_webc_url}</a_webc_url>
                        </s>
                    </root>

         It can have multiple <s> nodes.

The xslt templates in this xslt are defined in the Shared.xslt. The xslt matches on the xml root node.

The parameters passed into the xslt from the postcode.aspx are:

                  Name          Description
                                                 Page 35
                    Online Directories – Technical Specification
directory             Directory Name eg. Local_Services
sectionName           Empty string – needs to be defined as parameter as used in the shared.xslt
sectionTitle          Empty string – needs to be defined as parameter as used in the shared.xslt
Sectionhref           Empty string – needs to be defined as parameter as used in the shared.xslt
docId                 Empty string – needs to be defined as parameter as used in the shared.xslt
pageTitle             Empty string – needs to be defined as parameter as used in the shared.xslt
dirTitle              Directory title
subFolder             Empty string – needs to be defined as parameter as used in the shared.xslt
Intranet              True if intranet, false if internet
httpAddress           The website address e.g. http://www.islington.gov.uk/directories/
searchType            Empty String – needed as parameter is used in the shared.xslt
advancedsearchref     Empty String – needed as parameter is used in the shared.xslt
Postcode              Postcode area to search on




                                          Page 36
                             Online Directories – Technical Specification

14 AtoZcontacts.aspx
The AtoZcontacts.aspx is only available on the intranet and is accessed via ‘Service Contact search by
service type.’

The AtoZcontacts page displays all folders for a particular directory in alphabetical order. First time in
it displays all the folders beginning with A. It also displays all items within that folder

Example:




14.1 Page_Load Method
The Page_Load function runs the stored procedure ‘AtoZcontacts’ with one parameter letter. First time
in 'A' is passed to the stored procedure. There after the users selected letter.

Page parameters are:

                                     Parameter     Description
                                    Title          Page Title
                                    Dir            Directory Title
                                    Letter         The letter to filter on




14.2 LocalizeDetails
This function updates the LBIdirectory object with:
      The directory name
      If the site is on the Internet or Intranet
      The title


14.3 DrawAtoZ
A method that writes the A-Z list to the ASPX page. i.e.



                                                 Page 37
                              Online Directories – Technical Specification


14.4 AtoZcontacts.xslt
This xslt is used to transform the xml document created in the AtoZcontacts.aspx.

The returned XML will be a list of service types. Displayed below is the expected xml structure:

                 <root>
                   <servicetype>
                     <Service>{service}</Service>
                     <councilcontact>
                       <ChronicleID>{chronicleID}</ChronicleID>
                       <Title>{title}</Title>
                     </councilcontact>
                   </servicetype>


It can contain multiple <councilcontact> nodes within one <servicetype> node and multiple
<servicetype> nodes.



15 LBIDirectoryPage.cs
Contains methods used by the other classes.

15.1 TransformSource
This function returns the location of the xslt that is used to transform the xml.

15.2 Directory
This function returns the current directory the user is in.

15.3 ContentTransformFileName
This function returns the xslt transformation for each content page.

15.4 ContentFileLocation
This function returns the current location of the xml file.

15.5 TableNameRepeating
This function returns the name of the webcache_r table.

15.6 TableNameSingle
This function returns the name of the webcache _s table.

15.7 dirTitle
This function returns the title for the home page directory.




                                                  Page 38
                                  Online Directories – Technical Specification

15.8 OutputMode
This function finds out what mode the user is in when on the searchpage.aspx
Used when the user performs either a keyword Search or Avanced Keyword Search.

There are three options available:
    Set to "Screen" when viewing the search results in the Browser
    Set to "xml" when exporting the search results to xml
    Set to "print" when printing all the search results.

The function returns the current Output mode.



15.9 getStyleSheets
This function loads the html links to the location of the stylesheets and javascript files.
It returns a string with the CSS & JS linking

15.10 SQLQuery
This function stores and returns the currrent SQL Statement

15.11 AvailableSearchCriteriaNodeIterator
This function gets the (cached) values to use for the advanced keyword search : as a read-only
XmlDocument.
This is suitable to pass in as a parameter to an Xslt by calling CreateNavigator() on it
The created xml document structure is:
AvailableCriteria (document element)
+- Collection(*) : attribute "value" contains value
+- Keyword(*)      : attribute "value" contains value
+- Postcode(*) : attribute "value" contains value

Depending on what directory the user is in the following stored procedures are ran:

Directory               Stored Procedure Name          Description
Local Services          CFKeywordsLookup               This sp has one paramter @dirName – the directory name.
                                                       It returns the keywords for the directory
                        Local_Services_Collections     Returns the collections
                        Postal_district                Returns the postal districts
Children’s Directory    CFKeywordsLookup               This sp has one paramter @dirName – the directory name.
                                                       It returns the keywords for the directory
                        CFCatchmentAreaLookup          Returns the cathment areas
                        severity_level                 Returns the severity levels

The returned data populates the multi-select drop down lists on the Search Frame


15.12 TransformXML
This function transforms an XML document using an XSL file. The function parameters are:

                          Parameter         Description
                       XMLdocument          An XML Document
                       XSLStylesheetPath    XSLStylesheetPath - Relative to the Applications URL path
                       ErrMsg               Returns a string that holds the error message

The function returns the transformed XML.



                                                         Page 39
                                  Online Directories – Technical Specification

15.13 AddAvailableSearchCriteriaToArgList
This function adds all the available search criteria as an argument named "AvailableSearchCriteria". It
has one parameter argList, which is the XSL argument list to add info to.


15.14 AddRequestParametersToArgList
This function gets the HTTP request parameters (including query string and posted form data)
with an XPathNodeIterator suitable for passing in as a parameter to an XSL. It has one parameter
argList, which is the XSL argument list to add info to.

15.15 AddSearchCriteria
Executes a stored procedure and then appends each result as a parameterisable XmlElement to
container xmlElement. This code currently runs the stored procedures that return data for the
Advanced Search Options multi select drop downs

                          Parameter           Description
                       sqlQuery               the name of the stored procedure to run
                       containerElement       the xml element to append the data to
                       valueElement           name of xml element to create
                       sqlColumn              name of the sqlcolumn returned in the stored procedure
                       paramValue             value of the parmeter for the stored procedure.This can
                                              contain nulls



15.16 readFileText
This function reads a file from the file system with read only access. There is only one parameter
‘path’ - this is the path to the text file. It returns the text loaded from the text file in UTF8 encoding

15.17 initialiseMemberVars
Loads the various member variables from the web.config file. The function parameters are:

                   Parameter              Description
               Directory                  this is the path to the text file
               Opensite                   Whether or not the website is running the intranet or internet version
                                          Set to true if running the intranet
               Title                      The title of the home page directory




                                                             Page 40
                                Online Directories – Technical Specification

15.18 getSubDocumentsAsXML
This function queries the SQL database to get a list of documents that are contained within a specific
folder. The folder path to use is determined by the Chronicle ID passed in. This Chronicle ID (DCTM
speak) is a unique Identifier for the folder.

This function has the following parameters:

                 Parameter       Description
               sChronicleID      A string containing the unique ID
                                 of the folder to query for contained documents
               sWhereClause      A string that is used to filter what types of
                                 documents are returned. For example Children + Families filters
               Title             The title of the home page directory



Depending on the values in the passed in parameter, this function runs one of three stored
procedures:

                  Stored Procedure               Description
          local_services_sectionpage             Runs this stored procedure if the folderpath is the same is the
                                                 passed in parameter. This will only occur when the user is in
                                                 the local services directory
          getFolderContents                      Runs this stored procedure when the passed in where clause
                                                 is not null
          CF_GetFilteredFolderContents           Runs this stored procedure when in the children’s directory
                                                 and no where clause has been passed in

The results of running the stored procedures are returned as an xml document.

15.19 getSubFoldersAsXML
This function queries the SQL database to get a list of sub folders that are contained within a specific
folder. The folder path to use is determined by the Chronicle ID passed in. This Chronicle ID (DCTM
This function returns an xml document containing the subfolders for a directory.

15.20 getNestedSubFoldersAsXML
This function queries the SQL database to get a list of either sub folders or documents
that are contained within a specific folder. The folder path to use is determined by the Chronicle ID
passed in. This Chronicle ID (DCTM speak) is a unique Identifier for the folder
This function returns an xml document containing the subfolders for a directory.

15.21 getFilteredDirectoryClause
This function builds the 'Where' part of a sql query for the children's directory, it is used if the user has
selected Additional Search Options.

                                           Parameter         Description
                                         sCatchmentArea      Catchment Area
                                         sSeverityLevel      Severity Level

This function returns a returns the ‘where’ part of the sql query as a string.




                                                       Page 41
                                Online Directories – Technical Specification

15.22 getSQLResultsAsXML
This function runs the named stored procedure, which returns an xml string. The root element is
added to the returned xml string. The parameters for this function are:

                  Parameter        Description
                  sSP              stored procedure name
                  arrParams        string array of parameters for the stored procedure, it can be empty

This function returns an xml string.


15.23 getAtoZqueryAsXML
This function runs the stored procedures that returns all douments whose title starts with a particular
letter. The parameters for this function are:

                  Parameter        Description
                  cLetter          Letter to query on
                  arrParams        string array of parameters for the stored procedure, it can be empty

It runs one of the following stored procedures depending on which directory the user is in:

                      Stored Procedure              Description
                  AtoZquery_{Directory}_numeric     Returns a list of documents for a particular
                                                    directory in numerical order
                  AtoZquery_{Directory}             Returns a list of documents for a particular
                                                    directory whose title starts with a particular letter.

              Where _{Directory} is either childrensdirectory,council_Services, faq_details or local_services

The function returns a string containing xml containing the directory documents.

15.24 getAtoZcontactsAsXML
This function runs the stored procedures AtoZcontacts that returns all douments
whose service description starts with a particular letter for the council services directory. The function
and stored procedure have one parameter cLetter; the letter to query on. The function returns a string
containing xml containing the directory documents

15.25 getFAQlinksAsXML
This function gets the associated FAQ links for a selected document. It runs the stored procedure
FAQLinks. The function and stored procedure have one parameter sChronicleID; this is a string
containing the unique ID of the folder to query for contained documents. The function returns an xml
string containing the FAQLinks

15.26 getPostCodeAsXML
This function gets a list of postcodes or services for the postcodes passed in. The function has one
parameter postcode and runs the appropriate stored procedure based on the value of this parameter:
The stored procedures are:

                      Stored Procedure              Description
                  Postcode_service_areas            This stored procedure has no parameters and
                                                    returns a list of postcode service areas
                  Postcodes                         This stored procedure has one parameter
                                                    ‘postcode’ and returns a list of services for a
                                                    particular postcode
The function returns an xml containing the list of postcodes or services.


                                                        Page 42
                              Online Directories – Technical Specification

15.27 getContentFilePath
This function returns the complete URL for a document ID. The function has one paramter
sChronicleID; the unique identifier for the document. It runs the stored procedure getContentFilePath,
which has two paramters:

                     Stored Procedure Parameter          Description
                     TableName                           The name of the webcache _s table
                     Chronicle_ID                        The unique document id



15.28 getFolderPath
This function return the folder path where the object resides for an ID for a folder/document, The
funcion has one parameter sChronicleID ; the unique identifier for the document. It runs the stored
procedure getFolderPath which has two parameters:

                     Stored Procedure Parameter          Description
                     TableName                           The name of the webcache _s table
                     Chronicle_ID                        The unique document id



16 Utility.cs
16.1 CreateChildElement
This method creates a new Xml Element as a child of an existing element. It has the following
parameters:

                    Parameter       Description
                 containerElement   Existing element to append new child to (required)
                 elementName        element's name (required)
                 elementNamespace   element's namespace - (optional, can be null)


16.2 CreateDocumentWithRootNode
This function creates a new xml document with the passed in root node. It has the following
parameters:

                        Parameter             Description
                 rootElementName              name of root element to create
                 rootElementNamespace         namespace of root element

The function returns the newly created document.


16.3 EscapeSqlString
This function returns a string suitable for use as a SQL string, by escaping all single quotes. It has one
parmater inputString; the sql string to transform. The function returns a string suitable for use as a
SQL string.




                                                   Page 43
                                 Online Directories – Technical Specification


   17 SQL Server Database
   The application uses two SQL Server databases;

           intranet database - CIDirectories_Live
           internet database - WebsiteDirectories_Live


   Documentum publishes data to these databases. The c# code accesses the code via stored
   procedures. The application currently uses the following stored procedures:


Stored Procedure Name                      Description
AtoZcontacts                               Returns xml that contains all the documents whose title starts with the
                                           letter that has been passed in. This sp is used for the council services
                                           directory.
atozQuery_childrensdirectory               Returns xml that contains all the documents whose title starts with the
atozQuery_council_services                 letter that has been passed in.
atozQuery_faq_details
atozQuery_local_services
atozQuery_childrensdirectory_numeric       Returns xml that contains all the documents whose title starts with a
atozQuery_council_services_numeric         numeric
atozQuery_faq_details_numeric
atozQuery_local_services_numeric
CF_GetFilteredFolderContents               Returns xml that contains a list of the filtered documents in a particular
                                           folder. Currently is only used for the children's directory and filters on
                                           area and/or severity level
CF_KeywordSearchFull                       Returns the results of the advanced keyword search for the children's
                                           directory
CF_NumberOfSimpleKeywordSearchResults      Returns the number of results for a keyword search for the children's
                                           directory
CFCatchmentAreaLookup                      Returns all catchment areas for children’s directory
CFKeywordsLookup                           Returns all keywords for the children’s directory
FAQLinks                                   Returns xml that contains all FAQ documents whose contacts_detail_id
                                           equals the passed in @ContactID
getContentFilePath                         returns complete url for a document
getFolderContents                          Returns xml that contains a list of all documents in a particular folder
getFolderPath                              Returns a path for a given chronicle id
KeywordSearchBuildSQL                      Called from other stored procedures to build the search sql
Local_Services_Collections                 Returns all collections for local services
Local_Services_homepage                    Returns an xml string containing a list of folders for the local services
                                           directory
Local_Services_sectionpage                 Returns xml that contains a list of the items in local_services collection.
LS_KeywordSearchFull                       Returns the results of the advanced keyword search for the local services
                                           directory
Postal_district                            Returns all postcodes areas for local services
Postcode_service_areas                     Returns xml that contains all the service_Area documents ordered by the
                                           service_areas
Postcodes                                  Returns xml that contains all the service_Area documents ordered by the
                                           service_areas
Severity_level                             Returns all severity levels for children’s Directory
simpleKeywordSearch_CF                     Returns the results of the simple keyword search for the children’s
                                           directory
simpleKeywordSearch_CS                     Returns the results of the simple keyword search for the council services
                                           directory
simpleKeywordSearch_FAQ                    Returns the results of the simple keyword search for the FAQ directory
simpleKeywordSearch_LS                     Returns the results of the simple keyword search for the local services
                                           directory
Sp_getHomePageData                         Returns the top level folders for a particular directory




                                                   Page 44
                              Online Directories – Technical Specification


Each directory has its own set of tables:

      Table Name              Description
      {directory name}_s      Contains details for every document in the directory
      {directory name}_r      Contains webcache repeated data. e.g. keywords, severity levels and the
                              aweb_c_url that they are linked to
      {directory name}_m      Contains config data

The database also contains the following tables:

      Table Name              Description
      Lgsl_pid_descriptions   Pid numbers
      WebConfiguration_s      Config settings
      WebConfiguration_m      Config settings




                                                 Page 45
                             Online Directories – Technical Specification


18 How to add a new directory
Unfortunately because the documentum templates are not generic (see appendix) then you will need
to add directory specific code to display the web pages for the new directory correctly.

Assumptions:

    a. The directory has been set up in documentum and the SQL Server tables exist for that
       directory.
    b. The home page for the new directory is going to be either the DirectoryHomePage.aspx or the
       atoz.aspx.
    c. The new directory will be available on the intranet and internet

1. Config Changes:
    a. The new locations of the directories will need to be added to the web config file. Open up the
        web.config file and add the following settings:
             <add key="{new_dir}" value="/NewDir/"/> - Location of content files for the new directory
             <add key="dctm_{new_dir}" value="/NewDir"/> - Location of APR files for the new directory

2. Update the Internet and Intranet Default.htm; add a link to the new directory
    a. On the Internet the LHS menu will need changing:




                New links will need to be added for the new directory, the code for this is located in
                the shared.xslt in the template ‘LeftMenu’, add the code to the page- navigation div.

    b. On the Intranet, the menu at the bottom of the page will need changing:



                A new link will need to be added for the new directory, the code for this is located in
                the shared.xslt in the template ‘IntranetMenu2’, add the new link.


3. DirectoryHomePage.aspx

        This code is currently used by local services and children’s directory as its home page.
        Currently the code runs different stored procedures to return the home page data. The reason
        for this is that the local services data is stored alphabetically whereas the children’s directory
        is stored by folders. You can tell which way the data is stored by looking at the
        {directory_name}_s table and the column ‘r_folder_path’. The data in r_folder path will either
        take the format:

        1. /{directory_name}/{folder_name} – use the stored procedure sp_getHomePageData
           with parameters {tablename} and {directory_name}.
        2. /{directory_name}/A – unfortunately this stored procedure has not been written
           generically, so you will have to write a new stored procedure based on the local services
           stored procedure ‘local_services_homepage’


                                                Page 46
                            Online Directories – Technical Specification
       The directoryhomepage.aspx has two parameters which you will need to pass in when called
       from the default.htm:

               Parameter              Value
               dir                    The name you gave the directory in the config file i.e.
                                      {new_dir}
               Title                  Friendly name that will be displayed on the home page

       Depending on whether or not the user is on the internet/intranet the directoryhomepage.aspx
       uses the homepage.xslt to transform the data. You will need to add directory specific code
       that shows the data on the webpage.

       For the intranet add the code directly to the homepage.aspx (ideally this code should be
       amalgamated into the shared.xslt and use the same code as the internet)

       For the internet add the code to the template ‘HomePageSectionDetails’ in the shared.xslt.


4. AtoZ.aspx

       This code is currently used as default home page for FAQs and Council Services but is
       available to all pages to allow the users to do an AtoZ search. The code runs different stored
       procedure depending on which directory the user is in. You will need to write two new stored
       procedures, which should be named in the following way:

                atozquery_{dir_name}
                atozquery_{dir_name}_numeric


       The atoz.aspx has two parameters which you will need to pass in when called from the
       default.htm:

               Parameter              Value
               dir                    The name you gave the directory in the config file i.e.
                                      {new_dir}
               Title                  Friendly name that will be displayed on the atoZ


       You will need to add directory specific code to display the data in both the intranet & internet
       atoz.xslt pages.


5. Search.aspx – Simple Keyword Searching

       If the directory only has keyword searching (like FAQ’s and council services) then you will
       need to write a new stored procedure, which should take the naming convention:

                SimpleKeywordSearch_{dir_initials}

       And will have one parameter title, which will be the passed in title.
       The code that displays the search box is located in the shared.xslt in the template ‘search.’


6. Search.aspx – Advanced Keyword Searching

       If the directory has advanced keyword searching (like Children’s Directory and Local Services)
       then you will need to use existing stored procedures or create new ones to populate the multi-
       select drop down lists on the advanced search box. You will need to add the code to the
       LBIDirectoryPage.cs function ‘AvailableSearchCriteriaNodeIterator’.




                                                Page 47
                           Online Directories – Technical Specification
      The code that displays the advanced search box is located in the shared.xslt in the templates
      ‘LS-AdvancedSearchOptions.’ and ‘CD-AdvancedSearchOptions.’ Add a new template for
      your new directory’s advanced search box.

7. SectionPage.aspx

      This page is currently used to display a list of documents or a list of folders and is called from
      the directoryhomepage.aspx. It is not used if the directory uses atoz.aspx as its home page.
      Depending on how the directory has been setup you will need to add code to either the
                SectionPageSections.xslt -- this is currently only used by the children’s directory.
                   It displays a list of folders. If your new directory contains folders within folders
                   then you will need to use this xslt to add your directory specific code.
                SectionPagePages.xslt – this is used by all directories that use this c# page and
                   displays a list of documents. You will need to add your new directory code to the
                   template ‘sectionPageDetails’ in the shared.xslt
      Changes will need to be done to both the internet and intranet files.


8. Page.aspx

      This c# page is used by all the directories; it displays the content of the documentum xml file.
      You will need to
                Create a new xslt for the internet and intranet, this should follow the naming
                  convention: {directory_name}_ContentPage.xslt
                Create a new directory specific shared.xslt in the shared folder, this should follow
                  the naming convention: Shared_{directory_name}.xslt. This will contain all the
                  templates and can then be used in both the internet and intranet contentpage.xslt
                  files.




                                               Page 48
                                                             Online Directories – Technical Specification

19 APPENDIX
A. Children’s Content Page
Content Page Data                                    XML Mapping
                                                     CHILDRENS_DETAILS \ TITLE

                                                     CHILDRENS_DETAILS \ PARENT_ORGANISATION

                                                     CHILDRENS_DETAILS \ SERVICE_DESCRIPTION




 Who is this service for?                            CHILDRENS_DETAILS \ SERVICE_IS_FOR
 Can I refer myself?                                 CHILDRENS_DETAILS \ REFER_MYSELF
 What is the procedure for referrals?                CHILDRENS_DETAILS \ REFERALS_PROCEDURE
 Is there a charge?                                  CHILDRENS_DETAILS \ CHARGE
 Is there a waiting list?                            CHILDRENS_DETAILS \ WAITING_LIST
 What other languages (other than English are        CHILDRENS_DETAILS \ OTHER_LANGUAGES_AVAILABLE
available?
 Is information shard with other agencies?           CHILDRENS_DETAILS \ IS_INFORMATION_SHARED
 Lead practitioner:                                  CHILDRENS_DETAILS \ LEAD_PRACTITIONER_NAME
 Other key members of staff:                         CHILDRENS_DETAILS \ OTHER_KEY_STAFF
 Type of Organisation:                               CHILDRENS_DETAILS \ ORGANISATIONAL_TYPE
 Other Type of Organisation:                         CHILDRENS_DETAILS \ ORGANISATIONAL_TYPE_OTHER
 How do I apply                                      CHILDRENS_DETAILS \ HOW_TO_APPLY
 ISA level of severity of need - for practitioners   CHILDRENS_DETAILS \ SVERITY_LEVEL
only:

 Opening Hours:                                      CHILDRENS_DETAILS \ OPENING_HOURS
 Address:
 <Address Line1>
 <Address Line 2>                                    CHILDRENS_DETAILS   \   ADDRESS_DETAILS\ADDRESSES\   ADDRESS   \ADDRESS_LINE_1
                                                     CHILDRENS_DETAILS   \   ADDRESS_DETAILS\ADDRESSES\   ADDRESS   \ADDRESS_LINE_2
 <Address Line 3>
                                                     CHILDRENS_DETAILS   \   ADDRESS_DETAILS\ADDRESSES\   ADDRESS   \ADDRESS_LINE_3
 <Address Line 4>
                                                     CHILDRENS_DETAILS   \   ADDRESS_DETAILS\ADDRESSES\   ADDRESS   \ADDRESS_LINE_4


                                                     CHILDRENS_DETAILS \ ADDRESS_DETAILS\ADDRESSES\ UPRN
                                                     CHILDRENS_DETAILS \ ADDRESS_DETAILS\ADDRESSES\ ADDRESS \ UPRN




                                                                                    Page 49
                                                   Online Directories – Technical Specification

Disabled Access?                           CHILDRENS_DETAILS \ ADDRESS_DETAILS\ADDRESSES\ DISABLED_ACCESS
<tel desciption>: <tel number>             CHILDRENS_DETAILS \ CONTACT_NUMBERS\ CONTACT_NUMBER \ CONTACT_NUMBER_DESCRIPTION
                                           CHILDRENS_DETAILS \ CONTACT_NUMBERS\ CONTACT_NUMBER \ CONTACT_NUMBER_TEXT

Website:                                   CHILDRENS_DETAILS \ ADDRESS_DETAILS\ WEBSITES\ WEBSITE
Email:                                     CHILDRENS_DETAILS \ ADDRESS_DETAILS\ EMAIL_ADDRESSES \ EMAIL_ADDRESS

Is there disabled access?                  CHILDRENS_DETAILS \ADDRESS_DETAILS\ADDRESSES\ DISABLED_ACCESS_ADDRESS

Main public transport links:               CHILDRENS_DETAILS \ PUBLIC_TRANSPORT_LINKS

Website:                                   CHILDRENS_DETAILS \ WEBSITE



Secondary Address
<additional address details>
                                           CHILDRENS_DETAILS \ ADDITIONAL_ADDRESSES \ ADDITIONAL_ADDRESS \ ADDITIONAL_ADDRESS_DETAILS
<additional address postode>               CHILDRENS_DETAILS \ ADDITIONAL_ADDRESSES \ ADDITIONAL_ADDRESS \ ADDITIONAL_ADDRESS_POSTCODE
                                           CHILDRENS_DETAILS \ ADDITIONAL_ADDRESSES \ UPRN

Additional public transport links:         CHILDRENS_DETAILS \ ADDITIONAL_ADDRESSES \ ADDITIONAL_ADDRESS \ ADDITIONAL_ADDRESS_PUBLIC_TRANSPORT
Tel:                                       CHILDRENS_DETAILS \ ADDITIONAL_PHONES \ ADDITIONAL_PHONE \ ADDITIONAL_PHONE_NUMBER
Fax:                                       CHILDRENS_DETAILS \ ADDITIONAL_PHONES \ ADDITIONAL_PHONE \ ADDITIONAL_FAX_NUMBER
Email:                                     CHILDRENS_DETAILS \ ADDITIONAL_PHONES \ ADDITIONAL_PHONE \ ADDITIONAL_EMAIL_NUMBER
Secondary textphone/Minicom:               CHILDRENS_DETAILS \ ADDITIONAL_PHONES \ ADDITIONAL_PHONE \ ADDITIONAL_TEXTPHONE

                                           CHILDRENS_DETAILS \ ONLINE_FORMS \ INTERNAL_ONLINE_FORMS \ INTERNAL_ONLINE_FORM \
                                           INTERNAL_ONLINE_FORM_NAME
                                           CHILDRENS_DETAILS \ ONLINE_FORMS \ INTERNAL_ONLINE_FORMS \ INTERNAL_ONLINE_FORM \ ONLINE_FORM_URL


                                           CHILDRENS_DETAILS \ RELATED_LEAFLETS \ INTERNAL_RELATED_LEAFLETS \ INTERNAL_RELATED_LEAFLET \
                                           INTERNAL_RELATED_LEAFLET _FORM_NAME
                                           CHILDRENS_DETAILS \ RELATED_LEAFLETS \ INTERNAL _RELATED_LEAFLET \ INTERNAL_RELATED_LEAFLET \
                                           RELATED_LEAFLET _FORM_URL

                                           CHILDRENS_DETAILS \ RELATED_REFERAL_FORMS \ EXTERNAL_REFERAL_FORMS \ EXTERNAL_REFERAL_FORM \
                                           EXTERNAL_REFERAL_FORM_NAME
                                           CHILDRENS_DETAILS \ RELATED_REFERAL_FORMS \ EXTERNAL_REFERAL_FORMS \ EXTERNAL_REFERAL_FORM \ EXTERNAL
                                           _REFERAL_FORM_URL



Show me more services and weblinks about   CHILDRENS_DETAILS \ ALL_KEYWORDS\ ALL_KEYWORDS_KEYWORD


Acknowledgement




                                                                         Page 50
                                                        Online Directories – Technical Specification

The table below shows which fields in the Children Content Page are displayed.
Ext = Internet web site  Int = Intranet

 XML                                                                                                                          Ext   Int   Additional Info
 CHILDRENS
 _DETAILS
             ADDRESS_DETAILS
                                     ADDRESSES                                                                                            Assumed one
                                                                 ADDRESS                                                                  address
                                                                                                 ADDRESS_LINE_1                Y    Y
                                                                                                 ADDRESS_LINE_2                Y    Y
                                                                                                 ADDRESS_LINE_3                Y    Y
                                                                                                 ADDRESS_LINE_4                Y    Y
                                                                                                 DISABLED_ACCESS               Y    Y
                                                                                                 UPRN                          Y    Y
                                     WEBSITES
                                                                 WEBSITE                                                       Y    Y
                                     CONTACT_NUMBERS
                                                                 CONTACT_NUMBER                  CONTACT_NUMBER_DESCRIPTION    Y    Y       More than one,
                                                                                                                                            can hold phone
                                                                                                 CONTACT_NUMBER_TEXT           Y    Y      and fax numbers

                                     EMAIL_ADDRESSES                                                                           Y    Y
                                                                 EMAIL_ADDRESS                                                               More than one
             ALL_KEYWORDS                                                                                                      Y    Y     Each keyword is
                                                                                                                                          displayed as a
                                     ALL_KEYWORDS_KEYWORD                                                                      Y    Y     weblink
             TITLE                                                                                                             N    N
             KEYWORDS                                                                                                          Y    Y         Meta data
             DISABLED_ACCESS_ADDR
             ESS                                                                                                               Y    Y
             PUBLIC_TRANSPORT_LINK
             S                                                                                                                 Y    Y
             PARENT_ORGANISATION                                                                                               Y    Y
             SERVICE_DESCRIPTION                                                                                               Y    Y
             SERVICE_IS_FOR                                                                                                    Y    Y
             HOW_TO_APPLY                                                                                                      Y    Y
             REFER_MYSELF                                                                                                      Y    Y
             REFERALS_PROCEDURE                                                                                                Y    Y
             WAITING_LIST                                                                                                      Y    Y
             CHARGE                                                                                                            Y    Y
             OTHER_LANGUAGES_AVAI
             LABLE                                                                                                             Y    Y



                                                                           Page 51
                                             Online Directories – Technical Specification

IS_INFORMATION_SHARED                                                                                                     Y   Y
LEAD_PRACTITIONER_NAM
E                                                                                                                         Y   Y
OTHER_KEY_STAFF
DISCLAIMER                                                                                                            N       N
ORGANISATIONAL_TYPE                                                                                                   Y       Y
ORGANISATIONAL_TYPE_O
THER
RELATED_LEAFLETS
                        EXTERNAL_RELATED_LEAFLETS                                                                                 More than one
                                                      EXTERNAL_RELATED_LEAFLET
                                                                                      EXTERNAL_RELATED_LEAFLET_NAME   Y       Y
                                                                                      EXTERNAL_RELATED_LEAFLET_URL    Y       Y
                        INTERNAL_RELATED_LEAFLETS
                                                      INTERNAL_RELATED_LEAFLET                                                    More than one
                                                                                      INTERNAL_RELATED_LEAFLET_NAME   N       Y
                                                                                      INTERNAL_RELATED_LEAFLET_URL    N       Y
RELATED_REFERAL_FORMS
                        INTERNAL_REFERAL_FORMS                                                                                    More than one
                                                      INTERNAL_REFERAL_FORM
                                                                                      INTERNAL_REFERAL_FORM_NAME      N       Y
                                                                                      INTERNAL_REFERAL_FORM_URL       N       Y
                        EXTERNAL_REFERAL_FORMS
                                                      EXTERNAL_REFERAL_FORM
                                                                                      EXTERNAL_REFERAL_FORM_NAME      Y       Y
                                                                                      EXTERNAL_REFERAL_FORM_URL       Y       Y
ONLINE_FORMS
                        INTERNAL_ONLINE_FORMS
                                                      INTERNAL_ONLINE_FORM
                                                                                       INTERNAL_ONLINE_FORM_NAME      N       Y
                        EXTERNAL_ONLINE_FORMS                                         INTERNAL_ONLINE_FORM_URL        N       Y
                                                      EXTERNAL_ONLINE_FORM
                                                                                      EXTERNAL_ONLINE_FORM_NAME       Y       Y
                                                                                      EXTERNAL_ONLINE_FORM_URL        Y       Y
ADDITIONAL_ADDRESSES
                        ADDITIONAL_ADDRESS
                                                      ADDITIONAL_ADDRESS_DETAILS                                      N       Y
                                                      ADDITIONAL_ADDRESS_POSTCODE                                     N       Y
                                                      ADDITIONAL_ADDRESS_UPRN                                         N       Y
                                                      ADDITIONAL_ADDRESS_DISABLED                                     N       Y



                                                               Page 52
                                          Online Directories – Technical Specification

                                                   ADDITIONAL_ADDRESS_PUBLIC_TRA
                                                   NSPORT                                N   Y
TELEPHONE_NUMBER                                                                         Y   Y
FAX_NUMBER                                                                               Y   Y
MINICOM_NUMBER                                                                           Y   Y
ADDITIONAL_PHONES                                                                        Y   Y
                    ADDITIONAL_PHONE                                                             More than one
                                                   ADDITIONAL_PHONE_NUMBER               Y   Y
                                                   ADDITIONAL_FAX_NUMBER                 Y   Y
                                                   ADDITIONAL_EMAIL                      Y   Y
                                                   ADDITIONAL_TEXTPHONE                  Y   Y
WEBSITE
ACKNOWLEDGEMENT                                                                          N   N
DATA_OWNER                                                                               N   N
                    DATA_OWNER_TITLE                                                     N   N
                    DATA_OWNER_NAME                                                      N   N
                    DATA_OWNER_POSITION                                                  N   N
                    DATA_OWNER_TELEPHONE                                                 N   N
                    DATA_OWNER_FAX                                                       N   N
                    DATA_OWNER_EMAIL                                                     N   N




                                                            Page 53
                                                 Online Directories – Technical Specification

B. FAQ Content Page
Below is what an FAQ Internet page looks like:                Below is what an FAQ Intranet page looks like:




                                                                   Page 54
                                           Online Directories – Technical Specification

Content Page Data           XML Mapping
                            FAQ \ QUESTION


                            FAQ \ ANSWER


                            This is an http link to the council services page.
                            Using the doc id in the xml ‘FAQ \ CONTACT_LINK’ as the linkage
Address
                            FAQ   \   ADDRESS   DETAILS   \   ADDRESS_TITLE
                            FAQ   \   ADDRESS   DETAILS   \   ADDRESSES \ ADDRESS   \   ADDRESS_LINE_1
                            FAQ   \   ADDRESS   DETAILS   \   ADDRESSES \ ADDRESS   \   ADDRESS_LINE_2
                            FAQ   \   ADDRESS   DETAILS   \   ADDRESSES \ ADDRESS   \   ADDRESS_LINE_3
                            FAQ   \   ADDRESS   DETAILS   \   ADDRESSES \ ADDRESS   \   ADDRESS_LINE_4

                            FAQ \ ADDRESS DETAILS \ ADDRESSES \ ADDRESS \ UPRN
Website:                    FAQ \ ADDRESS DETAILS \ WEBSITES \ WEBSITE
Contacts:
  1. Tel:                   FAQ \ ADDRESS DETAILS \ CONTACT_NUMBERS \ CONTACT_NUMBER_DESCRIPTION
  2. Fax:                   FAQ \ ADDRESS DETAILS \ CONTACT_NUMBERS \ CONTACT_NUMBER_TEXT

                            If no data then under contacts display the text:
                                       ‘No contact details provided’


Email:                      FAQ \ ADDRESS DETAILS \ EMAIL_ADDRESSES \ EMAIL_ADDRESS
Is there disabled access?   FAQ \ ADDRESS DETAILS \ ADDRESSES \ ADDRESS \ DISABLED_ACCESS

                            FAQ \ ONLINE_FORMS \ EXTERNAL_ONLINE_FORMS \ EXTERNAL _ONLINE_FORM \ EXTERNAL _ONLINE_FORM_NAME
                            FAQ \ ONLINE_FORMS \ EXTERNAL_ONLINE_FORMS \ EXTERNAL _ONLINE_FORM \ EXTERNAL _ONLINE_FORM_URL

                            Intranet Only
                            FAQ \ ONLINE_FORMS \ INTERNAL_ONLINE_FORMS \ INTERNAL_ONLINE_FORM_NAME
                            FAQ \ ONLINE_FORMS \ INTERNAL_ONLINE_FORMS \ INTERNAL_ONLINE_FORM_URL




                            FAQ \ REALTED_DOCUMENTS \ RELATED_DOCUMENT \ RELATED_DOCUMENT_URL
                            FAQ \ REALTED_DOCUMENTS \ RELATED_DOCUMENT \ RELATED_DOCUMENT_TITLE

                            The link to Adobe Acrobat Reader is only shown if there are related documents



                            FAQ \ LAST_MODIFIED_DATE




                                                                     Page 55
                                   Online Directories – Technical Specification


Content Page Data       XML Mapping




                        FAQ \ RELATED_WEBSITES \ INTERNAL_LINKS \ INTERNAL_LINK_URL
                        FAQ \ RELATED_WEBSITES \ INTERNAL_LINKS \ INTERNAL_LINK_NAME


<Related Web Link(s)>




                                                      Page 56
                                                               Online Directories – Technical Specification



XML                                                                                                    Int    Ext   Extra Info
FAQ   QUESTION                                                                                         Y      Y
      ANSWER                                                                                           Y      Y
      TITLE                                                                                            N      N     this is the same as the FAQ/Question
      LAST_MODIFIED_DATE                                                                               Y      Y
      CONTACT_LINK                                                                                     Y      Y     Web links
      ADDRESS_DETAILS        ADDRESS_TITLE                                                             Y      Y     There is only one address
                             ADDRESSES             ADDRESS    ADDRESS_LINE_1                           Y      Y     – concatenate
                                                              ADDRESS_LINE_2
                                                              ADDRESS_LINE_3
                                                              ADDRESS_LINE_4
                                                              DISABLED_ACCESS
                                                              UPRN                                     Y      Y     If length >= 10 then display … links on map
                             WEBSITES              WEBSITE                                             Y      Y
                             CONTACT_NUMBERS       CONTACT_NUMBER                                      Y      Y     There can be more than one

                                                                      CONTACT_NUMBER_DESCRIPTION       Y      Y
                                                                      CONTACT_NUMBER_TEXT              Y      Y
                              EMAIL_ADDRESSES      EMAIL_ADDRESS                                       Y      Y     Only one
      EMAIL                                                                                            N      N     Only One
      HIGHLIGHTED_NOTES                                                                                N      N
      CHECKLIST                                                                                        N      N
      CHECKLIST_OWNER                                                                                  N      N
      CHECKLIST_EXPIRY_DATE                                                                            N      N
      FURTHER_INFO                                                                                     Y      Y
      RELATED_WEBSITES      INTERNAL_LINKS                                                                          There can be more than one
                                                   INTERNAL_LINK_NAME                                  Y      N
                                                   INTERNAL_LINK_URL                                   Y      N
                           EXTERNAL_LINKS          EXTERNAL_LINK
                                                                   EXTERNAL_LINK_NAME                  Y      Y
                                                                   EXTERNAL_LINK_URL                   Y      Y
      ONLINE_FORMS         INTERNAL_ONLINE_FORMS                                                                    There can be more than one
                                                   INTERNAL_ONLINE_FORM_NAME                           Y      N
                                                   INTERNAL_ONLINE_FORM_URL                            Y      N
                           EXTERNAL_ONLINE_FORMS   EXTERNAL_ONLINE_FORM                                             There can be more than one

                                                                          EXTERNAL_ONLINE_FORM_NAME    Y      Y
                                                                          EXTERNAL_ONLINE_FORM_URL     Y      Y
      RELATED_DOCUMENTS    RELATED_DOCUMENT                                                                         There can be more than one
                                                   URL                                                 Y      Y
                                                   TITLE                                               Y      Y
                                                   SIZE                                                Y      Y



                                                                                 Page 57
                                                Online Directories – Technical Specification

FAQ_OWNER              FAQ_OWNER_NAME                                                   N      N
                       FAQ_OWNER_TELEPHONE                                              N      N
                       LINE_MANAGER                                                     N      N
                       LINE_MANAGER_TELEPHONE                                           N      N
KEYWORDS               N                                                                N      Meta Data
  Ext = Internet web site   Int = Intranet




                                                                  Page 58
                                                              Online Directories – Technical Specification

C. Local Services and Council Services Content Page
Below is what a Local Services or Council Services content page looks like:
        Internet Page:                                                                     Intranet Page:




                                                                                Page 59
                                                                        Online Directories – Technical Specification

Note that the item highlighted in the LHS Menu will either be Directory of Local Services or Directory of Services .


Content Page Data                                                                                 XML Mapping
                                                                                                  CONTACT_DETAILS \ TITLE


                                                                                                  CONTACT_DETAILS \ SERVICE_DESCRIPTION



 Eligibility and Cost:                                                                            CONTACT_DETAILS      \ ELIGIBILITY_AND_COST
 Facilities:                                                                                      CONTACT_DETAILS      \ FACILITIES
 Languages:                                                                                       CONTACT_DETAILS      \ LANGUAGES
 Events:                                                                                          CONTACT_DETAILS      \ EVENTS
 Publications:                                                                                    CONTACT_DETAILS      \ PUBLICATIONS
 Opening Times:                                                                                   CONTACT_DETAILS      \ OPENING_TIMES
 Opening Hours:                                                                                   CONTACT_DETAILS      \ OPENING_HOURS


 Address:                                                                                         CONTACT_DETAILS      \ ADDRESSES \ ADDRESS \ @addressType = ‘mainAddress’\
                                                                                                  ADDRESS_LINE_1
                                                                                                  CONTACT_DETAILS      \ ADDRESSES \ ADDRESS \ @addressType = ‘mainAddress’\
                                                                                                  ADDRESS_LINE_2
                                                                                                  CONTACT_DETAILS      \ ADDRESSES \ ADDRESS \ @addressType = ‘mainAddress’\
                                                                                                  ADDRESS_LINE_3
                                                                                                  CONTACT_DETAILS      \ ADDRESSES \ ADDRESS \ @addressType = ‘mainAddress’\
                                                                                                  ADDRESS_LINE_4
                                                                                                  CONTACT_DETAILS      \ ADDRESSES \ ADDRESS \ @addressType = ‘mainAddress’\ POSTCODE
                                                                                                  CONTACT_DETAILS      \ ADDRESSES \ ADDRESS \ @addressType = ‘mainAddress’\ UPRN
                                                                                                  CONTACT_DETAILS \ ADDRESSES \ ADDRESS \ @addressType = ‘mainAddress’\
                                                                                                  DISABLED_ACCESS
                                                                                                  CONTACT_DETAILS \ ADDRESSES \ ADDRESS \ @addressType = ‘mainAddress’\
                                                                                                  ADDRESS_SPECFIC_OPENING_TIMES
Is there disabled access?
Opening Times:
Contacts:                                                                                         CONTACT_DETAILS \ CONTACT_NUMBERS\ CONTACT_NUMBER \ CONTACT_NAME
         Contact Name:                                                                            CONTACT_DETAILS\ CONTACT_NUMBERS\ CONTACT_NUMBER \ CONTACT_NUMBER_DESCRIPTION
         <Contact Type>:                                                                          CONTACT_DETAILS\ CONTACT_NUMBERS\ CONTACT_NUMBER \ CONTACT_NUMBER_TEXT

Website:                                                                                          CONTACT_DETAILS \ WEBSITES \ WEBSITE

Email:                                                                                            CONTACT_DETAILS \ EMAIL_ADDRESSES \ EMAIL_ADDRESS

Contact:                                                                                          CONTACT_DETAILS \ HOW_TO_CONTACT



                                                                                               Page 60
                        Online Directories – Technical Specification


                                            CONTACT_DETAILS \ RELATED_DOCUMENTS \ RELATED_DOCUMENT \ RELATED_DOCUMENT_URL
                                            CONTACT_DETAILS \ RELATED_DOCUMENTS \ RELATED_DOCUMENT \ RELATED_DOCUMNET_SIZE
                                            CONTACT_DETAILS \ RELATED_DOCUMENTS \ RELATED_DOCUMENT \
                                            RELATED_DOCUMNET_TITLE

                                            The link to Adobe Reader will only be shown if there are related documents




<date and time stamp>


                                            CONTACT_DETAILS \ FAQ_LINKS \ FAQ_DETAILS_S
                                            CONTACT_DETAILS \ FAQ_LINKS \ TITLE
                                            CONTACT_DETAILS \ FAQ_LINKS \ I_CHRONICLE_ID




                                          Page 61
                                                        Online Directories – Technical Specification


The table below shows which fields in the Local Services/ Council Services Content Page are displayed.
Ext = Internet web site  Int = Intranet

 XML                                                                                                            Ext   Int   Extra Info
 CONTACT_
 DETAILS    CONTACT_DESCRIPTION                                                                                 Y     Y
            SERVICES_PROVIDED                                                                                   Y     Y
            TITLE                                                                                               Y     Y
            LGSL_PID                                                                                            N     N
            LAST_MODIFIED_DATE                                                                                  Y     Y
            ELIGIBILITY_AND_COST                                                                                Y     Y
            FACILITIES                                                                                          Y     Y
            LANGUAGES                                                                                           Y     Y
            EVENTS                                                                                              Y     Y
            PUBLICATIONS                                                                                        Y     Y
            OPENING_TIMES                                                                                       Y     Y
            HOW_TO_CONTACT                                                                                      Y     Y
            ADDRESSES
                                        ADDRESS                                                                 Y     Y
                                         addressType="mainAddress"             ADDRESS_LINE_1                   Y     Y
                                                                               ADDRESS_LINE_2                   Y     Y
                                                                               ADDRESS_LINE_3                   Y     Y
                                                                               ADDRESS_LINE_4                   Y     Y
                                                                               POSTCODE                         Y     Y
                                                                               DISABLED_ACCESS                  Y     Y
                                                                               UPRN                             Y     Y
                                                                               ADDRESS_SPECIFIC_OPENING_TIMES   Y     Y
                                        ADDRESS
                                        addressType="alternativeAddress"       ADDRESS_LINE_1                   N     Y
                                                                               ADDRESS_LINE_2                   N     Y
                                                                               ADDRESS_LINE_3                   N     Y
                                                                               ADDRESS_LINE_4                   N     Y
                                                                               POSTCODE                         N     Y
                                                                               DISABLED_ACCESS                  N     Y
                                                                               UPRN                             N     Y
                                                                               ADDRESS_SPECIFIC_OPENING_TIMES   N     Y




                                                                           Page 62
                                       Online Directories – Technical Specification




CONTACT_NUMBERS
                        CONTACT_NUMBER                                                                More than one
                       contactType="mainTelephone"

                                                             CONTACT_NUMBER_DESCRIPTION       Y   Y
                                                             CONTACT_NUMBER_TEXT              Y   Y
                                                             CONTACT_NAME                     Y   Y
                        CONTACT_NUMBER
                       contactType="mainFax"

                                                             CONTACT_NUMBER_DESCRIPTION       Y   Y
                                                             CONTACT_NUMBER_TEXT              Y   Y
                                                             CONTACT_NAME                     Y   Y
EMAIL_ADDRESSES
                       EMAIL_ADDRESS                                                          Y   Y
WEBSITES
                       WEBSITE                                                                Y   Y
RELATED_IMAGES
                       RELATED_IMAGE
                                                             RELATED_IMAGE_PATH               N   N
                                                             RELATED_IMAGE_ALT_TEXT           N   N
RELATED_DOCUMENTS
                       RELATED_DOCUMENT
                                                             RELATED_DOCUMENT_URL         Y       Y
                                                             RELATED_DOCUMENT_TITLE       Y       Y
                                                             RELATED_DOCUMENT_SIZE        Y       Y
LLPG_DATA
                       BLPU_UPRN                                                          N       N
                        FORM_SAON                                                         N       N
                       FORM_PAON                                                          N       N
                       STREET_TEXT                                                        N       N
                       LLPG_POSTCODE                                                      N       N
                       UPDATER                                                            N       N
                       EASTING                                                            N       N
                        NORTHING                                                          N       N
INTERNAL_DESCRIPTION                                                                      N       N



                                                         Page 63
Select
Directory



                                            Online Directories – Technical Specification

                           INTERNAL_NOTES
                                                                  INTERNAL_NOTE            N   Y
                           CHECKLIST                                                       N   N
            EXTRA_FIELDS
                           EXTRA_FIELD
                                                                  EXTRA_FIELD_NAME         N   N
                                                                  EXTRA_FIELD_DETAILS      N   N

            KEYWORDS                                                                               Meta data
            SEE_ALSOS
            FAQ_LINKS
                           FAQ_DETAILS_S
                                                                  I_CHRONICLE_ID
                                                                  TITLE




                                                              Page 64

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:149
posted:8/10/2011
language:English
pages:64