SAP BPC 10.1 MS Problem with import with no Header row

[former_member392480]

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.

[former_member392480]

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

[Former Member]

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

[former_member392480]

Import file:

Transformation:

Data Preview:

Ave

[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.....

[former_member392480]

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.

[Former Member]

Please post the file in readable format.........or rather post a screenshot!

[Former Member]

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