@LeanneS I took a look at the file - it's slightly different as you say - if you can update the targetsmart_2019_bulkimport mapping to be correct for the new file I can import it on the command line. Maybe add a couple of columns to the csv for 'null' values for supplemental address &supplemental address if we are going to wipe those when you do it (you can leave the column blank but it will let you save those columns then)
Got it. Could I create a new import mapping to not mess with the field mapping for the future? As you know, the current export mapping page can be cumbersome to deal with.
No other updates are needed in the other columns.
I tested on staging & it updated gender for 10022 but my code to add them to a group (which I did want to do) was missing a beat so just need to merge that & try again)
drush cvapi TargetSmart.import csv=sites/default/files/targetsmart_gender.tsv mapping_name="TargetSmart 2019 - Gender import" offset=99 batch_size=50 add_to_group_name="693"