- Get the generated file for Masterfile in server (11.17) and check the data for finding the cause of the error
- Modify the application for changing the delimiter used from comma into a pipe for faster checking and finding the cause of the error when data uploaded to MSSQL
- Test the extraction of Masterfile and generation of textile for checking if no error will return
- Re-generate the file in the server and check the data for finding the incorrect data.
- Check each row of data for one column with a comma that add new column upon uploading of data in MSSQL
- found out that there are so many SKU's with a comma in the description, reported this to Arvin for checking and for discussing the step to prevent this in the future
- a comma in the description or other columns will cause an error when uploading the data in SQL as the file is delimited by comma, it will cause an additional column when uploaded to database