This extractor allows you to import data from email attachments to KBC. It extracts data from systems generating exports only as CSV files attached to an email. It can also be used instead of repeated manual imports of CSV files.
Tables only get imported with the extractor running. The import is not triggered by an email being sent or received. When running, the extractor imports all emails received since its previous run. Therefore it is a good idea to set up the extractor in a scheduled orchestration.
Find Email Attachments in the Extractors section and create a new configuration. Choose a meaningful name for your configuration. Each configuration corresponds to a single table to which all emails and their attachments are imported. If you need to import emails into more tables, you need to create more configurations.
An email address for sending attachments will be generated when the configuration is created. Use it to send .csv files.
If needed, specify the primary key and CSV options under Import Settings.
Send an email with a data attachment to the generated email address. Use the following sample table:
date | new | lost | total |
---|---|---|---|
2016-03-29 | 8 | 5 | 256 |
2016-03-30 | 9 | 1 | 264 |
2016-03-31 | 15 | 3 | 276 |
With the email message content being completely arbitrary, all that matters is the attached CSV file. It must always adhere to the format specified in Import Settings. It can also be gzipped.
Click Run and confirm.
If the extraction is successful, you will be able to check the processed data in the imported table by clicking on the link. There may be a delay between the time the email is sent, received, and picked up by the extractor.