|Compatibility:||IdSurvey 6||IdSurvey 7|
The contacts list (also called contacts DB) is the list of all the respondents and potential respondents to the survey.
You can import a contacts list by uploading a file in Excel format.
Each row represents a contact and each column is a contact field.
You don’t have to revise the column headers of your Excel file in order to upload the list on IdSurvey. The import guided procedure will allow you to easily associate the columns of the Excel file to the standard fields and custom fields already present in the survey or to create new ones.
In order to upload contacts go to the “Contacts Management” page from the survey settings. Click on the “Options” button on the top left of the page and then on “Import”.
Select the Excel file that you want to upload and click on the button “Insert”.
Now IdSurvey will ask you to select the sheet of the Excel file that you want to import.
- If the file that you are importing only contains one spreadsheet, the sheet will be automatically selected and you will move on to the following step.
Here you will be asked to associate the Excel columns to the IdSurvey fields.
The system will automatically associate the column headers of the existing fields when the names are corresponding.
Only the columns that will not get automatically recognized and for which an action is required will be displayed in red. For each column that was not recognized you can choose between: associating it to an existing field by choosing it from the dropdown menu, creating a new column or ignoring the column so that it will be excluded from the export (displayed in grey).
When all the columns have been recognized you can move on to the next step.
- By clicking on “Create new fields automatically” all the columns not yet recognized will be set on “New column”, creating a new field for each column.
- The name of the fields cannot contain blank spaces of special characters except for the _ (underscore). IdSurvey will automatically convert each character that was not accepted in underscore.
- The software will save the associations between columns and custom fields of the survey for the following imports. Should you need to import multiple excel files with the same column headers, these will be automatically recognized. You can manually edit the “Label import” from the “Manage custom fields” section.
- According to the methodology you are distributing the survey with, some of the standard fields will be necessary for the correct functioning of IdSurvey, such as the fields for telephone numbers or email address etc. Please check the table below for further details.
- Some of the standard fields have preset formats and cannot be edited. For example, the “date of birth” field only accepts dates in the yyyy-mm-dd format and the “number of employees” field only accepts whole numbers. See the Standard Fields list for more details.
Associate your contacts to the CATI, CAWI, CAPI methodologies that you plan to use for your project.
Click on “Insert data” to complete the uploading process.
- You can change this setting afterwards from the “Options” button of the “Contacts Management” page or from the page of each individual contact.