/// <summary> /// Export a list /// </summary> /// <returns></returns> static string ExportList() { CidList list; UserObject iListName = SelectListDialog("Database List to Export"); if (iListName == null) { return(""); } string initialName = iListName.Name + ".lst"; string fileName = UIMisc.GetSaveAsFilename("List File to Export Into", initialName, "Lists (*.lst)|*.lst|All files (*.*)|*.*", "LST"); if (fileName == "") { return(""); } Progress.Show("Exporting List..."); list = Read(iListName); // read database list if (list == null) { return("Error reading list from database"); } list.WriteToFile(fileName, SS.I.RemoveLeadingZerosFromCids); // write file list Progress.Hide(); return(list.Count.ToString() + " " + MetaTable.KeyMetaTable.KeyMetaColumn.Label + "s have been exported"); }
/// <summary> /// Export to csv or text file /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ExportTextFileMenuItem_Click(object sender, EventArgs e) { CsvExportOptions ceo; // Can specify separator TextExportMode tem; // Value or Text PdfExportOptions peo; if (Lex.IsNullOrEmpty(TextFileName)) { TextFileName = ClientDirs.DefaultMobiusUserDocumentsFolder; } string filter = "CSV (Comma delimited)(*.csv)|*.csv|" + "Text (Tab delimited)(*.txt)|*.txt"; string fileName = UIMisc.GetSaveAsFilename("CSV / Text File Name", TextFileName, filter, ".csv"); if (Lex.IsNullOrEmpty(fileName)) { return; } TextFileName = fileName; if (Lex.EndsWith(fileName, ".csv")) { PivotGridPanel.PivotGrid.ExportToCsv(TextFileName); } else { PivotGridPanel.PivotGrid.ExportToText(TextFileName); } return; }
private void Browse_Click(object sender, System.EventArgs e) { string fileName = FileName.Text; if (Lex.IsNullOrEmpty(fileName)) { fileName = ClientDirs.DefaultMobiusUserDocumentsFolder; } string filter = "SDfile (*.sdf)|*.sdf"; fileName = UIMisc.GetSaveAsFilename("SDfile Name", fileName, filter, ".sdf"); if (fileName == "") { return; } FileName.Text = fileName; }
/// <summary> /// Browse regular file system name /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Browse_Click(object sender, System.EventArgs e) { string fileName; string initialFile = FileName.Text; if (Lex.IsNullOrEmpty(initialFile)) { initialFile = ClientDirs.DefaultMobiusUserDocumentsFolder; } string filter = GetFileFilter(); fileName = UIMisc.GetSaveAsFilename("Excel File Name", initialFile, filter, ".xlsx"); if (fileName != "") { FileName.Text = fileName; } return; }
/// <summary> /// Export to Excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ExportExcelMenuItem_Click(object sender, EventArgs e) { XlsxExportOptions xeo; if (Lex.IsNullOrEmpty(TextFileName)) { XlsFileName = ClientDirs.DefaultMobiusUserDocumentsFolder; } string filter = "Excel Workbook (*.xlsx)|*.xlsx|" + "Excel 97-2003 Workbook (*.xls)|*.xls"; string fileName = UIMisc.GetSaveAsFilename("Excel File Name", XlsFileName, filter, ".xlsx"); if (Lex.IsNullOrEmpty(fileName)) { return; } XlsFileName = fileName; if (Lex.EndsWith(fileName, ".xls")) { PivotGridPanel.PivotGrid.ExportToXls(XlsFileName); } else { PivotGridPanel.PivotGrid.ExportToXlsx(XlsFileName); } string msg = "Export to Excel complete.\n" + "Do you want to open " + fileName; DialogResult dr = MessageBoxMx.Show(msg, UmlautMobius.String, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { SystemUtil.StartProcess(fileName); } return; }
private void Browse_Click(object sender, System.EventArgs e) { string fileName; string initialFile = FileName.Text; if (Lex.IsNullOrEmpty(initialFile) || Lex.Eq(initialFile, ClientDirs.DefaultMobiusUserDocumentsFolder)) { initialFile = ClientDirs.DefaultMobiusUserDocumentsFolder; initialFile += @"\" + Rf.Query.UserObject.Name; } string defaultExt = ".stdf"; string filter = GetFileFilter(); fileName = UIMisc.GetSaveAsFilename("Export Data", initialFile, filter, defaultExt); if (fileName != "") { FileName.Text = fileName; } return; }
/// <summary> /// Retrieve the results of a background export /// Example: Retrieve Background Export 231243 /// </summary> /// <param name="objectIdString">Id of BackgroundExport UserObject containing serialized ResultsFormat</param> /// <returns></returns> public static string RetrieveBackgroundExport( string objectIdString) { ResultsFormat rf; Query q; int objId; QbUtil.SetMode(QueryMode.Build); // be sure in build mode if (!int.TryParse(objectIdString, out objId)) { return("Invalid UserObjectId: " + objectIdString); } UserObject uo = UserObjectDao.Read(objId); if (uo == null) { return("RunInBackground UserObject not found: " + objectIdString); } if (uo.Type != UserObjectType.BackgroundExport) { return("Object is not the expected RunInBackground UserObject type"); } rf = ResultsFormat.Deserialize(uo.Content); if (rf == null) { throw new Exception("Failed to deserialize ResultsFormat: " + objectIdString); } string clientFile = rf.OutputFileName; string serverFile = GetServerFileName(rf, objId); string ext = Path.GetExtension(clientFile); string filter = "*" + ext + "|*" + ext; if (SharePointUtil.IsRegularFileSystemName(clientFile)) { clientFile = UIMisc.GetSaveAsFilename("Retrieve Background Export File", clientFile, filter, ext); } else { clientFile = SharePointFileDialog.GetSaveAsFilename("Retrieve Background Export File", clientFile, filter, ext); } if (String.IsNullOrEmpty(clientFile)) { return(""); } Progress.Show("Retrieving file..."); try { ServerFile.CopyToClient(serverFile, clientFile); } catch (Exception ex) { string msg = "Unable to retrieve cached export file: " + serverFile + "\n" + "to client file: " + clientFile + "\n" + DebugLog.FormatExceptionMessage(ex); ServicesLog.Message(msg); Progress.Hide(); return(msg); } Progress.Hide(); if (Lex.Eq(ext, ".xls") || Lex.Eq(ext, ".xlsx") || Lex.Eq(ext, ".doc") || Lex.Eq(ext, ".docx")) { DialogResult dr = MessageBoxMx.Show("Do you want to open " + clientFile + "?", UmlautMobius.String, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { SystemUtil.StartProcess(clientFile); } } return("Background export file retrieved: " + clientFile); }