FW: Unearthing

Dear Team

I attach some more of my  " Notes to Colleagues " ( from   www.hemenparekh.in > Notes to Colleagues )

Then realized , it would be far easier for you to read these ONLINE !

Anyway

hcp

From: Hemen Parekh [mailto:hcp@recruitguru.com]
Sent: Friday, January 16, 2015 10:19 AM
To: 'T Sreedhar'; 'naveen@tminetwork.com'; 'abrahamj@tminetwork.com'
Cc: 'shuklendu.baji@sentientsystems.net'; Kailas Patil
Subject: Unearthing

Dear Team

Find below , something that I found at ,,,,www.hemenparekh.in>notes to colleagues

Yesterday , I also spoke to Rahul Deodhar , who led our software team during 2005-2010 , when GlobalRecruiter / IndiaRecruiter and those tools were developed ( including RESUME RATER )

He has agreed to visit our office on Saturday , 31st Jan to help us to the extent he can

regards,

hcp

--------------------------------------------------------------------------------------

7 Jul 2007

GRSTOREEMAILEXTRACTOR

This tool was created to separate the emails that have come into the India recruiter database from the resumerater tool

DATABASE: GLOBALRG – INDIARG (ACTUAL)

DATATABLES :

GRSTORE

column_name	data_type	LENGTH
PKID	numeric	NULL
EMAILSTR	text	2147483647
ENTERDT	datetime	NULL
STATUS	bit	NULL

GRRESUMERATEREMAIL

column_name	data_type	LENGTH
PKID	numeric	NULL
EMAIL	varchar	100
ENTERDT	datetime	NULL
STATUS	bit	NULL
RATECOUNTER	numeric	NULL

The table GRSTORE stores the emails that come in a string(comma separated format)

PKID

EMAILSTR – email strings

ENTERDT - date

STATUS – status of the row being extracted or not….

The tool extracts each row and converse the string into individual emails (comma is the delimiter) and stores the emails into GRRESUMERATEREMAIL

PKID

EMAIL

ENTERDT – date of entry

STATUS – status of whether email has been sent to the email or not RATECOUNTER – no of times the email was extracted (occurrence of email)

Below is the interface

Total rows remaining indicates the rows that are pending in gesture to be extracted- ie the rows that have status 0

Total emails extracted have the count of emails in GRRESUMERATEREMAIL table

Total emails status yes indicates status as 1 for GRRESUMERATEREMAIL.

Transfer button is provided for the extraction logic to start

Hemen Parekh