Saving Monitor data

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.

Saving to 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. The binary file format is the only format that preserves all monitored information.
  • Save the data as a comma separated file (.csv) if you want to view it in another tool, such as Microsoft Excel. This only saves the information in the synchronization properties windows, except per table information and the session 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.

Exporting to a relational database or Excel

You can also export Monitor data using an ODBC connection. 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. Data from the graph is not exported.

The data source must have quoted identifiers enabled, because some of the columns are reserved words. The Monitor enables quoted identifiers automatically for SQL Anywhere, Adaptive Server Enterprise, and Microsoft SQL Server databases. If the quoted identifiers option is not enabled, the export fails.

To export the data to a database or Excel

  1. After collecting Monitor information, disconnect from the MobiLink server.

  2. In the MobiLink Monitor, choose File » Export To Database.

    The Export To Database window appears.

  3. Select options for the output.

    • You can name the two tables that are created to hold the data, or use the defaults. If the tables do not exist, they are 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.

  4. Click OK.

    A Connect window appears that allows you to connect to the database or Excel spreadsheet using ODBC.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0