Develop macro in iOpus to:
- Extract data from 2 web sites ,
- Transform the data and,
- Load the data into MS Excel.
The data is contact information (name, address, telephone, fax, email etc) from:
1. EPO [url removed, login to view]
2. CIPA [url removed, login to view]
The data must be correctly formatted in MS Excel so the process can be re-run in the future daily or weekly).
Please find attached documents with full description of data to extract, formatting and sample of the extracted data. (These are available in MS Excel if required) There is also a specification of the volume of data expected when the macro is run.