LemonWiki共筆 - Recent changes [en]

Accessibility

Planetoid — Wed, 30 Sep 2026 06:25:43 GMT

遵循標準、認證

← Older revision		Revision as of 14:25, 30 September 2026
Line 23:		Line 23:
	== 遵循標準、認證 ==		== 遵循標準、認證 ==
	* [http://bobby.watchfire.com/bobby/html/en/index.jsp Bobby AAA 認證]		* [http://bobby.watchfire.com/bobby/html/en/index.jsp Bobby AAA 認證]
	* World Wide Web Consortium (W3C) [http://www.w3.org/WAI/ Web Accessibility Initiative] (簡稱 WAI, 資訊網親和/可及性推動組織)，發佈的[http://www.w3.org/TR/WAI-WEBCONTENT/ Web Content Accessibility Guidelines] 1.0(簡稱WCAG 1.0）[~~http~~://~~www2~~.~~csj~~.~~ks.edu.tw~~/~~~tch023~~/~~accessibility~~/~~overint.htm~~ WCAG中文翻譯]		* World Wide Web Consortium (W3C) [http://www.w3.org/WAI/ Web Accessibility Initiative] (簡稱 WAI, 資訊網親和/可及性推動組織)，發佈的[http://www.w3.org/TR/WAI-WEBCONTENT/ Web Content Accessibility Guidelines] 1.0(簡稱WCAG 1.0）[https://www.w3.org/Translations/WCAG21-zh/ WCAG中文翻譯]
	* [http://www.section508.gov/ Section 508 認證]		* [http://www.section508.gov/ Section 508 認證]
	* [http://validator.w3.org/ HTML/XHTML 1.0 Strict 認證(Validator)]: MarkUp Validation Service		* [http://validator.w3.org/ HTML/XHTML 1.0 Strict 認證(Validator)]: MarkUp Validation Service

How to upsale image

Planetoid — Tue, 29 Sep 2026 03:37:28 GMT

Created page with "三款免費圖片解析度提高工具都能把小圖放大，但真正能把模糊的地方「修清楚」的，只有 Artguru，但是免費版會加上浮水印。用同一張 200 × 200 px 的小圖實測 iLoveIMG、PhotoGrid 和 Artguru，把結果整理成下面這張比較表。有幾個數字，和官網寫的不太一樣。 == 三款免費 AI 圖片放大工具比較表 == <table class="wikitable sortable"> <tr><th></th><th>iLoveIMG</th><th>PhotoGrid</th><t..."

New page

三款免費圖片解析度提高工具都能把小圖放大，但真正能把模糊的地方「修清楚」的，只有 Artguru，但是免費版會加上浮水印。

用同一張 200 × 200 px 的小圖實測 iLoveIMG、PhotoGrid 和 Artguru，把結果整理成下面這張比較表。有幾個數字，和官網寫的不太一樣。

== 三款免費 AI 圖片放大工具比較表 ==

<table class="wikitable sortable">
<tr><th></th><th>iLoveIMG</th><th>PhotoGrid</th><th>Artguru</th></tr>
<tr><td>'''放大方式'''</td><td>選倍率（2x、4x）</td><td>選輸出尺寸</td><td>選輸出尺寸</td></tr>
<tr><td>'''200px 小圖實測最大輸出'''</td><td>800px（4 倍）</td><td>1280px，另有 4K 選項</td><td>1024px（約 5 倍）</td></tr>
<tr><td>'''官網宣稱上限'''</td><td>4 倍，限 6MP 以下</td><td>4 倍、4K</td><td>8 倍、4K；8K 需付費</td></tr>
<tr><td>'''模糊修復效果'''</td><td>無明顯改善</td><td>無明顯改善</td><td>✅ 模糊處明顯變清晰</td></tr>
<tr><td>'''獨立畫質修復選項'''</td><td>無</td><td>無（官網稱放大時自動處理）</td><td>有</td></tr>
<tr><td>'''免費版浮水印'''</td><td>無</td><td>無</td><td>⚠️ 有</td></tr>
<tr><td>'''適合'''</td><td>只需要尺寸變大</td><td>需要較大的輸出尺寸</td><td>需要圖片真的變清晰</td></tr>
</table>

[[Category: Tool]]

User:2408:8649:2300:147:0:0:0:2

Planetoid — Mon, 21 Sep 2026 02:08:54 GMT

Planetoid blocked 2408:8649:2300:147::2 with an expiration time of 1 year (anonymous users only, account creation disabled) Removing content from pages

Robots.txt

Planetoid — Mon, 21 Sep 2026 02:08:31 GMT

Reverted edit by 2408:8649:2300:147:0:0:0:2 (talk) to last revision by Planetoid

← Older revision		Revision as of 10:08, 21 September 2026
Line 4:		Line 4:
	* [http://www.searchtools.com/robots/robots-meta.html Search Indexing Robots and the Robots META Tag - SearchTools.com]		* [http://www.searchtools.com/robots/robots-meta.html Search Indexing Robots and the Robots META Tag - SearchTools.com]
	* [http://www.google.com/support/webmasters/bin/answer.py?answer=40367 網站管理員說明中心 - 我不想將要攔截的每個檔案都列出。我可以使用* 和 $ 模式媒合嗎？]([http://www.google.com/support/webmasters/bin/answer.py?answer=40367&hl=en EN])		* [http://www.google.com/support/webmasters/bin/answer.py?answer=40367 網站管理員說明中心 - 我不想將要攔截的每個檔案都列出。我可以使用* 和 $ 模式媒合嗎？]([http://www.google.com/support/webmasters/bin/answer.py?answer=40367&hl=en EN])
			* [http://www.mediawiki.org/wiki/Robots.txt Robots.txt - MediaWiki]
			* [http://code.google.com/web/controlcrawlindex/docs/getting_started.html Getting Started - Controlling Crawling and Indexing - Google Code]


	robots.txt validator		robots.txt validator
	* [http://tool.motoricerca.info/robots-checker.phtml New Robots.txt Syntax Checker: a validator for robots.txt files]		* [http://tool.motoricerca.info/robots-checker.phtml New Robots.txt Syntax Checker: a validator for robots.txt files]


	== sitemap ==		== sitemap ==
Line 21:		Line 21:
	不希望自己的網站或網頁在google上被搜尋要求Google移掉連結		不希望自己的網站或網頁在google上被搜尋要求Google移掉連結
	* ?天: 使用[http://services.google.com/urlconsole/controller 自動網址移除系統]		* ?天: 使用[http://services.google.com/urlconsole/controller 自動網址移除系統]
	* 3-5個工作天內生效，並排除索引至少90天: 使用 [https://www.google.com/webmasters/tools/ Google 網站管理員工具]中的 URL 移除要求工具 ([http://www.google.com.tw/support/webmasters/bin/answer.py?answer=61062&ctx=sibling 說明])		* 3-5個工作天
			** 3-5個工作天內生效，並排除索引至少90天: 使用 [https://www.google.com/webmasters/tools/ Google 網站管理員工具]中的 URL 移除要求工具 ([http://www.google.com.tw/support/webmasters/bin/answer.py?answer=61062&ctx=sibling 說明])
			** 3-5個工作天: [http://www.google.com.tw/support/bin/request.py?ctx=answer 說明中心]回報選「法務問題」 via [http://khchao.blogspot.com/2007/12/google.html 威爺喔北貢: 移除Google搜尋引擎上的資料以及庫存網頁]
	* 6~8週內生效，並暫時排除索引180天: 使用robots.txt等 (說明: [http://www.google.com.tw/support/webmasters/bin/answer.py?answer=59819&topic=8459 如何確定我的內容可以從 Google 索引移除？], [http://www.google.com/intl/zh-TW/remove.html])		* 6~8週內生效，並暫時排除索引180天: 使用robots.txt等 (說明: [http://www.google.com.tw/support/webmasters/bin/answer.py?answer=59819&topic=8459 如何確定我的內容可以從 Google 索引移除？], [http://www.google.com/intl/zh-TW/remove.html])
	: more on [http://www.google.com.tw/support/webmasters/bin/answer.py?answer=35301 網站管理員說明中心 - 我如何從 Google 的索引中移除內容？]		: more on [http://www.google.com.tw/support/webmasters/bin/answer.py?answer=35301 網站管理員說明中心 - 我如何從 Google 的索引中移除內容？]
Line 35:		Line 37:
	* [[Add meta tag to movabletype]]		* [[Add meta tag to movabletype]]
	* [http://www.robbin.cc/vb/showthread.php?t=485 如何用.htaccess擋搜尋器 - WordPress歡樂正體中文交流所]		* [http://www.robbin.cc/vb/showthread.php?t=485 如何用.htaccess擋搜尋器 - WordPress歡樂正體中文交流所]
			* [http://gordon168.tw/?p=202 用Robots.txt來和搜尋機器人打交道 « 高登工作室]
			* [http://www.freegroup.org/2012/08/how-to-remove-results-from-google-yahoo-facebook/ [教學] 當個人隱私資料（電話號碼、地址）出現在 Google、Yahoo 頁庫存檔或 Facebook 時，如何請求刪除？]

	[[Category:Web_Dev]]		[[Category:Web_Dev]] [[Category:Google]]

Robots.txt

2408:8649:2300:147:0:0:0:2 — Sun, 20 Sep 2026 20:58:04 GMT

← Older revision		Revision as of 04:58, 21 September 2026
Line 4:		Line 4:
	* [http://www.searchtools.com/robots/robots-meta.html Search Indexing Robots and the Robots META Tag - SearchTools.com]		* [http://www.searchtools.com/robots/robots-meta.html Search Indexing Robots and the Robots META Tag - SearchTools.com]
	* [http://www.google.com/support/webmasters/bin/answer.py?answer=40367 網站管理員說明中心 - 我不想將要攔截的每個檔案都列出。我可以使用* 和 $ 模式媒合嗎？]([http://www.google.com/support/webmasters/bin/answer.py?answer=40367&hl=en EN])		* [http://www.google.com/support/webmasters/bin/answer.py?answer=40367 網站管理員說明中心 - 我不想將要攔截的每個檔案都列出。我可以使用* 和 $ 模式媒合嗎？]([http://www.google.com/support/webmasters/bin/answer.py?answer=40367&hl=en EN])
	* [http://www.mediawiki.org/wiki/Robots.txt Robots.txt - MediaWiki]
	* [http://code.google.com/web/controlcrawlindex/docs/getting_started.html Getting Started - Controlling Crawling and Indexing - Google Code]


	robots.txt validator		robots.txt validator
	* [http://tool.motoricerca.info/robots-checker.phtml New Robots.txt Syntax Checker: a validator for robots.txt files]		* [http://tool.motoricerca.info/robots-checker.phtml New Robots.txt Syntax Checker: a validator for robots.txt files]


	== sitemap ==		== sitemap ==
Line 21:		Line 21:
	不希望自己的網站或網頁在google上被搜尋要求Google移掉連結		不希望自己的網站或網頁在google上被搜尋要求Google移掉連結
	* ?天: 使用[http://services.google.com/urlconsole/controller 自動網址移除系統]		* ?天: 使用[http://services.google.com/urlconsole/controller 自動網址移除系統]
	* 3-5個工作天		* 3-5個工作天內生效，並排除索引至少90天: 使用 [https://www.google.com/webmasters/tools/ Google 網站管理員工具]中的 URL 移除要求工具 ([http://www.google.com.tw/support/webmasters/bin/answer.py?answer=61062&ctx=sibling 說明])
	** 3-5個工作天內生效，並排除索引至少90天: 使用 [https://www.google.com/webmasters/tools/ Google 網站管理員工具]中的 URL 移除要求工具 ([http://www.google.com.tw/support/webmasters/bin/answer.py?answer=61062&ctx=sibling 說明])
	** 3-5個工作天: [http://www.google.com.tw/support/bin/request.py?ctx=answer 說明中心]回報選「法務問題」 via [http://khchao.blogspot.com/2007/12/google.html 威爺喔北貢: 移除Google搜尋引擎上的資料以及庫存網頁]
	* 6~8週內生效，並暫時排除索引180天: 使用robots.txt等 (說明: [http://www.google.com.tw/support/webmasters/bin/answer.py?answer=59819&topic=8459 如何確定我的內容可以從 Google 索引移除？], [http://www.google.com/intl/zh-TW/remove.html])		* 6~8週內生效，並暫時排除索引180天: 使用robots.txt等 (說明: [http://www.google.com.tw/support/webmasters/bin/answer.py?answer=59819&topic=8459 如何確定我的內容可以從 Google 索引移除？], [http://www.google.com/intl/zh-TW/remove.html])
	: more on [http://www.google.com.tw/support/webmasters/bin/answer.py?answer=35301 網站管理員說明中心 - 我如何從 Google 的索引中移除內容？]		: more on [http://www.google.com.tw/support/webmasters/bin/answer.py?answer=35301 網站管理員說明中心 - 我如何從 Google 的索引中移除內容？]
Line 37:		Line 35:
	* [[Add meta tag to movabletype]]		* [[Add meta tag to movabletype]]
	* [http://www.robbin.cc/vb/showthread.php?t=485 如何用.htaccess擋搜尋器 - WordPress歡樂正體中文交流所]		* [http://www.robbin.cc/vb/showthread.php?t=485 如何用.htaccess擋搜尋器 - WordPress歡樂正體中文交流所]
	* [http://gordon168.tw/?p=202 用Robots.txt來和搜尋機器人打交道 « 高登工作室]
	* [http://www.freegroup.org/2012/08/how-to-remove-results-from-google-yahoo-facebook/ [教學] 當個人隱私資料（電話號碼、地址）出現在 Google、Yahoo 頁庫存檔或 Facebook 時，如何請求刪除？]

	[[Category:Web_Dev~~]] [[Category:Google~~]]		[[Category:Web_Dev]]

Troubleshooting of MySQLTuner

Planetoid — Fri, 18 Sep 2026 09:53:15 GMT

← Older revision		Revision as of 17:53, 18 September 2026
Line 2:		Line 2:

	__TOC__		__TOC__


			{{Tips}} Quick command: {{kbd \| key=<nowiki>perl mysqltuner.pl --host 127.0.0.1</nowiki>}}

	== How to resolve: (Cygwin) couldn't find diagnostic data ==		== How to resolve: (Cygwin) couldn't find diagnostic data ==

Testing

Planetoid — Fri, 18 Sep 2026 08:59:08 GMT

domain name issue

← Older revision		Revision as of 16:59, 18 September 2026
Line 35:		Line 35:
	=== domain name issue ===		=== domain name issue ===
	Modify the following files if you want to test the domain name before the mapping of domain name and ip was changed really		Modify the following files if you want to test the domain name before the mapping of domain name and ip was changed really
	* ~~C:\WINDOWS\system32\drivers\etc\hosts for~~ {{win}} XP, Win7<ref>[http://tommy.ironman.tw/windows-7-vista-hosts-error/ Azan 黃贊臣 » 在Windows 7 或 Vista 中修改hosts檔的方法]</ref>, Win 10 & Windows Server 2008 R2 Standard		* For {{win}} XP, Win7<ref>[http://tommy.ironman.tw/windows-7-vista-hosts-error/ Azan 黃贊臣 » 在Windows 7 或 Vista 中修改hosts檔的方法]</ref>, Win 10 & Windows Server 2008 R2 Standard: {{kbd \| key=<nowiki>C:\WINDOWS\system32\drivers\etc\hosts</nowiki>}}
	* On Windows 2003 server: edit the file located at {{kbd \| key=<nowiki>C:\WINNT\system32\drivers\etc\hosts</nowiki>}}		* On Windows 2003 server: edit the file located at {{kbd \| key=<nowiki>C:\WINNT\system32\drivers\etc\hosts</nowiki>}}
	* On {{Linux}}, input the command {{kbd \| key=<nowiki>sudo vi /etc/hosts</nowiki>}}		* On {{Linux}}, input the command {{kbd \| key=<nowiki>sudo vi /etc/hosts</nowiki>}}

Input method editor

Planetoid — Fri, 18 Sep 2026 03:42:55 GMT

← Older revision		Revision as of 11:42, 18 September 2026
Line 1:		Line 1:
	Input Method Editor (IME) ~~輸入法~~		Input Method Editor (IME) 輸入法：透過鍵盤按鍵或滑鼠移動選字的軟體

	== 免費輸入法 ==		== 免費輸入法 ==

Troubleshooting of Claude

Planetoid — Fri, 18 Sep 2026 03:29:33 GMT

How to Fix Missing Markdown Copy and Download Options in Claude Web Artifacts

← Older revision		Revision as of 11:29, 18 September 2026
Line 142:		Line 142:

	For a detailed step-by-step guide with screenshots, see: [https://errerrors.blogspot.com/2026/04/fixing-unknown-oauth-client-error-when.html Fixing "Unknown OAuth client" Error When Connecting Notion MCP in Claude Code] (written primarily in Traditional Chinese)		For a detailed step-by-step guide with screenshots, see: [https://errerrors.blogspot.com/2026/04/fixing-unknown-oauth-client-error-when.html Fixing "Unknown OAuth client" Error When Connecting Notion MCP in Claude Code] (written primarily in Traditional Chinese)

			=== How to Fix Missing Markdown Copy and Download Options in Claude Web Artifacts ===

			'''Error Details'''

			Artifacts created in the Claude web app cannot directly copy or download the original Markdown or Mermaid source. The Artifact menu does not provide '''Copy''', '''Source''', '''Code''', or '''Download''' options.

			'''Affected Scope'''

			Artifacts created through the Claude web app.

			'''Suggestions'''

			# Paste the Artifact content directly into the conversation and ask Claude to reproduce it as raw Markdown.
			# Alternatively, ask Claude to generate a downloadable <code>.md</code> file.

			'''Possible Root Cause'''

			Claude recently unified Chat, Cowork, Artifacts, Docs, and Slides under a redesigned interface. The source-copying and downloading features may not have been migrated to the new web interface yet, or the current interface may prioritize collaboration, sharing, and canvas-based editing.

			'''References''':

			# [https://support.claude.com/en/articles/9547008-publishing-remixing-and-sharing-artifacts Claude Help Center: Publish and share artifacts]
			# [https://claude.com/features/artifacts Claude: Artifacts]
			# [https://www.reuters.com/business/media-telecom/anthropic-fold-claude-ai-features-into-one-interface-launches-document-tools-2026-09-16/ Reuters: Anthropic unifies Claude features and launches document tools]

	== Further reading ==		== Further reading ==

Input method editor

Planetoid — Fri, 18 Sep 2026 02:37:19 GMT

免費輸入法

← Older revision		Revision as of 10:37, 18 September 2026
Line 38:		Line 38:
	* 授權方式：[https://github.com/rime/librime/blob/master/LICENSE BSD 3-Clause "New" or "Revised" License]		* 授權方式：[https://github.com/rime/librime/blob/master/LICENSE BSD 3-Clause "New" or "Revised" License]

	Yahoo! 奇摩輸入法 {{exclaim}} ~~可能有相容性問題~~		[https://github.com/chiakich/ChiaKey chiakich/ChiaKey: 千秋輸入法 ChiaKey: a modern macOS Traditional Chinese input method revival based on Yahoo KeyKey/OpenVanilla] {{access \| date =2026-09-10}}
			* 作業系統：{{Mac}}
			* 輸入法：注音、倉頡、簡易
			* 授權方式：[https://github.com/chiakich/ChiaKey/blob/main/LICENSE BSD 3-Clause "New" or "Revised" License]


			Yahoo! 奇摩輸入法 {{exclaim}} 新版 macOS 有相容問題
	* [https://github.com/YahooArchive/KeyKey YahooArchive/KeyKey] on {{Win}} & {{Mac}} {{access \| date =2019-01-15}} {{exclaim}} macOS Catalina 無法使用。介紹：[https://free.com.tw/yahoo-keykey/ Mac 最推薦輸入法！Yahoo! 奇摩輸入法免費下載點及安裝教學]		* [https://github.com/YahooArchive/KeyKey YahooArchive/KeyKey] on {{Win}} & {{Mac}} {{access \| date =2019-01-15}} {{exclaim}} macOS Catalina 無法使用。介紹：[https://free.com.tw/yahoo-keykey/ Mac 最推薦輸入法！Yahoo! 奇摩輸入法免費下載點及安裝教學]

Troubleshooting of MySQL errors

Planetoid — Thu, 17 Sep 2026 02:47:59 GMT

SQLSTATE[HY000] [2002] Can't assign requested address

← Older revision		Revision as of 10:47, 17 September 2026
Line 547:		Line 547:
	It typically occurs when your application is unable to establish a connection to the specified database server.		It typically occurs when your application is unable to establish a connection to the specified database server.

			=== Resolving "Host 'xx.xx.xxx.xxx' is blocked because of many connection errors" ===

			Error Message

			<pre>
			Host 'xx.xx.xxx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
			</pre>

			Understanding the Issue

			(1) Check the threshold value

			MySQL's mechanism works as follows: once the same source host (identified by IP or hostname) accumulates a number of "connection errors" reaching the value configured in `max_connect_errors`, MySQL automatically blocks that source and refuses further connections from it.

			<pre>
			SHOW VARIABLES LIKE 'max_connect_errors';
			</pre>

			The threshold found was 100.

			(2) Check which hosts are currently recorded/blocked

			<pre>
			SELECT IP, HOST, SUM_CONNECT_ERRORS, COUNT_HOST_BLOCKED_ERRORS
			FROM performance_schema.host_cache
			ORDER BY SUM_CONNECT_ERRORS DESC;
			</pre>

			Confirmed that the only blocked IP is `xx.xx.xxx.xxx`, with `SUM_CONNECT_ERRORS` exactly matching the threshold of 100, and no other IPs were affected.


			Resolving the Issue

			⚠️ Note: `flush-hosts` / `FLUSH HOSTS` clears the entire host cache, not just a single IP. If the query results show records for other hosts as well, they will all be reset at the same time. For a shared production environment, it's recommended to confirm with other administrators before running this.

			(1) In a terminal or command prompt, run:

			<pre>
			mysqladmin -u root -p flush-hosts
			</pre>

			or

			<pre>
			mysql -u root -p
			Once inside the MySQL shell, run: FLUSH HOSTS;
			</pre>

			Note: The `FLUSH HOSTS` syntax has been deprecated since MySQL 8.0.23 and removed in 8.4<ref>[https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html MySQL :: MySQL 8.4 Reference Manual :: 29.12.22.3 The host_cache Table]</ref><ref>[https://oneuptime.com/blog/post/2026-03-31-mysql-fix-max-connect-errors-blocked-hosts/view How to Fix max_connect_errors and Blocked Hosts in MySQL]</ref>. If your environment is on a newer version, use the officially recommended alternative instead:
			<pre>
			TRUNCATE TABLE performance_schema.host_cache;
			</pre>

			(2) Verify after execution

			<pre>
			SELECT IP, HOST, SUM_CONNECT_ERRORS, COUNT_HOST_BLOCKED_ERRORS
			FROM performance_schema.host_cache
			ORDER BY SUM_CONNECT_ERRORS DESC;
			</pre>

			Result: no rows returned (0 rows), indicating the host cache has been cleared — the previous connection error counts and blocked status have been reset, and the IP should now be able to connect normally.

	=== Transfer Data from MySQL to MSSQL ===		=== Transfer Data from MySQL to MSSQL ===

排除 MySQL 技術疑難問題

Planetoid — Thu, 17 Sep 2026 02:46:59 GMT

錯誤 2013: 在查詢過程中與 MySQL 伺服器失去連接

@@ Line 532: / Line 532: @@
 INSERT IGNORE INTO `target`.`table` SELECT * FROM `source`.`table` LIMIT 0, 10000;
 </pre>
 === 從 MySQL 資料轉移至 MSSQL ===

Extract domain from text

Planetoid — Tue, 15 Sep 2026 11:16:52 GMT

Using Google Sheets to extract domains

@@ Line 20: / Line 20: @@
 Explanation:
-* Domain refers to text that starts with <nowiki>http://</nowiki> or <nowiki>https://</nowiki>, followed by multiple characters that are not the symbol {{kbd | key = <nowiki>/</nowiki>}}: {{kbd | key = <nowiki>[^/]+</nowiki>}}. =
+* Domain refers to text that starts with <nowiki>http://</nowiki> or <nowiki>https://</nowiki>, followed by multiple characters that are not the symbol {{kbd | key = <nowiki>/</nowiki>}}: {{kbd | key = <nowiki>[^/]+</nowiki>}}.
 == Data Validation: Does the article content contain a domain ==

PDF to Markdown Conversion

Planetoid — Tue, 15 Sep 2026 09:42:44 GMT

← Older revision		Revision as of 17:42, 15 September 2026
(4 intermediate revisions by the same user not shown)
Line 1:		Line 1:
	= PDF to Markdown Conversion =		PDF to Markdown Conversion

	== Introduction ==		{{Tips}} Many people recommend MarkItDown, a tool developed by Microsoft, which works well on text-based PDFs but requires enabling its OCR plugin for image-based PDFs and even then, conversions can still fail;

			for Chinese-language PDFs in particular, the OCR models with better accuracy tend to come from Chinese vendors, which adds the extra burden of converting between Simplified and Traditional Chinese and proofreading the results, making this data-cleaning process quite labor-intensive, so by comparison, converting documents directly with a multimodal large language model turns out to be more efficient.

			== 1. Text-Based PDFs ==

			If the PDF content is primarily text-based, you can use:

			* [https://github.com/microsoft/markitdown MarkItDown] (consumes no AI tokens)
			* If you don't need Markdown formatting and just want to extract plain text, you can also use <code>pdftotext</code> https://www.xpdfreader.com/pdftotext-man.html

			== 2. Image-Based PDFs ==

			If the PDF content is primarily image-based (scanned documents, screenshots, charts, etc.), it's recommended to:

			* Use a model with vision/graphical recognition or multimodal capabilities directly, such as GPT-4.5 (consumes AI tokens)
			* Or use the [https://github.com/microsoft/markitdown/blob/main/packages/markitdown-ocr/README.md MarkItDown OCR Plugin] (consumes AI tokens), though it tends to make mistakes with more complex charts/diagrams

			=== Introduction ===

	This prompt is designed to convert a PDF document into structured Markdown while preserving not only its textual content, but also information contained in images, charts, screenshots, scanned pages, diagrams, and other visual elements.		This prompt is designed to convert a PDF document into structured Markdown while preserving not only its textual content, but also information contained in images, charts, screenshots, scanned pages, diagrams, and other visual elements.
Line 7:		Line 25:
	The goal is to produce a Markdown representation that preserves the original document as faithfully as possible, including its content, structure, reading order, tables, formatting, visually embedded text, and source references.		The goal is to produce a Markdown representation that preserves the original document as faithfully as possible, including its content, structure, reading order, tables, formatting, visually embedded text, and source references.

	== Model Requirements ==		=== Model Requirements ===

	This prompt should be used with an AI model that supports '''vision, image understanding, or multimodal input'''.		This prompt should be used with an AI model that supports '''vision, image understanding, or multimodal input'''.
Line 23:		Line 41:
	A text-only model, or a PDF processing pipeline that extracts only the PDF text layer, is '''not sufficient''' for this task because text embedded in screenshots, scanned pages, charts, diagrams, or other images may otherwise be omitted.		A text-only model, or a PDF processing pipeline that extracts only the PDF text layer, is '''not sufficient''' for this task because text embedded in screenshots, scanned pages, charts, diagrams, or other images may otherwise be omitted.

	== ~~Task~~ ==		=== Prompt ===

	Prompt		Prompt
Line 90:		Line 108:

	</pre>		</pre>

			== Similar tools ==
			* [https://github.com/microsoft/markitdown microsoft/markitdown: Python tool for converting files and office documents to Markdown.] & its [https://github.com/microsoft/markitdown/blob/main/packages/markitdown-ocr/README.md MarkItDown OCR Plugin]

	== References ==		== References ==
Line 95:		Line 116:

	[[Category: Tools]]		[[Category: Tools]]
			[[Category: PDF Processing]]
			[[Category: Document Conversion]]

PDF conversion

Planetoid — Tue, 15 Sep 2026 08:41:05 GMT

PDF 轉換成純文字 (TXT)

← Older revision		Revision as of 16:41, 15 September 2026
Line 28:		Line 28:
	* License: [https://github.com/ArtifexSoftware/mupdf?tab=AGPL-3.0-1-ov-file GNU AFFERO GENERAL PUBLIC LICENSE]		* License: [https://github.com/ArtifexSoftware/mupdf?tab=AGPL-3.0-1-ov-file GNU AFFERO GENERAL PUBLIC LICENSE]
	* Usage: {{kbd \| key=<nowiki>mutool draw -F txt -o PDF-file text-file</nowiki>}}		* Usage: {{kbd \| key=<nowiki>mutool draw -F txt -o PDF-file text-file</nowiki>}}


			==== PDF 轉換成 Markdown (md) ====
			[[PDF to Markdown Conversion]]

	==== PDF 轉換成 Word 或 RTF ====		==== PDF 轉換成 Word 或 RTF ====

PDF to Markdown Conversion

Planetoid — Tue, 15 Sep 2026 08:39:46 GMT

Created page with "= PDF to Markdown Conversion = == Introduction == This prompt is designed to convert a PDF document into structured Markdown while preserving not only its textual content, but also information contained in images, charts, screenshots, scanned pages, diagrams, and other visual elements. The goal is to produce a Markdown representation that preserves the original document as faithfully as possible, including its content, structure, reading order, tables, formatting, vis..."

New page

= PDF to Markdown Conversion =

== Introduction ==

This prompt is designed to convert a PDF document into structured Markdown while preserving not only its textual content, but also information contained in images, charts, screenshots, scanned pages, diagrams, and other visual elements.

The goal is to produce a Markdown representation that preserves the original document as faithfully as possible, including its content, structure, reading order, tables, formatting, visually embedded text, and source references.

== Model Requirements ==

This prompt should be used with an AI model that supports '''vision, image understanding, or multimodal input'''.

The model must be capable of analyzing visual content inside a PDF, rather than relying solely on text extracted from the PDF's text layer.

Examples of suitable multimodal or vision-capable models include:

* '''OpenAI:''' GPT-4.5<ref>[https://openai.com/zh-Hant/index/introducing-gpt-4-5/ 隆重介紹 GPT-4.5 | OpenAI]</ref>, GPT-4.1, GPT-5 series
* '''Google:''' Gemini models with multimodal/image understanding capabilities, such as Gemini 2.5 Flash<ref>[https://ai.google.dev/gemini-api/docs/models/gemini-2.5-flash?hl=zh-tw Gemini 2.5 Flash | Gemini API | Google AI for Developers]</ref> or Gemini 2.5 Pro
* '''Anthropic:''' Claude models with vision/image-input support

Equivalent or newer multimodal models or models with vision capabilities may also be used, provided that they can inspect images and graphical content contained within the PDF.

A text-only model, or a PDF processing pipeline that extracts only the PDF text layer, is '''not sufficient''' for this task because text embedded in screenshots, scanned pages, charts, diagrams, or other images may otherwise be omitted.

== Task ==

Prompt
<pre>

I will provide a PDF file. Convert its contents into Markdown-formatted text.

Please follow these requirements:

# If the PDF contains images, charts, screenshots, scanned pages, diagrams, or other graphical content, inspect the visual content and extract '''all readable text contained within it'''.

Transcribe that text into the Markdown output. Do not omit text simply because it is embedded in an image rather than stored in the PDF text layer.

# If a graphical element contains no text, such as a photograph, icon, illustration, or purely visual diagram, do not skip it.

Represent it using the following format:

<code>[Image: Brief description of its content or purpose]</code>

# Preserve the original document's structure and hierarchy as closely as possible, including:

* Headings (<code>#</code>, <code>##</code>, <code>###</code>, etc.)
* Paragraphs
* Ordered and unordered lists
* Tables
* '''Bold text'''
'' ''Italic text*
* Blockquotes
* Code blocks
* Other meaningful structural formatting

# Convert tables into standard Markdown table syntax whenever possible.

If a table is too complex to reproduce accurately in Markdown, explain the limitation and preserve the relationships between rows, columns, headers, and values as faithfully as possible.

# If a page contains both textual and graphical content, preserve the original '''reading order'''.

Insert transcribed image content or image descriptions at the position where the corresponding visual element appears in the document.

# Do not add, rewrite, correct, infer, summarize, or guess information that does not appear in the original PDF.

The output should be a transcription and structural conversion, not an interpretation of the document.

# If any text is blurry, obscured, incomplete, or otherwise impossible to identify reliably, use:

<code>[Unrecognizable]</code>

Do not guess the missing text.

# When both the PDF text layer and the visual rendering contain the same text, avoid unnecessary duplication.

Prefer the version that most accurately represents the document while preserving visually significant information that may not exist in the text layer.

# Pay particular attention to visual elements that commonly contain important text, including:

* Screenshots
* Scanned documents
* Infographics
* Flowcharts
* Charts and graphs
* Forms
* Presentation slides embedded in the PDF
* Captions and annotations
* Labels inside diagrams
* Text rendered as part of an image

</pre>

== References ==
<references />

[[Category: Tools]]

Timer

Planetoid — Tue, 15 Sep 2026 03:23:03 GMT

Linux command (BASH)

@@ Line 29: / Line 29: @@
 # expected result:
 #   Elapsed time 00h:00m:02s
 </pre>

Speech to text

Planetoid — Fri, 11 Sep 2026 02:18:57 GMT

← Older revision		Revision as of 10:18, 11 September 2026
(One intermediate revision by the same user not shown)
Line 153:		Line 153:

	== Related pages ==		== Related pages ==
			* [https://en.wikipedia.org/wiki/Speech_recognition Speech recognition] ([https://zh.wikipedia.org/zh-tw/%E8%AF%AD%E9%9F%B3%E8%AF%86%E5%88%AB 語音辨識], Automatic Speech Recognition，簡稱 ASR)
	* [[Video to text]]		* [[Video to text]]
	* [[Taiwanese Mandarin Text-to-Speech Services]]		* [[Taiwanese Mandarin Text-to-Speech Services]]
Line 158:		Line 159:
	* [[Troubleshooting of Olami speech to text]]		* [[Troubleshooting of Olami speech to text]]
	* [[Troubleshooting of whisperX]]		* [[Troubleshooting of whisperX]]

			== References ==
			<references />

	[[Category: Tool]]		[[Category: Tool]]

Troubleshooting of whisperX

Planetoid — Thu, 10 Sep 2026 05:34:47 GMT

WhisperX Speaker Diarization Issue

← Older revision		Revision as of 13:34, 10 September 2026
(One intermediate revision by the same user not shown)
Line 20:		Line 20:
	# Enter <code>export HF_TOKEN='your Hugging Face token'</code>		# Enter <code>export HF_TOKEN='your Hugging Face token'</code>
	# Run bash command		# Run bash command


			=== WhisperX Speaker Diarization Issue ===

			'''Problem''': Speaker diarization failed on an interview transcript — over 500 segments were all labeled `SPEAKER_00`, even though it was clearly a two-person Q&A interview. The output looked like a single person talking.

			'''Solution'''
			Installed the new whisperx 3.8.6 (torch 2.8 cu126) in a venv. Diarization automatically switched to use the new-generation `pyannote/speaker-diarization-community-1` model.

			'''Version Info'''
			Old environment: whisperX 3.1.1

	=== Repeated Same Dialog Issue ===		=== Repeated Same Dialog Issue ===

Anomaly detection

2001:B011:D804:9E4D:75B0:760:554F:27C4 — Sun, 06 Sep 2026 08:23:24 GMT

← Older revision		Revision as of 16:23, 6 September 2026
Line 40:		Line 40:

	== References ==		== References ==

	<references />		<references />

	[[Category: Data hygiene]]		[[Category: Data hygiene]]
	[[Category: Data Science]]		[[Category: Data Science]]

Anomaly detection

Planetoid — Sun, 06 Sep 2026 08:10:42 GMT

← Older revision		Revision as of 16:10, 6 September 2026
(2 intermediate revisions by the same user not shown)
Line 12:		Line 12:

	== Anomaly detection for time series data ==		== Anomaly detection for time series data ==
	* Trend		* Trend: For example, holiday and seasonal factors typically drive consistent, predictable shopping behavior, but an unexpected shift in product category suddenly occurs
	* ~~Dramatically Increase~~ or decrease ~~of rows~~ count for each time period		* Dramatic increase or decrease in row count for each time period
	** Example: ~~Regularly~~ scheduled web ~~scraping~~ that collects 9k records per week suddenly drops to 3k records		** Example: A regularly scheduled web scraper that normally collects 9k records per week suddenly drops to 3k records
			* Future data: Data timestamps fall outside (after) the expected time range

	== Anomaly detection for consumer data ==		== Anomaly detection for consumer data ==
Line 32:		Line 33:

	More on: [https://en.wikipedia.org/wiki/Outlier#Identifying_outliers Outlier - Wikipedia]		More on: [https://en.wikipedia.org/wiki/Outlier#Identifying_outliers Outlier - Wikipedia]

			== Further Reading ==

			# [https://www.amazon.com/Bad-Data-Handbook-Cleaning-Back-ebook/dp/B00A3IGAIA Amazon.com: Bad Data Handbook: Cleaning Up The Data So You Can Get Back To Work eBook : McCallum, Q. Ethan: Kindle Store] (ISBN: 9781449324964)
			# [https://www.oreilly.com/library/view/bad-data-ji-shu-shou-ce/9789862768952/ Bad Data 技術手冊 [Book]] (ISBN: 9789862768952)

	== References ==		== References ==