Import Groups

Top

Overview

You can import account-based groups that you created in another portfolio management system. After the import, each imported group displays in the My Groups list for the user on whose behalf the group was imported. Imported groups also display in the All Groups list.

Group information is imported using text files. The data contained in a text file must have a fixed length, or be separated by commas or tab characters. The imported information must meet the file specifications.

Top

Importing Groups

After you run an import, a notification is posted to the Message Center when the import is complete.

  1. Select Tools > Import > Groups. The Import window opens with the Import Type field indicating Groups. You cannot edit this field.
  2. In the Import Name box, enter the name for the import.

  3. From the File Type drop-down list, select the file format you are importing:

    • Comma Separated Value: (Default) Values are separated by commas.
    • Fixed Length Values: Values have a fixed length.
    • Tab-Delimited: Values are separated by tab characters.
  4. In the File Path field, enter the path and name of the import file, or select the Browse button to locate the file.

  5. In the On Behalf Of field, enter the ID of the user to assign to the group. The selected user will be able to access the group from the Groups window (the My Groups or All Groups list), edit the group, or delete the group.

    NOTE: The user ID requesting the import and the user ID that is named as On Behalf Of must be in the same firm. After the group is imported, the user ID requesting the import displays as the Created By user ID for the group.

  6. If entitled, designate the group Access Type as Public or Private.
  7. To overwrite any existing imported group information, select the Overwrite if data already exists check box.
  8. Select the Run Import button.

Top

File Specifications

The following tables show the fields that are imported and the lengths (applicable to Fixed Length Values imports only).

A group contains accounts. Each individual account is identified by an A (Group Record Type), an Account Number, and an Account Source Indicator.

Top

Fixed Length Values: Group Information

Field Size Description
Group Record Type 1

(Required) The Group Header Format Indicator:

  • G: Group
Group Name 60 (Required) The group name.
Group Description 150 The description of the group.
Group Content Type Code 1

The type of group:

  • A: Account-based
  • C: Criteria-based

NOTE: This value in this field is always A because you cannot import criteria-based groups.

Fixed Length Values: Group Account Information

Field Size Description
Group Record Type 1

The one-character Group Account List Format Indicator:

  • A: Account
Account Number 32 The account number.
Account Source Indicator 1

The one-character code that identifies the type of account:

  • B: Brokerage

Top

Comma-Separated Values

Information for the group and for each account must be contained on single lines. <Line Feed> indicates where each line ends.

File Format Allowable Fields
Comma Separated Value G,"Group Name","Group Description","A"<Line Feed>
A,"Account Number","Account Source Indicator"<Line Feed>
A,"Account Number","Account Source Indicator"<Line Feed>
A,"Account Number","Account Source Indicator"<Line Feed>

Top

Tab-Delimited Values

Information for the group and for each account must be contained on single lines. <Line Feed> indicates where each line ends.

File Format Allowable Fields
Tab-Delimited G<tab>"Group Name"<tab>"Group Description"<tab>"A"<Line Feed>
A<tab>"Account Number"<tab>"Account Source Indicator"<Line Feed>
A<tab>"Account Number"<tab>"Account Source Indicator"<Line Feed>
A<tab>"Account Number"<tab>"Account Source Indicator"<Line Feed>

Example

G<tab>"FloridaAccounts"<tab>"Accounts held in Florida"<tab>"A"<Line Feed>
A<tab>"033222222"<tab>"B"<Line Feed>
A<tab>"033555555"<tab>"B"<Line Feed>
G<tab>"ArizonaAccounts"<tab>"Accounts held in Arizona"<tab>"A"<Line Feed>
A<tab>"033333333"<tab>"B"<Line Feed>
A<tab>"033444444"<tab>"B"<Line Feed>

Top

651473.3.0