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
- Check that there are no empty dates
- Check that date format should look like 3/14/1998 in cell format
- Check that the SSN field does not start with a letter
- Check that the zipcode field does not start with a letter
- If all checked above, try saving as an Excel 4.0 version
© 1999-2007, ACS Wagers, Inc.
Importing
