Author Archives: Devin

Building Seamaster Day 7: F1 Former & Mid-Bottom Sheet

Center Bottom Section Installed

On Feb. 28th I continued work on the fuselage and unfortunately didn’t discover an issue that will come to light during an upcoming session.  Perhaps it hadn’t fully presented itself at this time, or perhaps I was just oblivious.  Either way this day was about continuing work on the fuselage.

To reinforce the nose of the aircraft a second F1 former needed to be attached.  This was the first task that required to do some light sanding to remove the laser burn marks and then applying glue to the side edges as well as covering the back surface with glue to ensure all surfaces that will be in contact with wood will have been glued down.  I then clamped this into place for it to dry, seen below.

2nd Former F1 Installed
2nd Former F1 Installed

The other task for the day was getting the middle section of the bottom glued in place, seen in the top piece is oversized.  I still had to make sure I got the sheet in the correct place as there were spots where not much overlap was present no matter the positioning of the piece.  I sanded the front edge of the piece that buts up against the fuselage. There was no need to sand the other edges as no wood would be touching and in the case of the two sides it’ll be sanded down once the glue dries.

To complete the day I got the piece I. Place and traced with a pencil along the fuselage to mark the sheeting, knowing the glue would have to go along the inside of that line. Peter than applied glue on the sheeting while I applied glue along the edges of the fuselage and back of the former the front edge of the sheeting buts up to.

We then clamped the sheeting in place to hold it while it dries. Had to get clever with clamping the former to the front edge of the sheeting as no clamps were long enough. We used a clamp as an intermediary to place our other clamps on.

That wraps up another building evening.

Building Seamaster Day 6: Front Formers + Wings Beginning

Formers F1-F3 Installed

On Feb. 27th worked on the fuselage and started the wing!  It was at this point I really felt like progress was heating up 🙂

One of the tasks for the evening, now that the front of the aircraft is shaped and dried was to install the front formers (F3 to F1, that’s the order of installation).  You want the bigger one, that is further back on the fuse, installed first as that starts bringing the sides together and helps ensure a proper shape.

Then proceeded to start work on the wing, specifically the right wing panel.  For this needed to get the trailing edge cut and Peter already had the spruce rear spar made (smaller rectangular piece of wood).  Once that along with the main spar were pinned securely in place, ensuring some overlap on both sides I cut the balsa sheeting to size such that it fits snug between the main spar and rear spar as well as between the rear spar and trailing edge sheet.

Wing Center Sheeting
Wing Center Sheeting

That was as far as I could get this day.

Building Seamaster Day 5: Sides Attached & Nose Shaping

Formers 6-10 Attached to Sides

Another great building session took place Saturday February 24th.  The first thing, as seen in Fig. 1 and 2 below is that the screw hole for anchoring the engine support post (is what I’m calling it) to the fuselage was drilled.  The groove carved into the ‘post’, seen in Fig. 1, Peter had done at another builders place.  This groove is where the wires will run down from the engine (i.e. for the throttle servo).  While Peter held the support in place I drilled a hole between the two bottom tabs (ensuring I was in about the middle and below the hole where the wires will be routed for the control services via the groove) a bit smaller than the screw being used as this is what will hold the post in place.

Drilled Whole For Screw
Fig. 1: Drilled Whole For Screw
Fig 2. - Screw hole drilled
Fig 2. – Screw hole drilled

Once that was done I glued formers F6 through F10 in place connecting both sides of the aircraft.  This was done with Sig Cement and each one was clamped in place to hold everything tight while the sides dried to the formers.  All the formers were previously sanded.

The last item for the day was to start shaping the front of the aircraft.  The prep work for this was having two pieces of wood with two notches made in them.  I then soaked the wood using a spray bottle and carefully bent the two nose pieces inwards and placed the sticks in place, top and bottom, to hold the pieces in place while the water dried.

While waiting for the wood to dry we chatted and then about an hour later sprayed the wood again and move the nose pieces in further. Then cut new notches in the wood to hold the pieces at the new closer position.  At this point I had to go home, but Peter repeated this process a couple more times until the two pieces were close enough together such that the F1 former would fit snug at the nose of the aircraft.

