{"id":4813,"date":"2012-10-23T14:05:11","date_gmt":"2012-10-23T14:05:11","guid":{"rendered":"https:\/\/www.snapsurveys.com\/support-snap11\/?page_id=4813"},"modified":"2019-01-10T15:06:43","modified_gmt":"2019-01-10T15:06:43","slug":"merging-similar-surveys","status":"publish","type":"page","link":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/","title":{"rendered":"Merging Data"},"content":{"rendered":"

This worksheet explains how to use the Database Link Wizard<\/strong> to import data from another Snap survey even where the two surveys are not identical.
\nFor details of importing\/exporting data to a database package click here<\/a>.<\/p>\n

Importing\/exporting data to another Snap survey<\/h3>\n

Snap can import and export data, variables and codes between Snap surveys even if the variables and codes are not identical.
\nThe easiest way to do this is using a database link to import or export the data.
\nThis method can be used to merge surveys:<\/p>\n

    \n
  1. Archive the survey<\/a> you want to add data to, in case of accidents.<\/li>\n
  2. Open the survey that you want to add data to.<\/li>\n
  3. Click \"Database on the Snap toolbar to open the Database Linkage<\/strong> dialog.\n
    \"1Database<\/div>\n<\/li>\n
  4. Click [New…]<\/strong> to create a new database link. The Database Linkage Wizard<\/strong> dialog will be displayed.<\/li>\n
  5. Select Import from Survey<\/strong>.\n
    \"2Linkage<\/div>\n<\/li>\n
  6. Click [Next>]<\/strong>.<\/li>\n
  7. Select a survey to import from. Snap lists all the surveys available in the default directory. If the survey you require is not in this directory use the [Browse…]<\/strong> button to find the appropriate directory.<\/li>\n
  8. Click [Next>]<\/strong> when you have highlighted the survey you require.\n
    \"3Select<\/div>\n<\/li>\n
  9. \n
    Snap displays another dialog.
    \nSelect the type of Import\/Export<\/strong> Options to use.
    \nJoin cases where the link variables match:<\/strong>
    \nOnly import\/export data where the value in the link variable matches between the two surveys (E.g. a survey containing customer ID numbers matches the information in the link survey with the same ID number.) Snap imports all requested data where two ID numbers are matched, and ignores all data in cases where the ID number does not match.
    \nJoin matching cases and append unmatched cases:<\/strong>
    \nThis option works as above, and also adds the unmatched data as new cases at the end of the file.
    \nAppend unmatched cases:<\/strong>
    \nThis option only imports\/exports cases that do not find a match between the link variable in the surveys.
    \nAppend all cases:<\/strong>This option imports\/exports every case of data into your survey as a new data case. It does not try to match the link variables.
    \n\"4Import
    \nIf you select Append all Cases<\/strong> you do not need to define a link variable.<\/div>\n<\/li>\n
  10. If you select any of the other import types, select the link variable in your current survey.\n
    \"5Link<\/div>\n<\/li>\n
  11. Select the variable containing the matching data in the survey you are importing from.
    \nThe link variables must contain a value that is unique for each case, and which match between the two surveys. For example they could both be ‘Customer ID’ variables. (Link variables are also known as database keys).<\/li>\n
  12. Click [Next]<\/strong> to move to a dialog showing a list of variables in survey to import from on the left, with variables in the current survey on the right.<\/li>\n
  13. Map the variables between the surveys. Snap works out the mapping between the variables where possible. To change a mapping, select a row in the right hand column, and click \"Scroll to display a list of available variables in the import survey. Select a variable to load data from, or select a blank to load nothing.\n
    \"6Database<\/div>\n
    If you match variables with multiple responses, Snap displays the possible responses below the variable list. Match the responses in the same way as you match the variables.
    \nThe example shows an extra code, wine\/beer<\/strong>, is an extra code in the survey that you are importing data from. You can assign wine\/beer<\/strong> to the Other<\/strong> code.<\/div>\n
    \"7Database
    \nYou could also create a new code in the current survey for wine\/beer<\/strong> by right clicking the row and selecting New code<\/strong> from the context menu.
    \nYou can create a new variable<\/strong> to match an existing variable in the same way. Right-click in the right hand row, and select New variable from the context menu. If you created a variable, you can modify and delete it.<\/div>\n<\/li>\n
  14. Click [Next]<\/strong> to display a summary of what the link does.<\/li>\n
  15. Check the details are correct, and enter a Name<\/strong> for the database link.<\/li>\n
  16. Click [Finish]<\/strong>. Snap shows the Database Linkage<\/strong> dialog including the new link.\n
    \"8After
    \nIf you wish to alter any part of the link, click [Modify]<\/strong>. To delete a link, click [Delete]<\/strong>. To make a copy of the link, click [Clone]<\/strong>, and then modify the new link as required.<\/div>\n<\/li>\n
  17. Select the link and click [Run]<\/strong> to import the data. Snap displays a brief report. Click [OK]<\/strong> to close it.<\/li>\n
  18. Check your data. This can be done by looking at a summary of the results.
    \nChoose [View]<\/strong> and select [Questionnaire]<\/strong> click \"Data\u00a0and choose [Counts]<\/strong> on the toolbar. Scroll down through the questionnaire checking the figures for each question are correct.<\/li>\n<\/ol>\n

    The Database Link Wizard<\/strong> can also automatically import and export information as data is entered using a Hot Link<\/a>.<\/p>\n

    If there is a topic you would like a worksheet on, email to snapideas@snapsurveys.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

    <\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"parent":43,"menu_order":129,"comment_status":"open","ping_status":"closed","template":"page-templates\/child-page.php","meta":{"_acf_changed":false,"footnotes":""},"class_list":{"0":"post-4813","1":"page","2":"type-page","3":"status-publish","5":"search_category-support-hub"},"acf":[],"yoast_head":"\nMerging Data - Snap Surveys<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Merging Data - Snap Surveys\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/\" \/>\n<meta property=\"og:site_name\" content=\"Snap Surveys\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SnapSurveys\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-10T15:06:43+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@snapsurveys\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/\",\"url\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/\",\"name\":\"Merging Data - Snap Surveys\",\"isPartOf\":{\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/#website\"},\"datePublished\":\"2012-10-23T14:05:11+00:00\",\"dateModified\":\"2019-01-10T15:06:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.snapsurveys.com\/support-snap11\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Worksheets\",\"item\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Merging Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/#website\",\"url\":\"https:\/\/www.snapsurveys.com\/support-snap11\/\",\"name\":\"Snap Surveys\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.snapsurveys.com\/support-snap11\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Merging Data - Snap Surveys","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_GB","og_type":"article","og_title":"Merging Data - Snap Surveys","og_url":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/","og_site_name":"Snap Surveys","article_publisher":"https:\/\/www.facebook.com\/SnapSurveys","article_modified_time":"2019-01-10T15:06:43+00:00","twitter_card":"summary_large_image","twitter_site":"@snapsurveys","twitter_misc":{"Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/","url":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/","name":"Merging Data - Snap Surveys","isPartOf":{"@id":"https:\/\/www.snapsurveys.com\/support-snap11\/#website"},"datePublished":"2012-10-23T14:05:11+00:00","dateModified":"2019-01-10T15:06:43+00:00","breadcrumb":{"@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/merging-similar-surveys\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.snapsurveys.com\/support-snap11\/"},{"@type":"ListItem","position":2,"name":"Worksheets","item":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/"},{"@type":"ListItem","position":3,"name":"Merging Data"}]},{"@type":"WebSite","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/#website","url":"https:\/\/www.snapsurveys.com\/support-snap11\/","name":"Snap Surveys","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.snapsurveys.com\/support-snap11\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/4813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/comments?post=4813"}],"version-history":[{"count":10,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/4813\/revisions"}],"predecessor-version":[{"id":28164,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/4813\/revisions\/28164"}],"up":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/43"}],"wp:attachment":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/media?parent=4813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}