Skip to main content

Survey Groups-Import

Overview

User can create a new group or edit an existing one as needed using survey groups option in Uploads module. Users can manage survey groups easily by uploading a file to update multiple groups at once.

To bulk edit the survey groups, follow these steps:

  1. Log in to your Data Governance Tool account. 

    Image of login page  

  2. Click on the hamburger menu on Data Governance Tool

    Image highlighting the hamburger icon

  3. From the menu, click on Uploads

    Image highlighting Uploads module

  4. On the Upload page, click on the Select Document Type drop-down menu Image highlighting Select Document Type drop-down menu

  5. From the Document type drop-down menu, scroll down to select Survey **Group.

    Image showing different document types in dropdown menu

  6. Click on the configure template button to configure the columns in template.

    Image highlighting configure template button

  7. Drag and Drop the fields to either include or exclude columns in the template and once done ,click on export button.

    Image highlighting export button

  8. Click on Save button to save the current configured template.

  9. The survey group template will be downloaded to your device. Open the survey group template with Excel.

  10. The survey group will appear on the excel sheet as shown below Image of Survey group template on excel sheet

  • Survey Group Name: Enter a name of the survey group you are creating here. Each row of responses is treated as a new survey group. You can create multiple survey groups here and add the responses of those groups as required.

  • Emails: Enter the email addresses of those users associated with this group. Multiple emails can be added by separating them with commas.

  • Data Map Systems: Enter the name of an existing data map in the designated column. Each row represents a data map entry. Ensure that only valid, pre-defined data map names are used, as random values are not allowed.

  • Data Flow: Specify the name of the data flow in the designated column. Each row represents a separate data flow process.

  1. In the example below, multiple survey groups have been created.

    Image of excel sheet with multiple survey groups being created

  2. Once all the responses have been entered, save the survey group excel on your device.

To upload survey group file back to Data Governance Tool, follow these steps:

  1. From the Survey Groups Upload page, click on Browse

    Image highlighting the browse button

  2. Select the survey you want to upload.

    Image showing a selected survey in browse option

  3. Click Save to upload the survey group file as shown above.

  4. The survey group file will get uploaded to the Data Governance Tool. The status of the survey group file at this time will be Uploaded.   A web job runs in the backend, which will change the status of the uploaded file. Refresh the page to view the new status

    Image highlighting the status of uploaded file i.e Uploaded

  5. After the web jobs runs, the status of the file will change to Report Generated.

    Image highlighting the status of uploaded file i.e Report Generated

  6. Click on Report Generated to view the file and verify that the details are as required.  Once the verification is done, click the Approve button present on the bottom left of the screen.

    Image showing the generated report

    Note: New groups will appear under the "New" tab, while existing groups will be listed under the "Updates" tab.

  7. On approving the survey file, the following pop-up will appear

    A popup displaying a message "Document Staged for Approving"

  8. The status of the file will now change to **To be Approved

    Image highlighting the status of uploaded file i.e To Be Approved

  9. Once the web job runs, the status of the file will change to Survey Group Generated

    Image highlighting the status of uploaded file i.e Survey Group Generated

To view the uploaded survey groups, follow these steps:

  1. The uploaded survey group will be visible on the Survey group section.

    Image showing the newly added survey groups in Survey Group section

  2. Click on Save Button to save the changes made in survey group section.