2018-05-12

The Church and the BSA

The news broke that the Church of Jesus Christ of Latter-day Saints has officially announced that it will no longer sponsor Boy Scouts of America troops. As a member of that church who currently serves in a calling as a Cub Scout den leader, and as a father of four boys — one of which just earned his Eagle Scout, and one who likely will within the next year — and being married to someone who currently volunteers as a Roundtable Commissioner for the BSA district, I have some thoughts.

First off, this has been a long time coming. The Church has members all across the world, and the Boy Scouts is an American institution. While Church leaders have often noted that the BSA is, essentially, the Young Men's organization within the Church, this has been completely unavailable outside of this country. We've heard rumors for a long time of the Church looking to institute something that would be available to members everywhere.

There are certain benefits to dumping the BSA from the Young Men's program. I've heard from numerous sources how the youth budget is often seen as unfair, with the Young Men getting far more allocation than the Young Women. However, the main reason for this is that the Church pays much of the registration fees, awards, and so forth required by the BSA — which is something that the Young Women do not have to deal with. The BSA also has many rules, regulations, and so forth that can be difficult for a ward full of unpaid volunteers to navigate. (One of the responsibilities my wife has is to help new scout troops and packs get through some of this — and the ones requiring help are not limited to LDS Church-sponsored troops.)

The move could also allow more freedom in Young Men's groups in their activities. Without having to follow strict rules and a prescribed list of activities and merit badges that boys are supposed to earn, it could be more easily tailored to the needs and desires of the people in the program (kids and leaders alike).

On the other hand, there are some things that would be a great loss. The structure and required activities are sometimes a benefit. When I asked my wife about her experience growing up in Activity Days (the program for girls the age of Cub Scout boys), she expressed her disappointment that it was little more than a cooking class. Her leaders were skilled in the kitchen and enjoyed doing that, so, without any real incentive to do anything else, that's what they did, week after week. Not being a very outdoorsy person myself, if I didn't have the Cub Scout requirements to drive me, I would likewise have very little incentive or direction to do some of the things that the boys in my care would enjoy (or should learn).

With the lack of BSA sponsorship, access to some of the campgrounds and resources that the Church currently enjoys will be lost. So although there will be more money to go around, some activities will cost more.

The Boy Scouts of America is a national institution, recognized by people regardless of their religious affiliation. Anecdotally, having an Eagle Scout rank is something that employers see as an asset in potential employees. Certainly, a Church program would be less likely to carry the same weight, even if its requirements were at all similar to those of the Eagle Scout.

There is very little commonly known about the new youth program-to-be. The official separation — and, I presume, the implementation of the new program — is scheduled for the beginning of 2020. Time will tell how many of the benefits and losses will be offset by the new benefits (and drawbacks) of the new program. My belief in an inspired leadership gives me great hope that many of these things will be addressed, and that the new program (which, incidentally, is to replace the current programs for boys and girls) will be successful.

One common refrain in the news is that the entire LDS membership of the Boy Scouts is going to go away. While that's most certainly an exaggeration, there is some truth to that. Without the encouragement inside of the Church to join Scouting, it's very likely that fewer boys will feel inclined to join. Also, something I've heard from many parents and have experienced myself, is that there seems to be very little time to fit in all of the extracurricular activities that all of your kids are involved in. With the Church bringing in its own program, boys that want to do Scouts will now have two activities to balance (Scouting and whatever the new program is) — and there's no guarantee that meeting times won't conflict. Also, although religion has been an integral part of the Boy Scouts (belief in God is a requirement, even if the manner of worship is completely open), I have heard various reports of non-LDS-sponsored packs and troops using Sunday as an activity day, which is something that most members of the Church try to avoid. Additionally, an LDS-sponsored pack and troop typically takes care of paying the dues for its members. Joining another troop will mean paying those membership costs out of the families' own pockets. (I have not had much personal experience in this, so I do not know how willing and how much other troops can assist with dues and fees for families that may need the help.) So even though the option to join Scouting is not out of the question, it will be more difficult for LDS youth to make that commitment. The BSA membership is probably going to take a significant hit. While it might not be 100% of LDS youth, it wouldn't surprise me to see it be very high.

The timing of the announcements has certainly been interesting. Several publications have noted that the announcement of the LDS/BSA split came within a week of the BSA announcing that they would change their program name from "Boy Scouts" to "Scouts" (as part of their move to include girls in the program), leading many to speculate that the name change was part of the cause. I won't deny that it certainly looks that way, but I suspect the reality is much more complicated.

The announcement of the split consisted of simultaneous press releases from both the Church and the BSA. While it may not be outside of the realm of possibility, I have a hard time believing that a coordinated PR move happens that quickly, which leads me to believe that both sides knew about this for a long time. Now, it's certainly possible also that the Church knew of the BSA's plans ahead of time as well, so there might yet be some merit to the idea that the Church made plans to leave because of the direction the BSA was moving. It's also possible that the BSA knew the Church was planning on striking out on their own with their own youth program, and the decision to include girls was made to try to mitigate the potential loss of LDS boys from their ranks. In other words, the cause-and-effect might be reversed.

Still, from the perspective of public perception (or at least the narrative that some press are driving), it does look like the Church is abandoning the Scouts because of the changes in the Scouts. While it may sound conspiratorial, I have to wonder if it wasn't timed to make the Church look bad, so everyone can point and laugh at the church, "Look at how those backwards Mormons run from simply having to include girls in their program!" On the other hand, if the timing were reversed, it may appear that the BSA would be the ones to appear reactionary, and the story would be, "Look at how the BSA is so desperate for members now, that they're changing their name to include girls!" The timing from the BSA could have been more defensive than offensive.

All told, I'm kind of looking forward to the change. While Scouting has had some great benefits for my boys and the other boys in the Church, I won't deny the administrative side has been a stress to deal with; and I'm hoping the new program will bring some positive change. I don't know if my own younger boys will continue in Scouting (my oldest is already an Eagle and moving into his adult life; my second oldest will be aging-out at nearly the same time the split becomes official), but it will be a choice we will prayerfully consider in the months to come.

2017-06-24

Forget this "Free Healthcare" business!

I had one of those shower moments where I started replaying conversations and debates I've ever had or witnessed. For some reason, my mind had settled on the idea of universal healthcare (not something I've argued much on either side, but definitely witnessed a lot). Proponents often describe this as "free healthcare", which leads to opponents arguing that "it's not free" since it's paid for by taxes. I've even seen one argument that you'd have a hard time convincing a doctor to use his skill and many years of medical school learning and training for no cost.

"Yeah," said the voice in my head, "just like police and firemen should expect to be paid for their service."

And that's when it occurred to me. The proposal shouldn't be "free healthcare"; it should be "make healthcare a public service". Because that's really the truth. No one's really suggesting that anything be "free". They're suggesting that the costs be covered by society as a whole (i.e., government, paid through taxes), rather than by the individual using the service at that point in time.

