File Content Conversion with Multiple structures

[Former Member]

Here is the scenario

Legacy to XI -> XI to R/3 (App Server)

txt file and fixed length.

<b>Test file</b>

100WELCOME 0430000960603201321

2000000000040008000803

<b>Table2</b>

RecordType

PriorityCode

Destination

BankOrginNo

CreationDate

CretionTime

Spaces

<b>Table2</b>

RecordType

Destination

BankOrginNo

ReferenceCode

ServiceCode

RecordLength

CharactersPerBlock

PartialCompression

CompressionSpaces

<b>Content Conversion Parameters:</b>

Document Name: Details

RecordsetName : recordset

Recordsetstructure : Table1,1,Table2,*

Recordsetsequence: Ascending

RecordsetperMessage: *

Keyfieldname : KF

Kefieldtype : String(Case-Sensitive)

Table1.keyFieldValue :'1'

Table1.fieldFixedLengths:1,2,10,10,6,4,47

Table1.fieldNames :RecordType,PriorityCode,Destination,BankOrginNo,CreationDate,CretionTime,Spaces

Table2.keyFieldValue :'2'

Table2.fieldFixedLengths: 1,10,10,10,3,3,4,1,38

Table2.fieldNames:RecordType,Destination,BankOrginNo,ReferenceCode,ServiceCode,RecordLength,CharactersPerBlock,PartialCompression,CompressionSpaces

ignoreRecordsetName :true

When I am trying with first structure it is working fine, where as 2 structures it is not.

in the adopter monitoring it show it pics the file from Legacy(file adopter display green), where as SXMB_MONI it is not showing any thing.

can any body help on this do I need to maintain any other parameters for file content conversion.

Thanks

M

[Former Member]

Hi,

Please can you check the error in runtime workbench

component monitoring-->Adapter engine.

Regards

Vijaya

[Former Member]

Vijaya Kumari,

Thanks for past response.

In runtime workbench->adopter monitoring it shows it picks the file(green color) successfully.

I can't see any thing in SXMB_MONI.

Thanks

M

[Former Member]

Hi Murali,

The Table2 has got more number of fields then that specified in your test files.

If you give extra values then defined then it gives an error in the adapter.

Please can you put correct data for the second record and see if it works.

Regards

vijaya

[Former Member]

Vijaya,

I have given like this in my post they are not visible.

Table2

RecordType,Destination,BankOrginNo,ReferenceCode,

ServiceCode,RecordLength,CharactersPerBlock,

PartialCompression,CompressionSpaces

Thanks

M

[Former Member]

HI,

I can see that.

The number of characters in the file for TABLE2 is lesser then the number of field size given.

for eg. if the table2 fixed field length sum is 20 ,your file contains only 10 characters. Please give complete data for table2

Test file

100WELCOME 0430000960603201321

<b>2000000000040008000803</b>

Table2.fieldFixedLengths: 1,10,10,10,3,3,4,1,38

Ragards

vijaya

Message was edited by: vijaya kumari

[Former Member]

Vijaya,

Might be I am wrong.

There might be some optional fields right?

They are all not mandatory fields,

some times you can't get the valuez for couple of fields.

Thanks

M

[Former Member]

Hi,

you have given fixed length. If the fields are optional then atleast you need to have spaces in between. it's position based.

if there is a fieldseparator then the length does not matter.

You can put the correct field length and then see if it works

Regards

vijaya

[Former Member]

Vijaya,

I have changed my file like this, even though it is same, I am not able to see anything in SXMB_MONI

100WELCOME 0430000960603201321

212345678900000000000123456789040008000803

Thanks

M

[Former Member]

Hi,

Please can you put endSeparator = 'nl'

Regards

vijaya

[Former Member]

Vijaya,

I solved this prob by putting "lastFieldsOptional".

Thank you very much for your help.

Thanks

M

[Former Member]

Vijaya,

When I trying to use Table4,* it is not showing any thing in SXMB_MONI.

When I use like Table4,2 (Kind of constant) it is working can you please tell me what is wrong with that and what are the parameters i need to maintain to access multiple records.

Thanks

M

[Former Member]

Hi,

Remove the quotes from the keyFieldValue paramter

Table1.keyFieldValue :'1'

Regards

Vijaya

[Former Member]

Vijaya,

I have removed quotes from the the key field value,

It is not recognize the key fields.

When I put the table1,* it is not showing any thing in SXMB_MONI.

Can you tell what are the parameters needs to be maintain

thanks

M