Documentation
Learn more about ByAllAccounts

Migration Steps and Best Practices

Suggest Edits

These instructions provide current Custodial Integrator for Universal desktop (CI Desktop) data administrators with the information required to migrate their data delivery operations from CI Desktop to Custodial Integrator SaaS (CI SaaS) Universal.

The following instructions will help guide you through the process of migrating your account and security translations, and global and column configurations from CI Desktop into AccountView CI SaaS. This method is a one-time process to be performed over the course of two days.

Video overview of migration

Demonstration of the migration process: [Coming soon]

Best Practices

🥾

Migration Best Practices

  • Review the Migration Requirements before you begin the migration process from CI Desktop to CI SaaS in AccountView.
  • Review all of the instructions included below.
  • Follow these steps carefully to minimize the risk of disrupting daily reconciliation.
  • Watch the video for a demonstration of the process.
  • Refer to Resources for Migration and CI SaaS for additional documentation.

📘

Running against multiple databases

The export utility can be configured to run against any Custodial Integrator database as described here. If you intend to run it against multiple databases, edit the command line to show the name of the customized .bat file for each instance as needed. Refer to the CI SaaS Universal Migration Utility Guide for details.

Note: instruction only applies to customers running multiple instances of CI Desktop.

Two Day Process to Migrate

These instructions provide current Custodial Integrator for Universal desktop (CI Desktop) data administrators with the information required to migrate their data delivery operations from CI Desktop to Custodial Integrator SaaS (CI SaaS) Universal.

The following instructions will help guide you through the process of migrating your account and security translations, and global and column configurations from CI Desktop into AccountView CI SaaS. This method is to be performed over the course of two days.

Day One

Step 1: Run CI Desktop as you normally would, and import the data into your portfolio management system. This is the last time you will use CI Desktop to deliver data to your portfolio management system.

Step 2: Download the Export Utility.

Instructions to download the utility
  1. Download the Export Utility from this location: http://www.byallaccounts.net/CI/CISaasMigrationUtility.zip
    The username and password needed to access the download should have been provided to you in an email message from us.
  2. Extract the contents of the file to C:\\Program Files (x86)\\Custodial Integrator\\

Step 3: Determine where your “CI Working Folder” is located.

Instructions to find the folder
  1. In the Custodial Integrator desktop application, click the Setup button.
  2. Take note of the folder location specified within the CI Working Folder field. This is the location to which the translation and configuration files will be exported.
  3. Take note of the location of the Universal Output Folder as well. You will need the location later when importing the files to AccountView CI SaaS.
  4. Close Custodial Integrator.

Step 4: Run the Export Utility to extract your CI Desktop configurations and translations.

Instructions to run the utility
  1. Navigate to the ‘C:\\Program Files (x86)\\Custodial Integrator\\’ directory.
  2. Double click on the runExportUtility.bat file that you extracted in Step 1.
    A small DOS window may appear briefly and then disappear; that is normal.

Step 5: Confirm the files were exported successfully.

Instructions to locate the files
  1. Navigate to your CI Working Folder (that was found in Step 3.
  2. If you see the following four files, then the process was successful.
    • GLOBALCONFIGURATION__.csv (the global translations file)
    • COLUMNCONFIGURATION__.csv (the column translations file)
    • ACCTTRANSLATIONS__.csv (the account translations file)
    • SECTRANSLATIONS__.csv (the security translations file)

Step 6: Upload the Global and Column Configuration files to AccountView CI SaaS.
It may take a few seconds for each upload to finish.

Instructions to upload the files
  1. Open your web browser and log into AccountView.
  2. Click Downloads to navigate to the Downloads Dashboard.
  3. Click Import and choose Import Global Configuration.
  4. Click Choose File and navigate to the GLOBALCONFIGURATION__.csv located in your CI Working Folder, and then Upload the file.
  5. Click Import and choose Import Column Configuration.
  6. Click Chose File and navigate to the COLUMNCONFIGURATION__.csv located in your CI Working Folder, and then Upload the file.

Step 7: Upload the Account Translations and Security Translations files to AccountView CI SaaS. It may take a few minutes for each upload to finish depending on how many translations there are.

Instructions to upload the files
  1. From the Downloads tab, click the Account Translations tab then click Import.
  2. Click Chose File and navigate to the ACCTTRANSLATIONS__.csv file located in your CI Working Folder, then Upload the file.
  3. Next, navigate to the Security Translations tab and click Import.
  4. Click Chose File and navigate to the SECTRANSLATIONS__.csv file located in your working folder and then then Upload the file.

Step 8: Run CI SaaS for the first time on the same day you have completed steps the steps above.

Instructions to run CI SaaS
  1. To run CI SaaS, in AccountView click Downloads to access the Downloads Dashboard, then click Export Universal Files.
  2. The files you have just created in AccountView CI SaaS should be ignored. The sole purpose of completing Step 8 is to “synch” the CI tracked transaction dates so that tomorrow, when you complete Step 9, the CI SaaS output will contain the new transactions that occurred since you last imported the CI Desktop data into your portfolio management system (Step 1).

Day Two

Step 9: On the following business day, repeat the CI SaaS file creation, and import the files into your portfolio management system.

Instructions to produce CI SaaS files
  1. Refer to the videos at ByAllAccounts Training Resources, specifically the “Overview of Daily File Creation” for step-by-step instructions on the process of file creation.

👍

Upon successful migration, CI SaaS is now the source of your ByAllAccounts data files

Updated about 16 hours ago