DMT Menu Security - Group not in a list of values?

Kinetic ERP
1

I’m running a DMT for menu security, done this a number of times for other companies. Suddenly, it’s not working. Not sure if it’s something I’m doing, I’m missing something quite obvious, or there are changes in the DMT tool. We’re on-premise, 2024.1.9.

Here’s my DMT file. I cut it down to just this one record, one group to import:

Company,SecCode,Description,AllowAll,AllowAccess
XXXXX,SEC022,Buyer Maintenance,False,CFO

When I run this through DMT, I get this error message:
Access contains a value which is not in the list of valid values for this column.

CFO is definitely one of the menu security groups that is set up.

I’m a pack rat when it comes to saving files, I pulled up DMT imports I’ve run on other companies to do this very thing - the format is basically the same. Not sure what’s going on.

2

It doesn’t make a lot of sense, but instead of “False” try “0” (numeral zero).

Worth a shot.

3

Or try putting quote marks around CFO… I can’t remember if SQL likes single or double quotes so I usually do the wrong one first.

4

Tried the quotes already, no-go. Tried the 0 instead of false, no-go.

Interesting, I thought I’d try to set the AllowAll first in one update, then do a second update where I updated the Entry List. However, when I used just this file:

Company,SecCode,Description,AllowAll
XXXXX,SEC022,Buyer Maintenance,TRUE

I still got the same error message. Looks like the problem isn’t in the list - it was giving me the error even without the list there.

5

My next step here is to set the one record manually, then go query it out via BAQ, then use THAT as the template for other records.

If THAT doesn’t work, it’s support ticket time.