/// <summary>
/// Parses XML from the web survey
/// </summary>
/// <param name="result">The parsed results in dictionary format</param>
// private List<WebFieldData> ParseXML(SurveyAnswerResponse result)
private List <WebFieldData> ParseXML(SurveyManagerService.SurveyAnswerResponse result)
{
List <WebFieldData> surveyResponses = new List <WebFieldData>();
foreach (SurveyManagerService.SurveyAnswerDTO surveyAnswer in result.SurveyResponseList)
{
WebFieldData wfData = new WebFieldData();
System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
doc.LoadXml(surveyAnswer.XML);
foreach (XmlElement docElement in doc.ChildNodes)
{
if (docElement.Name.ToLowerInvariant().Equals("surveyresponse"))
{
foreach (XmlElement surveyElement in docElement.ChildNodes)
{
if (surveyElement.Name.ToLowerInvariant().Equals("page") && surveyElement.Attributes.Count > 0 && surveyElement.Attributes[0].Name.ToLowerInvariant().Equals("pageid"))
{
foreach (XmlElement pageElement in surveyElement.ChildNodes)
{
if (pageElement.Name.ToLowerInvariant().Equals("responsedetail"))
{
string fieldName = string.Empty;
if (pageElement.Attributes.Count > 0)
{
fieldName = pageElement.Attributes[0].Value;
}
object fieldValue = pageElement.InnerText;
wfData = new WebFieldData();
wfData.RecordGUID = surveyAnswer.ResponseId;
wfData.Page = Convert.ToInt32(surveyElement.Attributes[0].Value);
wfData.FieldName = fieldName;
wfData.FieldValue = fieldValue;
wfData.Status = surveyAnswer.Status;
if (wfData.Status == 3)
{
surveyResponses.Add(wfData);
}
}
}
}
}
}
}
}
return(surveyResponses);
}
/// <summary>
/// Initiates an export of the data to the specified file.
/// </summary>
public override void Export()
{
OnSetStatusMessage(ImportExportSharedStrings.WEB_CSV_EXPORT_CONNECTING);
rowsExported = 0;
WordBuilder wb = new WordBuilder(SEPARATOR);
StreamWriter sw = null;
SurveyManagerService.SurveyAnswerRequest Request = new SurveyManagerService.SurveyAnswerRequest();
Request.Criteria.SurveyId = surveyKey.ToString();
Request.Criteria.UserPublishKey = secToken;
Request.Criteria.OrganizationKey = orgKey;
Request.Criteria.ReturnSizeInfoOnly = true;
SurveyManagerService.SurveyAnswerResponse Result = client.GetSurveyAnswer(Request);
Pages = Result.NumberOfPages;
PageSize = Result.PageSize;
Request.Criteria.ReturnSizeInfoOnly = false;
int count = 0;
List <SurveyManagerService.SurveyAnswerResponse> Results = new List <SurveyManagerService.SurveyAnswerResponse>();
OnSetStatusMessage(ImportExportSharedStrings.WEB_CSV_EXPORT_BUILDING_COLUMN_HEADINGS);
for (int i = 1; i <= Pages; i++)
{
Request.Criteria.PageNumber = i;
Request.Criteria.PageSize = PageSize;
Result = client.GetSurveyAnswer(Request);
Results.Add(Result);
foreach (SurveyManagerService.SurveyAnswerDTO surveyAnswer in Result.SurveyResponseList)
{
if (surveyAnswer.Status == 3)
{
count++;
}
}
}
if (SetMaxProgressBarValue != null)
{
SetMaxProgressBarValue((double)count);
}
List <string> columnHeaders = new List <string>();
foreach (SurveyManagerService.SurveyAnswerResponse R in Results)
{
wfList = ParseXML(R);
foreach (WebFieldData wfData in wfList)
{
if (!columnHeaders.Contains(wfData.FieldName))
{
columnHeaders.Add(wfData.FieldName);
}
else
{
break;
}
}
break;
}
try
{
OnSetStatusMessage(ImportExportSharedStrings.WEB_CSV_EXPORTING);
sw = File.CreateText(fileName);
foreach (string s in columnHeaders)
{
wb.Add(s);
}
sw.WriteLine(wb.ToString());
rowsExported = 0;
foreach (SurveyManagerService.SurveyAnswerResponse R in Results)
{
string currentGUID = string.Empty;
string lastGUID = string.Empty;
wfList = ParseXML(R);
wb = new WordBuilder(SEPARATOR);
foreach (WebFieldData wfData in wfList)
{
currentGUID = wfData.RecordGUID;
if (!string.IsNullOrEmpty(currentGUID) && !string.IsNullOrEmpty(lastGUID) && currentGUID != lastGUID)
{
sw.WriteLine(wb.ToString());
wb = new WordBuilder(SEPARATOR);
OnSetStatusMessageAndProgressCount("", 1);
}
string rowValue = wfData.FieldValue.ToString().Replace("\r\n", " ");
if (rowValue.Contains(",") || rowValue.Contains("\""))
{
rowValue = rowValue.Replace("\"", "\"\"");
rowValue = Util.InsertIn(rowValue, "\"");
}
wb.Add(rowValue);
lastGUID = wfData.RecordGUID;
}
sw.WriteLine(wb.ToString());
}
OnSetStatusMessage(ImportExportSharedStrings.WEB_CSV_EXPORT_COMPLETE);
if (FinishExport != null)
{
FinishExport();
}
}
catch (Exception ex)
{
OnSetStatusMessage(ex.Message);
if (ExportFailed != null)
{
ExportFailed(ex.Message);
}
}
finally
{
// Clean up
if (sw != null)
{
sw.Close();
sw.Dispose();
sw = null;
}
}
}
