AnsweredAssumed Answered

Required for pdm_userload

Question asked by jlhawley on Aug 22, 2016
Latest reply on Aug 24, 2016 by jlhawley

I have read everything I could get my hands on. We are attempting to update several contact records in the contact table (just one field), the issue is that there are many users without a middle_name value. The middle_name says in schema designer that it is "required for pdm_userload". We are having no issues including the middle_name as long as the user has a middle name, everything works fine. However, when there is no middle_name I get a "cannot have null value" error. Then when I try to remove the middle_name it from the .dat file and run it I get an invalid logical key error, skipping table. Is there a way to map a null value in the .dat file that will allow me to include the middle_name which is required? Do I need to do a deref for the middle_name value? If so, will that effect anything if it is null?

Outcomes