Deleting Spreadsheet Inventory Data from the Database

FlexNet Manager Suite 2021 R1 (On-Premises)

To remove data imported from an inventory spreadsheet, delete its connection.

When any inventory data source is removed from FlexNet Manager Suite, the data imported exclusively from that source is removed from the database as well.

Tip: Any data imported from multiple sources remains until its last source is removed. This means that if you want to delete from the database those inventory records that you imported only from a spreadsheet, you need only remove the connection to that inventory spreadsheet.

You may want to delete the connection to an inventory spreadsheet for several possible reasons:

• You made a mistake with some values in a one-time import of an inventory spreadsheet. To correct this, you must first delete the previous connection to that spreadsheet, and then do a new one-off upload of the amended inventory spreadsheet.
• A one-time upload failed in some way, and is now disabled. You must delete this connection to retry.
• You accidentally have multiple connections to one-time inventory spreadsheet imports existing to exist at the same time. All but one of these must be deleted.
• Inventory imported from a one-time spreadsheet import has aged, and you want to remove it from the Out-Of-Date Inventory listing.
• You want to change details about a scheduled import of inventory spreadsheets through an inventory beacon.

You can delete the connections separately for:

• One-time data uploads (for details about one-off uploads, see One-Off Import of an Inventory Spreadsheet). These connections are deleted only in the web interface.
• Scheduled, repeated uploads through an inventory beacon (for more information about these uploads, see Setting Up Scheduled Imports of Inventory from Spreadsheets). Connections established on an inventory beacon must be deleted both in the web interface and separately in the FlexNet Beacon interface.

To delete a connection to an inventory spreadsheet:

1. Navigate to the system menu ( in the top right corner) in the web interface for FlexNet Manager Suite, and click Data Inputs.
2. Click the Inventory Data tab.
   Tip: For connections through inventory beacons, if you do not want to delete your set-up connection, and plan to re-use it in future, select Disabled from the Connection status drop-down list displayed on its row. Manually disabled connections can be re-enabled when you are ready. (In contrast, one-off upload connections are automatically disabled after a single processing run, and cannot be re-enabled.)
3. Click the light-gray triangle displayed at the far right of your data connection’s row:

   
   
   

   A panel expands to reveal more details about the connection.
4. Inside this panel, click Delete connection.
5. Click OK on the confirmation dialog.
6. If this is a scheduled inventory spreadsheet import (that is, one running through an inventory beacon):
   1. Log in to the appropriate inventory beacon (for example, through Remote Desktop Connection), and start FlexNet Beacon.
      Tip: You must log in with an account that has administrator privileges on the inventory beacon.
   2. Ensure that the Inventory systems page is selected, and select the connection from the list.
      Your connection shows Spreadsheet in the Type column.
   3. Click Delete, and on the confirmation dialog, click OK.

The saved copy of your spreadsheet is removed (from the central application server for one-off uploads, or from the inventory beacon for repeatable uploads). At the next import and compliance calculation, the records created from that spreadsheet are removed from the database.