HomeGuides :: AssemblageFAQsWorldox Autofiler and Naming Conventions

9.6. Worldox Autofiler and Naming Conventions

This page is designed to discuss known file naming conventions for Worldox Autofiler purposes:

 Portfolio Center Reports

Source Filename Convention Mapping Other Information
Portfolio Center Reports AccountNumber_Date.pdf   Account number to the corresponding account number in Worldox

 Often times, the account number as it appears in the reports contains a dash, however, the account number in Worldox does not.  Therefore, the Worldox Autofiler will be responsible for removing the dash.

 

Black Diamond Reports

Source Filename Convention Mapping Other Information
Zip file from BlackDiamond PortfolioDescription_YYYYMMDD_Rep#_AccountID.pdf AccountID to corresponding values N/A

 

Schwab 1099s

Source Filename Convention Mapping Other Information
Zip file from Schwab AccountNumber_Date.pdf   Account number to the corresponding account number in Worldox

 Often times, the account number as it appears in the reports contains a dash, however, the account number in Worldox does not.  Therefore, the Worldox Autofiler will be responsible for removing the dash.

 

Fidelity Statements

Source Filename Convention Mapping Other Information
Zip file containing multiple PDFs stmt#######.pdf The zip file from Fidelity will contain an index.csv file which contains the filename and the corresponding account number.  Assemblage will use this .csv file to map from the filename to the appropriate account number.

 Often times, the account number as it appears in the reports contains a dash, however, the account number in Worldox does not.  Therefore, the Worldox Autofiler will be responsible for removing the dash.

 Morningstar Office Reports

Source Filename Convention Mapping Other Information
Directory of PDF files Report for Client Name.pdf The mapping for these reports must be done via an external data source (e.g. CRM or Excel Spreadsheet)

We will map from the information that appears after the "For" in the filename to a client code in Worldox

Tamarac (AdvisorVault) Reports

Source Filename Convention Mapping Other Information
Zip of PDF Files
AccountNumber_Date.pdf
(This can be adjusted by changing the template to this convention)
The mapping for these reports must be done via an external data source (e.g. CRM or Excel Spreadsheet)

We will map from the information that appears after the "For" in the filename to a client code in Worldox

If the item you wish to auto-file is not listed, please contact a Trumpet Support representative to request further information.

This page was: Helpful | Not Helpful

© 2012 Trumpet, Inc., All Rights Reserved