I have been scratching my head trying to figure out how the "scale configuration" cell should be written in order to import a competency framework as desired with the scale listing the default and proficient scores in the correct place. After more trial and error than I'd like to admit, I think I figured out the pattern. I have created a notated screenshot which I hope may help someone in Moodle land.
This is an example formula for the "scale config" cell in the CSV for comp import:
The "scaleid" refers to what number the scale will be out of all of your scales in Moodle currently. the "id" refers to which column you are referring to when you are configuring your scale to be "default" and "proficient". There are 2 choices 1 or 0. If you want to list that column 2 has a default and proficent score, and coloumn 4 has a default score, but no proficient score, you would use the formula above.
Anyhow, you might already know all of this, but it was news to me and I wanted to share.