how to transfer existing images to a new app using database ?

AppSheet AppSheet Q&A
, ,
1

Hello All,

I have an existing app which is based on google sheet. This app have a lot of images saved on google drive (app used for inventory management)

I’m creating a new app based on Appsheet database to replace the existing app.

I would like to reuse the images from the “old” app to the “new” app.

For my “old” App images are saved under this path : My Drive /APPNAME/FOLDER

PgM_0-1681749498694.png

For my “new” App, i’ve saved images under the path used when adding image from the app

PgM_1-1681749603643.png
PgM_1-1681749603643.png485×120 8.41 KB

PgM_3-1681749720897.png
PgM_3-1681749720897.png890×348 54.2 KB

Names of the images (seems to be) correct

PgM_4-1681749776661.png
PgM_4-1681749776661.png667×238 28 KB

But… it’s not displayed in the App, I’ve an error 404

PgM_5-1681749825677.png
PgM_5-1681749825677.png424×237 2.23 KB

Does anyone faced this issue ?

I would like to avoid to take thousands of pictures again :wink:

Many Thanks

PG

2

When using sheets, images are located using relative pathing - relative to the location of sheet itself. In your example path above, your sheet must have been located in the “My Drive/APPNAME/” location. AppSheet then creates the FOLDER using either a default name or a custom name you supply in the Image column. The default is constructed from the table name the column is located in followed by “_Images”. so it seems you relied on the default AppSheet FOLDER = “STOCKAGE_Images”.

In your new app, if you have the same Table name, the sheet is placed at the same level as the old app and the the sheet image column is updated correctly for each row, then you should have no issues. If you made manual changes to get the new app setup, You may need to clear the browser cache to see the images loaded. The browser relies heavily on caching of image to help speed up access. When the new app was setup, it may cached that there were no images for the rows. The manual updates won’t affect the cache immediately. But you can clear the cache to refresh.

NOTE: I am seeing a discrepancy in the table name of “STOCKAGE” versus “STOCK”. In your new app, if using the AppSheet default, you need to make sure that the folder name matches with the Table the image column belongs to and that the associated column in the sheet matches on each row.

For example…your post implies the new app name is “Daily_OPS-6030176” and inside that is the image folder is “STOCK_Image”. So these things MUST be true for your app to find the images:

  1. Your sheet is located under"Daily_OPS-6030176".
  2. The table in your new app is named “STOCK”
  3. In the sheet, for each row under the Image column, the path name starts with “STOCK_Images/” followed by the original filename (not including any path info from the old app).
  4. And of course, the images have been moved into the folder “STOCK_Images”.

If these are NOT the case, make the changes and try again. If all checks out, then clear the cache and try again. If still no luck then we need to see the above details to help more.

3 Likes
3

Many Thank you @WillowMobileSys +1