/// <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);
}