Email Parser

Extract data from incoming emails and automate your workflow

MENUMENU

How to correct the email date/time to the required time zone

January 8, 2019

 

Email Parser automatically uses your local time (as set in Windows) to give a value to the fields DateTimeSent and DateTimeProcessed. But you may need to have these times adjusted to UTC+0 time or another time zone. For this you need to use a small script:

read more …


Creating a field with a number to use it as index

August 10, 2018

 

Recently, a user has posted an interesting question in this website forum:

 

I’m writing to a text file.
Here’s my “Text to insert”:
‘1’,'<%customerID%>’,'<%customerID%>’,”,”,”,”,’ADMIN’,'<%shipToID%>’,”,”,”,”,N’

I’d like some way to increment the “1” with each successive line I extract from the e-mail….

I’ve been trying to create a static field above, and increment it.. tried a script & do it in C#…
Help!!!
and Thanks,
Rich

In this case, the user wanted an index value to write to a text file but it may also happen that you need an index value to insert to a database table. If doing so note that database tables can generate their own index when the SQL INSERT command is sent. But you can also provide them your own index value manually if you want to.

 

For example, if we retrieve the following fields from an incoming email:

 

read more …


New example: How to parse a table in an email and export to Excel

April 26, 2018

We have added to the examples section a step-by-step guide on how to capture table data and export it to an Excel file using the capture method “Capture HTML tag”. This capture method is a new feature added in the latest version of Email Parser (4.7).

 

Tags


Renaming attachments

September 25, 2017

We have added a new example to the examples collection that shows you how to rename attachments with the help of scripting.
You can find it here.

Tags


How to perform an action at a given time, not when emails arrive

May 30, 2017

 

Email Parser usually performs all the actions when an incoming email is received but sometimes you may need to trigger other actions wether or not new emails arrive.

In these cases, the way to go is to use the run conditionbefore any email is processed” or “after any email is processed“. They mean that everytime the Run button is clicked that action will be executed before checking the inboxes or after processing all the email. Regardless the amount of emails received, that action will be run once.

A customer recently asked in the forums how to send an email at 9:00pm and we have written an small example for him. Let’s take a look at the left panel items:

 

 

read more …

Tags


Parsing attached PDF files

November 24, 2016

 

We have added a new example that shows you how to parse data from an attached PDF file. Any comments are welcome!


How to store an email attachment in a MySQL database

November 1, 2016

It is not a very common use case but an user has asked if it is possible to save an attached file to a database. We have written an example about that and posted to the examples section. You can find it here.

Tags


How to parse emails not meeting a condition

October 3, 2016

Usually, when you want to parse a set of emails that meet a specific condition this condition is like “emails contining the word ‘summary’ in the subject” or the more complex one”emails matching the regular expression ‘\d\d\d-\d\d\d'” in the body text“. But, what happens if you want the contrary? It is not so common, but sometimes you want to get only the emails that do not match a condition.

In these cases, the easiest way is to create an email filter that matches the condition, for example, emails contining the word ‘summary’ in the subject. And then, in the following steps of the program select as the source of emails the emails not matching that filter. The screenshots below show how can be done:

read more …


How to remove existing excel rows

August 11, 2016

By default, the process that inserts new rows in an Excel file keeps the existing rows from previous runs and adds the new captured data in a new row. If you want not to keep the previously captured data an easy way to accomplish that is to create a new process that deletes the Excel file. A empty new Excel file will be automatically created the next time a row needs to be created. For example:

 

 

 

The command is:

del /f "C:\Users\Carlos\Desktop\invoices.xlsx"


Removing line breaks (or other unwanted characters) from captured text

June 12, 2014

You can master regular expressions or c# scripting  and build a parser that captures from the email exactly what you want but sometimes unwanted characters such as line breaks, tabs or weird characters (for instance ıġħť p̀ł) are part of the text captured.

To solve these issues we need to apply to the captured text another step of parsing called “text filtering and replacing” :


filter_captured_text-624x432

read more …

Tags