Partcat Features Release History

7.7.1

TBA

Added
New Configuration option to use Global Filter Region as mask in a variety of reports and processes.
Updated
Updated Advance PIES receivers requirements and validations to the latest specifications.
Improved
Depopualtion report will now take into consideration Global Filter Regions when applying analysing data to depopulate when global region mask opeion is in use.
Deprecated
Deprecated support for Auto Care Brand Table versions other than the full brand table w/ OEM, which is set to be the only one available past July 3rd 2023.
7.7.0

May 4, 2023

Added
Auto-Indexing: PartCat will now auto-index ACA references databases whenever necessary upon startup, allowing user to use weekly AutoCare database releases.
Added
O'reilly Assessement Reports: New assessement option to analyse and pre-fill O'Reilly assessement reports.
Added
Skip ACES Validation: New option in ACES Electronic Output to entirely skip ACES validation with a significant gain in performance. Note this may result in invalid application being outputed.
Added
Override Failed ACES/PIES Submissions: New option added to Statistics Dashboard to proceed with autoated submission anyway in the case of a failed project due to statistical differences.
Added
Exclude Non-Valid Applications: New Electronic Output Options to remove applications flagged as non-validaded (IsValidable=N) from output.
Improved
Added option to exclude parts without application from Buyer's Guide generation.
Updated
Refreshed PartCat and JNPSoft logos.
7.6.12

October 10, 2022

Improved
Better statistics reporting when generating overlap analysis with conflict solver option
Improved
Optimized AAIA XREF ID report and improved performances
Improved
Product Line switcher can now work on PIES-only and ACES-only product lines.
7.6.11

August 8, 2022

Added
Overlap Conflict Solver: New option in overlap report to analyse and attempt to automatically solve attribute conflicts flagged in the data.
Added
Overlap Application Flag: New flag added to application level to flag applications as expected/wanted overlaps.
Added
Ignore Flagged Overlaps: New option in overlap report to ignore applications which were flagge as expected, regardless of their lifecycle or overlap status.
Improved
Added support for sequencial description in MyPartFinder output.
7.6.10

June 3, 2022

Added
PIES Lifecycle Extract: Added ability to pick which lifecycles to include when generating PIES data.
Added
VIO Versioning: Added support for multiple VIO data sets of the same level (national, state) within VIO maintenance
Added
Extended Coverage Report VIO selecto to be able to pick which VIO version to use.
Improved
Improved SQL Server secure connections (TLS).
Fixed
Fixed some instances of missing F15 Record Sequence in PIES data entry.
7.6.9

January 20, 2022

Added
ACES XML Overpopulation: New option to overpopulate ACES XML output data.
Added
Part BrandID: Ability to assign, maintain and output PartNumber/AAIABrandID within ACES data.
Added
Task Scheduler Failsafe: New option added to abort automated tasks whenever error files are generated.
Added
OptiCat API 1.3 Added support for latest OptiCat API based submissions.
Compatibility
ACES 4.2: Option to output ACES 4.2 data along with its corresponding new fields.
Improved
Digital Asset Naming: Digital asset archive generated during PIES output will now follow PIES document title settings.
Added
PIES Kit data support added for MyPartFinder output.
Improved
Improved 360 compressor to meet Amazon 360 imaging naming criteria.
Improved
Increased Coverage report attribute selection limit to 6.
Updated
Updated Log4J in order to mitigate any security issues related to CVE-2021-44228.
Deprecated
OptiCat credentials authenticated replaced by API key.
7.6.8

August 6, 2021

