topic Re: Section Access Issue in App Development

Section Access Issue

John117 — Mon, 17 Apr 2023 15:14:06 GMT

Hi All,

having an issue with section access which has me stumped..

This works in my load script and applies the restriction to me (s110725) that I would expect Region = APAC.

Section Access;
Load * INLINE [
ACCESS, USERID, RESTRICTION
USER, AD_DOMAIN\ADMIN, *
USER, XXXX\s1100725, APAC
];

Section Application;

[Clockify]:
NoConcatenate
Load *
,Region as RESTRICTION
from [$(vFilePath)Clockify_Time_Report_Detailed.xlsx]
(ooxml, embedded labels, table is [Detailed Report]);

If I change the load script to use another field:

Section Access;
Load * INLINE [
ACCESS, USERID, RESTRICTION
USER, AD_DOMAIN\ADMIN, *
USER, XXXX\s1100725, Formulation SG
];

Section Application;

[Clockify]:
NoConcatenate
Load *
,Group as RESTRICTION
from [$(vFilePath)Clockify_Time_Report_Detailed.xlsx]
(ooxml, embedded labels, table is [Detailed Report]);

I get this error:

'Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script.

Data has not been loaded. Please correct the error and try loading again.'

Any ideas on what could be causing this?

Thanks.

Re: Section Access Issue

BrunPierre — Mon, 17 Apr 2023 15:35:39 GMT

Hi, I know INLINE always treats data as upper case, but try changing the reduction field the with "FORMULATION SG".

Re: Section Access Issue

John117 — Mon, 17 Apr 2023 15:38:19 GMT

Hi,

tried that and still get the same error.

Thanks for the reply.

Re: Section Access Issue

BrunPierre — Mon, 17 Apr 2023 15:46:59 GMT

Restrictions must have their Field Names and Values in Uppercase.

Upper(Group) as RESTRICTION

Re: Section Access Issue

John117 — Tue, 18 Apr 2023 08:59:05 GMT

I managed to get this working by introducing another table and applying the section access there.

Section Access;
Load * INLINE [
ACCESS, USERID, RESTRICTION
USER, AD_DOMAIN\ADMIN, *
USER, XXXX\s1100725, Formulation SG
];

[ClockifyStg]:
NoConcatenate
Load *
,Group as RESTRICTION
from [$(vFilePath)Clockify_Time_Report_Detailed.xlsx]
(ooxml, embedded labels, table is [Detailed Report]);

Section Application;
[Clockify]:
NoConcatenate
Load
*
Resident [ClockifyStg];

Re: Section Access Issue

Hania — Tue, 18 Apr 2023 09:19:30 GMT

hii,

[Clockify]:
NoConcatenate
Load * ,Upper(Region ) AS RESTRICTION,

from [$(vFilePath)Clockify_Time_Report_Detailed.xlsx]
(ooxml, embedded labels, table is [Detailed Report]);

Section Access;
Load * INLINE [
ACCESS, USERID, RESTRICTION

ADMIN, INTERNAL\sa_scheduler, *
USER, AD_DOMAIN\ADMIN, *
USER, XXXX\s1100725, Formulation SG
];

Section Application;

please use above Highlighted script once.

Hope this helps,

help user find answers ! don't forget to mark a solution that work for you and click the like button!