While I can understand the appeal of calling it "free", I think proponents do the discussion a great disservice by using that word. It implies, at best, a fundamental misunderstanding of economics, and, at worst, a lie covering it up (since both sides know that health care costs actual money, that it's not really "free" at all).

Do I think a mere change in word choice will clear up the whole discussion? Absolutely not. There are still plenty of points to argue — quality of care, the ability of government to manage, and the actual cost for the public, just to name a few — I do think it would at least let us get past the part where we argue about "free" being "free" or "not free".

2017-06-19

Pass a recordset to C# by way of XML

UPDATE: I have to discourage using this trick. For reasons I do not yet know, it doesn't seem to work with a large dataset. I do not know the exact point at which it fails, I just know that it does. I noticed that a significant number of values that should have been updated with text, actually got updated with nulls. As much as I would love to investigate this and try to see what is wrong and whether it's a failure in C#, SQL, or some combination, unfortunately, it's more important that my work actually get done; so I've had to abandon the XML route entirely.

Original post follows.


It's been a while since I've posted, well, anything. But I learned of a neat trick that I thought I'd post.

I'm currently working on a program that is converting data from two different sources into a single database. A lot of it is just done with carefully crafted SQL statements, but there are a few steps where I have to take data from one source and use some C# code to do some kind of processing before storing it in the target database. Since the data set is on the order of millions of rows, processing these records one at a time can be prohibitively time-consuming. And, since I have limited access to the SQL Server itself, using SQL CLR isn't a great option. (I probably could get the access if I needed to, but it will be an additional step to have to remember and configure when this goes to production, and the fewer moving parts I create for myself, the better.)

One of the tricks I've implemented is to use multi-threading to let the different steps run simultaneously — one thread extracts the records and puts them into a ConcurrentQueue<>, another thread processes that and puts the results into another queue, and a third thread updates the records in the database.

I've been trying to come up with ways to do the update in batches. There are ways to create a stored procedure that will take a table parameter, and ways to call that stored procedure by binding the parameter to an equivalent DataSet, but I didn't like the idea of creating a DataSet object just to pass the records in. It just seemed too "heavy" to me. (Though it might've been faster than calling a command object in a loop for records one-by-one.)

Another option was to create a VALUES table and build the command text dynamically. But, since I was working with strings, I didn't like the idea of building dynamic SQL and having to escape quotes or any other special characters that might cause SQL to choke. (Not to mention it's just bad practice, even if my code is unlikely to be used as a SQL injection vector.)

So, I came up with the idea of passing in values as an XML document. By building the XML with Linq-to-XML C# code, all necessary character escapes would be performed automatically. I could pass in as many values at once as I felt comfortable with, and let SQL do the work in a batch instead of one at a time.

To give some context to this code, I am taking email addresses that were encrypted in the source database, and converting them to their decrypted values in the target database. At this point, my queue consists of objects that have two properties: EncryptedEmail and DecryptedEmail. Earlier in my conversion work, I've simply copied the encrypted strings over into the Email field of the table, so all this method has to do is update the table and changing the Email field to its decrypted value.

var recordsToUpdate = GetRecordsToUpdateBatch(250); //Retrieves up to 250 records off of the queue at a time
if (recordsToUpdate.Any()) {

var xdoc = new XDocument(
new XElement("emails",
recordsToUpdate.Select(r => new XElement("email", new XAttribute("encrypted", r.EncryptedEmail), new XAttribute("decrypted", r.DecryptedEmail)))
)
);

using (var connection = new SqlConnection(GlobalSettings.DatabaseConnectionString)) {
await connection.OpenAsync();
using (var command = connection.CreateCommand()) {
command.CommandText = @"
WITH emails AS (
--Convert the XML document into a table that SQL can use normally SELECT Tbl.email.value('@encrypted','varchar(256)') AS Encrypted, Tbl.email.value('@decrypted','varchar(256)') AS Decrypted
FROM @emails.nodes('/emails/email') AS Tbl(email)
) UPDATE cust SET cust.Email = emails.Decrypted
FROM dbo.Customer cust
INNER JOIN emails ON cust.Email = emails.Encrypted;
"
;
command.CommandType = System.Data.CommandType.Text;
var param = command.CreateParameter();
param.ParameterName = "@emails";
param.SqlDbType = System.Data.SqlDbType.Xml;
param.Value = new SqlXml(xdoc.CreateReader());
command.Parameters.Add(param);

await command.ExecuteNonQueryAsync();
}
}

await Task.Run(() => Thread.Sleep(1));
}

2016-08-30

The server exploded.

As a warning, because I know the boys will tell you as soon as you walk in the door, the internet is down.

As I was debating whether or not I should leave work or try to get one more thing done first, I got a text from my wife saying the internet was down at the house. It happens from time to time. Usually, I just have to reboot something, and usually, that thing is the wireless router that most everything connects to. It's a Rosewill, which I bought mostly because my trusty Linksys WRT-54G was having a hard time keeping up with all the devices we kept adding to the mix. The Rosewill supports wireless N and has a much better signal range, but maybe once every week or so, things just go a little "wonky" and it has to be rebooted. Just this past weekend, in fact, it ended up "jamming" my home network completely, sending so much traffic (that wasn't actually going anywhere) that none of my machines could hear each other. I didn't immediately know it was the router at the time, but when I went to the basement to check the servers and all the networking gear, that's when I saw the rapid flashing on the switch connected to the Rosewill router.

I didn't expect it to be a big deal this time, either, but I got a couple more texts with some more details. Of course, my wife had tried rebooting the wireless router already. (Even the kids know that, sometimes, you just have to go over to it, pull the power plug, wait a few seconds, and plug it back in.) When that didn't help, she went down to the basement herself, and she heard some high-pitched beeping from what she described as a small box with blue lights on it. She turned it off, waited a bit, and tried turning it on again; and when it started screaming at her immediately, she just turned it back off.

From her description, I knew the device in question was the UPS. It seemed strange that the UPS would be beeping like that, unless the power was off and it was running out of batteries or something. It's a common story in tech support circles to get a call from someone who claims their computer doesn't work, and only after troubleshooting for a while does the clueless user say something like, "Well, I can't quite see, because the power is out and it's dark in here." I didn't believe my wife would fail to mention a power outage, though, so I figured it must be something else. The UPS going bad, perhaps? A tripped circuit breaker that cut the power to that outlet?

I got home and went downstairs to check things out. It was very quiet, which seemed like a bad sign. Two servers — the email server, and the main server that does just about everything else — are plugged into the UPS, but a third — the media server, which stores all our DVDs for easy access — is plugged straight into the outlet. If the UPS were bad, the media server should still have power. At this point, I'm thinking it's a tripped circuit breaker.

I go out to the power box to check the breakers, but none are tripped. I locate the one going to the servers and flip it off and on, just in case; then I head back inside. At this point, I'm getting a little concerned. We ran that power line ourselves; did we do something really wrong in the process? It's been fine for a few years, though. If it did go bad, what can I do to get power to that corner of the basement while we figure things out?

Back in the basement, the outlet still has no power. I noticed, though, that we installed a GFI outlet. Maybe that's what tripped. I pushed the red "reset" button, and as soon as it clicked, the media server hummed to life. Ok, that's what's keeping things down. Now, I'll bring things back up and see if it trips again, and then figure out what's causing the problem. I turned on the UPS, which gave only the slightest of beeps. The email server gave a soft beep as it got power, and then….

A little background on the main server. This thing runs pretty much everything. It is the only thing connected to the cable modem on one network card, and another network card connects to the switches that distribute internet traffic to the rest of the house. It was a machine I built several years ago, picking out the parts and assembling them myself. I didn't look for anything special in the case, but the one I happened to find on sale had some interesting LED lights on the fans and a clear side window, so you can see everything inside. I didn't even know about these features of the case when I bought it; I was just looking for something that would hold all the parts together for a decent price. Over the years, the server has been carefully configured to do everything I need it to. It has a web server, which is mostly used by my wife for her web design work. It has a minimal email server, which does some preliminary filtering before passing email on to my "real" email server inside the network. It does the firewall and routing, with some hand-crafted iptables scripts to make sure bits go where they're supposed to. It has a DNS server, which is configured to give easy access to important devices on the network by name, plus has the bonus of having a few hundred known advertising sites redirected to the address 0.0.0.0 as a convenient, network-wide ad block. (Fun fact: I tried to do the same with porn sites, but when I got a list of known sites and fed them into my DNS server, it promptly crashed. There were just way too many to filter out wholesale.) It also has a large file store with an FTP server used internally to back up, share, and keep files we want to hang on to.

Anyway, as the main server got its turn to power up, there was a series of three or four very loud POPs, accompanied by a bright flash that could be clearly seen through the case's clear side panel. Accompanying the popping noise, I shouted something that I don't quite remember. And then everything went quiet again as the GFI switch once again tripped and cut the power. A thin tendril of blue smoke leaked out of the power supply fan of the main server, and the smell of fried electrical parts hung in the air.

I went upstairs and told my wife the bad news. The server just exploded.

My wife helped me get the server unplugged (mostly because, even with the power cut, I was still a little terrified to touch the thing after what I had just seen), and I took it upstairs where I had more light and began taking it apart. There were a few cobwebs and a lot of dust inside, but no obvious sign of what blew up. Unfortunately, there's no real easy way to tell what may be good and what may be dangerous. Unwilling to risk frying any more components than necessary, I resigned myself to having to buy a new machine and rebuild.

I can only hope at this point that the hard drives are ok. The server contained four in total — two smaller ones that held most of the OS, and two larger ones that made up the file share, each pair in a RAID-1 array. But without access to the internet, downloading the appropriate installation media would be tricky. Not that I had a replacement server handy, anyway. First things first, find a replacement.

I took a quick trip to the nearest electronics-type store, that being Best Buy. I knew it was probably a long shot going in there, and, unfortunately, I was right. Plenty of laptops and costly consumer desktop systems, but nothing that would be good for a server. I wasn't willing to overspend on a system that wasn't suited for the task.

My next bet was Micro Center, which was a half hour away. Unfortunately, that, too, was a wasted trip. Pre-assembled systems were limited to the desktop and laptop variety. They do have a large array of components for building machines from parts, but, being perfectly honest with myself, I was not in a frame of mind to start piecing one together in a hurry. If I'm going to build something, I want to take the time to research, and really put together what I want for the best value. But I need a server, and quick. I figured Amazon is probably going to be my best bet.

