how to check is .csv file is corrupted or not

Question

hi, 
 
 is there any function that we can check is .csv file is corrupted or not? 
 note:-.csv.file will receive from external system 
 
 suggest me best approch?

Harsha Sharma · Answer

I assume if a file is corrupt then any function or smart service trying to read data from it will not behave as expected. So you can try reading data from the file and log accordingly if its successful or not.

Shubham Aware · Answer

PM Exception Flow is your only native way to catch can't open scenarios. Receive File -> Try to Parse CSV -> if Success: Process Data ; if Exception: Write "CORRUPTED" to DB -> Notify Team.

Stefan Helzle · Answer

A CSV file is just text. So technically it cannot be corrupt or encrypted. But it might happen that it does not follow the expected schema. You could try to read the first line and check the column names against your expectations.

Mike Schmitt · Answer

If you're getting "bad" CSV files, open one in Notepad++ and see what text it contains, and check to see if the 'bad' version is consistently the same. 
 If it's consistent, then use the "read text from file" utility to do an initial reading of the CSV file and scan for some of the text you'd expect to (only) see in the 'bad' file. If so, route elsewhere. If not, attempt to read it using your in-process reader of choice. (Note: this requires you to do the reading via a process model, but I'd recommend you do that in any case).

Shubham Aware · Answer

You can use any available plugin to parse CSV which is available on app market. You can refer this https://community.appian.com/b/appmarket/posts/excel-tools

Harsha Sharma · Answer

Try the function previewcsvforimport() available in Excel Tools plugin to read the csv file

Mike Schmitt · Answer

sureshs276515 said: sometime we will receive the .csv file in form of excel file 
 Then this is a severe error, which you should be putting more effort into finding the root of and correcting. 
 CSV is just a text file containing comma-separated columns of values across newline-separated rows. Anything else is NOT A CSV and should NOT BE NAMED CSV. 
 Modern Excel (.xlsx) files are actually a ZIP file containing various properties, the main one being an XML file consisting of the sheet(s) data - but to handle these requires FAR different techniques.

Shubham Aware · Answer

CSV cannot have sheets; only Excel (.xlsx) can.
Get external system to send proper .xlsx file, then use readexcelsheetpaging(ri!doc, sheetNumber, pagingInfo) per sheet.
OR
get them to send separate CSV files per sheet.