Welcome, Guest
Username: Password: Remember me

TOPIC: Apple Email Format Unrecognizable

Apple Email Format Unrecognizable 5 years 9 months ago #8906

Hi,

There is an ETL process reading a POP3 email from an Apple Ipad format. The Apple email is not recognizable by the ETL tool and fails. If the email is manually forwarded to another email, the ETL process is successful at reading and processing the forwarded email.

Attached are 2 files with email details - one which fails (the Apple format) and the second which is successful (the forwarded email).

Please let me know if you need additional details.
Thank you!

BBS
Attachments:

Please Log in or Create an account to join the conversation.

Apple Email Format Unrecognizable 5 years 9 months ago #8907

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7597
  • Karma: 33
  • Thank you received: 418
Please email us this email.

Mike
Mike

Please Log in or Create an account to join the conversation.

Apple Email Format Unrecognizable 5 years 9 months ago #8928

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7597
  • Karma: 33
  • Thank you received: 418
We are not able reproduce the problem

Email us some samples to test at etl-tools.com

Mike
Mike

Please Log in or Create an account to join the conversation.

Apple Email Format Unrecognizable 5 years 9 months ago #8930

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7597
  • Karma: 33
  • Thank you received: 418
It would really help if you publish execution logs and some screenshots.

Mike
Mike

Please Log in or Create an account to join the conversation.

Apple Email Format Unrecognizable 5 years 9 months ago #8942

Running version 5.7.6.8

Main Workflow package consists of 4 packages: Write Success Record to Log (write a record to log indicating 'start of process', Email File Processing, Process DBase File, and Write Success Record to Log (write a record to log indicating 'end of process'). The email being received is coming from an Apple Ipad and is Apple formatted. The ETL process is unable to recognize the format and abends.

Here are 3 attachments with screenshots of the execution logs:

1) 11-18-2013 2-52-05 PM_PopEmailFail.jpg - execution log details of when package 'Email File Processing' is run (which is agent scheduled) to retrieve email and unzip attachments. Log shows failure on get of email.

2) 11-18-2013 2-54-00 PM_PopEmailSuccess1of2.jpg - since ETL process above failed, the Apple formatted email was forwarded to another email box via SmartMail. The 'Email File Processing' package was restarted reading off the second email box. Here is the first part of the execution log.

3) 11-18-2013 2-57-57 PM_PopEmailSuccess2of2.jpg - continued execution log from #2 above. This shows execution of the forwarded email was successful.

We are sending a copy of a file to you via email. Please let us know if you did not yet receive it. Let us know if you need additional information. Thank you!

BBS
Attachments:

Please Log in or Create an account to join the conversation.

Apple Email Format Unrecognizable 5 years 9 months ago #8945

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7597
  • Karma: 33
  • Thank you received: 418
We are sending a copy of a file to you via email. Please let us know if you did not yet receive it. Let us know if you need additional information. Thank you!

I have just checked This email address is being protected from spambots. You need JavaScript enabled to view it. and there is nothing there from you.

Mike
Mike

Please Log in or Create an account to join the conversation.

We have 257 guests and no members online