Print  Feedback
« Back to Help Center

SQL Import Data File | Flat File Format

What is a SQL Import Data File?

In cases when data needs to be exported from the system and imported into another SQL based database, we provide a Flat Data file format for easy movement of the dataset.

How do I download the SQL Import Data file for my Survey?

Go To:

  • Login »  Surveys »  Reports »  Export Data »  SQL Import Data File

Screenshot
Survey Software Help Image

A Zip file will be generated. Download and open the Zip file.

Can I filter data for downloading?

Yes. Following filter options are available:

  • Time: Specify the start date and end date and responses for the specified time period will be downloaded.
  • Response Status:Responses matching the selected response staus will be downloaded.
Both time and response status filters can be used in combination.

Screenshot
Survey Software Help Image

File components:

The SQL Import Data File has 3 components:

Screenshot
Survey Software Help Image

  • A CSV File of all the Responses - IP Address, Timestamp etc.

    • Screenshot
    Survey Software Help Image

  • A CSV File of all the Mappings (QuestionID, AnswerID)

    • Screenshot
    Survey Software Help Image

  • A CSV File of all Question Metadata (QuestionID, QuestionType etc.)

    • Screenshot
    Survey Software Help Image

License Restrictions

This feature/tool [Flat Data File] is not available as part of any of our standard self-service licenses. It is part of our Enterprise Service License. Please contact your Account Manager for pricing and options for purchasing the Enterprise Service License.

Please Visit Survey Analytics to learn more about Enterprise Solutions

You may also be interested in...

 Print  Feedback
« Back to Help Center