Session access with users on external file

anormand — Sat, 16 Nov 2024 20:41:30 GMT

Hello community,

I'm currently working on an app that reduces data using "Session Access".
This app will be accessed from 2 ways :

1 - Admin (me) : I can see everything.

2 - Users (a lots, more than 800) : only see their personnal data.

For the session access I wrote something like this :

LOAD
'USER' AS ACCESS
,'MYSERVER\' & Lower(ID) AS USERID
,Upper(NOM) & ' ' & Upper(Prénom) AS RDVVENDEUR
,Upper(NOM) & ' ' & Upper(Prénom) AS RDVVERBATIM
,null() AS OMIT
FROM [lib://Folder/ExcelFileWithUsers.xlsx]
(ooxml, embedded labels, table is [tab1]);
Concatenate LOAD
ACCESS
,USERID
,RDVVENDEUR
,RDVVERBATIM
,OMIT
Inline [
ACCESS,USERID,RDVVENDEUR,RDVVERBATIM,OMIT
ADMIN,INTERNAL\SA_SCHEDULER,*,*,
ADMIN,MYSERVER\mylogin,*,*,
];

The part with "inline" that contains my login and admin right works.

But the part with the excel file looks to fail.

Is there a restricted use to only inline ?

Thanks in advance,

Adams

Re: Session access with users on external file

anormand — Wed, 12 Jun 2019 07:53:58 GMT

This morning I did a test, I added 1 user on the inline part, and it's works.

Why the "from excel" part don't work ?

topic Re: Session access with users on external file in App Development

Session access with users on external file

Re: Session access with users on external file