Bulk Downloads

Overview

You can make changes to large quantities of system data in CPQ. For example, you may need to download data in bulk, make batch edits, and then upload the data back to CPQ.

Watch Video  Video icon

There are several ways to move data and files in CPQ. See the table below to determine which help topic to use.

To Move... See...
Data to Oracle CPQ tables, in bulk Bulk Uploads
Data from Oracle CPQ tables, in bulk This document
Data Tables Import & Export of Data Tables
File Manager files, such as images, PDFs, or XSL files File Manager
Documents in Document Engine Document Migration: Document Engine
Migration changes between Oracle CPQ environments Migration Management Overview

ClosedData Types Available for Bulk Upload and Download

The following table shows the Data Types that can be uploaded and downloaded, and in which format.

All data that can be uploaded into the system can also be downloaded. For the XML data type, all downloaded data can be uploaded. However, only some downloaded CSV data can be uploaded.

Data Type XML CSV

Account/User Associations

 X  

Accounts

 X X

Commerce Processes * 1

 X  

Commerce Transactions * 2

 X  

Company

 X X

Configuration Attributes

 X X

Configuration Rules

 X  

Data Tables * 3

 X  

Event Logs

   X

File Manager * 3

 X X

Library Functions

 X  

Part Associations

 X X

Part Extended Descriptions

 X X

Part Pricing Rule Information

   X

Parts

 X X

Price Book Associations

 X X

Printer Friendly Document

 X  

Product Definition

 X  

Serial Number Associations

 X X

Serial Numbers

 X X

Text Administration

 X  

Translations * 4

   X

User Login History * 5

   X

User * 6

 X X

Notes:

  1. The Commerce Process can also be obtained from the Process Definition Deployment center, by using "Import Process".

  2. Commerce Transactions cannot be added or deleted, so the <action> tag can only be update, and the <action_var_name> tag must be populated with this valid action.

  3.  Downloading Data Tables and File Manager is useful if you want to download all Data Tables or all File Manager files in a single ZIP file. However, specific tools, besides Bulk Upload and Download, are used to manage Data Tables and File Manager. See Import and Export Data Tables and File Manager for more information.

    If a data table with a secure column is exported or downloaded using a bulk download, then the same content is uploaded using import or a bulk upload, values are double encoded, changing their value.

  4. See Localization for more translation-related information.

  5. For the User Login History bulk download, the User Login is the user being logged into directly or the target user being proxy logged into. The Proxy Login is the user that performed the proxy login to that specific user, if they are not logged in directly.

  6. Users cannot be deleted. Instead, change a user's status to Inactive.

ClosedTransferring the Product Family Data Type

The following data types require that a Product Family be specified in order to be transferred between sites, such as through migration or bulk download/upload:

  • Catalog Data (requires Product Family)
  • Configuration Data (requires Product Family)

  1. Migrate the Product Definition first, because it contains the information of what Product Family has been defined.

    • This will add the reference of the Product Family to the site.
    • If the Product Family already exists on the site, then you can see the categories that are listed.
  2. Manually add the Product Family under Catalog Definition.
  3. Continue migrating the Product Line.
  4. Migrate the Catalog.
  5. Migrate Configuration data.
  6. Migrate Attributes.
  7. Migrate Rules.

Administration

