…9784)

This change modifies the transformation of csvData in the DataTable
component by replacing .flatMap() with .map().
• Before: csvData was a flattened array of mapped cells across all
fields and rows.
• After: csvData is now a nested array (Array<Array<Cell>>), preserving
the structure of rows.
• This aligns better with expected downstream usage or fixes unintended
flattening issues in CSV processing.

Tests were not running because of the (unseen) error:

"[Warning] Aborted connection 21 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.5' (This connection closed normally without authentication)"

MariaDB 10.5 has removed or tightened several legacy permission
behaviors.

…9786)

When declared as single the dataquery module does not allow to choose the option
"is empty" in the filter. Since a visit may not have the instrument as part of its battery,
it should be OPTIONAL, and not SINGLE.

Some fixes that were necessary on CBIG to be able to build the
dictionary

1. ignore .meta fields for LINST files
2. re-add DATA ENTRY common filed to all instruments
3. make the script runnable from anywhere

This fixes the generate external IDs script to be runnable on 26
(mainly creating site and project objects). It also excludes scanners
from the genration since the regular pipeline adding the scanners does
it while bypassing the external ID generation (i.e. designed to be null)

[test] fix CI 26.0 failure

Co-authored-by: Dave MacFarlane <dave.macfarlane@mcin.ca>