In the parking lot of the Micro Center, I double-checked Amazon's site. (I had looked before I left the house, but I didn't commit to anything as I wanted to at least try to buy something from a local store that I could take home and start working on that night.) I found a couple possibilities, but my biggest issue was trying to find the internal specs on the machines. This mini-tower server looks like a good deal, but does it have the internal space and ports for four full-sized SATA hard drives? I don't know if it was because I was trying to use the mobile website, or if their site was really lacking that information, but I found it really hard to find. (I probably would have found more details on NewEgg, but I was wanting to take advantage of Amazon's better prices and faster shipping.) I found one that actually included a mention of "space for 6 drives" in the description, placed the order, and elected to pay extra for one-day shipping.

On my way home, I started to go over my options. I wouldn't be able to restore the web and file server until the new machine arrives, but what could I get up and running now? I had that old Linksys wireless router, which I had installed DD-WRT firmware on — meaning it is something that is very configurable and something I could really tweak. That, I figured, could take the duty of routing and firewalling for the internal network, and we would at least have internet access again. Email might be a bigger problem, though. Sure, the email server was alive, but the way I had it configured, I depended on the main server to filter email first. Maybe some of the security settings I had applied in the not-too-distant-past would allow me to grant it more direct access to the internet without becoming an open relay for spam mail. But that could be a secondary task.

I got home and set to work, hooking up the Linksys router in the place of the main server. I had some issues getting it configured, since my prior tinkering with the device (when it was just a toy to play with) had left it in a weird state. I ultimately had to reset it to its default state and rebuild it from there. DD-WRT has a very convenient web-based interface, though, and it took me much less time than I expected to get things to a working state. The thing that slowed me down the most was the fact that devices on the network still remembered their configuration from the main server, and didn't immediately update to point to the Linksys router when I brought it online.

With that accomplished, I figured I'd try setting up email. I did have a few small issues configuring the network, but again it came down to having to just reboot the server a couple times to force it to update its network configuration. I had some issues from there trying to get some external email server testing programs to talk to my email server, and that slowed me down a bit. It turned out that the email server didn't take too kindly to being forcibly rebooted, and the email services just plain hadn't started up. (It's amazing how much better things can work if the expected program is actually running.) I forwarded the secure email ports through the firewall easily enough, but I wasn't too sure about opening up the unsecured email port required to let outside email come in. It turned out much better than I expected. The security settings I had enabled recently were working perfectly. I ran a couple different open relay tests against my web server (which is something I always, always do when I tinker with the email server — last thing I want to do is to get shut down because my email server is sending out everyone else's spam mail), and it passed perfectly.

So, now I'm back up and running with internet access and email. The major items are taken care of, so everything else from here can get rebuilt on a much less rushed timeline. (Still want to do it quickly, but it doesn't have to be done yesterday.)

Time to count the blessings and see what I learned.

The biggest blessing is that nothing burned down. The GFI outlet tripped, but the UPS at that point should have still been providing power. Near as I can figure, it also detected something was wrong and cut power, then beeped as an alarm. When my wife turned it off and back on, it must have been able to still detect the problem and not try powering on the server. I'm not sure what changed when I got to it later, but when I tried turning things on and it started making loud boomy noises, the GFI tripped again and the UPS just shut itself off immediately. If it hadn't, there could have been much more damage done, and possibly an electrical fire as well. (I'm still keeping my fingers crossed that the hard drives aren't fried.)

We're up and running. Email and internet are the most important things we have to keep going, especially with one child doing homeschool and taking lessons over the internet. I pay for a backup email server that, when our server is down, will receive and hold our email in a queue until our server comes back online; so we haven't lost any email.

With the Linksys router doing the routing and firewall duties, I can rebuild the main server and just keep it behind the firewall itself, without having to configure it for routing as well. Whenever the server has an issue in the future, I won't have to bring down the whole network. Plus, keeping the file share off of the computer exposed to the internet is a better setup anyway.

I should probably look into offsite backups. While I can hope that the hard drives didn't get fried, if it turns out that they did, I could be up a very smelly creek in a barbed wire canoe without a paddle.

2016-07-21

When there's no will, there's no way

My relationship with my father can be described as "strained", at best. Growing up, I don't remember him being around much. He worked hard to make sure we never really wanted for anything; and though it meant we did have a very comfortable lifestyle, it did mean we didn't spend a lot of time together.

I've never been very good at communicating. I think there are many reasons for this, but I don't want to get into them for fear of being accused of trying to place blame. Even now, as a fully-grown adult, I get very anxious when I think about making a simple telephone call. I also tend to be forgetful and more than just a little lazy. My ideal vacation consists of one where I never leave the house. Not that I don't enjoy the occasional family trip once in a while, but I don't really ever fully relax until I can get back home.

My father has never accepted these aspects of me, though. While it could be considered noble to want me to be a better person, he's always taken my failings as a personal affront to him. If I don't call, it's because I don't respect him, and I'm a horrible, ungrateful little brat because of that. And he takes that as license to treat me as such. Which makes me more likely to act that way, and the cycle spirals downward.

My biggest issue, though, is that I am always the one to shoulder the blame, and the punishment. And, sometimes, that punishment borders on revenge.

Many years ago, we were having issues with email spam. An email address we had set up was getting hundreds of messages a day. We decided to change our email address to try to hide from some of these electronic assaults. I think that might have been the time when we set up our own email server, so that we could create new email accounts at-will and give a new email address to every website with which we were inclined to register. This is a huge benefit in that it means, when we start getting spam, we can identify exactly whose email list was hacked or sold, and we can terminate a single address without affecting our communication with any other person or business.

