How to configure the 'Companies' template for Mass Import

You should have already downloaded the template to mass import Companies. If you

haven’t done so, click on the ‘Step 1. Download Template’ Button as shown below.

Screen%20Shot%202019-02-05%20at%203.18.34%20pm.png


You might be asked where to save the file or it might download automatically to your

downloads folder.

Open this file in excel once downloaded.

The file will contain a simple spreadsheet with the following headers in the columns across the page:

NameMobilePhoneHome PhoneOther PhoneEmailOther EmailFaxDescription
RegionTypeIndustrySub IndustryLinkedin ProfileWebsiteMailing StreetMailing CityMailing State/ Province
Mailing Zip/Postal CodeMailing CountryOther CityOther State/ ProvinceOther Zip/Postal CodeOther CountryContact Ref. NoSourceTags

Copy and paste your data into this table without removing any of the field headers


If you are missing some data, this is OK, it may be added later. 

It is critical that you add a ‘Name' for every company. If this is not done, the file will not import correctly.


Save the file as a comma delimited file.


FOR WINDOWS

  1. Click 'Save As'
  2. The File Format should be changed to be ‘CSV UTF-8 (comma delimited) (*.csv)’
  3. Click Save
  4. Click continue when the message below appears
Users/DavidsMacbookPro15/Downloads/Screen Shot

FOR MACS

  1. Click 'Save As'
  2. The File Format should be changed to be ‘Comma Separated Values (.csv)’
  3. Click Save
  4. Click continue when the message below appears
Users/DavidsMacbookPro15/Downloads/Screen Shot

Now that your import file is ready to insert into Sentia, confirm by selecting 'Step 3. Done - my file is ready.'

Screen%20Shot%202019-02-05%20at%202.49.25%20pm.png


To proceed to the upload window, select 'Step 4. Upload File'.

Screen%20Shot%202019-02-05%20at%202.49.56%20pm.png


You will now be required to 'Select a file' by clicking on the 'Choose File' button. 

Users/DavidsMacbookPro15/Downloads/image (7).pn


Navigate to the template you saved earlier and open the file on the popup.

/Users/DavidsMacbookPro15/Desktop/Screen Shot 2018-11-23 at 9.04.48 am (1).png


Click the 'Next' button to proceed. 

The wizard will automatically map your fields to the system. It should look like the following.

/Users/DavidsMacbookPro15/Desktop/Screen Shot 2018-11-23 at 9.57.50 am (1).png

If you encounter an error and do not see this screen please ensure you have not changed or removed any field headers in the template file, and your template file is indeed saved in the .csv format. 

The 'Mapping Status' for every header should say 'Yes,' as per the screenshot above. 

Select 'Next' at the bottom of all the mapping to begin importing your file. 

After the import is complete you will see a summary screen showing information regarding your import (similar to the below). 

Users/DavidsMacbookPro15/Downloads/image (10).p


You have now inserted the companies that were in your template. 

Follow the link to go back on screen to then see a summary of every record. Here you can make changes if required to the data. 


Use the 'Back to Sentia' button to finish the entire import process. 

Screen%20Shot%202019-02-05%20at%202.51.48%20pm.png