[Roy Dennis]

So it seems they have always been this way

There is another tool in the rebuild database dialog "Define field Order" button where you select the field order but that only works on files that have never been imported before and you would also have to use "Song Types to index " feature with it.

You would probably be better of re-importing them via the Index Song Files dialog. but before reimporting them from there you would probably need to delete the importedFiles.txt in each folder first.

With the amount of files you have this is going to be a long job unless all your files follow the same naming order, which I doubt they would so you would have to be monitoring it all the time.

If you think they were all imported originally with the one long file name then I think this would be the best option If you want them named correctly otherwise you would need to edit every file separately.
Alternately import them all for now as previously but use the Add folders/subfolders button and then see if they are all one long file name or if it only applies to a few.

If decide to re-import the files and you have some kma files that were imported direct from disc might be better importing them as you did with the 2 small folders first as you can't change their field order and that will stop any duplicated problems when reimporting the others.