Index outside the bounds of the array

[Former Member]

Hi there,

I've created the csv file and need to import it into BPC but I keep getting the following message.  Any ideas?  The data file has no large numbers in - I've even changed it to just have 1 number but the same error message keeps appearing.

TOTAL STEPS  2
1. Convert Data:     Failed  in 1 sec.
2. Import:           completed  in 1 sec.

[Selection]
------------------------------------------------------------
FILE=\EBIQUITY\CONSOLIDATION\Team Files\Users UK Finance\DataManager\DataFiles\\2014-15\FD DATA Jul 14.csv
TRANSFORMATION=\EBIQUITY\CONSOLIDATION\DataManager\TransformationFiles\\FD_LEDGER_TRANS.xls
CLEARDATA= Yes
RUNLOGIC= Yes
CHECKLCK= Yes

[Messages]
------------------------------------------------------------

Index was outside the bounds of the array.

Thanks

Amanda

[Shrikant_Jadhav]

Hi Amanda,

Can you pls share your data file along with the transformation and conversion files.

Regards,

Shrikant

[Former Member]

Thanks

Data file

DEPT	ACCOUNT	INTERCO	TIME	VALUE
FD	BAL7100	BAL7100	2014.Jul	322,120.47
FD	BAL7102	BAL7102	2014.Jul	0

[Former Member]

transformation file

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = COMMA

SKIP = 0

SKIPIF =0

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=-1

ROUNDAMOUNT=0

*MAPPING

ACCOUNT=*COL(2)

AUDITID=*NEWCOL(GL_INP)

CATEGORY=*NEWCOL(ACT)

CONSOVIEW=*NEWCOL(NOSCOPE)

CURRENCY=*NEWCOL(LC)

DEPARTMENTS=*COL(1)

ENTITY=*NEWCOL(FDUK)

FLOW=*NEWCOL(F_999)

INTERCO=*COL(3)

TIME=*COL(4)

AMOUNT=*COL(5)

*CONVERSION

DEPARTMENTS=FD_LEDGER_LOAD.XLS!DEPARTMENTS

ACCOUNT=FD_LEDGER_LOAD.XLS!ACCOUNT

INTERCO=FD_LEDGER_LOAD.XLS!INTERCO

[former_member186498]

Hi Amanda,

probably there is an error in your transformation file, a dimension points to an inexistant column in your input file,

e.g. ACCOUNT=COL(9) but your input file has only 8 cols.

Please check your transformation file to see if all dimension fit the right column in the input file.

Otherwise please share your transformation, input and conversions file.

Regards

     Roberto

[Former Member]

Transformation file looks ok.  How do I attach the transformation, input and conv files into this message? It will only let me insert videos, images or links into this message?

[former_member186498]

Hi Amanda,

you can copy the text of the files and putting here,

for the input file just the header and a couple of line are sufficient

Regards

     Roberto

[Former Member]

Data file

DEPT	ACCOUNT	INTERCO	TIME	VALUE
FD	BAL7100	BAL7100	2014.Jul	322,120.47
FD	BAL7102	BAL7102	2014.Jul	0

[Former Member]

Conversion files - Departments tab

EXTERNAL	INTERNAL	FORMULA
BAL*	BAL
FMD*	FD
7000*	BAL
8000*	BAL

[Former Member]

Conversion file - account tab

EXTERNAL	INTERNAL	FORMULA
7000EUR	7000
8000EUR	8000
BAL6040	6060
BAL6041	6160
BAL6140	6070

[Former Member]

Conversion File - interco tab

EXTERNAL	INTERNAL
7000EUR	NON_INTERCO
8000EUR	NON_INTERCO
BAL6040	NON_INTERCO
BAL6041	NON_INTERCO
BAL6140	NON_INTERCO
BAL6141	NON_INTERCO

[Former Member]

transformation file

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = COMMA

SKIP = 0

SKIPIF =0

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=-1

ROUNDAMOUNT=0

*MAPPING

ACCOUNT=*COL(2)

AUDITID=*NEWCOL(GL_INP)

CATEGORY=*NEWCOL(ACT)

CONSOVIEW=*NEWCOL(NOSCOPE)

CURRENCY=*NEWCOL(LC)

DEPARTMENTS=*COL(1)

ENTITY=*NEWCOL(FDUK)

FLOW=*NEWCOL(F_999)

INTERCO=*COL(3)

TIME=*COL(4)

AMOUNT=*COL(5)

*CONVERSION

DEPARTMENTS=FD_LEDGER_LOAD.XLS!DEPARTMENTS

ACCOUNT=FD_LEDGER_LOAD.XLS!ACCOUNT

INTERCO=FD_LEDGER_LOAD.XLS!INTERCO

[former_member186498]

Hi Amanda,

I see several errors:

• DELIMITER = COMMA correct syntax should be DELIMITER = , because he accept only one character, exception are SPACE and TAB, see plase Data Transformation
• in your input file you use TAB (or SPACE) to separate the fields so you have to write
  DELIMITER = TAB (or SPACE)
• you have FD as Department in the input file so you have to chabge internal and external in Conversion files - Departments tab (FD should be in the external col)
• I don't see BAL7100 BAL7102 in your account and intco conv. files, please check that you have these in the external column
• use SIGNEDDATA = *COL(5) instead of AMOUNT=*COL(5)
• the value in input file should be without formatting (no thousand sepator)

Regards

     Roberto