Anyway, we sent out notices about our email address change, and after a couple months, deactivated the account. I am not certain if we failed to send such a notice to my father, or if he failed to read it and update his address book (though I'm leaning heavily towards the latter, for reasons I will explain later), but eventually, he noticed that emails he was sending were going unanswered, and eventually started to bounce.

I'm not sure how long it was before he eventually got in contact with us, and we told him (or reminded him) of our email address change. I'm not sure how we failed to communicate this, because apparently what he heard was: "We changed our email address and didn't tell you so we wouldn't have to hear from you." And, being so affronted, he then stopped sending birthday or Christmas cards for a while.

This was annoying for two reasons. One, it was clearly a misunderstanding. Somehow our change of address didn't "take". Although we were reasonably sure we told everyone, we accepted responsibility, apologized, and made sure he had our correct email. A reasonable response would be to accept that it happened, it's been resolved, and move on. But his response was to be angry that it happened, accuse us of doing it on purpose, and to punish us by not sending Christmas cards anymore. Two, he went beyond us. Not only did he stop sending my wife and me anything, but he stopped sending birthday cards to his grandkids, too. He was punishing them for what he perceived as our "attack" on him.

This was a very long time ago, so I don't remember exactly when things might have turned around. It might have been when my son was admitted to the hospital a few years back, and I decided to call him and let him know. But in any case, we had been back to sending cards and gifts for birthdays and Christmas again.

But moving forward to a few years ago. He and his wife came to visit around Thanksgiving time, as they decided to take a vacation to the Rocky Mountains and would stop by for a couple days. They stayed for a day, and we chatted for a while in the living room, but he wasn't feeling well and ended up spending most of the time back at his hotel to get some rest.

The next month, he sent a Christmas card. Since he handed us a check when he came to visit, I didn't expect there to be anything inside. Which I'm not complaining about. In any case — as with all Christmas cards and checks we get from relatives that time of year — I didn't open it right away and put it on the tree, for opening on Christmas day. We had also sent him a package, with some hand-made quilted wall hangings that my wife had been busy making for relatives all that previous month.

Christmas day came, we opened our gifts, and I opened the card to find a rather sizeable check inside. We were pretty thankful for this. We knew he was planning on having a big family gathering at his house that next summer, and we were planning on going, but we were a little concerned about the logistics of making such a trip with four kids on a budget. (I have not done as well for my family as he did for his when it comes to finances. We've always had "enough", and in many cases even some "extra", but I don't know that I would ever consider us "affluent". Though maybe that's because my only real comparison is with how much my own father provided us.) I put the check aside, with the intent to deposit it later, and, as is typical for me, didn't think about it for a bit.

A couple weeks had gone by, and the checks were still on my "to-do" board, since I had forgotten to grab them on my way out to work every day since. (Again, typical me. If you ever send me a check, and you need it cashed right away, please call me and I'll make it happen. Because it's not unusual for a check to be sitting in my "out box" for a month before I remember it's there. I've had our church's clerk come to me and ask me to deposit a reimbursement check for things we've bought for the scout troop on more than one occasion.) So I receive this email:

We sent you a Christmas card with an extra check to maybe make your Christmas a little happier. We didn't hear from you for Christmas or New Year's which is not unusual as you hardly ever call. But I am concerned about the check being lost in the mail and I am going to put a stop payment on it. If you did receive the card and still intend to deposit the check, please let me know before Monday.

Ok, oops. I hadn't deposited the check yet. Need to rectify that. I'd better reply.

Yes, we sure did, just haven't remembered to take the checks to the bank yet. Thanks so much! We're going to be putting that away for our trip out there this summer. Looking forward to it.

How was your trip up to Harvard? I heard there was a big storm that hit New England around that time.

Oh, but he won't have any of that "cordiality" or "small talk".

Unbelievable. You would think I would not have to solicit a thank you, or a Merry Christmas.

And you'd think he would know by now that I'm just not that good at replying. But the sound of his emails imply that we made zero communication at all. Notice how there's no mention of the gift we sent him (that my wife had been stressing over making the prior few weeks), which did include a "Merry Christmas" card enclosed. I don't know whether to be concerned or angry — concerned that our package didn't get to him, or angry that he got it, didn't say anything about it, and tries to lay the guilt trip on me for not saying anything. I'll try to keep things cordial by assuming the first, and copy his wife just in case she got it but forgot to tell him.

Well, now I'm a little concerned. Did you not get our gift to you? [My wife] spent a lot of time and effort designing and making it. We sent it to the Alabama address around the second week of December. Did it arrive? [His wife], have you seen the present we sent?

Enough already, I'm not going to play your game. Yes we got the Christmas present you sent and thank you. And, If I recall correctly, you said thank you when I gave you the Christmas card when we stopped to see you in November. I guess I thought that a check for [amount redacted] would be something a little extra special and something you might pick up the phone and call and express your appreciation, or call on Christmas, or on New Years. I know I don't call, I stopped several years ago because I felt communication with you was a one-way street.

Maybe our feelings toward each other are mutual. Maybe you think I am rude, inconsiderate, and ungrateful for anything you do. That is the way I feel about you and it just isn't worth it to me to try anymore. Please take the check and put it to good use for your family. You don't need to think I sent it to you so you could come visit us.

Yes, see, I forgot the rules of the "game". The rules that say I'm totally at fault for everything, and how dare I accuse him of not taking some of the responsibility himself. He claims to want to talk to me, but he'll be damned to be bothered to actually pick up the phone himself and call, because he doesn't feel that I don't call him enough. Which, yes, I don't, because that's just me. Yet he takes it as some personal slight to him, and because I don't live my life according to his rules, he can't be bothered to try.

I will give him credit for the masterful way he phrased this, though. He managed to call me rude, inconsiderate, and ungrateful, but worded it in a way that put the blame squarely on me for thinking that's what he thinks of me.

But, at least he did address my concern — our hand-made Christmas gift did, in fact, arrive; so it was just his own hypocrisy at work here. "How dare you not thank me for my gift! I don't have to thank you for yours, because you wouldn't appreciate it anyway!" But now I'm starting to wonder about this upcoming trip. Do I really want my kids to be exposed by this kind of treatment? Maybe he doesn't want me there, anyway. Of course, he's unlikely to admit to any such thing, instead making it so that my failure to attend is my decision and fault anyway. Perhaps he would answer a direct question.

No game was being played. Your previous message seemed to imply that you received absolutely nothing from us with regards to Christmas, and we were concerned that what we did send didn't make it. But I’m glad to hear that it did arrive.

You have always made your feelings for me abundantly clear. You can rest assured that none of this was any revelation.

We were legitimately looking forward to using the money you sent for coming out to visit, but the end of your message makes it sound like you don't want us to do that. We are willing to come, but it is your home, so I will leave the decision entirely up to you. Do you, or do you not, want us to come and visit this summer?


Don't bother.

Your actions have been abundantly clear since you've been a teanager and I don't know that there will ever be anything I can do to change your feelings toward me, either. Just like my father told me a few years ago,he did for me and I did for you what I thought was best for you.

Have a good life. I'll stay out of it.

I'll be there if you ever appreciate or respect me as a father, all be it not a perfect one. But I am not going to continuing doing things that are not acknowledged or appreciated.

This will be my last communication.

"Don't bother." As close to a direct answer as I could expect.

The cry to appreciate or respect him as he is, is, once again, hypocritical and insulting, when he obviously has no respect for the kind of person I am. You know, "all be it not a perfect one." And I really hope I don't harbor resentment for my own kids the way they act as teenagers the way he does for me. I'm sure he didn't act out at all when he was a kid, either.

I replied to make it clear that I refuse to accept total responsibility.

As you wish. If you ever decide to change your mind and treat me with the level of respect you seem to expect from me, you know how to reach me.

I did deposit the check, only to get a call from my bank a few days later to inform me that he did stop payment on it. I guess he really didn't want me to "take the check and put it to good use for your family", though I'm more inclined to think it was his reply to my last email (which he couldn't actually write since he already said it was his "last communication"). He had to get the last word in somehow.

A couple years later, we took a trip to visit family. When we got to my father's sister's house, we got a lot of admonishments as to how horribly we were treating my father, and how I should call him. Apparently, he has spent a lot of time telling his family what a horrible son he has and how I'm exiling him from our and his grandkids' life. Up until this point, I have not discussed our relationship with anyone in the family — I did not feel it was anyone else's business and didn't feel the need to burden anyone else with our "issues". Besides, I don't communicate much, anyway. My father, on the other hand, obviously did not feel the same. We had to spend a lot of time explaining our side of things while we were there.

I can only assume that some of our conversations with the family got back to him (one of our biggest complaints being how he seemed to punish the grandchildren for our disagreements or misunderstandings, when he severed all communication), because he actually sent us a card for the next occasion. We sent him one back, and, later, he mailed us a thank-you note that he had tried to email to us. Remember when I suspected that he just didn't update his address book when we changed our email? Yeah, the thank-you email had bounced back from an email service we hadn't used in well over a decade now. Apparently, if he wants to chide or berate me, he has no problem using the correct email address; but when it comes to sending something nice, suddenly he can't use the right address?

We continued to send cards back and forth. (Though not gifts; if he's not going to acknowledge the time and effort we spend into making and sending gifts, it's not worth sending. See, I did learn something from him after all.) We also made sure to send a thank-you card for every gift he sent us and the kids, since that seemed to be very important to him. But it was very obvious he had no interest in talking to us, just the grandkids, when birthday cards would come in for each of the kids and our days were conspicuously skipped. We had almost missed Father's Day, so we sent a quick e-card and, respecting his apparent wishes, "signed" it from the grandkids.

Apparently, the absence of my and my wife's names on this email was the last straw, as this email came in addressed to my wife:

Please inform my son that I have an appointment with my estate attorney in a few days with the purpose being to take him out of my will. I don't know what I did that was so bad that has resulted in his lack of any respect for me. I do believe I was not half as hard on him as my father was on me and I do believe had I not been hard on him he might not have been what he is today.

I intend to send birthday cards and gifts through the end of this year. After that, it just isn't worth it to me to make any more effort.

TL;DR: How dare you snub me after I snubbed you! I quit!

So, I suppose, that's it. Because he makes efforts to punish me for not being the kind of person he demands me to be, and because I don't kowtow and give him the love and adoration and respect he demands while he treats me like dirt, I'm not worth his "effort".

Some of my reaction may seem harsh with the limited discussion here, but this is just a small sampling of my interactions with him. And most of this has occurred after I have gotten tired of the beating down, bullying, and lack of respect as a person that I've endured for many years. He was a very toxic influence on my emotional well-being. I've tried to maintain the lines of communication so as not to cut him off from his grandchildren. But I have felt no guilt for declining to go above the minimal effort required when nothing is ever good enough.

2016-07-08

Why does Disney hate families?

Our Netflix queue recently delivered the Disney movie The Princess and the Frog. It's an adaptation of the old frog prince fairy tale, and all and all it's pretty good. John Lasseter, who proved himself at Pixar, is an excellent storyteller, and Disney is benefiting greatly from his influence. (When I first saw Bolt, my first thought was, "This was about as good as a Pixar movie," and it didn't surprise me to see Lasseter's name in the credits.)

When the movie starts, you see a young girl, Tiana, with her mom and dad. Then, we flash forward, and the girl has grown up. She talks to a picture of her dad in a military uniform, and soon we see her mother in person. They make references to the father being "gone", but they don't immediately reveal his status. My wife and I wondered to each other, "Is he away at war, or has he died?" When, later, we finally hear the words "dad" and "died" used together, our response was, "Of course he's dead; it's a Disney movie."

Disney movies seem to have this "thing" about having a broken family. It's like they hate having a complete, traditional family. Seriously. Let's review. These are animated movies, where a main or important character and their family is present.

  • Snow White, Cinderella — wicked stepmothers
  • The Little Mermaid — Ariel's mother not mentioned; Prince Eric's parents never appear (being a prince, one would assume a king and queen, but they don't even show for his own wedding)
  • Beauty and the Beast — Belle's mother not mentioned
  • Aladdin — Jasmine's mother has died
  • The Lion King — father dies
  • The Emperor's New Groove — parents presumed dead for him to be a young emperor (mitigating factor: Emperor Kuzco gets his "new groove" from traditional family man Pacha)
  • Lilo & Stitch — parents have died
  • Brother Bear — Kenai kills Koda's mother, who appears to be his only living parent
  • Chicken Little — mother has died
  • Meet the Robinsons — orphan (mitigating factor: adopted into traditional – albeit weird – family)
  • Bolt — Only Penny's mother is seen; no father mentioned (and, Penny's character in the TV show within the movie only has a father; no mother is mentioned)
  • The Princess and the Frog — dad dies

Note that Pixar isn't much better:

  • Toy Story — Andy's mother is there, but there's never even a mention of a father
  • Finding Nemo — Mother is killed in the opening scene
  • Ratatouille — Remy clashes with his father, no mother mentioned
  • Up — Russell's home life is uncertain; we know his father doesn't spend time with him much, and there's a woman who lives with them that's not his mother (nanny? stepmom?)

Snow White, Cinderella, and Beauty and the Beast probably aren't fair to mention, considering they come from fairy tales and stories that have the situation already established. I'll concede that in some cases, the family situation is part of the story — The Lion King, The Emperor's New Groove, Brother Bear, and Meet the Robinsons wouldn't have been the same story by a long shot if they were in traditional families that stayed whole throughout the movie. Finding Nemo might've worked (a father flipping out over a son being kidnapped, even if he has a wife and other kids safe at home, isn't much of a leap), but seeing his wife and all his other kids die before hatching gave him a reason for being neurotic that you could relate to.

But the rest? Could Lilo have been a troubled kid even with loving parents? Absolutely. Could Tiana have still been trying to build the restaurant for her dad if he was alive at home, just old and retired and unable to work for himself? Yes. Would Toy Story have been any less of a story if Dad was at least around to help with the move, or the birthday party, or to open presents at Christmas? Could Jasmine have had a mother who shared in her father's concern for her future?

So, what's the deal? Is Disney just trying to make their stories accessible to even those with broken families? Is it just easier to not have to write an extra character into the story, or cheaper to not hire another voice actor or animator? Or do they really have something against a mother, a father, and a child together that they avoid the situation as much as possible?

Meeting Your Heroes

I often wondered how I would react if I met someone famous, like an actor. I figured that such people would often be hounded by fans who see them as (and expect them to be) something different than they are, who only "know" them because of the persona they put forward in front of an audience — a personality that, often, is really a product of not just their talents, but also those of the writers and directors that work together to build the show that the audience sees. If I were such a person, I reason, it would be much more refreshing to have someone meet me as a person, instead of as some fictional character that I was pretending to be. So, if I were to meet a famous actor, I would try to treat them as a person, so they wouldn't see me as just some starry-eyed fanboy out of thousands who just fawn over something that doesn't truly exist. Maybe they would appreciate not having to act for a few minutes; and, at best, maybe I could make a friend with a real individual (even if only for a moment). So, that's what I would do if I met a famous actor: meet them like any other real person.

I think it's safe to say that, when meeting Rob Paulsen (the voice behind the real Yakko Warner) at Denver Comic Con in the summer of 2015, that I pretty much failed to live up to that plan.

I wasn't sure I was going to go to Comic Con. My son and his friend were going, and though I knew the voices behind the Animaniacs were going to be there, I wasn't really feeling up to it. I'm not sure I would qualify it as a clinical depression, as I wasn't having any life-terminating thoughts. (I've had those before, so by comparison, this is "just feeling sad".) But the thought of being in large crowds with lots of people didn't sound too appealing. My wife, though, strongly encouraged me to go. I'm not sure if it was for my sake, or for the sake of being near my son (instead of sending him off to be downtown all day with just his friend), or both, but we ended up getting two tickets so that I could go.

I didn't take a ton of cash with me, so I knew that I wouldn't be bringing home a lot of autographs or memorabilia. But I did take my copy of the CD "Yakko's World" — of my Animaniacs CDs, that seemed to be the most appropriate to have Mr. Paulsen sign. After waiting in what seemed like an endless line, I finally got to meet him. My hands shook as I brought out my CD, and when he asked me my name, I'm not sure how I managed not to squeak like a little girl. As he signed, I told him how I used to take this music along on my occasional post-college road trips, how teaching myself to sing things like Yakko's World didn't just make the trip more fun, but helped me to keep my brain engaged and stay awake. I also mentioned how I was looking forward to the Animaniacs reunion sing-a-long later that day, so that I could actually sing along with him.

One thing I noticed in that very brief encounter, is that he seemed genuinely happy to meet people. Some celebrities, when you see them interacting with fans, you sometimes get the feeling that they would rather be somewhere else. They may not overtly show it, but you find they aren't really engaged in the moment. But I didn't get that impression from Mr. Paulsen at all. He really seemed to enjoy meeting each person that came up to him, throwing out one-liners in the character of whatever show his visitor was a fan of.

After meeting Rob Paulsen, I noted that there wasn't a ton of time before the Animaniacs reunion show, probably not enough time to wait in line to talk to the rest of the cast present that day (Jess Harnell, Tress MacNeille, and Maurice LaMarche were all there). But I noticed a shorter line decorated with Animaniacs pictures nearby, leading to one Randy Rogel. It wasn't a name I immediately recognized, but one I should have known. Mr. Rogel was the man behind many of the songs to which I would sing along on those road trips. He had available his song charts, which I eagerly grabbed, and he graciously signed. He also told me that he had written a new verse for Yakko's World, incorporating the changes in countries in the years since he first wrote the song. He was planning on performing it in the Animainacs sing-a-long that afternoon, something I told him I would look forward to hearing.

The sing-a-long was a real treat. Rob Paulsen and Randy Rogel performed some of the original songs, and the other actors would join on stage for some of them as well. One of the things I remember most is when Mr. Paulsen spotted someone in the audience dressed in a full Pinky costume. He said something in Pinky's voice, laughed, "narfed", and then said in a sing-song voice, "I get paid for doing this," as he did a little skip. The impression that I got was that this was a man who primarily loves what he does, has fun, and is sometimes amazed that it's also his job.

After the show, I went to get in line to meet the rest of the cast. Lines were already forming by the time I got there, so I decided to start with the shortest one (in a very relative sense, since they were all pretty long), and that was Jess Harnell's line. Eventually the cast made their way back upstairs as well, to cheers from the crowd. The rest took their places at their tables, but Mr. Paulsen did something different in his line; he went down the line, shook hands, and said hi to everyone, before going back up to his table.

I met Jess Harnell and Tress MacNeille. Mr. Harnell was an easy person to talk to, and was happy to hear about me being able to teach my kids things like Wakko's America. Ms. MacNeille was a little harder to read. I didn't find her rude or anything, but she definitely did not seem as engaged with her fans as her "siblings" were.

I then got in Mr. Paulsen's line again, just to say how much fun it was to sing along. I might've said something else, but I honestly couldn't remember. I just knew I wanted to meet him one more time.

After that, I went back to see Mr. Rogel. I noticed that the mysterious new verse of Yakko's World didn't make an appearance in the sing-a-long, so I wanted to ask him about it. He pulled out his own copy of his charts, which had the new verse in it, and actually sang it for me. Awesome! I got to hear a new verse to a song written by the man himself! I wish I could've recorded it, but getting video was one of the things that cost money (I don't fault them for that; I understand that impressions and paid exposure is how their industry works), and, as I said, I didn't bring much.

I had yet to talk to Maurice LaMarche, so I got in his line. As I was waiting, I kept looking over towards Mr. Paulsen (since they were next to each other). That's when I noticed something about myself: my cheeks were starting to hurt, because I was grinning so much. I was enjoying this.

Waiting for Mr. LaMarche, I noticed the pictures of his characters on his poster, and I was surprised to see the king from Frozen. When I met him and told him this, and how it impressed me when I'm unable to recognize a voice actor from a given character because they can change so much, he did a few more voices for me that I didn't recognize as him. (Sadly, I didn't think until it was too late to tell him, "Egad, Brain, you astound me!").

After this, I decided I had to talk to Rob Paulsen one last time. I'm not sure if he recognized that it was my third time to visit him, and hopefully he didn't start to see me as a creepy fanboy stalker (even if I was starting to feel like one). But I told him, honestly, that I hadn't felt like smiling in a while, and here I was, smiling so much it started to hurt, and I wanted to thank him. He gave me a genuine look of concern, came around the table, and gave me a big hug. That completely made my day.

They say you shouldn't ever actually meet your heroes, because you'll end up disappointed when you find out they're just human. Though I don't know that I ever thought of Rob Paulsen as my "hero" rather than as someone whose talents I enjoyed listening to, I have to say that the person I met was truly a kind and happy person; and in that, was definitely not disappointed.

I was able to meet some other people on a more human level. I met Garrett Wang of Star Trek: Voyager fame. I asked him about what he's been doing since Voyager, and we talked a bit about life goals (how he had been travelling, considering starting a family, that kind of thing). I also got to meet Nichelle Nichols, who had all the personality of a spunky old grandmother. She ribbed me a little for not giving her money, and then I got to shake her hand. So, as far as not going total fanboy meeting famous actors, I guess I didn't completely fail.

2016-07-07

That's an oddly-specific coincidence

While my wife was busy trying to coordinate Cub Scout Twilight Camp, we borrowed my mother's extended-cab pickup truck for transporting stuff to and around the camp. One day, however, as we went to drive the truck to camp, we noticed that one of the rear windows was rolled down. Thinking we goofed and left the window rolled down (though no one remembered that window being down the day before), we tried to roll it up. The motor clicked and made a short whirring sound (not unlike what you might expect to hear when starting to roll up a window), but stopped very quickly with no visible change to the window's position.

Our first thought was that maybe we hadn't rolled down the window after all. Perhaps someone had broken the window to get into the car. But the contents were undisturbed. Even a particular electronic device had not been removed. Plus, peeking into the door frame, one could see the entire top of the window glass, apparently intact (though far enough down to prevent a comprehensive visual survey).

We covered the window with a custom-fit replacement (i.e., we traced the window opening to a cardboard box, cut it out, and duct-taped it into place) until we could get it repaired. The following week, my mother took the car to the shop, who discovered that the motor had simply given out and had to be replaced — something, they said, was not entirely uncommon for a vehicle of that age. It was, unfortunately, an expensive repair, but it was done, and we figured that would be the end of it.

With the Twilight Camp supplies still taking up half of our garage, our minivan has been spending its nights parked on our driveway. This week, my wife went to take it shopping. She started the car and rolled down the front windows to let out some of the heat. As the driver's side window rolled down, she noticed that the second half of its descent seemed abnormally quick. She tried to roll it back up, and only got a click in response.

Now, we started to get suspicious. Two vehicles, both parked out in front of our house, have issues with a window not rolling up, only two weeks apart? Could there be someone trying to break into cars by shoving something down in the door, failing, but breaking the window motor in the process?

We took the van to the shop this morning, and asked specifically if they could look for evidence of any foul play.

The mechanic who first looked it over immediately noticed a broken wire and could diagnose the problem. He said it's not terribly unusual and doesn't necessarily mean sabotage, but he promised to look for signs as he worked on the car.

Meanwhile, I guess we'll prepare for a big auto bill….

2016-02-28

The Case of the Missing Nintendo

My youngest son has wanted his very own Nintendo 3DS for a long time, so that he could play with his older brothers. After saving his money, after his sixth birthday, he finally had enough to buy his own. He was so proud to be able to buy it and so happy to be able to play Pokémon with his brothers; and I was proud of him for saving his money to be able to get it himself.

Unfortunately, maybe three months later, it went missing. My wife would ask my son if he wanted to bring his Nintendo on trips where he had to go but might otherwise be just sitting around, and he kept saying he didn't want to, that he just left it plugged in and charging. But after a couple weeks of this, he said he couldn't find it. (Whether he knew it was gone for those two weeks or not, we have no way of knowing.) We tried to backtrack to when it was last seen. There were a couple places he had taken it, but we were reasonably sure it had come home afterwards. We did call and revisit those places to be certain, and no one had seen it. We believe it was brought home and plugged into its charger in the family room. Then, one of his brothers had some friends over for a birthday party.

We have talked to the parents of the kids who were over, to see if their kids remembered seeing it and where it might have been moved to -- or, yes, if perhaps they happened to come home with something that wasn't theirs. So far, though, there has been no report.

It's been almost three months since then, and I'm actually pretty upset about it. He even got a new game for Christmas that he's never even had a chance to play. If it was in the house, I would have hoped that it would have turned up by now. Today, thinking about it, I got very frustrated on my son's behalf and turned the family room upside-down looking for it. It is, granted, not the first time that room has been searched, with the same results.

I have no way of knowing if someone did end up taking it. I would hope that parents would be observant and notice if their child had a pretty expensive video game system they didn't have before. But I'm not so sure. Last year, my wife was in charge of the Cub Scout Pinewood Derby, and she took a couple of my older sons' old cars (including one that one of my boys won 2nd place in the district with, something he was pretty proud of) as test cars. They were swiped at that event, and despite sending announcements to the parents and mentioning it at the following pack meeting, they have never been returned.

I don't know for sure where it is. It could've been misplaced in the house somewhere. My son could've taken it with him somewhere and lost it. It could've been stolen. There's no way to know. And while he seems to have let it go (he doesn't talk about it, even when all of his brothers are playing around him), it still makes me very upset for him. He set a goal for himself, he saved up his money, and he purchased his very own thing, and now, he doesn't get to have it.

2015-02-17

Caffeine detox, days 1-3

I taught a lesson in church last Sunday on the subject of free agency, how God wants us to be free to make our own decisions (but not necessarily be free of the consequences of those decisions). One of the topics that came up was that of addiction, how being addicted to substances takes away our agency to do certain things. I admitted to being addicted to caffeine, how I have a hard time functioning if I don't have a daily soda, and how that limits my freedom by requiring that I have that drink before I can do anything I really want.

I figured I should probably fix that.

This isn't the first time I've tried to give up drinking soda. I did it a few years back, swearing off caffeinated drinks completely. Unfortunately, to compensate for the headaches, I started taking Excedrin (which contains caffeine), the only thing that seems to work on my toughest headaches (which, I know, sounds like the commercials, but is pretty accurate). After a couple months, I realized how ridiculous it was that I was avoiding soda but popping pills, and decided that just drinking the soda was the lesser of two evils.

Where I work, there is a fountain soda machine in the kitchen area. I thought a good way to kick this caffeine habit would be to take my 32oz water bottle and fill it with progressively less soda each day. Unfortunately, that didn't seem to be working out too well. Even just trying to dial it back an ounce or two, by Wednesday, I started to get a headache and popped a couple Excedrin. To make matters worse, on Thursday, the soda machine wasn't working, so I couldn't get my daily Coke anyway.

This Sunday, I decided to try again, but to give up on trying to make it complicated by fiddling with soda amounts. I decided to bite the bullet and go cold turkey. I didn't decide this right away — a busy morning left me soda-less before I realized it was time to go. I just decided, as I started to feel the pressure in my forehead, that I wasn't going to give in and take a caffeinated painkiller to make it go away. My wife asked me a couple times that day if I was sure I didn't want to take anything, but I had made up my mind. I was not going to be a slave to this chemical any more, and I was just going to have to suffer through it.

I wasn't feeling too well by Sunday night. I went to bed relatively early, with an ice pack on my head. I was tired enough to fall asleep fairly quickly, but I woke up about an hour before my alarm with my head buzzing. It wasn't easy getting out of bed — I'm not sure I opened my eyes much until I was already showered and dressed. Snow had fallen over the Denver area, and the roads were very slick, which meant I had to work extra hard to force my brain to ignore the pain trying to shut it down, and muster up the extra concentration required to drive safely. And, by the grace of God, I made it to work without incident (even though I passed several people who had not been so lucky).

Work was a chore. By the end of the day, the pain in my head was pretty intense, triggering feelings of nausea. Fortunately, the roads were in better condition for my drive home. Although I don't think of President's Day as a major holiday, the number of people on the road seemed rather light for a Monday rush hour. When I made it home, I immediately flopped down on the couch, while my wife got me ice packs from the freezer. I felt very tired, but I don't think I slept much more than maybe a 15-minute doze. I didn't feel well enough to eat dinner, but my wife had prepared a dessert of pound cake and fruit, and that was light enough for me to keep down. I finished off dinner with some ibuprofen, and acetaminophen (uncaffeinated) an hour later, and I was able to participate in our family bedtime scripture reading and prayer.

I would have gone to bed right then, but I had already signed up for a video game boosting session that night. (Basically, people who are having trouble getting certain Xbox achievements will sign up for a time to get together and help each other.) It would have been easy for me to just blow it off, but I didn't feel right, even if it would only affect people I have and probably never will actually meet in real life. Actually, having something to concentrate on did help me ignore the pain in my head, which by that time had moved from an all-over ache to a pinpoint stabbing behind one eye (though still not as painful as some I've had). By the end of the session, though, it was getting harder to concentrate, so I was thankful when it came to an end and I could put myself in bed. I went to bed with an ice pack on my head and tossed around a bit before I finally fell asleep.

The good news is, I woke up this morning without a headache at all. It was an encouraging start to this third day without caffeine. I didn't even feel the oppressing fatigue or headache pressure that usually drives me to have a soda or some Excedrin by lunch. About lunchtime, though, I could start to feel the pressure build up behind my eyes.

2014-09-24

More MVC and JSON.Net - Exceptions

In my last episode with MVC, I was trying to reconcile MVC 5.0 with WebAPI 5.1 and the fact that the former used a broken JSON library, while the latter used the better Newtonsoft JSON library. I implemented a model binder and a value provider factory to get the two projects in sync, and all was right with the world.

As the project has gone on, we've come across instances where we've needed to call MVC controllers and get JSON responses back. We have created WebAPI controllers in some cases, but the way the project is structured, we've needed to post MVC models as JSON via AJAX back to MVC methods where we cannot reference them in the WebAPI project (otherwise we'd have a circular reference).

