Open topic with navigation

Import Data into a Bound Book

Complete the following procedure to import firearm data into a bound book by creating, populating, and importing a formatted Excel file.

1. Navigate to the desired Import data from Excel screen.

   1. Log In to the Data Center Application to display the Data Center ribbon menu.

      

   2. Select the appropriate option to display a warning window in front of the desired Import data from Excel screen:

      • Select Firearms > Enter Bound Book > Non-NFA to display the Import data from Excel screen.
      • Select Firearms > Enter Bound Book > Gunsmith to display the Import data from Excel screen.
      • Select Firearms > Enter Bound Book > NFA to display the Import data from Excel screen.

      

   3. Click the Continue button to close the warning window.

   

2. Right-click on the list to display a Save Template option.

   

3. Click the Save Template option to display a Save As window.

   

4. Complete the following procedure to save the template (Excel file):

   1. Browse to the desired location.
   2. If needed, enter/edit the document name in the File name field.

   3. Click the Save button to save the document as an electronic file.

5. Open the saved Excel file template.

6. Populate the Excel file with firearm information.

   Note: The file must adhere to the validation requirements indicated below:

   • No entry may have the same value for Log # as any other entry in this file or already in the system.
   • A UPC must be a 12-digit number.
   • The New/Used, Manufacturer, Importer, Model, S/N (serial number), Action, Caliber/Gauge, and Acquired Date columns are required.
   • Any entry in the Action column must conform to the selected Bound Book: The NFA book only accepts NFA options, the Non-NFA book only accepts non-NFA options, and the Gunsmith book accepts all firearm types.
   • The system requires that either the ACQ Vendor Name column or the ACQ First Name and ACQ Last Name columns are populated.
   • Any entry in the ID Type In or the ID Type Outcolumn must exactly match one of the types defined on the Identification Types screen. (Select Setup > Identification Types to view this screen.)
   • If an entry's Disp Date column is populated, the system requires that either the Disp Vendor Name column or the Disp First Name and Disp Last Name columns are populated.

7. Save the populated Excel file.

   

8. Click the Upload button on the Import data from Excel screen to display the Load Excel Import window.

   

9. Browse to the desired location.

10. Double-click the saved Excel file to select it and start the import process.

    Note: This process will overwrite any information that was previously on the screen.

11. When the import is complete, the system displays the uploaded information on the Import data from Excel screen.

    Note: If the system detects any errors with the uploaded data, it highlights the cells containing bad or missing information.

    

12. Locate and fix any validation errors.

13. Click the Submit button to place the displayed data in the associated Bound Book.

14. If the system detects validation errors, it displays an error message window.

    

    Click the Close button to return to the Import data from Excel screen without updating the associated Bound Book and fix any outstanding validation errors as needed.

15. When the import is complete, the system displays an informational window.

    

16. Click the Close button to close the window and screen