Unclaimed Property Systems
A division of Affiliated Computer Services, Inc.
 
 
5777 Central Ave Suite 227     Boulder, CO 80301        Phone: (303) 413-9450     Fax: (303) 413-0442
 
 
Holder Reporting System

Frequently Asked Questions
HRS Pro Importing



Can I import the NAUPA II formatted file back into HRS Pro?

Why am I getting errors when I finish importing my sdf or dbf import file?

My unclaimed property data is an Excel spreadsheet. Can I import my spreadsheet into HRS Pro?

Is the NAUPA II template in the latest HRS Pro software the same as the older software (NAUPA I template)? Where can I find the new template?

Error message NO OWNER LASTNAME

Error message about invalid date


Can I import the NAUPA II formatted file back into HRS Pro?

No. The file that is generated is meant for import by the state to which you are sending the report. It cannot be imported back into HRS Pro. To correctly import data into HRS Pro, follow the file format specified in User's Guide.

Why am I getting errors when I finish importing my sdf or dbf import file?

Be sure that your import file is formatted correctly and is exactly how it is shown in User's Guide. Be sure that you also have the correct codes for the state you are reporting to when importing also.

My unclaimed property data is an Excel spreadsheet. Can I import my spreadsheet into HRS Pro?

Yes. Instructions for importing your Excel spreadsheet into HRS Pro can be found in the User's Guide.

Is the NAUPA II template in the latest HRS Pro software the same as the older software (NAUPA I template)? Where can I find the new template?

No, in the new HRS Pro software, the template.dbf has several extra columns on the end for primary owner relation code, check number and (for OK properties) mineral rights. In addition, the new HRS Pro will now import .xls files. You can now save it as a .xls file after adding your data. If reporting to multiple states, you can save time by filing in the owner relation column with the appropriate code for primary and secondary owners.

Check each states "Guidelines" for appropriate codes. If you are reporting to just one state, you don't need to fill the code in the spreadsheet because you can choose the code to fill in automatically before importing, on the preview import screen.

The template.dbf can be found in the installation directory of HRS Pro.

Error message NO OWNER LASTNAME

If an error message about properties existing with no owner Lastname check that there is not a totals at the bottom of the spreadsheet that would have an empty Owner Lastname on that line.

Error message about invalid date

  1. Check that there are no empty dates
  2. Check that date format should look like 3/14/1998 in cell format
  3. Check that the SSN field does not start with a letter
  4. Check that the zipcode field does not start with a letter
  5. If all checked above, try saving as an Excel 4.0 version





© 1999-2007, ACS Wagers, Inc.