Overview
Import Groups
File Specifications
Related Topics

---

Overview

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

You can import account-based groups that you created in another portfolio management system. Once imported, each group name displays in the All Groups List.

Groups 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 text file must comply with the platform group import specifications.

---

Import Groups

Note

• The imports are text files created previously using Notepad or Microsoft Excel. If you use Excel to create the file, select Save As and save the file as a .csv file. When Excel prompts you to save again, reply No. Then, change the saved file's file type to .txt.

  Remember
  The text file must comply with the platform group import specifications

  .
• There are two distinct record formats for groups.
• The allowable file types when importing groups are Comma Separated Value (CSV), which is the default, Fixed Length Values, and Tab-Delimited.
• Import file formats for Comma Separated and Tab-Delimited have quotes around the data; quotes are not required for Fixed Length Values.
• Select the Cancel link at any time while you are on the Import screen to close the screen and ignore any selections/settings you made.

---

1. Select Tools > Imports > Groups. The Import screen displays with the Import Type indicating Groups.

   Note
   You cannot edit this information.

2. Optionally enter the Import Name in the associated field.

   Note
   It is recommended that you enter a name since it will help to locate and identify the import on the Import Status Tab.

3. Make your File Type selection using the associated drop-down list; options are:

   • Comma Separated Value (the default): Values are separated by commas.
   • Fixed Length Values: Values have a fixed length.
   • Tab-Delimited: Values are separated by tab characters.

4. Select the Browse button to complete the File Path field, which represents the location of the import file.

   Note
   You must use the Browse button and cannot enter the path manually.

5. Optionally complete the On Behalf Of field by entering the User ID of individual for whom you are importing the groups.

   Note
   This feature enables you to import groups on behalf of another user as long as you are both members of the same firm. These imported groups display in that user's My Groups list on the Group Access Layer. When the import completes, you do not have access to these groups since they are assigned to the User ID of the individual for whom you imported them. That person can edit, delete, or copy these groups.

6. Specify the Access Type for the groups by selecting the Public (the default) or Private radio buttons.

   Note
   This selection is entitled and may not display in your view. Public access indicates the groups are accessible to any user in your firm authorized to access at least one of the accounts contained in the groups. Private access indicates the groups are only accessible by the user who created the groups and users within the firm who have system administration-level privileges.

7. To overwrite any existing imported group information in the platform, select the checkbox associated with Overwrite if data already exists.
8. When all selections are complete, select the Run Import button to execute the import.

9. A confirmation message displays on the screen informing you that the import request was received and is being processed. Confirmation: We are processing your import. Details can be found on the Import/Export Status page. Select the Import/Export Status link to proceed to the page where you can view the import's progress and status.

   Note
   Use the Import Name you specified to locate and identify the desired import.

10. If you wish to import additional groups, select the Run Another Import button that displays and repeat Steps #2-#8.

11. The import's Status is listed as In Process in the Import Status Tab and the system performs a validity check on the import file. If there are no errors, an acceptance message displays indicating the import is being processed. An error message displays if the system cannot read the import file due to a general issue:

    • File path does not exist.
    • File name does not exist.
    • File size is too large.
    • File fails virus scan.
    • File format can not be read (extra columns included or file type does not match user input).

12. Whenever you choose to run the import, it is a best practice to view the Import Status (Tools > Imports & Exports > Import/Export Status > Import Status Tab) to verify there were no errors or to correct any errors that occurred.

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

---

File Specifications

• Fixed Length Values
• Comma Separated Value
• Tab-Delimited
• Tab-Delimited Example

Account Group information imported in text file format must meet the platform specifications. The following tables show the fields that are imported and the lengths (applicable to Fixed Length Values imports only).

Note
A group can contain any number of accounts. Each individual account is identified by a A (Group Record Type), an Account Number, and an Account Source Indicator.

Fixed Length Values

Group Information

Field	# of Characters	Definition
Group Record Type	1	Note This is a required field. A one character (G) Group Header Format Indicator.
Group Name	60	Note This is a required, key field. The group's name.
Group Description	150	The description of the group.
Group Content Type Code	1	A character indicating the type of group - either account-based (A) or criteria-based (C). Note This field always defaults to A since you cannot import criteria-based groups.

---

Account Information

Field	# of Characters	Definition
Group Record Type	1	Note This is a required field. A one character (A) Group Account List Format Indicator.
Account Number	32	Note This is a conditionally-required, key field. The account number.
Account Source Indicator	1	Note This is a conditionally-required, key field. A one character code that identifies the type of account: B: Fidelity Brokerage/Trust or NFS Brokerage F: Fidelity Retirement (403(b)/401(k)) I: Fidelity Annuity / Life Insurance P: Fidelity Donor Advised Fund A: Advent

---

Comma Separated Value

Note
Although it cannot be illustrated in the space constraints of the help screen, 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>

---

Tab-Delimited

Note
Although it cannot be illustrated in the space constraints of the help screen, 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>

---

Tab-Delimited Example

G<tab>"FloridaAccounts"<tab>"Accounts held in Florida"<tab>"A"<Line Feed>
A<tab>"179222222"<tab>"B"<Line Feed>
A<tab>"179555555"<tab>"B"<Line Feed>
G<tab>"ArizonaAccounts"<tab>"Accounts held in Arizona"<tab>"A"<Line Feed>
A<tab>"179333333"<tab>"B"<Line Feed>
A<tab>"179444444"<tab>"B"<Line Feed>

---

Related Topics

Note
See the following related topics for additional information on importing:

• Import Status
• Message Center

880918.1.0

---