on 07-20-2017 9:38 AM
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.
cusersgeorge-applegatedesktopkyriba-bank-reccaptur.pngcusersgeorge-applegatedesktopkyriba-bank-reccaptur.png
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 :
webdynpro/dispatcher/sap.com/converter~maintain~maintenance-app/Maintenance
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
Hi George!
Since your structure consists of tokens inside {} I guess you could split the source file using java mapping.
Regards, Evgeniy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Br,
Manoj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Manoj
The structure can change with each record or the structure can stay the same. Its a bank record so different structures are entered depending on what values / taxes etc are present. I know ALL the fields that could possibly come in, can I write those into a Content manager table to make such fields optional?
I'm after a plain to XML example - of which theres seems to be non around on help.sap.com !
Many thanks,
George.
Any ideas guys?!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.