1. Using Innovation Management
  2. How You Update a Concept Structure Using the Oracle ADF Desktop Integration Tool

How You Update a Concept Structure Using the Oracle ADF Desktop Integration Tool

Let's learn how you can update a concept structure in an Excel spreadsheet using the Oracle ADF Desktop Integration tool.

Note:

Download and install the ADFdi Excel client to exchange data directly between Microsoft Excel and Oracle Innovation Management.

To initiate the process of exporting the details of a concept structure to an Excel spreadsheet:

  1. Click the Edit in Spreadsheet option on the Actions menu of the Concept Design work area.

  2. To open the Excel file, sign in with your Innovation Management credentials. If you have previously signed into an Excel sheet and not signed out, then you're not prompted for your credentials when you open a newer Excel sheet.

  3. You can update concept and components data directly in the spreadsheet.

  4. After updating the concept and components data in the spreadsheet, click the Upload button. The cells that are successfully updated display their status in the Status column.

Note:
  • New rows have to be inserted between the first and last row of the table. After the upload, the new row is inserted as the last row in the table. You can select and move the new row to the desired location.
  • There shouldn't be any empty rows in the data between the first and last rows of the exported data. If you miss out on adding any details before uploading the data, an error message is displayed in the Status Viewer section of the spreadsheet.