Skip to content

[QUESTION] - Blank Account.Name becomes random and overwrites existing value in Target Org even with "csvInsertNulls": false #1209

Description

@Hieu-NgoOSF

Question title
Blank Account.Name becomes random and overwrites existing value in Target Org even with "csvInsertNulls": false

Question summary
There is an existing child account in the target org with name "ChildAccountName".
When running an upsert command, with the CSV file having "Name" as a blank value (e.g. no change), SFDMU instead generates a random name and upserts that into the Target Org.

Re-running the upsert will always generate a new random Account.Name and upsert that into the target org, overwriting it.

Current setup
Command ran:

  • sf sfdmu run --sourceusername csvfile --targetusername hnz-so --path ./data/Account/ --diagnostic --anonymise

export.json
export.json

source
Account_source.csv
RecordType_source.csv

target
Account_update_target.csv

What you already checked
I have read a lot of official documentation but could not find information on why random value is being generated for Account.Name, especially as I don't have any data masking on.

Expected clarification
Want to check if I am missing a flag and how to fix this if it is not a bug. I suspect as Account.Name is a required field in salesforce, the tool always ensures it is populated by generating a random value before upsert.

The expectation is if I have the flag "csvInsertNulls": false, then a blank value here should:

  1. For Insert, the target CSV should show an error saying Name is a required field
  2. For update, the target CSV should ignore Name as its not changed, and update other fields if changed.

The result instead shows success, with the random Account.Name upserted.

Log file (optional, recommended for runtime/migration questions)
2026-07-09__12_00_41.log

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

help-wantedUser need a help or something not working, not a bug

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions