Error Loading Rate data through Data Manger Pakage

[Former Member]

Hi all,

I wanted to load the Rate data so I uploaded my excel file on the server and it was successful. Even when I preview the data file it shows me first 200 records but when I run the Data Manger Pakage, I see the following error in the status.

TOTAL STEPS 2

1. Convert Data: Failed in 0 sec.

[Selection]

----

---

FILE=\STUDENT\RATE\DataManager\DataFiles\My Files\Rate.xls

TRANSFORMATION=\STUDENT\RATE\DATAMANAGER\TRANSFORMATIONFILES\SYSTEM FILES\IMPORT.XLS

CLEARDATA= No

RUNLOGIC= Yes

CHECKLCK= No

[Messages]

----

---

The data file is empty. Please check the data file and try again.

My Transformation file is as follows::

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER =

SKIP = 1

SKIPIF =

CREDITNEGATIVE=NO

CONVERTAMOUNTWDIM=

MAXREJECTCOUNT=

VALIDATERECORDS=YES

*MAPPING

*CONVERSION

Please help.

Diksha CHopra.

Edited by: Diksha Chopra on Apr 10, 2010 12:45 AM

[former_member599120 · Accepted solution]

Dear Diksha Chopra,

I saw your transformation file, the option *MAPPING not have some values. My suggestions are:

1. Please you configure *MAPPING and *CONVERSION if you need, Maybe it is a cause your import data failed.

2. Maybe you could change the option *SKIP=0

2. Please make sure your data in text file and have header in your data file.

3. Please make sure your amount have general format

Kind Regards,

Wandi Sutandi

[Former Member · Accepted solution]

Hi Wandi,

Format of my text file is

Category,InputCurrency,Rate,RateSrc,Time,Amount

and format of my Rate application is

Category,InputCurrency,Rate,RateSrc,Time

do I have to create/add Amount dimension to the application? if yes, then do I have to create a user define dimension?

I am new to this and appreciate your help.

Thanks,

Diksha.

[Former Member · Accepted solution]

Hi Diksha,

Amount is the key figure. Every application in BPC will have this key figure by default. So, there is no need to add this separately. As suggested, I would request you to remove the mapping / conversion, if not required. If your flat file has the header, if everything is in the proper format, then you dont require the transformation file.

Hope this helps.

[former_member599120 · Accepted solution]

Dear Diksha Chopra,

I think that your the option *MAPPING have something wrong, so your import process failed. Please you do some directions as following:

1. Please you open your transformation file which you used for import process.

2. You could copy and paste *MAPPING configuration this into your transformation file:

*MAPPING

Category=*COL(1)

InputCurrency=*COL(2)

Rate=*COL(3)

RateSrc=*COL(4)

Time=*COL(5)

Amount=*COL(6)

3. Validation and Save the transformation file

4. Please make sure you put header into you data file and the order of header likes: Category,InputCurrency,Rate,RateSrc,Time,Amount

Kind Regards,

Wandi Sutandi

[Former Member · Accepted solution]

Hi Wandi,

It worked. Thanks so much.

I really appreciate it.

Thanks.

Diksha.