COMBINED MATCH INDEX

16 Jul 2007

COMBINED MATCH INDEX

This tool is designed to incorporate

GURU MATCH

AND

GURU ARCHIVE

GURU MATCH

GURU MATCH IS A TOOL DESIGNED TO GET THE SEARCHES DONE BY THE CONSULTANTS IN GURU GRAB

THE RESUMES CAN BE VIEWED IN GURU SISH

BUT THESE RESUMES ARE NOT RATED

RATED IN TTERMS OF RAW SCORE

GURU MATCH TRIES TO INDEX THE RESUMES AND GET FREQUENCIES FOR THE RESUMES AS PER 1 DESIGNATION AND THEN ORDER THESE RESUMES ACC TO THE SCORE

THIS SECTION IS DESIGNED TO GET THE SEARCHES DONE BY THE CONSULTANTS

THE SEARCHES CAN BE TARGETED EITHER BY THE SERCH ID

OR BY CONSULTANT

THE BUTTONS  “SEARCH BY ID” AND “SEARCH CONSULTANT”

THE GRID DISPLAY IN BETWEEN IS TO DISPLAY THE DATA RELATED TO SEARCHES

IF THE SEARCH HAD A DESIGANTION SPECIFIED THEN THE RIGHT BOX GETS FILLED WITH THE DESIGNATIONS

THE “GET ALL DESIGNATIONS” BUTTON DISPLAYS ALL THE DESIGNATIONS IN THE RIGHT BOX

THIS IS DONE FOR THE SEARCHES WHICH DO NOT HAVE A DESIGNATION SPECIFIED

THIS RIGHT BOX ENABLES THE KEYWORDS TO BE DISPLAYED IN THE MIDDLE SECTION(MASTER LIST OF KEYWORDS)

THE BUTTONS >>> AND <<< ARE GIVEN TO NAVIGATE THE KEYWORDS FROM LEFT TO RIGHT AND VICE VERSA

SELECT ALL BUTTON SELECTS ALL THE KEYWORDS IN THE MASTER LIST

“GET MATCH INDEX” BUTTON

THIS BUTTON TAKES ALL THE KEYWORDS IN THE TEMPORARY KEYWORD BOX (RIGHT BOX) AND THEN INDEXES THE RESUMES FOR THE SPECIFIC SEARCHID ACC TO THE DESCENDING ORDER OF MATCH_INDEX

EXPORT TO EXCEL

THIS BUTTON IS GIVEN TO EXPORT THE KEYWORDS TO AN EXCEL SHEET FOR FUTURE REFRENCE.

THE EXCEL SHEET OF KEYWORDS CAN BE INPORTED IIN THE TOOL BY USING THE IMPORT FROM EXCEL BUTTON

ADD TO LIST  BUTTON ADDS THE KEYWORD TYPED IN THE TEXTBOX BESIDES THE BUTTON IN THE TEMPORARY LIST

THE GRID OF RESUMES IS SHOWN BELOW

THE COLUMNS CHECK IS GIVEN TO SELECT SPECIFIC RESUMES

SELECT ALL AND DESELECT ALL  ENABLES USER TO SELECT AND DESELECT ALL EASILY AND FASTER RESUMES CAN BE VIEWED AND SAVED BY THE USER

THIS SECTION IN THE TOOL HELPS THE USER TO DO THAT

EXCEL – VIEW

THIS BUTTON ENABLES TO GET THE DATA IN THE GRID IN AN EXCEL SHEET FOR THE USER TO USE

IF THE USER SELECTS ALL THEN ALL THE RESUMES (SELECTED/UNSELECTED) WILL BE DISPLAYED IN A EXCEL

IF THE USER SELECTED “SELECT” THEN ONLY THE SELECTED RESUMES WILL BE DISPLAYED IN THE EXCEL

SELECT-

THE OPTIONS SECTION HAS 3 SECTIONS

USER CAN EITHER SAVE OR VIEW RESUMES

USER CAN EITHER VIEW RESUMES HIGHLIGHTED OR NOT

USER CAN VIEW THE RESUME IN WORD OR HTML FORMAT

----X----X----X----

GURU ARCHIVE

THE USER INTERFACE OF GURU MATCH AND GURU ARCHIVE IS ALMOST SAME

DIFFERENCE BEING

GURU MATCH – RESUMES FROM MONSTER SEARCHES IN GURU-GRAB

GURU ARCHIVE – ARCHIVED RESUMES FROM 3P FOLDER – TOP 1000

THE INDEXING HAS BEEN DONE OVER THE 3 MAIN CATEGORIES

IT

NONIT

MONSTER DESIGNATIONS

IN THE GRID –

RESUMES-PRESENT COLUMNS DEFINES WHEATHER THE RESUMES ARE PRESENT IN THE SQL DATABASE

IF THE COLUMN READS Y THEN THE SPECIFIC DESIGNATION HAS BEEN WORKED UPON

DATABASE – SQL – RESUME

DATATABLES

 MONSTER DESIGNATIONS

 

COLUMN NAME	DATA TYPE	LENGTH
PKID	numeric	NULL
DESIGID	numeric	NULL
RESUMEHTML	text	2147483647
MATCH_INDEX	numeric	NULL
FILEPATH	varchar	500
EMAIL	varchar	150

 

OFFLINE_RESUMES_MATCH_INDEX_TWO

COLUMN NAME	DATA TYPE	LENGTH
PKID	numeric	NULL
DESIGID	numeric	NULL
RESUMEHTML	text	2147483647
MATCH_INDEX	numeric	NULL
FILEPATH	varchar	500
EMAIL	varchar	150

 

DESIGNATION_LIST

COLUMN NAME	DATA TYPE	LENGTH
ID	int	NULL
DNAME	nvarchar	255
STATUS	varchar	1

 

DESIGNATION_LIST_TWO

COLUMN NAME	DATA TYPE	LENGTH
FID	int	NULL
FNAME	nvarchar	255
STATUS	varchar	1

 

THE TABLES WHERE _TWO IS PRESENT DEFINES THE IT-NONIT FUNCTIONS-SKILLS

WITHOUT _TWO DEFINES MONSTER DESIGNATIONS

 

KEYWORD_LIST

COLUMN NAME	DATA TYPE	LENGTH
ID	numeric	NULL
KEYWORD	varchar	500
WEIGHT	numeric	NULL

 

KEYWORD_LIST_TWO

COLUMN NAME	DATA TYPE	LENGTH
ID	numeric	NULL
KEYWORD	varchar	500
WEIGHT	numeric	NULL

 

THE KEYWORDS ARE SAVED IN THESE TABLES

Hemen Parekh