There are probably a few ways to restructure this to work. Ripping the view models out to a library that can be referenced by both MVC and WebAPI was one idea, for instance. But that would've been a lot of work and caused bigger deployment headaches that I don't want to get into here. (A smaller project might've gotten away with it, though.)

Returning JSON to the client is almost as easy as having your MVC controller return a JsonResult — the MVC Controller class has its own built-in Json() method to do just that. Except, of course, it uses the JSON serializer we never want to see again. In this case, I created my own JsonNetResult class (based on a StackOverflow question, naturally), and my controller just calls this.JsonNetResult(resultObj); to do the magic.

The remaining issue, though, is when it came to exceptions. While WebAPI, on a JSON request, returns an error response formatted in JSON (that jQuery's ajax method parses easily), MVC gives you that nice, big, friendly "yellow screen of death" with the error formatted in HTML (or a generic message when you get to production). Not too useful when you want your JavaScript to report back some detail about what went wrong.

The solution, here, was to use an exception filter. The JsonNetExceptionFilter class checks to see if the incoming request was specified as JSON (using very similar code to the model binder), and if so, it handles the error on its own. We were throwing HTTP error messages using two different types of objects, depending on whether the code was copied from WebAPI or MVC (since they each have their own namespaces for this kind of thing). I check for these types so that I can set the response code to something besides the default 500 (400 Bad Request is used quite a bit), and I set the content to a JsonNetResult object with the data being a message formatted in something similar to the WebAPI format (and thus parsed by the same JavaScript code).

I considered leaving it here, so that we would have to decorate every JSON method with this handler as well as specifying it returned a JsonNetResult (unless there's a way to find out programmatically in the filter whether the current controller method returns a JsonNetResult, but I failed to find that); but ultimately, I decided to just override the default error handler site-wide (since it falls back to the base class for non-JSON requests, it shouldn't be an issue). That was done by editing the MVC app's RegisterGlobalFilters method to read:

filters.add(new JsonNetExceptionFilter());

Now, whenever we want to return an exception back to a JSON request, all we have to do is throw an exception:

throw new System.Web.HttpException((int)System.Net. HttpStatusCode.BadRequest, "Bad request data.");

Processing the return message in jQuery is left as an exercise to the reader (though if you use WebAPI, you probably already know). ;)

2014-08-11

How is escrow not a scam?

The concept of "escrow" already annoys me. As a requirement for my mortgage, I have to put aside money to pay for my homeowners insurance and property taxes, into a special account managed by the mortgage company, plus some extra depending on the mortgage company's demands. I can understand why they have a vested interest in making sure these things get paid, since technically they do own the house; but it seems it operates under the assumption that I would not take responsibility for these payments, and it gives me no opportunity to prove otherwise. Instead, the mortgage company gets to take the money and earn the interest, or dividends on the investments, and I have to just trust that they will make the tax and insurance payments (that I am responsible for) on time.

(To their credit, I have not yet had a mortgage company fail to pay either of these things on time.)

But recent events make me even more ticked off at the whole racket. I have a homeowners insurance claim in progress for storm damage (nothing too serious, mostly hail damage on the roof; we had the same thing five years ago). If the check is over a certain amount, the insurance company makes the check out to us and the mortgage company, requiring endorsement from all parties before the money can be used. I don't fully understand this. The insurance policy is a contract I have entered into with the insurance company. The mortgage company did not co-sign or endorse this contract, outside of requiring me to have a contract that meets whatever minimum requirements they had to allow me to get the mortgage. The mortgage company does not put any money into this contract — while they do make the payment of funds every year, they do so out of money they took from me. So why should they have a claim to the money on the insurance policy I paid for?

Still, before now, it was just a hurdle I had to jump before I could start repairing my home.

This time around, it's worse. Because the insurance payment was over a specific amount, my mortgage company demands I endorse the check and send it to them, and they will deposit it in a separate escrow account, and only give me money from it when I turn in receipts for repairs.

This is ridiculous. For one thing, it means I will be paying money out of pocket first. I don't have thousands of dollars sitting around that I can "float", paying for the repairs and waiting for the mortgage company to validate the receipts and give me my money back. That's the reason I have an insurance policy, so I don't have to pay out of pocket for catastrophes. For another, if my insurance company overestimated the damage amount, or if I am able to find a contractor willing to make the repairs for much less than the amount the insurance company gave me, how do I get that money when I don't have a big receipt to cover it? (The fact that the insurance company may have overpaid me is a discussion between me and them alone, since we are the ones that hold that contract.)

And this is just on top of my initial annoyance with escrow, that I'm not able to so much as put that money in an interest-bearing account to make a lousy 1‰ until I get the repairs done.

Of course, the answer is going to be so that they know that damage to their property is repaired, because otherwise the value of their property will be lessened by my negligence, while I could pocket the money and run. Still, this should be something I should prove first, let them sue me for negligence later. I get weary fast of having to pay for someone else's mistakes, and it seems like that's what is happing now: because irresponsible people exist, I cannot be trusted to do the right thing.

2014-07-27

Attraction doesn't always mean action

So here's a really interesting story. It's a hard one to read or listen to, because it involves something that, I'd wager, most of us would rather not think about. It's about a young man who discovered he was sexually attracted to children, and how he's been struggling with this attraction all his life. A big part of his struggle is that pedophilia is something for which it is very difficult to get help. As the article states: "…they have no way to talk about these urges or how to prevent them from taking control of their lives without being considered a threat. Talk to a shrink? You risk being reported to the authorities. The scientific community is so afraid of the stigma attached to even researching pedophilia that it's barely been studied it at all." Which is why this young man has risked tarring and feathering to set up support groups, to help people who need help taking control of their lives instead of letting their urges define and control them. It's actually a pretty inspirational story about taking control and standing up for what's right, even when the wrongness is coming from your own self.

Now, here's where I'm about to get very unpopular.

Take that same story, but replace all references to sexual attraction to children, with sexual attraction to members of the same sex.

Suddenly, it goes from a story of inspiration and self-control to one worthy of derision because of its support of self-denial and giving in to homophobia.

I've seen many arguments that saying "anti-gay" is wrong because people can't change who they are, and they should be free to act on their feelings. It's the whole crux of the argument for allowing same-sex marriage: preventing discrimination based on what a person is. Yet if we were to apply the same logic to other sexual attractions that are (still) considered bad — pedophilia, bestiality, necrophilia, take your pick — we would be immediately shot down for trying to support the "sick" or "depraved" (if we weren't immediately shot for merely insinuating any kind of relationship between homosexuality and pedophilia).

