on 06-14-2007 10:24 AM
Hi, i am asking again because i posted nearly same question some days ago.
My output is just one line instead of several more. I am getting IDoc to cenvert it to txt.
My FCC is like
ZeitDetailsStructure.fieldFixedLengths = 8,4,14,4,2,6,1
ZeitDetailsStructure.fieldNames = 'DUMMY01','AUSWEISNR','DUMMY02','TAG','DUMMY03','SALDO','DUMMY04'
ZeitDetailsStructure.fieldSeparator = 'nl'
ZeitDetailsStructure.endSeparator = 'nl'
any can give me a hand?!
br Jens
Hi Jen,
When u have specified the fieldfixed lenght then y do you need field separator ?
Also could u provide yr Documne tna drecord set structure also for better understanding of your problem
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
well the source looks like:
<ZBC01_OUTPUT_ZEIT SEGMENT="1">
<DUMMY01>** Y0000</DUMMY01>
<AUSWEISNR>1775</AUSWEISNR>
<DUMMY02>00400FFFF00</DUMMY02>
<TAG>1306</TAG>
<DUMMY03>01</DUMMY03>
<SALDO>+90000</SALDO>
<DUMMY04>.</DUMMY04>
</ZBC01_OUTPUT_ZEIT>
<ZBC01_OUTPUT_ZEIT SEGMENT="1">
<DUMMY01>** Y0000</DUMMY01>
<AUSWEISNR>1776</AUSWEISNR>
<DUMMY02>00400FFFF00</DUMMY02>
<TAG>1306</TAG>
<DUMMY03>03</DUMMY03>
<SALDO>+4</SALDO>
<DUMMY04>.</DUMMY04>
</ZBC01_OUTPUT_ZEIT>
<ZBC01_OUTPUT_ZEIT SEGMENT="1">
<DUMMY01>** Y0000</DUMMY01>
<AUSWEISNR>1777</AUSWEISNR>
<DUMMY02>00400FFFF00</DUMMY02>
<TAG>1306</TAG>
<DUMMY03>02</DUMMY03>
<SALDO>+820</SALDO>
<DUMMY04>.</DUMMY04>
</ZBC01_OUTPUT_ZEIT>
The output should look like:
ZeitRecordSet
- ZeitDetailsStructure
-- DUMMY01
-- AUSWEISNR
-- DUMMY02
-- TAG
-- DUMMY03
-- SALDO
-- DUMMY04
Any ideas. btw: does this fieldSeparator has to be deleted?
br Jens
Hi Jens,
You go to file adapter select the box where you enter FCC.
In that select the line for fieldSeparator and then use the -- button on top of the box.
Your fieldSeparator will be deleted.
Secondly in fieldNames you have mentioned the field name in single quotes. I think that is not required you can mention the field names without quotes.
In FCC Structure write = ZeitRecordSet,ZeitDetailsStructure
Regards,
Sumit
Hi, well i have to use fieldAdapter, otherwise it's not working for me.
The quotes seems to be no problem, so i let them.
And the FCC structure is right as u wrote.
And nothing changed, i have no clue what is wrong. I also changed the occurence form 0..1 to 0..unbounded - but nothing....
is it possible to write several lines at all?!
br Jens
Here u go:
<?xml version="1.0" encoding="UTF-8"?>
<ZBC01_OUTPUT_ZEIT>
<IDOC BEGIN="1">
<EDI_DC40 SEGMENT="1">
<TABNAM>EDI_DC40</TABNAM>
<MANDT>011</MANDT>
<DOCNUM>0000000000201024</DOCNUM>
<DOCREL>700</DOCREL>
<STATUS>30</STATUS>
<DIRECT>1</DIRECT>
<OUTMOD>2</OUTMOD>
<IDOCTYP>ZBC01_OUTPUT_ZEIT</IDOCTYP>
<MESTYP>ZBC01_OUTPUT_ZEIT</MESTYP>
<STDMES>ZBC01_</STDMES>
<SNDPOR>SAPD01</SNDPOR>
<SNDPRT>LS</SNDPRT>
<SNDPRN>D01CLNT011</SNDPRN>
<RCVPOR>ZKABA</RCVPOR>
<RCVPRT>LS</RCVPRT>
<RCVPRN>KABABENZ</RCVPRN>
<CREDAT>20070614</CREDAT>
<CRETIM>124624</CRETIM>
<SERIAL>20070612110222</SERIAL>
</EDI_DC40>
<ZBC01_OUTPUT_ZEIT SEGMENT="1">
<DUMMY01>** Y0000</DUMMY01>
<AUSWEISNR>1775</AUSWEISNR>
<DUMMY02>00400FFFF00</DUMMY02>
<TAG>1306</TAG>
<DUMMY03>01</DUMMY03>
<SALDO>+90000</SALDO>
<DUMMY04>.</DUMMY04>
</ZBC01_OUTPUT_ZEIT>
<ZBC01_OUTPUT_ZEIT SEGMENT="1">
<DUMMY01>** Y0000</DUMMY01>
<AUSWEISNR>1776</AUSWEISNR>
<DUMMY02>00400FFFF00</DUMMY02>
<TAG>1306</TAG>
<DUMMY03>03</DUMMY03>
<SALDO>+4</SALDO>
<DUMMY04>.</DUMMY04>
</ZBC01_OUTPUT_ZEIT>
<ZBC01_OUTPUT_ZEIT SEGMENT="1">
<DUMMY01>** Y0000</DUMMY01>
<AUSWEISNR>1777</AUSWEISNR>
<DUMMY02>00400FFFF00</DUMMY02>
<TAG>1306</TAG>
<DUMMY03>02</DUMMY03>
<SALDO>+820</SALDO>
<DUMMY04>.</DUMMY04>
</ZBC01_OUTPUT_ZEIT>
</IDOC>
</ZBC01_OUTPUT_ZEIT>
well i don't get u! i posted the payload receiving form IDoc-Adapter
<ZBC01_OUTPUT_ZEIT SEGMENT="1">
<DUMMY01>** Y0000</DUMMY01>
<AUSWEISNR>1775</AUSWEISNR>
<DUMMY02>00400FFFF00</DUMMY02>
<TAG>1306</TAG>
<DUMMY03>01</DUMMY03>
<SALDO>+90000</SALDO>
<DUMMY04>.</DUMMY04>
</ZBC01_OUTPUT_ZEIT>
this should be converted into the target structure!
DUMMY01AUSWEISNRDUMMY02TAGDUMMY03SALDODUMMY04
DUMMY01AUSWEISNRDUMMY02TAGDUMMY03SALDODUMMY04
etc
Jens
Hi Jen,
wanted the payload after mapping..
<ZBC01_OUTPUT_ZEIT SEGMENT="1">
<DUMMY01>** Y0000</DUMMY01>
<AUSWEISNR>1775</AUSWEISNR>
<DUMMY02>00400FFFF00</DUMMY02>
<TAG>1306</TAG>
<DUMMY03>01</DUMMY03>
<SALDO>+90000</SALDO>
<DUMMY04>.</DUMMY04>
</ZBC01_OUTPUT_ZEIT>
Since in this case theres only one structure tehre would be only one line in text file after FCC.
Why do need SEGMENT="1"> in the output file. You are not using this in FCC.
Regards,
Sumit
>
> My output is just one line instead of several more. I
> am getting IDoc to cenvert it to txt.
> My FCC is like
>
> ZeitDetailsStructure.fieldFixedLengths =
> 8,4,14,4,2,6,1
> ZeitDetailsStructure.fieldNames =
> 'DUMMY01','AUSWEISNR','DUMMY02','TAG','DUMMY03','SALDO
> ','DUMMY04'
> ZeitDetailsStructure.fieldSeparator = 'nl'
> ZeitDetailsStructure.endSeparator = 'nl'
>
taking these content conversion parameters into picture, the parameters that should be used,
ZeitDetailsStructure.fieldFixedLengths => 8,4,14,4,2,6,1
ZeitDetailsStructure.endSeparator = 'nl'
ZeitDetailsStructure.addHeaderLine = 0
Try with these parameters and let us know.
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@ Bhavesh
its not working woth ur three lines, i am getting
java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'ZeitRecordSet.fieldFixedLengths' or 'ZeitRecordSet.fieldSeparator' is missing
@ Sumit
Well the SEGMENT is coming from IDoc.
the target Payload looks like the MessageType:
<?xml version="1.0" encoding="UTF-8"?>
<MTZEIT>
<ZeitRecordSet>
<ZeitDetailsStructure>
<DUMMY01>** Y0000</DUMMY01>
<AUSWEISNR>1775</AUSWEISNR>
<DUMMY02>00400FFFF00</DUMMY02>
<TAG>1306</TAG>
<DUMMY03>01</DUMMY03>
<SALDO>+90000</SALDO>
<DUMMY04>.</DUMMY04>
</ZeitDetailsStructure>
</ZeitRecordSet>
</MTZEIT>
Jens,
Can you confirm these are the parameters you are using?
RecordsetStrcuture ZeitDetailsStructure
ZeitDetailsStructure.fieldFixedLengths => 8,4,14,4,2,6,1
ZeitDetailsStructure.endSeparator = 'nl'
ZeitDetailsStructure.addHeaderLine = 0
If you are using recordsetstrccutre as ZeitRecordSet,ZeitDetailsStructure , it should be just ZeitDetailsStructure
Regards
Bhavesh
Hi Jen ,
The target payload which you have put for that only a single line will come
in text file.
If you want multiple rows in the target file you need to have multiple occurrence of
<?xml version="1.0" encoding="UTF-8"?>
<MTZEIT>
<ZeitRecordSet>
<ZeitDetailsStructure>
<DUMMY01>** Y0000</DUMMY01>
<AUSWEISNR>1775</AUSWEISNR>
<DUMMY02>00400FFFF00</DUMMY02>
<TAG>1306</TAG>
<DUMMY03>01</DUMMY03>
<SALDO>+90000</SALDO>
<DUMMY04>.</DUMMY04>
</ZeitDetailsStructure>
<ZeitDetailsStructure>
<DUMMY01>** Y0000</DUMMY01>
<AUSWEISNR>1775</AUSWEISNR>
<DUMMY02>00400FFFF00</DUMMY02>
<TAG>1306</TAG>
<DUMMY03>01</DUMMY03>
<SALDO>+90000</SALDO>
<DUMMY04>.</DUMMY04>
</ZeitDetailsStructure>
</ZeitRecordSet>
</MTZEIT>
If the payload with multiple records is like the one mentioned above then multiple row will come in the target file.
Regards,
Sumit
Hi Jens,
Use the following in FCC ..
ZeitDetailsStructure.fieldFixedLengths = 8,4,14,4,2,6,1
ZeitDetailsStructure.fieldNames = 'DUMMY01','AUSWEISNR','DUMMY02','TAG','DUMMY03','SALDO','DUMMY04'
ZeitDetailsStructure.endSeparator = 'nl'
Also post the FCC parameters which you are using right now.
<i>@Sumit
well thats the problem! i have multiple data incoming but just one line is written!</i>
Please also post the payload which has multiple data.
Regards,
Sumit
Message was edited by:
Sumit Khetawat
Sorry Sumit but u suggest same as i wrote in first posting, except one.
And u got all the Payload i can give u!? - guess ur really lost
> ZeitDetailsStructure.fieldFixedLengths =
> 8,4,14,4,2,6,1
> ZeitDetailsStructure.fieldNames =
> 'DUMMY01','AUSWEISNR','DUMMY02','TAG','DUMMY03','SALDO
> ','DUMMY04'
> ZeitDetailsStructure.endSeparator = 'nl'
>
ZeitDetailsStructure.fieldFixedLengths = 8,4,14,4,2,6,1
ZeitDetailsStructure.fieldNames = 'DUMMY01','AUSWEISNR','DUMMY02','TAG','DUMMY03','SALDO','DUMMY04'
[[ ZeitDetailsStructure.fieldSeparator = 'nl' ]]
ZeitDetailsStructure.endSeparator = 'nl'
>
> Also post the FCC parameters which you are using
> right now.
>
> <i>@Sumit
>
> well thats the problem! i have multiple data incoming
> but just one line is written!</i>
>
> Please also post the payload which has multiple
> data.
>
> Regards,
> Sumit
>
> Message was edited by:
> Sumit Khetawat
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.