I am having a bit of a problem with the image...

(Stefan Ottomanski) #1

I am having a bit of a problem with the image cache. I upload all my images directly to Google drive and not through the app. I have replaced the first version of all my images on Google drive with edited new versions.

Some of the new versions appear, while others still show the old versions. This is what I did: Delete the old versions from Google drive and empty the bin. Reupload the new images (same file name and directory) Turned off the offline mode in the app Deleted the app and reinstalled it several times (iOS) 24 hours later some images “repaired” while others are still the old images (which no longer exist anywhere except as these ghosts in the app.

Is this a Google thing or could they be tangled up somewhere in AppSheet?

Should give Google a bit more time to digest the changes?

There are several thousand images, all cropped to 600 x 600 and average 180kb in size.

The images work fine in the app except for this issue.

(Aleksi Alkio) #2

The problem is normally the cache and you should change the file name slightly.

(Stefan Ottomanski) #3

@Aleksi_Alkio you mean the image filename?

(Aleksi Alkio) #4

Yes, that’s correct.

(Stefan Ottomanski) #5

@Aleksi_Alkio there are thousands of images. It is doable but it does complicate the workflow…

When you say “cache” do you mean the cache in the app (AppSheet side) or in Google Drive?

(Stefan Ottomanski) #6

What about copying the app and deleting the old one? Would the cache be copied too?

(Dinh Nguyen Nguyen) #7

@Stefan_Ottomanski1 Hi Stefan, the cache that stores image paths resides in an online caching service called Redis. This means that copying or deleting the app will have no effect on the cache. Since the cache stores not just the names of the image files, but rather the entire file paths, one quick way to fix this problem is to move the images to a different directory.

(Stefan Ottomanski) #8

@Harry that worked!

I just changed the top folder in Drive and in the sheet. Took 2 minutes.

It also fixed the sheet: I have an extra column to show the thumbnails in the sheet and they were not all showing up either. Now they are.

(Stefan Ottomanski) #9

Follow up question: if I set SYNC: CLOUD TO.DATA SOURCE or server caching to. ON, How would this affect the cache with issues like this?

(Dinh Nguyen Nguyen) #10

@Stefan_Ottomanski1 By default, image paths are cached regardless of the server caching setting. This setting only applies to table data, and the cache is automatically cleared when AppSheet detects that the tables have been modified.

(Stefan Ottomanski) #11

@Harry I see. All much clearer now. Thanks.