Skip to Content
avatar image
Former Member

Key Field Value for File Adapter Sender Wildcard

Hello everybody, is there a way to use a wildcard for the property of NamA.keyFieldValue in the cc for a Fils Sender????, here's an example why, I need to take some Files via PI 7.0 and my key filed can change according to the file an example is that in a file can be HF28 and in another file can be HF29, the only character that is going to be constant is the H, I would really appreciate any suggestions, thanks in advance.

Regards,

Julio Cesar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 04, 2008 at 01:15 AM

    Hi Julio

    File sender adapter will read the file using FCC

    Key Field Value entry is mandatory if the key field name is set. Otherwise, the entry can be ignored

    http://help.sap.com/saphelp_nw70/helpdata/EN/34/393071e9b998438ddb8ce97cd617a1/frameset.htm

    Content Conversion ( The Key Field Problem )

    Thanks

    Gaurav Bhargava

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 03, 2008 at 11:29 PM

    There is no need to use Key field value at all in sender file content conversion.

    Thanx

    Aamir

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 04, 2008 at 10:53 AM

    No, you can not use wildcard for keyFieldValue.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 04, 2008 at 05:21 PM

    Hi Julio,

    Recently came across such a scenario. We requested the sender application to produce a delimiter after the first character. Eg. H23 is now H|23 where we have the delimiter as |.

    Other option would be to make use of scripts to introduce the delimter.

    Once you have the delimiter just give the keyfield value as H.

    Regards

    Jaishankar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2008 at 08:50 PM

    Thanks everyone for your answers, now the problem is that I need to use a KeyValue cause the file contains Header and Detail Data, so I need something to differentiate the Headers an Details, now I can't actually ask a change to the file structure such as including a delimiter so it will be like H|23 cause I don't really have coperation from the 3rd party system, cause there's other applications that also use this files so there would be a lot of changes in different systems and applications, so I need to find a solution that involves only PI, I 'lle keep trying to find an option and I'll let you know, but thanks again for your answers.

    Regard's

    Julio Cesar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Try your FCC without using key field... it should work..

      Let us say there are 2 fields in header and 4 fields in detail..

      Header.fieldNames = F1,F2

      Header.fieldSeparator = ,

      Header.endSeparator = 'nl'

      Header.additionalLastFields = ignore

      Details.fieldNames = F3,F4,F5,F5

      Details.fieldSeparator = ,

      Details.endSeparator = 'nl'

      Details.additionalLastFields = ignore

      Regards,

      Sarvesh

  • avatar image
    Former Member
    Oct 08, 2008 at 04:56 PM

    Thanks, I'm goign to try both suggestions and I'll let you know soon, thanks for your answers I'll be in touch

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 13, 2008 at 06:31 PM

    Thanks for your answers I've tried your suggestions but it did not worked, I'm going to try to make the thir party coimpany to put the | delimiter after the H and D on every row, and this might work for me I'll let you know if you have any other suggestions would be really appreciated, thanks in advance.

    Regards,

    Julio Cesar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI Julio

      Why dont you write a script to modify the file and put key fields. Even using Java proxy you can read such file

      Thanks

      Gaurav

  • avatar image
    Former Member
    Nov 20, 2008 at 09:35 PM

    Thanks to everyone, I requested a little program that inserts the | character so the keys would be as I need them, thanks to everyone.

    Add comment
    10|10000 characters needed characters exceeded