Shaping Nose of Aircraft
Shaping Nose of Aircraft

Wasn’t concerned about the wrinkle because if necessary can slit it with a knife and glue it smooth.  That concluded another building session!

Building Seamaster Day 4: Pylon and Side Meet

Gluing Pylon to Left Side

February 21st was about finishing off the Pylon and starting to get the fuselage sides attached.  The first step was ensuring the seems of where the spacers meet the formers are secure by applying a bead of medium CA glue long the seems.  This was done for all four areas, inside and out, making for eight beads of glue.

Medium CA Glue
Medium CA Glue
Glue Along Seems
Glue Along Seems

After that was done, this type of glue dries fast!  I did a trial fit of the pylon to each fuselage side.  While doing this I made a line along each side to determine where I needed to apply glue (seen below).  After that was done I placed glue along the left side of the pylon (ensuring sufficient glue on the tabs) as well as on the fuselage side and then put the pieces in place and clamped them together as seen in the picture at the top of the article.

Marking Glue Lines For Pylon Placement
Marking Glue Lines For Pylon Placement

That wrapped up another day as couldn’t go any further until this dried.  Once dried Peter did the same for the other side so that the project wasn’t held up to much as that needed to be done before anymore formers could be trial fitted and glued in place.

Building Seamaster Day 3: Pylon

Re-gluing the sides

Monday the 19th was a day of dang’s and backtracking before nicely getting ahead.  When I first got there and was working discovered that the sides of the fuselage hadn’t stuck together well enough.  Bad batch of glue!  That’s my story and I’m sticking to it… the only other evidence I have is that Peter tossed both parts for mixing it up and the fact they didn’t stick.

To rectify the sides coming apart I had to re-glue it (seen above) and thankfully this time it stuck!  Same process as before (without all the sanding), but unfortunately means not as much progress was made this day.  Also did a lot of sanding (John helped as well) due to the excess glue around the top of the doubler as you want to make sure the wing will sit nicely within the ‘saddle’.

What was suppose to be the main focus of this session was building the pylon, pictured below.  This is the main support for the fuselage and the engine mount (that will be above the aircraft mounted onto the piece of wood sticking out, plus other pieces I’ll get to later in the build).

For this I had to find the 4  pieces that make up the pylon (two of them are formers, F4 & F5).  The front is the smaller of the formers.  I then went to sanding the sides of all the pieces, followed by gluing the pieces that will help hold the main support for the engine (or so I’ll call it) and complete the pylon connecting F4 & F5.

Pylon with spacers all glued together
Pylon with spacers all glued together

That was it for this day as needed to wait for everything to dry before proceeding.  Also to make sure everything stuck together properly as well!

Building Seamaster Day 2: Stab & Doubler

Stabilizer Glued

Playing catch up on my blog posts here as been busy!  Last Saturday, Feb. 17th, was a building session that focused on getting the 3 pieces of each side of the fuselage glued together and stabilizer.

In order to glue the pieces of the fuselage together you mix up a batch of glue as it is made from two equal parts.  Once mixed you glue them together and place weights (with wax paper between the weights and the wood to ensure nothing gets accidentally stuck together that could tear away the wood) to hold the seems together.  The reason for the ‘cartoon teeth’ like look is to provide some interlocking which adds strength as gluing to flat ends together would not hold up well!

In the picture below I’ve glued the doubler to the fuselage making sure the curve lines up with the side of the fuselage.  This piece is on the inside of both sides of the fuselage to provide support for the wing.  You need to make sure that it is flush with the top (as the bottom is right above where a tab for one of the formers fits in) and lined up properly front and back too as there are tab holes there as well that if it covers you’ll be loosing support from where you need it.

Doubler Glued w/ Weights
Doubler Glued w/ Weights

For the stabilizer (shown at the top of the post) used Sig Cement to glue.  The only reason why I’m mentioning this is because the next time I went to Peter’s I discovered the sides didn’t hold, dun dun dun.  But I knew my stab was still OK as I used a different set of glue all together.

