Data File Upload Instructions : ACR Support

TABLE OF CONTENTS

Purpose
Steps to Upload a File
Checking File Upload Status
Viewing Rejected Records

Purpose

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: 3D Printing Registry, 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. If the field is left blank for a given row, that row will be uploaded to the facility currently selected in the facility picker.
Click on the desired registry on the left side of the screen, then click Upload Data File from the Data Management menu.
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.

Click the Upload button

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.

Checking File Upload Status

Note: The Upload Errors Report provides immediate feedback about file upload status for an individual facility--or for multiple facilities within the same Corporate Account. The report includes file-specific error and warning details and can be especially helpful for identifying rejected files and files with rejected records across multiple facilities.

The table includes the following columns:

Facility	The facility for which record counts apply. Rows for other facilities included in the file are not counted.
Filename	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.
Received	The date and time the file was submitted to the registry, in Eastern US Time.
Loaded	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.
Status	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 when you click the icon. Cancelled by user – The upload was cancelled by the person attempting to submit the file. Load failure – The file was successfully uploaded, but valid records from the file could not be added to the database. Please contact the NRDR Help Desk for assistance if your file has a status of Load Failure.
# 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 by clicking Download Log File or Show Log File in the Action column. 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 added with warning	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 updated with warning	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.
Action	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: The Delete Data File option is only available for files that are in pending status. It is not possible to delete a file that has already been uploaded.

Viewing Rejected Records

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.
View Details	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.

Previous: Manual Data Entry

Next: Web-based Data Transmission

How can we help you today?

Data File Upload Instructions Print

Purpose

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: 3D Printing Registry, CTC Registry, GRID, LCSR, and NMD.

Steps to Upload a File

Log in to NRDR

Click on the desired registry on the left side of the screen, then click Upload Data File from the Data Management menu.

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.

Click the Upload button

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.

Checking File Upload Status

The table includes the following columns:

The facility for which record counts apply. Rows for other facilities included in the file are not counted.

Filename

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.

Received

The date and time the file was submitted to the registry, in Eastern US Time.

Loaded

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.

Status

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 when you click the icon.

Cancelled by user – The upload was cancelled by the person attempting to submit the file.

Load failure – The file was successfully uploaded, but valid records from the file could not be added to the database. Please contact the NRDR Help Desk for assistance if your file has a status of Load Failure.

# 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 by clicking Download Log File or Show Log File in the Action column.

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

added with

warning

# 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

updated with

warning

Action

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:

The Delete Data File option is only available for files that are in pending status. It is not possible to delete a file that has already been uploaded.

Viewing Rejected Records

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.

View Details

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.

Related Articles