不知道怎麼下後設資料？用AI幫你添增索引關鍵字  / Don't Know How to Add Metadata? Use AI to Write Keywords

我開發了一個家用的倉儲管理系統來記錄家裡物品的收納位置和存量。為了讓我更容易用搜尋找到物品，我使用Google Gemini來解析物品的照片，以此來添增後設資料(metadata)，提高它被檢索找到的機會。使用下來意外地好用，但也有些限制。這篇就記錄一下這種用AI識別照片添增物品後設資料的心得吧。

I developed a home inventory management system to track the location and quantity of items in my house. To make searching for items easier, I use Google Gemini to analyze photos of the items, adding metadata to increase their searchability. It's surprisingly effective, but it also has some limitations. This post documents my experience using AI image recognition to enhance item metadata.

雜談：不是每個API都叫做OpenAI的API / TALK: Not Every API Is Called OpenAI’s API

最近遇上太多「號稱背後是OpenAI」的大型語言模型API，但實際上並不是「OpenAI的API」的狀況。這種誤解造成實際開發時帶來很大的困擾，我們藉這個機會說明一下吧。

解鎖或加密PDF檔案：Colab PDF Protector / Unlocking or Encrypting PDF Files: Colab PDF Protector

PDF檔案的安全性加密與解除限制通常需要特別的軟體。如果我們只有手機的話，不妨來使用我開發的Colab PDF Protector，用Google Colab的腳本新增或移除PDF的安全性設定吧。

PDF file security encryption and decryption often require specialized software. If you only have a mobile phone, consider using my Colab PDF Protector, a Google Colab script designed to add or remove security settings from PDFs.

雜談：從不懂到改寫別人的VBA不難，但對心臟不太好 / TALK: From Novice to VBA Rewriter: An Easy but Stressful Journey

最近幫別人改寫老舊Excel上的VBA，讓使用者能直接從輸入資料到彙整成可以列印的格式，而避免大量的複製、貼上操作。寫是寫完了，但內心真是五味雜陳。

移除PDF上的註解：PDF Annotation Remover / Removing Annotations from PDFs: PDF Annotation Remover

PDF的註解功能可以允許我們在原始檔案上添增額外的文字、標亮、線條、筆記。而且這些註解還可以刪除、修改，讓原始檔案保持它原本的樣子。不過如果有大量註解需要移除的話，手動操作其實非常繁瑣。這時候你可以用我開發的PDF Annotation Remover，讓PDF檔案的註解全部移除吧。

PDF's annotation feature allows us to add additional text, highlights, lines, and notes directly onto the original file. These annotations can also be deleted or modified, preserving the original document's integrity. However, manually removing a large number of annotations can be quite tedious. For this, you can use my PDF Annotation Remover to remove all annotations from your PDF file.

雜談：為了管理Stable Diffusion提示詞而用AppSheet開發了工具 / Talk: I Developed a Tool Using AppSheet to Manage Stable Diffusion Prompts

由於我會在越來越地方使用Stable Diffusion繪圖，所以我花了一些時間用AppSheet做了提示詞管理工具。這篇就來聊一下我做了那些東西。

將PDF轉換成模仿成掃描檔：ScanSim PDF / Converting PDF to Simulated Scanned Document: ScanSim PDF

列印、簽名、拍照、轉換成PDF、上傳，這是現在很多證明文件的處理手續。處理後的PDF檔案只是圖片的封裝，不能直接選取與複製，只能作為證明文件留存，這已經是最基本的資安防護手段。然而，如果可以將數位文件直接轉換成彷彿掃描檔一樣的檔案，那不就可以省下列印與掃描的繁雜手續了嗎？也許這時候Docker APP ScanSim PDF就能夠派上用場了。

Printing, signing, taking a photo, converting it to PDF, and uploading it—this is the procedure for processing many verification documents nowadays. The processed PDF file is merely a container for the image; the text cannot be directly selected or copied. It can only serve as an archive of the verification document, which is a basic security measure. However, if digital documents could be directly converted into files that resemble scanned documents, wouldn't that eliminate the tedious printing and scanning steps? Perhaps the Docker APP ScanSim PDF could be useful in this situation.