Objective:
Extract existing client information from emails ( gmail ) using emails that match certain filter criteria. Filter criteria should be from advanced gmail filter criteria.
Assumptions: System assumes that all emails returned by search criteria are exactly of same format & structure. E.g. notification of web form will be exactly same every time.
Logic:
User creates a xml driver config file with gmail user name, password, advanced filter criteria as provided by gmail.
System uses the config file info to open email box and search emails by filter criteria.
System prompts user for information that he would like to extract from email to excel.
User clicks all data fields available for extraction and maps to excel column name chosen by user.
User saves this configuration for future runs.
User runs the config and all emails that match search criteria are extracted into excel as per mapping created by user in previous steps.
System saves the the time time stamp of first email and last email, so that if config is run again, only new emails are extracted to excel.
user should be able to save multiple configurations.
mapping Configurations should be created in XML format and linked back to its driver configuration.
user should be able to run all configurations from a batch file.