Solved

IBM Enterprise Integrator - ZID File

Posted on 2014-12-11
1
168 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now