Date format in flat file
I want to create a flat file to load data into an IC.
i have cal month data in my flat file. i am having the format as:
200511 and so on.
i used 0calmonth as my time characteristic in my Infosource and i have a flagged for conversion routine also.
but when i tried to preview in the Infopackage its not showing up. it says error: error 1 when loading data some times and also pern1 error also.
i think its the problem with the date format i am using in myflat file. can anybody please tell how to maniatin the format for calday/ calmonth/ calyear data in an flat file..
0calmonth in csv must have format MMYYYY,
and 0calday is YYYYMMDD.
and check your 0calmonth infoobject conversion routine,
it should PERI6, since your error message is pern1 ?
also try to check the infoobject sequences in 'transfer structure' (be careful can different from what you see in transfer rules infoobject mapping), should same as csv file. and try to save csv for just 1 or 2 records.
the other thing check if header for columns used in csv and 'ignore number of rows' in infopackage maintained properly. any infoobject with conversion routine pern1 used ?
separator/delimeter, decimal point, thousand separator etc check as well.
hope this helps.