Added
Advanced Task Scheduler: New task scheduler adding advanced control over each individual files generated.
Added
OEM Product Line Override: Link product lines to one or more different OEM product lines.
Added
App Notes Language: Added ability to tag each application notes column with the appropriate language code.
Added
ADN PartShare 1.4 loadsheet support.
Improved
When using enumeration naming scheme in IMAGO, primary images will always be first.
Improved
Project revalidaiton will now show Source name for invalid BrandID messages.
Improved
Advance PIES receiver version output updated to 7.0.
Improved
XREF Report: new options to include VehicleID and EngineConfigID.
Improved
XREF Report: now supports VIO reporting.
Improved
Added support for MyPartFinder2 output.
Improved
General improvement on Statistic Dashboard.
Updated
Updated some analysis messages within AutoZone assessement report.
Updated
Java platform updated to recent release and improved memory management.
Compatibility
Adjustements to AutoZone NYA report for added compatibility.
7.6.5

November 20, 2020

Added
Carry-Up Report: New report allowing analysis of missing coverage and potential additions based on VCDB attributes similarities.
Added
Added new receiver: APW.
Improved
XML parsing optimizations.
7.6.5

November 5, 2020

Updated
OptiCat Upload 1.2: Implemented support for latest OptiCat API (1.2).
Updated
NAPA 8.3 Support: Implemented output for latest NAPA Application & PartsPro Interchange format 8.3.
Added
NAPA C-Notes: Introduce notion of C-Note mapping to both NAPA Data Entry and Electronic Output.
Added
New option to replace NAPA LineCode by SupplierID in both Application and Interchange output.
Added
New Application Notes Conversion Summary tab in NAPA Bridge generated report.
Updated
Application notes in NAPA bridge are now separated by a pipe ('|') character.
Improved
FTP Upload now support FTP over TSL and SSH.
Improved
Product Lines names are now shown next to PartNumber in PIES Electronic Output part selection.
Added
New option to additionally analyze MPCC in NAPA Overlap report.
Improved
Specific Extract stability and performance improvements.
7.6.4

June 23, 2020

Added
TecDoc Bridge: Complete solution to bridge ACES data to TecDoc DMM Import-ready format. Supported features include:
Added
Semi-automatic linkage between VCDB attributes and TecDoc Criteria.
Added
Linkage of C-Notes, Application Notes and PADB to TecDoc Criteria.
Added
Semi-Automatic Linkage of PCDB Product Lines to TecDoc Generic Article.
Added
PIES and Asset delivery support.
Updated
PIES 7.2 Support: Added support to latest PIES 7.2 additions.
Updated
ACES 4.1 Support: Added full support of ACES 4.1 standard.
Improved
Overlap Report Automation: The overlap report can now have its settings saved as a project and scheduled for regular output via the Task Scheduler.
Added
Coverage percentage Report: New report available which analyse coverage percentage by ProductLine/Make/Year based on covered vs. non-covered models for a given year.
Added
Depopulation Report: New report available which analyse and optionally remove non-needed VCDB attribute (overpopulation) based on user defined attribute(s) to preserve.
Fixed
Statistic Dashboard Error Handling: The statistic dashboard will now reflect Automated Task Scheduler status and errors.
Added
Introduced special flags in Document Title field which allow more control on file naming scheme.
Improved
Statistic Dashboard now saves PIES version of PIES Project at the time of mapping.
Improved
Shopping list has the option to exclude special "N/A" parts form report.
Improved
Improved support for lower resolution screens in PIES mapping screen.
7.6.3

May 22, 2020

Improved
Improved Asset Renaming: Complete overhaul of IMAGO's asset criteria renaming feature, along with new advanced renaming options for asset output, including ability to rename 360 image set during compression.
Added
Bore/Stroke Overpopulation on import: New option to automatically overpopulate Engine Bore & Stroke upon excel import.
Improved
Automated File Submission Security: Automated mapping process with submission (FTP/Opticat) will now have a dependency on Dashboard status; projects with a "Failed" status will not be be transmitted.
Added
Dashboard Configuration: New configuration screen in statistics dashboard allowing to set threshold options, comparison interval and values to compare. The latter will dictate additional comparison criteria to flag a project as "failed".
Improved
Automated task projects can now have their schedule set in bulk at a regular interval via the "Scheduled Tasks" tab.
Improved
Automated task project options are now displayed directly in "Scheduled Tasks" tab under the "AT Project set options"
Improved
Overpopulation report can now produce data report with a choice of attributes to overpopulate.
Improved
Ability to output PIES files for custom product lines.
Improved
The Product Line Switch utility will now analyse and change PIES B64 field according to the destination product line.
Improved
Updated PIES mapping naming scheme to be more consistent with ACES naming scheme.
Added
Mandarin language support added in language selection.
7.6.2

