adding functions for fixed field manipulations when importing records