Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

IBM Enterprise Integrator - ZID File

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
nbtnotes
Asked:
nbtnotes
1 Solution
 
nbtnotesAuthor Commented:
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now