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 => { } }); }