[Loris-dev] Fixing multi-escaped special characters

[Rida Abou-Haidar]

Hi Eli,

In LORIS v22 I added a reported script that analyses if there are issues in
your instruments.

https://github.com/aces/Loris/pull/6477/files#diff-a943c6333454285d7b55ae4c9d792134

However the script that fixes all the issues requires some
customization per project and that's why it was not submitted to the repo.
Run the reporter first and see the extent of the damage, your options after
that are:

   1. fix the fields manually
   2. create your own little script to do it
   3. we send you the script of one of our projects and you modify it to
   work for you.

The reason the existing scripts need alterations is because projects have
the freedom to implement their instruments the way they want it, so it's
very difficult to make one script that works for all instruments on all
projects. There is also the extent of the damages that have to be
considered, in some projects the escaping happened so many times that the
data in the SQL table started getting truncated. I don't think it will be
the case for you because it happened because of a set of special
circumstances but seeing how much the data is affected can help identify
the best method for fixing the data.

Best,
Rida Abou-Haidar
Software Developer
Montreal Neurological Institute
McGill University
rida.abou-haidar at mcin.ca


On Tue, Jul 7, 2020 at 3:49 PM Eli Johnson <joh17964 at umn.edu> wrote:

> Hi,
>
> Is there any recommended method for identifying and fixing fields that
> have previously been saved with multi-escaped special characters, before
> the bugfix in v23.0 (issue #6223)? I have noticed affected fields in our
> database and was curious if anyone else had already cleaned their database
> and could advise.
>
> Thanks,
> Eli
>
> Eli Johnson
> Developer/Researcher
> Institute of Child Development
> University of Minnesota
> joh17964 at umn.edu
> _______________________________________________
> Loris-dev mailing list
> Loris-dev at bic.mni.mcgill.ca
> https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20200707/218a9ffd/attachment.html>