Debugging Problems with Spendcube data refresh

The first load of data into the SpendCube dev project lead to null values showing up in some value which should not have null values. Spent most of the day trying to figure out why...