Difference between revisions of "Workdocumentation 2020-08-26"
Heike.Rohde (talk | contribs) (→Betroffene Events) |
|||
(42 intermediate revisions by 4 users not shown) | |||
Line 19: | Line 19: | ||
{|- class='wikitable sortable' | {|- class='wikitable sortable' | ||
|- | |- | ||
− | ! acronym !! events !! anzahl | + | ! acronym !! events !! anzahl !!erledigt |
|- | |- | ||
− | | (null) || (null) ||809 | + | | (null) || (null) ||809 || |
|- | |- | ||
− | | [[ACAH 2013]] ||{{#ask:[[Acronym::ACAH 2013]]}} ||2 | + | | [[ACAH 2013]] ||{{#ask:[[Acronym::ACAH 2013]]}} ||2 ||v |
|- | |- | ||
− | | [[ACERP 2013]] ||{{#ask:[[Acronym::ACERP 2013]]}} ||2 | + | | [[ACERP 2013]] ||{{#ask:[[Acronym::ACERP 2013]]}} ||2 ||v |
|- | |- | ||
− | | [[ACP 2013]] ||{{#ask:[[Acronym::ACP 2013]]}} ||2 | + | | [[ACP 2013]] ||{{#ask:[[Acronym::ACP 2013]]}} ||2 || v |
|- | |- | ||
− | | [[BIOSIGNALS 2009]] ||{{#ask:[[Acronym::BIOSIGNALS 2009]]}} ||2 | + | | [[BIOSIGNALS 2009]] ||{{#ask:[[Acronym::BIOSIGNALS 2009]]}} ||2 ||v |
|- | |- | ||
− | | [[BIOSIGNALS 2012]] ||{{#ask:[[Acronym::BIOSIGNALS 2012]]}} ||2 | + | | [[BIOSIGNALS 2012]] ||{{#ask:[[Acronym::BIOSIGNALS 2012]]}} ||2 ||v |
|- | |- | ||
− | | [[CAADRIA 2019]] ||{{#ask:[[Acronym::CAADRIA 2019]]}} ||2 | + | | [[CAADRIA 2019]] ||{{#ask:[[Acronym::CAADRIA 2019]]}} ||2 ||v |
|- | |- | ||
− | | [[CADE 2017]] ||{{#ask:[[Acronym::CADE 2017]]}} ||2 | + | | [[CADE 2017]] ||{{#ask:[[Acronym::CADE 2017]]}} ||2 ||v |
|- | |- | ||
− | | [[CAiSE 2017]] ||{{#ask:[[Acronym::CAiSE 2017]]}} ||2 | + | | [[CAiSE 2017]] ||{{#ask:[[Acronym::CAiSE 2017]]}} ||2 ||v |
|- | |- | ||
− | | [[EDBT 2008]] ||{{#ask:[[Acronym::EDBT 2008]]}} ||2 | + | | [[EDBT 2008]] ||{{#ask:[[Acronym::EDBT 2008]]}} ||2 ||(sind zwei verschiedene Veranstaltungen) |
|- | |- | ||
− | | [[ESWC 2016]] ||{{#ask:[[Acronym::ESWC 2016]]}} ||2 | + | | [[ESWC 2016]] ||{{#ask:[[Acronym::ESWC 2016]]}} ||2 ||v |
|- | |- | ||
− | | [[Gift-ACLA 2017]] ||{{#ask:[[Acronym::Gift-ACLA 2017]]}} ||2 | + | | [[Gift-ACLA 2017]] ||{{#ask:[[Acronym::Gift-ACLA 2017]]}} ||2 ||(erst ACLA 2017 löschen, dann Gift-ACLA 2017 verschieben, funktioniert nicht) |
|- | |- | ||
− | | [[HFR 2017]] ||{{#ask:[[Acronym::HFR 2017]]}} ||2 | + | | [[HFR 2017]] ||{{#ask:[[Acronym::HFR 2017]]}} ||2 || HFR 2017 : 10. Inter ... im Akronym, löschen nicht möglich, ist doppelt zu HFR 2017) |
|- | |- | ||
− | | [[ICADL 2018]] ||{{#ask:[[Acronym::ICADL 2018]]}} ||2 | + | | [[ICADL 2018]] ||{{#ask:[[Acronym::ICADL 2018]]}} ||2 ||v |
|- | |- | ||
− | | [[ICBSB 2017]] ||{{#ask:[[Acronym::ICBSB 2017]]}} ||2 | + | | [[ICBSB 2017]] ||{{#ask:[[Acronym::ICBSB 2017]]}} ||2 ||(Nicht löschbare doppelte Einträge) |
|- | |- | ||
− | | [[ICC 2009]] ||{{#ask:[[Acronym::ICC 2009]]}} ||2 | + | | [[ICC 2009]] ||{{#ask:[[Acronym::ICC 2009]]}} ||2 ||v |
|- | |- | ||
− | | [[ICEDEG 2017]] ||{{#ask:[[Acronym::ICEDEG 2017]]}} ||2 | + | | [[ICEDEG 2017]] ||{{#ask:[[Acronym::ICEDEG 2017]]}} ||2 ||v |
|- | |- | ||
− | | [[ICIAR 2011 SS]] ||{{#ask:[[Acronym::ICIAR 2011 SS]]}} ||2 | + | | [[ICIAR 2011 SS]] ||{{#ask:[[Acronym::ICIAR 2011 SS]]}} ||2 ||v |
|- | |- | ||
− | | [[ICIS 2016]] ||{{#ask:[[Acronym::ICIS 2016]]}} ||2 | + | | [[ICIS 2016]] ||{{#ask:[[Acronym::ICIS 2016]]}} ||2 ||(sind zwei verschied. Veranstaltungen) |
|- | |- | ||
− | | [[ICRE 2017]] ||{{#ask:[[Acronym::ICRE 2017]]}} ||2 | + | | [[ICRE 2017]] ||{{#ask:[[Acronym::ICRE 2017]]}} ||2 ||(Nicht löschbare doppelte Einträge) |
|- | |- | ||
− | | [[ICSC 2018]] ||{{#ask:[[Acronym::ICSC 2018]]}} ||2 | + | | [[ICSC 2018]] ||{{#ask:[[Acronym::ICSC 2018]]}} ||2 ||v,(sind zwei verschied. Veranstaltungen) |
|- | |- | ||
− | | [[IEEE SCPA 2012]] ||{{#ask:[[Acronym::IEEE SCPA 2012]]}} ||2 | + | | [[IEEE SCPA 2012]] ||{{#ask:[[Acronym::IEEE SCPA 2012]]}} ||2 ||v, heißt jetzt SCPA 2012 |
|- | |- | ||
− | | [[IJCSI-March-2011]] ||{{#ask:[[Acronym::IJCSI-March-2011]]}} ||3 | + | | [[IJCSI-March-2011]] ||{{#ask:[[Acronym::IJCSI-March-2011]]}} ||3 ||(da alles drei CFPs und keine Konferenzen sind, wie besprochen zu CFPs geändert) |
|- | |- | ||
− | | [[IJCSIS 2009]] ||{{#ask:[[Acronym::IJCSIS 2009]]}} ||2 | + | | [[IJCSIS 2009]] ||{{#ask:[[Acronym::IJCSIS 2009]]}} ||2 ||(sind beides Einträge für Zeitschriften) |
|- | |- | ||
− | | [[IMECS 2012]] ||{{#ask:[[Acronym::IMECS 2012]]}} ||2 | + | | [[IMECS 2012]] ||{{#ask:[[Acronym::IMECS 2012]]}} ||2 ||v |
|- | |- | ||
− | | [[ISEC 2013]] ||{{#ask:[[Acronym::ISEC 2013]]}} ||2 | + | | [[ISEC 2013]] ||{{#ask:[[Acronym::ISEC 2013]]}} ||2 ||v |
|- | |- | ||
− | | [[ISUVR 2009]] ||{{#ask:[[Acronym::ISUVR 2009]]}} ||2 | + | | [[ISUVR 2009]] ||{{#ask:[[Acronym::ISUVR 2009]]}} ||2 ||v |
|- | |- | ||
− | | [[ISWC 2017]] ||{{#ask:[[Acronym::ISWC 2017]]}} ||2 | + | | [[ISWC 2017]] ||{{#ask:[[Acronym::ISWC 2017]]}} ||2 ||v |
|- | |- | ||
− | | [[JIST 2017]] ||{{#ask:[[Acronym::JIST 2017]]}} ||2 | + | | [[JIST 2017]] ||{{#ask:[[Acronym::JIST 2017]]}} ||2 || (Nicht löschbare doppelte Einträge) |
|- | |- | ||
− | | [[KES AMSTA 2010]] ||{{#ask:[[Acronym::KES AMSTA 2010]]}} ||2 | + | | [[KES AMSTA 2010]] ||{{#ask:[[Acronym::KES AMSTA 2010]]}} ||2 ||v |
|- | |- | ||
− | | [[KMIS]] ||{{#ask:[[Acronym::KMIS]]}} ||2 | + | | [[KMIS]] ||{{#ask:[[Acronym::KMIS]]}} ||2 ||v |
|- | |- | ||
− | | [[NASSUE 2009]] ||{{#ask:[[Acronym::NASSUE 2009]]}} ||2 | + | | [[NASSUE 2009]] ||{{#ask:[[Acronym::NASSUE 2009]]}} ||2 ||v |
|- | |- | ||
− | | [[OpenSuCo @ SC 2017]] ||{{#ask:[[Acronym::OpenSuCo @ SC 2017]]}} ||2 | + | | [[OpenSuCo @ SC 2017]] ||{{#ask:[[Acronym::OpenSuCo @ SC 2017]]}} ||2 || (Nicht löschbare doppelte Einträge) |
|- | |- | ||
− | | [[PSATS 2012]] ||{{#ask:[[Acronym::PSATS 2012]]}} ||2 | + | | [[PSATS 2012]] ||{{#ask:[[Acronym::PSATS 2012]]}} ||2 ||v |
|- | |- | ||
− | | [[RTAS 2020]] ||{{#ask:[[Acronym::RTAS 2020]]}} ||2 | + | | [[RTAS 2020]] ||{{#ask:[[Acronym::RTAS 2020]]}} ||2 ||v |
|- | |- | ||
− | | [[SCIPCV 2010]] ||{{#ask:[[Acronym::SCIPCV 2010]]}} ||2 | + | | [[SCIPCV 2010]] ||{{#ask:[[Acronym::SCIPCV 2010]]}} ||2 ||v |
|- | |- | ||
− | | [[SCIPCV 2011]] ||{{#ask:[[Acronym::SCIPCV 2011]]}} ||3 | + | | [[SCIPCV 2011]] ||{{#ask:[[Acronym::SCIPCV 2011]]}} ||3 ||v |
|- | |- | ||
− | | [[SETN 2010]] ||{{#ask:[[Acronym::SETN 2010]]}} ||2 | + | | [[SETN 2010]] ||{{#ask:[[Acronym::SETN 2010]]}} ||2 ||v |
|- | |- | ||
− | | [[STIDS 2016]] ||{{#ask:[[Acronym::STIDS 2016]]}} ||2 | + | | [[STIDS 2016]] ||{{#ask:[[Acronym::STIDS 2016]]}} ||2 ||v |
|- | |- | ||
− | | [[Science in Society Conference 2011]] ||{{#ask:[[Acronym::Science in Society Conference 2011]]}} ||2 | + | | [[Science in Society Conference 2011]] ||{{#ask:[[Acronym::Science in Society Conference 2011]]}} ||2 ||v, heißt jetzt [[Science in Society 2011]] |
|- | |- | ||
− | | [[VC 2009]] ||{{#ask:[[Acronym::VC 2009]]}} ||3 | + | | [[VC 2009]] ||{{#ask:[[Acronym::VC 2009]]}} ||3 ||v |
|- | |- | ||
− | | [[WACV 2017]] ||{{#ask:[[Acronym::WACV 2017]]}} ||2 | + | | [[WACV 2017]] ||{{#ask:[[Acronym::WACV 2017]]}} ||2 ||v |
|- | |- | ||
− | | [[WCE 2011]] ||{{#ask:[[Acronym::WCE 2011]]}} ||2 | + | | [[WCE 2011]] ||{{#ask:[[Acronym::WCE 2011]]}} ||2 ||v |
|- | |- | ||
− | | [[WCE 2012]] ||{{#ask:[[Acronym::WCE 2012]]}} ||2 | + | | [[WCE 2012]] ||{{#ask:[[Acronym::WCE 2012]]}} ||2 ||v |
|- | |- | ||
− | | [[WCECS 2012]] ||{{#ask:[[Acronym::WCECS 2012]]}} ||2 | + | | [[WCECS 2012]] ||{{#ask:[[Acronym::WCECS 2012]]}} ||2 ||v |
|- | |- | ||
− | | [[WISE 2013]] ||{{#ask:[[Acronym::WISE 2013]]}} ||2 | + | | [[WISE 2013]] ||{{#ask:[[Acronym::WISE 2013]]}} ||2 ||v |
|- | |- | ||
− | | [[WWW 2011]] ||{{#ask:[[Acronym::WWW 2011]]}} ||4 | + | | [[WWW 2011]] ||{{#ask:[[Acronym::WWW 2011]]}} ||4 ||v |
|} | |} | ||
+ | |||
= Sehr lange Acronyme = | = Sehr lange Acronyme = | ||
== SQL Query == | == SQL Query == |
Latest revision as of 17:53, 15 October 2020
Contents
Acronyme, die für mehrere Events verwendet wurden
Beispiel:
{{#ask:[[Acronym::WWW 2011]]}}
SQL-Query
sqlite3 Datenbank von http://ptp.bitplan.com verwendet ...
select '|-n| [[' || acronym || ']]' as acronym, '||{{#ask:[[Acronym::' || acronym || ']]}}' as events, '||' || count(*) as anzahl from event_or group by acronym having(count(*)>1) order by acronym
-n muss noch mit editor auf "\n" geändert werden damit die Tabelle unten gefüllt werden kann:
Betroffene Events
Sehr lange Acronyme
SQL Query
select '|-n| [[' || acronym || ']]' as acronym, '||[[:' || title || ']]' as event, '||' || length(acronym) as acronymLen from event_or order by length(acronym) desc limit 150