Email Attachments

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.

Create New Configuration

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.

Screenshot - Create Name Confgiruation

User Email Import

An email address for sending attachments will be generated when the configuration is created. Use it to send .csv files.

Screenshot - Create New Email Import

If needed, specify the primary key and CSV options under Import Settings.

Test Email Import

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.

Screenshot - Job Detail