Skip to Content
0
Former Member
May 08, 2008 at 04:44 AM

Flat file load issue-Urgent

63 Views

Hello

I'm trying to load a master data infoobject with a flat file and getting errors.

The infoobject ZCOLLECT_DATE has two fields - ZQUARTER and ZCOLLECTDATE

ZCOLLECT_DATE is of Data type NUMC, Length 5, conversion routine PERI5 and Output length 6

I created a flat file in Excel the following way:

Left the first row blank

Second column - 1/2008 (for ZQUARTER)

Thrid column - 01/11/2008 (for ZCOLLECTDATE)

I saved it as a CSV (save as-> csv).

In the infopackage, I've selected this file in the External data tab, File type CSV, Data separator ; , Escape sign "

When I try to load the infoobject, I get the following error:

"Error in conversion exit CONVERSION_EXIT_PERI5_INPUT"

I thought this was because the Length in my infoobject was 5, whereas ZQUARTER is of length 6 in my flat file (eg-1/2008) and ZCOLLECTDATE is of format mm/dd/yyyy.

Any thoughts on what the issue is?

Thanks

Alex