Importing Address
The Multiple Address feature allows for bulk importing of data into address fields if the address type is already associated with the user or the organization.
There are two approaches for importing data into the Address Type fields:
- Import From Profile
- Import From Text
Import From Profile
The Import From Profile feature allows an Address Type to be populated from existing standard address fields that exist against the user or organization profile.
It can be used to update all users or organizations with that Address Type.
- Access the Address Type by clicking on the hyperlink in the Name column.
- Click on the Import From Profile tab long the top of the screen.
- Check the box for the entity type that you wish to import the address against, whether this is a User or a Company.
- In the resulting screen you can map custom fields from the overall entity, whether User or Company, to the custom fields on the Address Type.
- You can also select the User roles or Company categories to which this automated import will apply against, depending on the entity type that you wish to import the address against, or you can leave all options blank if you wish to apply to all roles or all categories.
- Once you click Import then you will be presented with confirmation message. Simply click OK to proceed.
- You will be presented with message indicating the number of entities that have been successfully updated.
Import From Text
The Import From Text feature allows an Address Type to be populated from text values.
It can be used to update addresses associated with individual users or organizations. As such you must provide a unique identifier for the individual company or organization.
- Access the Address Type by clicking on the hyperlink in the Name column.
- Click on the Import From Text tab long the top of the screen.
- Check the box for the entity type that you wish to import the address against, whether this is a User or a Company.
- In the resulting screen you have the following options available:
- Column Delimiter - drop-down list showing the delimiter options used to separate different values in the text field into different address fields on the system
- Values enclosed by double quote - checked when you wish to indicate that individual values will be enclosed in double quotes.
- First row contains field names - checked when you wish to indicate that the first row in the Text field will actually be column headers rather than address values
- Text field - enter in the address values, separated by the column delimiter
NOTE: You will have to provide an identifier in the text field for the for the individual company or organization that you wish to update. You can also enter multiple rows if you wish to update against multiple users/companies.
- Click the Analyze button when you have added the address data.
- In the resulting screen you can define the mappings from the data previously entered in the text field to the Address fields, including the individual User ID or Company ID that the update is applied against.
- Click the Parse button when you have defined the mappings.
- In the resulting screen you can review the mappings ensuring that the data entered in the text field is mapping to the correct Address fields, including the individual User ID or Company ID that the update is applied against.
- If issues emerge then click on the Back button to make changes to the mappings. If no issues emerge then click the Upload button.
- If you have clicked on the Upload button then you will be presented with a confirmation screen, indicating those company or user profiles that have been updated successfully.
