Module:Import table - Revision history

MSGJ: newline after column break

2023-05-17T20:58:50Z

newline after column break

← Previous revision		Revision as of 20:58, 17 May 2023
Line 50:		Line 50:
	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,"\|-",true) -- split table into rows		local rows = mw.text.split(content,"\|-\n",true) -- 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

2022-12-13T16:28:43Z

add P131 to common

← Previous revision		Revision as of 16:28, 13 December 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
			v2 = v2 .. mw.wikibase.getLabel(common["P131"]) .. ", "
			end
			v2 = v2 .. mw.wikibase.getLabel(common["P17"])
	end		end
	v2 = v2 .. '"' .. eol		v2 = v2 .. '"' .. eol

2022-11-04T14:46:12Z

more robust tidying of text

← Previous revision		Revision as of 14:46, 4 November 2022
Line 15:		Line 15:
	end		end
	return qid,rawlabel		return qid,rawlabel
			end

			local function tidystring(string)
			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.text.trim(tidy) -- trim spaces
			return tidy
	end		end

Line 53:		Line 60:
	local label = columns[1]		local label = columns[1]
	if label then		if label then
	label = ~~mw.text.trim~~(label)		label = tidystring(label)
	local qid		local qid
	qid,label = resolveqid(label) -- resolve qid if first column is link		qid,label = resolveqid(label) -- resolve qid if first column is link
Line 94:		Line 101:
	end		end
	if import then		if import then
	col = ~~mw.ustring.gsub~~(col~~,"%<ref.+%<%/ref%>",""~~) ~~-- remove any references~~		col = tidystring(col)
⚫	~~col~~ = mw.text.trim(~~col~~) -- trim ~~any~~ spaces
	if config[cn][1] == "wikilink" then		if config[cn][1] == "wikilink" then
	local val = resolveqid(col)		local val = resolveqid(col)

2022-11-03T14:05:05Z

do not import if a claim for that property already exists

2022-11-02T16:07:50Z

allow qid to be specified

← Previous revision		Revision as of 16:07, 2 November 2022
Line 52:		Line 52:
	label = mw.text.trim(label)		label = mw.text.trim(label)
	local qid = resolveqid(label) -- resolve qid if first column is link		local qid = resolveqid(label) -- resolve qid if first column is link
			if not qid then
			qid = string.match(label,"Q%d+") -- check if QID is specified in first column
			end
	if not qid then		if not qid then
	v2 = v2 .. "CREATE" .. eol		v2 = v2 .. "CREATE" .. eol

2022-11-02T13:09:56Z

improve search pattern

← Previous revision		Revision as of 13:09, 2 November 2022
Line 6:		Line 6:
	local qid		local qid
	if title then		if title then
	local rawarticle = string.match(title,'%[%[([^%\|]+)%\|') or string.match(title,'%[%[([^%]]+)%]%]')		local rawarticle = string.match(title,'%[%[([^%\|%]]+)%\|') or string.match(title,'%[%[([^%\|%]]+)%]%]')
	if rawarticle and rawarticle ~= "" then		if rawarticle and rawarticle ~= "" then
	qid = resolveEntity(rawarticle)		qid = resolveEntity(rawarticle)

2022-11-02T10:02:05Z

bug fixes

← Previous revision		Revision as of 10:02, 2 November 2022
Line 6:		Line 6:
	local qid		local qid
	if title then		if title then
	local rawarticle = string.match(title,'%[%[(.+)%\|') or string.match(title,'%[%[(.+)%]%]')		local rawarticle = string.match(title,'%[%[([^%\|]+)%\|') or string.match(title,'%[%[([^%]]+)%]%]')
	if rawarticle and rawarticle ~= "" then		if rawarticle and rawarticle ~= "" then
	qid = resolveEntity(rawarticle)		qid = resolveEntity(rawarticle)
Line 73:		Line 73:
	for cn,col in ipairs(columns) do		for cn,col in ipairs(columns) do
	if config[cn] then		if config[cn] then
	~~for ref~~ in mw.ustring.~~gmatch~~(col,"%<ref.+%<%/ref%>") do		col = mw.ustring.gsub(col,"%<ref.+%<%/ref%>","") -- remove references
	col = mw.ustring.gsub(col,ref,"")
⚫	end
	col = mw.text.trim(col)		col = mw.text.trim(col)
	if config[cn][1] == "wikilink" then		if config[cn][1] == "wikilink" then
Line 101:		Line 99:
	end		end
	elseif config[cn][1] == "coord" then		elseif config[cn][1] == "coord" then
	local val = mw.getCurrentFrame():preprocess(col)		if col ~= "" then
			local val = mw.getCurrentFrame():preprocess(col)
	v2 = addtov2(config[cn][2],"@" .. coord2text(val,"lat") .. "/" .. coord2text(val,"long"))		v2 = addtov2(config[cn][2],"@" .. coord2text(val,"lat") .. "/" .. coord2text(val,"long"))
		⚫	end
	end		end
	end		end

2022-11-01T16:34:40Z

+coord

← Previous revision		Revision as of 16:34, 1 November 2022
Line 100:		Line 100:
	v2 = addtov2(config[cn][2],'"' .. col .. '"')		v2 = addtov2(config[cn][2],'"' .. col .. '"')
	end		end
	--elseif config[cn][1] == "coord" then		elseif config[cn][1] == "coord" then
			local val = mw.getCurrentFrame():preprocess(col)
	--import[#import+1] = {}
		⚫	v2 = addtov2(config[cn][2],"@" .. coord2text(val,"lat") .. "/" .. coord2text(val,"long"))
	--import[#import].property = config[cn][2]
⚫	~~--import~~[~~#import~~].~~value =~~ coord2text(~~col~~,"lat") .. "/" .. coord2text(~~col~~,"long")
	end		end
	end		end

2022-11-01T12:55:38Z

no import if label blank

2022-10-31T22:15:09Z

add label, description and common statements for items being created

@@ Line 16: / Line 16: @@
 function p.import(frame)
 	local tab = "|"
-	local wikiqid = "Q328"
+	local wikiqid = "Q328" -- QID for English Wikipedia
 	local eol = "<br>" -- end of line string
 	local coord2text = require("Module:Coordinates/sandbox")._coord2text
@@ Line 29: / Line 29: @@
 	for c1,col in ipairs(mw.text.split(args.config,",")) do
 		config[c1] = mw.text.split(col,"-")
 	end
 	local content = mw.title.new(args.page):getContent() -- read page specified
@@ Line 41: / Line 48: @@
 		local columns = mw.text.split(row,"\n|") -- split table rom into columns
 		table.remove(columns,1) -- remove content before the first \n| character
-		local qid = resolveqid(columns[1]) -- resolve qid of link in first column
+		local label = columns[1]
-		if qid then
+		if not qid then
-			v2qid = qid -- use resolved QID
+			v2 = v2 .. "CREATE" .. eol
 		end
 		local function addtov2(prop,val)
 			return v2
 		end