Is there a way to export Testflight external tester emails

Question

Doesn't seem like iTunes connect has basic exporting of user emails from Prerelease > External testers

Needed to export emails to CSV

Does anyone have a script or workaround solution?

Thanks!

score 15 · Accepted Answer · edited Jun 24 '17 at 22:16

You can use pilot (from Fastlane) to do that :

To export in a CSV file: fastlane pilot export

$ fastlane pilot list

+--------+--------+--------------------------+-----------+
|                    Internal Testers                    |
+--------+--------+--------------------------+-----------+
| First  | Last   | Email                    | # Devices |
+--------+--------+--------------------------+-----------+
| Felix  | Krause | felix@krausefx.com       | 2         |
+--------+--------+--------------------------+-----------+

+-----------+---------+----------------------------+-----------+
|                       External Testers                       |
+-----------+---------+----------------------------+-----------+
| First     | Last    | Email                      | # Devices |
+-----------+---------+----------------------------+-----------+
| Max       | Manfred | email@email.com            | 0         |
| Detlef    | Müller  | detlef@krausefx.com        | 1         |
+-----------+---------+----------------------------+-----------+

score 12 · Answer 2 · answered Nov 30 '15 at 21:14

12

Just use console get Email, First Name, Last Name

Paste this into console https://gist.github.com/creaoy/80d1092283a5d0fa1070

answered Nov 30 '15 at 21:14

creaoy

136
1
4

3

this answer worked surprisingly well. for new folks (me), to use console -> https://developer.chrome.com/devtools/docs/console (thank you @creaoy) – tmr Jan 27 '16 at 08:45

score 4 · Answer 3 · answered May 07 '16 at 18:33

4

Upon trial and error (because I'm desperate), I found a way out, the low tech way.

Go to Activity > iOS History > All Builds > Testers

This is the page where you see all of your external and internal testers' emails, name, status, sessions, crashes and devices. Select all rows and paste them into excel. It will display all information in each cell nicely :) Select the first column in excel and you have all the emails only.

answered May 07 '16 at 18:33

Sue Anne C

61
5

1

There is no "Testers" option these days. – toast Nov 11 '16 at 04:54

score 2 · Answer 4 · answered Jun 22 '16 at 03:28

I expanded creaoy's script to include the Status (Notified/Installed x.xx). Still works for me today.

Scroll all the way down so all testers are loaded. Then paste this in Safari's error console and hit enter.

var text = ''; 
$('.col-email').each(function(index,el) { 
if (index == 0) {
    text = 'Email, First Name, Last Name, Status\n';
}
else {
    //Email
    text = text + $.trim($(el).find("a").text()) + ',';
    //First Name
    text = text + $.trim($($($($('.col-name')[index]).find("span")[0]).find("span")[0]).text()) + ',';
    //Last Name
    text = text + $.trim($($($($('.col-name')[index]).find("span")[0]).find("span")[1]).text()) + ',';
    //Status
    text = text + $.trim($($($($('.col-status')[index]).find("div")[0]).find("span")[0]).text()) + '\n';
}
}); 
var a = document.createElement("a"); 
var file = new Blob([text], {type: 'text/csv'});
 a.href = URL.createObjectURL(file); 
 a.download = name; a.click();

score 1 · Answer 5 · answered Aug 09 '15 at 15:57

Not as yet. You can only import a csv file but not create one from the users there.

You can copy the rows, edit them in TextEdit/Notepad in the format: fistname,lastname,email

and save that as csv to use when you want to import those emails later.

It would be good if they implemented it to do this automatically, or at least having the option to send the updates to specific groups that you can create.

score 1 · Answer 6 · answered Oct 19 '15 at 08:55

1

I made a little console hack that extracts just the emails. Improve to your liking :-)

https://gist.github.com/larsparendt/a67d25b1611db67ba67b

answered Oct 19 '15 at 08:55

lpa

710
6
14

Alon Burg · Answer 7 · 2017-03-10T15:37:41.697

1

Some great answers, but wanted to add another option. BoardingBot is a tool that lets you send TestFlight invites automatically, as well as emails to your beta testers. So this might fill your need for contacting your beta testers.

Disclaimer: I'm the founder of BoardingBot :)

edited Mar 10 '17 at 15:37

answered Nov 16 '16 at 07:03

Alon Burg

2,500
2
27
32

amleszk · Answer 8 · 2016-04-06T15:24:23.030

0

Edit:

