Home → Guides :: Assemblage → FAQs → Worldox 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.