Prevent and Identify erroneous files or information uploaded via mass upload (data shuttle)

Vanessa Soto

As we know, if the information that is loaded through mass upload does not meet the criteria we have set in the data shuttle, the information will not be loaded, and the fields/columns will remain blank. But the users who are loading the information cannot know the reason why the mass upload is not running.

The proposals for this situation are as follows.
1.- In the data shuttle settings, the row for the headers can be set as optional and the system will automatically recognize the row with text meaning the headers. From there, Smartsheet can load the necessary information.
2.-Smartsheet can create a pop-up warning sentence for users who are uploading information via mass upload (data shuttle) with the specific reason why their file is incorrect. In this way, users will receive a notification if the information uploaded via mass upload contains errors. For example, a sentence that mention; the information does not appear in the row/tab in which the data shuttle was configured, so the information cannot be read.

Ribbon settings.PNG