How would you export a PRN file from Appraise or Appraise SaaS and import it into ONESOURCE FPS 706 program?

Created At: Jan 12, 2024 Last Updated: Oct 21, 2024

Appraise & Appraise SaaS .PRN Export

Setting the Export Option
Appraise Software Main Menu
  1. On the Main Menu, click on "System Setup"
Appraise Software System Setup Import/Export Tab
  1. Click on the “Import/Export” Tab
  2. On either the "Export Data" option or "Import Data" option click on the Up or Down arrow buttons until "ONESOURCE" is displayed.
  3. Click on the “ONESOURCE” text in the box so it is highlighted in blue (this indicates that the option is selected). Changing either "Export Data" or "Import Data" will change the other automatically.
Creating the PRN File
Appraise Software Estate Portfolio Modify Screen
  1. From the Main Menu, click on "Modify Portfolio" and select the portfolio you would like to make a .PRN Export file for.
  2. Click on the "File" dropdown menu in the top left part of the window.
  3. Click on the "Export Portfolio to PRN" option in the dropdown menu.
  4. This will create a .PRN file in the same directory that all of your Appraise portfolio files are saved.
  5. For Appraise users => C:\APPRAISE\DATA unless it has been changed in "System Setup"
  6. For Appraise SaaS users => Check in "System Setup" under the "Directories" tab for your "APPRAISE DATA" folder location.
ONESOURCE FPS 706 .PRN Import
FPS 706 Software Dropdown Menu
  1. Open your ONESOURCE FPS 706 program and click on the "File" dropdown menu in the top left.
    1. Move the mouse cursor over the "Import" option
    2. Move your mouse over the newly visible "Import From Valuation Services" option
    3. Click on the "ESI" option
FPS 706 Software File Import Settings
  1. Click on the "..." button located at the end of the "Date of Death File" box. This will allow you to browse to the location of your .PRN file.
FPS 706 Software PRN File Browser Window
  1. Once you have navigated to the appropriate .PRN file, click on the file to highlight it then click the "Open" button.
FPS 706 Software File Import Settings with file selected
  1. The file location will display in the "Date of Death File" text box for verification.
  2. Select any necessary settings for your work specifications, then click on the "Next" button.
FPS 706 Software Asset Overview Screen
  1. This screen will display all the securities listed in the portfolio's .PRN file. Securities are listed with valuation date and the schedule they will be imported to. Verify all settings are correct and click on the "Import" button.

The import process should now be complete, select the "Schedule" to view your imported assets.