User Access: The features and tools in this article are only available to Advisor-level users.

 

Executive Summary (TL;DR) Custom Imports let advisor-level users create or update multiple records at once across the database, rather than editing items one at a time. Download a template, fill it out, upload it, fix any errors or warnings, and apply the import. This article covers: - Enabling the privileges needed to use Custom Imports - Downloading and processing an import template - Making changes inside the import tool and validating them - Reviewing, troubleshooting, and excluding errors and warnings - A reference list of common custom imports

 

 

What Does This Article Help Solve?

Common Real-Life Questions Users Ask About Custom Imports

"How do I update a large group of accounts at once instead of one at a time?"

"Why won't the system accept my template file?"

"My import has rows with errors — how do I fix them or skip them?"

"What's the difference between a row with an error and a row with a warning?"

"Which import do I use to update transactions, households, or models?"

 

 

Article Quick Links

Why Utilize Custom Imports?
What is the Value of Custom Imports?
How Do I Get Started with Custom Imports?

User Privileges

Custom Imports Tool

How to Download and Process an Import 

How to Make Changes to the Template within the Import Tool

How to Troubleshoot Messages for the Import

Instructions for Common Custom Imports

 

Why Utilize Custom Imports?

• Streamline your portfolio management and save precious time! Use Custom Imports to create or update multiple entities, fields, or items at once across your entire database.

 

Common Use Cases
Move transactions between assets with ease by using the Transaction Update import!
Adjust representative assignments en masse with the Household Update import.
Seamlessly manage your alternatives with the many AIP custom imports available.

 

What is the Value of Custom Imports? Do you have numerous transactions needing to be added to an Account? Need to update several models? Well, look no further. Orion’s Custom Imports functionality is here to help. Custom imports provide the ability for certain groups of information to be imported into Orion en masse, and they are found within the Custom Imports App. Please review the applicable section of this article to learn more about how to process each import type.

Please Note:  A lot of the import templates require you to input the Household or Account ID for the item that is being updated. In order to easily acquire the corresponding ID, run Query ID 1922, Audit File - All Accounts, and use the VLOOKUP functionality in Excel to extract the ID from the query based on the account number for each Account.

 

 

How Do I Get Started with Custom Imports?

User Privileges

Please Note: This import is only available to advisor-level users. Utilize the Custom Imports app by enabling the following privilege for your role within the Manage Users app :

• Custom Imports 2 (Apps > Tools)

Each import requires additional permissions to be enabled to access. Enable additional permissions to access specific import templates with Custom Imports:

• Actions > Custom Imports

 

Custom Imports Tool
How to Download and Process an Import Template

• Navigate to the Custom Imports app, Import Templates tab.

• Next to the applicable import, click Download Template.

 

 

• The name of the spreadsheet can be updated; however, the name MUST end in your firm’s Owner Code/Abbreviation in order for the system to accept your template. This can be found in the Firm Profile app  > Contact Information tab > Abbreviation field. 

• For more information on how to fill out some common imports, click on the applicable import within the Instructions for Common Custom Imports section of this article.

• Once you are ready to process the template, click New Import next to the applicable import. 

• Enter an Import Name, click Select File to Upload, and drop in the template. Please note, you can skip the spreadsheet completely and manually fill in all of the same information within the import tool by clicking Proceed Without File.

Back To Top

The results from the import will display within the grid, and the audits at the top will display how many rows have an error, or a warning. Please note, rows with an error will fail and the transaction will not be created. Rows with a warning will still be created, but it is best practice to review the warning before processing the import. For more information on how to review and troubleshoot errors and warnings, click on the specific import within the Instructions for Common Custom Imports section of this article.
 

 

How to Make Changes to the Template Within the Import Tool

• Click on any of the cells within the grid to make a change to the import before processing it. After changes are made, click Validate at the top of the page. If any new error or warning results populate, review these before proceeding. 

 

 

  

• To make multiple changes to a single row or multiple rows at the same, highlight the applicable rows(s) and click the  in the upper right. Enter the necessary changes into each field, click Apply Changes, and then Validate at the top of the page. If any new error or warning results populate, review these before proceeding.

 

 

 

After all errors and warnings have been reviewed, and all changes have been made if necessary, process the import by clicking on Actions in the upper right, and select Apply.

Back To Top

• Click on  to add a new row with the grid

• Click on Reset Data within the Actions menu to update the data in the grid to match your original import. This comes in handy when you’ve made changes within the import tool, but want to start over without having to create a new import instance. 

 

How to Troubleshoot Messages for the Import

As mentioned above, the Rows With Errors and Rows With Warnings audits will appear at the top of the page after you upload the template into the import tool. Click on the audit to review the rows pertaining to each result. If a row contains an error, it will not be applied. If a row has a warning, that row will still be applied, but it is best practice to review the warning before processing the import. 

