Missing Submitter Email Address on Export (Spotting Giant Sea Bass)

[andrewpettit]

In which Wildbook did the issue occur?

Spotting Giant Sea Bass

What operating system were you using? (eg. MacOS 10.15.3)

MacOS 13.4.1

What web browser were you using? (eg. Chrome 79)

Chrome

What is your role on the site? (admin, researcher, etc)

admin

What happened?

when I export the data (in any format) there is either no column containing submitter email addresses or there is a column labeled “Submitter Email Address” but the whole column is blank (in OBIS format Excel export)

What did you expect to happen?

I expect to have a submitter email address attributed to each submitted encounter. I want to calculate the number of submitters per year.

What are some steps we could take to reproduce the issue?

Encounter search → search → export any Excel files.

If this is a bulk import report, send the spreadsheet to services@wildme.org with the email subject line matching your bug report

[Anastasia]

Thanks for letting us know! I’ll need a bit of time to work on this. I’ll follow up when I have an update.

[Anastasia]

Hi @andrewpettit Thanks for your patience.

Are you looking for just the email addresses from public submissions? If so, you can reference this post for instructions: Downloading User Emails? (Spotting Giant Sea Bass) - #2 by Anastasia

If you just need the submitter email addresses from both public and registered users, the steps are similar, except that you will do an Encounter search without adding filters for the Assigned to user section. You’ll just click the Search encounters button and then export email data.

[andrewpettit]

Anastasia,
No. When I export the encounters, I want to know the email address attributed to every encounter. Currently that column is vastly empty. I want to be able to count the number of email address that submitted an encounter per year and the number of encounters each email address submitted per year.

Thanks,
Andrew

[Lucas]

Hi

I think it may be another example of the “everything should be in the Excel export” request ?

Being able to export the photographer name (and all the data)

What Wildbook should this feature be in? Whiskerbook and I guess all of them What would you like to see? Hi Some data cannot be exported, for example the “photographer name” entered in the encounter is not in the Excel Export File, only the submitter name is. The Excel export should contain all the data of the encounters (or of the individuals), of course only within the scope of what the person doing the export is authorized to see. In particular in our case, we really need…

[Anastasia]

@andrewpettit Thanks for clarifying. Lucas is right; this is a good candidate for the “if this data is on an Encounter, make it exportable” request he linked. Feel free to add your support there so we can track interest on it.

[andrewpettit]

I just commented on that forum.

Do you know if there is an update on this issue? Is there any chance this issue will be fixed in the near future?

Thank you!

Best,
Andrew

[Anastasia]

Unless it’s been explicitly stated by one of the members of our staff, the timeline for feature requests is generally that it will get done as time and resources allow.

[ACWadmin1]

Hi @andrewpettit - this has been resolved in the new Annotation Export file as per the detail in this post: Being able to export the photographer name (and all the data) - #7 by ACWadmin1

The new export file contains all submitter information by encounter + photographer name & email.

cheers
Maureen

[Anastasia]

Hi @ACWadmin1 As I mentioned in a reply to your previous post about this, this hasn’t rolled out to all Wildbooks yet, so this request as it relates to Giant Sea Bass is not considered resolved.

[Anastasia]

Correction: This was already part of the 10.1 release and I had completely forgotten about it (even though I wrote the release summary )

That said, export improvements are still in the pipeline, but WildEx could help fill those gaps in the meantime.