I am helping my father in law get his collection of postcards into an online gallery. I am hoping to use the Wix website to create a database of the postcards and include the web URL that each can be found at.
All of his postcards are in a Dropbox folder. The issue is that there are over 10,000 postcard images that need adding to the database collection. With this volume, it makes sense to use the Import facility available in Wix.
So I need a way of:
- Getting the folder structure from Dropbox, including subfolders and files into a spreadsheet
- Making an entire Dropbox folder public including subfolders and files
- Constructing the web URL from the filename and folder info obtained in step 1
I believe I can do step one easily enough through Excel and using the "Get Data" from folder. I also believe it is easy enough to give public access to a particular folder. My issue is creating the individual web URLs that will be in the sub folders. I don't want to have to visit each f the 10,000 items and copy and paste the public URL for the image into a spreadsheet.
Hopefully that makes sense, but if not please ask for clarification and I will do my best 