Null name column issue in 1.4.3 will result in Java Number Format Error

[lofung]

As forum post in june 2021.

https://forums.ohdsi.org/t/usagi-java-number-format-error/11395

a null name forum as like

code, details, , ,, , , , test

seems to result in java.lang.NumberFormatException: For Input string: “”

[MaximMoinat]

The way I could reproduce the error, was to import a file with empty cells in the frequency column (or when the input has a completely empty row). Usagi tries to convert the empty string to a number, which fails. To fix this, I suggest we assign a frequency of 1 to any missing frequencies.

@lofung can you check that this is indeed the issue with your input file? e.g. by using the same file, but not importing the frequency column. I can't reproduce issues with empty column names.

[lofung]

it seems it has to do with the "header" columns, aka first column of the txt that contains the column titles. I have further find another issue today. It seems that either it cannot do with null or "space char" character

result in java.lang.NumberFormatException: For Input string: “”
both results in

[MaximMoinat]

@lofung I was not able to reproduce an issue with empty header cells. Could you share the file you are trying to import?