BigTools5-GA

BigTools 5 Chrome Extension

Developer tools for Oracle CPQ that provide integration with your favorite editors. # BigTools 5.0.1 - Fixed View Transaction failure for legacy commerce processes # BigTools 5.0 BigTools 5.0 has been rewritten and upgraded to the latest Vue framework to address the performance issues users are experiencing in BigTools 4 and lays the foundation for feature new features. It is feature-comparable to BigTools 4 in this initial release. # New Features and Bugs Fixed in BigTools 4.4.8 - [Fixed] Advance Pricing Script Editor: Fixed developer name not being populated in the Revision History. - [Fixed] Only run the content script on the top-level frame. - [New] Commerce Formula Editor: added ability to extract the formula into a file and edit it in your editor. Also added the ability to load the formula into CPQ from the file. - [Fixed] Corrected the issue View XSL does not open the XSL document template file in the Document Designer. - [New] Added support for the user to open another quote from the transaction details page by providing either the quote number or BSID. - [New] Show the part numbers and part descriptions in the Existing BOM Mappings and Existing BOM Attribute Mappings tabs of the PW BOM Data Mapper. This is helpful if the Variable Name is different than the Part Number. # Bugs Fixed in BigTools 4.4.7 - [Fixed] BOM Mapper: The dynamic definition of the Variable Name field causes the attribute map to fail. - [Fixed] BOM Mapper: The Commerce Line Attributes are not loaded properly, causing the commerce attribute list to be blank. - [Fixed] The global data table search does not return any results. - [Fixed] Clicking on the "Edit Jet CSS" does not open the CSS file in the text editor. # Release Notes for 4.4.5 1. Fixed issue where the CPQ browser session expires when a loading data table is loaded/refreshed after the latest Chrome browser. # Release Notes for 4.4.4 1. Fixed the issue where the width BigTools menu is very narrow and does not show the menu label after Chrome v116 update. # Release Notes for 4.4.2 # Data Table Editor ## Multiple table text search (Requires CPQ REST API v14 or later) In addition to searching for a table by name, you now can perform a value search in multiple data tables to obtain a list of tables containing the search text. This feature is only enabled if your site supports CPQ REST API v14 or later. Once you verify your site meets this requirement, update your site settings to specify v14 to enable this feature. ## Reduce Table Editor Memory Footprint The BigTools Data Table Editor can be very memory intensive when editing large data tables due to it loads all the data when you open a data table. In the last Chrome release, Google released a performance improvement feature causing BigTools to crash. In an attempt to address this issue, the data grid scrolling method has been changed to use "infinite scrolling" so only 100 records are loaded when the bottom of a page is reached. To make the table editor behave like before, the table filtering is also enhanced to support BMQL-like where condition expressions. You can use most BMQL conditional operators (except IN and NOT LIKE due to the REST API limitation). Additionally, you can use regular the custom "regex" operator to search for values using regular expressions, e.g. YourColumn regex '/^MyValue.\*123$/i'. This example regular expression will return the records where the value in the YourColumn field starts with "myvalue" and ends with "123", the "i" suffix will perform a case-insensitive search. Note that the search for most operators is case-sensitive. Search using the "like" operator is case insensitive by default. # Transaction Viewer ## Reduce Transaction Viewer Memory Footprint The Transaction Viewer is also very memory intensive when there are data fields containing large amounts of data and when there are a lot of line items. It only keeps the first 1000 characters of a text field to reduce memory usage. The full value is retrieved when you expand a field or when you copy the value to the clipboard. New in BigTools 4.4.0 * Transaction Viewer: Ability to save and reuse previous search criteria and quote line filters * Data Table Editor: Display the table name in the tab of Data Table Editor * Data Table Editor: Selected records are always visible * PW BOM Mapper: Selected records are always visible * Global BML Search Result Filter * Part Integration * Other Enhancements Bugs Fixed in BigTools 4.4.0 * Transaction Viewer: Fixed the quote line column heading that does not match the data displayed. * Parts Integration: Fixed "Edit SOAP XSL" and "Edit SOAP Parser" commands not working issue. * PW BOM Mapper: Fixed or (|) filter expression not handled correctly. * Data Table Editor: Fixed data import failure when the CSV file is in UTF-8 with BOM format. * Fixed Menu Editor to support the latest changes Oracle CPQ enhancement that allows more than 30 custom part attribute fields. Features Summary: General: * Edit, reload, and debug util functions * Edit and replace files in the File Manager * Edit Home Page XSL, JavaScript, and CSS files * Edit site alternate CSS file * Edit page header and footer HTML fragments * Edit mobile and JET CSS files * View server log files * Slack integration. BigTools will post a message to the Slack channel with the same name as the host name of the site (i.e. company name) * Added comment support for BML scripts, in addition to BML function comment Commerce: * Edit, reload, and debug Commerce functions * Edit and reload Commerce action pre-pricing BML scripts * Edit and reload Commerce action post-pricing BML scripts * Edit and reload Commerce action advanced validation BML scripts * Edit and reload Commerce attribute advanced default BML scripts * Edit and reload Commerce attribute advanced modify BML scripts * Edit and reload Commerce approval advanced condition BML scripts * Edit and reload Commerce approval advanced approver condition BML scripts * Edit and reload Commerce approval advanced approver selection BML scripts * Edit and reload Commerce approval advanced notification BML scripts * Edit and reload Commerce advanced forwarding rule BML scripts * Edit and reload Commerce advanced timer condition BML scripts * Edit and reload Commerce transition advanced condition BML scripts * Edit and reload Commerce transition notification advanced sender BML scripts * Edit and reload Commerce transition notification advanced recipient BML scripts * Edit Commerce Integration XSL files * Open Transaction for a given transaction ID directly from the transaction page without the need to search for the transaction * Edit Commerce output advanced output (printer friendly) XSL template * View Document Designer XSL template * View Transaction Header and Transaction Line Details * View Transaction Change History Configurator: * Edit and reload Configurator recommendation rules * Edit and reload Configurator constraint rules * Edit and reload Configurator bill-of-material rules * Edit and reload Configurator pricing rules * Edit and reload Configurator configuration flow rules * Edit and reload Configurator search flow rules * Edit and reload Configurator recommendation item rules * Edit and reload Configurator hiding rules * Edit Configurator CSS files * Edit and reload Configurator external configuration functions Pricing / Rating Engine: * Edit and reload Pricing/Rating Engine advanced BML scripts BigTools VSCode Extension Features: * Edit BML scripts imported from CPQ * Real time compiling for errors and warnings * Format script for consistent appearance * Load script back into CPQ * Debug using test scripts