Can you Mass Disable the Marketing User field (UserPermissionMarketingUser) for multiple User records using Data Loader?

Question

I am attempting to mass disable the User record's Marketing User field (UserPermissionMarketingUser) for certain user records that exist within a test SF org. The steps I used were:

1. Create a report for all 797 users who have profiles that do not match these three profiles:

   a) System Administrator

   b) Marketing User

   c) Marketing

2. The report headers contains these fields :

   a) Profile

   b) User Id

   c) Username

   d) Marketing User

3. Export the report into a CSV file.

4. Change the contents of all the Marketing User values from '1' to '0' in order to disable the field.

5. Using Data Loader with the Update setting for the User object, Upload the updated CSV file back into Salesforce.

However Data Loader does not recognize this field. It does not exist when I try to map the SF fields with the columns in the CSV file. It is the only SF field it does not seem to recognize during mapping.

Q) How can I mass update this field without using Apex? Thanks

Answer 1

Yes. The User field you want to change is UserPermissionsMarketingUser. You can load into this field using Data Loader.

Answer 2

I want to thank @DavidSchach for pointing me in the right direction regarding tools other than Data Loader to access the Marketing User field since I already use the latest version (45.00) of this tool and I still was unable to map the Marketing User field from Salesforce User detail Record with my CSV File's Marketing User column. That issue occurred because the Salesforce Marketing User field that was being retrieved by Data Loader was hidden from this tool.

Solution: My Solution was to go to Workbench because this tool allowed me to do an update on User object and its mapping did give me access to the Marketing User field (UserPermissionsMarketingUser). Here is the abbreviated screen shot and the results.