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:

#13

Hi!

Has this been fully resolved with the update? There are still some image URLs that are returning error.

For example...
https://store.hp.com/CanadaStore/Html/Merch/Images/c05714247_1750x1285.jpg
https://store.hp.com/CanadaStore/Html/Merch/Images/c05101508_1750x1285.jpg
https://store.hp.com/CanadaStore/Html/Merch/Images/c05101719_1750x1285.jpg

The formula I'm using is
=Dump(ImageProperties('SEO Optimized Feed - NO PAPER'!U26,"FileName",TRUE))

Thanks,
Kevin

#14

Hi Kevin,

We have not released the new build yet but if you email me (victor@seotoolsforexcel.com) I can send it to you. Those images returns 'forbidden' and the same is true for the DownloadFile function. Will need to look into why.

#15

Update: Issue has been fixed