Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

IBM Enterprise Integrator - ZID File

Posted on 2014-12-11
1
Medium Priority
?
194 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

636 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