Updated on 2024-05-21 GMT+08:00

Importing RVTools Data

Constraints

  • Supported RVTools versions

    The file to be imported must be an Excel (.xlsx) exported from RVTools 4.5.1. If you use another RVTools version, adjust the exported file to fit the RVTools 4.5.1 version.

  • File size and compression ratio requirements

    The file to be imported cannot be larger than 50 MB, and the compression ratio cannot be lower than 5%.

  • Data filtering

    In the imported RVTools file, if CPUs or Memory of a server on the vInfo sheet is empty or 0, the server information will not be parsed by MgC.

Exporting RVTools Data

  1. Start the RVTools application.

  2. On the login page, enter the following information:

    • In the IP address/Name text box, enter IP address of the vCenter server.
    • In the User name text box, enter the username for connecting to the vCenter server.
    • In the Password text box, enter the password corresponding to the username.

  3. Click Login. In the top menu bar, choose File > Export all to Excel.
  4. Select a path for saving the file that contains details about your resource.

Importing RVTools Data

  1. Log in to the MgC console.
  2. In the navigation pane on the left, choose Research > Application Discovery. Select a migration project in the upper left corner of the page.
  3. If you are creating a discovery task for the first time, in the Tool Discovery card, choose Import > RVTools data. If you have created discovery tasks before, in the Discovery Task card, choose Import > RVTools data.
  4. In the displayed Improt RVTools Data window, click Select File and select the file exported from RVTools.
  5. Click Confirm.

    You can view the task in the task list.

    • If the task status is Failed, click View in the Operation column to view the data source that failed to be collected. You can move the cursor to the collection status of the data source to view the failure cause. After handling the failure cause, you need to delete the failed task and perform a second import.
    • If the task status is Succeeded, you can go to the resource list page to view the imported details about your resources.