February 11, 2020

Fixed
(HOTFIX) PADB 4.0 Compatibility: Added critical compatibility fix with latest PADB (Autocare February 2020 Release) as well as backward compatibility for previous versions.
Added
New option to export Global PADB attribute in Web Output.
7.6.2

December 2, 2019

Updated
PIES 7.1 Support: Added import/export/data entry support for PIES 7.1, including VMRS Brand support in Interchange Brand Management.
Added
Automated OptiCat Submission: Ability to schedule automated mapping and submission to OptiCat using the Task Scheduler.
Added
New OptiCat Status Codes: New status messages added to OptiCat submissions to better reflect the submission status of file(s) sent to OptiCat via PartCat.
Added
Added Specific Extract to ACES ID Cross Reference report.
Added
ACES ID Cross Reference report can be be automated and scheduled via Task Scheduler.
Added
New assessment report analysis added: Epicor.
7.6.1

July 9, 2019

Added
Statistics Dashboard: New dashboard showing statistics about previously mapped files, either generated manually or via the automated service. Detailed view showing all the mapping used at the time of mapping as well as the difference between past mapping. Currently supports ACES, PIES and WEB projects.
Added
New option to generate "raw" 360 imagesets in IMAGO in order to help compatibility with other systems, such as OptiCat.
Improved
Revamped the Task Scheduler screen.
7.6.0

May 15, 2019

Updated
ACES 4.0 Compliance: Added support of ACES 4.0 specifications.
Added
Addition of latest EngineBoreStroke and EngineBlock ACES fields in all components of PartCat.
Added
ACES 4.0 Body Config Validation Rules added as an optional Validation configuration setting.
Added
Body Config Validation toggle switch added in general configuration to either use or not the new Body Config validation introduced within ACES 4.0.
Added
New Vehicle Class field in Global Filter and Specific Extract.
Improved
ACES Version as a mapping options: Moved ACES version output from General Config. to ACES electronic output.
Added
Overpopulate Engine fields on Data Entry: Added option of overpopulating ACES 4.0 Engine-specific fields directly from application Data Entry upon saving.
Added
PIES Coverage Report: New audit report to highlight missing PIES fields of your parts from a configurable user selection of fields, per receivers.
Added
Mapping Project Validation: New validation on PIES, ACES and Web project to highlight inconsistencies in selected data. Validation made upon loading prpject and running it automatically using task scheduler. Project Revalidation report also made available.
Improved
Part selection from spreadsheet: All part choosers have been updated to now include the ability to import a list of part to select from an external spreadsheet.
Added
ACES to NAPA Sync Report: New type of coverage report to easily identify cases of missing NAPA coverage based on your existing ACES coverage. NAPA Bridge required for this to be active.
Improved
NAPA Lifecycle: NAPA mapping can now follow lifecycle exclusion/inclusion rules form Lifecycle configuration.
Improved
IMAGO Asset report can now be run by interchange.
Added
New option to map TEST ACES files in Electronic Output.
Improved
Product Line Header Configuration can now be manually reset.
Added
Added NAPA, NAPA Bridge and QDB versions to Data Maintenance screen.
Added
Added option to generate EngineBaseID ACES data instead of EngineBoreStroke and EngineBlock at time of mapping.
Added
New global option to enable or disable display of BoreStroke on application listing summary.
Added
New global option to enable or disable display of Part Headers summaries (yellow rows) on Part Export.
Added
License and version information now available in Configuration > About.
Fixed
Better visibility of Data Entry selection color under poor contrast environment.
Improved
Revamped the General Config configuration screen.
Improved
Adapted OptiCat Upload to handle newly added API responses from OptiCat.
7.5.10