So what's the difference? Attraction to children is something that, as a society, we all seem to agree is wrong — so it's ok to have laws against it and to not even think about granting legal protections and rights to those forms of relationships. And yet, it wasn't until just the past few years that the same could be said for same-sex attraction. Debate or blame whomever you wish for the existence of California's famous Proposition 8, but the fact that it passed means there was a significant number of people who, less than a decade ago, supported the idea that condoning same-sex attraction was wrong.

So, why? Why is this form of sexual attraction ok, and others aren't? What makes same-sex attraction part of a person's being, but underage attraction something that a person can and should suppress and live their lives in denial of? And what form of sexual attraction that we think is wrong today, will we be forced to bake cakes in celebration of ten years from now?

2014-07-17

MVC, JSON, and DateTime (oh my)

It's been a while since I've had a programming issue that warrants a blog post, but here's an interesting one.
First, let me set up the situation. I have an MVC project (MVC version 5.0) that communicates to RESTful services using WebAPI (version 5.1). In one particular view, I write out an object in JSON with the intent that the client can make changes to it and POST it back to an MVC action to get an HTML table back. Here's the model:

public class PaymentScheduleRequestModel {
[JsonProperty(PropertyName = "effDt", NullValueHandling = NullValueHandling.Ignore)]
public DateTime EffectiveDate { get; set; }

[JsonProperty(PropertyName = "termId", NullValueHandling = NullValueHandling.Ignore)]
public Nullable<int> ContractTermId { get; set; }

[JsonProperty(PropertyName = "billDay", NullValueHandling = NullValueHandling.Ignore)]
public int BillingDayOfMonth { get; set; }

[JsonProperty(PropertyName = "freq", NullValueHandling = NullValueHandling.Ignore)]
public PaymentScheduleFrequencyId PaymentScheduleFrequencyId { get; set; }

[JsonProperty(PropertyName = "prem", NullValueHandling = NullValueHandling.Ignore)]
public decimal TotalPremium { get; set; }
}

