Hi Friends,
                                              Even as I launch this today ( my 80th Birthday ), I realize that there is yet so much to say and do.
                                                  There is just no time to look back, no time to wonder,"Will anyone read these pages?"
                                       With regards,
                                       Hemen Parekh
                                       27 June 2013

Monday, 16 July 2007

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

IDENTIFY_PROFILES_LOCALLY

16 Jul 2007

IDENTIFY_PROFILES_LOCALLY

THIS TOOL WAS DESIGNED IN THE HOPE OF --- RESUME FINDER

IT WOULD ENABLE THE USER TO LOCATE THE PROFILES ON HIS HARDDISK

PROJECT WAS UNSUCCESFUL

PARAMETERS:----

THESE STRINGS WOULD BE FOUND IN THE DOCS

Profiles:ThenewcurrencyofRecruitment.Issuedby,www.IndiaRecruiter.net

MyFunction/IndustryProfile

TheResumeAnalytics

MySalaryProfile

MyTenureProfile

MyCareerProfile

MyExperience

MyKarmaScope

MyEducationProfile

MyEducationalQualifications

IF ALL THESE STRINGS WERE PRESENT IN THE WORD FILE THEN THE WORD FILE SURELY IS A PROFILE

IS NOT SUCCESFUL SINCE THE TEMPLATE OF PROFILE HAS THESE LABELS AS

THIS IS WHAT IS PRESENT IN THE WORD FILE

IT DOES NOT GET READ ALWAYS

INSTEAD THIS SHOULD HAVE BEEN LABEL

My Skills Profile

CANT BE TABLE SINCE RAHUL SAYS IT WOULD REQUIRE LOT OF TWEAKING IN THE UIRSExportToWord.vb MODULE


 Hemen Parekh