January 29, 2019

Added
PIES Coverage Report: Reports the required, missing and mapped PIES fields for a given receiver and export in standard PIES format along with a per-part summary. Follows standard validation rules with the ability to check for additional PIES field coverage.
Added
Interchange Grid Report: Prints interchanges in a grid format, where various sources can be added to the report's columns and compare against all selected parts.
Improved
Bulk QDB Export tool will now exports Application, Part and Interchange notes under their respective tab.
Improved
Improvement on QDB parameter validation.
7.5.10

November 26, 2018

Added
OptiCat Upload Utility: New utility allowing upload of ACES, PIES and Image files onto the OptiCat platform from within PartCat.
Added
Support for latest NAPA PartsPRO Interchange format.
7.5.10

October 19, 2018

Added
Complete QDB Support: Full integration of QDB data manipulation within PartCat; data entry, new QDB Maintenance Screen, electronic output, validation, etc. Consult the "PartCat QDB Guide" for more details.
Updated
PIES 7.0: Updated PIES mapping rules and validation to follow the latest PIES 7.0 changes. New PCDB-based validation of coded value, which requires a PIES 7.0-compliant PCDB to be set in your environment.
Added
Product Line Switcher: New utility allowing easy move of data from one product line to another.
Improved
Bulk Application Note Maintenance: Multiple Application notes can now be edited at once from the Data Entry Screen.
Improved
Data Entry Screen can now be scaled and resized.
Improved
IMAGO reports now follow Reporting Lifecycle configuration.
Added
New shopping list feature where the PCMDB part (if any) corresponding to the OEM application is printed.
Improved
Product Line is now optional when loading a specific extract part list from spreadsheet. All instances will get selected when no Product Line is given.
Added
Added support for metric ACES fields for PowerOutput, Wheelbase and BedLength.
Improved
NAPA MPCC can now be searched by keywords.
Improved
NAPA Comments can now be searched also by IDs.
Improved
NAPA Overlap report can now be generated based on an interchange.
Removed
VED Removed XLS/MDB/ACCDB support for import.
7.5.9

September 5, 2018

Added
Assessment Reports Automation: New automation of standard assessment reports analysis based on the current state of your data. Reports currently supported: WHI, Autozone.
Improved
Market Copy Import/Export: Market copy content can be exported and imported on its own.
Added
Updated sorting order on NAPA NetChange Application mapping so that Deletes now come first within the generated file. File name was updated to "*_DEL_ADD.txt" to reflect this change.
7.5.9

July 10, 2018

Added
PIES Values Replacement by Interchange: New ability to replace existing PIES fields during mapping based on Interchange Note(s) when mapping by interchange.
Added
All Applicable Year Support in Web Output: Customs applications with year 0 or 9999 will now be included in web outputs and treated as "All Applicable years" on MyPartFinder.
Fixed
Rejected Interchange and Supersessions during import can now be exported for review.
Improved
Added support of multiple monitor workstations.
7.5.8

April 9, 2018

Added
Custom PADB Validation: Added ability to load custom values for free-form PADB attributes (text and alphanumeric). Custom values will appear as a drop-down choice in PADB data entry screen.
Added
PADB Global Receiver: New special reciever type for PADB attributes that can be used as a wildcard when mapping a PIES file with PADB attribute: the Global receiver can be used with any receiver. Existing PADB data mapped to another receiver will always take priority over the Global data.
Added
PADB UoM Conversion: New General config option "Convert Pies UOM" that will automatically convert any PADB values into all the other existing units of measurement (as defined by the PADB).
Added
O'Reilly Extended Characters Replacement: new mapping option that will strip extended characters rejected by O'Reilly from the ACES file being mapped.
Added
Added button to add a new line for all existing PADB attribute for a given product line.
Added
Added ability to load Market Copy data from a spreadsheet.
7.5.7

