[Tony]

Hi there, using XFB to route a file to XIB that we pull using a Transfer model/decision rule that parses the names from a DIR listing and then pulls them, we encounter an issue with the files being pulled with a CRLF appended to the filename. It routes to integrator and processes without difficulty, but when integrator attempts to route it to an internal FTP site, it chokes because of the CRLF at the end.

Does anybody know a way to trim this?

Thanks,
Tony

[Rhenus ICT Servi...]

Hi Tony,

I just did a quick test with a filename + CR/LF and the RENAME-statement in the FTP Send Script of XIB does have problems
with the CR/LF.

Yes, it's possible to remove unwanted characters from a filename:

1) Make a custom MBC that has the FTP Send as a next activity.
In this custom MBC you have to extract the original filename from the FTP ReceiveInfo Attributes:

CODE

FOR $i_Attribute = 1 TO ARRAYSIZE($AttributeNames)
{
   $AttributeValue = MBC_HIERCHMSGENV.GetAttribute($SessionId, $MessageId, $AttributeNames[$i_Attribute]);

   # FTPReceiveInfo
   IF $AttributeNames[$i_Attribute] = TA_FTP.$ReceiveInfoAttribute
   {
      $ftpinputattribute = TA_FTP.UnpackReceiveAttribute($AttributeValue);
      $InputFilename = $ftpinputattribute.$RemoteFilename;
   }
}

2) Now you can remove the CR/LF from the $InputFilename variable.
3) Use the 'clean' filename as output filename using the FTP Send Override Attributes:

CODE

# Set the filename for outgoing FTP Transfers
$ftpOverride.$Use_RemoteFilename = $TRUE;
$ftpOverride.$RemoteFilename     = $OutputFilename;

# Pack the record.
$ftpOverrideString = TA_FTP.PackSendMethodOverrideAttribute($ftpOverride);

# Set the attribute.
MBC_HIERCHMSGENV.SetAttribute $SessionId
   MessageId $NewMessageId
   Name TA_FTP.$SendMethodOverrideAttribute
   Value $ftpOverrideString;

I hope these hints will help you!

[Gwenaël Kergunte...]

Hi Tony,

I just did a quick test with a filename + CR/LF and the RENAME-statement in the FTP Send Script of XIB does have problems
with the CR/LF.

Yes, it's possible to remove unwanted characters from a filename:

1) Make a custom MBC that has the FTP Send as a next activity.

If you are using Integrator V3.x, you can also do it in a Map Broker.
%sFileName := getStringAttribute("FTPReceiveInfo", "RemoteFileName");
%iCRLFPosition := index(%sFileName, "\n");
%sFileName := getStringLeft(%sFileName, %iCRLFPosition - 1);
You will have the real file name, without the CRLF.

Also, you can try the following, even more simple if it works !
%sRealFileName := trimString(getStringAttribute("FTPReceiveInfo", "RemoteFileName"), "\n");

Finally, you just need to set the attribute :
setAttribute("FTPSendMethodOverride", %sRealFileName);

[Tony]

Thanks to both of you. We're in 2.1.1. so I'll give the MBC thing a shot!

If you are using Integrator V3.x, you can also do it in a Map Broker.
%sFileName := getStringAttribute("FTPReceiveInfo", "RemoteFileName");
%iCRLFPosition := index(%sFileName, "\n");
%sFileName := getStringLeft(%sFileName, %iCRLFPosition - 1);
You will have the real file name, without the CRLF.

Also, you can try the following, even more simple if it works !
%sRealFileName := trimString(getStringAttribute("FTPReceiveInfo", "RemoteFileName"), "\n");

Finally, you just need to set the attribute :
setAttribute("FTPSendMethodOverride", %sRealFileName);

[Rhenus ICT Servi...]

I'm not an Integrator v3 programmer, but I think the following line:

CODE

%iCRLFPosition := index(%sFileName, "\n");

should be:

CODE

%iCRLFPosition := index(%sFileName, "\r");

Please correct me if i'm wrong...