cancel
Showing results for 
Search instead for 
Did you mean: 

CONVERTION OF FLAT FILE TO XML : NO OUT PUT FOUND

former_member185856
Participant
0 Kudos

Hi XI Experts,

I am not getting output while creating a scenario of flat file to xml file. I have set the file content conversion parameter correctly...the file which is .txt is picking up but I m not getting the file in the output directory.

CAN ANYONE HELP ME.....PLS!!!

Thanks in advance...

Accepted Solutions (0)

Answers (6)

Answers (6)

former_member185856
Participant
0 Kudos

not answered...

Former Member
0 Kudos

can u paste your input file adapter details and mapping cardinailty

former_member185856
Participant
0 Kudos

Hi XI Experts,

I have made the corrections as u people suggested, thanks for the help. One more thing I want to know,

my flat file is as follows :

Shilpa,Bangalore

Suma,Mysore

I m getting the out put as :

<?xml version="1.0" encoding="UTF-8" ?>

- <ns:mt_txt2file_rec xmlns:ns="urn:txtfiletoxml">

<Cmrname>Shilpal</Cmrname>

<Addr>Bangalore</Addr>

</ns:mt_txt2file_rec>

and I m not getting the output for the second record.....can anyone help me out pls...

my file content conv is as follows :

Document name : mst type name

Document Namespace ; Name space name

Record set name : node name ( record)

recordset str : Record str name

Key field type :...

Row.fieldNames: Name,Addr

Row.fieldSeparator: ,

Row.processConfiguration : FromConfiguration

Row.endSeparator : 'nl'

DO I NEED TO ADD SOME MORE THINGS IN IT???

Thanks in Advance!!

Former Member
0 Kudos

check our cardinlity in mapping it is 1:1 right now make it 1:unbounded.

please reward points

Regards

Sreeram.G.Reddy

Message was edited by:

Sreeram Reddy

Former Member
0 Kudos

Hi Sunil,

give:

recordset name : node

recordset sequence : node,*

in key value pair do:

node.fieldNames: Name,Addr

node.fieldSeparator: ,

node.processConfiguration : FromConfiguration

node.endSeparator : 'nl'

Thanks,

Rajeev Gupta

Former Member
0 Kudos

HI,

please change

Document name : mst type name

Document Namespace ; Name space name ( may not require)

Record set name : node name ( record)

recordset str : Record str name -- Here Please change <b>recordstrname,*</b>

Sure you will get it..

Please see above 1092 blog..

Regards

Chilla..

Former Member
0 Kudos

HI,

Your Out put msg structure should follow below ..(If possible)

Messagetype

Record set

<b>Record setSubstr</b>..

<i>On file structure

Multiple records</i> ..

If it is like that then in you configuration..

Please add <b>RecordSustr,*</b>

Regards

Chilla...

I hope

former_member185856
Participant
0 Kudos

Hi,

Thanks for your guidance, still its not working..is there any thing to be added..to get multiple records....pls help me out...

Thanks in Advance!!

Former Member
0 Kudos

can u paste your input file adapter details and mapping cardinailty

Former Member
0 Kudos

Hi Suneel,

in your target data type, the node should be 0..unbounded then the node can repeat mutiple times.......this node will contain your fields of name and address.

Test your mapping in the message mapping test tab and see in target multiple nodes are generated or not....

Thanks,

Rajeev Gupta

Message was edited by:

RAJEEV GUPTA

Former Member
0 Kudos

HI,

Please try to explain input and output structures..

so that you will get exact solution..

And what you have configured..

Regards

Chilla..

former_member185856
Participant
0 Kudos

Hi,

The follwoing is the mapping str I created and also I have pasted the FCC parameters,

I want to send the .txt file which contains the data as

Sunil,Bangalore

Shetty,Bangalore

( for multiple records..)

Note : I m getting the o/p for single records...

Pls help me.....

Sender Target

Record Record

Row Row

Name string 1..unbounded ---> Name string 1..unbounded

Addr string 1..unbounded ---> Addr string 1..unbounded

Source Dir : c:/send

File Name : send.txt

Document Name : Message type name

Document Namespace : urn:....

Recordset Name : Record

Recordset Structure: Row,*

Row.fieldNames : Name,Addr

Row.fieldSeparator : ,

Row.processConfiguration : FromConfiguration

Row.endSeparator : 'nl'

Thanks in Advance....

Former Member
0 Kudos

sunil,

make our Row 1 to OUNBOUDED in source and traget structure.

Regards

Sreeram.G.Reddy

Former Member
0 Kudos

Hi,

Please chenge your structure ..

Row --- 0..unbound

name --1.1 or 0.1

addre -- 1.1 or 0.1

Now works..

Regards

Chilla..

Former Member
0 Kudos

HI,

This you have to check in sender side adapter / communication channel monitor .. where the exact error is occurred.. through RWB ..

Also check the below links to see the Content conversion parameters..

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1 - File to File Part 1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2 - File to File Part 2

/people/michal.krawczyk2/blog/2005/11/10/xi-the-same-filename-from-a-sender-to-a-receiver-file-adapter--sp14

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns - FCC

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file - FCC

/people/harrison.holland5/blog/2006/12/20/xi-configuration-for-mdm-integration--sample-scenario - FCC

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp - FCC

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy - FCC

/people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter - EOIO - File

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Regards

Chilla..

Former Member
0 Kudos

HI Sunil check in SXMB_Moni ? is it sucessful processed or any error in SXMB_Moni if everthing is sucess then check in RWB adaptyer monitroing of reciver adapter.

Regards

Sreeram.G.Reddy

Former Member
0 Kudos

Hi Sunil,

<i>the file which is .txt is picking up</i> - so if you have in sender file comm channel, delete mode, then the source file is deleted or not.......if source file not deleted, then go to RWB - Component monitoring - adapter monitoring - File adapter....see the error in your source file adapter........rectify the error in comm channel from ID.....Activate the comm.....test your scenario again......

if source file is deleted, go to SXMB_MONI.......See the msg of your scenario....whether it is successfully processed i.e. chequerd flag or it is in error i.e. red flag.......if red flag, then what error occured - mapping error or some other error - double click the msg and see what error is there...........

if successfully processed, then see the queue status column of this msg .... see is the queue status is in wait status - yellow triangle......if queue is in wait status, go to SXMB_ADM, activate queue............again test your scenario......

if nothing is in the queue and queue is active, then go to RWB - Component monitoring - adapter monitoring - File adapter....see the error in your receiver file adapter........rectify the error in comm channel from ID.....Activate the comm chanel.....again test your scenario.....

Then your output file will be generated.

Thanks,

Rajeev Gupta

Message was edited by:

RAJEEV GUPTA

bhavesh_kantilal
Active Contributor
0 Kudos

Hi,

Check the Communication Channel Monitoring / Adapter Monitoring and check if there is an error in your Sender File Adapter.

Regards

Bhavesh