External Flat File Import - CSV

 Delivered external flat file import by default gives the file format as fixed however in peoplebooks its been recommended to change to csv based on requirement. However after changin to csv and using the process,it doesnt behave in the same way as the fixed file format.For example,

1.In fixed format if a file with 35 characters in line description is uploaded ,the process goes to no success and shows in which line the error is present.However if the same file is uploaded in csv,the process just goes to no success and doesnt show where the error is present.So we are manually having to go through files of lakhs of lines identifying where the error is.