Skip to Content
0
Former Member
Nov 16, 2006 at 06:49 AM

Issues with File Adapter

10 Views

Hi!

I am working on File(source.csv)->Xi->File(Target.csv) Scenario.

In my Source File i have 4 fields which are mapped to the target file which contains 2 additional fields with constant values mapped. So, I should get 6 fields at receiver end.

<b>Source structure</b>

CharacterName

Lowerlimit

Upperlimit

Targetvalue

<b> Target Structure</b>

CharacterName

Lowerlimit

Upperlimit

Targetvalue

Plant (constant value -1000)

Status (Constant value - Released)

But, While using file adapter it showing only 4 fields of my Source file at the receiver end , not the ones which have been mapped with constant values(It is with out Using FCC) .

When i use FCC under File Adapter, XI is not picking the file. These are the parameters I am defining at Sender Adapter:

Document Name : file_rece( Not sure whether it should be similar as of my Msg Type name)

RecordSet Name :Record (not sure abt naming conventions)

Recordset Structure : main,1

In parameters:

main.fieldNames:CharacterName,Lowerlimit,Upperlimit ,Targetvalue

main.fieldSeparator: ,

main.endSeparator : 'nl'

Receiving Adapter:

Recordset Structure : main,1

main.fieldSeparator :,

main,endSeparator : 'nl'

---I gone through some previous posts but cant able to resolve it.

Regards

Parth

<b></b>