CPT4 sample download for testing

Implementers
1

Hi all,

I’m trying to test the CPT4 update process using a smaller dataset. I have a concept.csv file in my temp folder, and when I attempt to process the full concept_cpt4.csv file, it takes an extremely long time — sometimes over two days.

To speed up testing, I want to try the process with just a few records (e.g., 20 rows from concept_cpt4.csv). I attempted to manually reduce the file by copying a few records and converting them to comma-separated format using Excel, but the process keeps failing with the following error:

java.lang.NullPointerException: Cannot invoke "java.lang.Integer.intValue()" because "this.conceptIdIndex" is null

It seems like the Java program can’t find the concept_id column due to formatting issues.

Can anyone advise on the correct way to prepare a small, valid subset of the CPT4 data so I can confirm the process works before running the full import?

Thanks in advance!

2

Hi @banjawd, sounds like the error is from a formatting issue.

Try this:
Open the original concept, cpt4.csv, in a text editor (like Notepad++), copy the header and 20 full rows, and save that as a new CSV file. Don’t use Excel, it can mess up the format.

Make sure the concept, ID column is included and that all columns match the original order.

That should fix the conceptIdIndex null error.

1 Like
3

Hi @banjawd

Sometimes the error is on the UMLS side, but it does sound strange.

Is there any chance you are using old CPT4.jar? We updated it during the last release and it should now run within seconds (well, sometimes minutes), but not hours and days like it was before.