Skipping fields during content conversion

[Former Member]

is it possible to skip fields during content conversion in file sender adapter?

The case is, the CSV file contains 300+ field and i only need 10. Therefore i have created a datatype with those 10 field.

I was hoping to skip the fields i do not need during content conversion.

If this is not possible i see no other than to create a datatype with 300+ fields by hand. Which will take all day!

Hopefully there is a solution, since i could not find what i needed on the SAP Help or SDN.

Thanks in advance for all your time!

[Former Member · Accepted solution]

Hi,

The case is, the CSV file contains 300 field and i only need 10. Therefore i have created a datatype with those 10 field. +

All the thing you need to do is to define your structure with 10 fields and in the file adapter specify all the field names(300)

This works....

Regards

Harsha Paruchuri

[Former Member · Accepted solution]

Thanks Harsha! This solved my problem.

[Former Member]

What if you want to skip fields on the Reciever File Content Conversion, e.g. there is a value at the end of the payload that was used for internal XI purposes, but you do NOT want to write it out to the file.

Thanks,

Matt

[rajasekhar_reddy14]

Hi ,

Instead of skipping fileds at FCC level, you can skip at mapping level.

my suggestion is read all fileds available in source message, create one data type for this .Create one more data type which has only 10 fileds.

then map source message to 10fileds message,that means your skipping fileds here.

cheers,

raj

[Former Member]

Hi M,

 is it possible to skip fields during content conversion in file sender adapter? 

No .. this is not possible during FCC.

 The case is, the CSV file contains 300+ field and i only need 10. Therefore i have created a datatype with those 10 field. 
Hopefully there is a solution, since i could not find what i needed on the SAP Help or SDN.

Well, you can give it a shot. There are freewares available on internet, which can transform the CSV file to XSD. Then you can import that XSD structure in ESR.

The only point is that your source CSV file must be having the header (with all field names on it).

I had done this with another integration tool, no idea how it will work with PI. But it's worth giving it a try.

If this is not gonna happen, then you have no other option but to create complete DT manually or use adapter module (not recommended for such cases).

Regards,

Neetesh

[Former Member]

Hi Koevoets,

There is no work around for this. If you want only 10 fields then why is your source system is generating 300 fields, ask them to write a file with only 10 fields (if possible). Else you have to manually key in all the fiedls in the datatype (I know its a pain), but you cannot avoid it.

else you can come up with an adapter module, so more maintenace.

Have a beer in your hand while creating

Regards,

---Satish

[Former Member]

Hi,

If the fields You want to read are not in sequence, you are not to able to get your requirement with FCC.

What You can do is build a module to delete the fields you do not want, It would work before the FCC.

Regards

Ivan