public void ReAllocate_Trims_Strings()
{
var _reAllocator = new DataReallocator();
ICollection <IRawRecord> newlyAllocatedRecords = new List <IRawRecord>();
ICollection <Variable> variables = new List <Variable>();
using (FileStream fileStream = new FileStream(@"TestFiles/reallocationtests.sav", FileMode.Open,
FileAccess.Read, FileShare.Read, 2048 * 10, FileOptions.SequentialScan))
{
var reader = new SpssReader(fileStream);
newlyAllocatedRecords = _reAllocator.ReAllocateRecords(reader.Records);
variables = reader.Variables;
}
var string50charVariable = variables.SingleOrDefault(x => x.Name == "string50char");
var string750charVariable = variables.SingleOrDefault(x => x.Name == "string750char");
var emptySpaceRegex = new Regex(@"\s+$");
//string with 50 char max size
Assert.IsFalse(emptySpaceRegex.IsMatch(newlyAllocatedRecords.First().GetValue(string50charVariable)?.ToString()));
Assert.IsFalse(emptySpaceRegex.IsMatch(newlyAllocatedRecords.Skip(1).First().GetValue(string50charVariable)?.ToString()));
//string with 750 char max size
Assert.IsFalse(emptySpaceRegex.IsMatch(newlyAllocatedRecords.First().GetValue(string750charVariable)?.ToString()));
Assert.IsFalse(emptySpaceRegex.IsMatch(newlyAllocatedRecords.Skip(1).First().GetValue(string750charVariable)?.ToString()));
}
public void CreateDatadictionaryFromSpsssav(string filepath, string sourcefilename)
{
using (FileStream fileStream = new FileStream(filepath + sourcefilename, FileMode.Open, FileAccess.Read, FileShare.Read, 2048 * 10,
FileOptions.SequentialScan))
{
// Create the reader, this will read the file header
SpssReader spssDataset = new SpssReader(fileStream);
// Iterate through all the varaibles
foreach (var variable in spssDataset.Variables)
{
// Display name and label
Debug.WriteLine("{0} - {1}", variable.Name, variable.Label);
// Display value-labels collection
foreach (KeyValuePair <double, string> label in variable.ValueLabels)
{
Debug.WriteLine(" {0} - {1}", label.Key, label.Value);
}
uwac.Variable newvar = new uwac.Variable(variable);
if (newvar != null)
{
this.vars.Add(newvar);
}
}
}
ExtractValuesets();
}
//Read in an SPSS .sav file
public Spsssav(string filepath, string savfilename)
{
_dict = new Datadictionary(filepath, savfilename);
using (FileStream fileStream = new FileStream(filepath + savfilename, FileMode.Open, FileAccess.Read, FileShare.Read, 2048 * 10,
FileOptions.SequentialScan))
{
// Create the reader, this will read the file header
spssDataset = new SpssReader(fileStream);
GetData();
//// Iterate through all data rows in the file
//foreach (var record in spssDataset.Records)
//{
// foreach (var variable in spssDataset.Variables)
// {
// Console.Write(variable.Name);
// Console.Write(':');
// // Use the corresponding variable object to get the values.
// Console.Write(record.GetValue(variable));
// // This will get the missing values as null, text with out extra spaces,
// // and date values as DateTime.
// // For original values, use record[variable] or record[int]
// Console.Write('\t');
// }
// Console.WriteLine("");
//}
}
}
static void Main(string[] args)
{
OpenFileDialog openFileDialog = new OpenFileDialog()
{
Multiselect = false, Filter = "SPSS Files(*.sav)|*.sav"
};
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
Console.WriteLine("Running.");
string fileName = openFileDialog.FileName;
string directory = Path.GetDirectoryName(fileName);
string fileNameWithoutExtension = Path.GetFileNameWithoutExtension(fileName);
string outputFileName = directory + "\\" + fileNameWithoutExtension + "_OUTPUT.TXT";
string labelOutputFileName = directory + "\\" + fileNameWithoutExtension + "_LABELS.TXT";
using (SpssReader spssReader = new SpssReader(new FileStream(fileName, FileMode.Open, FileAccess.Read, FileShare.Read)))
{
using (StreamWriter streamWriter = new StreamWriter(outputFileName))
{
string delimiter = "|";
using (StreamWriter labelStreamWriter = new StreamWriter(labelOutputFileName))
{
labelStreamWriter.WriteLine("Name%1Label%1Value%1ValueLabel".Replace("%1", delimiter));
foreach (Variable variable in spssReader.Variables)
{
if (variable.ValueLabels.Any())
{
foreach (KeyValuePair <double, string> pair in variable.ValueLabels)
{
labelStreamWriter.WriteLine("\"" + variable.Name + "\"" + delimiter + "\"" + variable.Label + "\"" + delimiter + pair.Key + delimiter + pair.Value);
}
}
else
{
labelStreamWriter.WriteLine("\"" + variable.Name + "\"" + delimiter + "\"" + variable.Label + "\"" + delimiter + delimiter);
}
}
}
Console.WriteLine(string.Format("{0} created.", labelOutputFileName));
streamWriter.WriteLine("GeneratedUserID" + delimiter + "Key" + delimiter + "Value");
int i = 1;
foreach (Record record in spssReader.Records)
{
foreach (Variable variable in spssReader.Variables)
{
if (!(record.GetValue(variable) == null))
{
streamWriter.WriteLine(i + delimiter + variable.Name + delimiter + record.GetValue(variable));
}
}
i++;
}
Console.WriteLine(string.Format("{0} created.", outputFileName));
}
}
Console.WriteLine("Done.");
}
System.Threading.Thread.Sleep(-1);
}
public static FileResults CheckSpssFile(string filePath)
{
using (FileStream fileStream = new FileStream(filePath, FileMode.Open,
FileAccess.Read,
FileShare.Read, 2048 * 10, FileOptions.SequentialScan))
{
SpssReader spssDataset = new SpssReader(fileStream);
return(new FileResults(spssDataset.Records.Count(), spssDataset.Variables.Count()));
}
}
internal static void ReadData(FileStream fileStream, out int varCount, out int rowCount,
IDictionary <int, Action <int, Variable> > variableValidators = null, IDictionary <int, Action <int, int, Variable, object> > valueValidators = null)
{
SpssReader spssDataset = new SpssReader(fileStream);
varCount = 0;
rowCount = 0;
var variables = spssDataset.Variables;
foreach (var variable in variables)
{
Debug.WriteLine("{0} - {1}", variable.Name, variable.Label);
foreach (KeyValuePair <double, string> label in variable.ValueLabels)
{
Debug.WriteLine(" {0} - {1}", label.Key, label.Value);
}
Action <int, Variable> checkVariable;
if (variableValidators != null && variableValidators.TryGetValue(varCount, out checkVariable))
{
checkVariable(varCount, variable);
}
varCount++;
}
foreach (var record in spssDataset.Records)
{
var varIndex = 0;
foreach (var variable in variables)
{
Debug.Write(variable.Name);
Debug.Write(':');
var value = record.GetValue(variable);
Debug.Write(value);
Debug.Write('\t');
Action <int, int, Variable, object> checkValue;
if (valueValidators != null && valueValidators.TryGetValue(varIndex, out checkValue))
{
checkValue(rowCount, varIndex, variable, value);
}
varIndex++;
}
Debug.WriteLine("");
rowCount++;
}
}
public void Reallocate_UncompressedFile_CopiesAllReordsAndVariables()
{
//after this test the new file is substantially smaller thean the original
int originalRecordCount;
int originalVariableCount;
using (FileStream fileStream = new FileStream(@"TestFiles/230mbfile.sav.gz", FileMode.Open,
FileAccess.Read, FileShare.Read, 2048 * 10, FileOptions.SequentialScan))
using (GZipStream deCompressStream = new GZipStream(fileStream, CompressionMode.Decompress, true))
using (MemoryStream memStream = new MemoryStream())
{
deCompressStream.CopyTo(memStream);
memStream.Position = 0;
SpssReader spssDataset = new SpssReader(memStream);
originalRecordCount = spssDataset.Records.Count();
originalVariableCount = spssDataset.Variables.Count;
var deallocator = new DataReallocator();
// code under test
var records = deallocator.ReAllocateRecords(spssDataset.Records);
using (FileStream outputFileStream = new FileStream(@"TestFiles/34mbfile-after-reallocation.sav", FileMode.Create, FileAccess.Write))
{
using (var writer = new SpssWriter(outputFileStream, spssDataset.Variables, new SpssOptions()
{
Cases = originalRecordCount
}))
{
foreach (var record in records)
{
var newRecord = writer.CreateRecord(record);
writer.WriteRecord(newRecord);
}
writer.EndFile();
}
}
}
var results = FileValidator.CheckSpssFile(@"TestFiles/34mbfile-after-reallocation.sav");
Assert.AreEqual(originalRecordCount, results.RecordCount);
Assert.AreEqual(originalVariableCount, results.VariableCount);
}
public void ReAllocate_Allocates_Doubles_Ints_Strings()
{
var _reAllocator = new DataReallocator();
ICollection <IRawRecord> newlyAllocatedRecords = new List <IRawRecord>();
ICollection <Variable> variables = new List <Variable>();
using (FileStream fileStream = new FileStream(@"TestFiles/reallocationtests.sav", FileMode.Open,
FileAccess.Read, FileShare.Read, 2048 * 10, FileOptions.SequentialScan))
{
var reader = new SpssReader(fileStream);
newlyAllocatedRecords = _reAllocator.ReAllocateRecords(reader.Records);
variables = reader.Variables;
}
var doubleVariable = variables.SingleOrDefault(x => x.Name == "double");
var intVariable = variables.SingleOrDefault(x => x.Name == "numeric");
var string50charVariable = variables.SingleOrDefault(x => x.Name == "string50char");
var string750charVariable = variables.SingleOrDefault(x => x.Name == "string750char");
//doubles
Assert.AreEqual(newlyAllocatedRecords.First().GetValue(doubleVariable), 1.12);
Assert.AreEqual(newlyAllocatedRecords.Skip(1).First().GetValue(doubleVariable), 2.91);
Assert.AreEqual(newlyAllocatedRecords.Last().GetValue(doubleVariable), null);
//ints
Assert.AreEqual(newlyAllocatedRecords.First().GetValue(intVariable), 1);
Assert.AreEqual(newlyAllocatedRecords.Skip(1).First().GetValue(intVariable), null);
Assert.AreEqual(newlyAllocatedRecords.Last().GetValue(intVariable), 3);
//string with 50 char max size
Assert.AreEqual(newlyAllocatedRecords.First().GetValue(string50charVariable), "tfdutq");
Assert.AreEqual(newlyAllocatedRecords.Skip(1).First().GetValue(string50charVariable), "mhom");
Assert.AreEqual(newlyAllocatedRecords.Last().GetValue(string50charVariable), null);
//string with 750 char max size
Assert.AreEqual(newlyAllocatedRecords.First().GetValue(string750charVariable), ".");
Assert.AreEqual(newlyAllocatedRecords.Skip(1).First().GetValue(string750charVariable), "some random text");
Assert.AreEqual(newlyAllocatedRecords.Last().GetValue(string750charVariable), null);
}
public void TestCopyFile()
{
using (FileStream fileStream = new FileStream(@"TestFiles/cakespss1000similarvars.sav", FileMode.Open,
FileAccess.Read,
FileShare.Read, 2048 * 10, FileOptions.SequentialScan))
{
using (FileStream writeStream = new FileStream("newcake1000similarvars.sav", FileMode.Create, FileAccess.Write))
{
SpssReader spssDataset = new SpssReader(fileStream);
SpssWriter spssWriter = new SpssWriter(writeStream, spssDataset.Variables);
foreach (var record in spssDataset.Records)
{
var newRecord = spssWriter.CreateRecord(record);
spssWriter.WriteRecord(newRecord);
}
spssWriter.EndFile();
}
}
Assert.IsTrue(true); // To check errors, set <DeleteDeploymentDirectoryAfterTestRunIsComplete> to False and open the file
}
public void TestReadMetadata()
{
//var filename = @"C:\Users\ttbiagif\Documents\Datasets\Demo_set.sav";
var filename = @"C:\Users\francisco.biagi\Documents\datasets\Tests\strvar.sav";
//var filename = @"C:\Users\francisco.biagi\Documents\Datasets\tests\LongNameVars.sav";
//var filename = @"C:\Users\francisco.biagi\Documents\datasets\Demo_set.sav";
FileStream fileStream = new FileStream(filename, FileMode.Open, FileAccess.Read, FileShare.Read, 2048 * 10, FileOptions.SequentialScan);
SpssReader spssDataset = new SpssReader(fileStream);
var variables = spssDataset.Variables;
foreach (var variable in variables)
{
Debug.WriteLine("{0} - {1}", variable.Name, variable.Label);
foreach (KeyValuePair <double, string> label in variable.ValueLabels)
{
Debug.WriteLine(" {0} - {1}", label.Key, label.Value);
}
}
foreach (var record in spssDataset.Records)
{
foreach (var variable in variables)
{
Debug.Write(variable.Name);
Debug.Write(':');
Debug.Write(record.GetValue(variable));
Debug.Write('\t');
}
Debug.WriteLine("");
}
fileStream.Close();
}
//static void Main(string[] args)
public void runBIJabodetabek()
{
var variablesmap = new Dictionary <string, string>();
int SurveyID = 600615;
//string SurveyPeriod = "2014-09-30";//survey period
string AttendedOn = "2018-08-31";
//string year = getYear(SurveyPeriod);
string country = "Indonesia"; //survey country
DB_insertion_BiallSariroti iobj = new DB_insertion_BiallSariroti();
string questions = "id,weight,B37a1,B37a2,B37a3,B37a4,B37a5,B37a6,B37a7,B37a8,B37a9,B37a10,B37a11,B37a12,B37a13,B37a14,B37a15,B37a16,B37a17,B37a18,B37a19,B37a20,B37a21,B37a22,B37a23"; // dashboard variable value
//string questions = "NETT_SR_User,NETT_Non_SR_User";
string[] spss_variable_name = questions.Split(',');
SpssReader spssDataset;
using (FileStream fileStream = new FileStream(@"D:\spssparsing\SariRoriHW\BI\SRHW_Jabodetabek.sav", FileMode.Open, FileAccess.Read, FileShare.Read, 2048 * 10, FileOptions.SequentialScan))
{
spssDataset = new SpssReader(fileStream); // Create the reader, this will read the file header
foreach (string spss_v in spss_variable_name)
{
foreach (var variable in spssDataset.Variables) // Iterate through all the varaibles
{
if (variable.Name.Equals(spss_v))
{
foreach (KeyValuePair <double, string> label in variable.ValueLabels)
{
string VARIABLE_NAME = spss_v;
string VARIABLE_NAME_SUB_NAME = variable.Name;
string VARIABLE_ID = label.Key.ToString();
string VARIABLE_VALUE = label.Value;
string VARIABLE_NAME_QUESTION = variable.Label;
string BASE_VARIABLE_NAME = variable.Name;
//iobj.insert_Dashboard_variable_values(VARIABLE_NAME, VARIABLE_NAME_SUB_NAME, VARIABLE_ID, VARIABLE_VALUE, VARIABLE_NAME_QUESTION, SurveyID, country, BASE_VARIABLE_NAME, AttendedOn);
}
}
}
}
foreach (var record in spssDataset.Records)
{
string variable_name;
string userID = null;
string u_id = null;
decimal Weight = 0;
string B37a1 = "-- Not Available --";
string B37a2 = "-- Not Available --";
string B37a3 = "-- Not Available --";
string B37a4 = "-- Not Available --";
string B37a5 = "-- Not Available --";
string B37a6 = "-- Not Available --";
string B37a7 = "-- Not Available --";
string B37a8 = "-- Not Available --";
string B37a9 = "-- Not Available --";
string B37a10 = "-- Not Available --";
string B37a11 = "-- Not Available --";
string B37a12 = "-- Not Available --";
string B37a13 = "-- Not Available --";
string B37a14 = "-- Not Available --";
string B37a15 = "-- Not Available --";
string B37a16 = "-- Not Available --";
string B37a17 = "-- Not Available --";
string B37a18 = "-- Not Available --";
string B37a19 = "-- Not Available --";
string B37a20 = "-- Not Available --";
string B37a21 = "-- Not Available --";
string B37a22 = "-- Not Available --";
string B37a23 = "-- Not Available --";
foreach (var variable in spssDataset.Variables)
{
foreach (string spss_v in spss_variable_name)
{
if (variable.Name.Equals(spss_v))
{
variable_name = variable.Name;
switch (variable_name)
{
case "id":
{
u_id = Convert.ToString(record.GetValue(variable));
userID = find_UserId(SurveyID, AttendedOn, u_id);
break;
}
case "weight":
{
Weight = Convert.ToDecimal(record.GetValue(variable));
break;
}
case "B37a1": { B37a1 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a2": { B37a2 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a3": { B37a3 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a4": { B37a4 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a5": { B37a5 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a6": { B37a6 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a7": { B37a7 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a8": { B37a8 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a9": { B37a9 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a10": { B37a10 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a11": { B37a11 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a12": { B37a12 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a13": { B37a13 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a14": { B37a14 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a15": { B37a15 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a16": { B37a16 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a17": { B37a17 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a18": { B37a18 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a19": { B37a19 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a20": { B37a20 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a21": { B37a21 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a22": { B37a22 = Convert.ToString(record.GetValue(variable)); break; }
case "B37a23": { B37a23 = Convert.ToString(record.GetValue(variable)); break; }
}
}
}
}
if (userID != null && Weight != 0)
{
iobj.insert_Jabodetabek_values(userID, SurveyID, AttendedOn, Weight, country, B37a1, B37a2, B37a3, B37a4, B37a5, B37a6, B37a7, B37a8, B37a9, B37a10, B37a11, B37a12, B37a13, B37a14, B37a15, B37a16, B37a17, B37a18, B37a19, B37a20, B37a21, B37a22, B37a23);
}
}
}
}
static void Main(string[] args)
{
System.Threading.Thread.Sleep(10000);
idStudy = new Guid();
DataUploadProvider provider = DataUploadProvider.SPSS;
CaseDataLocation caseDataLocation = CaseDataLocation.Sql;
string databaseProvider = "";
string connectionString = "";
string fileName = "";
string respondentVariable = "";
applicationPath = "";
string language = "";
int idLanguage = 2057;
bool debug = false;
string clientName = "";
// Run through all command line arguments.
foreach (string arg in args)
{
// Get the name of the argument.
string name = arg.Split('=')[0];
// Get the value of the argument.
string value = HttpUtility.UrlDecode(arg.Split('=')[1]);
switch (name)
{
case "IdStudy":
// Parse the id of the study to import from the argument value.
idStudy = Guid.Parse(value);
break;
case "Provider":
// Parse the import provider to use from the argument value.
provider = (DataUploadProvider)Enum.Parse(
typeof(DataUploadProvider),
value
);
break;
case "DatabaseProvider":
databaseProvider = HttpUtility.UrlDecode(value);
break;
case "ConnectionString":
connectionString = HttpUtility.UrlDecode(value);
break;
case "FileName":
fileName = value;
break;
case "RespondentVariable":
respondentVariable = value;
break;
case "ApplicationPath":
applicationPath = HttpUtility.UrlDecode(value);
break;
case "Language":
language = value;
break;
case "ClientName":
clientName = value;
break;
case "CaseDataLocation":
caseDataLocation = (CaseDataLocation)Enum.Parse(
typeof(CaseDataLocation),
value
);
break;
case "IdLanguage":
idLanguage = int.Parse(value);
break;
case "Debug":
debug = bool.Parse(value);
break;
}
}
string createResponsesFile = Path.Combine(
applicationPath,
"App_Data",
"DataStorage",
"CreateResponses.sql"
);
if (debug)
{
//Console.ReadLine();
}
DatabaseCore.Core core;
Study study;
try
{
// Create a connection to the database.
core = new DatabaseCore.Core(
databaseProvider,
connectionString,
databaseProvider,
connectionString,
new string[0]
);
core.ClientName = clientName;
core.CaseDataVersion = 0;
core.CaseDataLocation = caseDataLocation;
// Get the study from the database.
study = core.Studies.GetSingle(idStudy);
}
catch (Exception ex)
{
LogError(applicationPath, idStudy, ex.Message);
return;
}
// Check if the study exists.
if (study == null)
{
LogError(applicationPath, idStudy, "The study was not found in the database.");
return;
}
BaseReader reader = null;
switch (provider)
{
case DataUploadProvider.SPSS:
// Create a new spss reader.
reader = new SpssReader(
fileName,
core,
study,
respondentVariable,
createResponsesFile,
idLanguage
);
break;
case DataUploadProvider.Excel:
case DataUploadProvider.CSV:
// Create a new excel reader.
reader = new ExcelDataReader(
fileName,
core,
study,
respondentVariable,
createResponsesFile,
idLanguage
);
break;
case DataUploadProvider.LDF:
reader = new LdfReader(
fileName,
core,
study,
createResponsesFile,
idLanguage
);
break;
}
reader.ApplicationPath = applicationPath;
reader.Language = language;
// Validate the file.
List <string> validationErrors = reader.Validate();
// Check if there are validation errors.
if (validationErrors.Count > 0)
{
LogError(applicationPath, idStudy, string.Join(
Environment.NewLine,
validationErrors
));
}
else
{
//try
{
// Start the import.
reader.Read();
Log("The import was successful.", LogType.Success);
study.Status = StudyStatus.None;
study.Save();
}
/*catch (Exception ex)
* {
* Log("An error occurred during the import.", LogType.Error);
*
* LogError(
* applicationPath,
* idStudy,
* ex.ToString()
* );
* }*/
}
string fileNameRunningImport = Path.Combine(
applicationPath,
"Fileadmin",
"RunningImports",
idStudy.ToString()
);
if (File.Exists(fileNameRunningImport))
{
File.Delete(fileNameRunningImport);
}
File.Delete(fileName);
}
public void Reallocate_PSPPCompressedFile_CopiesAllReordsAndVariables()
{
//after this test the new file is the same size as the original
int originalRecordCount;
int originalVariableCount;
using (FileStream fileStream = new FileStream(@"TestFiles/34mbfile.sav.gz", FileMode.Open,
FileAccess.Read, FileShare.Read, 2048 * 10, FileOptions.SequentialScan))
using (GZipStream deCompressStream = new GZipStream(fileStream, CompressionMode.Decompress, true))
using (MemoryStream memStream = new MemoryStream())
{
deCompressStream.CopyTo(memStream);
memStream.Position = 0;
SpssReader spssDataset = new SpssReader(memStream);
originalRecordCount = spssDataset.Records.Count();
originalVariableCount = spssDataset.Variables.Count();
var deallocator = new DataReallocator();
// code under test
var records = deallocator.ReAllocateRecords(spssDataset.Records);
var variables = spssDataset.Variables
.Where(x => x.Name == "qhidimpconcepteval" || x.Name == "qhidimpproduct1")
.ToList();
var datalist = new List <string>();
foreach (var record in records)
{
foreach (var variable in variables)
{
var data = record.GetValue(variable)?.ToString()?.Trim();
if (!string.IsNullOrEmpty(data))
{
datalist.Add(data);
}
}
}
using (FileStream outputFileStream = new FileStream(@"4mbfile-after-reallocation.sav", FileMode.Create, FileAccess.Write))
{
using (var writer = new SpssWriter(outputFileStream, spssDataset.Variables, new SpssOptions()))
{
foreach (var record in records)
{
var newRecord = writer.CreateRecord(record);
writer.WriteRecord(newRecord);
}
writer.EndFile();
}
}
}
var results = FileValidator.CheckSpssFile(@"4mbfile-after-reallocation.sav");
Assert.AreEqual(originalRecordCount, results.RecordCount);
Assert.AreEqual(originalVariableCount, results.VariableCount);
}
public void ReadSpss(string filename, char separator)
{
// Open file, can be read only and sequetial (for performance), or anything else
using (FileStream fileStream = new FileStream(filename, FileMode.Open, FileAccess.Read, FileShare.Read, 2048 * 10,
FileOptions.SequentialScan))
{
// Create the reader, this will read the file header
SpssReader spssDataset = new SpssReader(fileStream);
SaveFileDialog dlg = new SaveFileDialog
{
FileName = filename.Replace(".sav", string.Empty),
DefaultExt = ".csv",
Filter = "csv documents (.csv)|*.csv"
};
dlg.ShowDialog();
if (dlg.FileName != "")
{
using (System.IO.StreamWriter file = new System.IO.StreamWriter(dlg.FileName))
{
bool first = true;
foreach (var variable in spssDataset.Variables)
{
if (first)
{
file.Write("{0}", variable.Name);
first = false;
}
else
{
file.Write("{0}{1}", separator, variable.Name);
}
}
file.WriteLine(string.Empty);
// Iterate through all data rows in the file
foreach (var record in spssDataset.Records)
{
first = true;
foreach (var variable in spssDataset.Variables)
{
if (first)
{
file.Write(record.GetValue(variable));
first = false;
}
else
{
file.Write(string.Format("{0}{1}", separator, record.GetValue(variable)));
}
}
file.WriteLine(string.Empty);
}
}
}
else
{
return;
}
if (GenearaMetadatos.IsChecked == true)
{
SaveFileDialog dlg2 = new SaveFileDialog
{
DefaultExt = ".txt",
Filter = "text documents (.txt)|*.txt",
FileName = dlg.FileName.Replace(".csv", "_metadata.txt")
};
dlg2.ShowDialog();
if (dlg2.FileName != "")
{
using (System.IO.StreamWriter file = new System.IO.StreamWriter(dlg2.FileName))
{
// Iterate through all the varaibles
foreach (var variable in spssDataset.Variables)
{
// Display name and label
file.WriteLine("{0} - {1}", variable.Name, variable.Label);
// Display value-labels collection
foreach (KeyValuePair <double, string> label in variable.ValueLabels)
{
file.WriteLine("{0} - {1}", label.Key, label.Value);
}
file.WriteLine(string.Empty);
file.WriteLine(string.Empty);
}
}
}
}
MessageBox.Show("Finalizado exitosamente", "Finalizado exitosamente", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
static void Main(string[] args)
{
int SurveyID = 600612;
//string SurveyPeriod = "2014-09-30";//survey period
string AttendedOn = "2018-10-31";
//string year = getYear(SurveyPeriod);
string country = "Indonesia"; //survey country
DB_insertion_SariRotiHWAll iobj = new DB_insertion_SariRotiHWAll();
string questions = "id,weight,S9,S8,S2,B1,B2_1,B2_2,B2_3,B2_4,B2_5,B2_6,B2_7,B2_8,B2_9,B2_10,B2_11,B2_12,B2_13,B2_14,B2_15,B2_16,B2_17,B2_18,B2_19,B2_20,B2_21,B2_22,B2_23,B2_24,B4a,B5_1,B5_2,B5_3,B5_4,B5_5,B5_6,B5_7,B5_8,B5_9,B5_10,B5_11,B5_12,B5_13,B5_14,B5_15,B5_16,B5_17,B5_18,B5_19,B5_20,B5_21,B5_22,B5_23,B5_24,B5b_1,B5b_2,B5b_3,B5b_4,B5b_5,B5b_6,B5b_7,B10,B3,B8_1,B8_2,B8_3,B8_4,B8_5,B8_6,B8_7,B8_8,B8_9,B8_10,B8_11,B8_12,B8_13,B8_14,B8_15,B8_16,B8_17,B8_18,B8_19,B8_20,B8_21,B8_22,B8_23,B8_24,B7_1,B7_2,B7_3,B7_4,B7_5,B7_6,B7_7,B7_8,B7_9,B7_10,B7_11,B7_12,B7_13,B7_14,B7_15,B7_16,B7_17,B7_18,B7_19,B7_20,B7_21,B7_22,B7_23,B7_24,B6_1,B6_2,B6_3,B6_4,B6_5,B6_6,B6_7,B6_8,B6_9,B6_10,B6_11,B6_12,B6_13,B6_14,B6_15,B6_16,B6_17,B6_18,B6_19,B6_20,B6_21,B6_22,B6_23,B6_24,B38,B39,B40_1,B40_2,B40_3,B40_4,B41b_1,B41b_2,B41b_3,B41b_4,B42_1,B42_2,B43a_1,B43a_2,P1,P2_1,P2_2,P2_3,P2_4,P2_5,P2_6,P2_7,P2_8,P2_9,P2_10,P3,C4_1,C4_2,C4_3,C4_4,C4_5,C4_6,C4_7,C3_1,C3_2,C3_3,C3_4,C3_5,C3_6,C3_7,C2_1,C2_2,C2_3,C2_4,C2_5,C2_6,C2_7,C1_1,C1_2,C1_3,C1_4,C1_5,C1_6,C1_7,NETT_SR_User,NETT_Non_SR_User"; // dashboard variable value
//string questions = "NETT_SR_User,NETT_Non_SR_User";
string[] spss_variable_name = questions.Split(',');
SpssReader spssDataset;
using (FileStream fileStream = new FileStream(@"D:\spssparsing\SariRoriHW\All\SR_HW_ALL-final recoded and weighted-sep18 (S16=yes).sav", FileMode.Open, FileAccess.Read, FileShare.Read, 2048 * 10, FileOptions.SequentialScan))
{
spssDataset = new SpssReader(fileStream); // Create the reader, this will read the file header
foreach (string spss_v in spss_variable_name)
{
foreach (var variable in spssDataset.Variables) // Iterate through all the varaibles
{
if (variable.Name.Equals(spss_v))
{
foreach (KeyValuePair <double, string> label in variable.ValueLabels)
{
string VARIABLE_NAME = spss_v;
string VARIABLE_NAME_SUB_NAME = variable.Name;
string VARIABLE_ID = label.Key.ToString();
string VARIABLE_VALUE = label.Value;
string VARIABLE_NAME_QUESTION = variable.Label;
string BASE_VARIABLE_NAME = variable.Name;
//iobj.insert_Dashboard_variable_values(VARIABLE_NAME, VARIABLE_NAME_SUB_NAME, VARIABLE_ID, VARIABLE_VALUE, VARIABLE_NAME_QUESTION, SurveyID, country, BASE_VARIABLE_NAME, AttendedOn);
}
}
}
}
foreach (var record in spssDataset.Records)
{
string userID = null;
string u_id = null;
string variable_name;
decimal Weight = 0;
string Country = "-- Not Available --";
string Region = "-- Not Available --";
string AgeGroup = "-- Not Available --";
string SES = "-- Not Available --";
string BrTom = "-- Not Available --";
string BrSpontArnon = "-- Not Available --";
string BrSpontAroma = "-- Not Available --";
string BrSpontBima = "-- Not Available --";
string BrSpontBread_Talk = "-- Not Available --";
string BrSpontBread_Co = "-- Not Available --";
string BrSpontGarmelia = "-- Not Available --";
string BrSpontHolland_Bakery = "-- Not Available --";
string BrSpontLauw = "-- Not Available --";
string BrSpontLe_Gitt = "-- Not Available --";
string BrSpontMatahari = "-- Not Available --";
string BrSpontMaxim = "-- Not Available --";
string BrSpontMr_Bread = "-- Not Available --";
string BrSpontMy_Roti = "-- Not Available --";
string BrSpontParoti = "-- Not Available --";
string BrSpontPrime_Bread = "-- Not Available --";
string BrSpontRamona = "-- Not Available --";
string BrSpontRoti_Boy = "-- Not Available --";
string BrSpontRoti_O = "-- Not Available --";
string BrSpontSari_Roti = "-- Not Available --";
string BrSpontSay_Bread = "-- Not Available --";
string BrSpontSharon = "-- Not Available --";
string BrSpontSuzana = "-- Not Available --";
string BrSpontSwanish = "-- Not Available --";
string BrSpontVanessa = "-- Not Available --";
string AdTom = "-- Not Available --";
string AdSpontArnon = "-- Not Available --";
string AdSpontAroma = "-- Not Available --";
string AdSpontBima = "-- Not Available --";
string AdSpontAdead_Talk = "-- Not Available --";
string AdSpontAdead_Co = "-- Not Available --";
string AdSpontGarmelia = "-- Not Available --";
string AdSpontHolland_Bakery = "-- Not Available --";
string AdSpontLauw = "-- Not Available --";
string AdSpontLe_Gitt = "-- Not Available --";
string AdSpontMatahari = "-- Not Available --";
string AdSpontMaxim = "-- Not Available --";
string AdSpontMr_Adead = "-- Not Available --";
string AdSpontMy_Roti = "-- Not Available --";
string AdSpontParoti = "-- Not Available --";
string AdSpontPrime_Adead = "-- Not Available --";
string AdSpontRamona = "-- Not Available --";
string AdSpontRoti_Boy = "-- Not Available --";
string AdSpontRoti_O = "-- Not Available --";
string AdSpontSari_Roti = "-- Not Available --";
string AdSpontSay_Adead = "-- Not Available --";
string AdSpontSharon = "-- Not Available --";
string AdSpontSuzana = "-- Not Available --";
string AdSpontSwanish = "-- Not Available --";
string AdSpontVanessa = "-- Not Available --";
string B5b_1 = "-- Not Available --";
string B5b_2 = "-- Not Available --";
string B5b_3 = "-- Not Available --";
string B5b_4 = "-- Not Available --";
string B5b_5 = "-- Not Available --";
string B5b_6 = "-- Not Available --";
string B5b_7 = "-- Not Available --";
string Bumo = "-- Not Available --";
string Favourite_Brand = "-- Not Available --";
string ConL1W_Arnon = "-- Not Available --";
string ConL1W_Aroma = "-- Not Available --";
string ConL1W_Bima = "-- Not Available --";
string ConL1W_Adead_Talk = "-- Not Available --";
string ConL1W_Adead_Co = "-- Not Available --";
string ConL1W_Garmelia = "-- Not Available --";
string ConL1W_Holland_Bakery = "-- Not Available --";
string ConL1W_Lauw = "-- Not Available --";
string ConL1W_Le_Gitt = "-- Not Available --";
string ConL1W_Matahari = "-- Not Available --";
string ConL1W_Maxim = "-- Not Available --";
string ConL1W_Mr_Adead = "-- Not Available --";
string ConL1W_My_Roti = "-- Not Available --";
string ConL1W_Paroti = "-- Not Available --";
string ConL1W_Prime_Adead = "-- Not Available --";
string ConL1W_Ramona = "-- Not Available --";
string ConL1W_Roti_Boy = "-- Not Available --";
string ConL1W_Roti_O = "-- Not Available --";
string ConL1W_Sari_Roti = "-- Not Available --";
string ConL1W_Say_Adead = "-- Not Available --";
string ConL1W_Sharon = "-- Not Available --";
string ConL1W_Suzana = "-- Not Available --";
string ConL1W_Swanish = "-- Not Available --";
string ConL1W_Vanessa = "-- Not Available --";
string ConL1M_Arnon = "-- Not Available --";
string ConL1M_Aroma = "-- Not Available --";
string ConL1M_Bima = "-- Not Available --";
string ConL1M_Adead_Talk = "-- Not Available --";
string ConL1M_Adead_Co = "-- Not Available --";
string ConL1M_Garmelia = "-- Not Available --";
string ConL1M_Holland_Bakery = "-- Not Available --";
string ConL1M_Lauw = "-- Not Available --";
string ConL1M_Le_Gitt = "-- Not Available --";
string ConL1M_Matahari = "-- Not Available --";
string ConL1M_Maxim = "-- Not Available --";
string ConL1M_Mr_Adead = "-- Not Available --";
string ConL1M_My_Roti = "-- Not Available --";
string ConL1M_Paroti = "-- Not Available --";
string ConL1M_Prime_Adead = "-- Not Available --";
string ConL1M_Ramona = "-- Not Available --";
string ConL1M_Roti_Boy = "-- Not Available --";
string ConL1M_Roti_O = "-- Not Available --";
string ConL1M_Sari_Roti = "-- Not Available --";
string ConL1M_Say_Adead = "-- Not Available --";
string ConL1M_Sharon = "-- Not Available --";
string ConL1M_Suzana = "-- Not Available --";
string ConL1M_Swanish = "-- Not Available --";
string ConL1M_Vanessa = "-- Not Available --";
string ConL3M_Arnon = "-- Not Available --";
string ConL3M_Aroma = "-- Not Available --";
string ConL3M_Bima = "-- Not Available --";
string ConL3M_Adead_Talk = "-- Not Available --";
string ConL3M_Adead_Co = "-- Not Available --";
string ConL3M_Garmelia = "-- Not Available --";
string ConL3M_Holland_Bakery = "-- Not Available --";
string ConL3M_Lauw = "-- Not Available --";
string ConL3M_Le_Gitt = "-- Not Available --";
string ConL3M_Matahari = "-- Not Available --";
string ConL3M_Maxim = "-- Not Available --";
string ConL3M_Mr_Adead = "-- Not Available --";
string ConL3M_My_Roti = "-- Not Available --";
string ConL3M_Paroti = "-- Not Available --";
string ConL3M_Prime_Adead = "-- Not Available --";
string ConL3M_Ramona = "-- Not Available --";
string ConL3M_Roti_Boy = "-- Not Available --";
string ConL3M_Roti_O = "-- Not Available --";
string ConL3M_Sari_Roti = "-- Not Available --";
string ConL3M_Say_Adead = "-- Not Available --";
string ConL3M_Sharon = "-- Not Available --";
string ConL3M_Suzana = "-- Not Available --";
string ConL3M_Swanish = "-- Not Available --";
string ConL3M_Vanessa = "-- Not Available --";
string Slogan_Aware = "-- Not Available --";
string Slogan_Correct_brand = "-- Not Available --";
string B40_1 = "-- Not Available --";
string B40_2 = "-- Not Available --";
string B40_3 = "-- Not Available --";
string B40_4 = "-- Not Available --";
string B41b_1 = "-- Not Available --";
string B41b_2 = "-- Not Available --";
string B41b_3 = "-- Not Available --";
string B41b_4 = "-- Not Available --";
string B42_1 = "-- Not Available --";
string B42_2 = "-- Not Available --";
string B43a_1 = "-- Not Available --";
string B43a_2 = "-- Not Available --";
string P1 = "-- Not Available --";
string P2_1 = "-- Not Available --";
string P2_2 = "-- Not Available --";
string P2_3 = "-- Not Available --";
string P2_4 = "-- Not Available --";
string P2_5 = "-- Not Available --";
string P2_6 = "-- Not Available --";
string P2_7 = "-- Not Available --";
string P2_8 = "-- Not Available --";
string P2_9 = "-- Not Available --";
string P2_10 = "-- Not Available --";
string P3 = "-- Not Available --";
string ConsP1WSharon_Steamed_Cheese_Cake = "-- Not Available --";
string ConsP1WSharon_Dorayaki = "-- Not Available --";
string ConsP1WSharon_Japanese_Ring_Cake = "-- Not Available --";
string ConsP1WSharon_Soft_Waffle = "-- Not Available --";
string ConsP1WSari_roti_Lapis_Bamkuhen = "-- Not Available --";
string ConsP1WSari_roti_Dorayaki = "-- Not Available --";
string ConsP1WSari_roti_Cheese_Cake = "-- Not Available --";
string ConsP1MSharon_Steamed_Cheese_Cake = "-- Not Available --";
string ConsP1MSharon_Dorayaki = "-- Not Available --";
string ConsP1MSharon_Japanese_Ring_Cake = "-- Not Available --";
string ConsP1MSharon_Soft_Waffle = "-- Not Available --";
string ConsP1MSari_roti_Lapis_Bamkuhen = "-- Not Available --";
string ConsP1MSari_roti_Dorayaki = "-- Not Available --";
string ConsP1MSari_roti_Cheese_Cake = "-- Not Available --";
string ConsP3MSharon_Steamed_Cheese_Cake = "-- Not Available --";
string ConsP3MSharon_Dorayaki = "-- Not Available --";
string ConsP3MSharon_Japanese_Ring_Cake = "-- Not Available --";
string ConsP3MSharon_Soft_Waffle = "-- Not Available --";
string ConsP3MSari_roti_Lapis_Bamkuhen = "-- Not Available --";
string ConsP3MSari_roti_Dorayaki = "-- Not Available --";
string ConsP3MSari_roti_Cheese_Cake = "-- Not Available --";
string AidBrSharon_Steamed_Cheese_Cake = "-- Not Available --";
string AidBrSharon_Dorayaki = "-- Not Available --";
string AidBrSharon_Japanese_Ring_Cake = "-- Not Available --";
string AidBrSharon_Soft_Waffle = "-- Not Available --";
string AidBrSari_roti_Lapis_Bamkuhen = "-- Not Available --";
string AidBrSari_roti_Dorayaki = "-- Not Available --";
string AidBrSari_roti_Cheese_Cake = "-- Not Available --";
string NETT_SR_User = "******";
string NETT_Non_SR_User = "******";
foreach (var variable in spssDataset.Variables)
{
foreach (string spss_v in spss_variable_name)
{
if (variable.Name.Equals(spss_v))
{
variable_name = variable.Name;
switch (variable_name)
{
case "id":
{
u_id = Convert.ToString(record.GetValue(variable));
userID = find_UserId(SurveyID, AttendedOn, u_id);
break;
}
case "weight":
{
Weight = Convert.ToDecimal(record.GetValue(variable));
break;
}
case "S9": { SES = Convert.ToString(record.GetValue(variable)); break; }
case "S8": { Region = Convert.ToString(record.GetValue(variable)); break; }
case "S2": { AgeGroup = Convert.ToString(record.GetValue(variable)); break; }
case "B1": { BrTom = Convert.ToString(record.GetValue(variable)); break; }
case "B2_1": { BrSpontArnon = Convert.ToString(record.GetValue(variable)); break; }
case "B2_2": { BrSpontAroma = Convert.ToString(record.GetValue(variable)); break; }
case "B2_3": { BrSpontBima = Convert.ToString(record.GetValue(variable)); break; }
case "B2_4": { BrSpontBread_Talk = Convert.ToString(record.GetValue(variable)); break; }
case "B2_5": { BrSpontBread_Co = Convert.ToString(record.GetValue(variable)); break; }
case "B2_6": { BrSpontGarmelia = Convert.ToString(record.GetValue(variable)); break; }
case "B2_7": { BrSpontHolland_Bakery = Convert.ToString(record.GetValue(variable)); break; }
case "B2_8": { BrSpontLauw = Convert.ToString(record.GetValue(variable)); break; }
case "B2_9": { BrSpontLe_Gitt = Convert.ToString(record.GetValue(variable)); break; }
case "B2_10": { BrSpontMatahari = Convert.ToString(record.GetValue(variable)); break; }
case "B2_11": { BrSpontMaxim = Convert.ToString(record.GetValue(variable)); break; }
case "B2_12": { BrSpontMr_Bread = Convert.ToString(record.GetValue(variable)); break; }
case "B2_13": { BrSpontMy_Roti = Convert.ToString(record.GetValue(variable)); break; }
case "B2_14": { BrSpontParoti = Convert.ToString(record.GetValue(variable)); break; }
case "B2_15": { BrSpontPrime_Bread = Convert.ToString(record.GetValue(variable)); break; }
case "B2_16": { BrSpontRamona = Convert.ToString(record.GetValue(variable)); break; }
case "B2_17": { BrSpontRoti_Boy = Convert.ToString(record.GetValue(variable)); break; }
case "B2_18": { BrSpontRoti_O = Convert.ToString(record.GetValue(variable)); break; }
case "B2_19": { BrSpontSari_Roti = Convert.ToString(record.GetValue(variable)); break; }
case "B2_20": { BrSpontSay_Bread = Convert.ToString(record.GetValue(variable)); break; }
case "B2_21": { BrSpontSharon = Convert.ToString(record.GetValue(variable)); break; }
case "B2_22": { BrSpontSuzana = Convert.ToString(record.GetValue(variable)); break; }
case "B2_23": { BrSpontSwanish = Convert.ToString(record.GetValue(variable)); break; }
case "B2_24": { BrSpontVanessa = Convert.ToString(record.GetValue(variable)); break; }
case "B4a": { AdTom = Convert.ToString(record.GetValue(variable)); break; }
case "B5_1": { AdSpontArnon = Convert.ToString(record.GetValue(variable)); break; }
case "B5_2": { AdSpontAroma = Convert.ToString(record.GetValue(variable)); break; }
case "B5_3": { AdSpontBima = Convert.ToString(record.GetValue(variable)); break; }
case "B5_4": { AdSpontAdead_Talk = Convert.ToString(record.GetValue(variable)); break; }
case "B5_5": { AdSpontAdead_Co = Convert.ToString(record.GetValue(variable)); break; }
case "B5_6": { AdSpontGarmelia = Convert.ToString(record.GetValue(variable)); break; }
case "B5_7": { AdSpontHolland_Bakery = Convert.ToString(record.GetValue(variable)); break; }
case "B5_8": { AdSpontLauw = Convert.ToString(record.GetValue(variable)); break; }
case "B5_9": { AdSpontLe_Gitt = Convert.ToString(record.GetValue(variable)); break; }
case "B5_10": { AdSpontMatahari = Convert.ToString(record.GetValue(variable)); break; }
case "B5_11": { AdSpontMaxim = Convert.ToString(record.GetValue(variable)); break; }
case "B5_12": { AdSpontMr_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B5_13": { AdSpontMy_Roti = Convert.ToString(record.GetValue(variable)); break; }
case "B5_14": { AdSpontParoti = Convert.ToString(record.GetValue(variable)); break; }
case "B5_15": { AdSpontPrime_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B5_16": { AdSpontRamona = Convert.ToString(record.GetValue(variable)); break; }
case "B5_17": { AdSpontRoti_Boy = Convert.ToString(record.GetValue(variable)); break; }
case "B5_18": { AdSpontRoti_O = Convert.ToString(record.GetValue(variable)); break; }
case "B5_19": { AdSpontSari_Roti = Convert.ToString(record.GetValue(variable)); break; }
case "B5_20": { AdSpontSay_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B5_21": { AdSpontSharon = Convert.ToString(record.GetValue(variable)); break; }
case "B5_22": { AdSpontSuzana = Convert.ToString(record.GetValue(variable)); break; }
case "B5_23": { AdSpontSwanish = Convert.ToString(record.GetValue(variable)); break; }
case "B5_24": { AdSpontVanessa = Convert.ToString(record.GetValue(variable)); break; }
case "B5b_1": { B5b_1 = Convert.ToString(record.GetValue(variable)); break; }
case "B5b_2": { B5b_2 = Convert.ToString(record.GetValue(variable)); break; }
case "B5b_3": { B5b_3 = Convert.ToString(record.GetValue(variable)); break; }
case "B5b_4": { B5b_4 = Convert.ToString(record.GetValue(variable)); break; }
case "B5b_5": { B5b_5 = Convert.ToString(record.GetValue(variable)); break; }
case "B5b_6": { B5b_6 = Convert.ToString(record.GetValue(variable)); break; }
case "B5b_7": { B5b_7 = Convert.ToString(record.GetValue(variable)); break; }
case "B10": { Bumo = Convert.ToString(record.GetValue(variable)); break; }
case "B3": { Favourite_Brand = Convert.ToString(record.GetValue(variable)); break; }
case "B8_1": { ConL1W_Arnon = Convert.ToString(record.GetValue(variable)); break; }
case "B8_2": { ConL1W_Aroma = Convert.ToString(record.GetValue(variable)); break; }
case "B8_3": { ConL1W_Bima = Convert.ToString(record.GetValue(variable)); break; }
case "B8_4": { ConL1W_Adead_Talk = Convert.ToString(record.GetValue(variable)); break; }
case "B8_5": { ConL1W_Adead_Co = Convert.ToString(record.GetValue(variable)); break; }
case "B8_6": { ConL1W_Garmelia = Convert.ToString(record.GetValue(variable)); break; }
case "B8_7": { ConL1W_Holland_Bakery = Convert.ToString(record.GetValue(variable)); break; }
case "B8_8": { ConL1W_Lauw = Convert.ToString(record.GetValue(variable)); break; }
case "B8_9": { ConL1W_Le_Gitt = Convert.ToString(record.GetValue(variable)); break; }
case "B8_10": { ConL1W_Matahari = Convert.ToString(record.GetValue(variable)); break; }
case "B8_11": { ConL1W_Maxim = Convert.ToString(record.GetValue(variable)); break; }
case "B8_12": { ConL1W_Mr_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B8_13": { ConL1W_My_Roti = Convert.ToString(record.GetValue(variable)); break; }
case "B8_14": { ConL1W_Paroti = Convert.ToString(record.GetValue(variable)); break; }
case "B8_15": { ConL1W_Prime_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B8_16": { ConL1W_Ramona = Convert.ToString(record.GetValue(variable)); break; }
case "B8_17": { ConL1W_Roti_Boy = Convert.ToString(record.GetValue(variable)); break; }
case "B8_18": { ConL1W_Roti_O = Convert.ToString(record.GetValue(variable)); break; }
case "B8_19": { ConL1W_Sari_Roti = Convert.ToString(record.GetValue(variable)); break; }
case "B8_20": { ConL1W_Say_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B8_21": { ConL1W_Sharon = Convert.ToString(record.GetValue(variable)); break; }
case "B8_22": { ConL1W_Suzana = Convert.ToString(record.GetValue(variable)); break; }
case "B8_23": { ConL1W_Swanish = Convert.ToString(record.GetValue(variable)); break; }
case "B8_24": { ConL1W_Vanessa = Convert.ToString(record.GetValue(variable)); break; }
case "B7_1": { ConL1M_Arnon = Convert.ToString(record.GetValue(variable)); break; }
case "B7_2": { ConL1M_Aroma = Convert.ToString(record.GetValue(variable)); break; }
case "B7_3": { ConL1M_Bima = Convert.ToString(record.GetValue(variable)); break; }
case "B7_4": { ConL1M_Adead_Talk = Convert.ToString(record.GetValue(variable)); break; }
case "B7_5": { ConL1M_Adead_Co = Convert.ToString(record.GetValue(variable)); break; }
case "B7_6": { ConL1M_Garmelia = Convert.ToString(record.GetValue(variable)); break; }
case "B7_7": { ConL1M_Holland_Bakery = Convert.ToString(record.GetValue(variable)); break; }
case "B7_8": { ConL1M_Lauw = Convert.ToString(record.GetValue(variable)); break; }
case "B7_9": { ConL1M_Le_Gitt = Convert.ToString(record.GetValue(variable)); break; }
case "B7_10": { ConL1M_Matahari = Convert.ToString(record.GetValue(variable)); break; }
case "B7_11": { ConL1M_Maxim = Convert.ToString(record.GetValue(variable)); break; }
case "B7_12": { ConL1M_Mr_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B7_13": { ConL1M_My_Roti = Convert.ToString(record.GetValue(variable)); break; }
case "B7_14": { ConL1M_Paroti = Convert.ToString(record.GetValue(variable)); break; }
case "B7_15": { ConL1M_Prime_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B7_16": { ConL1M_Ramona = Convert.ToString(record.GetValue(variable)); break; }
case "B7_17": { ConL1M_Roti_Boy = Convert.ToString(record.GetValue(variable)); break; }
case "B7_18": { ConL1M_Roti_O = Convert.ToString(record.GetValue(variable)); break; }
case "B7_19": { ConL1M_Sari_Roti = Convert.ToString(record.GetValue(variable)); break; }
case "B7_20": { ConL1M_Say_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B7_21": { ConL1M_Sharon = Convert.ToString(record.GetValue(variable)); break; }
case "B7_22": { ConL1M_Suzana = Convert.ToString(record.GetValue(variable)); break; }
case "B7_23": { ConL1M_Swanish = Convert.ToString(record.GetValue(variable)); break; }
case "B7_24": { ConL1M_Vanessa = Convert.ToString(record.GetValue(variable)); break; }
case "B6_1": { ConL3M_Arnon = Convert.ToString(record.GetValue(variable)); break; }
case "B6_2": { ConL3M_Aroma = Convert.ToString(record.GetValue(variable)); break; }
case "B6_3": { ConL3M_Bima = Convert.ToString(record.GetValue(variable)); break; }
case "B6_4": { ConL3M_Adead_Talk = Convert.ToString(record.GetValue(variable)); break; }
case "B6_5": { ConL3M_Adead_Co = Convert.ToString(record.GetValue(variable)); break; }
case "B6_6": { ConL3M_Garmelia = Convert.ToString(record.GetValue(variable)); break; }
case "B6_7": { ConL3M_Holland_Bakery = Convert.ToString(record.GetValue(variable)); break; }
case "B6_8": { ConL3M_Lauw = Convert.ToString(record.GetValue(variable)); break; }
case "B6_9": { ConL3M_Le_Gitt = Convert.ToString(record.GetValue(variable)); break; }
case "B6_10": { ConL3M_Matahari = Convert.ToString(record.GetValue(variable)); break; }
case "B6_11": { ConL3M_Maxim = Convert.ToString(record.GetValue(variable)); break; }
case "B6_12": { ConL3M_Mr_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B6_13": { ConL3M_My_Roti = Convert.ToString(record.GetValue(variable)); break; }
case "B6_14": { ConL3M_Paroti = Convert.ToString(record.GetValue(variable)); break; }
case "B6_15": { ConL3M_Prime_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B6_16": { ConL3M_Ramona = Convert.ToString(record.GetValue(variable)); break; }
case "B6_17": { ConL3M_Roti_Boy = Convert.ToString(record.GetValue(variable)); break; }
case "B6_18": { ConL3M_Roti_O = Convert.ToString(record.GetValue(variable)); break; }
case "B6_19": { ConL3M_Sari_Roti = Convert.ToString(record.GetValue(variable)); break; }
case "B6_20": { ConL3M_Say_Adead = Convert.ToString(record.GetValue(variable)); break; }
case "B6_21": { ConL3M_Sharon = Convert.ToString(record.GetValue(variable)); break; }
case "B6_22": { ConL3M_Suzana = Convert.ToString(record.GetValue(variable)); break; }
case "B6_23": { ConL3M_Swanish = Convert.ToString(record.GetValue(variable)); break; }
case "B6_24": { ConL3M_Vanessa = Convert.ToString(record.GetValue(variable)); break; }
case "B38": { Slogan_Aware = Convert.ToString(record.GetValue(variable)); break; }
case "B39": { Slogan_Correct_brand = Convert.ToString(record.GetValue(variable)); break; }
case "B40_1": { B40_1 = Convert.ToString(record.GetValue(variable)); break; }
case "B40_2": { B40_2 = Convert.ToString(record.GetValue(variable)); break; }
case "B40_3": { B40_3 = Convert.ToString(record.GetValue(variable)); break; }
case "B40_4": { B40_4 = Convert.ToString(record.GetValue(variable)); break; }
case "B41b_1": { B41b_1 = Convert.ToString(record.GetValue(variable)); break; }
case "B41b_2": { B41b_2 = Convert.ToString(record.GetValue(variable)); break; }
case "B41b_3": { B41b_3 = Convert.ToString(record.GetValue(variable)); break; }
case "B41b_4": { B41b_4 = Convert.ToString(record.GetValue(variable)); break; }
case "B42_1": { B42_1 = Convert.ToString(record.GetValue(variable)); break; }
case "B42_2": { B42_2 = Convert.ToString(record.GetValue(variable)); break; }
case "B43a_1": { B43a_1 = Convert.ToString(record.GetValue(variable)); break; }
case "B43a_2": { B43a_2 = Convert.ToString(record.GetValue(variable)); break; }
case "P1": { P1 = Convert.ToString(record.GetValue(variable)); break; }
case "P2_1": { P2_1 = Convert.ToString(record.GetValue(variable)); break; }
case "P2_2": { P2_2 = Convert.ToString(record.GetValue(variable)); break; }
case "P2_3": { P2_3 = Convert.ToString(record.GetValue(variable)); break; }
case "P2_4": { P2_4 = Convert.ToString(record.GetValue(variable)); break; }
case "P2_5": { P2_5 = Convert.ToString(record.GetValue(variable)); break; }
case "P2_6": { P2_6 = Convert.ToString(record.GetValue(variable)); break; }
case "P2_7": { P2_7 = Convert.ToString(record.GetValue(variable)); break; }
case "P2_8": { P2_8 = Convert.ToString(record.GetValue(variable)); break; }
case "P2_9": { P2_9 = Convert.ToString(record.GetValue(variable)); break; }
case "P2_10": { P2_10 = Convert.ToString(record.GetValue(variable)); break; }
case "P3": { P3 = Convert.ToString(record.GetValue(variable)); break; }
case "C4_1": { ConsP1WSharon_Steamed_Cheese_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "C4_2": { ConsP1WSharon_Dorayaki = Convert.ToString(record.GetValue(variable)); break; }
case "C4_3": { ConsP1WSharon_Japanese_Ring_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "C4_4": { ConsP1WSharon_Soft_Waffle = Convert.ToString(record.GetValue(variable)); break; }
case "C4_5": { ConsP1WSari_roti_Lapis_Bamkuhen = Convert.ToString(record.GetValue(variable)); break; }
case "C4_6": { ConsP1WSari_roti_Dorayaki = Convert.ToString(record.GetValue(variable)); break; }
case "C4_7": { ConsP1WSari_roti_Cheese_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "C3_1": { ConsP1MSharon_Steamed_Cheese_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "C3_2": { ConsP1MSharon_Dorayaki = Convert.ToString(record.GetValue(variable)); break; }
case "C3_3": { ConsP1MSharon_Japanese_Ring_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "C3_4": { ConsP1MSharon_Soft_Waffle = Convert.ToString(record.GetValue(variable)); break; }
case "C3_5": { ConsP1MSari_roti_Lapis_Bamkuhen = Convert.ToString(record.GetValue(variable)); break; }
case "C3_6": { ConsP1MSari_roti_Dorayaki = Convert.ToString(record.GetValue(variable)); break; }
case "C3_7": { ConsP1MSari_roti_Cheese_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "C2_1": { ConsP3MSharon_Steamed_Cheese_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "C2_2": { ConsP3MSharon_Dorayaki = Convert.ToString(record.GetValue(variable)); break; }
case "C2_3": { ConsP3MSharon_Japanese_Ring_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "C2_4": { ConsP3MSharon_Soft_Waffle = Convert.ToString(record.GetValue(variable)); break; }
case "C2_5": { ConsP3MSari_roti_Lapis_Bamkuhen = Convert.ToString(record.GetValue(variable)); break; }
case "C2_6": { ConsP3MSari_roti_Dorayaki = Convert.ToString(record.GetValue(variable)); break; }
case "C2_7": { ConsP3MSari_roti_Cheese_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "C1_1": { AidBrSharon_Steamed_Cheese_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "C1_2": { AidBrSharon_Dorayaki = Convert.ToString(record.GetValue(variable)); break; }
case "C1_3": { AidBrSharon_Japanese_Ring_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "C1_4": { AidBrSharon_Soft_Waffle = Convert.ToString(record.GetValue(variable)); break; }
case "C1_5": { AidBrSari_roti_Lapis_Bamkuhen = Convert.ToString(record.GetValue(variable)); break; }
case "C1_6": { AidBrSari_roti_Dorayaki = Convert.ToString(record.GetValue(variable)); break; }
case "C1_7": { AidBrSari_roti_Cheese_Cake = Convert.ToString(record.GetValue(variable)); break; }
case "NETT_SR_User": { NETT_SR_User = Convert.ToString(record.GetValue(variable)); break; }
case "NETT_Non_SR_User": { NETT_Non_SR_User = Convert.ToString(record.GetValue(variable)); break; }
}
}
}
}
if (userID != null && Weight != 0)
{
iobj.insert_Dashboard_values(userID, SurveyID, AttendedOn, Weight, country, Region, AgeGroup, SES, BrTom, BrSpontArnon, BrSpontAroma, BrSpontBima, BrSpontBread_Talk, BrSpontBread_Co, BrSpontGarmelia, BrSpontHolland_Bakery, BrSpontLauw, BrSpontLe_Gitt, BrSpontMatahari, BrSpontMaxim, BrSpontMr_Bread, BrSpontMy_Roti, BrSpontParoti, BrSpontPrime_Bread, BrSpontRamona, BrSpontRoti_Boy, BrSpontRoti_O, BrSpontSari_Roti, BrSpontSay_Bread, BrSpontSharon, BrSpontSuzana, BrSpontSwanish, BrSpontVanessa, AdTom, AdSpontArnon, AdSpontAroma, AdSpontBima, AdSpontAdead_Talk, AdSpontAdead_Co, AdSpontGarmelia, AdSpontHolland_Bakery, AdSpontLauw, AdSpontLe_Gitt, AdSpontMatahari, AdSpontMaxim, AdSpontMr_Adead, AdSpontMy_Roti, AdSpontParoti, AdSpontPrime_Adead, AdSpontRamona, AdSpontRoti_Boy, AdSpontRoti_O, AdSpontSari_Roti, AdSpontSay_Adead, AdSpontSharon, AdSpontSuzana, AdSpontSwanish, AdSpontVanessa, B5b_1, B5b_2, B5b_3, B5b_4, B5b_5, B5b_6, B5b_7, Bumo, Favourite_Brand, ConL1W_Arnon, ConL1W_Aroma, ConL1W_Bima, ConL1W_Adead_Talk, ConL1W_Adead_Co, ConL1W_Garmelia, ConL1W_Holland_Bakery, ConL1W_Lauw, ConL1W_Le_Gitt, ConL1W_Matahari, ConL1W_Maxim, ConL1W_Mr_Adead, ConL1W_My_Roti, ConL1W_Paroti, ConL1W_Prime_Adead, ConL1W_Ramona, ConL1W_Roti_Boy, ConL1W_Roti_O, ConL1W_Sari_Roti, ConL1W_Say_Adead, ConL1W_Sharon, ConL1W_Suzana, ConL1W_Swanish, ConL1W_Vanessa, ConL1M_Arnon, ConL1M_Aroma, ConL1M_Bima, ConL1M_Adead_Talk, ConL1M_Adead_Co, ConL1M_Garmelia, ConL1M_Holland_Bakery, ConL1M_Lauw, ConL1M_Le_Gitt, ConL1M_Matahari, ConL1M_Maxim, ConL1M_Mr_Adead, ConL1M_My_Roti, ConL1M_Paroti, ConL1M_Prime_Adead, ConL1M_Ramona, ConL1M_Roti_Boy, ConL1M_Roti_O, ConL1M_Sari_Roti, ConL1M_Say_Adead, ConL1M_Sharon, ConL1M_Suzana, ConL1M_Swanish, ConL1M_Vanessa, ConL3M_Arnon, ConL3M_Aroma, ConL3M_Bima, ConL3M_Adead_Talk, ConL3M_Adead_Co, ConL3M_Garmelia, ConL3M_Holland_Bakery, ConL3M_Lauw, ConL3M_Le_Gitt, ConL3M_Matahari, ConL3M_Maxim, ConL3M_Mr_Adead, ConL3M_My_Roti, ConL3M_Paroti, ConL3M_Prime_Adead, ConL3M_Ramona, ConL3M_Roti_Boy, ConL3M_Roti_O, ConL3M_Sari_Roti, ConL3M_Say_Adead, ConL3M_Sharon, ConL3M_Suzana, ConL3M_Swanish, ConL3M_Vanessa, Slogan_Aware, Slogan_Correct_brand, B40_1, B40_2, B40_3, B40_4, B41b_1, B41b_2, B41b_3, B41b_4, B42_1, B42_2, B43a_1, B43a_2, P1, P2_1, P2_2, P2_3, P2_4, P2_5, P2_6, P2_7, P2_8, P2_9, P2_10, P3, ConsP1WSharon_Steamed_Cheese_Cake, ConsP1WSharon_Dorayaki, ConsP1WSharon_Japanese_Ring_Cake, ConsP1WSharon_Soft_Waffle, ConsP1WSari_roti_Lapis_Bamkuhen, ConsP1WSari_roti_Dorayaki, ConsP1WSari_roti_Cheese_Cake, ConsP1MSharon_Steamed_Cheese_Cake, ConsP1MSharon_Dorayaki, ConsP1MSharon_Japanese_Ring_Cake, ConsP1MSharon_Soft_Waffle, ConsP1MSari_roti_Lapis_Bamkuhen, ConsP1MSari_roti_Dorayaki, ConsP1MSari_roti_Cheese_Cake, ConsP3MSharon_Steamed_Cheese_Cake, ConsP3MSharon_Dorayaki, ConsP3MSharon_Japanese_Ring_Cake, ConsP3MSharon_Soft_Waffle, ConsP3MSari_roti_Lapis_Bamkuhen, ConsP3MSari_roti_Dorayaki, ConsP3MSari_roti_Cheese_Cake, AidBrSharon_Steamed_Cheese_Cake, AidBrSharon_Dorayaki, AidBrSharon_Japanese_Ring_Cake, AidBrSharon_Soft_Waffle, AidBrSari_roti_Lapis_Bamkuhen, AidBrSari_roti_Dorayaki, AidBrSari_roti_Cheese_Cake, NETT_SR_User, NETT_Non_SR_User);
}
}
}
}
static void Main(string[] args)
{
int SurveyID = 600593;
//string SurveyPeriod = "2014-09-30";//survey period
string AttendedOn = "2018-11-30";
//string year = getYear(SurveyPeriod);
string country = "Indonesia";//survey country
DB_insertion_wacok iobj = new DB_insertion_wacok();
//string questions = "id,weight,S9,S8,S2,S7,S10,S11,S12,CH1,CH2_1,CH2_2,CH2_3,CH2_4,CH2_5,CH2_6,CH2_7,CH2_8,CH2_9,CH2_10,CH2_11,CH2_12,CH2_13,CH2_14,CH2_15,CH2_16,CH2_99,CH4,CH8_1,CH8_2,CH8_3,CH8_4,CH8_5,CH8_6,CH8_7,CH8_8,CH8_9,CH8_10,CH8_11,CH8_12,CH8_13,CH8_14,CH8_15,CH8_16,CH8_99,CH13,CH3,CH10_1,CH10_2,CH10_3,CH10_4,CH10_5,CH10_6,CH10_7,CH10_8,CH10_9,CH10_10,CH10_11,CH10_12,CH10_13,CH10_14,CH10_15,CH10_16,CH10_99,CH9_1,CH9_2,CH9_3,CH9_4,CH9_5,CH9_6,CH9_7,CH9_8,CH9_9,CH9_10,CH9_11,CH9_12,CH9_13,CH9_14,CH9_15,CH9_16,CH9_99,CH11_1,CH11_2,CH11_3,CH11_4,CH11_5,CH11_6,CH11_7,CH11_8,CH11_9,CH11_10,CH11_11,CH11_12,CH11_13,CH11_14,CH11_15,CH11_16,CH11_99,CH12_1,CH12_2,CH12_3,CH12_4,CH12_5,CH12_6,CH12_7,CH12_8,CH12_9,CH12_10,CH12_11,CH12_12,CH12_13,CH12_14,CH12_15,CH12_16,CH12_99,CH15,CH16,CH17,CH18,CH19,CH20,CH21,CH22,CH23,S13_1,S13_2,S13_3,S13_4,S13_5,S13_6,S13_7,S13_8,S13_99,S14_1,S14_2,S14_3,S14_4,S14_5,S14_6,S14_7,S14_8,S14_99,CH25,CH26,CH29,CH30,CH6,CHAP39,CHAP40,CHNOV39,CHNOV40";// dashboard variable value
string questions = "CHNOV39,CHNOV40";// dashboard variable value
string[] spss_variable_name = questions.Split(',');
SpssReader spssDataset;
using (FileStream fileStream = new FileStream(@"D:\spssparsing\wacok\WacockChocolateSet2_Nov2018.sav", FileMode.Open, FileAccess.Read, FileShare.Read, 2048 * 10, FileOptions.SequentialScan))
{
spssDataset = new SpssReader(fileStream); // Create the reader, this will read the file header
foreach (string spss_v in spss_variable_name)
{
foreach (var variable in spssDataset.Variables) // Iterate through all the varaibles
{
if (variable.Name.Equals(spss_v))
{
foreach (KeyValuePair <double, string> label in variable.ValueLabels)
{
string VARIABLE_NAME = spss_v;
string VARIABLE_NAME_SUB_NAME = variable.Name;
string VARIABLE_ID = label.Key.ToString();
string VARIABLE_VALUE = label.Value;
string VARIABLE_NAME_QUESTION = variable.Label;
string BASE_VARIABLE_NAME = variable.Name;
iobj.insert_Dashboard_variable_values(VARIABLE_NAME, VARIABLE_NAME_SUB_NAME, VARIABLE_ID, VARIABLE_VALUE, VARIABLE_NAME_QUESTION, SurveyID, country, BASE_VARIABLE_NAME, AttendedOn);
}
}
}
}
foreach (var record in spssDataset.Records)
{
string userID = null;
string u_id = null;
string variable_name;
decimal Weight = 0;
string Country = "-- Not Available --";
string Education = "-- Not Available --";
string Location = "-- Not Available --";
string Gender = "-- Not Available --";
string MaritalStatus = "-- Not Available --";
string AgeGroup = "-- Not Available --";
string SES = "-- Not Available --";
string Occupation = "-- Not Available --";
string BrTom = "-- Not Available --";
string BrSpont_BengBeng = "-- Not Available --";
string BrSpont_Cadbury = "-- Not Available --";
string BrSpont_Chacha = "-- Not Available --";
string BrSpont_Cheweez = "-- Not Available --";
string BrSpont_ChicChoc = "-- Not Available --";
string BrSpont_Cloud9 = "-- Not Available --";
string BrSpont_ChokiChoki = "-- Not Available --";
string BrSpont_Dove = "-- Not Available --";
string BrSpont_Fullo = "-- Not Available --";
string BrSpont_GeryPasta = "-- Not Available --";
string BrSpont_KinderJoy = "-- Not Available --";
string BrSpont_KitKat = "-- Not Available --";
string BrSpont_Nockers = "-- Not Available --";
string BrSpont_Silverqueen = "-- Not Available --";
string BrSpont_Snickers = "-- Not Available --";
string BrSpont_Top = "-- Not Available --";
string BrSpont_OthersSpecify = "-- Not Available --";
string AdTom = "-- Not Available --";
string AdSpont_BengBeng = "-- Not Available --";
string AdSpont_Cadbury = "-- Not Available --";
string AdSpont_Chacha = "-- Not Available --";
string AdSpont_Cheweez = "-- Not Available --";
string AdSpont_ChicChoc = "-- Not Available --";
string AdSpont_Cloud9 = "-- Not Available --";
string AdSpont_ChokiChoki = "-- Not Available --";
string AdSpont_Dove = "-- Not Available --";
string AdSpont_Fullo = "-- Not Available --";
string AdSpont_GeryPasta = "-- Not Available --";
string AdSpont_KinderJoy = "-- Not Available --";
string AdSpont_KitKat = "-- Not Available --";
string AdSpont_Nockers = "-- Not Available --";
string AdSpont_Silverqueen = "-- Not Available --";
string AdSpont_Snickers = "-- Not Available --";
string AdSpont_Top = "-- Not Available --";
string AdSpont_OthersSpecify = "-- Not Available --";
string Bumo = "-- Not Available --";
string Favourite_Brand = "-- Not Available --";
string ConL1M_BengBeng = "-- Not Available --";
string ConL1M_Cadbury = "-- Not Available --";
string ConL1M_Chacha = "-- Not Available --";
string ConL1M_Cheweez = "-- Not Available --";
string ConL1M_ChicChoc = "-- Not Available --";
string ConL1M_Cloud9 = "-- Not Available --";
string ConL1M_ChokiChoki = "-- Not Available --";
string ConL1M_Dove = "-- Not Available --";
string ConL1M_Fullo = "-- Not Available --";
string ConL1M_GeryPasta = "-- Not Available --";
string ConL1M_KinderJoy = "-- Not Available --";
string ConL1M_KitKat = "-- Not Available --";
string ConL1M_Nockers = "-- Not Available --";
string ConL1M_Silverqueen = "-- Not Available --";
string ConL1M_Snickers = "-- Not Available --";
string ConL1M_Top = "-- Not Available --";
string ConL1M_OthersSpecify = "-- Not Available --";
string ConL3M_BengBeng = "-- Not Available --";
string ConL3M_Cadbury = "-- Not Available --";
string ConL3M_Chacha = "-- Not Available --";
string ConL3M_Cheweez = "-- Not Available --";
string ConL3M_ChicChoc = "-- Not Available --";
string ConL3M_Cloud9 = "-- Not Available --";
string ConL3M_ChokiChoki = "-- Not Available --";
string ConL3M_Dove = "-- Not Available --";
string ConL3M_Fullo = "-- Not Available --";
string ConL3M_GeryPasta = "-- Not Available --";
string ConL3M_KinderJoy = "-- Not Available --";
string ConL3M_KitKat = "-- Not Available --";
string ConL3M_Nockers = "-- Not Available --";
string ConL3M_Silverqueen = "-- Not Available --";
string ConL3M_Snickers = "-- Not Available --";
string ConL3M_Top = "-- Not Available --";
string ConL3M_OthersSpecify = "-- Not Available --";
string ConL1W_BengBeng = "-- Not Available --";
string ConL1W_Cadbury = "-- Not Available --";
string ConL1W_Chacha = "-- Not Available --";
string ConL1W_Cheweez = "-- Not Available --";
string ConL1W_ChicChoc = "-- Not Available --";
string ConL1W_Cloud9 = "-- Not Available --";
string ConL1W_ChokiChoki = "-- Not Available --";
string ConL1W_Dove = "-- Not Available --";
string ConL1W_Fullo = "-- Not Available --";
string ConL1W_GeryPasta = "-- Not Available --";
string ConL1W_KinderJoy = "-- Not Available --";
string ConL1W_KitKat = "-- Not Available --";
string ConL1W_Nockers = "-- Not Available --";
string ConL1W_Silverqueen = "-- Not Available --";
string ConL1W_Snickers = "-- Not Available --";
string ConL1W_Top = "-- Not Available --";
string ConL1W_OthersSpecify = "-- Not Available --";
string ConYestOrToday_BengBeng = "-- Not Available --";
string ConYestOrToday_Cadbury = "-- Not Available --";
string ConYestOrToday_Chacha = "-- Not Available --";
string ConYestOrToday_Cheweez = "-- Not Available --";
string ConYestOrToday_ChicChoc = "-- Not Available --";
string ConYestOrToday_Cloud9 = "-- Not Available --";
string ConYestOrToday_ChokiChoki = "-- Not Available --";
string ConYestOrToday_Dove = "-- Not Available --";
string ConYestOrToday_Fullo = "-- Not Available --";
string ConYestOrToday_GeryPasta = "-- Not Available --";
string ConYestOrToday_KinderJoy = "-- Not Available --";
string ConYestOrToday_KitKat = "-- Not Available --";
string ConYestOrToday_Nockers = "-- Not Available --";
string ConYestOrToday_Silverqueen = "-- Not Available --";
string ConYestOrToday_Snickers = "-- Not Available --";
string ConYestOrToday_Top = "-- Not Available --";
string ConYestOrToday_OthersSpecify = "-- Not Available --";
string CH15 = "-- Not Available --";
string CH16 = "-- Not Available --";
string CH17 = "-- Not Available --";
string CH18 = "-- Not Available --";
string CH19 = "-- Not Available --";
string CH20 = "-- Not Available --";
string CH21 = "-- Not Available --";
string CH22 = "-- Not Available --";
string CH23 = "-- Not Available --";
string S13_1 = "-- Not Available --";
string S13_2 = "-- Not Available --";
string S13_3 = "-- Not Available --";
string S13_4 = "-- Not Available --";
string S13_5 = "-- Not Available --";
string S13_6 = "-- Not Available --";
string S13_7 = "-- Not Available --";
string S13_8 = "-- Not Available --";
string S13_99 = "-- Not Available --";
string S14_1 = "-- Not Available --";
string S14_2 = "-- Not Available --";
string S14_3 = "-- Not Available --";
string S14_4 = "-- Not Available --";
string S14_5 = "-- Not Available --";
string S14_6 = "-- Not Available --";
string S14_7 = "-- Not Available --";
string S14_8 = "-- Not Available --";
string S14_99 = "-- Not Available --";
string CH25 = "-- Not Available --";
string CH26 = "-- Not Available --";
string CH29 = "-- Not Available --";
string CH30 = "-- Not Available --";
string CH6 = "-- Not Available --";
string CHAP39 = "-- Not Available --";
string CHAP40 = "-- Not Available --";
string CHNOV39 = "-- Not Available --";
string CHNOV40 = "-- Not Available --";
foreach (var variable in spssDataset.Variables)
{
foreach (string spss_v in spss_variable_name)
{
if (variable.Name.Equals(spss_v))
{
variable_name = variable.Name;
switch (variable_name)
{
case "id":
{
u_id = Convert.ToString(record.GetValue(variable));
userID = find_UserId(SurveyID, AttendedOn, u_id);
break;
}
case "weight":
{
Weight = Convert.ToDecimal(record.GetValue(variable));
break;
}
case "S10":
{
MaritalStatus = Convert.ToString(record.GetValue(variable));
break;
}
case "S11":
{
Occupation = Convert.ToString(record.GetValue(variable));
break;
}
case "S12":
{
Education = Convert.ToString(record.GetValue(variable));
break;
}
case "S9": {
SES = Convert.ToString(record.GetValue(variable));
break;
}
case "S8": {
Location = Convert.ToString(record.GetValue(variable));
break;
}
case "S2": {
AgeGroup = Convert.ToString(record.GetValue(variable));
break;
}
case "S7": {
Gender = Convert.ToString(record.GetValue(variable));
break;
}
case "CH1": {
BrTom = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_1": {
BrSpont_BengBeng = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_2": {
BrSpont_Cadbury = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_3": {
BrSpont_Chacha = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_4": {
BrSpont_Cheweez = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_5": {
BrSpont_ChicChoc = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_6": {
BrSpont_Cloud9 = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_7": {
BrSpont_ChokiChoki = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_8": {
BrSpont_Dove = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_9": {
BrSpont_Fullo = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_10": {
BrSpont_GeryPasta = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_11": {
BrSpont_KinderJoy = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_12": {
BrSpont_KitKat = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_13": {
BrSpont_Nockers = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_14": {
BrSpont_Silverqueen = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_15": {
BrSpont_Snickers = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_16": {
BrSpont_Top = Convert.ToString(record.GetValue(variable));
break;
}
case "CH2_99": {
BrSpont_OthersSpecify = Convert.ToString(record.GetValue(variable)); break;
}
case "CH4": {
AdTom = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_1": {
AdSpont_BengBeng = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_2": {
AdSpont_Cadbury = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_3": {
AdSpont_Chacha = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_4": {
AdSpont_Cheweez = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_5": {
AdSpont_ChicChoc = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_6": {
AdSpont_Cloud9 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_7": {
AdSpont_ChokiChoki = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_8": {
AdSpont_Dove = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_9": {
AdSpont_Fullo = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_10": {
AdSpont_GeryPasta = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_11": {
AdSpont_KinderJoy = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_12": {
AdSpont_KitKat = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_13": {
AdSpont_Nockers = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_14": {
AdSpont_Silverqueen = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_15": {
AdSpont_Snickers = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_16": {
AdSpont_Top = Convert.ToString(record.GetValue(variable)); break;
}
case "CH8_99": {
AdSpont_OthersSpecify = Convert.ToString(record.GetValue(variable)); break;
}
case "CH13": {
Bumo = Convert.ToString(record.GetValue(variable)); break;
}
case "CH3": {
Favourite_Brand = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_1": {
ConL1M_BengBeng = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_2": {
ConL1M_Cadbury = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_3": {
ConL1M_Chacha = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_4": {
ConL1M_Cheweez = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_5": {
ConL1M_ChicChoc = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_6": {
ConL1M_Cloud9 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_7": {
ConL1M_ChokiChoki = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_8": {
ConL1M_Dove = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_9": {
ConL1M_Fullo = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_10": {
ConL1M_GeryPasta = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_11": {
ConL1M_KinderJoy = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_12": {
ConL1M_KitKat = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_13": {
ConL1M_Nockers = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_14": {
ConL1M_Silverqueen = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_15": {
ConL1M_Snickers = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_16": {
ConL1M_Top = Convert.ToString(record.GetValue(variable)); break;
}
case "CH10_99": {
ConL1M_OthersSpecify = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_1": {
ConL3M_BengBeng = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_2": {
ConL3M_Cadbury = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_3": {
ConL3M_Chacha = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_4": {
ConL3M_Cheweez = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_5": {
ConL3M_ChicChoc = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_6": {
ConL3M_Cloud9 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_7": {
ConL3M_ChokiChoki = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_8": {
ConL3M_Dove = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_9": {
ConL3M_Fullo = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_10": {
ConL3M_GeryPasta = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_11": {
ConL3M_KinderJoy = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_12": {
ConL3M_KitKat = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_13": {
ConL3M_Nockers = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_14": {
ConL3M_Silverqueen = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_15": {
ConL3M_Snickers = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_16": {
ConL3M_Top = Convert.ToString(record.GetValue(variable)); break;
}
case "CH9_99": {
ConL3M_OthersSpecify = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_1": {
ConL1W_BengBeng = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_2": {
ConL1W_Cadbury = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_3": {
ConL1W_Chacha = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_4": {
ConL1W_Cheweez = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_5": {
ConL1W_ChicChoc = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_6": {
ConL1W_Cloud9 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_7": {
ConL1W_ChokiChoki = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_8": {
ConL1W_Dove = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_9": {
ConL1W_Fullo = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_10": {
ConL1W_GeryPasta = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_11": {
ConL1W_KinderJoy = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_12": {
ConL1W_KitKat = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_13": {
ConL1W_Nockers = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_14": {
ConL1W_Silverqueen = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_15": {
ConL1W_Snickers = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_16": {
ConL1W_Top = Convert.ToString(record.GetValue(variable)); break;
}
case "CH11_99": {
ConL1W_OthersSpecify = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_1": {
ConYestOrToday_BengBeng = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_2": {
ConYestOrToday_Cadbury = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_3": {
ConYestOrToday_Chacha = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_4": {
ConYestOrToday_Cheweez = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_5": {
ConYestOrToday_ChicChoc = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_6": {
ConYestOrToday_Cloud9 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_7": {
ConYestOrToday_ChokiChoki = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_8": {
ConYestOrToday_Dove = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_9": {
ConYestOrToday_Fullo = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_10": {
ConYestOrToday_GeryPasta = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_11": {
ConYestOrToday_KinderJoy = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_12": {
ConYestOrToday_KitKat = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_13": {
ConYestOrToday_Nockers = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_14": {
ConYestOrToday_Silverqueen = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_15": {
ConYestOrToday_Snickers = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_16": {
ConYestOrToday_Top = Convert.ToString(record.GetValue(variable)); break;
}
case "CH12_99": {
ConYestOrToday_OthersSpecify = Convert.ToString(record.GetValue(variable)); break;
}
case "CH15": {
CH15 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH16": {
CH16 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH17": {
CH17 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH18": {
CH18 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH19": {
CH19 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH20": {
CH20 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH21": {
CH21 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH22": {
CH22 = Convert.ToString(record.GetValue(variable)); break;
}
case "CH23": {
CH23 = Convert.ToString(record.GetValue(variable)); break;
}
case "S13_1": { S13_1 = Convert.ToString(record.GetValue(variable)); break; }
case "S13_2": { S13_2 = Convert.ToString(record.GetValue(variable)); break; }
case "S13_3": { S13_3 = Convert.ToString(record.GetValue(variable)); break; }
case "S13_4": { S13_4 = Convert.ToString(record.GetValue(variable)); break; }
case "S13_5": { S13_5 = Convert.ToString(record.GetValue(variable)); break; }
case "S13_6": { S13_6 = Convert.ToString(record.GetValue(variable)); break; }
case "S13_7": { S13_7 = Convert.ToString(record.GetValue(variable)); break; }
case "S13_8": { S13_8 = Convert.ToString(record.GetValue(variable)); break; }
case "S13_99": { S13_99 = Convert.ToString(record.GetValue(variable)); break; }
case "S14_1": { S14_1 = Convert.ToString(record.GetValue(variable)); break; }
case "S14_2": { S14_2 = Convert.ToString(record.GetValue(variable)); break; }
case "S14_3": { S14_3 = Convert.ToString(record.GetValue(variable)); break; }
case "S14_4": { S14_4 = Convert.ToString(record.GetValue(variable)); break; }
case "S14_5": { S14_5 = Convert.ToString(record.GetValue(variable)); break; }
case "S14_6": { S14_6 = Convert.ToString(record.GetValue(variable)); break; }
case "S14_7": { S14_7 = Convert.ToString(record.GetValue(variable)); break; }
case "S14_8": { S14_8 = Convert.ToString(record.GetValue(variable)); break; }
case "S14_99": { S14_99 = Convert.ToString(record.GetValue(variable)); break; }
case "CH25": { CH25 = Convert.ToString(record.GetValue(variable)); break; }
case "CH26": { CH26 = Convert.ToString(record.GetValue(variable)); break; }
case "CH29": { CH29 = Convert.ToString(record.GetValue(variable)); break; }
case "CH30": { CH30 = Convert.ToString(record.GetValue(variable)); break; }
case "CH6": { CH6 = Convert.ToString(record.GetValue(variable)); break; }
case "CHAP39": { CHAP39 = Convert.ToString(record.GetValue(variable)); break; }
case "CHAP40": { CHAP40 = Convert.ToString(record.GetValue(variable)); break; }
case "CHNOV39": { CHNOV39 = Convert.ToString(record.GetValue(variable)); break; }
case "CHNOV40": { CHNOV40 = Convert.ToString(record.GetValue(variable)); break; }
}
}
}
}
if (userID != null && Weight != 0)
{
//iobj.insert_Dashboard_values(userID, SurveyID, AttendedOn, Weight, country, Location, Gender, MaritalStatus, Occupation, Education, AgeGroup, SES, BrTom, BrSpont_BengBeng, BrSpont_Cadbury, BrSpont_Chacha, BrSpont_Cheweez, BrSpont_ChicChoc, BrSpont_Cloud9, BrSpont_ChokiChoki, BrSpont_Dove, BrSpont_Fullo, BrSpont_GeryPasta, BrSpont_KinderJoy, BrSpont_KitKat, BrSpont_Nockers, BrSpont_Silverqueen, BrSpont_Snickers, BrSpont_Top, BrSpont_OthersSpecify, AdTom, AdSpont_BengBeng, AdSpont_Cadbury, AdSpont_Chacha, AdSpont_Cheweez, AdSpont_ChicChoc, AdSpont_Cloud9, AdSpont_ChokiChoki, AdSpont_Dove, AdSpont_Fullo, AdSpont_GeryPasta, AdSpont_KinderJoy, AdSpont_KitKat, AdSpont_Nockers, AdSpont_Silverqueen, AdSpont_Snickers, AdSpont_Top, AdSpont_OthersSpecify, Bumo, Favourite_Brand, ConL1M_BengBeng, ConL1M_Cadbury, ConL1M_Chacha, ConL1M_Cheweez, ConL1M_ChicChoc, ConL1M_Cloud9, ConL1M_ChokiChoki, ConL1M_Dove, ConL1M_Fullo, ConL1M_GeryPasta, ConL1M_KinderJoy, ConL1M_KitKat, ConL1M_Nockers, ConL1M_Silverqueen, ConL1M_Snickers, ConL1M_Top, ConL1M_OthersSpecify, ConL3M_BengBeng, ConL3M_Cadbury, ConL3M_Chacha, ConL3M_Cheweez, ConL3M_ChicChoc, ConL3M_Cloud9, ConL3M_ChokiChoki, ConL3M_Dove, ConL3M_Fullo, ConL3M_GeryPasta, ConL3M_KinderJoy, ConL3M_KitKat, ConL3M_Nockers, ConL3M_Silverqueen, ConL3M_Snickers, ConL3M_Top, ConL3M_OthersSpecify, ConL1W_BengBeng, ConL1W_Cadbury, ConL1W_Chacha, ConL1W_Cheweez, ConL1W_ChicChoc, ConL1W_Cloud9, ConL1W_ChokiChoki, ConL1W_Dove, ConL1W_Fullo, ConL1W_GeryPasta, ConL1W_KinderJoy, ConL1W_KitKat, ConL1W_Nockers, ConL1W_Silverqueen, ConL1W_Snickers, ConL1W_Top, ConL1W_OthersSpecify, ConYestOrToday_BengBeng, ConYestOrToday_Cadbury, ConYestOrToday_Chacha, ConYestOrToday_Cheweez, ConYestOrToday_ChicChoc, ConYestOrToday_Cloud9, ConYestOrToday_ChokiChoki, ConYestOrToday_Dove, ConYestOrToday_Fullo, ConYestOrToday_GeryPasta, ConYestOrToday_KinderJoy, ConYestOrToday_KitKat, ConYestOrToday_Nockers, ConYestOrToday_Silverqueen, ConYestOrToday_Snickers, ConYestOrToday_Top, ConYestOrToday_OthersSpecify, CH15, CH16, CH17, CH18, CH19, CH20, CH21, CH22, CH23, S13_1, S13_2, S13_3, S13_4, S13_5, S13_6, S13_7, S13_8, S13_99, S14_1, S14_2, S14_3, S14_4, S14_5, S14_6, S14_7, S14_8, S14_99, CH25, CH26, CH29, CH30, CH6, CHAP39, CHAP40,CHNOV39,CHNOV40);
}
}
}
}
