Correcting and Resubmitting Data

After you submit the data to the database, the result of entering the data into Excel to Component Interface utility appears on the Staging and Submission sheet. If a submission generates an error or a warning, the Status column in the Staging and Submission sheet displays that.

You can read the errors and warnings messages on moving your cursor over the Status column. Also, the utility adds an Errors page which displays consolidated error messages with the respective row numbers.

If you click a cell that displays Error link in the Status column, an HTML page opens. This HTML page also displays the complete list of error and warning messages in a tabular format.

Both the Errors sheet and the HTML page help to display all error messages and warnings on a single sheet. You can correct the input data before staging it for submission to the database again. You can continue this process of correcting errors and resubmitting the data until no errors remain.

Note:

Data that was not submitted because the error threshold was reached will have no status. When the data that created the error is corrected on the data input sheet, the data that was not submitted will be staged to the database.

Submission Statuses

Errors received for each record submitted appear in a comment field when you move the cursor over the status column. The records marked OK in green have been successfully submitted and cannot be restaged for submission and can be kept as a record of work completed.

One of the following three status values can appear when you submit data to the database:

Field or Control	Description
Ok	The submission to the database finished successfully. The field is highlighted in green. These records cannot be restaged for submission.
Warning	The data was saved to the database successfully, but a warning was generated in the process. The field is highlighted in yellow.
Error	The data was not saved to the database due to an error. This field is highlighted in red with a hyperlink to a HTML page. The field provides two options to see the error details that the component interface generated. Click the Error link to access the HTML page with the error details. Place your cursor on the Status field to see the error messages in a comment box. Note: The same errors are also consolidated in the Errors worksheet in the Excel to Component Interface utility.