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

Friday, 29 June 2007

JOBGUIDEDISPLAY

29 June 2007

JOBGUIDEDISPLAY

DATABASE : INTERVIEW_QUESTIONS

TABLE: JOBDESCRIPTION


THE JOB DESCRIPTIONS WERE DOWNLOADED FROM THE WEBSITE

INSERT A STAR IN THE TOP TEXTBOX AND PRESS THE ADJOINING BUTTON

SELECTING THE RESPECTIVE JOB-DESCRIPTIONS WILL 

REVEAL THE DETAILS



Hemen Parekh

IT-KEYWORDS-FINALIZE

29 June 2007

IT-KEYWORDS-FINALIZE

DATABASE :

SQL

INTERVIEW_QUESTIONS

DATATABLES

IT-HIGHLIGHTED-KEYWORDS

IT-KEYWORDS-EXCEL

IT-FUNCTIONLIST

ACCESS FILE :


FOLDERS ACCESSED  -

D:\isys index\ISYS-INDEXING-LOG\FINAL-EXCEL-FILES\hcp-sir-finished-indexing

NOW STORED ON EXTERNAL DRIVE – F:\ISYS-RELATED\ISYS INDEX

PURPOSE :

TO FINALIZE THE IT KEYWORDS

Hemen Parekh

Thursday, 28 June 2007

PRINT-KEYWORDS

28 June 2007

PRINT-KEYWORDS

DATABASE - FUNCTION_KEYWORDS_TEMP

PURPOSE OF TOOL

THE TOOL WAS CREATED TO HIT GOOGLE SETS AND GET MATCHING KEYWORDS FOR THE VARIOUS KEYWORDS THAT ARE PRESENT ON THE VARIOUS NON IT FUNCTIONS

THIS IS USEFUL TO FILL THE “IIT_KEYWORDMATCHES” TABLE
THIS TABLE IS USED IN KARMASCOPE WHEN KEYWORDS ARE CLICKED TO SHOW THE MATCHING KEYWORDS IN IIT

PRESENTLY THE IT FUNCTION KEYWORDS ARE NOT FILLED IN THE 

KEYWORDMATCHES TABLE


IIT_KEYWORDMATCHES


COLUMN_NAME
DATA_TYPE
LENGTH
PKID
decimal
NULL
FUNCTIONID
decimal
NULL
FUNCTIONNAME
varchar
50
KEYWORD
varchar
50
KEYWORDMATCHES
varchar
50 

Looking at the code and the various modules, one can understand how to introduce new functions and keywords and get the matching keywords into the sql database.

Most useful – from New Vitthal Functions Key words. vb

This module can be automated also by calling the button event at the list box. Selected index change event.

Hemen Parekh

PERSONALITY-SOFT-SKILLS-QUESTIONS

28 June 2007

PERSONALITY-SOFT-SKILLS-QUESTIONS

PURPOSE OF THE TOOL

ONE TIME TOOL

TO CAPTURE THE SOFTSKILL QUESTIONS

FROM --------- JOBBANKUSA


DATABASE

soft-skills-questions.mdb

DESCRIPTION

THE LINKS (55) WERE DOWNLOADED ON AN MDB

THE LINKS WERE LOOPED THROUGH THE WEBBROWSER AND THE QUESTIONS WERE TAKEN INTO THE MDB

Hemen Parekh

Tuesday, 26 June 2007

QUESTION_BANK_TOOL

26 June 2007

QUESTION_BANK_TOOL

ONE TIME USE TOOL

this tool was created to analyze the question that were downloaded from all interview website

the SQL database is "INTERVIEW_QUESTIONS "
to refer to their database diagram go to the "INTERVIEW_QUESTIONS_DATABASE_DIAGRAM" FILE

MODULE 1

THE TOP TEXTBOX KEEPS TRACK OF THE LAST FUNCTION WORKED UPON

IT SAVES THE LAST FUNCTION WORKED UPON IN A STATUS FILE (TEXT FILE)

ON STARTING THE TOOL AGAIN - THE STATUS FILE IS READ AND THE SPECIFIC FUNCTION CAN BE OPENED BY THE USER

Y - ACCEPT

D - REJECT

M - MODIFY (ROUND TWO)

