Solved

IBM Enterprise Integrator - ZID File

Posted on 2014-12-11
1
176 Views
Last Modified: 2014-12-11
FYI....I changed the extension of the file from .zid to .txt so I could upload it.


I have IBM Enterprise Integrator and I am attempting to do a Direct Transfer from a Text File to a Notes Database.

I have setup the ZID File and it imports records into my Domino Database however I am receiving an error in the log document.

12/11/2014 12:28:03 PM      Activity started
12/11/2014 12:28:03 PM      WARNING: Unable to set MailingFax for [Input Record 1], field exceeds record length (168),  Connector 'TXT - DOT - Carrier',  Method -Fetch-
12/11/2014 12:28:03 PM      WARNING: Unable to set MailingFax for [Input Record 2], field exceeds record length (157),  Connector 'TXT - DOT - Carrier',  Method -Fetch-
12/11/2014 12:28:03 PM      WARNING: Unable to set MailingFax for [Input Record 3], field exceeds record length (126),  Connector 'TXT - DOT - Carrier',  Method -Fetch-
12/11/2014 12:28:03 PM      WARNING: Unable to set MailingFax for [Input Record 5], field exceeds record length (133),  Connector 'TXT - DOT - Carrier',  Method -Fetch-
12/11/2014 12:28:03 PM      WARNING: Unable to set MailingFax for [Input Record 6], field exceeds record length (166),  Connector 'TXT - DOT - Carrier',  Method -Fetch-
12/11/2014 12:28:03 PM      Activity finished: DOT - 01 - File Import - 01 - Carrier

I have tried all the following without success:
MailingFax: TYPE TEXT UNTIL ""
MailingFax: TYPE TEXT UNTIL \r
MailingFax: TYPE TEXT UNTIL \n
MailingFax: TYPE TEXT UNTIL \r\n
MailingFax: TYPE TEXT UNTIL \n\r

Am I not closing the ZID File out correctly ?
Carrier.txt
0
Comment
Question by:nbtnotes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
nbtnotes earned 0 total points
ID: 40495301
Added a "~" to the end of the row on the Carrier.txt file.

I also changed the MailFax line to:
MailingFax: TYPE TEXT UNTIL "~"

All is working properly now.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
DAOS - Backup / Restore 2 202
Lotus Notes - Broken Links report 5 224
See used databases in Domino 8 106
Access VBA to send PDF attachment from C Drive using Lotus Notes. 30 140
For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question