Moving to SQL - Images Column question

[Martina_Hawkins]

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?

[Martina_Hawkins]

No it is set as 

This is to the OneDrive of the account. I now have a folder /appsheet/product images which can be used by multiple apps. It holds images which are used in a Master Catalogue table that is stored in SQL Databse. That is the reason for this as sugessted in an earlier post which works.

I didn't know you could use a Sharepoint site here 

[SkrOYC]

Yes, you can point to the sharepoint site so that all of the app's data is there instead of an individual account

Data Organization for Teams | AppSheet Help Center

It should help I think with the images thing to be more reliable

[Martina_Hawkins]

thanks for this suggestion @SkrOYC . That seems to work and will save having to move all the images to /appsheet folder.  At least something is working 🙂

[Martina_Hawkins]

Getting another strange message.  When I copied the App whose data was in SharePoint to a new App and said copy to database, the App copied and created the tables in the database and changed the sources in the App automatically.

LewishamGatewayPH2Orders is the original App. SQL Lewisham Orders is the new App with data in the database. I can see the records in the database.  There are no Excel spreadsheets connected to this App.

[SkrOYC]

Look at the "Reports" table also.

The process to copy apps is a little bit cumbersome sometimes and some things doesn't work.

Sometimes you are tell there was a problem and everything is fine... etc

[Martina_Hawkins]

@SkrOYC , yes Reports table is also fine. It is now syncing fine.  It just randomly came up with that error which is very odd and very unreliable

[Martina_Hawkins]

Revisiting this to try to explain better my current problem.

App 1  Default folder 1.  Spreadsheet Project A. Default folder 1\POD_Images (stores uploaded images by user through app)

App 2 Default folder 2.  SpreadSheet Project B. Default folder 2\POD_Images (stores uploaded images by user through app)

App 3 Default folder 3. Spreadsheet Project C. Default folder 2\POD_Images (stores uploaded images by user through app)

I have 12 of these Apps.

Data Store is Sharepoint. Spreadsheets are in the Default folder. Images that Users save through each App are saved in folders in default folder 

App 13. Default folder 13. Spreadsheet - Master Catalogue. This spreadsheet has an image column. Images in this column get pulled from images that are stored in a folder called Product Images which is also in Default Folfer 13 

The Master Catalogue folder gets pulled into Apps 1-12 which works fine.

I have now moved the spreadsheet for App 1 to an Azure SQL Database. I have also copied over the Master Catalogue to the spreadsheet.

I know I now have to keep the SharePoint Master updated and the Database Master updated which isn't a huge probelm for now.

The issue is that App 1 can no longer see the Product Images folder in Default Folder 13

To solve this I moved the SharePoint Master Catalouge spreadsheet and the Product Images folder to the default folder of App 1.

I then changed the sourece of Apps 2-12 to pull from default folder of App 1 insttead of default folder of App 13.

This works ok.

The default Folder of each app has to stay the same so that each app can see existing uploaded images.

My big problem is that if I move App2 to a database it will not be able to see the Prodcut Images in default folder of App 1.

I would need to thave the Product Images folder in each default folder but that would be impossible to keep up to date.

Are there any SQL experts who could tell me if it is possible to store all the images in the Products Images folder in the SQL Database and for each app to look there instead of in SharePoint?

[Martina_Hawkins]

So in an attempt to solve the above:

1. Set up Blob Storage in Azure SQL Database

2. Created some containers and added some images to the containers.

3. Got the url of an image and changed the Product Image column in the Master Product Catalogue table

This however didn't work. Image does not show in App.

Is this even possible? Does anyone know?