Sam Wilson's Website

T177: The H. M. Wilson Archives

RSS feed icon. RSS feed for the "The H. M. Wilson Archives" tag

  1. Uploading scanned letters with Pattypan

    Pattypan is a great tool for uploading lots of files to Commons. I’m using it today for a set of scans of airgraphs. I scanned them all yesterday, and gave them hopefully-useful filenames that contain a prefix, date, and bit of info about each. These documents all look pretty much the same when viewed as thumbnails, so it’s important to be able to determine at least something by glancing at the filename. That said, it’s never good to ‘‘rely’’ on metadata being in the filename nor on all files having the same structure to their names.

    Anyway, after creating the spreadsheet for these files, I did some tweaking to the data columns:

    1. Filled the source column based on the name column:
      • Formula: =CONCAT("{{HMW|wiki=",B2,"}}")
      • Result: {{HMW|wiki=Airgraph 1943-12-30 Adele to Murray}}
    2. Extracted the date:
      • Formula: =REGEX(B3,"[0-9]{4}-[0-9]{2}-[0-9]{2}")
      • Result: 1943-12-30
    3. Crucially, any column that uses a formula needs to be copied to a new column with ‘‘values only’’ (i.e. “Edit / Paste special / Values only”). Otherwise Pattypan can’t see the formula result.

  4. Cossack Bond Store, 1966

    The file that is attached to this post.

    <a href="https://hmwilson.archives.org.au/items/149.html" rel="noreferrer nofollow">hmwilson.archives.org.au/items/149.html</a>

  5. Cossack Bond Store, 1966

    The file that is attached to this post.

    <a href="https://hmwilson.archives.org.au/items/149.html" rel="noreferrer nofollow">hmwilson.archives.org.au/items/149.html</a>

  6. Cossack Bond Store, 1966

    The file that is attached to this post.

    <a href="https://hmwilson.archives.org.au/items/149.html" rel="noreferrer nofollow">hmwilson.archives.org.au/items/149.html</a>