I am testing moving from MS SharePoint - Excel to SQL database.
I have a products table with an image column
Excel Products table was stored here:
Images Folder was also stored in same location
so my excel table looked like this
and app pulled in images
The Products table is now in SQL Database but images are not pulling in.
What do I need to change or move to get images to show as the data is now no longer in the same location as the image folder?
You may find the below article and the highlighted excerpt useful.
It sounds you may need to add prefix of “/appsheet/data/Yourapp-123456/” to the Image path in the image column at the following setting.
This path is of course valid if all the relevant apps are at the path “/appsheet/data/” in your case.
https://help.appsheet.com/en/articles/5339970-images-or-files-that-do-not-load
You may also need some experimentation whether only defining the path in the Image column’s settings serves the purpose or you may need to prefix the path in the database rows itself for the existing images.
I think new images will work just fine with the path defined in the image column in app editor.
@Suvrutt_Gurjar , I thought the above needed to be added for when I am adding images through the App. I have an Images folder with images already saved in the folder that need to be displayed in an images column. Do I need to create a folder /appsheet/data/My app../Product Images and move all my images here?
May we know what is the path of the current images folder relative to the App folder meaning “/appsheet/data/Yourapp-123456/” path?
And were these images added initially through the app or the image folder was already existing? If so how you had earlier linked it to the spreadsheet based app? Meaning how the path was added to the back end table rows?
Images are in a Sharepoint folder
Default folder is
Images did not have to be in the default folder when using Excel. They were in the same folder as the Excel workbook but that is no longer in use as its in SQL database now.
Also, the Master Catalogue is a global table that is used in many apps. The Product Images folder holds thousands of images. I can’t duplicate that folder in every apps appsheet/data folder
Thank you. May we know where the image folder currently is relative to the new App path “appsheet / data/ SQLLewishamOrders-5229412”
It is in the above Sharepoint folder, unrelated to default folder
Got it. I will test at my end in similar set up and revert. In the meantime someone else may have inputs for you based on discussion so far.
Try copping your app folder from the table in which the images where, like this:
SHAREPOINT_SITE_ID_australexport.sharepoint.com_AAAAAAAA-AAAA-AAAA-AAAA-AAAAAAAAAAAA_AAAAAAAA-AAAA-AAAA-AAAA-AAAAAAAAAAAA//Apps//DATABASE.xlsx
And take all of the thing that’s before your excel workbook and use it as a prefix for one of your rows and test.
So, if the image column has something like:
/Images/One/OneOne/image.png
Try:
SHAREPOINT_SITE_ID_australexport.sharepoint.com_AAAAAAAA-AAAA-AAAA-AAAA-AAAAAAAAAAAA_AAAAAAAA-AAAA-AAAA-AAAA-AAAAAAAAAAAA/Apps/Images/One/OneOne/image.png
or
SHAREPOINT_SITE_ID_australexport.sharepoint.com_AAAAAAAA-AAAA-AAAA-AAAA-AAAAAAAAAAAA_AAAAAAAA-AAAA-AAAA-AAAA-AAAAAAAAAAAA//Apps//Images//One//OneOne//image.png
I’m thinking out loud here but I use sharepoint and it seems it should work.
Also, check your SQL table on appsheet, and see which config is under this:
Hi @SkrOYC , so I tried the above but still no luck.
When data is in Sharepoint, Source Id is
so I took the above … Master Product Catalogue/Product Images/ …jpg and added it to 1st product in table database and got the below error
Also, I think the below is correct as this is where other images (unrelated to products) that are captured through the app are stored.
I’m getting very confused now!!
Below is not about the Product images but about the images users upload throught the app for other processes which is not working - images not getting stored.
In my App where the data is coming from Sharepoint (location in screenshot above) the default folder is
/appsheet/data/LewishamGatewayPh2Orders-5229412
All that is stored here are my templates in a folder called Contents
Images that users upload through the app are stored in folders of format tablename_Images in the same location as the spreadsheet, not the default folder.
Now that I have no spreadsheet so no path for spreadsheet, where does tablename_images get created?
@1minManager , @MultiTech , maybe you can help me out here?
This is the shocking reply I got from support:
Hello,
Thank you for contacting Google Cloud Support.
Unfortunately, we are unable to help you with your query since it’s a design query and we are limited in providing support to technical issues. Would you please follow this community post or you can create a new one anytime and other AppSheet experts will answer it there. We try to use the community for these kinds of how-to questions so they’re public and discoverable by people who may have the same question.
You could also check our partners from www.appsheet.com/partners through they are third parties with their own fee structures.
Best Regards,
Pratip G.
Do you see any options there aside from Default?
Also, if you try to match the App Default Folder with the one where the images are, does that display the images as if the default folder were the one with the excel on a “normal” scenario (not sql)?
I’m jus trying to help though, I don’t have experience on this.
@Marc_Dillon You have any inputs?
As per my understanding, the image file folder needs to be a subfolder of
Appsheet /Data/SQLLewishamOrders-5229412
which is the current path of the app.
You could possibly create a folder under the Appsheet /Data/SQLLewishamOrders-5229412 with the same name as your current image folder, so something like
Appsheet /Data/SQLLewishamOrders-5229412 / Product Images/…
and test with one or two images.
Is there a specific question or a summary, or are you expecting me to review this entire thread?
Have you dealt with images after a migration from worksheet to sql?
Yes.
The images stay in the same GDrive folder, and the “default app folder” has to point to the appropriate parent folder to make the relative paths stored in the data correct.
In other words, the relative path is no longer relative to the table’s sheet location, but relative to the “default app folder”.
I have 2 issues here:
Product images. These are already stored in a folder in SharePoint and need to be used by several Apps so cannot be stored in appdata/data default folder of one app.
Images that are uploded by the user which will be stored in the appdata/data/tablename_images folder.
I didn’t change anything but this is sort of working but something strange going on.
I have 2 tables PODs and Revised POD’s.
I uploaded an image to POD and it is showing in the App but not in the Appdata… folder
I uploaded 2 photos to Revised POD, both showing in the App but only one in appdata…
