ImageProperties Error

#1

Hi,

I'm getting the following error when I try to bulk validate image URLs.

What's causing this issue?

Kevin

#2

How are you doing the "bulk" part?

#3

I meant a range of cells containing image URLs.

#4

Range of cells are not supported. You need to use Formula mode for one image URL, then expand the formula to the rest of the list.

#5

Thanks.

What valid values does the formula take?

ImageProperties(imageUrl,fields,excludeHeaderInResult)

imageURL is pretty self-explanatory. For fields, should I use the properties exactly as they are listed here: https://seotoolsforexcel.com/imageproperties/?

Lastly, what do I put in for excludeHeaderInResult?

#6

You can experiment with the formula settings from the ImageProperties taskpane (found in HTTP tab):

Here, you can chose the fields and other arguments. In the example, I've used brackets around A2 which is a shortcut to insert the cell reference in the formula.

#7

Thank you!

I used the formula to validate image load status. For most, the returned status was ok, but for some, I got #VALUE!.

For example - https://assethub-pro-us-standard-cache.s3.amazonaws.com/hp%2Fba57152e80717158aaceb17ff5f2d43ffa28eb9d

The link is public and you can paste the URL into the browser to see the image, but the formula is returning #VALUE!. Why is that happening?

FYI, the formula is =ImageProperties(s420,FileName,TRUE)

#8

Hi!

Just following up on my question. Actually, I'm not even sure if you are a support staff or just a very friendly community member, but I'm appreciative nonetheless!

Can you please take a look at my question and tell me what the issue might be?

Kevin

#9

Hi Kevin,

Thanks for noticing this. I haven't solved it yet but working on it.

1 Like
#10

Identified and fixed the error. The fix will be included in the next release (hopefully out in 1-2 months).

Do you have other examples of image urls which resulted in errors?

#11

Thanks for the update!

Here are a few more.

https://assethub-pro-us-standard-cache.s3.amazonaws.com/hp%2F1ec97a174f76af1bed1e3d5c87e7d6dba8fc3720

Thanks

#12

Thanks, all images worked :slight_smile: