Monday, October 14, 2013

How to Import contacts to SendTree

If you have a large number of contacts to send messages to, you will likely want to upload a list rather than type in each contact manually.

First, choose which SendTree you want to upload your contacts to by using the "My account" menu at the top of the page. In this example we have a SendTree named "VIP Customers".





On the Recipients tab, you will find an "Upload recipients" button in the panel on the right:




Clicking this button will show the upload panel:


Click "Choose File" to choose your CSV data file, then click the "Upload" button to upload the data to SendTree. But first let's have a look at the CSV file format used for uploading the data.

Suppose you want to use SendTree's text messaging service to reach a list of 15 text contacts. If you edited your contact list in a spreadsheet, it would have three columns of data, and might look something like this:



The first column is the name of your contact, the second column is their mobile number, and the third column tells SendTree that you want to send TEXT messages that phone number.


A note about contact types

You can specify either TEXT, VOICE, or EMAIL for the message type. You would supply an email address instead of a phone number is the latter case. Here's an example having three different people, showing each message type.



Keep in mind that if you have one person who wants to receive a TEXT and an EMAIL, then you simply include that person for each type of communications that want. For example, this person "J. Smith" will receive a TEXT, a VOICE message, and an EMAIL.




When you save your speadsheet, you can save it as a "comma separated value" file, or CSV file. If you opened your CSV file in a text editor (like Notepad, or Textedit), you would find your 15 contacts data separated by commas, something like this:



With this CSV file, you can now click the "Choose File" button, choose this file, and then click "Upload". The recipients page should reflect the newly imported contacts.



Knowing how to upload your contacts will make it practical when you already have contact information in another form. You might have to use a spreadsheet to isolate the three columns of data. Just copy/paste and organize your data in a new sheet and save-as a CSV file.

Happy uploading!



One more thing about CSV files



Note that you do not have to use a spreadsheet to create a valid CSV file. You could create or edit your data with a text editor, like Notepad or Textedit. But pay careful attention to your use of commas and quotations.

For example, consider a name with a suffix, which is usually presented with a comma. What happens if you use that as a name in your CSV file? Here's some example data:



When this is turned into a proper CSV file, those names will be quoted, to keep the comma intact. I.e., the CSV for this file would look like:



If you build your own CSV file, take a close look at where the double quotes and the commas are placed.