Importing Security Filters with a Dataport

jorgebraga · 2006-02-14

Hi all of u!

I'm trying to import permissions from an Excel sheet using a Dataport.

The Permission Table (2000000005) is defined as follows

Field No. Field Name Data Type Length Description
1 Role ID Code 20
2 Role Name Text 30
3 Object Type Option
4 Object ID Integer
5 Object Name Text 249
6 Read Permission Option
7 Insert Permission Option
8 Modify Permission Option
9 Delete Permission Option
10 Execute Permission Option
11 Security Filter TableFilter

My poblem is precisely the Security Filter. I cannot use it in a Dataport.

The error states that the data type TableFilter is invalid for the Source expression.

How can we solve this problem?

Aditional info: NAV 3.70 SQL Server Dataport works fine if Security Filter is not used (BY I NEED IT BAD)

Txs in advance 4 your time

ara3n · 2006-02-14

have you tried to asign the value to a text variable and then export. And do the same when you import.

kriki · 2006-02-15

If you don't use it, don't put it in the dataport.

If you use it, you have to use a text-variable in the dataport and
in the "OnBeforeExportRecord()" put

txtSecurityFilter := FORMAT("Security Filter");

and in the "OnBeforeImportRecord()" put

txtSecurityFilter := '';

and in the "OnAfterImportRecord()" put

EVALUATE("Security Filter",txtSecurityFilter);
IF "Role ID" = 'SUPER' THEN
  CurrDataport.SKIP; // this because I think it will give an error on the SUPER-role

jorgebraga · 2006-02-16

Guys txs a lot for your help.

It works just fine (And it was very simple to do with your tips).

ara3n · 2006-02-16

Thanks kriki for writting to code. Don't have the time to write it.

kriki · 2006-02-16

Didn't take me that much time to write it.

ara3n · 2006-02-16

that is still time

maya-chan · 2012-05-30

I guess it's only work if u didn't put any filter on security filter.
How bout if we put filter on it? I tried but can't work for imported the filtering.

CMIIW

kriki · 2012-06-01

Does it give an error? And in that case: which error?

maya-chan · 2012-06-13

No error, but the security filter not inserted, only blank.
But i have worked with it.
I added Clear then it's worked
Thx

Importing Security Filters with a Dataport

Answers

Categories