Section access

[#1]

Hi,

why when I run my script can I then not see any data? Even though I have set my access as admin, everything disappears!

The data definitely loads into the file, so it's not a question of it not being there.

I am GLOBAL\A_MCLEOD

ACCESS	NTNAME	OMIT
ADMIN	GLOBAL\A_MCLEOD
USER	GLOBAL\USER1	R_Comments__c
USER	GLOBAL\USER2	e_comments__c
USER	GLOBAL\USER3	R_Comments__c

Section Access;
Sections:
LOAD
  ACCESS,
  NTNAME,
  OMIT
FROM
[..\..\Section Access\SalesforceSectionAccess.xls]
(biff, embedded labels, table is [Sheet1$]);

[#2]

User * in place of blank OMIT and check

[tresesco · Accepted solution]

Section Access loads table as a temporary table which is droped automatically. hence, you can't see it. If you want a table to be visible, load it under Section Application.

[#4]

Try inserting something into admins omit field. If the data loads, only the omitted field not, then QV has some problem with understanding the blank field.

Let us know what you have experiencd!

Best,

T

[#5]

This will not work, as * means the fields listed in the OMIT column will mean R_comments__c and e_comments__c will be unavailable to me

[#6]

And what if I have numerous tables following the Section Access table?

Do i simply need to put one preceding statement

Section Application;

[#7]

* does not mean the field in the list, it is to get access to all the values in the field

[#8]

Oh OK. I was only going of this doc

On page 17 it says

USER5 has a “*” added which means that all listed fields in OMIT will be unavailable.

USER5 will not be able to see fields SALES, WAREHOUSE and EMPLOYEES.

Note the admin user has nothing in the OMIT column

[tresesco]

Section access table is something that is uasually not desirable to be visiable by the users. If you take the same table under section application as well, it will be visible (Ctrl+T) to the users. Preceding load(under section application) might not be able to fetch data from section access.

[simenkg]

The documentation is correct. * means all listed values in the field and not all possible values in the field.