Form nucsvtransfer

[ricklincs]

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)"

[kev1n]

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.

[ricklincs]

Thanks Kev1n, will give that a try later.