Project

Profile

Help

Import contacts into Planio via CSV files » History » Sprint/Milestone 3

Gregor Schmidt, 03/13/2018 04:02 PM

1 1 Gregor Schmidt
# Import contacts into Planio via CSV files
2
3 2 Gregor Schmidt
This is a guide on how you can import contacts and companies from Comma Separated Values (CSV) files using the importer in Planio. You'll be able to move data between different software packages easily.
4 1 Gregor Schmidt
5
{{>toc}}
6
7
There are two steps to this process. First, you need to prepare a CSV file for import. Second, you have to carry out the import. We’ll cover both in this guide.
8
9
## Preparing the CSV file
10
11 2 Gregor Schmidt
You need to export your contacts in the CSV format. Most contact databases provide one way or another to do so. If you're managing addresses using Excel sheets, you can create a CSV file by clicking on **File -\> Save As…** and then selecting **Comma Separated Values** as the format from the drop-down menu.
12 1 Gregor Schmidt
13 3 Gregor Schmidt
Your CSV file can have the following headers. You’ll find a sample CSV file here: attachment:example.csv. Each row corresponds to a newly created contact.
14 1 Gregor Schmidt
15 3 Gregor Schmidt
| Values            | Notes                                                                                                                                                                                                                           |
16
| ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
17
| Company fields    |                                                                                                                                                                                                                                 |
18
| Name              | Enter the company name of a company, which is already stored within your Planio project. This field is optional. Alternatively, you may select a pre-existing company for all new contacts when configuring the import.         |
19
| Contact fields    |                                                                                                                                                                                                                                 |
20
| Gender/Salutation | Use either `m` of `f` to indicate the person's gender. Alternatively provide commonly used salutations like "Mr." or "Mrs."                                                                                                     |
21
| First name        | Enter the contact's first name                                                                                                                                                                                                  |
22
| Last name         | This field contains the family name of the person.                                                                                                                                                                              |
23
| Email address(es) | You may provide up to three separate columns of email addresses.                                                                                                                                                                |
24
| Phone Number(s)   | Enter up to three phone/fax numbers. Enter the type of phone separately from the actual phone number. Planio knows the following kinds of phone numbers: "Work", "Home", "Mobile", "Work Fax", "Home Fax", "Pager", and "Other" |
25 1 Gregor Schmidt
26 3 Gregor Schmidt
If you wish to create companies along side contacts, you can select "Create missing values". Then you'll be able to also import further information about the company.
27
28
**Please note:** When importing companies, the importer will not overwrite information within existing companies. If the imported attributes differ from previously stored values, a new company with the same name will be created instead. You may later merge these duplicates, if need be.
29
30 1 Gregor Schmidt
## Importing the CSV File
31
32 2 Gregor Schmidt
Now, you have a CSV file ready for import. The next step is to import it into Planio. You’ll find the button for the Import in the top right corner on the overall contacts page.
33 1 Gregor Schmidt
34 2 Gregor Schmidt
{{figure(Click on Import contacts in the top right)
35
!contacts-page@2x.png!
36 1 Gregor Schmidt
}}
37
38
Then, select your CSV file using the file picker.
39
40
{{figure(Upload the CSV file using the file picker)
41
!file-selector@2x.png!
42
}}
43
44
On the next page, you can select options for importing the CSV File
45
46
{{figure(Select the options for importing the CSV file based on how your CSV file is formatted)
47
!import-options@2x.png!
48
}}
49
50
| Option          | Notes                                                                                                |
51
| --------------- | ---------------------------------------------------------------------------------------------------- |
52
| Field separator | You can select between comma separated values or semicolon separated values                          |
53
| Field wrapper   | You can select between double quotes or single quotes.                                               |
54
| Encoding        | You can select the encoding for the CSV file                                                         |
55
| Date format     | You can select one of five date formats (YYYY-MM-DD, DD/MM/YYYY, MM/DD/YYY, DD.MM.YYY or DD-MM-YYYY) |
56
57 3 Gregor Schmidt
First you have to select a target project for the import. Then, you have to map the values from the CSV files to contact fields in Planio. You can select each value from the drop-down menu beside each attribute. You’ll also see a file content preview further down, so you can make sure you’re importing the right data.
58 1 Gregor Schmidt
59 3 Gregor Schmidt
{{figure(Assign each column in the CSV file to a contact field)
60 1 Gregor Schmidt
!field-mapping@2x.png!
61
}}
62
63
Once you’re done assigning the values to each field, you can click on import to start the import.
64
65
If you encounter any problems, you'll see a page with the errors and the import will not be carried out. You can restart the import once you've fixed the problems in the CSV file.
66
67
{{figure(A list of the errors encountered during the import)
68
!import-error@2x.png!
69
}}
70
71 3 Gregor Schmidt
If all goes well, you’ll see a list of the imported contacts.
72 1 Gregor Schmidt
73 3 Gregor Schmidt
{{figure(You'll see a list of the created contacts.)
74 1 Gregor Schmidt
!successful-import@2x.png!
75
}}
76
77 3 Gregor Schmidt
That's how you can import companies and contacts into Planio using the CSV importer.