While importing messages using a EmailGetNextMessage/EmailReadMessageValue Loop i do receive all emails, but i only get the text/html/body-content if the mail has an attachment otherwise these fields always stay empty.

I have also tried using the xml-import but the xml-file gets deleted before the import script-step is able to read the file.

What am i missing here?

While importing messages using a EmailGetNextMessage/EmailReadMessageValue Loop i do receive all emails, but i only get the text/html/body-content if the mail has an attachment otherwise these fields always stay empty.

I have also tried using the xml-import but the xml-file gets deleted before the import script-step is able to read the file.

What am i missing here?

It sounds like there may be an error in your script, or you may not be calling the functions or setting your field properly. EmailReadMessageValue will return the specified value of the message, or "ERROR" if there was an error. You shouldn't receive blank unless there isn't a value for the property you're trying to read.

Give our example mail client a try and see if that properly reads the message values. If it does, it sonds like there is a problem with your script not setting the fields in your database correctly. You may not be catching errors correctly, so I would recommend going through your script steps with the script debugger and data viewer.

You can also check the plugin logs for errors.

FileMaker Client

OS X

/Users/userName/Library/Logs/360Plugin Logs/360Plugins_XXXXX.log

Windows

XP or S2003: C:\Documents and Settings\<userName>\My Documents\360Plugin Logs\360Plugins_XXXXX.log

Vista, 7, or S2008: C:\Users\<userName>\Documents\360Plugin Logs\360Plugins_XXXXX.log

FileMaker Server

OS X

/Library/FileMaker Server/Logs/360Plugin Logs/360Plugins_XXXXX.log

Windows

XP or S2003: C:\Documents and Settings\Default User\My Documents\360Plugin Logs\360Plugins_XXXXX.log

Vista, 7, or S2008: C:\Users\Default User\Documents\360Plugin Logs\360Plugins_XXXXX.log

I don't get any error from EmailReadMessageValue and i get all other fields properly - just the body/text/html is all blank.

I am getting the same result with the example mail client.

I cant see an error in the logs.

What mail host are you using? Can you try a different account? For example, try a gmail account instead of your business account. You may also want to try connecting through IMAP if you are currently using POP. This may help find out where the problem is.

It should be an Exchange 2007 Server with IMAP-Service. I tried the same account with apple-mail, no problem. I asked the exchange-administrators turn on the POP-Service and that works! But they don't want that service to stay on so i have to solve the problem.

I wanted to try the xml-import instead of the EmailReadMessage-Loop but that doesn't work either because the generated xml-file gets instantly deleted - what could that be?

I know a number of other users are connecting to exchange servers with imap, so that shouldn't be an issue. Can you try connecting to another mail account as well, such as a gmail account?

Gmail works as expected but i have to use our internal Exchange-IMAP with SSL.

Maybe it has something to do with parsing the body-text out of the mail if nothing is attached, because everything else works.

With an attachment (body gets into the solution) the header ends to:

Content-Type: multipart/mixed;

	boundary="XXXXXXXXXXXXXXXXXXXXX"

Without an attachment (body doesnt make it into the solution) the header ends to:

Content-Type: text/plain; charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable

Can you send me some login information to try this on your server? My contact information is below.

Unfortunately not, the server is not available directly from outside the company.

You could tell me what to send to the server and i send you the source of the refetched email.

Do you have VPN access available? If there is a problem with the plugin retrieving data it is difficult for me to see where the problem is without being able to do it on my machine.

No, this company is very strict about that. I am now off for two weeks. I have to check again after that. Until then they use POP but it cant stay like that. Thanks for your help so far!

Hi David,

 

We are having the same issue in our FM application when we try to connect our internal Exchange Server through IMAP. I tested the Email Fetch script with 360works demo file also.

 

When I test with Gmail account, I can able to get both viewed and viewed with attachments message. But when we try to connect our internal exchange server, the imap account is connected. But it downloads only the email messages which has attachments.. Other email messages are swipe out.

 

We have confusion that why the same plugin code behaves differently for 2 different mail account.

 

For your reference, we have given the code for EmailReadMessages() below.

 

EmailReadMessages(
    "mailbox=INBOX";
    "readonly=true" ;
    "max=500";
    "attachments=false" ;
    "progress=true"
)

 

 

Please let me know what setting makes the different to fetch emails from the mail account.

 

Thanks

Thiyagu