Importing is the most efficient way to add master data when you set up a new account or have a large batch of records to upload. Each master data element has its own Excel template, which you can find in the Help Center. Euna Grants uses each completed template to create or update master data records. Preparing your data first helps you avoid unintended changes.
This article includes the following sections:
- Planning Your Imports
- Finding the Import Templates
- Completing a Template
- Importing a Completed Template
Planning Your Imports
Plan your imports before you complete a template:
- Apply your naming conventions. Enter names according to your organization's naming conventions to avoid duplicates or inaccurate reporting.
- Import in stages. You do not have to wait until all of your data is ready to begin importing. You can import as many times as you need, so start with the records that are prepared and add the rest later.
Finding the Import Templates
Euna Grants provides a separate import template for each master data element:
Each template includes a column for every available field on that record type.
You can find and complete the templates in the Import Templates section in the Help Center. Download the template for each element you want to import.
Completing a Template
Complete each template before you import it. Follow these guidelines:
- Fields marked with an asterisk are required.
- Cells with a red triangle in the upper right corner include an attached note. Hover over these cells before you enter data.
- Apply your naming conventions and other data standards.
The following image shows a required field and a cell with an attached note.
Important: Do not change a template's column names or dropdown options as it can break or corrupt the import.
Importing a Completed Template
Only Account Admins can import master data.
Warning: An import updates existing records that match your data instead of creating duplicates. Use caution when you enter records that already exist in Euna Grants.
Each master data element imports from its own list. The following table describes where to find each list.
| Master Data Element | Navigation Path |
|---|---|
| Organizations | Contacts > Organizations |
| Individuals | Contacts > Individuals |
| Staff | Contacts > Staff |
| Users | Administration > System Security > Users |
| Departments | Administration > System Security > Departments |
| Subjects | Administration > Lists > Subjects |
| Benefit Types | Administration > Lists > Benefit Types |
| Budget Categories | Administration > Lists > Budget Categories |
To import a completed template, complete the following steps:
- Open the list for the element you want to import. For the navigation path, refer to the previous table.
The master data list displays. - Click the Import (document with an inward-facing arrow) button in the icon toolbar.
The import popup displays. - (Staff Import Only) Select Staff Import from the Choose Import dropdown.
- Click the Choose a file button, and then select your completed template.
The mapping fields display. - For each Source column, select the Destination field. If you use the import template, the source and destination fields match.
- Click the Import button.
Euna Grants imports the records and adds them to the list.
Comments
0 comments
Article is closed for comments.