How can I export images in Database?

Ask the community
,
1

Hi,
I created a database which collect images from users. When I try to export the database to csv file, the file only contain a url which I cannot open in Chrome. So I am wondering how can I download all the images in my Database?
Thanks,
EuTester

5 Likes
2

I see what you mean, the export to CSV dumps the wix-path into the data. There is not much you can do about it using this function. You have 3 options:

  1. in excel or LibreOffice or whatever you use that has a programming language, post process the data iwth the example code below)
  2. write your own export to file. Corvid dosn´t support it out of the box, but I believe Steve Cropper once wrote a good tutorial on this very forum to do it anyway
    3)write simple Corvid code, output it to a text box and copt/paste by hand.

Below my latest version of the function that converts a wix-image address to a URL that it useable from outside Wix:

export function getFullImageURL(imageSRC) {
 //convert the wix:image url to something that can be displayed inside html-component
 let strReturnImage = "";
 if (imageSRC.startsWith("image:")) {
 let wixImageURL = "";
        wixImageURL = "https://static.wixstatic.com/media/";
 let wixLocalURL = "";
        wixLocalURL = imageSRC.replace('image://v1/', '');
        wixLocalURL = wixLocalURL.substr(0, wixLocalURL.indexOf('/'));
        strReturnImage = wixImageURL + wixLocalURL;
    } 
 else if (imageSRC.startsWith("wix:image:")) {
 let wixImageURL = "";
        wixImageURL = "https://static.wixstatic.com/media/";
 let wixLocalURL = "";
        wixLocalURL = imageSRC.replace('wix:image://v1/', '');
        wixLocalURL = wixLocalURL.substr(0, wixLocalURL.lastIndexOf('/'));
        strReturnImage = wixImageURL + wixLocalURL;
    }
 else {
        strReturnImage = imageSRC;
    }
 return strReturnImage;
3

What’s the point of having images if you can’t download them, I’ve created an online brochure to connect directly to my indesign and find that the images are useless unless I download each individually and then paste to a database.
Easy with one or two but not with thousands. What a waste of time, this really needs sorting out or let people know before they start developing. Arrggghhh! :angry:

4

Please refer to old posts in a link on your new forum post if you need to bump old posts.

Use Giri Zano code if you need to download the pictures directly.

Otherwise, when you export the dataset from Wix, it will just download the file url for the image which is where it is stored in your Wix Media Mnaager.
https://www.wix.com/corvid/reference/$w.Image.html

Image
Images are images stored in the Media Manager or retrieved from an external web location.

The URL formats for images are:

  • Images from the Media Manager: wix:image://v1//#originWidth=&originHeight=[&watermark=<watermark_manifest_string>]

  • Images from the web: http(s)://

5

Do I understand correctly that you have created an online brochure in Wix and you want to incorporate images from an external source, like indesign? If so, you can: the image objects takes 2 kinds of images: wix images (stored in a db) and a plain URL. So if indesign stores imaes as a plain URL, you just have to point towards it.

6

Hi giri excuse me to contact you here but can you assist me to fix an issue on my mobile version’s wix website ?