The below method is flakey - there is a great ruby gem for managing testflight testers called Fastlane pilot. I woudl recommend looking into that instead: https://github.com/fastlane/fastlane/tree/master/pilot

Found a google chrome extension that will do the job:

Table capture:https://chrome.google.com/webstore/detail/table-capture/iebpjdmgckacbodjpijphcplhebcmeop/reviews?hl=en

Also needed to filter out duplicates, which can be done using Google spreadsheets

edited Apr 06 '16 at 15:24

answered Aug 14 '15 at 12:06

amleszk

6,192
5
38
43

how did you filter out the dupes? – inorganik Apr 06 '16 at 00:20

inorganik · Answer 9 · 2016-04-06T13:01:37.703

Since iTunes Connect is now an angular app, many of the answers on this page no longer work. However if you have the Angular/Batarang extension for Chrome you can paste this script in the console (cmd+i) and it will spit out a csv. Note that first you have to inspect an item in the list (cmd + shift + c) to get a reference to $scope. Also don't forget to scroll down to make the page auto-load the whole list.

var text = ''; 
angular.forEach($scope.filteredTesters, function(val) {
    text += val.firstName.value + ',';
    text += val.lastName.value + ',';
    text += val.emailAddress.value + '\n';
}); 
var a = document.createElement("a"); 
var file = new Blob([text], {type: 'text/csv'});
a.href = URL.createObjectURL(file); 
a.download = name; a.click();

score 0 · Answer 10 · answered Apr 18 '16 at 21:06

If you just need the emails and have a text editor with regex replacement you can do this

Scroll to the bottom of the list in itunesconnect so you get all rows
Copy all the rows into text editor of your choice (I used sublime text)
replace ^.*\n\n with <empty string>. This removes all names
replace \n\s\n with ,.
replace \n with ,.

and you're left with a CSV of all the emails

score 0 · Answer 11 · answered Feb 20 '17 at 13:47

if like me you also needed the date this is the code you need:

var text = ''; 
$('.col-email').each(function(index,el) { 
if (index == 0) {
    text = 'Email, First Name, Last Name, Status, Date\n';
}
else {
    //Email
    text = text + $.trim($(el).find("a").text()) + ',';
    //First Name
    text = text + $.trim($($($($('.col-name')[index]).find("span")[0]).find("span")[0]).text()) + ',';
    //Last Name
    text = text + $.trim($($($($('.col-name')[index]).find("span")[0]).find("span")[1]).text()) + ',';
    //Status
    text = text + $.trim($($($($('.col-status')[index]).find("div")[0]).find("span")[0]).text()) + ',';
 //Date
 text = text + '\"' + $.trim($($($($('.col-status')[index]).find("div")[0]).find("span")[2]).text()) + '\"\n';
}
}); 
var a = document.createElement("a"); 
var file = new Blob([text], {type: 'text/csv'});
 a.href = URL.createObjectURL(file); 
 a.download = name; a.click();

MillerMedia · Answer 12 · 2017-09-01T17:40:38.810

I came up with a jQuery solution to output this data to the console in CSV format. It is dependent on the way that the pages selectors are set up but as of now (Sep. 2017), it runs great.

Open up the console on your browser (I use Chrome), copy and paste this code in, hit enter. Quick and dirty.

Edit

I borrowed some code from guido's answer here that triggers an automatic download after hitting enter.

output = "email,first name,last name\n";

jQuery('table.table-itc-testers tr[ng-repeat*="itcUser"]').each(function(){
    row = [];

    //Email Address
    row.push(jQuery(this).find('span a[href*="users_roles"]').text());

    // First and last name
    full_name = jQuery(this).find('td.sorted > span:not(.ng-hide)');

    // If only name is filled out
    if(full_name==""){
        row.push("");
        row.push("");
    } else {
    row.push(full_name.clone().children().remove().end().text().trim());
        row.push(full_name.find('span.lastname').text());
    }

    output += row.join(",") + "\n";
});

var a = document.createElement("a"); 
var file = new Blob([output], {type: 'text/csv'});
a.href = URL.createObjectURL(file); 
a.download = 'external_testers.csv'; a.click();

score 0 · Answer 13 · answered May 25 '18 at 23:29

0

Quick Update with a new answer: iTunes Connect now has an easy-to-use download button on the right side of the page!

answered May 25 '18 at 23:29

Aaron Sarazan

305
1
4

Is there a way to export Testflight external tester emails

13 Answers13

Edit:

Edit