private static string LoadDataSourceExt(ServerDataSource dataSource, string sheetOrTablename)
{
//uaopendataset(typeoffile, directory,filename,uaperformance)
string dirPath = Path.GetDirectoryName(dataSource.FileNameWithPath);
string fileName = Path.GetFileName(dataSource.FileNameWithPath);
string fullpathfilename = Path.Combine(dirPath, fileName); //dirPath + "\\" + fileName;
string datasetname = dataSource.Name;
string filetype = dataSource.Extension.ToUpper();
string worksheetname = null;
bool replaceDataset = false;
bool csvHeader = true;
string loadMissingValue="FALSE";//21Apr2014
if (filetype.Equals("SAV"))
{
filetype = "SPSS";
//21Apr2014 Missing Values loading is optional.
string LoadMisVal = confService.AppSettings.Get("loadSavMissingValue");
// load default value if no value is set
if (LoadMisVal.Trim().Length == 0)
LoadMisVal = confService.DefaultSettings["loadSavMissingValue"];
loadMissingValue = LoadMisVal.ToLower().Equals("true") ? "TRUE" : "FALSE"; ///
}
if (sheetOrTablename!=null)// filetype.Equals("XLS") || filetype.Equals("XLSX"))
{
worksheetname = sheetOrTablename;// "Sheet1";
}
////UAloadDataset(fullpathfilename, filetype, worksheetName=NULL, replace_ds=FALSE, csvHeader=TRUE, datasetName )//Change this, if uadatapackage is changed
return string.Format("UAloadDataset(fullpathfilename='{0}', filetype='{1}', worksheetName='{2}',load.missing={4}, datasetName='{3}')", FormatFileName(fullpathfilename), filetype, worksheetname, datasetname, loadMissingValue);
//return string.Format("UAloadDataset(fullpathfilename='{0}', filetype='{1}', worksheetName='{2}', datasetName='{3}')", FormatFileName(fullpathfilename), filetype, worksheetname, datasetname);
}