Page MenuHomePhabricator

Gender for original TargetSmart list
Open, Needs TriagePublic

Description

Hi @Eileenmcnaughton, as discussed, could you import gender for the first amended list? I've placed the file, GENDER field for import, in the same folder as the other import files.

Thanks!

Event Timeline

LeanneS created this task.Tue, Aug 27, 5:17 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptTue, Aug 27, 5:17 PM

@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)

@Eileenmcnaughton Is it possible to just import the Gender column? The rest of the information is already imported.

@LeanneS you can set the others to 'do not import' and they won't come in. I probably still need those nulls on the end though as the code expects that.

Is there likely to be updates in the other columns?

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.

Yes a new one is fine

@Eileenmcnaughton I created a new import "TargetSmart Import 2019 - Gender" and added the Primary -Supplemental Address 1 field as the last field in the mapping. Does the file need to be updated as well?

Change 535765 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Remove our target smart import processor - it's upstreamed

https://gerrit.wikimedia.org/r/535765

Change 535765 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Remove our target smart import processor - it's upstreamed

https://gerrit.wikimedia.org/r/535765

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"

Just noting 89902 as a contact id to be updated for checking purposes when I try again tomorrow

Change 536354 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Pass params to allow scheduling

https://gerrit.wikimedia.org/r/536354

Change 536354 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Pass params to allow scheduling

https://gerrit.wikimedia.org/r/536354

This is now running & around 9000 are imported so far - the y are being put in the group 2019-tsmart-gender_import - although I doubt we need to keep that group long-term

@LeanneS this is now imported - the group is civicrm/group/search?reset=1&force=1&context=smog&gid=693 (2019-tsmart-gender_import ) - wee might choose to delete that group later