Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error Loading Rate data through Data Manger Pakage

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 Member
Former Member replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question