Saving and Using RDI Tool Mapping Templates
Using the Record Data Import Tool the first time requires you to manually match each column of your spreadsheet to AdvisorEngine CRM Fields.
However, if you plan on importing data from the same spreadsheet layout multiple times with different data, you can save all the matches and use those same mappings again next time, rather than re-mapping the entire sheet field by field.
- Use the RDI Tool as normal until you have matched all the fields from your spreadsheet.
- In the upper left, click Templates > Save Template.
- Select a save location, specify a filename and click Save.
The next time you prepare a spreadsheet import, use the same column headers and layout as before with new rows of data.
- Run the RDI Tool and load your next spreadsheet into the tool.
- When you reach Step 3, click Templates > Load Template in the upper left.
- Locate and select the template file you saved previously. All the mappings you saved load automatically.
Warning!
When you first create your mappings, the RDI Tool verifies that the data in the column matches the data type that the field is expecting. Loading mappings from a template skips this verification. If you are loading mappings from a template, be doubly sure that the data you are importing is the correct data type or you may have errors after importing into AE CRM.
Related Articles
Using the Record Data Import Tool
After you have installed the Record Data Import Tool and prepared your data, you are ready to use the RDI Tool. Step 1: Select Your Data Launch the Junxure Cloud Record Data Import from the desktop shortcut or the CRM Software folder in your start ...
Creating and Using Grid Templates
If you have used the Grid tools to arrange a custom Grid view that suits your needs, you can save that particular arrangement of filters, groups, sorts, columns, display items, and even searches as a Grid Template which may be quickly recalled later. ...
Preparing Your Data for the Record Data Import Tool
The Record Data Import Tool takes a Comma Separated Value (CSV) spreadsheet and maps the columns of data to fields in AdvisorEngine CRM. You may use your own spreadsheet, or you may use an AE provided sample sheet that you then populate with your own ...
Using the Document Template Kit
This article covers creating a Document Template for AdvisorEngine CRM offline through Microsoft Word. Though this provides access to all the features and familiarity of Microsoft Word, it is a more complicated process than creating a Template online ...
Importing Data from the RDI Tool into AdvisorEngine CRM
After you’ve run your data through the Record Data Import Tool and received your output, you’re ready to upload the finished CSV file to AdvisorEngine CRM. Importing Your Data Within AE CRM, navigate to Import > Record Data Import from the site ...