Parker Software Forum

Parker Software Forum http://www.parkersoft.co.uk/forum/ This is an XML content feed of; Parker Software Forum : Last 10 Posts Sat, 25 May 2013 09:40:35 +0000 Fri, 24 May 2013 21:15:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.64 30 www.parkersoft.co.uk/forum/RSS_topic_feed.asp Parker Software Forum http://www.parkersoft.co.uk/forum/forum_images/PSLSmall.bmp http://www.parkersoft.co.uk/forum/ Email2DB Version 3 : Attachment misssing on outgoing email http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8805&PID=20192#20192 Author: James Horton
Subject: Attachment misssing on outgoing email
Posted: 24 May 2013 at 9:15pm

Hi Sdms,

We have found this issue internally and we are currently working on a fix. The issue appears to reside within the currently public build of 1155.

The resolution will be available shortly, but if you would like to receive the latest release once successful testing has been completed then please keep in touch with our support@parker-software.com for further news on our progress while we work on the fix.

I believe that a resolution to the problem should be available during the week of the 27th May 2013.

]]> Fri, 24 May 2013 21:15:32 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8805&PID=20192#20192 General : Trigger Inserting Blank Lines to SQL http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8808&PID=20191#20191 Author: James Horton
Subject: Trigger Inserting Blank Lines to SQL
Posted: 24 May 2013 at 7:46pm

If you review the Message Processor Log after processing a message, do you see a value next to your Extracted Field?

If not, then it is possible that the extraction method you are using differs from the actual content of the message you are attempting to process. against.

I would say that the next step is to right click on the Trigger that has processed your inbound message and select 'View Processed Messages'. Within this area you will be able to see all of the recent messages that Email2DB has processed, along with the ability to reprocess these (please bear in mind that the message data will be empty if your Account Properties have been set to not store a full copy of the message).

When inside the message select 'Message Text' and make sure that the extraction rules for the field are taking this format into account. This will be how Email2DB sees your message, and may at times differ from an Outlook representation of the message, as Outlook would typically display HTML if that is present. Sometimes if the message is multi-part then the plain text element will remain hidden depending on your mail client's configuration and so this may possibly have been overlooked due to this.

Once you have the body of the message, paste this into the Find & Extract Helper to see if in real time editing, Email2DB picks up your field when reviewing your extraction rules.

If this does not assist, then please let us know how much further you get with this.

]]> Fri, 24 May 2013 19:46:56 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8808&PID=20191#20191 General : Trigger Inserting Blank Lines to SQL http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8808&PID=20190#20190 Author: andyc209
Subject: Trigger Inserting Blank Lines to SQL
Posted: 24 May 2013 at 4:36pm

noobie here to this so be patient

set up Email2DB to talk to my exchange server and my SQL server and i want the data within the emails to post to a table in SQL. I think all the connections etc are fine its just when i try a test email it is inserting blank lines into the SQL table. I have included my Trigger and email template below:

Conditions

Where subject line contains 'Accept'

In Extracted fields:

Name Table Field Find

Surname TBL_Accepts Surname(string(max)) Surname=

Trigger Action

INSERT INTO TBL_ACCEPTS (SURNAME) VALUES (@SURNAME)

Email Subject: Accept

Email Body: Surname= smith

the connection to the database tests fine etc so not sure where i am going wrong

]]> Fri, 24 May 2013 16:36:29 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8808&PID=20190#20190 General : Timing Issues (Message Received & Processed) http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8807&PID=20189#20189 Author: GaryWilliams
Subject: Timing Issues (Message Received & Processed)
Posted: 24 May 2013 at 3:31pm

Hi Liam,

Logging is set to Debug, watching the Message Processor we see nothing either and it's not showing in the View Processed Messages.

We were on a Screen Share today with another Vendor testing a Workflow Process that gets triggered as a result of an email coming in - and Email2DB done nothing and it move to Processor Folder - we don't have another instance of Email2DB running anywhere looking at the Mailbox Folder we are checking either.

]]> Fri, 24 May 2013 15:31:36 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8807&PID=20189#20189 General : Timing Issues (Message Received & Processed) http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8807&PID=20188#20188 Author: Liam
Subject: Timing Issues (Message Received & Processed)
Posted: 24 May 2013 at 3:25pm

