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
 
                
                       
              
    
  - 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.
 
 
                
                       
              
    
   - A CSV File of all the Mappings (QuestionID, AnswerID)
 
 
                
                       
              
    
   - A CSV File of all Question Metadata (QuestionID, QuestionType etc.)
 
                
                       
              
    
 
  
  
     
   
     
   
   
   
      Thank you for submitting feedback.