ui-icts / redcap-admin-dashboard

Provides a sortable table view of various reports on REDCap metadata
MIT License
2 stars 2 forks source link

Admin Dashboard fails if the delimiter for csv is configured to semicolon #24

Open AlexandreDu45 opened 1 month ago

AlexandreDu45 commented 1 month ago

Hello everyone,

We experienced a bug with the Admin Dashboard external module. image1

We noticed this difference in the column name results when testing the query:

REDCap instance in which the module works: image2

REDCap instance in which the module does not work: image3

And we found the difference. The "redcapDataEntryForm.js" file handles the return from the "Database Query Tool" taking into account only the comma "," as the data delimiter. If the user has changed the delimiter to a semicolon ";" (in my case), the error will be generated. image4

Ideally, the external module would have this information in the documentation or implement obtaining the delimiter from the user profile.

Thank you,

Alexandre