For future
I agree with the contributor who suggested cutting the harness and lap soldering a pigtail in, to a standard you're tooled up for.
I rarely hunt for highly specific connector mates. If you calculate your hours spent, now and in the future, it usually works out to be a better value to:
* Cut
* Lap solder a pigtail
You might buy that pigtail, or crimp cut ends to suit. Molex and jst have a great number of pigtailed options.
* Populated pigtail
* Crimped ends
Crimped ends mean you're buying specific lengths of wire (say 1 foot or 1 meter) with a professionally crimped pin or socket on the end.
You can buy them in different colors, then you populate the housing as needed. Did you key sells many crimped ends*
* 16awg - I crimp my own
* 1mm, 1.5mm, 2mm pitch, I buy crimped ends
As wires get smaller (~26awg) hand cramping becomes practically impossible. You can do it... I can do it under a microscope or under a really good lens... But they're very fussy... And you really want to have the professional crimper ($250)
The real reason to buy crimped ends is so you don't have to buy the expensive crimper and kill yourself pinching microscopic wires!
...
Anyhow
I would say that 7 out of 10 times I cut a connector off and lap solder a pigtail.
2 out of 10 times I spend a custom PCB adapter board with mating 90° or straight connector.
1 out of 10 times I hunt for the perfect mate.
But
The connectors I generally deal in are 99.9% intended to land on a PCB board, so board Mount connector.
... Glad to hear things worked out for you
-methods