Manipulating order of descriptive fields when importing XLSX terminology with GlossaryConverter

Question

I'm importing a huge XSLX sheet with termininology into MultiTerm 2017 using GlossaryConverter. This works pretty well, but I'd like to be able to manipulate the order in which the descriptive fields are imported. It seems to be completely random as you can see in the screen grab below. 
 
 I'd simply like to have them in alphabetical order, just the way they are displayed in the bottom section of the screen grab. I'm aware I can change the order in the Termbase Wizard, but I'm doing a lot of maintenance in the XLSX file, often re-importing it several times a day. 
 Thanks in advance for any ideas! 
 Eva

Paul · Answer

Hi Eva Repolusk-Stoppel , 
 
The only way I could achieve this, without using Excelling MultiTerm, is to change the order in the spreadsheet where it's faster. You could even create a small macro in Excel to reorder the columns after conversion from MultiTerm. Just make the order in Excel in reverse alphabetical order from left to right. 
 
Regards 
 
Paul

Paul · Answer

Hi Eva Repolusk-Stoppel 
 I don't get the same order. This is what I have to do: 
 Converting Excel to TB 
 
 reverse alphabetical order of the fields in columns from left to right 
 drop into the Glossary Converter 
 
 Converting TB to Excel 
 
 drop into Glossary Converter 
 fields are the wrong way around, so I reverse the columns so they are as above
 
 this is what you could create the macro for

Regards 
 Paul

Klaus Fleischmann · Answer

Hi Eva also from Kaleidoscope side. I am sorry for the support misunderstanding. We have a hard time following community cases that have to do with our products, but Paul was nice enough to forward your issue. 
 
From what you are describing here, you wanted to test Excelling MultiTerm which certainly can do what you are trying to achieve. But the error screenshot you sent us was from Publishing MultiTerm. Can you try again, please, with Excelling MultiTerm? The error you got in Publishing MultiTerm has to do with the Java XSLT engine which PMT needs to produce PDFs etc., but which is not required for Excelling MultiTerm at all. 
 
Best regards, 
 
Klaus

Trados Studio > 3. MultiTerm

Manipulating order of descriptive fields when importing XLSX terminology with GlossaryConverter