Export produces bad csv formatting

[stappan]

please review this export (attached) . I exported this today, but if you look at the cells, there's bad formatting that is happening. Cell overrun?

the offending population is of course aacar-5 (statement 120).

export_v4-1-0_2025-04-11_19-22-42.csv

[ddelpiano]

@stappan could you please attach a screenshot of the problem you are seeing?
I just opened this with a csv editor and I don't see any problem with aacar 5, just extremely big cells but all looks correct at a quick glance. Thanks

[tgbugs]

When I'm using libre office calc I get an error The data could not be loaded completely because the maximum number of characters per cell was exceeded.. It is almost certainly the knowledge statement from aacar-5 and it leads to truncation of the rest of the row it seems.

Issue seems to be that Object Text is 109989 chars long and Neuron population label (A to B via C) is 109204 chars long for the aacar-5 rows.

I think the simplest fix is to export some sentinel value if things are too long. In the medium term splitting out the anatomical axioms from the others might help as well.

On the neurondm side I can process the file without issue and I won't be roundtripping those statements for the apinatomy populations anyway.

[stappan]

@ddelpiano please confirm your plans for this?

[stappan]

@ddelpiano please describe here what you did to fix this issue, and close this ticket. thanks!

[ddelpiano]

@stappan nothing has been done here so far, we need to schedule this in one of the sprints as we do for all other tasks. Thanks