CINXE.COM

<!DOCTYPE html> <html class="client-nojs" lang="de" dir="ltr"> <head> <meta charset="UTF-8"> <title>Wikipedia:WikiProjekt Vorlagenauswertung/en – Wikipedia</title> <script>(function(){var className="client-js";var cookie=document.cookie.match(/(?:^|; )dewikimwclientpreferences=([^;]+)/);if(cookie){cookie[1].split('%2C').forEach(function(pref){className=className.replace(new RegExp('(^| )'+pref.replace(/-clientpref-\w+$|[^\w-]+/g,'')+'-clientpref-\\w+( |$)'),'$1'+pref+'$2');});}document.documentElement.className=className;}());RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":[",\t.",".\t,"],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy","wgMonthNames":["","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"],"wgRequestId":"80070586-4379-42c6-a694-a12d1416e350","wgCanonicalNamespace":"Project","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":4,"wgPageName":"Wikipedia:WikiProjekt_Vorlagenauswertung/en","wgTitle":"WikiProjekt Vorlagenauswertung/en","wgCurRevisionId":223606619,"wgRevisionId":223606619,"wgArticleId":2372190,"wgIsArticle":true,"wgIsRedirect":false,"wgAction": "view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["Wikipedia:Internes WikiProjekt"],"wgPageViewLanguage":"de","wgPageContentLanguage":"de","wgPageContentModel":"wikitext","wgRelevantPageName":"Wikipedia:WikiProjekt_Vorlagenauswertung/en","wgRelevantArticleId":2372190,"wgIsProbablyEditable":true,"wgRelevantPageIsProbablyEditable":true,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgNoticeProject":"wikipedia","wgCiteReferencePreviewsActive":true,"wgFlaggedRevsParams":{"tags":{"accuracy":{"levels":1}}},"wgMediaViewerOnClick":true,"wgMediaViewerEnabledByDefault":true,"wgPopupsFlags":0,"wgVisualEditor":{"pageLanguageCode":"de","pageLanguageDir":"ltr","pageVariantFallbacks":"de"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":true,"nearby":true},"wgWMESchemaEditAttemptStepOversample":false,"wgWMEPageLength":8000,"wgRelatedArticlesCompat":[],"wgCentralAuthMobileDomain":false,"wgEditSubmitButtonLabelPublish":true,"wgDiscussionToolsFeaturesEnabled":{ "replytool":true,"newtopictool":true,"sourcemodetoolbar":true,"topicsubscription":false,"autotopicsub":false,"visualenhancements":false,"visualenhancements_reply":false,"visualenhancements_pageframe":false},"wgDiscussionToolsFallbackEditMode":"visual","wgULSPosition":"interlanguage","wgULSisCompactLinksEnabled":true,"wgVector2022LanguageInHeader":false,"wgULSisLanguageSelectorEmpty":false,"wgWikibaseItemId":"Q66458694","wgCheckUserClientHintsHeadersJsApi":["brands","architecture","bitness","fullVersionList","mobile","model","platform","platformVersion"],"GEHomepageSuggestedEditsEnableTopics":true,"wgGETopicsMatchModeEnabled":false,"wgGEStructuredTaskRejectionReasonTextInputEnabled":false,"wgGELevelingUpEnabledForUser":false};RLSTATE={"ext.gadget.citeRef":"ready","ext.gadget.defaultPlainlinks":"ready","ext.gadget.dewikiCommonHide":"ready","ext.gadget.dewikiCommonLayout":"ready","ext.gadget.dewikiCommonStyle":"ready","ext.gadget.NavFrame":"ready","ext.globalCssJs.user.styles":"ready", "site.styles":"ready","user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"loading","ext.discussionTools.init.styles":"ready","oojs-ui-core.styles":"ready","oojs-ui.styles.indicators":"ready","mediawiki.widgets.styles":"ready","oojs-ui-core.icons":"ready","skins.vector.styles.legacy":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","codex-search-styles":"ready","ext.uls.interlanguage":"ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["mediawiki.page.media","site","mediawiki.page.ready","mediawiki.toc","skins.vector.legacy.js","ext.centralNotice.geoIP","ext.centralNotice.startUp","ext.gadget.easyNewSection","ext.gadget.WikiMiniAtlas","ext.gadget.OpenStreetMap","ext.gadget.CommonsDirekt","ext.gadget.donateLink","ext.urlShortener.toolbar","ext.centralauth.centralautologin","mmv.bootstrap","ext.popups","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.echo.centralauth", "ext.discussionTools.init","ext.eventLogging","ext.wikimediaEvents","ext.navigationTiming","ext.uls.compactlinks","ext.uls.interface","ext.cx.eventlogging.campaigns","ext.checkUser.clientHints","wikibase.sidebar.tracking"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.impl(function(){return["user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"}); }];});});</script> <link rel="stylesheet" href="/w/load.php?lang=de&modules=codex-search-styles%7Cext.discussionTools.init.styles%7Cext.uls.interlanguage%7Cext.visualEditor.desktopArticleTarget.noscript%7Cext.wikimediaBadges%7Cmediawiki.widgets.styles%7Coojs-ui-core.icons%2Cstyles%7Coojs-ui.styles.indicators%7Cskins.vector.styles.legacy%7Cwikibase.client.init&only=styles&skin=vector"> <script async="" src="/w/load.php?lang=de&modules=startup&only=scripts&raw=1&skin=vector"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=de&modules=ext.gadget.NavFrame%2CciteRef%2CdefaultPlainlinks%2CdewikiCommonHide%2CdewikiCommonLayout%2CdewikiCommonStyle&only=styles&skin=vector"> <link rel="stylesheet" href="/w/load.php?lang=de&modules=site.styles&only=styles&skin=vector"> <meta name="generator" content="MediaWiki 1.44.0-wmf.4"> <meta name="referrer" content="origin"> <meta name="referrer" content="origin-when-cross-origin"> <meta name="robots" content="max-image-preview:standard"> <meta name="format-detection" content="telephone=no"> <meta name="viewport" content="width=1120"> <meta property="og:title" content="Wikipedia:WikiProjekt Vorlagenauswertung/en – Wikipedia"> <meta property="og:type" content="website"> <link rel="preconnect" href="//upload.wikimedia.org"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//de.m.wikipedia.org/wiki/Wikipedia:WikiProjekt_Vorlagenauswertung/en"> <link rel="alternate" type="application/x-wiki" title="Seite bearbeiten" href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit"> <link rel="apple-touch-icon" href="/static/apple-touch/wikipedia.png"> <link rel="icon" href="/static/favicon/wikipedia.ico"> <link rel="search" type="application/opensearchdescription+xml" href="/w/rest.php/v1/search" title="Wikipedia (de)"> <link rel="EditURI" type="application/rsd+xml" href="//de.wikipedia.org/w/api.php?action=rsd"> <link rel="canonical" href="https://de.wikipedia.org/wiki/Wikipedia:WikiProjekt_Vorlagenauswertung/en"> <link rel="license" href="https://creativecommons.org/licenses/by-sa/4.0/deed.de"> <link rel="alternate" type="application/atom+xml" title="Atom-Feed für „Wikipedia“" href="/w/index.php?title=Spezial:Letzte_%C3%84nderungen&feed=atom"> <link rel="dns-prefetch" href="//meta.wikimedia.org" /> <link rel="dns-prefetch" href="//login.wikimedia.org"> </head> <body class="ext-discussiontools-replytool-enabled ext-discussiontools-newtopictool-enabled ext-discussiontools-sourcemodetoolbar-enabled skin-vector-legacy mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-4 ns-subject mw-editable page-Wikipedia_WikiProjekt_Vorlagenauswertung_en rootpage-Wikipedia_WikiProjekt_Vorlagenauswertung skin-vector action-view"><div id="mw-page-base" class="noprint"></div> <div id="mw-head-base" class="noprint"></div> <div id="content" class="mw-body" role="main"> <a id="top"></a> <div id="siteNotice"></div> <div class="mw-indicators"> </div> <h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-namespace">Wikipedia</span><span class="mw-page-title-separator">:</span><span class="mw-page-title-main">WikiProjekt Vorlagenauswertung/en</span></h1> <div id="bodyContent" class="vector-body"> <div id="siteSub" class="noprint">aus Wikipedia, der freien Enzyklopädie</div> <div id="contentSub"><div id="mw-content-subtitle"><div class="subpages">< <bdi dir="ltr"><a href="/wiki/Wikipedia:WikiProjekt_Vorlagenauswertung" title="Wikipedia:WikiProjekt Vorlagenauswertung">Wikipedia:WikiProjekt Vorlagenauswertung</a></bdi></div></div></div> <div id="contentSub2"></div> <div id="jump-to-nav"></div> <a class="mw-jump-link" href="#mw-head">Zur Navigation springen</a> <a class="mw-jump-link" href="#searchInput">Zur Suche springen</a> <div id="mw-content-text" class="mw-body-content"><div class="mw-content-ltr mw-parser-output" lang="de" dir="ltr"><p><b>Diese Seite auf Deutsch</b>: <a href="/wiki/Wikipedia:WikiProjekt_Vorlagenauswertung" title="Wikipedia:WikiProjekt Vorlagenauswertung">Wikipedia:WikiProjekt Vorlagenauswertung</a> </p><p>This project (Codename: <i>Templatetiger</i>) extracts all templates from the database dump. It intends to analyse the variable values contained in the templates and represent them in new ways, apply filters and do other useful stuff. </p><p><b>Startpage: <a class="external free" href="https://iw.toolforge.org/templatetiger">https://iw.toolforge.org/templatetiger</a></b> </p> <figure typeof="mw:File/Thumb"><a href="/wiki/Datei:Templatetiger1.png" class="mw-file-description"><img src="//upload.wikimedia.org/wikipedia/commons/thumb/6/6d/Templatetiger1.png/300px-Templatetiger1.png" decoding="async" width="300" height="184" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/6/6d/Templatetiger1.png/450px-Templatetiger1.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/6/6d/Templatetiger1.png/600px-Templatetiger1.png 2x" data-file-width="1085" data-file-height="667"/></a><figcaption>Screenshot</figcaption></figure> <div id="toc" class="toc" role="navigation" aria-labelledby="mw-toc-heading"><input type="checkbox" role="button" id="toctogglecheckbox" class="toctogglecheckbox" style="display:none" /><div class="toctitle" lang="de" dir="ltr"><h2 id="mw-toc-heading">Inhaltsverzeichnis</h2><span class="toctogglespan"><label class="toctogglelabel" for="toctogglecheckbox"></label></span></div> <ul> <li class="toclevel-1 tocsection-1"><a href="#Objectives"><span class="tocnumber">1</span> <span class="toctext">Objectives</span></a></li> <li class="toclevel-1 tocsection-2"><a href="#Use"><span class="tocnumber">2</span> <span class="toctext">Use</span></a> <ul> <li class="toclevel-2 tocsection-3"><a href="#Template_selection"><span class="tocnumber">2.1</span> <span class="toctext">Template selection</span></a></li> <li class="toclevel-2 tocsection-4"><a href="#Table_display"><span class="tocnumber">2.2</span> <span class="toctext">Table display</span></a></li> <li class="toclevel-2 tocsection-5"><a href="#Regular_expressions"><span class="tocnumber">2.3</span> <span class="toctext">Regular expressions</span></a> <ul> <li class="toclevel-3 tocsection-6"><a href="#Negating_the_query"><span class="tocnumber">2.3.1</span> <span class="toctext">Negating the query</span></a></li> <li class="toclevel-3 tocsection-7"><a href="#Sorting_the_result"><span class="tocnumber">2.3.2</span> <span class="toctext">Sorting the result</span></a></li> <li class="toclevel-3 tocsection-8"><a href="#Selection_of_Columns"><span class="tocnumber">2.3.3</span> <span class="toctext">Selection of Columns</span></a></li> <li class="toclevel-3 tocsection-9"><a href="#Change_of_line_count"><span class="tocnumber">2.3.4</span> <span class="toctext">Change of line count</span></a></li> </ul> </li> <li class="toclevel-2 tocsection-10"><a href="#Re-use_of_data_in_spreadsheets"><span class="tocnumber">2.4</span> <span class="toctext">Re-use of data in spreadsheets</span></a> <ul> <li class="toclevel-3 tocsection-11"><a href="#Openoffice_Calc"><span class="tocnumber">2.4.1</span> <span class="toctext">Openoffice Calc</span></a></li> <li class="toclevel-3 tocsection-12"><a href="#MS_Excel"><span class="tocnumber">2.4.2</span> <span class="toctext">MS Excel</span></a></li> </ul> </li> <li class="toclevel-2 tocsection-13"><a href="#Disadvantages_of_this_procedure"><span class="tocnumber">2.5</span> <span class="toctext">Disadvantages of this procedure</span></a></li> </ul> </li> <li class="toclevel-1 tocsection-14"><a href="#Database"><span class="tocnumber">3</span> <span class="toctext">Database</span></a> <ul> <li class="toclevel-2 tocsection-15"><a href="#Creation"><span class="tocnumber">3.1</span> <span class="toctext">Creation</span></a></li> <li class="toclevel-2 tocsection-16"><a href="#Database_layout"><span class="tocnumber">3.2</span> <span class="toctext">Database layout</span></a></li> <li class="toclevel-2 tocsection-17"><a href="#How_to_access"><span class="tocnumber">3.3</span> <span class="toctext">How to access</span></a></li> <li class="toclevel-2 tocsection-18"><a href="#Data_download"><span class="tocnumber">3.4</span> <span class="toctext">Data download</span></a></li> </ul> </li> <li class="toclevel-1 tocsection-19"><a href="#Project_participants"><span class="tocnumber">4</span> <span class="toctext">Project participants</span></a></li> <li class="toclevel-1 tocsection-20"><a href="#Project_coordinators"><span class="tocnumber">5</span> <span class="toctext">Project coordinators</span></a></li> </ul> </div> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Objectives" data-mw-thread-id="h-Objectives"><span data-mw-comment-start="" id="h-Objectives"></span>Objectives<span data-mw-comment-end="h-Objectives"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=1" title="Quellcode des Abschnitts bearbeiten: Objectives"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>The now dormant project <a href="https://meta.wikimedia.org/wiki/Wikidata" class="extiw" title="meta:Wikidata">Wikidata</a> shall be revived, Wikipedia itself shall be prepared for the highly interesting <a href="https://en.wikipedia.org/wiki/Semantic_MediaWiki" class="extiw" title="en:Semantic MediaWiki">Semantic MediaWiki</a>. </p><p>On the one hand, this projects intends to facilitate maintenance work (on categories and templates) and projects on Wikipedia, on the other hand it intends to offer new search capabilities for interested users of Wikipedia. Although such data was extracted previously within the projects <a href="https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Geographical_coordinates" class="extiw" title="en:Wikipedia:WikiProject Geographical coordinates">Geographical coordinates</a> and <a href="https://en.wikipedia.org/wiki/Wikipedia:Persondata" class="extiw" title="en:Wikipedia:Persondata">Persondata</a>, a similar effort was not afforded to smaller subjects, until now. </p><p>Another objective is to demonstrate that template extraction via the parser (realtime data) is sensible and feasible in regards to performance. Moreover, not every template needs necessarily a table for itself. </p><p>The project layout intends to support all the mayor Wikipedia languages from the start. </p><p><br/> </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Use" data-mw-thread-id="h-Use"><span data-mw-comment-start="" id="h-Use"></span>Use<span data-mw-comment-end="h-Use"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=2" title="Quellcode des Abschnitts bearbeiten: Use"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>This project is used by modifying the URL, so it offers only a very limited usability. To mitigate this limitations, we will answer questions to the project on the talk page. As the amount of data is very large, we please ask interested parties for a little patience until results to a query are displayed. Once the query is completed the results can be used very fast, though. </p> <div class="mw-heading mw-heading3"><h3 id="Template_selection" data-mw-thread-id="h-Template_selection-Use"><span data-mw-comment-start="" id="h-Template_selection-Use"></span>Template selection<span data-mw-comment-end="h-Template_selection-Use"></span></h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=3" title="Quellcode des Abschnitts bearbeiten: Template selection"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>To select the available templates, open on one of the following pages: </p> <ul><li><a class="external text" href="https://iw.toolforge.org/templatetiger/template-choice.php?lang=de">template-choice.php|lang=de</a> Templates, most often used ones first.</li> <li><a class="external text" href="https://iw.toolforge.org/templatetiger/template-choice.php?lang=de&az=yes&from=Info">template-choice.php|lang=de&az=yes&from=Info</a> template selection in alphabetical order, beginning with Template:Info...</li></ul> <div class="mw-heading mw-heading3"><h3 id="Table_display" data-mw-thread-id="h-Table_display-Use"><span data-mw-comment-start="" id="h-Table_display-Use"></span>Table display<span data-mw-comment-end="h-Table_display-Use"></span></h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=4" title="Quellcode des Abschnitts bearbeiten: Table display"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>It is possible to filter the template for a pair of variables by using the URL parameters "Where" and "is" for the desired variable value. For example: </p> <ul><li><a class="external text" href="https://iw.toolforge.org/templatetiger/tt-table4.php?template=Personendaten&lang=de&where=GEBURTSORT&is=London">tools.wikimedia.de</a></li></ul> <p>displays all people born in London. </p> <ul><li><a class="external text" href="https://iw.toolforge.org/templatetiger/tt-table4.php?lang=de&template=Infobox%20Berg&where=Erstbesteigung&is=%5B%5B18__%5D%5D&offset=0&limit=30">tools.wikimedia.de</a></li></ul> <p>displays all mountains which where first climbed during the 19<sup>th</sup> century. </p><p>The query tries to find a substring by using the SQL command LIKE %...%. As wildcards, the commands "%" are used for a variable number of signs, the command "_" for exactly one discretionary sign. The following query displays all mountains, whose last eruption is noted in the template (volcanoes): <a class="external free" href="https://iw.toolforge.org/templatetiger/tt-table4.php?lang=de&template=Infobox%20Berg&where=LETZTE%20ERUPTION&is=_&offset=0&limit=30">https://iw.toolforge.org/templatetiger/tt-table4.php?lang=de&template=Infobox%20Berg&where=LETZTE%20ERUPTION&is=_&offset=0&limit=30</a> </p> <div class="mw-heading mw-heading3"><h3 id="Regular_expressions" data-mw-thread-id="h-Regular_expressions-Use"><span data-mw-comment-start="" id="h-Regular_expressions-Use"></span>Regular expressions<span data-mw-comment-end="h-Regular_expressions-Use"></span></h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=5" title="Quellcode des Abschnitts bearbeiten: Regular expressions"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p><code><a class="external free" href="https://iw.toolforge.org/templatetiger/tt-table4.php?lang=de&template=Infobox%20Berg&where=H%he&is=%5b8%5d%5b0-9%5d%5b0-9%5d%5b0-9%5d&offset=0&limit=30&regexp=yes">https://iw.toolforge.org/templatetiger/tt-table4.php?lang=de&template=Infobox%20Berg&where=H%he&is=%5b8%5d%5b0-9%5d%5b0-9%5d%5b0-9%5d&offset=0&limit=30&regexp=yes</a></code>] </p><p>Display of all 8000 m mountains by using regular expressions (please copy internet address into the browser box) </p> <div class="mw-heading mw-heading4"><h4 id="Negating_the_query" data-mw-thread-id="h-Negating_the_query-Regular_expressions"><span data-mw-comment-start="" id="h-Negating_the_query-Regular_expressions"></span>Negating the query<span data-mw-comment-end="h-Negating_the_query-Regular_expressions"></span></h4><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=6" title="Quellcode des Abschnitts bearbeiten: Negating the query"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p><code>&where...&is=...&not=yes </code> shows only items, which do not fulfill the query, but they must contain an entry. </p> <div class="mw-heading mw-heading4"><h4 id="Sorting_the_result" data-mw-thread-id="h-Sorting_the_result-Regular_expressions"><span data-mw-comment-start="" id="h-Sorting_the_result-Regular_expressions"></span>Sorting the result<span data-mw-comment-end="h-Sorting_the_result-Regular_expressions"></span></h4><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=7" title="Quellcode des Abschnitts bearbeiten: Sorting the result"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <ul><li><code>&order=article</code> sorting the articles alphabetical by article names (<a class="external text" href="https://iw.toolforge.org/templatetiger/tt-table4.php?template=Infobox%20Berg&lang=de&order=article">Example</a>)</li> <li><code>&order=columnname</code> sorting the articles alphabetical by a selectable column. Shows only articles with an entry. (<a class="external text" href="https://iw.toolforge.org/templatetiger/tt-table4.php?template=Infobox%20Arcade&lang=de&order=Firma">Example</a> Games sorting by producer)</li></ul> <p>Sorting works only without a filter. </p> <div class="mw-heading mw-heading4"><h4 id="Selection_of_Columns" data-mw-thread-id="h-Selection_of_Columns-Regular_expressions"><span data-mw-comment-start="" id="h-Selection_of_Columns-Regular_expressions"></span>Selection of Columns<span data-mw-comment-end="h-Selection_of_Columns-Regular_expressions"></span></h4><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=8" title="Quellcode des Abschnitts bearbeiten: Selection of Columns"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>With parameter <code>&columns=column1,column2,...</code> only some columns are displayed, so the result could be faster and more clearly. Example: <a class="external free" href="https://iw.toolforge.org/templatetiger/tt-table4.php?template=Infobox%20See&lang=de&where=&is=&columns=LAGE,MAX-TIEFE">https://iw.toolforge.org/templatetiger/tt-table4.php?template=Infobox%20See&lang=de&where=&is=&columns=LAGE,MAX-TIEFE</a> </p> <div class="mw-heading mw-heading4"><h4 id="Change_of_line_count" data-mw-thread-id="h-Change_of_line_count-Regular_expressions"><span data-mw-comment-start="" id="h-Change_of_line_count-Regular_expressions"></span>Change of line count<span data-mw-comment-end="h-Change_of_line_count-Regular_expressions"></span></h4><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=9" title="Quellcode des Abschnitts bearbeiten: Change of line count"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>By changing the limit variable in the URL it is possible to display more than the standard amount of articles which is set to 30. On account of security the maximum amount is limited to 2000 at the moment. </p> <div class="mw-heading mw-heading3"><h3 id="Re-use_of_data_in_spreadsheets" data-mw-thread-id="h-Re-use_of_data_in_spreadsheets-Use"><span data-mw-comment-start="" id="h-Re-use_of_data_in_spreadsheets-Use"></span>Re-use of data in spreadsheets<span data-mw-comment-end="h-Re-use_of_data_in_spreadsheets-Use"></span></h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=10" title="Quellcode des Abschnitts bearbeiten: Re-use of data in spreadsheets"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>By copying the tables in new spreadsheets it is possible to hide rows, sort the content or change data fields. </p> <div class="mw-heading mw-heading4"><h4 id="Openoffice_Calc" data-mw-thread-id="h-Openoffice_Calc-Re-use_of_data_in_spreadsheets"><span data-mw-comment-start="" id="h-Openoffice_Calc-Re-use_of_data_in_spreadsheets"></span>Openoffice Calc<span data-mw-comment-end="h-Openoffice_Calc-Re-use_of_data_in_spreadsheets"></span></h4><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=11" title="Quellcode des Abschnitts bearbeiten: Openoffice Calc"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Supports besides Copy/Paste the possiblity to use Insert/Link to external datas... directly to the URL. </p> <div class="mw-heading mw-heading4"><h4 id="MS_Excel" data-mw-thread-id="h-MS_Excel-Re-use_of_data_in_spreadsheets"><span data-mw-comment-start="" id="h-MS_Excel-Re-use_of_data_in_spreadsheets"></span>MS Excel<span data-mw-comment-end="h-MS_Excel-Re-use_of_data_in_spreadsheets"></span></h4><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=12" title="Quellcode des Abschnitts bearbeiten: MS Excel"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>The programm can be used with the Extras/Web query. </p> <div class="mw-heading mw-heading3"><h3 id="Disadvantages_of_this_procedure" data-mw-thread-id="h-Disadvantages_of_this_procedure-Use"><span data-mw-comment-start="" id="h-Disadvantages_of_this_procedure-Use"></span>Disadvantages of this procedure<span data-mw-comment-end="h-Disadvantages_of_this_procedure-Use"></span></h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=13" title="Quellcode des Abschnitts bearbeiten: Disadvantages of this procedure"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>All data field entries are uniformly recognized as text. This limits the possibilities for e.g. the sorting of numbers. More than one filter criterium is difficult to apply. It appears to be difficult to find articles which lack certain field entries. </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Database" data-mw-thread-id="h-Database"><span data-mw-comment-start="" id="h-Database"></span>Database<span data-mw-comment-end="h-Database"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=14" title="Quellcode des Abschnitts bearbeiten: Database"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <div class="mw-heading mw-heading3"><h3 id="Creation" data-mw-thread-id="h-Creation-Database"><span data-mw-comment-start="" id="h-Creation-Database"></span>Creation<span data-mw-comment-end="h-Creation-Database"></span></h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=15" title="Quellcode des Abschnitts bearbeiten: Creation"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>The data inside the database is read while extracting the geographical data (<a href="https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Geographical_coordinates" class="extiw" title="en:Wikipedia:WikiProject Geographical coordinates">WikiProject Geographical coordinates</a>). The Perl script was extended for this purpose, so that it can also read all text inbetween curly braces ({{…}}). Templates without variables are ignored. From the other templates the variable names and values are extracted. </p><p>The current method reads only templates, which are not listed inside another template. If for example in the Template:Infobox in the variable "POSITION=" the Template:Coordinate is used, only the variable value "Template:Coordinate" can be read. Furthermore, the comments inside the templates are left out, because otherwise the data interpretation would have been much more difficult. </p> <div class="mw-heading mw-heading3"><h3 id="Database_layout" data-mw-thread-id="h-Database_layout-Database"><span data-mw-comment-start="" id="h-Database_layout-Database"></span>Database layout<span data-mw-comment-end="h-Database_layout-Database"></span></h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=16" title="Quellcode des Abschnitts bearbeiten: Database layout"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>For each language version there will be an own table. For the German language, this is "pub_tt1_de". Every variable in every template of every article contains one set of data, so for the German WP, there are 1,9 million data entries at the moment. A data set contains: </p> <table class="wikitable"> <tbody><tr> <td>name</td> <td>Name of the article </td></tr> <tr> <td>name_id</td> <td>ID-number of the article </td></tr> <tr> <td>tp_name</td> <td>Name of the template </td></tr> <tr> <td>entry_name</td> <td>Name of the template variable (1,2,3,… or name1,name2…) </td></tr> <tr> <td>value</td> <td>Value of the template variable </td></tr></tbody></table> <div class="mw-heading mw-heading3"><h3 id="How_to_access" data-mw-thread-id="h-How_to_access-Database"><span data-mw-comment-start="" id="h-How_to_access-Database"></span>How to access<span data-mw-comment-end="h-How_to_access-Database"></span></h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=17" title="Quellcode des Abschnitts bearbeiten: How to access"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Through the <a href="https://meta.wikimedia.org/wiki/Toolserver" class="extiw" title="meta:Toolserver">Toolserver</a> you can access to <code>u_kolossos_p</code> database, if you have an account. This way, you can write your own application. </p> <div class="mw-heading mw-heading3"><h3 id="Data_download" data-mw-thread-id="h-Data_download-Database"><span data-mw-comment-start="" id="h-Data_download-Database"></span>Data download<span data-mw-comment-end="h-Data_download-Database"></span></h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=18" title="Quellcode des Abschnitts bearbeiten: Data download"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>There are plans to make the data download possible later. </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Project_participants" data-mw-thread-id="h-Project_participants-2009-01-08T17:29:00.000Z"><span data-mw-comment-start="" id="h-Project_participants-2009-01-08T17:29:00.000Z"></span>Project participants<span data-mw-comment-end="h-Project_participants-2009-01-08T17:29:00.000Z"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=19" title="Quellcode des Abschnitts bearbeiten: Project participants"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span><div class="ext-discussiontools-init-section-bar"><div class="ext-discussiontools-init-section-metadata"></div><div class="ext-discussiontools-init-section-actions"></div></div></div> <p><span data-mw-comment-start="" id="c-Snipre-2009-01-08T17:29:00.000Z-Project_participants"></span>People are sought for further optimization of the data analysis, and to propagate the project in the other language versions. </p> <ul><li><a href="/wiki/Benutzer:Snipre" title="Benutzer:Snipre">Snipre</a> <a href="https://de.wikipedia.org/wiki/Wikipedia:WikiProjekt_Vorlagenauswertung/en#c-Snipre-2009-01-08T17:29:00.000Z-Project_participants" class="ext-discussiontools-init-timestamplink">18:29, 8. Jan. 2009 (CET)</a>. I’m active on WP:fr (<a href="https://fr.wikipedia.org/wiki/User:Snipre" class="extiw" title="fr:User:Snipre">fr:User:Snipre</a>) and I am developping interfaces in order to build the query in an easiest way.<span class="ext-discussiontools-init-replylink-buttons" data-mw-thread-id="c-Snipre-2009-01-08T17:29:00.000Z-Project_participants"><span class="ext-discussiontools-init-replylink-bracket">[</span><a class="ext-discussiontools-init-replylink-reply" role="button" tabindex="0" href="">Beantworten</a><span class="ext-discussiontools-init-replylink-bracket">]</span></span><span data-mw-comment-end="c-Snipre-2009-01-08T17:29:00.000Z-Project_participants"></span></li> <li>…</li> <li>…</li></ul> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Project_coordinators" data-mw-thread-id="h-Project_coordinators"><span data-mw-comment-start="" id="h-Project_coordinators"></span>Project coordinators<span data-mw-comment-end="h-Project_coordinators"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit&section=20" title="Quellcode des Abschnitts bearbeiten: Project coordinators"><span>Quelltext bearbeiten</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>We are keen to answer any of your questions. </p> <ul><li><a href="https://en.wikipedia.org/wiki/de:User:Kolossos" class="extiw" title="w:de:User:Kolossos">User:Kolossos</a> Application programming</li> <li><a href="https://en.wikipedia.org/wiki/en:User:Bgwhite" class="extiw" title="w:en:User:Bgwhite">w:en:User:Bgwhite</a> Data extraction</li></ul>    </div><noscript><img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?type=1x1" alt="" width="1" height="1" style="border: none; position: absolute;"></noscript> <div class="printfooter" data-nosnippet="">Abgerufen von „<a dir="ltr" href="https://de.wikipedia.org/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&oldid=223606619">https://de.wikipedia.org/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&oldid=223606619</a>“</div></div> <div id="catlinks" class="catlinks" data-mw="interface"><div id="mw-normal-catlinks" class="mw-normal-catlinks"><a href="/wiki/Wikipedia:Kategorien" title="Wikipedia:Kategorien">Kategorie</a>: <ul><li><a href="/wiki/Kategorie:Wikipedia:Internes_WikiProjekt" title="Kategorie:Wikipedia:Internes WikiProjekt">Wikipedia:Internes WikiProjekt</a></li></ul></div></div> </div> </div> <div id="mw-navigation"> <h2>Navigationsmenü</h2> <div id="mw-head"> <nav id="p-personal" class="mw-portlet mw-portlet-personal vector-user-menu-legacy vector-menu" aria-labelledby="p-personal-label" > <h3 id="p-personal-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Meine Werkzeuge</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-anonuserpage" class="mw-list-item"><span title="Benutzerseite der IP-Adresse, von der aus du Änderungen durchführst">Nicht angemeldet</span></li><li id="pt-anontalk" class="mw-list-item"><a href="/wiki/Spezial:Meine_Diskussionsseite" title="Diskussion über Änderungen von dieser IP-Adresse [n]" accesskey="n"><span>Diskussionsseite</span></a></li><li id="pt-anoncontribs" class="mw-list-item"><a href="/wiki/Spezial:Meine_Beitr%C3%A4ge" title="Eine Liste der Bearbeitungen, die von dieser IP-Adresse gemacht wurden [y]" accesskey="y"><span>Beiträge</span></a></li><li id="pt-createaccount" class="mw-list-item"><a href="/w/index.php?title=Spezial:Benutzerkonto_anlegen&returnto=Wikipedia%3AWikiProjekt+Vorlagenauswertung%2Fen" title="Wir ermutigen dich dazu, ein Benutzerkonto zu erstellen und dich anzumelden. Es ist jedoch nicht zwingend erforderlich."><span>Benutzerkonto erstellen</span></a></li><li id="pt-login" class="mw-list-item"><a href="/w/index.php?title=Spezial:Anmelden&returnto=Wikipedia%3AWikiProjekt+Vorlagenauswertung%2Fen" title="Anmelden ist zwar keine Pflicht, wird aber gerne gesehen. [o]" accesskey="o"><span>Anmelden</span></a></li> </ul> </div> </nav> <div id="left-navigation"> <nav id="p-namespaces" class="mw-portlet mw-portlet-namespaces vector-menu-tabs vector-menu-tabs-legacy vector-menu" aria-labelledby="p-namespaces-label" > <h3 id="p-namespaces-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Namensräume</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-project" class="selected mw-list-item"><a href="/wiki/Wikipedia:WikiProjekt_Vorlagenauswertung/en" title="Portalseite anzeigen [c]" accesskey="c"><span>Projektseite</span></a></li><li id="ca-talk" class="mw-list-item"><a href="/wiki/Wikipedia_Diskussion:WikiProjekt_Vorlagenauswertung/en" rel="discussion" title="Diskussion zum Seiteninhalt [t]" accesskey="t"><span>Diskussion</span></a></li> </ul> </div> </nav> <nav id="p-variants" class="mw-portlet mw-portlet-variants emptyPortlet vector-menu-dropdown vector-menu" aria-labelledby="p-variants-label" > <input type="checkbox" id="p-variants-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-variants" class="vector-menu-checkbox" aria-labelledby="p-variants-label" > <label id="p-variants-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Deutsch</span> </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </nav> </div> <div id="right-navigation"> <nav id="p-views" class="mw-portlet mw-portlet-views vector-menu-tabs vector-menu-tabs-legacy vector-menu" aria-labelledby="p-views-label" > <h3 id="p-views-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Ansichten</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected mw-list-item"><a href="/wiki/Wikipedia:WikiProjekt_Vorlagenauswertung/en"><span>Lesen</span></a></li><li id="ca-edit" class="mw-list-item"><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=edit" title="Den Quelltext dieser Seite bearbeiten [e]" accesskey="e"><span>Quelltext bearbeiten</span></a></li><li id="ca-history" class="mw-list-item"><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=history" title="Frühere Versionen dieser Seite [h]" accesskey="h"><span>Versionsgeschichte</span></a></li> </ul> </div> </nav> <nav id="p-cactions" class="mw-portlet mw-portlet-cactions emptyPortlet vector-menu-dropdown vector-menu" aria-labelledby="p-cactions-label" title="Weitere Optionen" > <input type="checkbox" id="p-cactions-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-cactions" class="vector-menu-checkbox" aria-labelledby="p-cactions-label" > <label id="p-cactions-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Weitere</span> </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </nav> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box-show-thumbnail vector-search-box-auto-expand-width vector-search-box"> <h3 >Suche</h3> <form action="/w/index.php" id="searchform" class="vector-search-box-form"> <div id="simpleSearch" class="vector-search-box-inner" data-search-loc="header-navigation"> <input class="vector-search-box-input" type="search" name="search" placeholder="Wikipedia durchsuchen" aria-label="Wikipedia durchsuchen" autocapitalize="sentences" title="Durchsuche die Wikipedia [f]" accesskey="f" id="searchInput" > <input type="hidden" name="title" value="Spezial:Suche"> <input id="mw-searchButton" class="searchButton mw-fallbackSearchButton" type="submit" name="fulltext" title="Suche nach Seiten, die diesen Text enthalten" value="Suchen"> <input id="searchButton" class="searchButton" type="submit" name="go" title="Gehe direkt zu der Seite mit genau diesem Namen, falls sie vorhanden ist." value="Artikel"> </div> </form> </div> </div> </div> <div id="mw-panel" class="vector-legacy-sidebar"> <div id="p-logo" role="banner"> <a class="mw-wiki-logo" href="/wiki/Wikipedia:Hauptseite" title="Hauptseite"></a> </div> <nav id="p-navigation" class="mw-portlet mw-portlet-navigation vector-menu-portal portal vector-menu" aria-labelledby="p-navigation-label" > <h3 id="p-navigation-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Navigation</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mainpage-description" class="mw-list-item"><a href="/wiki/Wikipedia:Hauptseite" title="Hauptseite besuchen [z]" accesskey="z"><span>Hauptseite</span></a></li><li id="n-topics" class="mw-list-item"><a href="/wiki/Portal:Wikipedia_nach_Themen"><span>Themenportale</span></a></li><li id="n-randompage" class="mw-list-item"><a href="/wiki/Spezial:Zuf%C3%A4llige_Seite" title="Zufällige Seite aufrufen [x]" accesskey="x"><span>Zufälliger Artikel</span></a></li> </ul> </div> </nav> <nav id="p-Mitmachen" class="mw-portlet mw-portlet-Mitmachen vector-menu-portal portal vector-menu" aria-labelledby="p-Mitmachen-label" > <h3 id="p-Mitmachen-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Mitmachen</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-Artikel-verbessern" class="mw-list-item"><a href="/wiki/Wikipedia:Beteiligen"><span>Artikel verbessern</span></a></li><li id="n-Neuerartikel" class="mw-list-item"><a href="/wiki/Hilfe:Neuen_Artikel_anlegen"><span>Neuen Artikel anlegen</span></a></li><li id="n-portal" class="mw-list-item"><a href="/wiki/Wikipedia:Autorenportal" title="Info-Zentrum über Beteiligungsmöglichkeiten"><span>Autorenportal</span></a></li><li id="n-help" class="mw-list-item"><a href="/wiki/Hilfe:%C3%9Cbersicht" title="Übersicht über Hilfeseiten"><span>Hilfe</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Spezial:Letzte_%C3%84nderungen" title="Liste der letzten Änderungen in Wikipedia [r]" accesskey="r"><span>Letzte Änderungen</span></a></li><li id="n-contact" class="mw-list-item"><a href="/wiki/Wikipedia:Kontakt" title="Kontaktmöglichkeiten"><span>Kontakt</span></a></li><li id="n-sitesupport" class="mw-list-item"><a href="//donate.wikimedia.org/wiki/Special:FundraiserRedirector?utm_source=donate&utm_medium=sidebar&utm_campaign=C13_de.wikipedia.org&uselang=de" title="Unterstütze uns"><span>Spenden</span></a></li> </ul> </div> </nav> <nav id="p-tb" class="mw-portlet mw-portlet-tb vector-menu-portal portal vector-menu" aria-labelledby="p-tb-label" > <h3 id="p-tb-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Werkzeuge</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Spezial:Linkliste/Wikipedia:WikiProjekt_Vorlagenauswertung/en" title="Liste aller Seiten, die hierher verlinken [j]" accesskey="j"><span>Links auf diese Seite</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Spezial:%C3%84nderungen_an_verlinkten_Seiten/Wikipedia:WikiProjekt_Vorlagenauswertung/en" rel="nofollow" title="Letzte Änderungen an Seiten, die von hier verlinkt sind [k]" accesskey="k"><span>Änderungen an verlinkten Seiten</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Spezial:Spezialseiten" title="Liste aller Spezialseiten [q]" accesskey="q"><span>Spezialseiten</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&oldid=223606619" title="Dauerhafter Link zu dieser Seitenversion"><span>Permanenter Link</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&action=info" title="Weitere Informationen über diese Seite"><span>Seiteninformationen</span></a></li><li id="t-urlshortener" class="mw-list-item"><a href="/w/index.php?title=Spezial:URL-K%C3%BCrzung&url=https%3A%2F%2Fde.wikipedia.org%2Fwiki%2FWikipedia%3AWikiProjekt_Vorlagenauswertung%2Fen"><span>Kurzlink</span></a></li><li id="t-urlshortener-qrcode" class="mw-list-item"><a href="/w/index.php?title=Spezial:QrCode&url=https%3A%2F%2Fde.wikipedia.org%2Fwiki%2FWikipedia%3AWikiProjekt_Vorlagenauswertung%2Fen"><span>QR-Code herunterladen</span></a></li> </ul> </div> </nav> <nav id="p-coll-print_export" class="mw-portlet mw-portlet-coll-print_export vector-menu-portal portal vector-menu" aria-labelledby="p-coll-print_export-label" > <h3 id="p-coll-print_export-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Drucken/exportieren</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="coll-download-as-rl" class="mw-list-item"><a href="/w/index.php?title=Spezial:DownloadAsPdf&page=Wikipedia%3AWikiProjekt_Vorlagenauswertung%2Fen&action=show-download-screen"><span>Als PDF herunterladen</span></a></li><li id="t-print" class="mw-list-item"><a href="/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&printable=yes" title="Druckansicht dieser Seite [p]" accesskey="p"><span>Druckversion</span></a></li> </ul> </div> </nav> <nav id="p-wikibase-otherprojects" class="mw-portlet mw-portlet-wikibase-otherprojects vector-menu-portal portal vector-menu" aria-labelledby="p-wikibase-otherprojects-label" > <h3 id="p-wikibase-otherprojects-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">In anderen Projekten</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-wikibase" class="wb-otherproject-link wb-otherproject-wikibase-dataitem mw-list-item"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q66458694" title="Link zum verbundenen Objekt im Datenrepositorium [g]" accesskey="g"><span>Wikidata-Datenobjekt</span></a></li> </ul> </div> </nav> <nav id="p-lang" class="mw-portlet mw-portlet-lang vector-menu-portal portal vector-menu" aria-labelledby="p-lang-label" > <h3 id="p-lang-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">In anderen Sprachen</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> <div class="after-portlet after-portlet-lang"><span class="uls-after-portlet-link"></span><span class="wb-langlinks-add wb-langlinks-link"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q66458694#sitelinks-wikipedia" title="Links auf Seiten in anderen Sprachen hinzufügen" class="wbc-editpage">Links hinzufügen</a></span></div> </div> </nav> </div> </div> <footer id="footer" class="mw-footer" > <ul id="footer-info"> <li id="footer-info-lastmod"> Diese Seite wurde zuletzt am 11. Juni 2022 um 05:39 Uhr bearbeitet.</li> <li id="footer-info-copyright"><div id="footer-info-copyright-stats" class="noprint"><a rel="nofollow" class="external text" href="https://pageviews.wmcloud.org/?pages=Wikipedia:WikiProjekt_Vorlagenauswertung/en&project=de.wikipedia.org">Abrufstatistik</a> </div><div id="footer-info-copyright-separator"><br /></div><div id="footer-info-copyright-info"> <p>Der Text ist unter der Lizenz <a rel="nofollow" class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.de">„Creative-Commons Namensnennung – Weitergabe unter gleichen Bedingungen“</a> verfügbar; Informationen zu den Urhebern und zum Lizenzstatus eingebundener Mediendateien (etwa Bilder oder Videos) können im Regelfall durch Anklicken dieser abgerufen werden. Möglicherweise unterliegen die Inhalte jeweils zusätzlichen Bedingungen. Durch die Nutzung dieser Website erklären Sie sich mit den <span class="plainlinks"><a class="external text" href="https://foundation.wikimedia.org/wiki/Policy:Terms_of_Use/de">Nutzungsbedingungen</a> und der <a class="external text" href="https://foundation.wikimedia.org/wiki/Policy:Privacy_policy/de">Datenschutzrichtlinie</a></span> einverstanden.<br /> </p> Wikipedia® ist eine eingetragene Marke der Wikimedia Foundation Inc.</div></li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy/de">Datenschutz</a></li> <li id="footer-places-about"><a href="/wiki/Wikipedia:%C3%9Cber_Wikipedia">Über Wikipedia</a></li> <li id="footer-places-disclaimers"><a href="/wiki/Wikipedia:Impressum">Impressum</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Universal_Code_of_Conduct">Verhaltenskodex</a></li> <li id="footer-places-developers"><a href="https://developer.wikimedia.org">Entwickler</a></li> <li id="footer-places-statslink"><a href="https://stats.wikimedia.org/#/de.wikipedia.org">Statistiken</a></li> <li id="footer-places-cookiestatement"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Stellungnahme zu Cookies</a></li> <li id="footer-places-mobileview"><a href="//de.m.wikipedia.org/w/index.php?title=Wikipedia:WikiProjekt_Vorlagenauswertung/en&mobileaction=toggle_view_mobile" class="noprint stopMobileRedirectToggle">Mobile Ansicht</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://wikimediafoundation.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/static/images/footer/wikimedia-button.svg" width="84" height="29" alt="Wikimedia Foundation" loading="lazy"></a></li> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/w/resources/assets/poweredby_mediawiki.svg" alt="Powered by MediaWiki" width="88" height="31" loading="lazy"></a></li> </ul> </footer> <script>(RLQ=window.RLQ||[]).push(function(){mw.log.warn("This page is using the deprecated ResourceLoader module \"codex-search-styles\".\n[1.43] Use a CodexModule with codexComponents to set your specific components used: https://www.mediawiki.org/wiki/Codex#Using_a_limited_subset_of_components");mw.config.set({"wgHostname":"mw-web.codfw.main-57488d5c7d-slg92","wgBackendResponseTime":161,"wgDiscussionToolsPageThreads":[{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Objectives","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Use","replies":[{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-Template_selection-Use","replies":[]},{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-Table_display-Use","replies":[]},{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-Regular_expressions-Use","replies":[{"headingLevel":4,"name":"h-","type":"heading","level":0,"id":"h-Negating_the_query-Regular_expressions","replies":[]},{"headingLevel":4,"name":"h-","type":"heading","level":0,"id":"h-Sorting_the_result-Regular_expressions","replies":[]},{"headingLevel":4,"name":"h-","type":"heading","level":0,"id":"h-Selection_of_Columns-Regular_expressions","replies":[]},{"headingLevel":4,"name":"h-","type":"heading","level":0,"id":"h-Change_of_line_count-Regular_expressions","replies":[]}]},{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-Re-use_of_data_in_spreadsheets-Use","replies":[{"headingLevel":4,"name":"h-","type":"heading","level":0,"id":"h-Openoffice_Calc-Re-use_of_data_in_spreadsheets","replies":[]},{"headingLevel":4,"name":"h-","type":"heading","level":0,"id":"h-MS_Excel-Re-use_of_data_in_spreadsheets","replies":[]}]},{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-Disadvantages_of_this_procedure-Use","replies":[]}]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Database","replies":[{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-Creation-Database","replies":[]},{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-Database_layout-Database","replies":[]},{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-How_to_access-Database","replies":[]},{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-Data_download-Database","replies":[]}]},{"headingLevel":2,"name":"h-Snipre-2009-01-08T17:29:00.000Z","type":"heading","level":0,"id":"h-Project_participants-2009-01-08T17:29:00.000Z","replies":[{"timestamp":"2009-01-08T17:29:00.000Z","author":"Snipre","type":"comment","level":1,"id":"c-Snipre-2009-01-08T17:29:00.000Z-Project_participants","replies":[]}]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Project_coordinators","replies":[]}],"wgPageParseReport":{"discussiontools":{"limitreport-timeusage":"0.013"},"limitreport":{"cputime":"0.035","walltime":"0.043","ppvisitednodes":{"value":118,"limit":1000000},"postexpandincludesize":{"value":1046,"limit":2097152},"templateargumentsize":{"value":0,"limit":2097152},"expansiondepth":{"value":2,"limit":100},"expensivefunctioncount":{"value":0,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":7,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["100.00% 2.817 1 Wikipedia:WikiProjekt_Vorlagenauswertung/news","100.00% 2.817 1 -total"]},"cachereport":{"origin":"mw-api-int.codfw.main-7858d788f6-cc8c7","timestamp":"20241102040409","ttl":2592000,"transientcontent":false}}});});</script> </body> </html>