Click here to Skip to main content
Click here to Skip to main content
Go to top

Dynamic HTML Page creation & Search through Free Text and Meta Tags of HTML by Using Index Server

, 1 Aug 2003
Rate this:
Please Sign up or sign in to vote.
The article mainly focuses on the problem faced in jobs portal to provide the mechanism to employers/recruiters to search job seeker’s uploaded and created resumes on the basis of given template, and vice versa for the job seekers to search the jobs on the basis of the specified criteria.

Introduction

The article mainly focuses on the problem faced in jobs portal to provide the mechanism to employers/recruiters to search job seeker’s uploaded and created resumes on the basis of given template, and vice versa for the job seekers to search the jobs on the basis of the specified criteria.

Issues

There are two solutions to cater this issue.

  • Solution No.1:

    All the relevant information regarding the job seeker should be stored in the database including their resumes. When employers fetch the resume on the basis of specified criteria, the records matching the certain criteria is fetched from the database by using normal SQL Query Language. But when employers specify the free text searching criteria (Free Text searching means specifying the keywords matching the result like Visual Basic developer, SQL Server experts etc.), the records are fetched from the database by using Free Text searching mechanism. SQL Server handles those fields in which Free Text searching applies separately to other fields by using separate pages, which in some extent, improve the performance but not always the better choice.

    The main drawback in the solution is that in jobs portal, we have millions of job seekers' (e.g. In monster.com etc.) profiles and this number increases day by day. So fetching the resumes from millions of records by using Free Text searching of SQL Server drastically degrades the performance of query execution time. We have inserted the resume (which normally in any case not less than 2 pages of MS Word document), so fetching those fields is also a teasing time query execution plan for SQL server.

  • Solution No.2:

    The 2nd and the most efficient way is to save the resumes in the HTML file format by specifying the meta tags (Meta tags is used to uniquely identify the HTML documents) and search those resumes by using the Index Server which is a part of Windows 2000/Windows Xp/Windows Server 2003.

Part A) Dynamic HTML Creation

The technique that I have used here is the creation of HTML templates, defined relevant fields and Meta tags names, through which I will be able to search the resumes in the 2nd part. (HTML template file is available with source code).

When job seekers create their profile and enter all the relevant information, I can retrieve all the contents of the template HTML page in the memory by using the StreamReader class in the System.IO namespace and one by one replace all the user’s provided credentials in the template HTML page and also set the meta tags name’s contents value from the user's given information and save the resume to HTML page by giving the filename like profileId.html (Profile ID is unique in any circumstance).

Part B) Search through Free Text and Meta Tags of HTML Pages by using Index Server

Index Server is a part of Windows 2000/Windows XP/Windows Server 2003, so there is no extra cost involved by using Index Server.

To configure Index Server, follow these steps:

  1. Locate the Index Server

    Start --> Setting --> Control Panel --> Administrative Tools --> Services and Applications --> Index Service

  2. Create a new catalogue

    Right click Index Server --> New --> Catalogue by providing the Catalogue name and folder in which Index Server manages the catalogue

  3. Map the searched folder

    Right click Directories under Catalogue name and then Select New --> Directory --> Locate the mapped directory and give it alias (UNC) like Profiles.

  4. Setting Catalogue’s Properties

    Right Click Catalogue --> Properties -->(Tracking --> WWW Server --> Select Default Website --> OK )

  5. Restart Index Server

    Restart the Index Server.

  6. Full Rescan the Mapped Folder

    Right Click the Mapped Folder --> All Task --> Rescan (Full)

  7. Refresh the Mapped folder meta tag properties

    Right Click Properties --> All Task --> Refresh List

  8. Cache the Meta Tag Properties

    Select catalogue --> Properties --> Select the Meta Tag properties one by one.

    Double click (Meta Tag Property) --> check the Cached Option and Select "VT_LPWSTR" option for string properties.

    Now from the development environment, I have used Index Server data access "ixssco control" type library with ASP.NET for Visual Basic. NET, but we can also use ASP 3.0, Visual Basic 6.0, ASP.NET for C#.NET etc. First, I have gathered all the information in which employee wants to see the resume, and then on the basis of information, built the dynamic query to send to Index Server object after defining the columns of meta tags and then displayed the result in the data grid.

Conclusion

This application is not only used for Job Portal but can be used to search specific data from an HTML page by using Index Server. And to make the dynamic HTML pages, we can not only generate the HTML but can also generate MS Word, Text Format, RTF format document as well.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Syed Adnan Ahmed
Architect Version 1
Ireland Ireland
Adnan Ahmed is SharePoint Architect in Version 1(http://www.version1.com), the IT Consulting Company in Ireland and has involved with many large enterprises to help them realise real benefits of SharePoint 2007|2010.
 
SharePoint Architect | Blogger | IT Evangelist | MCPD SharePoint 2010 Developer| MCITP SharePoint Administrator 2010
 
Email: adnan.ahmed@live.ie
Owner: http://www.mossgurus.com
http://www.sp-blogs.com
Linked In Profile: http://www.linkedin.com/in/syedadnanahmed
 
My Blogs:
http://www.sp-blogs.com/blogs/adnan

Comments and Discussions

 
Questionsearch a field in html page having table and save in database oracle through vb or vb.net Pinmembernokia11081-Mar-07 4:25 
GeneralTSQL PinmemberSphinx766-Mar-06 4:19 
GeneralAbout Query Pinmemberharibala14-Jul-05 20:21 
GeneralAnd ... Pinmemberjalchr31-May-05 4:27 
Generali went to make index server in xml files Pinmemberjarrar15-Sep-03 21:40 
Hi Syed Adnan Ahmed I read your articles but I went to ask you question
I went to make search in xml files, I used asp.net, the index server
Will be index this files, (under un known extensions), the xml files contain title author and description, how can I deal with xml, if the index server treat the files as a text.

GeneralErrors In Download PinmemberPaul Tilson10-Aug-03 12:37 
GeneralThat can't Find any Record Pinmemberwinart6-Aug-03 16:59 
GeneralDefineColumn Pinmembervampiresoft5-Aug-03 11:22 
GeneralRe: DefineColumn PinmemberSyed Adnan Ahmed5-Aug-03 18:58 
GeneralRe: DefineColumn Pinmembervampiresoft6-Aug-03 9:39 
GeneralNext step Pinmemberpburns5-Aug-03 10:21 
GeneralRe: Next step PinmemberSyed Adnan Ahmed5-Aug-03 19:02 
GeneralRe: Next step Pinmemberalhambra-eidos6-Oct-08 7:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 2 Aug 2003
Article Copyright 2003 by Syed Adnan Ahmed
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid