Module:Import table/sandbox - Revision history

MSGJ at 10:25, 22 May 2023

2023-05-22T10:25:13Z

← Previous revision		Revision as of 10:25, 22 May 2023
Line 51:		Line 51:
	content = mw.ustring.match(content,"%{%\|(.+)%\|%}") -- keep table only		content = mw.ustring.match(content,"%{%\|(.+)%\|%}") -- keep table only
	content = mw.ustring.gsub(content,"\|\|","\n\|") -- use \n\| for column breaks		content = mw.ustring.gsub(content,"\|\|","\n\|") -- use \n\| for column breaks
	local rows = mw.text.split(content,"%\|%-[^\n]*\n") -- split table into rows		local rows = mw.text.split(content,"%\|%-\n") -- split table into rows, prev %\|%-[^\n]*\n
	table.remove(rows,1) -- remove table definition		table.remove(rows,1) -- remove table definition
	--table.remove(rows,1) -- remove heading row		--table.remove(rows,1) -- remove heading row

MSGJ: ustring

2023-05-22T10:19:28Z

ustring

← Previous revision		Revision as of 10:19, 22 May 2023
Line 7:		Line 7:
	local rawlabel		local rawlabel
	if label then		if label then
	rawlabel = ~~string~~.match(label,'%[%[([^%\|%]]+)%\|') or ~~string~~.match(label,'%[%[([^%\|%]]+)%]%]')		rawlabel = mw.ustring.match(label,'%[%[([^%\|%]]+)%\|') or mw.ustring.match(label,'%[%[([^%\|%]]+)%]%]')
	if rawlabel then		if rawlabel then
	qid = resolveEntity(rawlabel)		qid = resolveEntity(rawlabel)
Line 49:		Line 49:
	end		end
	local content = mw.title.new(args.page):getContent() -- read page specified		local content = mw.title.new(args.page):getContent() -- read page specified
	content = ~~string~~.match(content,"%{%\|(.+)%\|%}") -- keep table only		content = mw.ustring.match(content,"%{%\|(.+)%\|%}") -- keep table only
	content = ~~string~~.gsub(content,"\|\|","\n\|") -- use \n\| for column breaks		content = mw.ustring.gsub(content,"\|\|","\n\|") -- use \n\| for column breaks
	local rows = mw.text.split(content,"%\|%-[^\n]*\n") -- split table into rows		local rows = mw.text.split(content,"%\|%-[^\n]*\n") -- split table into rows
	table.remove(rows,1) -- remove table definition		table.remove(rows,1) -- remove table definition
Line 62:		Line 62:
	if label then		if label then
	label = tidystring(label)		label = tidystring(label)
	local qid = ~~string~~.match(label,"Q%d+") -- check if QID is specified in first column		local qid = mw.ustring.match(label,"Q%d+") -- check if QID is specified in first column
	if not qid then		if not qid then
	qid,label = resolveqid(label) -- resolve qid if first column is link		qid,label = resolveqid(label) -- resolve qid if first column is link
Line 114:		Line 114:
	end		end
	elseif config[cn][1] == "year" then		elseif config[cn][1] == "year" then
	local val = ~~string~~.match(col,"%d%d%d%d")		local val = mw.ustring.match(col,"%d%d%d%d")
	if val then		if val then
	v2 = addtov2(config[cn][2],"+" ..val .. "-00-00T00:00:00Z/9")		v2 = addtov2(config[cn][2],"+" ..val .. "-00-00T00:00:00Z/9")
	end		end
	elseif config[cn][1] == "quantity" then		elseif config[cn][1] == "quantity" then
	local val = ~~string~~.gsub(col,",","") -- remove any commas		local val = mw.ustring.gsub(col,",","") -- remove any commas
	val = ~~string~~.match(val,"%d+%.?%d*") -- extract value, possibly from inside convert template		val = mw.ustring.match(val,"%d+%.?%d*") -- extract value, possibly from inside convert template
	if val then		if val then
	if ~~string~~.upper(~~string~~.sub(config[cn][3],1,1)) == "Q" then		if mw.ustring.upper(mw.ustring.sub(config[cn][3],1,1)) == "Q" then
	config[cn][3] = ~~string~~.sub(config[cn][3],2)		config[cn][3] = mw.ustring.sub(config[cn][3],2)
	end		end
	v2 = addtov2(config[cn][2],val .. "U" .. config[cn][3])		v2 = addtov2(config[cn][2],val .. "U" .. config[cn][3])
Line 132:		Line 132:
	end		end
	elseif config[cn][1] == "coord" then		elseif config[cn][1] == "coord" then
	local val = ~~string~~.match(col,"%{%{[Cc]oord.*%}%}")		local val = mw.ustring.match(col,"%{%{[Cc]oord.*%}%}")
	if val then		if val then
	val = mw.getCurrentFrame():preprocess(col)		val = mw.getCurrentFrame():preprocess(col)
Line 138:		Line 138:
	end		end
	elseif config[cn][1] == "image" then		elseif config[cn][1] == "image" then
	local val = ~~string~~.match(col,"%[%[File%:([^%\|%]]+).*%]%]")		local val = mw.ustring.match(col,"%[%[File%:([^%\|%]]+).*%]%]")
	if val then		if val then
	v2 = addtov2(config[cn][2],'"' .. val .. '"')		v2 = addtov2(config[cn][2],'"' .. val .. '"')

MSGJ at 13:33, 16 November 2022

2022-11-16T13:33:41Z

← Previous revision		Revision as of 13:33, 16 November 2022
Line 82:		Line 82:
	v2 = v2 .. mw.wikibase.getLabel(common["P17"])		v2 = v2 .. mw.wikibase.getLabel(common["P17"])
	elseif common["P376"] then -- add planet		elseif common["P376"] then -- add planet
	v2 = v2 .. "on " .. mw.wikibase.getLabel(common["P376"])		v2 = v2 .. " on " .. mw.wikibase.getLabel(common["P376"])
	end		end
	v2 = v2 .. '"' .. eol		v2 = v2 .. '"' .. eol

MSGJ: add planet

2022-11-16T13:33:20Z

add planet

← Previous revision		Revision as of 13:33, 16 November 2022
Line 76:		Line 76:
	v2 = v2 .. qid .. tab .. 'Den' .. tab .. '"' .. mw.wikibase.getLabel(common["P31"])		v2 = v2 .. qid .. tab .. 'Den' .. tab .. '"' .. mw.wikibase.getLabel(common["P31"])
	if common["P17"] then -- add country		if common["P17"] then -- add country
	v2 = v2 .. ' in '		v2 = v2 .. " in "
	if common["P131"] then -- add region too		if common["P131"] then -- add region too
	v2 = v2 .. mw.wikibase.getLabel(common["P131"]) .. ", "		v2 = v2 .. mw.wikibase.getLabel(common["P131"]) .. ", "
	end		end
	v2 = v2 .. mw.wikibase.getLabel(common["P17"])		v2 = v2 .. mw.wikibase.getLabel(common["P17"])
			elseif common["P376"] then -- add planet
			v2 = v2 .. "on " .. mw.wikibase.getLabel(common["P376"])
	end		end
	v2 = v2 .. '"' .. eol		v2 = v2 .. '"' .. eol

MSGJ: add region to auto description

2022-11-16T13:30:50Z

add region to auto description

← Previous revision		Revision as of 13:30, 16 November 2022
Line 76:		Line 76:
	v2 = v2 .. qid .. tab .. 'Den' .. tab .. '"' .. mw.wikibase.getLabel(common["P31"])		v2 = v2 .. qid .. tab .. 'Den' .. tab .. '"' .. mw.wikibase.getLabel(common["P31"])
	if common["P17"] then -- add country		if common["P17"] then -- add country
	v2 = v2 .. ' in ' ~~.. mw.wikibase.getLabel(common["P17"])~~		v2 = v2 .. ' in '
			if common["P131"] then -- add region too
			v2 = v2 .. mw.wikibase.getLabel(common["P131"]) .. ", "
			end
			v2 = v2 .. mw.wikibase.getLabel(common["P17"])
	end		end
	v2 = v2 .. '"' .. eol		v2 = v2 .. '"' .. eol

