parsing transactions correctly and loading one-by-one if some are truncated