Email Parser

Extract data from incoming emails and automate your workflow

MENUMENU

How to save an attached file in a Microsoft SQL Server Database

May 22, 2014

Email Parser can save attached files from an incoming email to a given folder with the “Save attachments” action. Setting this up is quite easy and straightforward as it only requires to enter the folder where the attachments will be saved. ┬áBut in the case you want to save the file contents to a database this requires a bit of more work. This blog post shows how it can be done in a Microsoft SQL server database.

read more …

Tags


Saving data to CSV files

May 16, 2014

CSV (Comma Separated Values) files are plain text files used to store tabular data, like Excel files or database tables, although in a much more limited way. Each line of the file stores a record (row) and each value (column) is separated by a comma character. Sometimes a tab, a semicolon or other character is used as separator.

For example, a CSV file contains the following data:

02/01/2013;22.43;1.1
02/02/2013;21.54;1.2
02/03/2013;19.43;1.0
02/04/2013;18.56;1.1
02/05/2013;19.21;1.1
02/06/2013;19.12;1.1
02/07/2013;20.56;1.0
02/08/2013;21.65;0.9
02/09/2013;22.54;1.0
02/10/2013;23.12;1.1
02/11/2013;23.87;1.0
02/12/2013;20.32;1.0

read more …

Tags


How to arrange separately captured text values into one

May 6, 2014

Let’s say we have an email containing the following line:

date: 04-06-2004

But what we need is the date backwards (2004-06-04) and insert this text value in an Excel file.

First we have to set up an email parser item to capture the day, month and year separately from the incoming emails. We have to use the regular expression:

read more …

Tags