File Content Conversion problem

[Former Member]

Hi Experts,

I have File to RFC scenario .

The FCC is from .ASC file to XML in File Adapter.

In FCC the below details are configured,

Document name is "GMTotals";

Recordset Structure is "GMTLogTransactionF,,GMTLogTransactionTL,";

Recordset Sequence is " Variable";

Key Field Name is "TransactionType",

Key Field Type is "String(Case-Sensitive)";

ignoreRecordsetName value is true;

GMTLogTransactionF.fieldNames value is <TransactiopnType,fieldname1,fieldName2>

GMTLogTransactionF.keyFieldValue value is "F",

GMTLogTransactionF.fieldFixedLengths value is "2,1,4";

GMTLogTransactionF.lastFieldsOptional value is "YES";

GMTLogTransactionTL.fieldNames value is <TransactiopnType,fieldname1,fieldName2,field3>

GMTLogTransactionTL.keyFieldValue value is "TL",

GMTLogTransactionTL.fieldFixedLengths value is "2,1,4,2";

GMTLogTransactionTL.lastFieldsOptional value is "YES";

a) If the File is " F 22345

TL1123421

"

then only TL type is converted to XML and F type is not converted to XML by File Adapter

b) If the file is " F 22345

"

then Adapter warning is "Empty document found. Proceed without sending message"

But the funny thing is if the FCC is like

Document name is "GMTotals";

Recordset Structure is "GMTLogTransactionF,*"

Recordset Sequence is " Variable";

Key Field Name is "TransactionType",

Key Field Type is "String(Case-Sensitive)";

ignoreRecordsetName value is true;

GMTLogTransactionF.fieldNames value is <TransactiopnType,fieldname1,fieldName2>

GMTLogTransactionF.keyFieldValue value is "F",

GMTLogTransactionF.fieldFixedLengths value is "2,1,4";

GMTLogTransactionF.lastFieldsOptional value is "YES";

GMTLogTransactionTL.fieldNames value is <TransactiopnType,fieldname1,fieldName2,field3>

GMTLogTransactionTL.keyFieldValue value is "TL",

GMTLogTransactionTL.fieldFixedLengths value is "2,1,4,2";

GMTLogTransactionTL.lastFieldsOptional value is "YES";

then the F type is converted to XML file properly without any error.

for the file

"F 21234"

Please help to solve the issue.

Regards,

Amit

[Former Member]

Hi,

Please see the below extract from help.sap

Key Field Name

If you specified a variable number of substructures for Recordset Structure, in other words, at least one substructure has the value u2018*u2019, then the substructures must be identified by the parser from their content. A key field must be set with different constants for the substructures. In this case, you must specify a key field, and the field name must occur in all substructures

I think a * is required in the RecordSet Structure for key field to work..

Regards,

Divya

[Former Member]

Hi,

After the * in Recordset Structure the below error in Adapter

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Format error in 'xml.recordset' argument: incomplete structure (name,number) pair.

Pls help.

[Former Member]

no, i did not mean only *

you have to give Recordset Structure is "GMTLogTransactionF,*"

[Former Member]

Hi ,

Thanks for the quick response.

Yes, this was my mistake ;

Recordset Structure I configured at first as " GMTLogTransactionTL,,GMTLogTransactionF,".

This was my mistake to provide the input, I missed out the *.

Pls help.

[Former Member]

Hi,

Recordset Structure I configured at first as "" GMTLogTransactionTL,"",GMTLogTransactionF,"".

Note: * is not taking until "".

[Former Member]

Hi,

Please help me to solve the issue.

Regards,

Amit

[Former Member]

Hi,

Please help to solve.

[Former Member]

Hi Amit,

Can you give the sample file and the message type you have created here so that somebody can help you out.

Regards,

---Satish

[Former Member]

Hi,

File is

F 23456

TL18765