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
