Bulk upload of excel spreadsheet failing

Support
,
1

What Wildbook are you working in?
IOT

What is the entire URL out of the browser, exactly where the error occurred?
Import Overview:
Excel File Name: /data/upload/hpastrp/WildbookStandardFormat.xlsx
Excel File Successfully Found = true
Excel Sheets in File = 2
Excel Rows = 6
Excel Columns = 21
Trial Run: true
NOT IMPORTED Column types (1):
Encounter.mediaAsset

Can you describe what the issue is you’re experiencing?
bulk upload will not recognize Encounter.mediAsset column
Can you provide steps on how to reproduce what you’re experiencing?
here are the first two columns in my excel spreadsheet…

Encounter.mediaAsset Encounter.verbatimLocality
IMG_3704.JPG Puako, HI Isle, HI
IMG_3705.JPG Puako, HI Isle, HI
IMG_3707.JPG Puako, HI Isle, HI
IMG_3708.JPG Puako, HI Isle, HI
IMG_3710.JPG Puako, HI Isle, HI

When I run the excel upload, the Encounter.mediaAsset is not imported.
If this is a bulk import report, send the spreadsheet to services@wildme.org with the email subject line matching your bug report

2

Hello,

I’ve taken a look at your explanation and the sample file you provided, thanks
for these.

I believe the problem is the column name: Media asset is a numeric column to allow
many images if necessary, so it needs to be named Encounter.mediaAsset0.
For any subsequent images you would add others like Encounter.mediaAsset1
and so on further down in the row.

Please alter your excel sheet, give this a try and let us know if your import concludes
successfully.

Thanks!

3

Thanks, Colin.
The change in column name worked… Does this mean that for each subsequent bulk upload the Encounter.mediaAsset column name should
increase by one… 0, 1 , 2, 3 ,etc.
Also, can I refer to more that one picture in each row with comma separation or does each image have to be a separate row?

4

Hey there!
You’re close; you use additional Encounter.mediaAsset columns to add more pictures in a row. So every bulk import should have Encounter.mediaAsset0, and if you want to add two more pictures to that encounter, you would include Encounter.mediaAsset1 and Encounter.mediaAsset2 as additional columns.

Tanya