THE RELATED TABLE IS - AIQUESTIONS

AIQUESTIONS

 

COLUMN_NAME
DATA_TYPE
LENGTH
FID
numeric
NULL
SID
numeric
NULL
TID
numeric
NULL
TNAME
varchar
500
QID
numeric
NULL
QUESTION
varchar
500
UPDATED
varchar
1

CHANGES MADE TO THE SPECIFIC QUESTIONS ARE REFLECTED IN THE SQL DATABASE

MODULE 2

MAPPER-ADD/DELETE

THE MAPPER FUNCTIONALITY IS TO CONNECT THE PRIMARY FUNCTIONS TO THE SUB CATEGORIES

THE MAPPING IS DONE ON THE TABLE  

AI_FUNCTION_SUBCATEGORY_MAPPER


AI_FUNCTION_SUBCATEGORY_MAPPER


COLUMN_NAME
DATA_TYPE
LENGTH
FID
numeric
NULL
FNAME
varchar
500
SID
numeric
NULL
SNAME
varchar
500


Hemen Parekh

Monday, 25 June 2007

RESUME VIEWER FINAL

25 June 2007

RESUMEVIEWERFINAL

PROJECT DESCRIPTION

IT IS A PROJECT TO VIEW THE RESUMES FROM MONSTER.

POINTS

IT CAN GET A DETAILED DESCRIPTION OF ALL THE AVAILABLE RESUMES ON THE DATABASE.

USERS GET LOGIN.

USERS HAVE SEARCHES MADE IN GURU GRAB.

RESUMES ARE STORED IN THE SQL DATABASE "RESUME".

THE SQL-DIAGRAM OF RESUME DATABASE IS PRESENT IN HTML AND DOC FORMAT TO VIEW IN THE FOLDER "RESUME-DATABASE-DIAGRAM".

RESUMES CAN BE SEARCHED IN THE FOLLOWING MANNERS

1.CONSULTANT WISE

2.DATE WISE

3.CLIENT WISE

4.POSITION WISE



BY TWEAKING THE SEARCH PARAMETERS THE RESULTS CAN BE SEEN IN THE TOP GRID  (GRID A)



DATABASE AND TABLES

DESIGNATION_LIST

COLUMN_NAME
DATA_TYPE
LENGTH
ID
int
NULL
DNAME
nvarchar
255
STATUS
varchar
1

MONCATEGORYROLE

COLUMN_NAME
DATA_TYPE
LENGTH
CATEGORYID
int
NULL
ROLEID
int
NULL
ROLENM
varchar
50

MONRESUME

COLUMN_NAME
DATA_TYPE
LENGTH
PKID
numeric
NULL
PROCESSID
numeric
NULL
EMAILID
varchar
75
RESUMEHTML
text
2147483647
RESUMETEXT
text
2147483647
PROCESSDATE
datetime
NULL

MONSEARCH

COLUMN_NAME
DATA_TYPE
LENGTH
PKID
numeric
NULL
SEARCHNAME
varchar
500
KEYWORDNAMES
varchar
500
MINEXP
varchar
5
MAXEXP
varchar
5
MINSAL
varchar
50
MAXSAL
varchar
50
INDUSTRYIDS
varchar
500
LOCATIONIDS
varchar
500
CATEGORYIDS
varchar
500
ROLEIDS
varchar
500
DEGREEIDS
varchar
500
DEGREESPECIALIDS
varchar
500
IIMS
bit
NULL
IITS
bit
NULL
TOP_UNIVERSITY
bit
NULL
TOP_BUSINESS
bit
NULL
TOP_ENGG
bit
NULL
RESUMERANGEIDS
varchar
500
COMPANYNAMES
varchar
500
PROCESSED
char
1
EMAIL_ID
varchar
75
SEARCHDATE
datetime
NULL

USERLIST

COLUMN_NAME
DATA_TYPE
LENGTH
PKID
numeric
NULL
EMAILID
varchar
70
USERPASSWORD
varchar
70
PROCESSDATE
Date time
NULL
RESUMENUMER
numeric
NULL

KEYWORD_LIST

COLUMN_NAME
DATA_TYPE
LENGTH
ID
numeric
NULL
KEYWORD
varchar
500
WEIGHT
numeric
NULL

Hemen Parekh