The Portfolio Report Wizard enables PortfolioCenter© and dbCAMS users to upload batch reports to clients' ClientView Live websites. Use the instructions below to:

• Set Up Your Portfolio Management Software
  
• Use the Portfolio Report Wizard to Upload Client Reports
  
• Portfolio Report Redo Wizard
  
• Supported Batch Files
  

Set Up Your Portfolio Management Software

Note: The Portfolio Report Wizard can be used only with PortfolioCenter® or dbCAMS.

From the ClientView Live desktop, go to System Setup > ClientView Setup.

On the General tab, select either PortfolioCenter or dbCAMS from the drop-down list. (For more information on supported batch files, see Supported Batch Files section in this topic.)

Click the Report Folder icon and choose the destination for your batch files. Your changes are automatically saved.

Now move the .zip file of the portfolio reports to the destination folder and unzip the file. Any previous batch files in this folder must be deleted.

Note: ClientView Live will not reprocess the previously run batch files. To delete outdated reports, go to Portfolio Reports > Portfolio Report Tasks.

Upload Client Portfolio Reports

Go to Portfolio Reports > Portfolio Report Wizard.

Click Next under Upload my clients' portfolio reports?.

The Select Portfolio batches to process screen appears. A batch is a folder that contains portfolio reports generated from your portfolio management software.

To add a new batch:

• In the Batch Name field, type in a name to identify a particular batch.
  
• Click the file folder icon under the Batch Path column to locate your folder. Select your file folder, which may be located on your local drive or your server. Click OK.
  
• Under the View Files column, click the folder icon to confirm that you wish to process the files in your selected folder.
  

To process an existing batch, or to continue processing a new batch, click the checkbox under the Process This Batch? column. Note: you may receive a pop-up message if the Portfolio Report Wizard is unable to process your batch. This may be due to inappropriate file types in your selected folder or incorrect paths.

Once your batch is ready to process, click Next to continue.

The Ready to process batches screen appears. This step will parse files from your selected ClientView Live batch into the database and auto-assign portfolios by account. Click Process batches to continue.

Note: To stop your batch from processing, click Abort. You can restart your batch by returning to this step in the Portfolio Report Wizard.

Once your batch is complete, click Next.

Next you will Assign Portfolios by Account that could not be automatically assigned to the client. Unassigned portfolios appear in left screen.

To manually assign these accounts to a client, choose a client from the right side of the screen. The Assigned Portfolio tab appears as the default in the bottom of the screen.

Go to the first blank line in the grid and type in Unassigned PortfolioID number in the grid (you may also use the drop down to locate the Unassigned PortfolioID). Once you assign it to this client, the PortfolioID disappears from unassigned grid.

Note: Once you have assigned your portfolio accounts, you will not need to assign them again.

dbCAMS users: the PortfolioID field is called DBCamID. You can manually assign by clicking portfolios the same way as described above.

If you have decided to use web groups and web accounts as part of your setup, this is where you will assign your web groups and web accounts. See educational video, Web Groups and Web Accounts or System Setup: Web Groups for more information.

Click Next to continue.

If you have any unassigned portfolios, you will receive a pop-up notification. Click OK to continue.

On the Define Report Categories and Merge Order screen, you will be able to select your report categories and set the order that you would like your reports to appear to your clients.

• Click in the Report Category field for each row and use the drop-down menu to select a category. Reports with the same category will be merged into a single PDF file.
  
• Click in the Merge Order field for each row to change the order of your reports.
  
• The Reports to Process field displays how many reports in that category will be included in your batch.
  

Click Next to continue.

On the Define Report Categories screen, you can choose a cover page for each report category, if desired, and you can select the post date for your report, which will appear on the website to your clients.

• To the left of your Report, click the + sign icon to expand the details of your report. Here you will see your report names, categories, and merge order.
  




• To add a cover letter, click the drop-down in the Cover Letter field and select a cover letter. Select None if you do not wish to add a cover letter.
  




• To edit the post date, use the Post Date field to enter in a new date.
  

Click Next to continue.

In the Merge reports and move to Junxure Client Folder screen, click Begin Merge. Note: Once you begin the merge, you will not be able to go back into the Portfolio Report Wizard.

Once the merge is complete, click Next.

On the Manage Portfolio Reports screen, you can view the merged reports that now appear on the website. This is also where you can remove old reports from the ClientView Live website. Click Next.

Click Finish. You have completed the Portfolio Report Wizard.

Supported Batch Files

ClientView Live allows you to process and post portfolio reports from multiple vendors including PortfolioCenter® and Principia CAMS (dbCAMS+).

To access this feature, from Junxure (or the ClientView Live desktop tool) go to System Setup > ClientView Setup. Click on the General Tab. See ClientView Setup for more information.

PortfolioCenter Users: Under the ClientView Setup section, use the drop-down menu next to the Interface field to select PortfolioCenter.

You must create reports from either eReports or Presentation Reports – see instructions below. Contact PortfolioCenter for support.

Other Programs: If you are creating reports from any other system (dbCAMS, Advent Axys, Morningstar, Packman, etc.), use the drop down menu next to the Interface field on the General Tab to dbCAMS. Reports that correspond to this selection must meet one of the file-naming conventions listed in the article below.

dbCAMS

ClientView supports the following file naming convention in order to use the dbCAMS (Principa CAMS) Interface:

xxx~yyyyyyyyyzzzzzz.PDF

xxx_yyyyyyyyy.PDF

xxx_yyyyyyyyy_ALL.PDF

xxx~ yyyyyyyyy_ALLzzzzzz.PDF

xxx~yyyyyyyyy_wwwzzzzzz.PDF

xxx_yyyyyyyyy_zzz.PDF

yyyyyyyyy_qtly.pdf

Where:

yyyyyyyyy = Account# - If this Account# is listed on the accounts tab in Junxure, then the reports will assign to appropriate client automatically. It's very important that the file names be the correct length e.g. the account number must be 9 characters so if the account number was 909 you would pad it with 0's e.g. 000000909

xxx = UserID - not used

zzz = OwnCode - not used

zzzzzz = Report Code - not used

In order to process these reports, make sure you have the dbCAMS interface selected in the ClientView Live Set-up “General Tab”*

You may use the alternative naming convention of Client Name-ClientID-Account#-YYYYMMDD (include dashes and be sure to set the Interface field on the General tab to dbCAMS).

To change file-name formats, you may manually change the names (locate the file, right click on the mouse and choose Rename), or you work with your IT specialist to create a batch file to change the file names.

As an alternative you may use the drop down menu next to the Interface field on the General tab to select PortfolioCenter, and then follow the Presentation Report naming convention. This cannot be done with eReports as the additional text files are needed. The Presentation Report naming convention is as follows:

• Account Number_YYYYMMDD
  
• Client Name_Client ID_Account#_YYYYMMDD (The Interface field on the General tab must be set to PortfolioCenter.)
  

Note: If the reports do not meet the proper naming conventions for the selected Interface setup then they will not be processed through the Portfolio Report Wizard or Document Assembly Wizard. You may still attach the individual reports to the Document Vault if you choose.