MSGJ: try

2022-11-16T13:28:11Z

try

← Previous revision		Revision as of 13:28, 16 November 2022
Line 51:		Line 51:
	content = string.match(content,"%{%\|(.+)%\|%}") -- keep table only		content = string.match(content,"%{%\|(.+)%\|%}") -- keep table only
	content = string.gsub(content,"\|\|","\n\|") -- use \n\| for column breaks		content = string.gsub(content,"\|\|","\n\|") -- use \n\| for column breaks
	local rows = mw.text.split(content,"%\|%-~~+%s~~*\n") -- split table into rows		local rows = mw.text.split(content,"%\|%-[^\n]*\n") -- split table into rows
	table.remove(rows,1) -- remove table definition		table.remove(rows,1) -- remove table definition
	--table.remove(rows,1) -- remove heading row		--table.remove(rows,1) -- remove heading row

MSGJ: spaces before new line

2022-11-16T11:42:27Z

spaces before new line

← Previous revision		Revision as of 11:42, 16 November 2022
Line 51:		Line 51:
	content = string.match(content,"%{%\|(.+)%\|%}") -- keep table only		content = string.match(content,"%{%\|(.+)%\|%}") -- keep table only
	content = string.gsub(content,"\|\|","\n\|") -- use \n\| for column breaks		content = string.gsub(content,"\|\|","\n\|") -- use \n\| for column breaks
	local rows = mw.text.split(content,"%\|%-+\n") -- split table into rows		local rows = mw.text.split(content,"%\|%-+%s*\n") -- split table into rows
	table.remove(rows,1) -- remove table definition		table.remove(rows,1) -- remove table definition
	--table.remove(rows,1) -- remove heading row		--table.remove(rows,1) -- remove heading row

MSGJ at 10:24, 14 November 2022

2022-11-14T10:24:00Z

← Previous revision		Revision as of 10:24, 14 November 2022
Line 126:		Line 126:
	end		end
	elseif config[cn][1] == "coord" then		elseif config[cn][1] == "coord" then
	local val = string.match(col,"%{%{~~coord~~.*%}%}")		local val = string.match(col,"%{%{[Cc]oord.*%}%}")
	if val then		if val then
	val = mw.getCurrentFrame():preprocess(col)		val = mw.getCurrentFrame():preprocess(col)

MSGJ at 10:23, 14 November 2022

2022-11-14T10:23:11Z

← Previous revision		Revision as of 10:23, 14 November 2022
Line 53:		Line 53:
	local rows = mw.text.split(content,"%\|%-+\n") -- split table into rows		local rows = mw.text.split(content,"%\|%-+\n") -- split table into rows
	table.remove(rows,1) -- remove table definition		table.remove(rows,1) -- remove table definition
	table.remove(rows,1) -- remove heading row		--table.remove(rows,1) -- remove heading row
	local output = ""		local output = ""
	local v2 = ""		local v2 = ""

MSGJ at 10:20, 14 November 2022

2022-11-14T10:20:17Z

← Previous revision		Revision as of 10:20, 14 November 2022
Line 20:		Line 20:
	local tidy = mw.ustring.gsub(string,"%<ref.+%<%/ref%>","") -- remove any references with <ref .. </ref>		local tidy = mw.ustring.gsub(string,"%<ref.+%<%/ref%>","") -- remove any references with <ref .. </ref>
	tidy = mw.ustring.gsub(tidy,"%<ref.+%/%>","") -- remove any references with <ref .. />		tidy = mw.ustring.gsub(tidy,"%<ref.+%/%>","") -- remove any references with <ref .. />
			tidy = mw.ustring.gsub(tidy,"^%s*%\|","") -- remove \| character at start
	tidy = mw.text.trim(tidy) -- trim spaces		tidy = mw.text.trim(tidy) -- trim spaces
	return tidy		return tidy