email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Post here if you experience problems or get unexpected errors.
I am trying to capture bad email addresses and update a SQL Server database, but after making some changes in my Email Parser settings I now receive the following error message every time I try to run Email Parser:

Error. A duplicate value cannot be inserted into a unique index. [ Table name = FieldValuePairs,Constraint name = PK_FieldValuePairs ].

The table/view "FieldValuePairs" is not in my SQL Server database so I presume it is in the Email Parser database. I have only recently installed and started learning Email Parser, so I do not mind deleting and re-creating items at this time.

But at the moment my Email Parser is broken because this error happens every time I try to run it, please help!

Screenshot uploaded:
Attachments
Email Parser Error.png
Screenshot
Hi Colin,

seems to me that you have a Primary Key combined with another field and made this unique. This is, as far as I know, a SQL server option. So check the database for PK's (Primary Key's) and you'll probably see that there is a field that contains the value that you are trying to insert.

regards, J.
Hi Colin,

Thanks for reporting this problem. I have fixed it and uploaded a new setup file to the website.

You just need to run the new installer, there is no need to uninstall it first.

James wrote:
So check the database for PK's (Primary Key's) and you'll probably see that there is a field that contains the value that you are trying to insert.
This is an internal error of Email Parser. It uses an embedded version of SQL server to handle the emails and their data. The error messages are the same and this is because it is a bit confusing.
Hi James - thanks for your input. Support found and fixed an internal issue, I've re-downloaded and the program now runs without error. :) Colin
OK, everybody happy! :D :D