Junxure asset import wizard Interfaces
See Using the Junxure Asset Import Wizard for basic instructions on performing a daily import.
This topic includes additional information specific to individual interfaces that are integrated into the Junxure Asset Import Wizard (JAIW).
The following interfaces may be used to import data into Junxure. Click on the links below for more information on individual interfaces.
Advent Axys
Before you begin, you must set up the .csv file in Advent. See our Knowledge Base Article for complete instructions on configuring this report. Users not on Junxure Version 9 may also unzip the files from this link to the c:\Junxure\AssetImports folder to run a report that includes cost basis. Note: this is a function of Advent and not supported by Junxure.
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Enter your SQL Connection String in the field provided to connect to your APX database. Otherwise, skip to step 5.
5. The Select Data File screen appears. Choose your import file from the list and click Next.
6. Click Next and you will be prompted to begin processing the data. Click Yes.
Note: The import may take several minutes to process.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
Advent Portfolio Exchange (APX)
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Enter your SQL Connection String in the field provided to connect to your APX database. Otherwise, skip to step 5.
5. Click Next and you will be prompted to begin processing the data. Click Yes.
You will be prompted to begin processing the data, and your assets and accounts will appear in a temporary grid to view.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
Note: The final step in the import is to look at the missing account list and add any accounts that should be assigned to clients in Junxure. (See Optional Step: Adding Accounts).
Aqumulate (Formerly Advisor Exchange)
NOTE: To complete the setup of the Advisor Exchange interface, you must contact Advisor Exchange at to enable the Junxure export.
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Enter in a batch name, then click OK. Otherwise, skip to step 5.
5. You will be prompted to begin processing the data. Click Yes.
You will be prompted to begin processing the data, and your assets and accounts will appear in a temporary grid to view.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
Albridge Solutions (Web Services)
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Enter in a batch name, then click OK. Otherwise, skip to step 5.
5. You will be prompted to begin processing the data. Click Yes.
6. Enter in your Partner User ID and your Financial Institution ID. (These are your Albridge credentials which must be obtained from your broker dealer.) Click OK.
Click Next once the import has been processed. Your assets and accounts will appear in a temporary grid to view.
Here are the fields that will appear in Junxure:
Accounts Screen:
Asset Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
Note: The import may take several minutes to process.
Albridge Solutions (CSV Import)
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Click OK. Otherwise, skip to step 5.
5. The Select Data File screen appears. Choose your import file from the list and click Next.
6. You will be prompted to begin processing the data. Click Yes.
Click Next once the import has been processed. Your assets and accounts will appear in a temporary grid to view.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
byallaccounts
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. In the fields provided, enter in a Batch Name and a Username of your preference. Click Apply then OK to save your settings.
Note: In future imports, the Import Settings screen will appear as Read Only. You may modify this information by clicking Edit.
5. You will be prompted to begin processing the data. Click Yes.
6. Enter in your Username and Password for byallaccounts web service authentication. Click OK.
Note: The import may take several minutes to process.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
The data is downloaded into temporary tables (the time to complete this step varies on the number of accounts). Click Next when the download is complete.
The temporary data is displayed on the next screen and allows you to select an account on the left and assets for selected accounts on the right. Click Next to continue.
On the Select Import Items screen, select any optional fields you would like to have updated. Fields such as NoUnits and MarketValue are always imported. (Many users set this screen once on the first import.) Click Next, and the data is then moved from temporary tables and committed to the Junxure database.
Click Yes to begin the import.
Click Next when the import is complete.
Once the import is complete, Junxure will check accounts against contacts and create a list of accounts that could not be matched to a contact in Junxure.
Double click on a row to launch the Add by Client screen. Here you can select a existing Junxure contact and then double click to match this account to that contact. This Missing Accounts List would only show new accounts on future runs of the import. (For more information, see: Optional Step: Adding Accounts. Please note that the Add by SSN functionality is not currently available for byallaccounts.)
Click Finish.
You have completed the import process.
Black Diamond
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Click OK. Otherwise, skip to step 5.
5. You will be prompted to begin processing the data. Click Yes.
6. Enter in your Username and Password for Black Diamond web service authentication. Click OK.
Note: The import may take several minutes to process.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
Buckingham Asset Management
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Click OK. Otherwise, skip to step 5.
5. The Select Data File screen appears. Choose your import file from the list and click Next.
6. You will be prompted to begin the data processing. Click Yes.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
Captools
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Click OK. Otherwise, skip to step 5.
5. The Select Data File screen appears. Choose your import file from the list and click Next.
6. You will be prompted to begin the data processing. Click Yes.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
Envestnet
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Click OK. Otherwise, skip to step 5.
5. On your first import from Envestnet, you will be prompted to enter your Opaque ID. Click Save. (If you do not have an Opaque ID, please contact Envestnet support.)
Note: The Opaque ID only needs to be saved once. Future imports will use the saved Opaque ID.
6. The Envestnet Website screen appears. On this screen you can:
- Edit your saved Opaque ID
- Open the Envestnet website to download the file you wish to import. When choosing this option, you will need to save and unzip the file in a temporary location. Click here for more information on using the Envestnet website.
7. Once you have saved and unzipped the data file in a temporary location, click Continue.
8. The Select Data File screen appears. Choose your import file from the list and click Next.
9. You will be prompted to begin processing the data. Click Yes.
Click Next once the import has been processed. Your assets and accounts will appear in a temporary grid to view.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
Fortigent
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Click OK.
5. You will be prompted to begin the data processing. Click Yes.
6. Enter in your Username and Password for Fortigent web service authentication. Click OK.
Note: The import may take several minutes to process.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
Investigo
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Click OK.
5. The Select Data File screen appears. Choose your import file from the list and click Next.
6. You will be prompted to begin the data processing. Click Yes.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
LPL Financial
Users of LPL BranchNet may have one of two versions of the interface - the Positions tab varies in format, however both versions are compatible with the Junxure Asset Import Wizard.
Create Import Files
Version 1.
Version 2.
Create the import files
- Log in to your LPL Financial web interface and select the clients menu item.
- Select Browse > Browse Clients and click the Positions tab
- Select All Reps from the first drop down menu
- Under the Search Positions in These Accounts section, select your necessary criteria.
- Under the Search Positions in Securities Matching One of These Criteria, select Security Descriptions and put "%" in the Value to Match field.
- Click Export. Export the results to an Microsoft® Excel spreadsheet, then select that spreadsheet from the import tool.
- Save the spreadsheet to a .CSV file in the C:\Junxure\ assetimports \LPL folder
- Arrange the columns in your .CSV files in the following order.
• Notif
• Loc
• LPLAccount
• AccountName
• SecurityID
• Description
• AssetClass
• Quantity
• Price
• MarketValue
• PurchaseCost
• GainLoss
• PCT
• ClientGrp
• HHGrp
• Memo
• SecurityType
• CUSIP
• AcctType
• AcctClass
• TradeDate
• PhoneNumber
• Rep
Note: If you have extra columns, open the .CSV file in Excel, delete the extra columns and then save it as a .CSV again.
Use the JAIW for LPL BranchNet
1. To begin, launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Click OK.
5. The Select Data File screen appears. Choose your import file from the list and click Next.
6. You will be prompted to begin the data processing. Click Yes.
You will be prompted to begin processing the data, and your assets and accounts will appear in a temporary grid to view.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
Morningstar Office
Note: The Morningstar interface allows an export of only 50 records at a time. To perform the import, you will need to create as many Import Configurations as necessary to import your entire dataset. (See Step 5 for more information.)
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
5. If this is your first import, the Import Settings screen will open. Otherwise, skip to step 6.
Note: The Morningstar interface allows an export of 50 records at a time. To perform the import of your entire dataset, you will need to create enough Import Configs as necessary to cover your database.
Tips:
- Create a different folder location for each config to eliminate confusion about which file to process.
- Each “set of 50” from Morningstar will need a unique batch name.
Once you have the initial configuration setup, click Apply. To add additional configurations, click Add New Config. For each new Config that you add, click Apply to apply the changes.
Click OK when complete.
6. You will return to the Select the Database Configuration to Use screen. Your configurations will appear on the left for you to select. Click Next. <![CDATA[ ]]>
7. Select the data file that you are importing for this batch and click Next.
8. You will be prompted to begin the data processing. Click Yes.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
PowerAdvisor
Note: Before you begin, you will need to create an Executive Summary report within PowerAdvisor Reports (see below) to obtain the As of Date.
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Click OK.
5. The Select Data File screen appears. Choose your import file from the list and click Next.
6. You will be prompted to begin the data processing. Click Yes.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
Principia CAMS (Formerly dbCAMS+)
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the file on the left that corresponds with the data that you’d like to import and click Next.
Note:If this is your first import, the Import Settings screen will open. Browse to your dvbdata folder under the Data File Location area then Click OK. Otherwise, skip to step 5.
5. You will be prompted to begin processing the data. Click Yes.
Here are the fields that will appear in Junxure:
Account Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
RBC Wealth Management
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Click OK. Otherwise, skip to step 5.
5. The Select Data File screen appears. Choose your import file from the list and click Next.
6. You will be prompted to begin the data processing. Click Yes.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
OmniPlanner
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Click OK. Otherwise, skip to step 5.
5. You will be prompted to begin the data processing. Click Yes.
6. Enter in your Username and Password for Omniplanner Web Services. (You must obtain this information from your Broker Dealer or from Omniplanner.) Click OK.
7. Once the import data has been processed, click Next.
Note: The import may take several minutes to process.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 8 from Using the Junxure Asset Import Wizard.
Orion AdvisorLynx
Before you can use the Orion AdvisorLynx interface, you must contact Orion and request to integrate with Junxure. Orion will then issue you two files, “C1.xml” and “C2.xml.” Junxure Version 7 and 8 users should store these files in C:\Junxure\CodeDN. <![CDATA[ ]]>
Version 9 users will store these files in C:\program files (x86) \ crm software\junxure\codedn (for 64bit machines) or C:\program files \ crm software \junxure\ codedn (for 32bit machines).
<![CDATA[ ]]>Note:The update to the Orion AdvisorLynx interface includes Account Notes. In addition to the JAIW update, Orion Advisorlynx users will also be prompted to update default and individual configurations upon login.
On the Updated FieldMap Available prompt, click Yes*.
*If you have a custom configuration for your Orion AdvisorLynx interface, contact Junxure Support at 1-866-586-9873, option 1 for more information.
A second screen may appear - click Yes to continue.
You may now continue using the Orion AdvisorLynx interface with the applied update.
Using the Orion AdvisorLynx Interface:
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Enter a batch name then click OK. Otherwise, skip to step 5.
5. You will be prompted to begin the data processing. Click Yes.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
SEI
Note: Prior to using the SEI interface, you will need the following files from SEI. (Contact SEI technical support for more information.)
- ADyymmdd.pos
- ADyymmdd.sec
- ADyymmdd.trd
The yy, mm and dd indicate year, month and date.
1. Launch the Junxure Asset Import Wizard from Junxure at Database Tools > Interfaces > Junxure Asset Import Wizard.
2. If you have more than one program, select an asset import from the list and click Run Selected Import. Otherwise, skip to step 3.
3. The Junxure Asset Import Wizard will open and a splash screen will be displayed. Click Next to continue with the import.
4. The Select the Database Configuration to Use screen opens. Select the configuration on the left that corresponds with the data that you’d like to import and click Next.
Note: If this is your first import, the Import Settings screen will open. Enter a batch name then click OK. Otherwise, skip to step 5.
5. You will be prompted to begin the data processing. Click Yes.
You will be prompted to begin processing the data, and your assets and accounts will appear in a temporary grid to view.
Here are the fields that will appear in Junxure:
Accounts Screen:
Assets Screen:
Continue with Step 7 from Using the Junxure Asset Import Wizard.
See Using the Junxure Asset Import Wizard for basic instructions on performing a daily import.
