1. Using Innovation Management
  2. Import Object Data Using Oracle Visual Builder Excel Add-in

Import Object Data Using Oracle Visual Builder Excel Add-in

You can use the Oracle Visual Builder Excel Add-in to import objects into Oracle Innovation Management.

This add-in lets you to edit business data available from REST services. To import each object type, you must know its REST API URL, and required fields.

The table lists the object types, REST API URLs, and fields with examples.

Object Type REST API URLs Required Fields with Examples
Requirements Specification

https:// <host>/fscmRestApi/resources/11.13.18.05/requirementSpecifications/describe

 Name: Dual Band FM Radio
Ideas https://<host>/fscmRestApi/ resources/11.13.18.05/ideas/describe Name: Rugged Field Radio
Proposals https:// <host>/fscmRestApi/ resources/11.13.18.05/productProposals/describe Name: Emergency Communications Radio
Concepts https:// <host>/fscmRestApi/resources/11.13.18.05/productConcepts/describe Name: Mobile Radio TNC
Note: Hierarchies aren't supported in concepts and requirements specifications.

You can download and install the Oracle Visual Builder Add-in for Excel from the URL: https://www.oracle.com/downloads/cloud/visual-builder-addin-downloads.html. Note that this isn't supported in iOS.

To import data for proposals:

  1. Once you install the add-in and open Microsoft Excel, you see the Oracle Visual Builder ribbon. To design a sheet to import issues, click Designer. The New Layout Setup dialog appears.
  2. If you've set up proposals as one of the business objects, then you can see that productProposals is already an object in the object catalog. To learn how to set up Business Object Catalogs, view the video: Use Visual Builder Excel Add-in to Manage Data.
  3. Select productProposals object.
  4. Click Next.
  5. Select the Table Layout option.
  6. Click Next.
  7. Click Finish. Now you've a spreadsheet template to import the product proposals.

    The spreadsheet lists all the fields for the selected business object. The add-in doesn’t always select the appropriate fields as required and so you must change the list of required fields.

  8. Open the Proposal field and select the Required to Create and Omit from payload if value is empty options.
  9. Click Done.
  10. Click Redraw Layout.
  11. Verify that the required fields you chose appears with an asterisk.
  12. Add data that you want to import and click Upload Changes.
  13. In the Status panel, you can see the created number of rows. The Status column in the main panel shows you the status of the upload for each row.

To validate the import, sign in to your cloud instance and search for the issues you imported.

Related Topics