Tweak the JotForm URL so that I can use it in my Shopify import to grab the image?

  • rtolmach
    Asked on February 11, 2019 at 4:06 PM

    Hello Jotform

    We want people to use a jotform embedded on our website to provide various data and upload pictures. We will then massage that data and use it to populate a CSV that we import to shopify.


    It ALMOST works for us. We run into one problem.


    The form is here: https://form.jotform.com/82055266987166

    The problem arises in the question: Please upload your company logo. 


    In the submission we received at 

    2019-02-11 10:37:14

    The image appears OK in the view-submissions page, and it has a link, "IMG_6055.JPG" under the image.

    In the CSV download of the submission, the logo image is shown to be at https://www.jotform.com/uploads/rtolmach/82055266987166/4257086338211348049/IMG_6055.JPG

    (Yeah, I know. The person who tested it used a picture of a painting instead of a logo.)


    I can go to that link and download/save the image (but I cannot see it online there).


    We massage the data we collect from our jotform submission download CSV, and we use it to populate a CSV that we then upload to Shopify as product submissions.


    However, Shopify says,

    "Line 2-6: Validation failed: Image https://www.jotform.com/uploads/rtolmach/82055266987166/4257086338211348049/IMG_6055.JPG failed to download. - file not found. Check that file can be found at your URL."


    I assume that may be because the jotform URL is configured just to allow download of the image, and not to allow viewing it online. 


    Shopify does not have a solution for that. We will have WAY too many submissions to be able to download each image from jotform, save them into a CDN, and then enter those CDN URLs into the shopify import tool.

    Is there a way I can tweak the jotform URL so that I can use it in my shopify import CSV and Shopify can grab the image?

    Thank you!
    Robert 










  • jonathan
    Replied on February 11, 2019 at 6:34 PM

    From what I understand on the details, the one that was not working was the steps that involved uploading the file to Shopify directly from JotForm server (using the submission file download  link).

    Example, you were trying to upload this file to Shopify, the file was located at JotForm -- so it will not work.

    Is there a way I can tweak the jotform URL 

    Can you provide more details how you meant to tweak the URL?

    You cannot customize the download URL link of the uploaded file in the form.

    But what you can do is use a 3rd party file host integration i.e. Dropbox, google drive... so you can create a download link of the file using the 3rd party app.

    Please let us know if you need further assistance.





  • rtolmach
    Replied on February 11, 2019 at 7:43 PM
    Hello Jotform

    Thank you for your prompt reply.

    Yes, when I enter the jotform URL into a CSV to import into Shopify, they cannot grab the image.

    Re:
    “Is there a way I can tweak the jotform URL Can you provide more details how you meant to tweak the URL?”

    I do not know how your system works. So, perhaps there is some variation of the URL, which would let me (and Shopify) see the image in the browser.
    So, this is the current link, which only allows download (and not viewing):
    https://www.jotform.com/uploads/rtolmach/82055266987166/4257086338211348049/IMG_6055.JPG
    Perhaps there is a version of the URL that allows the image to be viewed, such as for instance the following (I am just making a wild guess for the purpose of illustration to show what I mean by tweaking):
    https://www.jotform.com/uploads/rtolmach/82055266987166/view/4257086338211348049/IMG_6055.JPG
    You wrote:
    “But what you can do is use a 3rd party file host integration i.e. Dropbox, google drive... so you can create a download link of the file using the 3rd party app.”
    We need a way to do this in bulk. We cannot manually download tens of thousands of images and upload each of them to dropbox, then figure out the URL of each, then add those URLs into a CSV file to upload to Shopify.
    Here is another approach:
    We are using the uploadcare widget for some images that we need to force the user to crop to the correct aspect ratio. Uploadcare gives us image URLs that we can actually view, such as https://ucarecdn.com/b451b6f2-2071-4d47-b08c-ca233d845e82/-/crop/750x281/0,360/-/resize/1200x450/ and which Shopify can therefore import.
    So, although we do not need the logo to be cropped, I suppose we could use the uploadcare app for the user to submit their logo. However, that gets expensive.
    Is there another widget to upload pictures (it does not need to provide for cropping), which will work with jotform, which will give us viewable image URLs, and which is more affordable than uploadcare?

    Thank you!
    Robert


    Robert Tolmach
    Co-Founder
    ChangingThePresent.org
    rtolmach@ChangingThePresent.org



    ...
  • Jed_C
    Replied on February 11, 2019 at 10:29 PM

    Yes, when I enter the jotform URL into a CSV to import into Shopify, they cannot grab the image. — The link you get is the download link. I don't think it will be detected in shopify if it's a download link. You'll need a direct link that opens into browser.

    In a sample image you have in your submission, you can see that this image is loaded on the browser. To see if my observation is correct, try adding that link to your CSV and see if that uploads in your Shopify image in that way we will be able to compare the download link vs. the direct image link.

    Let us know how it goes.

  • rtolmach
    Replied on February 12, 2019 at 9:43 AM
    Hello

    Thank you for your reply.

    The image link provided by the uploadcare widget
    https://ucarecdn.com/bd422a13-a530-4231-8d71-475ac79429de/-/preview/1162x693/-/setfill/ffffff/-/format/jpeg/-/progressive/yes/
    works OK for a Shopify import.

    The download link provided by jotform does not work in a shopify import.

    Is there a way to get an image link from jotform instead of a download link?

    Thank you!
    Robert


    Robert Tolmach
    Co-Founder
    ChangingThePresent.org
    rtolmach@ChangingThePresent.org



    ...
  • David JotForm Support Manager
    Replied on February 12, 2019 at 11:32 AM

    Unfortunately, there isn't, the links generated for the files are just to download.

  • rtolmach
    Replied on April 28, 2019 at 7:20 PM

    I have two problems:

    ----1----

    Following up on Jonathan's comment:

    "But what you can do is use a 3rd party file host integration i.e. Dropbox, google drive... so you can create a download link of the file using the 3rd party app."

    How would I do that? If I use the jotform file upload tool, I get a download link. I need a direct image link that I can put into our Shopify product import CSV. Does Jonathan's reply suggest a way to do that? I do not understand it.


    ---2---

    In some cases, we need visitors to upload a picture and be prompted to crop it to a certain aspect ratio we specify. I know I can do that with the widget from Uploadcare, but it is very expensive. Is there another widget that will do that?


    Thanks!


  • Kiran Support Team Lead
    Replied on April 29, 2019 at 1:52 AM

    The issue seems to have already been addressed on your other thread https://www.jotform.com/answers/1798344. We request you to try enabling the Multiple files option in the file upload field as mentioned in the other thread. Also, we request you to follow-up on the other thread if you need any further assistance. 

    Thanks!