Page MenuHomePhabricator

May 26 – Export and upload welcome survey data
Closed, ResolvedPublic

Description

See parent task for instructions.

Details

Due Date
May 25 2022, 10:00 PM

Event Timeline

kostajh set Due Date to May 25 2022, 10:00 PM.May 3 2022, 12:54 PM

@Sgs can you please share the command you used for the export? (see T307454#7951561 for a previous example.) We need the "to" timestamp so that the export today can start from the correct timestamp.

@Joe did it since I didn't have access, the command used was:

mwscript extensions/GrowthExperiments/maintenance/ExportWelcomeSurveyMailingListData.php --wiki=eswiki --debug --from=20220509000000 --to=20220526093322 --output-format=csv > may26.csv
Tgr subscribed.

We can just use the registration timestamp of the last user in the export (which is 20220526091005).

The export for May 26 was cumulative, which is incorrect (I've updated the parent task description to be more clear). I'll recreate the May 26 export now.

On mwmaint1002:

mwscript extensions/GrowthExperiments/maintenance/ExportWelcomeSurveyMailingListData.php --wiki=eswiki --debug --from=20220523222300 --to=20220526222300 > may26.csv

Debug output:

Converting registration timestamps:
	From (exclusive): 20220523222300 -> UID 6565166 (registered: 20220523222225)
	To (inclusive): 20220526222300 -> UID 6568306 (registered: 20220526222226)

The uploaded file is in the private google drive.