February 7, 2018

Added
Bulk Delete PartNumbers: New Data Maintenance screen allowing the deletion of part numbers in bulk from the PCMDB, either from manual selection of based on an imported list of numbers.
Improved
Automated Mapping Merging: The Task Scheduler now offers the option to automatically merge ACES & PIES projects within the task, allowing the creation of more complex files. Projects that do not meet the merging requirements get generated as usual.
Added
Automatic Excel Conversion: New option in the task scheduler that allow automatic conversion of generated XML into Excel spreadsheet during run time.
Improved
NAPA Position Filter: Ability to filter applications based on positions extracted from NAPA MPCC in the search screen. This is for display only and does not affect mapping.
Added
PIES Net Change for Flat File Receivers: New NetChange features for the following PIES receivers: ADN, APA, AWDA, Pronto, WorldPac in both TXT or Excel formats (where applicable). Given a reference "previous" file, the netchange will generate an update file only for added and updated parts, and a delete file (when applicable) for part no longer present in the most current mapping.
Improved
Performance Improvement: Improved performance for the following: VIO Import, PIES Export, NAPA Bridge.
Added
New option in the Coverage Report allowing to merge all Coverage report results into a single sheet, while keeping individual coverage information per product line.
Improved
Improved part notes selection in ACES mapping screen: it is now possible to select multiple Part Notes and add them at once in the note selection.
Added
New "Add All" and "Remove All" buttons for part notes: the former will add all Part Notes (all product lines), while the latter remove the complete selection of notes.
Added
New configuration setting allowing the mapping of Application Notes before Part Notes during ACES mapping.
Improved
Improved UTF-8 special character encoding for ACES 3.2.
Added
Added PADB attribute description in PIES Data Entry tab for PADB attributes.
Added
New prompt informing no result was found when searching for application in the Search screen.
Improved
VIO Counts are now able to be displayed in the search screen for OEM application, even when no corresponding application is found in PCMDB.
7.5.6

December 7, 2017

Improved
Improvement on Specific Part Extract by Part List when importing parts from a spreadsheet. Special characters are now ignored when trying to match the parts from the list with the ones in the database.
Improved
Performance improvement on the ACES ID Cross Reference Report.
Improved
Performance improvement on NAPA Data Entry.
7.5.6

November 6, 2017

Improved
Rearranged PIES Segments Selection option on the PIES mapping screen.
Added
Added validation on PIES field E05 - EXPI Code.
7.5.6

Initial Release

Compatibility
64-bit Support: PartCat is now available for both 32-bit and 64-bit system architectures. Global performance improvements.
Added
Specific Part Extract by Part List: The option to select Part Numbers from a list of Part Numbers in spreadsheet form was added to the specific extract screen, allowing easy selection of multiple parts at once.
Added
User Profiles Import / Export: Added the ability to export and import your user profiles for backup and restore purposes. Option available under the new "Security" tab of the "DB Connections and path" configuration screen.
Added
Added Pronto Flat File mapping format support to PIES mapping.
Fixed
ACES Quantities can now be overridden by a different quantity when mapping from an interchange.
Added
Added validation on PIES field B41 - Quantity per Application UOM.
Added
Added validation on PIES field D35 - Price Type.
Added
D Added validation on PIES field J10 - Regulating Country of Origin.
7.5.5

August 28, 2017

Added
Added validation on PIES field C05 - Description Code.
Improved
ACES Mapping performance improvements
7.5.5

July 17, 2017

Added
Copy over PIES: New feature added allowing the automatic copy of PIES information from one receiver to another. Fields eligible for copy will need to be set up within the PIES configuration screen.
7.5.5

July 3, 2017

Added
VIO Load date is now displayed on the Data Maintenance screen.
7.5.4

Initial Release

