That sounds a lot like my first mbox import. It took me a couple of months.
Yes, you can probably fix some stuff with some replacements.
If you put .json at the end of a category url you can find a category id. It’s an integer.
You’ll need to look at what the user creator is using for an identifier and what is getting used by the post function to find users. Or maybe they just don’t match.