ClosedPerforming a Bulk Data Download

  1. ClosedNavigate to the Download Category List page.

    1.  Click Admin to go to the Admin Home Page.

    2.  Click - Download under Bulk Data Services in the Utilities section.

      The Download Category List page opens.

  2. Select a category to download.

  3. Click Next.

    The Search Criteria page opens.

  4. Specify the criteria. Only the data that satisfies the criteria will be downloaded.

    Filter Field Names Description
    id

    The Oracle CPQ system generates a unique ID for each item it stores, be it a rule, attribute, account record, ... and so on. For downloads, the ID field can be used to filter a single record in that download category.

    In general, you can locate an ID by navigating to the item you want to download and then viewing the corresponding ID in the URL.
    company_id Company IDs can be located in the home page URL.
    ref_id

    This is the ref_type ID that is generated (for example, Model ID, Product ID, Company ID for all Product Families).

    Navigate to the Model List Admin page and view the ref_type ID in the URL.
    segment_id

    For the "all product family" product category, the segment ID equals the company ID. Company IDs can be viewed on a Commerce page, if the attribute has been placed on the layout.

    For the "single segment" product category, the segment ID is a unique number associated with a particular segment. Segment IDs can be located by navigating to the Product Line Administration List page and viewing the segment_ID in the URL.

    pline_id

    		 To locate a product line ID, navigate to the Product Line Administration List page, click the Product Line, and view the parent_id in the URL.

    The URL shows /edit_pline.jsp?id=5543984&segment_id=11&_fromQlink=0. The specific ID for the product line is 5543984.
    model_id To locate a model ID, navigate to a rule at the model level and view the model_ID in the URL.
    attribute_id To locate an Attribute ID, navigate to the Attribute Administration List page, put the cursor over a specific attribute link and view the ID that dynamically appears in the browser window's bottom bar.
    rule_id To locate a Rule ID, navigate to the Rule List page, put the cursor over a specific rule link and view the ID that dynamically appears in the browser window's bottom bar.
    part_id To locate a Part ID, navigate to the Part Administration page for a specific part and view the "pid" in the URL.
    serial_number_id To locate a serial number ID, navigate to the Serial Number Administration page for a specific serial number and view the ID in the URL.
    part_association_id Part Association IDs can be found on the Part Tree for Part Number page, which displays part associations for a select part. To view a part association ID, highlight a part number and view the ID that dynamically appears in the browser window's bottom bar.
    parent_part_id, child_part_id

    When downloading a single part association, these IDs must be used together.

    Each field expects a part_id: one for the parent part association and the other for the child part association.

    Part Associations can also be downloaded using the part_association_id instead of these two IDs.
    serial_number_id, part_id

    When downloading a single serial number association, these IDs must be used together.

    The first field expects the serial_number_id, and the second field expects the part ID for the associated part.
    To download all the data in the Data Table, leave all criteria blank.

  5. Click Download.

    The Download Status page opens.

    Downloaded files are stored on the server. Files that are stored on the server can be downloaded onto your local system or viewed in your browser from the server location.

    • The types of Configuration rules you can download are: recommendations, constraints, and pricing.
    • Only one type of rule can be downloaded at a time.
    • Product line and model data can be downloaded for one segment at a time.
    • When downloading Commerce or Asset Management data, the entire transaction, including all documents and sub-documents, is downloaded.
    • File size is limited to 10MB.

ClosedViewing Download Status

The Download Status page shows the module name and status of all files scheduled for download in the previous seven days. The page also displays the status message and the scheduled date and time.

Successful downloads showing a status of Completed are removed from the Download Status page after seven days. Download tasks with any other status are not removed from the Download Status page.

To access the Download Status page:

  1. Click Admin to go to the Admin Home Page.
  2. Click (Status), next to - Download, under Bulk Data Services in the Utilities section.

The Download Status page opens.

Using this page, you can:

  • Sort the details based on Status, Status Message, and Scheduled Date/Time. Click the appropriate heading to sort the details in the order you wish to view them.
  • View the Status of the task. The Status column shows Pending until the process begins. Finished downloads show a Status of Completed.
  • Click the name of a Module that was downloaded from the system. This opens a pop-up window displaying the name of the ZIP file. Select whether to Open the file using one of the drop-down options provided, or Save it.
  • Remove local downloads from the server to free up room for future download files. Select all Modules, or select individual Modules to be deleted, using the Select All or Select options. Click Delete to delete the download(s).

Up to five download files can be stored on the server at any given time.

  • Select a task and click Stop Current Task to stop the download.

    • If the download file you want to view does not appear on the Download Status page, the download process may not have completed.
    • Click Refresh to update the data on the page.
    • Download tasks can have any of the following statuses:
      • Completed
      • Failed
      • Running
      • Pending
    • If a download fails, retry the download process. If you still cannot get download to succeed, contact an implementation engineer.
    • Files too large to display in a browser must be opened in an editor tool.
    • When no records are found, the download file will contain the following XML: "<record_list ></record_list>".
    After a file is removed from the server, it is not possible to recover it.

Related Topics

Related Topics Link IconSee Also