Skip to Content
avatar image
Former Member

SAP BPC 10.1 MS Problem with import with no Header row

I am having a problem importing a flat file with no header row. I am using a standard import package and running on BPC 10.1 MS

Transformation file

*OPTIONS
FORMAT = DELIMITED
HEADER =NO
DELIMITER = ;
SKIP =
SKIPIF =
AMOUNTDECIMALPOINT = ,
VALIDATERECORDS=YES
CREDITNEGATIVE=YES
MAXREJECTCOUNT= -1
ROUNDAMOUNT=

I am using a mapping section

*MAPPING
ACCOUNT=*COL(4)
etc

Has anybody experienced a similar problem? During validation I get an error:
Index was outside the bounds of the array.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Feb 02, 2017 at 09:14 AM

    Can you show your flat file? try with DELIMITER = , and hopefully there are no special characters in the flat file...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 02, 2017 at 09:37 AM

    Yes of course:

    T2016.12 EK 000.000 A.12345.0 PJ.000000 PD.000 Block Unassigned TT.0 IC.0 T2016.12 EK 000.000 A.12345.0 PJ.000000 PD.000 Block Unassigned TT.0 IC.0 T2016.12 EK 000.000 A.12345.0 PJ.000000 PD.000 Block Unassigned TT.0 IC.0

    I have tried validating with a header option YES and a header row and it works.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 03, 2017 at 09:42 AM

    Import file:

    Transformation:

    Data Preview:

    Ave

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I can see spaces in ID's like "Block Unassigned". We cannot have spaces in between ID's. There are some special characters also which are not allowed. Look at the help for exceptions! "_" is most probably used instaed of a space in ID!

      P.S You have really starnge ID's T2016.12, TT.0 etc.....

  • avatar image
    Former Member
    Feb 03, 2017 at 11:30 AM

    I've tried with "_" and still get an error. Any more suggestions? I am really stuck.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Since its MS try using .txt file instead of .csv! and DELIMITER = ,(comma). Also remove the spaces after "=" in transformation file.