[Loris-dev] [IPMSA project] LORIS missing updates in assign_missing_instruments.php

[Morales Pinzon, Alfredo]

Dear LORIS-dev team,

In the IPMSA project we are batch inserting the clinical data. I am following the steps suggested by Rida, that I successfully used for a first study but now I am stuck in one of the steps. In that step I call the script "assign_missing_instruments.php" to assign missing instruments in the system. Using the script without the option "confirm", the output is telling me that only 1053 out of the expected 32338 visits are going to be created. Could you help understanding where is the problem or if the script I am missing something? What I can see is that script is only generating the changes for 2 out the new 83 visit labels.

 Here is the steps I have for the uploading process of clinical data, I am stuck in step number 8:


1. Generate the labels of the visits in the system (successfully done  - 83 new visit labels)
  a. Modify the file config.xml
  b. Run the script "php populate_visit_windows.php"

2. Populate the table "test_battery" (successfully done: 678 new entries were added.)
  a. For each visit a set of instruments is assigned.

3. Check the state of tables
  - session: 31027 rows
  - flad: 275176 rows

4. Create the visits using the LORIS-API (successfully done: 32345 visits were created.)
  - table "session" has now "63372" rows (32345 = 31027 previous rows + 32345 new rows)

5. Check state of "session" table (17246 entries are "In progress")
  - select count(*) from session where Visit='In Progress';

6. Hack the session table (successfully done: 32345 rows were updated )
  a. Update each new row in the session table (32345 new rows) like this:
  UPDATE session SET Visit='In Progress',Scan_done='N',Current_stage='Visit',Date_stage_change='2010-12-24',Date_visit='2010-12-24' WHERE Visit_label='VISIT_LABEL' AND CandID=123456;

7. Check state of "session" table (49584 entries are "In progress", 49584 = 17246 old entries + 32338 new entries) [7 entries were not updated for missing date]
  - select count(*) from session where Visit='In Progress';

8. Run php assign missing instruments
  - When running assign_missing_instruments.php with no arguments I get 1053 changes but I should get 32338 changes. The changes are pointing to only 2 out of the new 83 visit labels.

9. Insert instrument-visit information

10. Add "Candidate" information


Thank you very much for help. Let me know if you need more details from my side.

Best 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 Partners Compliance HelpLine at
http://www.partners.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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20190219/3160afdd/attachment.html>