private void LoadEntitiesAndLanguages() { lvEntities.Items.Clear(); cbbLcid.Items.Clear(); WorkAsync("Retrieving entities...", (bw, e) => { emdCache = new List<EntityMetadata>(); var response = (RetrieveAllEntitiesResponse)Service.Execute(new RetrieveAllEntitiesRequest()); foreach (var emd in response.EntityMetadata) { emdCache.Add(emd); } bw.ReportProgress(0, "Retrieving available languages"); var lcidRequest = new RetrieveProvisionedLanguagesRequest(); var lcidResponse = (RetrieveProvisionedLanguagesResponse)Service.Execute(lcidRequest); e.Result = lcidResponse.RetrieveProvisionedLanguages.Select( lcid => new LanguageCode { Lcid = lcid, Label = CultureInfo.GetCultureInfo(lcid).EnglishName }); }, e => { foreach (var emd in emdCache) { var displayName = emd.DisplayName != null && emd.DisplayName.UserLocalizedLabel != null ? emd.DisplayName.UserLocalizedLabel.Label : "N/A"; var name = emd.LogicalName; lvEntities.Items.Add(new ListViewItem { Text = displayName, SubItems = { name }, Tag = name }); } foreach (var lc in (IEnumerable<LanguageCode>)e.Result) { cbbLcid.Items.Add(lc); } if (cbbLcid.Items.Count > 0) { cbbLcid.SelectedIndex = 0; } SetWorkingState(false); }, e => SetWorkingMessage(e.UserState.ToString())); }
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); } }
public List<Language> RetrieveAvailableLanguages() { var lcidRequest = new RetrieveProvisionedLanguagesRequest(); var lcidResponse = (RetrieveProvisionedLanguagesResponse)service.Execute(lcidRequest); return lcidResponse.RetrieveProvisionedLanguages.Select(lcid => new Language(lcid)).ToList(); }