private void BtnExportTranslationsClick(object sender, EventArgs e) { if (lvEntities.CheckedItems.Count > 0 || chkExportGlobalOptSet.Checked || chkExportSiteMap.Checked) { var entities = (from ListViewItem item in lvEntities.CheckedItems select ((EntityMetadata) item.Tag).LogicalName).ToList(); var sfd = new SaveFileDialog {Filter = "Excel workbook|*.xlsx", Title = "Select file destination"}; if (sfd.ShowDialog(this) == DialogResult.OK) { var settings = new ExportSettings { ExportAttributes = chkExportAttributes.Checked, ExportBooleans = chkExportBooleans.Checked, ExportEntities = chkExportEntity.Checked, ExportForms = chkExportForms.Checked, ExportFormFields = chkExportFormsFields.Checked, ExportFormSections = chkExportFormsSections.Checked, ExportFormTabs = chkExportFormsTabs.Checked, ExportGlobalOptionSet = chkExportGlobalOptSet.Checked, ExportOptionSet = chkExportPicklists.Checked, ExportViews = chkExportViews.Checked, ExportCustomizedRelationships = chkExportCustomizedRelationships.Checked, ExportSiteMap = chkExportSiteMap.Checked, FilePath = sfd.FileName, Entities = entities }; SetState(true); WorkAsync("Exporting Translations...", (bw, evt) => { var engine = new Engine(); engine.Export((ExportSettings)evt.Argument, Service, bw); }, evt => { SetState(false); if (evt.Error != null) { string errorMessage = CrmExceptionHelper.GetErrorMessage(evt.Error, true); MessageBox.Show(this, errorMessage, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }, evt=>SetWorkingMessage(evt.UserState.ToString()), settings); } } }
public void Export(ExportSettings settings, IOrganizationService service, BackgroundWorker worker = null) { // Loading available languages if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Loading provisioned languages..."); } var lcidRequest = new RetrieveProvisionedLanguagesRequest(); var lcidResponse = (RetrieveProvisionedLanguagesResponse)service.Execute(lcidRequest); var lcids = lcidResponse.RetrieveProvisionedLanguages.Select(lcid => lcid).ToList(); // Loading entities var emds = new List<EntityMetadata>(); if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Loading selected entities..."); } foreach (string entityLogicalName in settings.Entities) { var filters = EntityFilters.Default; if (settings.ExportEntities) { filters = filters | EntityFilters.Entity; } if (settings.ExportCustomizedRelationships) { filters = filters | EntityFilters.Relationships; } if (settings.ExportAttributes) { filters = filters | EntityFilters.Attributes; } var request = new RetrieveEntityRequest { LogicalName = entityLogicalName, EntityFilters = filters }; var response = (RetrieveEntityResponse)service.Execute(request); emds.Add(response.EntityMetadata); } var file = new ExcelPackage(); file.File = new FileInfo(settings.FilePath); if (settings.ExportEntities && emds.Count > 0) { if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Exporting entities translations..."); } var sheet = file.Workbook.Worksheets.Add("Entities"); var et = new EntityTranslation(); et.Export(emds, lcids, sheet); StyleMutator.FontDefaults(sheet); } if (settings.ExportAttributes && emds.Count > 0) { if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Exporting attributes translations..."); } var sheet = file.Workbook.Worksheets.Add("Attributes"); var at = new AttributeTranslation(); at.Export(emds, lcids, sheet); StyleMutator.FontDefaults(sheet); } if (settings.ExportCustomizedRelationships && emds.Count > 0) { if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Exporting relationships with custom labels translations..."); } var sheet = file.Workbook.Worksheets.Add("Relationships"); var rt = new RelationshipTranslation(); rt.Export(emds, lcids, sheet); StyleMutator.FontDefaults(sheet); var sheetNn = file.Workbook.Worksheets.Add("RelationshipsNN"); var rtNn = new RelationshipNnTranslation(); rtNn.Export(emds, lcids, sheetNn); StyleMutator.FontDefaults(sheetNn); } if (settings.ExportGlobalOptionSet) { if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Exporting global optionsets translations..."); } var sheet = file.Workbook.Worksheets.Add("Global OptionSets"); var ot = new GlobalOptionSetTranslation(); ot.Export(lcids, sheet, service); StyleMutator.FontDefaults(sheet); } if (settings.ExportOptionSet && emds.Count > 0) { if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Exporting optionset translations..."); } var sheet = file.Workbook.Worksheets.Add("OptionSets"); var ot = new OptionSetTranslation(); ot.Export(emds, lcids, sheet); StyleMutator.FontDefaults(sheet); } if (settings.ExportBooleans && emds.Count > 0) { if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Exporting booleans translations..."); } var sheet = file.Workbook.Worksheets.Add("Booleans"); var bt = new BooleanTranslation(); bt.Export(emds, lcids, sheet); StyleMutator.FontDefaults(sheet); } if (settings.ExportViews && emds.Count > 0) { if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Exporting views translations..."); } var sheet = file.Workbook.Worksheets.Add("Views"); var vt = new ViewTranslation(); vt.Export(emds, lcids, sheet, service); StyleMutator.FontDefaults(sheet); } if ((settings.ExportForms || settings.ExportFormTabs || settings.ExportFormSections || settings.ExportFormFields) && emds.Count > 0) { if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Exporting forms translations..."); } var ft = new FormTranslation(); ft.Export(emds, lcids, file.Workbook, service, new FormExportOption { ExportForms = settings.ExportForms, ExportFormTabs = settings.ExportFormTabs, ExportFormSections = settings.ExportFormSections, ExportFormFields = settings.ExportFormFields }); } if (settings.ExportSiteMap) { if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Exporting SiteMap custom labels translations..."); } var st = new SiteMapTranslation(); st.Export(lcids, file.Workbook, service); } if (settings.ExportDashboards) { if (worker != null && worker.WorkerReportsProgress) { worker.ReportProgress(0, "Exporting Dashboards custom labels translations..."); } var st = new DashboardTranslation(); st.Export(lcids, file.Workbook, service); } file.Save(); if (DialogResult.Yes == MessageBox.Show("Do you want to open generated document?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { Process.Start(settings.FilePath); } }