(Note that the JsonProperty decorators exist because the same model is used to communicate to the WebAPI service -- we are using shorter property names to lighten the payload.)

And the MVC action that is set up to process it looks like this:

[HttpPost] public async Task<ActionResult> NewPaymentSchedule(PaymentScheduleRequestModel request) { … }

To put it in JavaScript, the view has this block of code:

window.ScriptModel = @Html.Raw(Json.Encode(new {
PaymentScheduleUrl = Url.Action("NewPaymentSchedule", "Contract"),
PaymentScheduleRequestModel = new PaymentScheduleRequestModel {
ContractTermId = Model.ContractTermId,
EffectiveDate = Model.StartDate ?? DateTime.Now,
TotalPremium = 200m
}
}));

Unfortunately, Json.Encode doesn't work well with dates. This is the output that the browser sees (with line breaks added for legibility):

window.ScriptModel={
"PaymentScheduleUrl":"/Contract/NewPaymentSchedule",
"PaymentScheduleRequestModel":{
"EffectiveDate":"\/Date(1078729200000)\/",
"ContractTermId":null,
"BillingDayOfMonth":0,
"PaymentScheduleFrequencyId":0,
"TotalPremium":200
}
};

Notice two things about System.Web.Helpers.Json.Encode's output:

  1. The property names are the .Net property names. The same code could not be used to post what should be the same model to MVC or to WebAPI.
  2. The EffectiveDate field has been converted to a Date function, enclosed in a string. Even if the Date function would reveal the correct value, the fact that it's in a string means JavaScript will not see it as a Date.

