[Loris-dev] Change visit label

Wed Sep 8 11:50:17 EDT 2021

Dear Alfredo,

Indeed, the BIDS import script does not register any upload in the
mri_upload table as those are for DICOM files mainly (in the current setup).

The easiest way to remove the data would be manual unfortunately in your
case. I am guessing that no QC was attached to the inserted files, which
will make things easier for you.

To remove the images:
- find the FileID you want to delete in the files table
- Run `DELETE FROM parameter_file WHERE FileID IN (..., ..., ...)` (to
delete associated entries in the parameter_file table)
- Run `DELETE FROM files WHERE FileID IN (..., ..., ...)` (to delete file
entries in the files table)
- Ensure to remove the related files that have been copied into the
bids_import directory on the file system

One the images have been removed, you can then delete the visit from the
session table.

Hope this helps. Let me know how it goes or if you have any questions,

Cécile

On Tue, Sep 7, 2021 at 4:45 PM Morales Pinzon, Alfredo <
AMORALESPINZON at bwh.harvard.edu> wrote:

> Hi Nicolas,
>
> I am using the script “delete_imaging_upload.pl” to delete uploaded
> images into a visit. This script needs the uploadId of the images however
> for this study, which was uploaded using the BIDS insertion script, I
> cannot find the uploadIds. I usually find the uploadIds with the following
> SQL
>
> ===
> select UploadID from mri_upload where SessionID={SessionId};
> ===
>
> How can I remove the images or the visits?
>
> Best,
> Alfredo.
>
> On Sep 2, 2021, at 12:08 PM, Morales Pinzon, Alfredo <
> AMORALESPINZON at BWH.HARVARD.EDU> wrote:
>
>         External Email - Use Caution
>
> Hi Nicolas,
>
> Thank you. I will then delete and re-upload with the right visit label.
>
> Best,
> Alfredo.
>
> On Sep 1, 2021, at 4:36 PM, Nicolas Brossard <
> nicolasbrossard.mni at gmail.com> wrote:
>
>         External Email - Use Caution
>
> Hi Alfredo,
>
> I would remove the visits and re-upload the scans to the proper visit
> since the number of scans is low.
>
>
> Best,
> Nicolas
>
> On Wed, Sep 1, 2021 at 3:37 PM Morales Pinzon, Alfredo <
> AMORALESPINZON at bwh.harvard.edu> wrote:
>
>> Hi Nicolas,
>>
>> Here are the answer to the questions:
>>
>>
>> - How many images are we talking about?
>>
>>
>> 4 visits with around 4 images per visit
>>
>> - Is there behavioural data in the database for visit 'screening2'
>>
>>
>> No
>>
>> - You are supposed to set the patient name DICOM header of all the images
>> you inserted to <PSCID>_<CandID>_<Visit_label>. When you did that, did you
>> use the visit label 'screening' or 'screening2'?
>>
>>
>> I used the BIDS insertion script for these specific visits as the dataset
>> is in BIDS format.
>>
>> What is you suggestion?
>>
>> Best,
>> Alfredo.
>>
>> On Aug 31, 2021, at 3:00 PM, Nicolas Brossard <
>> nicolasbrossard.mni at gmail.com> wrote:
>>
>>         External Email - Use Caution
>>
>> Hi Alfredo,
>>
>> I need to ask you a few questions in order to provide the best solution:
>>
>> - How many images are we talking about?
>> - Is there behavioural data in the database for visit 'screening2'
>> - You are supposed to set the patient name DICOM header of all the images
>> you inserted to <PSCID>_<CandID>_<Visit_label>. When you did that, did you
>> use the visit label 'screening' or 'screening2'?
>>
>> I'll suggest something based on your answers.
>>
>>
>> Thanks!
>> Nicolas
>>
>>
>> On Mon, Aug 30, 2021 at 10:57 AM Morales Pinzon, Alfredo <
>> AMORALESPINZON at bwh.harvard.edu> wrote:
>>
>>> Dear LorisDev Team,
>>>
>>> By mistake I added images to a visit with label “screening2” instead of
>>> to the visit with label “screening”. Is it possible to change the visit
>>> label or I need to remove the visit and upload the images to the proper
>>> visit.
>>>
>>> Thank you in advance.
>>>
>>> Regards,
>>> Alfredo.
>>> The information in this e-mail is intended only for the person to whom
>>> it is addressed. If you believe this e-mail was sent to you in error and
>>> the e-mail contains patient information, please contact the Mass General
>>> Brigham Compliance HelpLine at
>>> http://www.massgeneralbrigham.org/complianceline
>>> <http://secure-web.cisco.com/1y5PBW7skD2grQZZ2Cx6GxLSQn516dgwLE8Q44oE__XNJhz4X-4FNe2wqTYOVfZTKDjcAb_x1fIRX-N_GGCsD8uLaq8x0vyPf8xAf9p7k5ZpZ8xI1IvRHshe5ffWWiw3He7m2wbr2G3ZmHzjpvMZ3YHxBFApyCU33IIcArRGNDUL2r3ZjPQrIq8S2uAv-236YmksiB36DIjOKlid-dn3bmCDshLhuDgtCn-10fjNV6_uPFl6Io_eZwLMS091409WIQZ-PD0V0eCyJ9QW4OJzORA/http%3A%2F%2Fwww.massgeneralbrigham.org%2Fcomplianceline>
>>> . If the e-mail was sent to you in error but does not contain patient
>>> information, please contact the sender and properly dispose of the e-mail.
>>> Please note that this e-mail is not secure (encrypted).  If you do not
>>> wish to continue communication over unencrypted e-mail, please notify the
>>> sender of this message immediately.  Continuing to send or respond to
>>> e-mail after receiving this message means you understand and accept this
>>> risk and wish to continue to communicate over unencrypted e-mail.
>>>
>>> _______________________________________________
>>> Loris-dev mailing list
>>> Loris-dev at bic.mni.mcgill.ca
>>> https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
>>> <https://secure-web.cisco.com/1ErJvwVr9ght-ZdXQnfIsa0qS_ryiQC98YD3qXVVtwwVOuQRfO444qDpHJ6rcS4JrHCpD-35FXEytMe56g5ejhGll8kSdUu5g1wdF_c8QiU3rutxCU8cEPJeFPi0GttPuUB5ypEtNidKoduGyOUWlawF1HGAgwpczZkC0T5sXnjeBJUyvpxCYZHfOggCe5KjTRbdWzT_R87Rj4-lmKuztXkfSBqFBFwApmVxrvmlBtUgYyigW4eEXrBE6WqbZicw9ZabMTSxtGLlJSZ2ZWKaITQ/https%3A%2F%2Fmailman.bic.mni.mcgill.ca%2Fmailman%2Flistinfo%2Floris-dev>
>>>
>>
>> The information in this e-mail is intended only for the person to whom it
>> is addressed. If you believe this e-mail was sent to you in error and the
>> e-mail contains patient information, please contact the Mass General
>> Brigham Compliance HelpLine at
>> http://www.massgeneralbrigham.org/complianceline
>> <http://secure-web.cisco.com/1vn0ZiKxTm2sy2RajDTvJyghmq_bdKypIE7Cy9OIYMbVK5y8WCpwCOEtbBhgojjD0FhXGDJVdtdK7m80sKcEimw6pbEJKycxTq8fQNgWkhfjO8Xu3DN5YQDWtptqLegYXzOuP88trqnVY9y5mbMDwhDxWAhOGLI-UVNTGpJhbnJvc02VpbIk9mUY7Km3T8hWGbi5ZqlA1O8mzdeDJTIQFS1gDXf8KncwNxY6iRlpBWxoelYKAQHwOrThlibMAbel85SgxpkHoCSljFzHyRazhCw/http%3A%2F%2Fwww.massgeneralbrigham.org%2Fcomplianceline>
>> . If the e-mail was sent to you in error but does not contain patient
>> information, please contact the sender and properly dispose of the e-mail.
>>
>> Please note that this e-mail is not secure (encrypted).  If you do not
>> wish to continue communication over unencrypted e-mail, please notify the
>> sender of this message immediately.  Continuing to send or respond to
>> e-mail after receiving this message means you understand and accept this
>> risk and wish to continue to communicate over unencrypted e-mail.
>>
>
> The information in this e-mail is intended only for the person to whom it
> is addressed. If you believe this e-mail was sent to you in error and the
> e-mail contains patient information, please contact the Mass General
> Brigham Compliance HelpLine at
> http://www.massgeneralbrigham.org/complianceline . If the e-mail was sent
> to you in error but does not contain patient information, please contact
> the sender and properly dispose of the e-mail.
>
> Please note that this e-mail is not secure (encrypted).  If you do not
> wish to continue communication over unencrypted e-mail, please notify the
> sender of this message immediately.  Continuing to send or respond to
> e-mail after receiving this message means you understand and accept this
> risk and wish to continue to communicate over unencrypted e-mail.
> _______________________________________________
> Loris-dev mailing list
> Loris-dev at bic.mni.mcgill.ca
>
> https://secure-web.cisco.com/1jqhRt_by2nFbUhOQm9zVI1XxT-HwfvUQpV8-GuXYNwUfxpgj-K2GI8WDD1a7UDFZObPi0cOs3QckK47y43l7aE6jeiYURTbUi2hFh1Q5Gbb7f9UtjZfQRwpfWKfComUV_Tm_9z9ySQJ7sYL5kOvESaD5yG71XLe41Oz4zU94eL1aL7ISUKE7V77na0yATArwJsX2U5z-ArOyyQ64-HAiWtOHnyHtlcV1lWqr7C-tKltDJq_YS4L8UYOfsboj95GI-tV8OeHJZ4EmwDQAHjqwTQ/https%3A%2F%2Fmailman.bic.mni.mcgill.ca%2Fmailman%2Flistinfo%2Floris-dev
>
>
> The information in this e-mail is intended only for the person to whom it
> is addressed. If you believe this e-mail was sent to you in error and the
> e-mail contains patient information, please contact the Mass General
> Brigham Compliance HelpLine at
> http://www.massgeneralbrigham.org/complianceline . If the e-mail was sent
> to you in error but does not contain patient information, please contact
> the sender and properly dispose of the e-mail.
>
> Please note that this e-mail is not secure (encrypted).  If you do not
> wish to continue communication over unencrypted e-mail, please notify the
> sender of this message immediately.  Continuing to send or respond to
> e-mail after receiving this message means you understand and accept this
> risk and wish to continue to communicate over unencrypted e-mail.
> _______________________________________________
> 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/20210908/1cf0689a/attachment.html>