Using the Record Data Import Tool

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

  1. Launch the Junxure Cloud Record Data Import from the desktop shortcut or the CRM Software folder in your start menu.
  2. Click Start at the bottom of the window.
  3. Use the file browser window to find and select your prepared CSV file to import.

The RDI Tool will scan your CSV file and present you with the data it finds for review.

Step 2: Preview Raw Data

You are given a preview of the data you have selected to ensure that you have selected the correct file. If everything looks good, click Next. Otherwise, close the program and start over.

Step 3: Map Your Data

After you have verified the raw data, you will be presented with seven pages of empty fields that you can map from data in your spreadsheet.

Each box represents a field on a CRM Record. The screens presented may not match the current AE CRM interface. To “map” a field in AE CRM to a column of your imported spreadsheet:

  1. Double-click on the field you want to map. The matching window opens.
  2. In the column on the left, locate the header from your spreadsheet that corresponds to the field you selected.
    • Single-click a header name to preview the data in that column.
    • If the data in the column does not match the data-type requirements of the CRM field, you will be given a warning.
  3. Double-click the header name to map it to the field. It will be removed from the list for further mappings.
  4. Repeat the process across the pages until you have mapped all the data from your imported spreadsheet. You do not need to fill in every field, only the ones for which you want data imported.

Optional: Global Fields

On the second page of the field mapping section there is a blue box with ten fields. As it states on the page, data entered into any of these boxes will be applied to ALL Records you import and will override any data for those fields in your spreadsheet. If you filled in this data on your spreadsheet you do not need to use this section.

Optional: Saving Mapping Template

If you intend to perform more than one import with the same spreadsheet layout, you can save the mappings you have defined to easily load those matches on future imports.

See Saving and Using RDI Tool Mapping Templates for further information.

Step 4: Matching Results and Saving

After the final page of AE CRM fields you will be presented with the mapping data you’ve completed. You may use the Previous button to return and make any adjustments to the data you like. If all the data is good, click Finish to receive your completed CSV output file. Save this file somewhere safe. You are now ready to import into AdvisorEngine CRM itself.

    • Related Articles

    • Record Data Import (RDI) Overview

      The Record Data Import (RDI) process provides a way to add Records to AdvisorEngine CRM in bulk and pre-fill many of the critical fields for those Records using data contained in a spreadsheet or other CSV (Comma separated value) file type. The RDI ...

    • 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 ...

    • Installing the Record Data Import Tool

      The Record Data Import Tool is a locally-installed software program that processes your spreadsheet of data into a format that AdvisorEngine CRM is able to import. The following documentation will walk you through downloading and installing the ...

    • 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, ...

    • 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 ...