For the stab I had to find all the pieces, do some light sanding to remove the laser burns, and then line them up on the plans to ensure everything lines up and lightly sand where necessary.  I then glued and pin the perimeter pieces together followed by the center piece.  I then has to measure and cut all the individual pieces for reinforcing the stabilizer.  This involved cutting and sanding to make sure my angles were right to get a tight fit where the individual pieces of the ‘inside’ touch together along with where they touch with the perimeter of the stab.

Side Glued Together & Weighted
Side Glued Together & Weighted

That wrapped up another day!

Building Seamaster Day 1: Fuselage Sides

Seamaster Fuselage Sides - Front

Woot, woot!  Wednesday this past week I got to start another build.  This time around I am building a Seamaster.  This build has taken some time to get started with all the major life changes that happened over this winter and some hiccups in the creation of the kit itself.  This kit is no longer manufactured so someone Peter knows out of Winnipeg cut the kit for me, so a big thank-you to him!  I got to see the pieces for the first time Wednesday.

Peter put together a manual for constructing the kit, which I am reading through to get a general understanding of the overall process and also in being a guinea pig on the thoroughness / ease of use of the manual. 😉

This will be my first seaplane and I’m excited to experiencing taking off / landing and flying over water.  I’m getting ahead of myself though as I need to build the aircraft first!  To start I read through the introduction of the manual Peter wrote up along with the first bit on the fuselage.  I then laid out the plans on the table, covered it, and pinned it all in place.  I found the 6 pieces making up each side of the fuselage and laid them out.

You can see the front portion laid out in the image at the top of the post and the back portion of the fuselage sides in the image at the bottom of the post.  Due to the kits being laser cut the first step is always to do lots of sanding!  Which is what I did most of this day, was sanding all the edges to get rid of the ‘laser burns’ and give a better edge for the glue hold and allow the pieces to stick together (as shown in the top 3 pieces).

That sums up the first day of this build and am looking forward to Day 2!  I hope others will be interested to follow along on yet another build by yours truly 🙂

Now to reading the manual I go!

Seamaster Fuselage Sides - Back
Seamaster Fuselage Sides – Back

 

Flying 4 Star 60: A Summary

Time got away from me and I never blogged during the summer about my flying.  It was a very busy summer.  I got out flying ass much as I could and loved it as usual!  Missed some flying time during the summer as my girlfriend (at the time) and I went to Ottawa for a visit to take in the sites and got engaged (technically while in Gatineau)! P.S. what a beautiful city!

Basically my time went from learning the basics of taking off and landing with a taildragger, going through the same basic circuits as I did when learning to fly with my 4 Star 60, to advancing to doing loops and rolls in various combinations.

One thing to remember, which I’ve been keeping in the back of my mind for the upcoming season is to use my rudder a lot more.  This includes for aligning the aircraft on takeoffs and landings as well as when making turns using the rudder to prevent the tail from ‘sagging’.

I had some mishaps, most just coming in a little to hot and hitting the tall grass along the edge of the runway.    Need to ensure I am flaring my landings to aid in slowing the aircraft down.  My worst mishap was when I ran out of fuel in the air and couldn’t make the runway, thus crashing into the tall grass/weeds down the hill on the North side of the runway.  The worst part of the damage was breaking the leading edge of one wing which needed to be repaired and recovered before flying again.

I am looking forward to getting out flying again once this nasty cold weather is behind us.  I will start with my Sig Kadet LT40 to get back into the groove of things before bringing out my 4 Star 60 again.  In the meantime I have finally been able to start another build, a float plane this time, so more to come on that.  Been a crazy winter with getting married in December and getting settled into my (uh-um, our) new normal as I am very much a creature of habit, lol.

 

Tracker to Hobby Tracker: Resurrecting in 2018!

2017 was a very busy year for me with getting engaged in Gatineau, QC followed by tying the not mid-December.  At work I have been working on a mobile application and want to now do this as a mobile application, platform of choice being iOS/Apple, due to what seems to be a more intuitive development process.  This will also allow me to explore, learn and integrate features to give a better end-user experience within the app.

