Hi @jas condes!
When you do an import, you know that you have the chance to make a preview that checks structures and data. There you (the user) have a first control to help.
Then, each import message is recorded in the integration message tables. WHAT you would be looking for is, to get that message and display it on the screen.
The messages are in MAXINTMSGTRK (where STATUS = 'ERROR') and in MAXINTMSGTRKDTL (where STATUS = 'ERROR').
You can analyze and show the errors for each record processed (MXLOADER does it), but other validations, such as knowing if the CSV has data, I understand that you would need an external program for that because I don't know anything that does it.
Once, an external system left me a consumption log in its own format. We had to process it to the format demanded by the object structure to import to Maximo, and we did that with a Java program (it was an automatic process, the log was processed by the java program, saved properly as csv and then the CRONTASK FLATFILECONSUMER read it).
I'm going to look to see if I can find anything that can help you move forward.
Regards!