TABLE OF CONTENTS
This article provides instructions for uploading a data file using the Upload Data utility in the NRDR Portal. For registry-specific data upload details, see the article for the: CTC Registry, GRID, LCSR, and NMD.
Steps to Upload a File
Log in to NRDR
Select the facility to which you wish to upload the data, using the facility picker in the upper right corner of the portal.
Note: You may upload data for multiple facilities within a single file by populating the Facility ID column in the upload file. However, Facility ID is not a required field in the data file. In the event the field is left blank for a given row, that row will be uploaded to the facility currently selected in the facility picker.
Click the Browse button to locate the file you want to upload or drag the file and drop to the box shown in the LCSR example below. Refer to the links in the Purpose section above for file naming conventions.
A confirmation message appears stating the file has been received. If there are errors, you can either continue or cancel the upload. If you click Continue the valid records will be uploaded. If you click Cancel none of the records will be uploaded.
File uploads may not be larger than 50MB for CTC, GRID, LCSR and NMD.
Checking File Upload Status
The table includes the following columns:
The name of the file, with your facility ID added to the beginning of the name. Refer to the file specification for a description of the other components of the file name.
The date and time the file was submitted to the registry, in Eastern US Time.
The date and time the file was added to the registry. This normally occurs during the early morning hours of the day after the file was received.
The status of the file, indicated as one of the following:
Pending – The file was successfully uploaded, but records from the file have not yet been added to the database. All files are in pending status when first submitted.
Successful – The file was successfully uploaded. Valid records have been added to or updated in the database. There must be at least one valid record for the status to be Successful.
Successful with Warning – The file was successfully uploaded but includes incomplete records which require additional data to be uploaded. Valid records have been added to or updated in the database.
Rejected – The file could not be uploaded. An explanation appears in the Message column.
Cancelled by user – The upload was cancelled by the person attempting to submit the file.
The facility for which record counts apply. Rows for other facilities included in the file are not counted.
# of records in file
The number of records read from the file for the facility.
# of records rejected
The number of invalid records. These records were not added to or updated in the database. You can view a list of rejected records with reasons for rejections.
Note: When you upload your file, the column header row will be rejected as an invalid record. This is expected; consequently, all uploads with column headers will have at least one rejected record
# of records added
The number of records that were added to the registry database.
# of records
|The number of records that were added to the registry database, but are missing the additional data element(s) necessary for a complete record.
# of records updated
The number of records that were updated in the registry database. No history of changes to updated records is retained.
# of records
|The number of records that were updated in the registry database, but are missing the additional data element(s) necessary for a complete record.. No history of changes to updated records is retained.
An explanation of why a file was rejected, such as Invalid file name.
Links for viewing or downloading a log file, and for viewing details of how many records were processed for each facility ID within a file. Clicking on the ellipsis opens the available options:
You can restrict the list of files by using the search filter that appears at the top of the page. If you want to restrict the list to a certain date range, enter the dates in the Upload Start Date fields and click the Search button. You can also restrict the list by selecting a file status from the drop-down menu in the Status field.
If you uploaded a file that has rejected records, you will see as many as four links in the Action column that you can use to display the reasons for which the records were rejected:
Download Log File
Use this link to create a file of rejected records and the reasons for rejection. The file can be saved for future viewing with a software application such as Microsoft Excel. The columns in the file are delimited with a | (vertical bar).
Show Log File
Use this link to view rejected records and the reasons for rejection online, as shown in the NMD registry example, below. (Note: Please allow pop-ups for the NRDR site if you cannot view the log file)
Generate Log File
For larger file submissions, this option is available for a log file to be generated in the background as you continue to work with the NRDR portal. You will receive a notification if still in the portal (or via email notification if not) that the log file can be downloaded and reviewed.
Shows the summary of the file with record counts and status, helpful for submissions with multiple facilities.
The first column shows the order of the record in the file. The second column shows the record as invalid. The remaining columns correspond to data elements in the file. Refer to the registry's file specification for a list of data elements and their valid values and formats.
Some errors are detected as soon as you upload your file. Others are not detected until the file is processed, resulting in a file status of either Successful or Rejected. Files are normally processed overnight, but may take up to 72 hours to process.