Form nucsvtransfer

Questions related to using nuBuilder Forte.

Form nucsvtransfer

Unread postby ricklincs » Wed Feb 10, 2021 8:17 pm

Is it possible to give user access to the form nucsvtransfer?
At present only Admins can run this form and procedure.
I have tried adding a run object,have set it to run the nucsvtransfer form and given the user group access (add, print etc).
The user can open the form, enter details in the objects, but when the user presses transfer a message comes up with "Access To Procedure Denied... (CSVTRANSFER)"
ricklincs
 
Posts: 37
Joined: Tue Aug 02, 2011 1:09 am

Re: Form nucsvtransfer

Unread postby kev1n » Wed Feb 10, 2021 9:47 pm

Hi,

The CSVTRANSFER procedure is a system procedure and it can't be chosen in the Access Levels form.
A workaround is to run this insert statement on your database.

Replace fffffffffffffff with the Access Level ID of the user (see table zzzzsys_access, column zzzzsys_access_id)

Code: Select all
INSERT INTO `zzzzsys_access_php`(
    `zzzzsys_access_php_id`,
    `slp_zzzzsys_access_id`,
    `slp_zzzzsys_php_id`
)
VALUES(
    '5f6fe8bd7ff850a',   -- New (unique) ID. No need to change if the insert statement is just run once.
    'fffffffffffffff',     -- access_id of the user. Table zzzzsys_access, column zzzzsys_access_id
    'nu5f6fe8bd7ff850a' -- ID of the PHP Procedure CSVTRANSFER. Do not change.
);


After running the sql, the user will need to login again.
kev1n
nuBuilder Team
 
Posts: 2117
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Form nucsvtransfer

Unread postby ricklincs » Thu Feb 11, 2021 2:11 am

Thanks Kev1n, will give that a try later.
ricklincs
 
Posts: 37
Joined: Tue Aug 02, 2011 1:09 am


Return to General

Who is online

Users browsing this forum: No registered users and 24 guests