Added
Excel Import performance improvements.
Added
D Overlap report performance improvements.
7.5.3
Added
PIES Interchange Note Selection: Added ability to manually select which Interchange Notes are to be sent within PIES when mapping a file.
Updated
ACES 3.2 Support: Now supports ACES 3.2 mapping along with its newly implemented specifications.
Added
Added global option to automatically exclude interchanges with blank BrandID during PIES mapping.
Added
Added support for Part Number based specific extract for Custom applications.
7.5.2

March 6, 2017

Improved
Increased Notes (C, Application, Publishing) character limit to 500.
Improved
VED Performance improvement on PIES import.
7.5.2

Initial Release

Added
360 Images: Added 360 Images support to IMAGO and PIES. Ability to now load, process, manage and map 360 degrees images for PIES delivery.
Updated
PIES 6.7 Support: Added latest PIES 6.7 output as part of PIES mapping options, along with 6.7 new specification and fields.
Updated
Attribute Entry Tab: PIES custom attribute entry has now been moved from the Part tab to its own tab: Product Attributes.
Added
Added ability to save PIES file output names within a PIES mapping project.
Improved
Import performance improvements.
7.5.1

Initial Release

Added
Full MySQL and SQL Server Support: Full implementation and support of MySQL and SQLServer environments, including major performance improvements. Dropped support for Access and H2 databases.
Added
Image NetChange: NetChanges for images are now able to be generated. Once the initial baseline is established (via IMAGO), subsequent updates to the image files can be found and selected using checksums.
Added
Parts with no Applications Audit Report: New added audit report. Will return part numbers that are currently not linked to any applications within the database.
7.44

March 31, 2017

Added
C-Note Filtering: Added the ability to filter search result based on a user-defined specific C-Column Note. Filtering appears as drop-down box in the search screen when activated (from the Selection Criteria screen).
Added
Added MfrLabel as a optional selection criteria for the search screen.
7.4.4

December 12, 2016

Added
New PIES Receiver: WorldPac added as a new PIES receivers. Output PIES data following their specific load sheet format.
Added
Project Manager support for Amazon: The ACES Project Manager functionalities has now been added to the Amazon ACES Electronic Output, now allowing sa projects and automating mapping via the task scheduler.
Updated
New VCDB Validations: Total changed permitted products and Total of invalid product lines without applications have been added to the re-validation audit process
Fixed
Pressing Back from the Data Entry screen will now return to the Utilities menu instead of the Main Menu.
7.4.4

Initial Release

Added
** NAPA Bridge**: When activated, allows automatic conversion of ACES application data to NAPA application data, upon data entry or Excel Import
Added
**VIO Import / Export**: new utility that now allows advanced VIO data export and import by oneself. Located under Utilities.
Added
**Overlap by interchange**: Added ability to generate an overlap report for interchange-based data. New tab Interchange Options within the Overlap reporting scr added to reflect those options.
Updated
**PIES 6.6 Support*: Added PIES 6.6 support along with its associated new fields and associated features.
Improved
**More C-Notes**: Extended the number of allowed Part/Column Notes from 40 to 200.
Improved
**PIES Specific Extract**: Now allow PIES extracts on specific Part Numbers selected.
Added
**C-Notes Display Name**: Added the option to rename Part/C-Notes columns from the Part header and Columns screen. Excel export will also additionally display Display Names within the Part segment.
Improved
Improved Advance PIES validation.
Added
Ability to export only the PIES Item Segment in the export and maintenance screens.
Fixed
Excel export by part will now only export relevant interchange and supersession data from the selected parts.
Improved
Part Numbers can now be linked to a default NAPA MPCC (USA or CAN).
Added
NAPA MPCC can now be added manually within PartCat, in anticipation of the official MPCC file release from NAPA.
Added
NAPA Comments can now be added manually within PartCat, in anticipation of the official database update release from NAPA.
Improved
Buyer's Guide report has now the option to split applications by Position (different positions will get their own line).
Improved
Web Output performance improvements.
en_USEnglish
fr_CAFrench en_USEnglish