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