public static ExportEngine GetMasterSettings()
{
var masterSettings = new ImportSettings
{
ConnectionString = Constants.MasterConnectionString,
Extend = Constants.BaseEntity,
IgnoredColumns = (Constants.GetIgnoreColumnList()),
NameSpace = Constants.MasterNamespaceLocation,
OutputDirectory = Constants.MasterEntityOutputDirectory,
EntityTemplateLocation = Constants.MasterEntityTemplateName,
SchemaToImport = new List <string>()
{
"access"
},
TablesToImport = new List <string>()
{
"OrganizationAccessView",
"insights",
"FilterOperands",
"FilterEntityColumns"
}
};
ExportEngine engine = new ExportEngine(masterSettings);
engine.ApplyDefaultImportSettings();
engine._importSettings.ImportAllTables = false;
engine._importSettings.ImportAllSchema = false;
return(engine);
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (this.dataGridViewTask.CurrentRow != null)
{
ExportEngine engine = new ExportEngine(QlikViewConnectorProxy.Instance);
engine.Logger = new QVConfigLog();
this.lblRunning.Text = "It is Running.....";
IError error = engine.RunTask(this.dataGridViewTask.CurrentRow.DataBoundItem as ReportTask, ReportConfig.SmtpServerManager.SmtpServer);
if (error.HasError)
{
this.lblRunning.Text = "Run Test failed.";
}
else
{
this.lblRunning.Text = "Run Test Succeed.";
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.StackTrace);
}
}
public virtual void Export(object selectedObject)
{
var exportEngine = new ExportEngine();
var document = exportEngine.Export(View.SelectedObjects.OfType <XPBaseObject>(), ObjectSpace.GetObject((ISerializationConfigurationGroup)selectedObject));
Save(document);
}
void SelectExportConfiguration(object sender, SimpleActionExecuteEventArgs simpleActionExecuteEventArgs)
{
XDocument xDocument = new ExportEngine().Export(View.SelectedObjects.OfType <XPBaseObject>());
var serializationConfiguration = SerializationConfigurationQuery.Find(ObjectSpace.Session, View.ObjectTypeInfo.Type);
xDocument.Save(serializationConfiguration.TypeToSerialize.Name + ".xml");
}
protected void RunTask(IReportItem reportItem)
{
if (this.TaskRunning != null)
{
this.TaskRunning(this, new EventArgs());
}
IError error = null;
ReportTask task = null;
try
{
task = reportItem as ReportTask;
ExportEngine engine = new ExportEngine(QlikViewConnectorProxy.Instance);
engine.Logger = new QVConfigLog();
error = engine.RunTask(task, ReportConfig.SmtpServerManager.SmtpServer);
}
catch (Exception ex)
{
if (error == null)
{
error = new QvError();
}
error.ErrorMessage.Append(ex.StackTrace);
error.HasError = true;
}
this.DeleteAllExportedFiles(task);
if (this.TaskRunCompleted != null)
{
this.TaskRunCompleted(error);
}
}
internal static void ExportView(string viewName, string path, IExportSettings options)
{
ExportEngine ee = new ExportEngine();
ee.ExportView(viewName, path, options);
ee.Close(); // does nothing, not needed
}
void exportWorker_DoWork(object sender, DoWorkEventArgs e)
{
var settings = (ImportFileSettings)((object[])e.Argument)[0];
var filePath = ((object[])e.Argument)[1].ToString();
var ee = new ExportEngine(filePath, service, settings);
ee.RaiseError += ee_RaiseError;
ee.Export();
}
protected MemoryStream Save(XDocument document)
{
var memoryStream = new MemoryStream();
using (var textWriter = XmlWriter.Create(memoryStream, ExportEngine.GetXMLWriterSettings(document.IsMinified()))) {
document.Save(textWriter);
textWriter.Close();
}
return(memoryStream);
}
static XDocument ExportRecords(XPObjectSpace XPObjectSpace)
{
ISerializationConfiguration serializationConfiguration = XPObjectSpace.CreateObject <SerializationConfiguration>();
serializationConfiguration.TypeToSerialize = typeof(PEnumClass);
serializationConfiguration.SerializationConfigurationGroup =
XPObjectSpace.CreateObject <SerializationConfigurationGroup>();
new ClassInfoGraphNodeBuilder().Generate(serializationConfiguration);
XDocument document = new ExportEngine().Export(new[] { _pEnumClass }, serializationConfiguration.SerializationConfigurationGroup);
return(document);
}
internal static void ExportCategory(string name, IEnumerable <ICursorFilter> filters, string path, IExportSettings options)
{
ExportEngine ee = new ExportEngine();
if (filters == null)
{
ee.ExportCategory(name, path, options);
}
else
{
ee.ExportCategory(name, filters, path, options);
}
ee.Close(); // does nothing, not needed
}
public virtual void Export(ISerializationConfigurationGroup selectedObject)
{
var exportEngine = new ExportEngine(selectedObject.XPObjectSpace());
var document = exportEngine.Export(View.SelectedObjects.OfType <XPBaseObject>(), selectedObject);
using (var memoryStream = Save(document)){
if (selectedObject.ZipOutput)
{
Zip(memoryStream);
}
else
{
Save(memoryStream);
}
}
}
public void Run(string task)
{
ReportItemDictionary <ReportTask> tasks = ReportConfig.ReportTaskManager.ItemCollection;
ExportEngine engine = new ExportEngine(new QlikViewConnector());
engine.Logger = this.Logger;
ReportTask taskItem = tasks.Values.FirstOrDefault(x => x.Name.ToString() == task);
if (taskItem != null)
{
Console.WriteLine("Running task first time: " + taskItem.Name + ".......");
engine.Logger.Message("Running task first time: " + taskItem.Name + ".......");
IError error = engine.RunTask(taskItem, ReportConfig.SmtpServerManager.SmtpServer);
if (error.HasError == false)
{
Console.WriteLine("Running task fisrt time" + taskItem.Name + " complete.......");
engine.Logger.Message("Running task fisrt time" + taskItem.Name + " complete.......");
}
else
{
Console.WriteLine("Running task fisrt time " + taskItem.Name + " failed.......");
engine.Logger.Error("Running task fisrt time " + taskItem.Name + " failed....... \n" + error.ErrorMessage.ToString());
//MailHelper.ExceptionNotify("Running task fisrt time " + taskItem.Name + " failed", error.ErrorMessage.ToString(), ReportConfig.Instance.SmtpServer);
Console.WriteLine("Running task second time: " + taskItem.Name + ".......");
engine.Logger.Message("Running task second time: " + taskItem.Name + ".......");
error = engine.RunTask(taskItem, ReportConfig.SmtpServerManager.SmtpServer);
if (error.HasError)
{
MailHelper.ExceptionNotify("Running task second time " + taskItem.Name + " failed", error.ErrorMessage.ToString(), ReportConfig.SmtpServerManager.SmtpServer);
}
}
}
else
{
engine.Logger.Error(string.Format("There is no task {0}. ", task));
}
this.Close();
}
private void btnReportRunTest_Click(object sender, EventArgs e)
{
if (this.dataGridViewReport.CurrentRow != null)
{
ExportEngine engine = new ExportEngine(QlikViewConnectorProxy.Instance);
engine.Logger = new QVConfigLog();
this.lblRunning.Text = "It is Running.....";
bool succeed = engine.RunReport(this.dataGridViewReport.CurrentRow.DataBoundItem as QlikViewReport, ReportConfig.SmtpServerManager.SmtpServer);
if (succeed)
{
this.lblReportRunTestMsg.Text = "Run Test Succeed.";
}
else
{
this.lblReportRunTestMsg.Text = "Run Test failed.";
}
}
}
/// <summary>
/// generate data xml
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnGenerateData_Click(object sender, EventArgs e)
{
if (CheckUserInput() == false)
{
return;
}
ExportEngine engine = new ExportEngine();
Dictionary <string, string> paramList = new Dictionary <string, string>();
paramList["OrderId"] = txtOrderId.Text.Trim();
string dataXml = engine.GenerateData(txtTemplate.Text.Trim(), paramList);
string dataPath = "temp/data.xml";
SaveFile(dataXml, dataPath);
MessageBox.Show("Generate data success, path: " + dataPath);
}
protected void ExportReport(IReportItem reportItem)
{
if (this.ExportReportRunning != null)
{
this.ExportReportRunning(this, new EventArgs());
}
IError error = new QvError();
QlikViewReport report = null;
try
{
report = reportItem as QlikViewReport;
ExportEngine engine = new ExportEngine(QlikViewConnectorProxy.Instance);
engine.Logger = new QVConfigLog();
bool succeed = engine.RunReport(report, ReportConfig.SmtpServerManager.SmtpServer);
if (succeed)
{
error.HasError = false;
}
else
{
error.ErrorMessage.Append(string.Format("Export Report {0} failed.", report.Name));
error.HasError = true;
}
}
catch (Exception ex)
{
if (error == null)
{
error = new QvError();
}
error.ErrorMessage.Append(ex.StackTrace);
error.HasError = true;
}
if (this.ExportReportCompleted != null)
{
this.ExportReportCompleted(error);
}
}
/// <summary>
/// Export
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExport_Click(object sender, EventArgs e)
{
if (CheckUserInput() == false)
{
return;
}
ExportEngine engine = new ExportEngine();
Dictionary <string, string> paramList = new Dictionary <string, string>();
paramList["OrderId"] = txtOrderId.Text.Trim();
ExportResult result = engine.Export(txtTemplate.Text.Trim(), paramList);
string folder = "Temp";
string ext = Path.GetExtension(result.FileDisplayName);
string filePath = GenerateFilePath(folder, ext);
SaveFile(result.FileContent, filePath);
txtExportFileName.Text = result.FileDisplayName;
txtExportFilePath.Text = filePath;
}
private void tsbExport_Click(object sender, EventArgs e)
{
var sfd = new SaveFileDialog {
Title = "Select where to save the file", Filter = "Csv file|*.csv"
};
if (sfd.ShowDialog(ParentForm) != DialogResult.OK)
{
return;
}
listLog.Items.Clear();
var settings = new ImportFileSettings
{
FirstEntity = ((EntityInfo)cbbFirstEntity.SelectedItem).Metadata.LogicalName,
FirstAttributeIsGuid = rdbFirstGuid.Checked,
FirstAttributeName = ((AttributeInfo)cbbFirstEntityAttribute.SelectedItem).Metadata.LogicalName,
Relationship = ((RelationshipInfo)cbbRelationship.SelectedItem).Metadata.IntersectEntityName,
SecondEntity = ((EntityInfo)cbbSecondEntity.SelectedItem).Metadata.LogicalName,
SecondAttributeIsGuid = rdbSecondGuid.Checked,
SecondAttributeName = ((AttributeInfo)cbbSecondEntityAttribute.SelectedItem).Metadata.LogicalName,
};
WorkAsync(new WorkAsyncInfo
{
Message = "Exporting many to many relationship records...",
AsyncArgument = new object[] { settings, sfd.FileName },
Work = (bw, evt) =>
{
var innerSettings = (ImportFileSettings)((object[])evt.Argument)[0];
var filePath = ((object[])evt.Argument)[1].ToString();
var ee = new ExportEngine(filePath, this.Service, innerSettings);
ee.RaiseError += ee_RaiseError;
ee.Export();
},
PostWorkCallBack = evt => { }
});
}