One features in this vein would be when listing out the quilts they are tracking load the items (mainly the featured image, thinking will be the one labeled ‘top’ or an OTB image for in progress projects) as they come into view and have a local cache to preserve bandwidth, perhaps detecting WiFi vs data.

Below is the current schema I am thinking.  I created the tables in DynamoDB as implementing my app using Amazon Web Services as the back-end.

HobbyTracker NoSQL DB v1.0
HobbyTracker NoSQL DB v1.0

Key aspects of this schema that will hopefully allow me to make this application work are as follows:

  • Based on DynamoDB/NoSQL impelentation UserID and CreatedOn date down to the ms will act as the primary key (Partition and Sort key respectively)
  • When a table needs to have a reference to an item in another table it will store the UserId and CreatedOn for that record in the table in the following format: UserId#CreatedOn
    • This will hopefully allow me to parse and retrieve the item when necessary from the other table
  • Tables marked as Public anyone can add items to as we do not need to duplicate authors, etc. and the app will only allow editing of certain properties (i.e. in Author would only be able to edit DOD)
  • Tables marked Protected are for allowing other users to view the entries and comment (i.e. on quilts project or specific images or patterns)
  • DateFinished for a book will allow options like: In Progress, Unknown, or an actual date formatted MM/DD/YYYY
    • May follow similar format for CompletedOn with a Quilt
    • Default to ‘In Progress’

Update January 1, 2018:

Well, I’ve discovered one thing. This implementation that somewhat parallels a relational database to reference related items in another table takes a lot of read/write capacity units (a measure used by AWS to calculate costs) and the free tier only provides 25 which according to them is more than enough for most applications.  Check out the FAQ.

This leads me to believe I need to rewrite the storage structure to store the bulk of the information in a JSON object in a column of type Map.

Thus, based on this from the AWS documentation above I need to figure out how much storage each item would be as a JSON object:

A unit of Write Capacity enables you to perform one write per second for items of up to 1KB in size. Similarly, a unit of Read Capacity enables you to perform one strongly consistent read per second (or two eventually consistent reads per second) of items of up to 4KB in size. Larger items will require more capacity. You can calculate the number of units of read and write capacity you need by estimating the number of reads or writes you need to do per second and multiplying by the size of your items (rounded up to the nearest KB).

Now, I may just be over complicating things but this will hopefully eliminate the need for so many tables, perhaps a column to indicate object type stored as JSON which will be indexed (increases capacity units per table by the way).

To be investigated further at a later date!

SharePoint List – Delete Columns Through PowerShell

Today my colleague ran into an issue where she added columns to a SharePoint 2013 list, later realised they were not what she wanted and was unable to delete them.

I ended up doing up the following PowerShell script to delete the columns based on some examples I found online in both C# and PowerShell.  The key one I found was on SharePoint Diary; however, this did not work for me but was close to what I had already started.

The full script that worked for me is as follows:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
#Variables
$SiteURL="http://foundations.thrive"
$ListName="Activity Reporting - 2018"
$ColumnName="Target Audiences"
 
Write-Host $ListName - $ColumnName
#Get Internal Name of the columns
$web = Get-SPWeb $SiteURL
 
#Get the list
$list = $web.Lists.TryGetList($ListName)
 
if($List -ne $null)
{
    #Get the column
    $column = $list.Fields[$ColumnName]
 
    if($column -ne $null)
    {
        #Reset column properties to allow delete
	$column.Sealed = $false
        $column.ReadOnlyField = $false
        $column.AllowDeletion = $true
        $column.Update()
 
        #Delete the column from list
        $list.Fields.Delete($column.InternalName)
        write-host "Column has been deleted!" -f Green
    }
    else
     {
        write-host "Specified column name not found!" -ForegroundColor Red
     }
}

The key difference from theirs is the column properties I had to set.  Setting the columns Hidden property:

1
$column.Hidden = $false

Didn’t work for me and I had to replace it with:

1
$column.Sealed = $false

This might depend on the type of column you are having issues with, but since I we were unable to delete these through the GUI this is what I ended up doing but wanted to document the other way as well encase down the road we run into a scenario that fits there original use case.