Add unit tests for import scripts

For custom import scripts, we should refactor the logic to be testable and add some basic unit tests.

At the very least, there should be some "smoke test" that the local deployment works.