home *** CD-ROM | disk | FTP | other *** search
/ bombers.k12.ar.us / bombers.k12.ar.us.tar / bombers.k12.ar.us / survey_unconfigured / ExportData.asp < prev    next >
Text File  |  2006-05-31  |  10KB  |  247 lines
  1. <!--#Include File="Include/Top_inc.asp"-->
  2. <%
  3. '***********************************************************************
  4. '   Application: SelectSurveyASP Advanced v8.1.5
  5. '   Author: Aaron Baril for ClassApps.com
  6. '   Page Description: This page is used to export data to CSV/Excel format.
  7. '
  8. '   COPYRIGHT NOTICE
  9. '
  10. '   See attached Software License Agreement
  11. '
  12. '   (c) Copyright 2002 - 2006 by ClassApps.com.  All rights reserved.
  13. '***********************************************************************
  14. %>
  15. <!--#Include File="Include/SurveyUtility_inc.asp"-->
  16. <!--#Include File="Include/Utility_inc.asp"-->
  17. <!--#Include File="Include/Constants_inc.asp"-->
  18. <!--#Include File="Include/Config_inc.asp"-->
  19. <!--#Include File="Include/ID_inc.asp"-->
  20. <!--#Include File="Include/adovbs_inc.asp"-->
  21. <!--#Include File="Include/CurrentUser_inc.asp"-->
  22. <!--#Include File="Include/ReportShare_inc.asp"-->
  23. <!--#Include File="Include/SurveySecurity_inc.asp"-->
  24.  
  25. <%
  26.     Dim lngSurveyID
  27.  
  28.     'Get the survey ID
  29.     If Len(Request.QueryString("SID")) > 0 Then
  30.         lngSurveyID = CreateReportShareSessionString(Request.QueryString("SID"))
  31.  
  32.         'Check to make sure that this user has data export granted
  33.         If GetValueFromReportShareSessionString(SUR_REPORT_SHARE_FIELD_EXPORT_DATA) = SUR_BOOLEAN_NEGATIVE Then
  34.             Response.Redirect "AccessDenied.asp?Reason=" & SUR_ACCESS_DENIED_NOT_ADMIN_SECURITY_LEVEL
  35.         End If
  36.     Else
  37.         lngSurveyID = Request.QueryString("SurveyID")
  38.  
  39.         'If the user is not the survey owner and does not have "Admin" permission, redirect to the access denied page.
  40.         If IsUserOwnerOrAdmin(lngSurveyID) = False Then
  41.             Response.Redirect "AccessDenied.asp?Reason=" & SUR_ACCESS_DENIED_NOT_ADMIN_SECURITY_LEVEL
  42.         End If
  43.     End If
  44. %>
  45. <html>
  46. <head>
  47.     <title>Export Survey Data</title>
  48.     <link rel="stylesheet" href="Resources/StyleSheet/SurveyStyle.css">
  49. </head>
  50.  
  51. <script language ="JavaScript" src="ClientInclude/Utility.js"></script>
  52.  
  53. <body class="MainBodyStyle">
  54.  
  55. <!--#Include File="Include/FrameworkTop_inc.asp"-->
  56.  
  57. <table border="0" cellspacing="0" cellpadding="0" width="754" class="MediumBlueBackgroundColor">
  58.     <tr>
  59.         <td height="36" valign="center">
  60.               <span class="H1HeadingStyle"><a name="skipnav" tabindex="1">Export Survey Data</a></span> <img style="cursor:hand" alt="Help" onClick="javascript:window.open('Help/Help.htm#ExportingData', null, 'menubar=no,toolbar=no,titlebar=no,status=no,left=10,top=10,scrollbars=yes,resizable=yes,height=550,width=770');" border="0" src="Resources/Images/Help.gif">
  61.         </td>
  62.     </tr>
  63. </table>
  64.  
  65. <!--#Include File="Include/FrameworkTop2_inc.asp"-->
  66.  
  67. <table width="740" border="0" cellpadding="0" cellspacing="6" class="LightGrayBackgroundColor">
  68.     <form action="ExportDataAction.asp" method="post" name="frmExportData">
  69.     <input type="hidden" value="<%=lngSurveyID%>" name="SurveyID">
  70.         <tr>
  71.             <td width="1" rowspan="2"></td>
  72.             <td height="36" valign="center">
  73.                 <span class="H2HeadingStyle">Export Data for Survey '<%=Request.QueryString("SurveyName")%>'</span>
  74.             </td>
  75.             <td width="1" rowspan="2"> </td>
  76.         </tr>
  77.         <tr>
  78.             <td valign="top" height="52">
  79.                 <span class="Normal">
  80.                     This page exports data in CSV (Excel) format for the selected survey.  Standard question and answer data
  81.                     is always exported for each report.  To export, first select a data format.  Then, optionally, select
  82.                     additional fields of response and/or user data.
  83.                 </span>
  84.             </td>
  85.         </tr>
  86.     </table>
  87.     <table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td height="1" background="Resources/Images/ThinDivider.gif"></td></tr>
  88.     <table border="0" cellpadding="0" cellspacing="6" width="740" class="WhiteBackgroundColor">
  89.         <tr>
  90.             <td width="1"></td>
  91.             <td>
  92.                 <table width="690" cellspacing="2" cellpadding="0" border="0">
  93.                     <tr>
  94.                         <td colspan="4">
  95.                             <span class="H3HeadingStyle"><label for="optDataFormat">Data Format</label></span>
  96.                         </td>
  97.                     </tr>
  98.                     <tr>
  99.                         <td colspan="4">
  100.                             <input checked type="radio" value="<%=SUR_EXPORT_DATA_FORMAT_USER_RESPONSES%>" name="optDataFormat" id="optDataFormat">
  101.                             <span class="NormalBold">User Responses</span>
  102.                             <span class="Normal"> - Export each user's response as a row, with one column per question.</span>
  103.                         </td>
  104.                     </tr>
  105.                     <tr>
  106.                         <td colspan="4">
  107.                             <input type="radio" value="<%=SUR_EXPORT_DATA_FORMAT_INDIVIDUAL_RESPONSES%>" name="optDataFormat" id="optDataFormat">
  108.                             <span class="NormalBold">Individual Responses</span>
  109.                             <span class="Normal"> - Export each answer as a row, with multiple rows for multiselect questions.</span>
  110.                         </td>
  111.                     </tr>
  112.                     <tr>
  113.                         <td colspan="4">
  114.                             <input type="radio" value="<%=SUR_EXPORT_DATA_FORMAT_SPSS%>" name="optDataFormat" id="optDataFormat">
  115.                             <span class="NormalBold">SPSS Format</span>
  116.                             <span class="Normal"> - Export each response as a row, with one column per possible answer to each question.</span>
  117.                         </td>
  118.                     </tr>
  119.                     <tr>
  120.                         <td colspan="4">
  121.                              
  122.                         </td>
  123.                     </tr>
  124.                     <tr>
  125.                         <td colspan="4">
  126.                             <span class="H3HeadingStyle">Response Data</span>
  127.                         </td>
  128.                     </tr>
  129.                     <tr>
  130.                         <td>
  131.                             <input type="checkbox" name="chkUsername" id="chkUsername" value="ON"> <span class="Normal"><label for="chkUsername">Username</label></span>
  132.                         </td>
  133.                         <td>
  134.                             <input type="checkbox" name="chkIPAddress" id="chkIPAddress" value="ON"> <span class="Normal"><label for="chkIPAddress">IP Address</label></span>
  135.                         </td>
  136.                         <td>
  137.                             <input type="checkbox" checked name="chkDateStarted" id="chkDateStarted" value="ON"> <span class="Normal"><label for="chkDateStarted">Date Started</label></span>
  138.                         </td>
  139.                         <td>
  140.                             <input type="checkbox" name="chkTimeStarted" id="chkTimeStarted" value="ON"> <span class="Normal"><label for="chkTimeStarted">Time Started</label></span>
  141.                         </td>
  142.                     </tr>
  143.                     <tr>
  144.                         <td>
  145.                             <input type="checkbox" name="chkDateCompleted" id="chkDateCompleted" value="ON"> <span class="Normal"><label for="chkDateCompleted">Date Completed</label></span>
  146.                         </td>
  147.                         <td>
  148.                             <input type="checkbox" name="chkTimeCompleted" id="chkTimeCompleted" value="ON"> <span class="Normal"><label for="chkTimeCompleted">Time Completed</label></span>
  149.                         </td>
  150.                         <td>
  151.                              
  152.                         </td>
  153.                         <td>
  154.                              
  155.                         </td>
  156.                     </tr>
  157.                     <tr>
  158.                         <td colspan="4">
  159.                              
  160.                         </td>
  161.                     </tr>
  162.                     <tr>
  163.                         <td colspan="4">
  164.                             <span class="H3HeadingStyle">User Data</span>
  165.                         </td>
  166.                     </tr>
  167.                     <tr>
  168.                         <td width="173">
  169.                             <input type="checkbox" name="chkFirstName" id="chkFirstName" value="ON"> <span class="Normal"><label for="chkFirstName">First Name</label></span>
  170.                         </td>
  171.                         <td width="172">
  172.                             <input type="checkbox" name="chkLastName" id="chkLastName" value="ON"> <span class="Normal"><label for="chkLastName">Last Name</label></span>
  173.                         </td>
  174.                         <td width="173">
  175.                             <input type="checkbox" name="chkEmailAddress" id="chkEmailAddress" value="ON"> <span class="Normal"><label for="chkEmailAddress">Email Address</label></span>
  176.                         </td>
  177.                         <td width="172">
  178.                              
  179.                         </td>
  180.                     </tr>
  181.                     <tr>
  182.                         <td>
  183.                             <input type="checkbox" name="chkCompany" id="chkCompany" value="ON"> <span class="Normal"><label for="chkCompany">Company</label></span>
  184.                         </td>
  185.                         <td>
  186.                             <input type="checkbox" name="chkCurrentPosition" id="chkCurrentPosition" value="ON"> <span class="Normal"><label for="chkCurrentPosition">Current Position</label></span>
  187.                         </td>
  188.                         <td>
  189.                             <input type="checkbox" name="chkLocation" id="chkLocation" value="ON"> <span class="Normal"><label for="chkLocation">Location</label></span>
  190.                         </td>
  191.                         <td>
  192.                              
  193.                         </td>
  194.                     </tr>
  195.                     <!--SB 5-8-2006 START -->
  196.                     <tr>
  197.                         <td>
  198.                             <input type="checkbox" name="chkEmailFirstName" id="chkEmailFirstName" value="ON"> <span class="Normal">
  199.                             <label for="chkEmailFirstName">Email First Name</label></span>
  200.                         </td>
  201.                         <td>
  202.                             <input type="checkbox" name="chkEmailLastName" id="chkEmailLastName" value="ON"> <span class="Normal">
  203.                             <label for="chkEmailLastName">Email Last Name</label></span> </td>
  204.                         <td>
  205.                             <input type="checkbox" name="chkEmailListAddress" id="chkEmailListAddress" value="ON"> <span class="Normal">
  206.                             <label for="chkEmailListAddress">Email List Address</label></span></td>
  207.                         <td>
  208.                              </td>
  209.                     </tr>
  210.                     <!--SB 5-8-2006 END -->
  211.                     <tr>
  212.                         <td colspan="4">
  213.                              
  214.                         </td>
  215.                     </tr>
  216.                     <tr>
  217.                         <td colspan="4">
  218.                             <span class="H3HeadingStyle">Hidden Fields</span>
  219.                         </td>
  220.                     </tr>
  221.                     <tr>
  222.                         <td colspan="4" align="left">
  223.                             <input type="checkbox" name="chkHiddenFields" id="chkHiddenFields" value="ON"> <span class="Normal"><label for="chkHiddenFields">Include all hidden fields in the exported data</label></span>
  224.                         </td>
  225.                     </tr>
  226.                     <tr>
  227.                         <td colspan="4" align="right">
  228.                             <a href="Reports.asp?SurveyID=<%=lngSurveyID%><% If Len(Request.QueryString("SID")) > 0 Then Response.Write "&SID=" & Request.QueryString("SID") End If %>"><img border="0" alt="Cancel" name="btnCancel" src="Resources/Buttons/Cancel.gif"></a>
  229.                             <input type="image" border="0" alt="Export" name="btnExport" src="Resources/Buttons/Export.gif">
  230.                         </td>
  231.                     </tr>
  232.                 </table>
  233.             </td>
  234.             <td width="1"> </td>
  235.         </tr>
  236.     </form>
  237. </table>
  238.  
  239. <!--#Include File="Include/FrameworkBottom_inc.asp"-->
  240.  
  241. </body>
  242. </html>
  243.  
  244. <%
  245.     'Ensure that the web server returns the page
  246.     Response.Flush
  247. %>