Excel file is empty

[Ni_a Sy]

I watched and read about how to do the import sets and I tried it perform it well but i am just wondering but how about if the excel file is empty and i noticed it still insert to the target table. Is there anyway that you can import set and able to detect that the excel uploaded is blank and will not add to the target table and give message that uploaded excel is blank? If yes? How can I achieve that?

I am new at service now and I want to explore. Thank you.
table cmdb_rel_person. 

[Saurav11 · Accepted solution]

Hello,

How are you importing the data?

Are you directly downloading the excel in the data source and running the import set?

If the above is yes I do not think there is any way you can stop the import from running.

But keep this field on the Transform map unchecked so that empty field does snot update the value in table

Please mark my answer as correct based on Impact.

Thanks.

[Ni_a Sy]

this is the process i tried so far.

[Saurav11]

Yeah from this the system will not know if you put a empty excel and import will still run though there will not be any record created or updated.

Please mark my answer as correct based on Impact.

[Ni_a Sy]

can we create script about this?