XpoLog help - Export and Import Log
 
How to export and import log files and configuration?

In order for an XpoLog user to make his logs available for another user that has no direct access to his logs, such as for instance in support requests, XpoLog allows you to export and import logs. Other than exporting the log data itself, XpoLog exports additional configuration data, so that the log could be imported at another XpoLog site and could be viewed without any need for further configuration


Export
  1. Select the log you want to export from the log tree.
  2. Open the 'Data Support' menu and click on the 'Export log' option. You can also right click on the log in the log tree and select 'Export log' from the context menu.

  3. In the Transformation section, select the first option ('Export the log together with its configuration, to enable future import') if you want to export both the data and the configuration; if you only need to export the data without the configuration, select the 'only transform the current data' option.

    Data Transformation

    XpoLog allows you to transform and save data from logs in a variety of other formats like XML, CSV (Excel) ,tab delimited or SQL database tables, so that the logs data will be accessible for other systems and users. The system will archive and compress it for fast network transportation and disk space optimization. You can export the transformed data to any source , just like when you export a log with its configuration. It is possible to activate a filter in the log view and then transform the data. The transformation engine will then use only the filtered data.
    XpoLog can transform log data to the following formats:
    XML - The data will be saved as an xml file.
    CSV - The data will be saved as an CSV file.
    TAB Delimited - The data will be saved as tab delimited file.
    SQL Database Table - The data will be saved to a SQL database table. In that case, a new exporting method called 'Insert log to database table' (see below) will be added to the export methods list.

  4. Now select the export method:
    • Get current log as Zip - XpoLog will create a zip file containing the log data (and its configuration if requested) and the browser will prompt you to save it.
    • Zip and send current log by email - selecting this option will direct you to the 'email log' page, where you will be asked to provide the email sender and recipient accounts, the subject and the text of the mail. The zipped export file will be attached to the email message and will be sent to the specified recipient.

    • Zip and send current log to ftp site - in the 'export to FTP' page select the ftp account to be used and enter the ftp site directory.

    • Zip and send current log to a local file system address - in the 'Export to File System' page enter the file system account to be used (corresponding to a location in your file system), where the zipped export file will be saved. Select the 'override' option to allow for XpoLog to override an eventually existing export file.

    • Zip and send current log over SSH to a remote machine - in the 'Export via SSH' page select the SSH account to be used and enter the directory where the zipped export file will be saved.

    • Insert log to database table - in case you chose to transform the data to a SQL Database table, select this method.
      If you choose this method you get to 'export log ... to database table' page. Enter the following data:
      'Database' - select the database or click 'new' to create a new one.
      'Table' - select the database table.
      'Table name to use' - in case you want to change the selected table's name or insert the data to a new table, enter here the table name to use; if the table does not yet exist, select the 'create table if it does not exist in database' option; this option will be automatically set once value has been entered to the 'Table name to use' field, assuming the table does not exist.
      'Log columns' and 'DB table columns' - This is a mapping between the exported log's columns and the selected database table columns. Use the links between the columns lists to select from one side which log columns should be written to the database and in what order, and from the other side to select the database table columns these values should be inserted to.
      'Create table statement' - in case you choose to create a new database table, you will need to specify the SQL create statement you want XpoLog to execute. If the 'create table' option is set then XpoLog will automatically create the insert statement.
      'Insert statement' - specify here the insert statement XpoLog will execute.
      Click 'Next' to start the process.

  5. Note that in all cases other then 'Get current log as Zip' an appropriate account should be available, or you'll be asked to create one. see the address book for more information on how to create accounts.


Import
  1. From the 'Data Support' select 'Import log'.
  2. Enter the full path of the zipped export file or press the browse button to select the file from the file browser.
  3. Click 'next' and select the folder into which you want to import the log.
  4. Execute the import by pressing the 'next' link.

E-mail text
An additional method to easily send the log, or segments of it, to an email recipient is the email text. Just select this option in the Data support menu and an email message with the current viewed log text will be created. Simply enter the sender and recipient emails, add your own text if needed, and send it.

Additional links
     Mail settings
     Export / Import folder
     Configuration Image
     Address book