See Online Videos
This form enables you to import data into Symphony from Excel. Here you tell Symphony which file to import and how the data is laid out. When processing the data, Symphony creates the Respondents, Codes, Tags, and Demographics as needed.
Symphony handles two general layouts of data.
1. One row per comment -- in this case, each row contains the complete data for the Comment, and "stands alone" from the other rows. Respondent data (name, title, etc.) is repeated for each row, and there are as many rows of data for each Respondent as there are Comments. If the data is pre-coded, the columns for the codes must reside on the same row as the comment. This format is typical of database extracts.
2. One row per Respondent -- in this case, each row contains the complete data provided by a single Respondent. Each row may contain any number of comments. If the data is pre-coded (for example, by the item question text on a survey or by question group) the code cell must reside in the same column as the comment, and the same code is applied to all comments in that row. This format is typical of online surveys.
 Save Template
Click this button to save the cell mappings to a file. This is useful if you intend to import data in other projects from spreadsheets using the same format. When you click this button, a Save As dialog opens.
|
 Run Button
Click this button to begin importing the data.
|
 Clear Cell Mappings
Click this button to remove all cell mappings and start over.
|
 Cancel Import
Click this button if you decide to cancel the import while it is in progress.
|
 Data File
This is the name of the spreadsheet you want to import. To set the name, click the navigate button (...) at the end of the field and locate the spreadsheet you want to import. Once the file is chosen, Symphony extracts a sample of data and loads it into the Preview pane at the bottom of the view.
|
 Respondent Default Cell Map
|
 Template File
If you previously saved a file using the Save Template button, you can retrieve it by clicking the navigate button (...) at the end of the field. By default, this field already has the name of the last file used.
|
 Demographic Cell Map
<TODO> Insert description text here... And don't forget to add keyword for this topic
|
 Source File Preview Pane
This area displays a sample of the data from the Data File you
|
 Tag Cell Map
This section shows the Tag mappings for the highlighted Comment cell map. If your comments include tags, drag them into this column. If your definition includes more than one comment, only the tag cells associated with the currently-highlighted comment are displayed.
|
 Comment Cell Map
This section shows the current Comment cell mappings.
|
 SpreadSheet
This dropdown list contains the names of all the spreadsheets included in the Data File workbook. By default, data is imported from the first spreadsheet. To import from a different spreadsheet, choose it from this dropdown list. Whenever you switch spreadsheets, a sample of data is loaded in the Source File Preview Pane.
|
 Duplicate Action
This specifies which action to take when a duplicate comment is encountered.
A comment is considered a duplicate when one already exists for the same Respondent, with the exact same text, and coded to the same code.
Your choices are as follows:
-
Accept all -- Symphony will automatically import duplicate Comments
-
Ignore all -- Symphony will not import duplicate Comments
-
Ask me -- When a duplicate is encountered, Symphony will display the Comment and related information and will let you choose whether or not to import it. At the same time, Symphony will give you the option to switch your preference to Accept all or Ignore all, so you are not prompted anymore.
|
