Skip to Content
0
Former Member
Apr 12, 2010 at 06:14 PM

Problem Validating & Processing Transformation file in NW 7.0 version

43 Views

I am trying to Validate & Process Transformation File against my Data file I am getting the error message that I have at the below. When I validate the Conversion files, I see the creation of corresponding .CDM files. I even deleted the .CDM files and recreated the files.

So my question is why it is giving "Sheet does not exist (CONVERSION)" warning for which it is rejecting the records inside the Data File?

DATA FILE:

******************************

C_Category,Time,R_ACCT,R_Entity,InputCurrency,Amount

ACTUAL,2007.DEC,AVG,GLOBAL,USD,1

ACTUAL,2007.DEC,END,GLOBAL,USD,1

ACTUAL,2007.DEC,AVG,GLOBAL,JPY,110

ACTUAL,2007.DEC,END,GLOBAL,JPY,110

ACTUAL,2007.DEC,HIST,GLOBAL,JPY,110

ACTUAL,2007.DEC,HIST,GLOBAL,USD,1

ACTUAL,2008.MAR,AVG,GLOBAL,USD,1

ACTUAL,2008.MAR,END,GLOBAL,USD,1

ACTUAL,2008.MAR,AVG,GLOBAL,JPY,107.5

ACTUAL,2008.MAR,END,GLOBAL,JPY,105

ACTUAL,2008.MAR,HIST,GLOBAL,JPY,110

ACTUAL,2008.MAR,HIST,GLOBAL,USD,1

TRANSFORMATION FILE:

*********************

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

SPECIFICMAPPING=YES

*MAPPING

C_Category=*col(1)

Time=*col(2)

R_ACCT =*col(3)

R_Entity=*col(4)

InputCurrency=*col(5)

Amount=*col(6)

*CONVERSION

C_Category=[COMPANY]C_Category.xls!CONVERSION

Time=[COMPANY]Time.xls!CONVERSION

R_ACCT=[COMPANY]R_ACCT.xls!CONVERSION

R_Entity=[COMPANY]R_Entity.xls!CONVERSION

InputCurrency=[COMPANY]InputCurrency.xls!CONVERSION

ERROR

********************************

[Start validating transformation file]

Validating transformation file format

Validating optionsu2026

Validation on options was successful

Validating mappingsu2026

Validation on mappings was successful

Validating conversionsu2026

Sheet does not exist (CONVERSION)

Sheet does not exist (CONVERSION)

Sheet does not exist (CONVERSION)

Sheet does not exist (CONVERSION)

Sheet does not exist (CONVERSION)

Validation on conversions was successful

Creating the transformation xml file; wait a moment

Transformation xml file saved successfully

Connecting to server...

Begin validate transformation file with data fileu2026

[Start test transformation file]

Validate has successfully completed

ValidateRecords = YES

Task name CONVERT:

No 1 Round:

Record count: 12

Accept count: 0

Reject count: 12

Skip count: 0

Error: All records are rejected