SQL Export Data File | Flat File Format

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 Export Data file for my Survey?

Go To:

  • Login » Surveys » Manage Data » Export » SQL Import Data File
  • Survey Software Help Image
  • Click on Download
  • 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 status will be downloaded.
Both time and response status filters can be used in combination.

File components:

The SQL Import Data File has 3 components:

  • A CSV File of all the Responses - IP Address, Timestamp etc.
  • Survey Software Help Image

  • A CSV File of all the Mappings (QuestionID, AnswerID)
  • Survey Software Help Image

  • A CSV File of all Question Metadata (QuestionID, QuestionType etc.)
  • Survey Software Help Image

License & Access Options

This feature/tools described here are available with the following license(s) :

Enterprise Edition

Unlimited Surveys, Questions

Advanced Toolset and Features

No Long Term Commitment

Was this article helpful?
Sorry about that
How can we improve it?