Populating a mediawiki from tabular data - Revision history

Ttenbergen at 04:09, 2024 March 25

2024-03-25T04:09:10Z

← Older revision		Revision as of 21:09, 2024 March 24
Line 31:		Line 31:

	There are additional xml tags that can be used, to see more example content export a few pages from a wiki and review the XML for examples.		There are additional xml tags that can be used, to see more example content export a few pages from a wiki and review the XML for examples.


			[[Category:Mediawiki]]

Ttenbergen: Ttenbergen moved page Internal:Populating a mediawiki from tabular data to Populating a mediawiki from tabular data without leaving a redirect

2024-03-25T04:06:44Z

Ttenbergen moved page Internal:Populating a mediawiki from tabular data to Populating a mediawiki from tabular data without leaving a redirect

← Older revision	Revision as of 21:06, 2024 March 24
(No difference)

Ttenbergen at 04:04, 2024 March 25

2024-03-25T04:04:48Z

← Older revision		Revision as of 21:04, 2024 March 24
Line 28:		Line 28:
	The title and the page content can then be generated via excel formula from other columns if needed.		The title and the page content can then be generated via excel formula from other columns if needed.

	These lines are pasted into a text file, between the <code><mediawiki></code> and ~~xxx~~ tags. That file can then be imported to the wiki via Special Pages, Import pages. A bug on that page means that you have to enter some text into the "interwiki prefix" line or nothing will be imported.		These lines are pasted into a text file, between the <code><mediawiki></code> and <code></mediawiki></code> tags. That file can then be imported to the wiki via Special Pages, Import pages. A bug on that page means that you have to enter some text into the "interwiki prefix" line or nothing will be imported.

	There are additional xml tags that can be used, to see more example content export a few pages from a wiki and review the XML for examples.		There are additional xml tags that can be used, to see more example content export a few pages from a wiki and review the XML for examples.

Ttenbergen at 03:51, 2024 March 25

2024-03-25T03:51:56Z

← Older revision		Revision as of 20:51, 2024 March 24
Line 20:		Line 20:
	</page>		</page>
	</mediawiki>		</mediawiki>

			So, the xml for one page can be created by putting a adding a first, third and fifth column with the xml tags.
			{\| class="wikitable"
			\|-
			\| <page><title> \|\| the title \|\| </title><revision><text xml:space="preserve"> \|\| page content \|\| </text><comment>Imported content</comment></revision></page>
			\|}
			The title and the page content can then be generated via excel formula from other columns if needed.

			These lines are pasted into a text file, between the <code><mediawiki></code> and xxx tags. That file can then be imported to the wiki via Special Pages, Import pages. A bug on that page means that you have to enter some text into the "interwiki prefix" line or nothing will be imported.

			There are additional xml tags that can be used, to see more example content export a few pages from a wiki and review the XML for examples.

Ttenbergen at 03:31, 2024 March 25

2024-03-25T03:31:54Z

← Older revision		Revision as of 20:31, 2024 March 24
Line 10:		Line 10:

	In this scenario I will often create a new column and use excel functions to generate text of the same format as the XML files generated by an export from Mediawiki. This file can then be imported into the wiki.		In this scenario I will often create a new column and use excel functions to generate text of the same format as the XML files generated by an export from Mediawiki. This file can then be imported into the wiki.

			Mediawiki import/export files are of the following basic XML structure:
			<mediawiki>
			<page><title>mypagetitle</title>
			<revision>
			<text xml:space="preserve"> the content of my page
			</text><comment>Imported content</comment>
			</revision>
			</page>
			</mediawiki>

Ttenbergen: Created page with "{{TidBit |shortDescription=Get data into a mediawiki from tabular format such as a spreadsheet |skillSet=Mediawiki |featured=Yes }} When you first set up a new Mediawiki it is a good idea to populate it with some starting content that uses templates. Sometimes data that needs to go on the wiki is available in tabular form. For example, you may have a spreadsheet to track tools and you want to add this to the wiki. To make best use of the wiki you will want one pag..."

2024-03-25T02:22:53Z

Created page with "{{TidBit |shortDescription=Get data into a mediawiki from tabular format such as a spreadsheet |skillSet=Mediawiki |featured=Yes }} When you first set up a new Mediawiki it is a good idea to populate it with some starting content that uses templates. Sometimes data that needs to go on the wiki is available in tabular form. For example, you may have a spreadsheet to track tools and you want to add this to the wiki. To make best use of the wiki you will want one pag..."

New page

{{TidBit
|shortDescription=Get data into a mediawiki from tabular format such as a spreadsheet
|skillSet=Mediawiki
|featured=Yes
}}

When you first set up a new [[Mediawiki]] it is a good idea to populate it with some starting content that uses templates. Sometimes data that needs to go on the wiki is available in tabular form. For example, you may have a spreadsheet to track tools and you want to add this to the wiki.

To make best use of the wiki you will want one page per tool, so you can add all the structured data you want, but also add as much free text as you want. This means you need to add one page per line of spreadsheet, and there could be hundreds of lines.

In this scenario I will often create a new column and use excel functions to generate text of the same format as the XML files generated by an export from Mediawiki. This file can then be imported into the wiki.