fbpx

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

© 2008-2021   FrozenFrog Software    PAD file     Privacy Policy & Terms of Use