If I don't do anything with this object and just post it back to the MVC app, the resulting object does not have a valid date — all other values carry over, but the EffectiveDate property is 01/01/0001. So not only does it look odd, not only is it inconvenient in that JavaScript can't use it as-is (without picking apart the string), but it doesn't even work for round-tripping data to and from the client.

In doing some research on this topic, I came across Scott Hanselman's blog post describing the problem, and stating that the release of WebAPI won't have the issue since it will use JSON.Net (a.k.a. Newtonsoft.Json). Since I'm using the same model in an WebAPI call further downstream, I can verify that it does work as intended. It uses the JsonProperty decorators to rename the properties, and it serializes and deserializes like magic.

To solve this problem in MVC, you have to alter how it deals with JSON on the way out and on the way in.

On the way out is easy in my case, since I am manually spitting out JSON into the HTML. I just exchanged Json.Encode with Newtonsoft's serializer:

window.ScriptModel = @Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(new {
PaymentScheduleUrl = Url.Action("NewPaymentSchedule", "Contract"),
PaymentScheduleRequestModel = new PaymentScheduleRequestModel {
ContractTermId = Model.ContractTermId,
EffectiveDate = Model.StartDate ?? DateTime.Now,
TotalPremium = 200m
}
}));

And the browser sees:

window.ScriptModel={
"PaymentScheduleUrl":"/Contract/NewPaymentSchedule",
"PaymentScheduleRequestModel":{
"effDt":"2004-03-08T00:00:00",
"billDay":0,
"freq":0,
"prem":200
}
};

This is better. Of course, the controller action doesn't understand this. It's still looking for the .Net property names, and, since they don't exist on the incoming object, all values come back empty. (In this simple example, not only is EffectiveDate 01/01/0001, but TotalPremium is 0.0.)

The trick here is to override MVC's default model binder, so that it, too, uses the Newtonsoft.Json library. It is also consistent to have MVC use a value provider factory that also uses JSON.Net.

Fortunately, people smarter than I figured out these two steps. I found a value provider factory on this blog: http://www.dalsoft.co.uk/blog/index.php/2012/01/10/asp-net-mvc-3-improved-jsonvalueproviderfactory-using-json-net/
and the important piece, the model binder, that will translate the JSON property names to their real .Net names, is detailed here: http://stackoverflow.com/questions/4164114/posting-json-data-to-asp-net-mvc

My implementation looks like this:

And this code gets called from Application_Start (I actually added it to my WebApiConfig class (which, for some reason, exists in my MVC app even though it's obviously not the same as WebAPI), since other configuration-type things were being done here):

ValueProviderFactories.Factories.Remove(ValueProviderFactories.Factories.OfType<JsonValueProviderFactory>().FirstOrDefault());
ValueProviderFactories.Factories.Add(new JsonDotNetValueProviderFactory());

ModelBinders.Binders.DefaultBinder = new JsonDotNetDefaultModelBinder();

All this because, although Microsoft updated one of their web interfaces (WebAPI) to use the JSON.Net library that works, another one of their interfaces (MVC) uses their own, broken, JSON serialization library.

2014-04-30

Consequences of free speech

A lot has been made recently of Los Angeles Clippers' owner Donald Sterling, being caught on tape saying some pretty racist things, bad enough for the NBA to ban him for life, fine him $2½ million, and force him to sell his team. From what I've heard, this result seems like a net positive for society as a whole, but how this whole thing has come about makes me very worried for the direction this country is headed.

According to the reports I've been reading, Sterling is not a very nice guy. Some say he has a long history of being racist. By the sound of things, the NBA will be better off without him. And yet, the NAACP gave him an award back in 2009 because (at least in part) he gave away a lot of tickets. The more cynical reports suggest he was given this award, with his racism overlooked, because he gave money to the right people. He was, in fact, due to receive another award this year from the NAACP, before recent events made the organization reconsider.

But what were the "recent events"? Did he use his power as an owner in real estate to deny housing to blacks or hispanics? Did he make an employment decision based on race? No, that was years ago (before, during, and after the NAACP was giving him his first lifetime achievement award). It happened because his girlfriend recorded a private conversation, coaxed him to say what he did, and sold the tape to the online tabloid TMZ.

I've read conflicting comments as to whether or not Sterling knew he was being recorded, but those that care to mention the girlfriend seem to agree that she really worked on Sterling to get him to make his damaging statements, leading him to say what he did and really dragging it out of him. Of course that brings a lot of rumor and speculation about how much, and from whom, she was getting paid to do this, and whether or not it was illegal (most likely if Sterling didn't know the tape was rolling).

Kareem Abdul-Jabbar wrote an excellent opinion of the issue for Time, which echoes a lot of the comments I've heard that led me to my conclusion above. It also comes to pretty much the same end — Sterling's eviction from the NBA is a good thing and long overdue, but how it happened is very, very wrong.

The big question, of course, is, did Sterling deserve his NBA exile, fine, and loss of ownership of his team for what he said? Maybe his speech just served to bring about awareness of what he was actually doing, but because he only got punished when he expressed his views in the privacy of his own home, it certainly looks like that's his sin. He said something that was unpopular, and now he must pay.

It is true that "freedom of speech" does not make you free of consequences. If you say something that someone doesn't like, that person is just as entitled to use their own freedom of speech to speak out against you, exercise their freedom of association to refuse to do business with you, and even freely encourage others to avoid you as well. But why does it seem like it's only the speech — or even the perceived interpretation of speech — that deserves to be punished, when actions can go unnoticed or be forgiven?

We've been sliding down this slope for a while. Paula Deen was condemned for using a racial slur in the past (including in a description of someone who had a gun to her head), despite having apparently changed her ways since. Phil Robertson lost his place on the show Duck Dynasty for daring to honestly answer an interview question asking what he considered a sin (only to be reinstated after enough public support). Brendan Eich found he was unable to do his new job as Netscape CEO due to all the protests that, six years prior, he gave a paltry (for him) sum for California Proposition 8 — a view that, even though is becoming less so now, was the popular view at the time (Prop 8 passed) and, at the time, was even supported by presidential candidate Barack Obama. Cliven Bundy was supported by many in the (mostly right-wing) media, before he expressed his political opinion that came off as racist (though that might be less actual racism and more poor word choice and selective editing by the media, depending on your point of view).

So now, it's not just what you say in public. It's not even what you said in public in the past, whether or not you've recanted since. But what you say in private, behind closed doors, can and will be used against you in the court of public opinion; and if your opinion goes against the prevailing wisdom, whichever way it happens to be blowing at the time, then God help you.