For an explanation of the errors or warning messages for our most common imports, and guidance on how you can resolve them, review the specific import within the Instructions for Common Custom Imports section of this article.
 

How to Review Error and Warning Messages

• Click on the Rows With Errors or Rows With Warnings Audit and select a transaction row within the grid. 

• Click on  in the upper right, and select the Errors or Warnings dropdown menus to review the corresponding message for the selected row.

• Click on another transaction row to review the error or warning messages that are associated with that row. 

• Review the How to Make Changes to the Template section within this article for steps on how to fix these issues.

 

 

How to Exclude Errors

Error messages require immediate attention and prohibit imports from applying. Excluding errors lets you apply the import as a whole while skipping rows with errors, so you can address them later.


A) Exclude Individual Error Rows

• Select the row(s) you wish to exclude

• Right-click and select Exclude from Import

B) Exclude Errors En Masse

• Click the Actions dropdown

• Select Exclude Errors. This excludes all errors within the import.

For information on how to exclude errors for Multiple Database imports, review Exclude Errors within How-To and Overview: Multi Database Custom Imports.
 

Back To Top

 

Instructions for Common Custom Imports
Custom Imports

Click the title of each import for more information on how to complete and troubleshoot the corresponding import template. 
 

Import Name	Import Description
Account Change History	Update account data while simultaneously noting the update in the account's Change History section.
Account Update	Edit account settings and fields en masse.
Advisor Fee Adjustments	Add or reverse a one-time debit or credit adjustment at the account level.
AIP Custom Imports	Maintain your alternative investments.
Asset Level Fee Schedule Add	Assign Asset Level Fee Schedules to multiple accounts en masse.
Asset Level Fee Schedule Delete	Delete asset level fee schedules from accounts en masse.
Asset Update	Update multiple fields for existing assets in a single account or for multiple accounts en masse.
Attribution Details	Add, edit, or remove attribution detail data en masse.
Billing Account Update	Update billing settings on the account level en masse.
Billing Asset Update	Update billing fields at the asset level en masse.
Composites	Add, edit, or remove Composite account data.
Credits & Expenses	Add, update, and delete credits and expenses to an entity's payout en masse.
Fee Hierarchy	Add, update, and delete rates from the hierarchy en masse.
Fee Schedule Add	Create fee schedules en masse.
Financial Planning Fees	Create financial planning fee accounts en masse.
Household Update	Edit household-level (client) information en masse.
Local Price	Add, update, and/or remove local prices on your products en masse.
Model Add	Add, update, and delete new models in Orion Connect.
Model Aggregate Permissions	Update model permissions en masse. This can be done for a single model, or for multiple models at the same time all within the same import template.
Notes	Add, edit, and delete new notes for Households, Registrations, and Accounts en masse.
Payee Add	Create payees en masse.
Payout Rates	Create payout rates en masse.
Payout Schedules	Create payout schedules en masse.
Preserved Historic Stored Performance	Track and preserve historic performance returns without transaction history.
Product Local Update	Update local product settings.
RB3 Version Assignment	Add, update, or delete report version assignments.
Receivable-Payable Add	Import receivables and payables calculated outside of Orion.
Recurring Adjustments	Add, update, and delete recurring debit or credit adjustments at the household or account level.
Registration RMD	Update decedent information en masse.
Registration Update	Update fields on registrations en masse.  This can be done for single registrations, or for multiple registrations within the same import template.
Related Households	Create or remove related household relationships.
Representative Imports	Add, update, or delete Representatives and Additional Representatives in bulk.
Separately Managed	Add and/or update separately managed accounts (SMAs).
Stored Performance	Import Stored Performance to track and preserve historic performance returns.
Systematics	Add or edit systematics en masse.
Transaction Add	Create transactions en masse for accounts that are manually maintained at your firm. This can be done for a single account, or for multiple accounts at the same time all within the same import template.
Transaction Fee	Track your transaction fee details. Add fees, interest, and taxes to your Exchange transactions en masse.
Transaction Update	Update fields on transactions en masse.  This can be done for single account's transactions, or for multiple accounts within the same import template.
Transaction Cost Basis Override	Add cost basis overrides to transactions en masse.
Update Collect From	Update collect from assignments for the fee hierarchy en masse.
User Defined & Entity Option Import	Update any custom field at any portfolio level or edit numerous entity level settings.

In Summary Enable the Custom Imports 2 privileges in Manage Users before starting. Download the template from the Import Templates tab and keep your firm's Owner Code/Abbreviation at the end of the file name. Upload the template or choose Proceed Without File, then click Validate before applying. Review rows with errors and warnings; exclude error rows individually or en masse to apply the rest. Use the Instructions for Common Custom Imports table to find guidance for a specific import.