How to Save an Import Mapping

When you import files with the same format, you may want to save the mapping to avoid mapping each field manually each time. Using saved mappings expedites importing future .csv files set up in the same field format as the saved mapping.

 

Save an Import Mapping

  1. Log in to VanillaSoft as an Admin.
    Log_In_to_VanillaSoft.jpg
  2. Select the desired Project.
    Select_Project.jpg
  3. Open the Contacts & Reports menu and select the Import Contacts section.
    mceclip0.png
  4. Select Choose File and browse to your .csv spreadsheet.
    mceclip1.png
  5. Once found, select the file and click Open.
    mceclip10.png
  6. Leave the Import Mapping drop-down selected on No Mapping.
    mceclip2.png
  7. Open the Import Method drop-down and select the desired method.
    mceclip3.png
    • Add Contacts - This option will add all contacts from your spreadsheet into VanillaSoft regardless if there are any duplicates or not.
    • Add Contacts / Skip Duplicates - This option will add any new contacts but will skip duplicates based on the desired field.
    • Add / Update Contacts - This option will add any new contacts and update any duplicates based on the desired field.
  8. Once you make your selections, click Next.
    mceclip4.png
  9. Map all desired fields from your spreadsheet to the corresponding VanillaSoft field.
    mceclip5.png
    • VanillaSoft will attempt to map the fields, but it is recommended to verify that all mapping is correct before proceeding.
  10. Once your mapping is complete, select Save Mappings.
    mceclip6.png
  11. Enter the desired name in the New Mapping Name field.
    mceclip7.png
  12. Click OK to save. 
    mceclip8.png
  13. You should now see the mapping name in the Import Mapping drop-down.
    mceclip9.png
    • This confirms your mapping has been saved and you may continue with your Contact import.

 

Note: You can only use a saved mapping on future files that are identical in structure, meaning the same number of columns in the same order. The column headers in future .csv files must be identical to the file used in the original mapping.  If you attempt to use a saved mapping on a different file structure, the system may return an error. In this case, you will need to map the fields manually.

Was this article helpful?

Related articles