Documentation: Upload leads

Upload leads to myphoner

Importing data into myphoner is easy and flexible. However, if something goes wrong, this documentation will help you troubleshoot.

Upload a file with leads

Many people have leads stored in a spreadsheet or exported from another system in .csv-files. Here's a quick video describing the good way of getting that list into myphoner, and a guide to give you some extra details.

Screencast that explains how to import leads into myphoner.

Step 1: Prepare your data

Before you begin, take a look at your data. The first row in your spreadsheet must define the column names. Those will be mapped into the fields of your list in myphoner.

If your spreadsheet has a heading or notes on the first row(s), before the column names and the lead data, delete those row(s), so the column names is on the very first row in your spreadsheet.

If your spreadsheet does not define column names on the first row, but simply starts with lead data from the first lead in the list, you'll have to insert a row at position one, and give each column a name.

Here's an example of a well formed spreadsheet (although rather small), ready for import to myphoner:

Name Title Company Phone
John Doe Ceo Doe inc. 12345678

Step 2: Upload the list

Now all you have to do is find the import screen in myphoner. Go to Manage Lists Add a new list , hit "Select file" and locate the file on your hard drive.

When hitting 'Next', you'll be asked if you want to use a template or simply import using the file column names as field names.

Using file column names is faster and easier, so we reccommend this for new users (everything can be changed later).

However, if you already have another list, or if you plan on setting up synchonisation to another system later on, we recommend using a template.

Use our default template to enable synchronisation with other systems. Read more in Configure Integrations.

Use another list as template to enable moving leads back and forth between your lists, for example as part of a pipeline design.



The myphoner import template selection view.
Upload into existing list

If you want to import a file of leads to an existing list, go to Manage Lists  and then choose Import  from the context menu next to the list you want to import into.

During import, you'll be given the option to update existing leads. If you do this, be careful to choose the right field used to match up leads. If an existing lead matches a new lead its stemdata will be updated with data from the new lead. State including category, schedule, claims and activity log will not be changed.



Find the Import option in the list context menu.

Step 3: Preview and map

After selecting your template you'll be presented with a preview of your lead data. There's two important things to look our for here:

  1. Make sure your data looks like you'd expect. If not, refer to the troubleshooting section in the detailed documentation: Upload leads.
  2. Make sure that all the columns you want imported has a green header. If ther header is red, it means that the field has not been mapped and data for that column will not be imported.
    Please not that if you selected 'Use file column names' when selecting template, you won't have to do this.


Having trouble?

If you see an error message while importing a list, please refer to the troubleshooting section in the detailed documentation: Upload leads.



Preview and map your import data.

Step 4: Select user access

Now all that's left is selecting which of your users should have access to call leads in this list. Once done, you'll get to the list configuration screen where you'll get a chance to tweak your list further. But that's covered in the next part of this guide: Configure a List.


Troubleshooting xlsx upload

If you are having trouble uploading an .xlsx file, try exporting it as .csv (comma separated values) format.
You can convert an Excel worksheet to a text file by using the Save As command.

  1. Click the Microsoft Office Button Button image, and then click Save As.
    The Save As dialog box appears.
  2. In the Save as type box, choose the text file format for the worksheet.
    For example, click Text (Tab delimited) or CSV (Comma delimited).

You can find more details here:



Pro Tip

If you haven't already, give OpenOffice a try. It's a great alternative to Excel - it reads excel files and has better support for both reading and writing csv-files, it's completely free and comes both for Mac OSX, Windows and Linux.

Screencast that explains how to convert a spreadsheet to CSV and upload to myphoner.

Troubleshooting csv upload

Most of the time, uploading csv files works all well and dandy, but a number of thing can go wrong, here's some of the most common pitfalls and how to handle them.

I see encoding could not be determined

CSV is a plain text format, and plain text is stored using an encoding, that is different depending on the country or region you live in and the language or character set you use. myphoner tries to detect what encoding your file is using, but sometimes it's too hard, and the attempt to show a preview of your data fails.

In this case, you need to tell myphoner what encoding should be used, or try to save your file again using a differnt encoding. We recommend using UTF-8 when saving your files. OpenOffice will allow you to select the encoding when saving as .csv (see screencast in the top of this page for details). If you are using Excel, try saving as .txt.

I see Error: Illegal quoting in line xx or Error: Unquoted fields do not allow \r or \n (line xx)

CSV is a very simple text format, where the columns are separated by commas or semicolons and line breaks delimits the next row. If your data contains commas, semicolons or line breaks (\r or \n) it needs to be wrapped in quotes, so the computer can tell which characters should be treated as data separators, and which ones should be part of the data. If your data also contains quotes, you might end up in trouble.

If this happens, you need to either

  • Re-export your data with different settings for field and/or text delimiters
  • Or edit the file and manually fix the illegal line (you might have to do this multiple times)

Characters look weird. myphoner tries to guess what character encoding (language) you are using, but sometimes it's wrong.

If you see æ instead of æ , this is most likely a mismatched encoding. If this is the case, try saving your csv file in UTF-8 encoding before upload, if possible.



Having trouble?

You can always contact us at support@myphoner.com if you need any help.

Please note that the best way for us to help you is if you attach the file you are having trouble with, so we can have a look at it ourselves.

Pro Tip

CSV files are plain text files and you can inspect and edit them using a plain text editor such as Sublime Text