PortfolioCenter - Junxure SQL Import
Requires MS Access 2000, XP, 2003, or 2007
This interface requires an ODBC connection
to the Junxure database.
Click the link below for step by step
instructions for creating this connection
This interface is “machine specific” and will need to be downloaded
and setup on any workstation that needs to run the import. Once the interface
is run, the updated assets and account values will be visible by all users on
all machines
Interface Setup
There are 2 methods to set this up.
Method 1
(Preferred Method)
Download
the following self extracting executable and save it to your desktop.
Self Extracting PC interface (contains both
files)
Once
you have the self extracting file on your PC, double click on the file to run
it.
You
will be prompted to click the install button. The file location does not need
to be modified.
If it asks you to “Confirm file replace”,
then click “Yes to All”
The
interface files will be copied to the directory. If the folders do not exist,
it will create them automatically.
The
Interface should be ready to use from within Junxure from Database Tools >
Interfaces > PortfolioCenter
Method 2
(use
this only if Method 1 does not work for you)
Download
the zip file below, save to your desktop, and then right click and
unzip/extract the zip file into the
c:\junxure\assetimports\portfoliocenter folder.
You may need to manually create the “AssetImports” and “PortfolioCenter” folders
Interface Use
You will access the interface in Junxure by going to Database Tools > Interfaces > PortfolioCenter
If the import does not open and you get a “compile error”
you may possibly need to install the following XML file from Microsoft.
Click the link to get the
XML file from Microsoft if you get the “Compile Error” MSXML
6
When you first open the import, you will need to fill out the PortfolioCenter Database name and the server name. Once entered, this information will be saved in the import for future use.
This info can be obtained in PortfolioCenter by clicking on
Help > About PortfolioCenter
For
Offices with Multiple Databases- you can run through all steps of the interface
as below for one PortfolioCenter Database and then you can run the interface
again after inputting the second PortfolioCenter Database Name.
The “As of date” will
always default to yesterdays date. However, on Mondays, or the day after Market
Holidays, you will need to set this date back to the last “Close of
Market”
The 
button is only to be used the first time
you ever download from
The opens a form that allows you to clear out old
assets you may have imported from another program with one of our other
interfaces. Failure to clear out old assets from another interface can result
in duplication of assets in Junxure.
Step 1-
To begin using the interface, once
you have entered the above information, click on the
“Import
From PortfolioCenter” button and the login screen will appear.
This password will be the “SA” (Security
Admin) password for PortfolioCenter NOT your normal PC login.
This is not the SA password for the SQL database.
The interface may take a few minutes
to communicate with the PC server and then will download the assets into a
temporary database. When it is complete, the login screen will disappear and
you will get a message box stating
“XML Import
Complete”
Step 2-
Once you have “XML Import
Complete” click on the “Check the Import
Results” button.
A second screen will open and you
will be able to highlight client names on the left and see the assets to be
imported on the right.
**If this screen is blank (as above), DO NOT move forward with the next step-
click the link below for more information**
Junxure
Knowledge Base- PortfolioCenter Import
Blank results
Step 3-
Provided that you do get results on
the “Check Import Results” screen, you may now click on the “Import to Junxure” button.
The process will run through and the
assets will be entered into Junxure and it will also delete any assets previously
imported from PortfolioCenter that are not in the current download from PC.
This
keeps you from having to do “double cleanup”. When you remove an
asset from PortfolioCenter, the next time you run the interface, the asset will
be deleted in Junxure as well. When the process completes, you will see
“Update Complete”
Step 4-
Click the “View Missing Account #s” or the “View Missing Acct#s Spreadsheet”
This will be a list of account
numbers downloaded from PortfolioCenter, that have not yet been entered into
Junxure.
This asset import works by matching account numbers.
Any account numbers on this report will need to be entered into Junxure
manually. To do this, open the appropriate contact, click on the
“Accounts/Assets” tab, the “Accounts” sub-tab, and then
click “Add”
On the first use the list may be large, however, as
you move forward and get all the numbers on the list entered onto the contacts,
this list should only show newly entered accounts in PortfolioCenter that are
not yet in Junxure.
This Import can be run as
often as you would like to update the accounts and assets in Junxure. Many
offices do this on a daily basis to keep the information as up to date as
possible.
If you need assistance with the
setup of this interface on your workstation, feel free to call Junxure
Technical Support between 9am and 6pm ET at
866-586-9873 option 1
Important Note to Junxure
Users of 3rd-Party Software
Junxure only provides an interface to this 3rd-party software
application, and for that reason, can’t provide any technical support
regarding any issues with the 3rd-party data,
application configuration, or necessary set-up. If assistance is
needed, please contact the application software provider directly.