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

Now as I approach my 90th birthday ( 27 June 2023 ) , I invite you to visit my Digital Avatar ( www.hemenparekh.ai ) – and continue chatting with me , even when I am no more here physically

Saturday 7 July 2007

GRSTOREEMAILEXTRACTOR

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