Task #1674
Updated by Lukas Vonlanthen about 8 years ago
* Main contributor of QA should be the compiler in QCAT
* On qa.wocat.net: 55 QAs listed with main contributor "Not registered".
<pre>165, 162, 161, 160, 159, 156, 155, 154, 153, 152, 151, 150, 148, 147, 145, 281, 282, 146, 142, 133, 124, 123, 119, 279, 280, 109, 108, 184, 107, 106, 105, 104, 276, 277, 103, 102, 101, 100, 99, 97, 96, 94, 93, 91, 90, 89, 74, 331, 361, 274, 275, 69, 68, 67, 66</pre>
* In DB, 46 QAs have main_contributor = 661 (Philippe Zahner) (*)
<pre>SELECT * FROM qa.approach WHERE main_contributor=661;</pre>
* In DB, 41 QAs have owner_id = 133 (Carin Pretorius)
<pre>SELECT * FROM qa.approach WHERE owner_id=133;</pre>
* (*) In DB, the entry in qa_text with id 661 is "Not registered"
<pre>SELECT * FROM qa.qa_text WHERE id=661;</pre>
* All 46 QAs with main_contributor = 661 are part of the 55 QAs listed as with main contributor "Not registered" on qa.wocat.net
**Decision**: Questionnaires with main_contributor = 661 (as in the text lookup for "Not registered") will be assigned to a generic user (example: "WOCAT Secretariat", to be discussed and created) during import.