Skip to Content

Interesting FCC issue - variable changing elements.

Hi Experts

My scenario is sftp to ecc via proxy. But I want to get it working in fcc before I use mtb but I'm starting to wonder if fcc/mtb is possible.

I've got a source text file that holds bank payment data, it has a strange header which can be ignored, these headers start with {1:F10MIRgaf ... etc and end } , then the line items are numbered but sit between :'s e.g. :20: . SOmetimes all line items exist, other times they don't and I'm having issues reading the file in when these variations in structure exit.


All the data in yellow is to be read in. AS you can see in the second capture we've got the format the file may come in as, as you can see some items such as 60f or 60m are optional. Pretty certain FCC cant handle this.

I had considered reading the entire file into one element and passing it to the proxy but thought this might be a bit unelegant?

So I got reading and understand theres a tool in B2b called EDI Content Manager which would read in the flat file and create a xsd from it to be able to read the file. I've had a look for guides on the content manager and tried to import my file structure into the url :


but don't seem to be having much luck.

Could someone please advise what the best way of handling this requirement would be and if the Content manager is the best way to go about it - if so can I get some pointers as to a guide?

Many thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Aug 17, 2017 at 02:57 PM

    Any ideas guys?!

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 17, 2017 at 03:19 PM

    Hi George,

    B2B Cockpit helps is converting a Plain to XML or XML to plain only if there is a predefined structure present in content manager , if you dont have the predefined structure you need to manually create it but again to create you need to know the format of the file .

    In your case i dont see any static file structure , not sure if you can just read line by line and send it to ECC if they are able to handle it.But it would be good if you talk to the team who is generating the file and ask on what basis this file structure is created depending on that you may be able to handle in PI.



    Add comment
    10|10000 characters needed characters exceeded

  • Aug 17, 2017 at 06:59 PM

    Hi George!

    Since your structure consists of tokens inside {} I guess you could split the source file using java mapping.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded