You can save the data from a Monitor session as a binary file (.mlm), as a text file with comma-separated values (.csv), as tables in a relational database, or as a Microsoft Excel file.
To save the data as a file, choose File > Save As.
Save the data as a binary (.mlm) file if you want to view the saved data in the MobiLink Monitor. To reopen, choose File > Open.
Save the data as a comma separated file (.csv) if you want to view it in another tool, such as Microsoft Excel. This will save all the information in the session and synchronization property sheets, except per table information and the session begin and end time. You can also open a .csv file in the Monitor.
In the .csv file format, time durations are stored in milliseconds.
You can specify that you want data to be saved automatically to a file. To do this, choose Tools > Options, and enter an output file name on the General tab. The output file is overwritten by new data.
You can also export Monitor data using an ODBC or JConnect connection. With JConnect, you can only export to Adaptive Server Anywhere or Adaptive Server Enterprise databases. With ODBC, you can export to any relational database that is supported by MobiLink, as well as to Excel.
When you export data, all the columns in your Monitor session are exported, as well as a column called export_time that identifies the time the export was performed.
The data source must have quoted identifiers enabled, because some of the columns are reserved words. The Monitor enables quoted identifiers automatically for Adaptive Server Anywhere, Adaptive Server Enterprise, and Microsoft SQL Server databases. If quoted identifiers is not enabled, the export will fail.
To export the data to a database or Excel
After collecting Monitor information, disconnect from the MobiLink synchronization server.
In the MobiLink Monitor, choose File > Export to Database.
The Export to Database dialog appears.
Select options for the output.
You can name the two tables that will be created to hold the data, or use the defaults (mlm_by_sync and mlm_by_table). If the tables do not exist, they will be created by the Monitor. For Excel output, the two table names identify the two worksheets that are created.
Choose whether you want to overwrite data in existing tables. If you do not choose to overwrite the data, new data is appended to existing data.
Click OK.
A Connect dialog appears that allows you to connect to the database or Excel spreadsheet using ODBC or JConnect.
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.