I cover the options for three different potential audiences: 1. Novice, 2. Intermediate, and 3. Developer.<\/p>\n\n\n\n
Step 1: Planning<\/h3>\n\n\n\n
The initial step, regardless of your skill level, involves: 1) Physical Document Assessment, and 2) Digitization Strategy.<\/p>\n\n\n\n
- \n
- Physical Document Assessment\n
- \n
- Evaluate your document conditions and quality<\/li>\n\n\n\n
- Make note of recurring patterns and structures<\/li>\n\n\n\n
- Identify special formatting and tables<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Digitization Strategy\n
- \n
- Defined desired output format (e.g., JSON, CSV, XML, TXT)<\/li>\n\n\n\n
- Identify data you want to extract<\/li>\n\n\n\n
- Establish data validation requirements<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n
In my case, my documents were in good condition but were complex because they lacked a uniform set of patterns and structures between issues. This prevented me from using a single schema or template across the issues.<\/p>\n\n\n\n
Step 2: Digitization<\/h3>\n\n\n\n
This step in the project involves converting the print documents into digital format. For this step, you will need a scanner or a smartphone with a scanning app (e.g., Adobe Scan, Microsoft Lens). <\/p>\n\n\n\n
Before I go through the steps of digitizing the directories, here is a view of the 1996 issue of Directory of Literary Magazines<\/em> before digitization. All 10 issues of the directory looked very similar to this issue.<\/p>\n\n\n\n
![\"Photo](\"https:\/\/digitalborn.org\/wp-content\/uploads\/2024\/04\/directory-clmp-1996-1024x448.jpg\")
<\/a><\/figure>\n\n\n\nIn order to prepare the book for scanning, I first loosened the binding glue in order to remove the cover. I applied the hot metal on the end of my soldering iron to the spine of the book, which allowed me to non-destructively remove the cover. Next, I used a razor blade to scrape the glue from the spine. <\/p>\n\n\n\n
I then pulled the pages away from the binding in sections of between 80 to 100 pages, and the removal of approximately 1\/4 inch from the binding edge was performed using a paper trimmer.<\/p>\n\n\n\n
![\"Photo](\"https:\/\/digitalborn.org\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-07-at-5.13.38\u202fPM-239x300.png\")
<\/a><\/figure>\n\n\n\nThe resulting trimmed pages provided me with a consistent and a clean page edge that prevented jamming the document scanner, albeit at the expense of the periodical’s original margins.<\/p>\n\n\n\n
After trimming the binding edge, I manually checked pages to ensure they were unbound to other pages. I then put the pages into the document scanner (in this case, a Raven Pro Document Scanner), and set the scanning for two-sided, color, and 300 dots per inch (dpi). I used 300 dpi because this is what was recommended for scan resolution for improved accuracy of Optical Character Recognition (OCR) processing in the Adobe Acrobat Pro documentation (Adobe, 2024).<\/p>\n\n\n\n
![\"\"](\"https:\/\/digitalborn.org\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-07-at-5.16.52\u202fPM-300x274.png\")
<\/a><\/figure>\n\n\n\n<\/p>\n\n\n\n
Step 3: PDF to Text Conversion<\/h3>\n\n\n\n
The next step in the project is to convert the scanned PDF files into plain text format. In the scenario that we’re describing, the documents will typically be “flat” in an image format. This requires some type of OCR to extract the information. It’s at this stage, that the approach starts to diverge depending on your background and resources:<\/p>\n\n\n\n
- \n
- Novice
Use a cloud service that allows you to upload files and define a document schema. The best option for this in my experience is Airparser, which provides multiple upload options, simple schema creation and validation, and multiple output options.<\/li>\n\n\n\n - Intermediate
You can use existing python libraries such as Tesseract<\/a> to OCR the files. You can also purpose-built software for this such as Adobe Acrobat Pro or pdf2go. <\/li>\n\n\n\n- Developer
Claude recently released a beta feature called Claude PDF Support<\/a>. Depending on the complexity of your documents, this API simplifies the process because you can send any PDF file to the endpoint and it will both extract the text and provide parsing. Another route is to convert the scans into base64 and send these to OpenAI API or Claude API for extraction and output.<\/li>\n<\/ul>\n\n\n\nIn my case, I used Azure Vision for the OCR step. If I were to do this today, I would use Claude PDF Support. At the time I was choosing between Adobe Acrobat Pro and Azure Vision. I used Azure Vision image-to-text processing because it was much more accurate than Adobe Acrobat Pro OCR (in January 2024, anyway). However, if you do not want to spend money on Azure Vision or Adobe Acrobat Pro, I have had good success with pdf2go. This process laid the foundation for the subsequent data cleaning and extraction stages.<\/p>\n\n\n\n
Step 4: Data Cleaning<\/h3>\n\n\n\n
Once the PDFs are converted to text files, the next step involves cleaning the data to ensure its usability. This step differs somewhat depending on experience and resources:<\/p>\n\n\n\n
- \n
- Novice
If you use Airparser, you will need to manually spot check your output to make sure it is outputting accurately. If you notice errors, you should adjust your document template in Airparser and iterate on your prompt. <\/li>\n\n\n\n - Intermediate & Developer
For this step, I would recommend sending the extracted text to either Claude or OpenAI API for review and cleaning. After that step, manually review the output to ensure it is accurate. If there are accuracy errors, revise your prompt.<\/li>\n<\/ul>\n\n\n\nRegardless of which approach you take, you should provide the expected output and validation for the model to review. For example, if you are using JSON, provide the objects and values you expect to be returned and examples of the type of information that would be included as values. Use this information in your prompt to validate and set requirements.<\/p>\n\n\n\n
In my project, this process included:<\/p>\n\n\n\n
- \n
- Extracting the main content by removing the foreword and indices of the original book.<\/li>\n\n\n\n
- Eliminating page numbers and headers that were not part of the listing data.<\/li>\n\n\n\n
- Manually identifying and correcting errors in the text resulting from the AI conversion process.<\/li>\n\n\n\n
- Utilizing a code script to remove any extra spaces in the text files.<\/li>\n<\/ol>\n\n\n\n
These cleaning steps were crucial in preparing the data for the extraction phase.<\/p>\n\n\n\n
Step 5: Data Parsing<\/h3>\n\n\n\n
Now that you have clean and accurate text, you can perform parsing and logic on the information. For example, say you were extracting information from academic transcripts. Once you have extracted the data, cleaned it, and have a reliable JSON output, you could then perform calculations or analysis. In the academic transcript example, this could include something like calculating “last half GPA” and providing some logic in the prompt for determining how to add up the last half of credits from the transcript and averaging the GPA.<\/p>\n\n\n\n
In my project, the data parsing process was divided into two types: non-predefined keys and predefined keys.<\/p>\n\n\n\n
5.1 Non-Predefined Keys<\/h4>\n\n\n\n
After the data cleaning stage, extracting data with non-predefined keys was relatively straightforward. A Python script was used to process the cleaned text files and extract the relevant information. The script, as shown in the code snippet included at the end of the article, performed the following tasks:<\/p>\n\n\n\n
- \n
- Reading the cleaned text file and removing any unusable characters or short numeric strings.<\/li>\n\n\n\n
- Defining exact match patterns to identify the beginning of each magazine entry (e.g., “Magazine:”, “Online:”, “Press:”).<\/li>\n\n\n\n
- Splitting the text into individual magazine entries based on the match patterns.<\/li>\n\n\n\n
- Extracting key-value pairs from each magazine entry, handling cases where values span multiple lines.<\/li>\n\n\n\n
- Storing the extracted data in a dictionary format, with each magazine entry represented as a separate object.<\/li>\n\n\n\n
- Converting the dictionary to a JSON string and writing it to an output file.<\/li>\n<\/ol>\n\n\n\n
This process successfully extracted the non-predefined key data from the cleaned text files.<\/p>\n\n\n\n
import json\nimport codecs\n\n# Open the input text file containing the cleaned data from the OCR PDFs and the output file for the JSON.\nIN = codecs.open(\"clmp-2005-2006.txt\", \"r\", encoding=\"utf8\")\nOUT = codecs.open(\"clmp-2005-2006-submit.txt\", \"w\", encoding=\"utf8\")\n\n# Read the input file, split it into lines, and filter out lines that are either too short (likely errors) or page numbers.\nin_list = [\n s.strip()\n for s in IN.read().split(\"\\n\")\n if not (len(s.strip()) <= 1 or (len(s.strip()) <= 3 and s.isnumeric()))\n]\n\nIN.close()\n\ndatas = {}\n\n# Patterns to identify the beginning of new entries in the text file. Define the exact matches.\npatterns = [\"Magazine:\", \"Online:\", \"Press:\"]\nmatch_list = [] # This list will contain the indices of lines where patterns are found.\n\n# Loop through each line in the input list to find matches to the patterns.\nfor index, st in enumerate(in_list):\n match = [(True if st.find(pattern) == 0 else False) for pattern in patterns]\n if any(match):\n match_list.append(index)\n\nlength = len(in_list)\nmatch_length = len(match_list)\n\nprint(length, match_length) # Debugging print to check sizes.\n\ncurrentIndex = 0\nfor i in range(0, match_length - 1):\n st, en = match_list[i], match_list[i + 1]\n currentIndex += 1\n data = {}\n idx = st\n while idx < en:\n # Split each line into a key-value pair at the first colon.\n key, value = map(str.strip, in_list[idx].split(\":\", 1))\n idx += 1\n # If the following line doesn't contain a colon, it's part of the previous value.\n while idx < en and \":\" not in in_list[idx]:\n if not value.endswith(\"-\"):\n value += f\" {in_list[idx]}\"\n else:\n value = value[:-1] + in_list[idx]\n idx += 1\n data[key] = value\n datas[currentIndex] = data\n\nprint(currentIndex) # Debugging print to ensure the expected number of entries are processed. This must be the same as the first match_length. \n\n# Convert the dictionary to a JSON string, ensuring pretty printing.\ndatas_string = json.dumps(datas, sort_keys=False, indent=4, ensure_ascii=False)\n\n# Write the JSON string to the output file and close it.\nOUT.write(datas_string)\nOUT.close()\n<\/code><\/pre>\n\n\n\n5.2 Predefined Keys<\/h4>\n\n\n\n
Extracting data with predefined keys proved to be the most challenging aspect of the project. The keys were sometimes embedded within the text, requiring human analysis rather than automated script processing. This led to numerous missing values and multi-line comments.<\/p>\n\n\n\n
To tackle this challenge, I integrated OpenAI API and GPT4, an AI-powered language model, was into the workflow. However, due to the large volume of data, direct processing was not feasible. Instead, the data was segmented into manageable chunks of around 70 lines each. These segments were then sent to GPT4 along with a prompt to extract the predefined keys within the specified context.<\/p>\n\n\n\n
The prompt provided to GPT4 included instructions on the expected format of the extracted data (JSON) and the specific fields that might appear in the magazine listings. GPT4 analyzed each chunk of data and returned the extracted information in the desired JSON format, handling missing information and anticipating the beginning of the next article.<\/p>\n\n\n\n
# Define a string 'to_system' that describes the role of the user and the type of data to be processed. This string serves as a structured set of instructions for an AI model to understand the context and the required output format.\nto_system = \"\"\"\nYou are a programmer.\n...\n\"\"\"\n\n# Define a function 'evaluate_JSON' that takes a text input and returns formatted JSON.\ndef evaluate_JSON(text):\n # Initialize the flag, return dictionary, and title holder.\n f, ret, next_title = False, {}, \"\"\n \n try:\n # Call the OpenAI API client to generate completions using the provided model. Here, the conversation messages are structured to pass the 'to_system' instructions and the given 'text' as input for the AI to process.\n response = client.chat.completions.create(\n model=\"gpt-3.5-turbo\",\n messages=[\n {\"role\": \"system\", \"content\": to_system},\n {\"role\": \"user\", \"content\": f\"'''\\n{text}\\n ... ...\\n'''\"},\n ],\n )\n\n # Process the response to extract the content, and format the JSON with newlines to make it more readable. This step assumes that the response from the AI will be in a string format that resembles JSON.\n rlt = response.choices[0].message.content\n rlt = rlt.replace(\"{\", \"\\n{\\n\")\n rlt = rlt.replace(\"},\", \"\\n},\\n\")\n\n # ... rest of the processing code should go here ...\n \n # Exception handling in case of an error during the API call or processing.\n except Exception as e:\n print(f\"An error occurred: {e}\")\n\n # The function would return the formatted JSON content.\n return ret<\/code><\/pre>\n\n\n\nConclusion<\/h3>\n\n\n\n
Converting scanned PDFs of the CLMP Directory of Literary Magazines<\/em> into clean, well-structured JSON was a multi-step process that involved digitization of the directories, PDF to text conversion, data cleaning, and data extraction. The project utilized Python scripts and AI-powered tools like GPT to overcome challenges such as embedded keys and large data volumes.<\/p>\n\n\n\n
By segmenting the data into manageable chunks and providing clear instructions to GPT4, I successfully extracted the desired information in a structured JSON format.<\/p>\n\n\n\n
Result Example<\/h4>\n\n\n\n
I started with print issues that contained thousands of magazines that included variations of listing information like this<\/p>\n\n\n\n
![\"Screenshot](\"https:\/\/digitalborn.org\/wp-content\/uploads\/2024\/04\/Screenshot-2024-03-06-at-4.16.49\u202fPM-2-1006x1024.png\")
<\/a><\/figure>\n\n\n\nAnd I was able to turn all of the listing information across the issues into JSON like this<\/p>\n\n\n\n
![\"\"](\"https:\/\/digitalborn.org\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-07-at-5.52.31\u202fPM-1024x563.png\")
<\/a><\/figure>\n\n\n\nThis project demonstrates the potential of combining traditional programming techniques with AI-powered tools to tackle complex data extraction tasks in the digital humanities field. The resulting JSON data can now be used for further analysis and research, opening up new possibilities for exploring the historical content of the CLMP Directory of Literary Magazines<\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":"
This post discusses a recent project where I scanned PDF issues of the Council of Literary Magazines and Presses (CLMP) Directory of Literary Magazines from 1995 to 2005 and converted those 10 directories into clean, well-structured JSON. The process encompassed several stages, including PDF to text conversion, data cleaning, and data extraction using Python scripts and AI-powered tools like ChatGPT.<\/p>\n","protected":false},"author":5,"featured_media":3288,"comment_status":"open","ping_status":"closed","sticky":true,"template":"","format":"standard","meta":{"footnotes":""},"categories":[143],"tags":[150,202,203,152,201,204],"class_list":["post-3286","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data","tag-api","tag-clmp","tag-gpt","tag-json","tag-ocr","tag-openai"],"_links":{"self":[{"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/posts\/3286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/comments?post=3286"}],"version-history":[{"count":0,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/posts\/3286\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/media\/3288"}],"wp:attachment":[{"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/media?parent=3286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/categories?post=3286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/tags?post=3286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}},{"id":3209,"date":"2024-01-03T15:52:17","date_gmt":"2024-01-03T20:52:17","guid":{"rendered":"https:\/\/digitalborn.org\/?p=3209"},"modified":"2024-01-08T17:22:28","modified_gmt":"2024-01-08T22:22:28","slug":"echo-show-15-poe-setup","status":"publish","type":"post","link":"https:\/\/digitalborn.org\/echo-show-15-poe-setup\/","title":{"rendered":"Power over Ethernet for Amazon Echo Show 15"},"content":{"rendered":"\n
If you’re reading this article, you’ve encountered a similar problem to the one that I recently solved: you bought an Echo Show 15 and wanted to either 1. power the device without wires showing, 2. deliver power to the device over a long distance (the included power supply is only 6 feet in length), or 3. avoid installing an AC power outlet. For me, I wanted to accomplish all three of these items: I wanted to run a single Cat6a cable from my PoE network switch in the basement through the wall and power the Echo Show 15 in the kitchen.<\/p>\n\n\n\n
\n ![\"Photo](\"https:\/\/digitalborn.org\/wp-content\/uploads\/2024\/01\/echo-show-15-before-1-1024x771.jpg\")
<\/a>Before<\/figcaption><\/figure>\n\n\n\n ![\"Photo](\"https:\/\/digitalborn.org\/wp-content\/uploads\/2024\/01\/echo-show-15-after-1024x771.jpg\")
<\/a>After<\/figcaption><\/figure>\n<\/figure>\n\n\n\n
- Developer
- Novice
![\"Photo](\"https:\/\/digitalborn.org\/wp-content\/uploads\/2024\/04\/directory-clmp-1996.jpg\")
<\/a><\/figure>\n\n\n\n