Hello Gary,

I would go into EMail2DB -> File -> Program Options -> Logging and set the logging level to debug.
then when you process a message if you watch the Message Processor Server Log you will be able to see exactly which action the delay is happening on.

To my understanding the processed date will be the date and time when the message has finished all trigger actions.

I haven't come across an issue like this before, can you find these messages within "View Processed Messages" within Email2DB?]]> Fri, 24 May 2013 15:25:30 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8807&PID=20188#20188 General : Timing Issues (Message Received & Processed) http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8807&PID=20187#20187 Author: GaryWilliams
Subject: Timing Issues (Message Received & Processed)
Posted: 23 May 2013 at 4:19pm

Hi ...

On one of our Servers we're noticing that it's taking some time to process messages, that is by looking in the Message Store, the Received Time Stamp and Process Time Stamp are quite some time apart, and the Accounts are set to a maximum of 3 minutes to check.

Can someone tell me the process on when this Time Stamps are taken, i.e. is the Received when the Email hits the Inbox, and the Processed when Email2DB has picked it up or finished with it and moved it?

In addition it appears that we're seeing at times Messages being moved to the processed folder with nothing happening, they look like they pass the validation checks (there are non set other than the default) - anyone experienced this?

]]> Thu, 23 May 2013 16:19:39 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8807&PID=20187#20187 General : Trigger Condition Cancelled Execution http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8799&PID=20186#20186 Author: peterro
Subject: Trigger Condition Cancelled Execution
Posted: 22 May 2013 at 10:39pm

It's been a while but I'm getting back to this, thanks for the info. Here's an example:

I have a trigger that only has 1 condition - from address is 1 of 2 listed.

There are no extracted fields.

There are no trigger actions defined.

Sometimes when this (or another) trigger is activated, the log lists 9 entries that say "Trigger Condition Cancelled Execution". Though I've seen this trigger activate without logging these messages.

It seems I have some weird configuration that are causing these to be logged multiple times.

Thoughts?

]]> Wed, 22 May 2013 22:39:48 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8799&PID=20186#20186 General : uploading multi-row table to CRM http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8806&PID=20185#20185 Author: Nobbydoe
Subject: uploading multi-row table to CRM
Posted: 20 May 2013 at 3:57pm

All,

I have email2db working to upload to our Dynamics CRM without issue, but now I need to add some more functionality.

On my CRM opportunity I have a multirow entry that allows me to enter one or more data records relating to the opportunity. These records reflect the hardware that is to be ordered as part of the opportunity.

Does anyone have any knowledge of how I would upload not only the opportunity, but also the sub records that are associated with it?

many thanks,

Ian

]]> Mon, 20 May 2013 15:57:28 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8806&PID=20185#20185 Email2DB Version 3 : Attachment misssing on outgoing email http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8805&PID=20184#20184 Author: sdms
Subject: Attachment misssing on outgoing email
Posted: 18 May 2013 at 3:23am

I have added a trigger to one of my accounts which causes an email to be sent out when a database record is read and processed. I have done this several times before but in this instance I am attaching three files to the outgoing email which l have not done before. When the email gets sent out it only has the first file attached (a pdf). There should be 2 pdf's and 1 word document. When I look at the email structure in Email2DB, at the bottom I can see the "attach" line which contains three paths to the files each separated with a ";"

No matter what I try only one attachment gets sent out.

]]> Sat, 18 May 2013 03:23:48 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8805&PID=20184#20184 Email2DB Version 3 : email2dbmessage.attachments.fileExtension format http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8797&PID=20183#20183 Author: Liam
Subject: email2dbmessage.attachments.fileExtension format
Posted: 17 May 2013 at 12:42pm

Hello Paul,

This will get the file types - Email2DBMessage.Attachments(x).FileExtension

However I don't believe that this contains the '.' as you have entered in your script.
The best thing to do is to print the FileExtension variable to the log file using the Call AddToLog() function. This way you can see exactly how the variable is stored.]]> Fri, 17 May 2013 12:42:13 +0000 http://www.parkersoft.co.uk/forum/forum_posts.asp?TID=8797&PID=20183#20183