Author Topic: Export collection with pictures?  (Read 403 times)

Export collection with pictures?
« on: February 14, 2021, 03:43:00 pm »
Hi guys,

I was wondering if we could make an export including pictures of at least the front box?
I know about the csv export which is a great feature. It would be nice if the pictures of the games could be exported too.

Keep up the good work and keep on gaming & collecting!

segabias

Re: Export collection with pictures?
« Reply #1 on: February 14, 2021, 05:23:23 pm »
I can get you half the way there using excel formulas.

You can concatenate the URL for the image.

The value in column A "VGC id" from the csv export, is a unique identifier, used in the URL.

Formula:                      =CONCATENATE("https://vgcollect.com/images/front-box-art/",A2,".jpg")
Displayed Cell Value:     https://vgcollect.com/images/front-box-art/89249.jpg

Taking this one step further it can be wrapped in the with the hyperlink function to make a clickable link that will open in your web browser.

Formula:                      =HYPERLINK(CONCATENATE("https://vgcollect.com/images/front-box-art/",A2,".jpg"),"Front Box Art")
Displayed Cell Value:     Front Box Art

Apparently you'd need to write some VBA code to actually pull the image into a excel spreadsheet.

« Last Edit: February 14, 2021, 10:51:37 pm by segabias »

Re: Export collection with pictures?
« Reply #2 on: May 09, 2021, 10:29:21 am »
Tnx for this.
Will try this out later.