Sent on behalf of Joe Rogers
Date: September 11, 2024
To: NAACCR List Serv members
From: Joseph D. Rogers, M.S.
Team Lead: Informatics, Data Science, and Applications Team
Cancer Surveillance Branch
Division of Cancer Prevention and Control, NCCDPHP, CDC
Subject: Release of CDC NPCR's Exchange Plus 2.6
We are very pleased to announce that Exchange Plus 2.6 is now available! This version replaces the previous version available on the CDC NPCR Registry Plus website, and the web page has been updated. This version accommodates previous NAACCR XML versions.
Exchange Plus is a tool for reading and writing data exchange files formatted according to the NAACCR XML Data Exchange Standard. Exchange Plus was developed to work with analytic software tools such as R and SAS, which do not accept NAACCR-formatted XML data files as inputs, but can accept flat and delimited files produced by this application to perform data manipulation, statistical calculation, and graphical display.
The following updates have been included in this release of Exchange Plus:
- Supports the NAACCR Data Exchange Standard, XML Specifications for Cancer Registry Records, Version 1.8: The datatype, dateTime, has been implemented. This updated version, Exchange Plus 2.6, will be needed to validate v25 XML files appropriately for dateTime.
- Enhancements for Running EDITS:
- Editing has been enhanced for multiprocessing.
- Individual Edit Options have been added allowing users to suppress edits.
- The Run Edits interface has been enhanced.
- Mapping Function: Resolves a comma delimited issue where data was not aligned properly if commas were included in the values.
Tasks performed by XMLExchange Plus include:
- Create User Dictionaries/Dictionary Maintenance. This module is intended to help users who are not XML experts produce valid NAACCR XML dictionaries. This audience includes metafile administrators who may be asked to define a user dictionary based upon customized data items collected by their registry.
- Convert. This module converts data files from the flat-buffer format to NAACCR XML format, from NAACCR XML format to flat-buffer format, and from NAACCR XML format to delimited.
- Run EDITS. This module runs EDITS against a NAACCR XML data file and creates a GenEDITS-style report (detail and summary).
- Import, View, Update, Export NAACCR Data. This module allows users to import NAACCR files, view the data in a grid, update individual records in grid cells or apply batch updates for file manipulation, export updated files with or without application of filter criteria, anonymize confidential data, and includes a feature to split files by number of records or by a field value. Multiple NAACCR files can be combined into one data source. Central registries using CRS Plus can specify connection string to the CRS Plus database and run linkage on all records in the data source against all abstracts or consolidated records in the CRS Plus database. This feature is helpful for case finding, completeness, and prioritization of data to determine if records exist in the database prior to importing into CRS Plus.
- Validation. This module runs schema validation to verify the xml file is a valid NAACCR xml document and that the file does not contain any data items that are not defined in the base or user-defined dictionary. It also validates the data type and length of each data item and produces a validation report.
- Data File Mapping. This module converts any kind of delimited file or fixed column position file to the current NAACCR XML file, and also maps data items with different code and format structure to NAACCR standard codes to assist registries with data linkages and preparing data to write to the database in the NAACCR standard format.
For more information about CDC NPCR's Exchange Plus, including system requirements and installation instructions, please visit our product website at the following location: Exchange Plus | NPCR | CDC
The install contains a PDF version of the Exchange Plus Manual that can be accessed from the Help menu in the task bar.
We also encourage central registries to review existing local data items to determine if reporting needs have changed, and to prepare user dictionaries for NAACCR v25 if the dictionaries have not been created to date. As a reminder, a User Dictionary Clearinghouse is hosted on the NAACCR website to show examples of user dictionaries from other central registries and to provide the template that will help central registries gather information needed to define their own XML User Dictionary. Central registries with registry-specific data items are encouraged to fill out the Excel template available at XML User Dictionary - NAACCR and upload it to the XML Dictionary Submission Portal with a corresponding XML User Dictionary so that registry software vendors can get access to these required files to prepare customized software applications and to deploy their NAACCR v25 changes in a timely manner.
ALL issues or support questions should be sent directly to the Helpdesk at cancerinformatics@cdc.gov.
Please share this information with other members of your team, as appropriate.
Thank you,
Joe
Data Visualizations Public Use Databases | Joseph D. Rogers (Joe), MS Team Lead Informatics, Data Science, and Applications Team Email: JRogers@cdc.gov Tel: 770-488-4701 National Program of Cancer Registries (NPCR) Cancer Surveillance Branch (CSB) Division of Cancer Prevention and Control (DCPC) Centers for Disease Control and Prevention (CDC) Cancer Data Driving Action | www.cdc.gov/cancer/npcr/ |
Measuring progress. Targeting Action. |