Can't read CSV file outputted from ThunderSTORM

[kdwhitl]

I've been trying to localize single molecules with ThunderSTORM and then pass these coordinates to TrackMate to do the tracking (file: 220322_slide2_1_tSTORM.csv). But, I found that the csv file that's directly exported from ThunderSTORM can't be read by TrackMate CSV Importer. In the Import log, I get:

Parsing records.
Could not parse line 1. Malformed number, skipping.
For input string: "1.0" Could not parse line 2. Malformed number, skipping.
For input string: "1.0" Could not parse line 3. Malformed number, skipping.

...and so on for every line of the csv file.

I had a look at a previous discussion on a similar subject: https://forum.image.sc/t/sptpalm-using-thunderstorm-and-trackmate/26039. From that forum, I downloaded the csv file that user had shared (Trial1.csv) to have a look. This one imported completely fine, with no error!

When looking carefully at the two csv files (mine and Trial1.csv), they look like they have an identical format at first. But, @HoldenLab noticed one very subtle difference: in Trial1.csv, the columns for "id" and "frame" are integers, while in mine they are floating points.

I converted those two columns to integers via Matlab (as that's what I'm most familiar with), and then the file uploads perfectly well with the CSV Importer.

So, it seems to be a simple issue. Maybe something changed with how ThunderSTORM exports csv files? At any rate, it would be most helpful if the Importer can read the csv file that's outputted straight from ThunderSTORM without needing to reformat it.

For further context, here is some further information that is possibly relevant:

• OS: Windows 10
• FIJI/ImageJ: v1.53q
• ThunderSTORM: v1.3?
• TrackMate CSV Importer: v.3.1.1