Spreadsheet to form widget fails to open stream after updating file

  • Profile Image
    taxi88test
    Asked on October 10, 2017 at 11:25 AM

    Hi.

    I'm using the Spreadsheet to Form widget to preload my recurring customer data. I have about 200 lines on my xlsx file.

    Everything worked great for the first 1000 submissions, until I made a few additions changes to the source file.

    Now I'm getting the following error:

    file_get_contents(https:///uploads/taxi88test/form_files/Book3.395.xlsx): failed to open stream: operation failed 

    in : /home/prepopulator/public_html/widget/server/AutoFillExcel.php 
    on line : 62

    reupping the old file is no help. also cloning the form. The entire 

    it only works from clones of the preupdated form - until i try to reupload any source file.

    It looks like there's a problem with url - missing the domain. Something in the reuploading procedure messes it up.

    Please have it fixed ASAP. I need to update my xlsx list...


    *update* - Reverting to an older version of the form works! but can't update the file

  • Profile Image
    aubreybourke
    Answered on October 10, 2017 at 12:23 PM

    Great that you found a solution with reverting to an older version of the form.

    So what you are saying is that now your excel file seems to be causing the problem?

    If the file was downloaded from JotForm, may I suggest you download it again:

    How to Export Form Data to Excel 

  • Profile Image
    taxi88test
    Answered on October 11, 2017 at 06:03 AM

    You miss understand me. It doesn't matter which excel file I upload - I always get that same error message - even when starting a new form from scratch!

    The only thing that works is using an older version of my original form - and never updating the excel file

  • Profile Image
    taxi88test
    Answered on October 11, 2017 at 06:05 AM

    I've tried comparing the source codes of the working form and another, but can't seem to find any difference relating to the PHP input strings. perhaps something is going on server side? 

  • Profile Image
    taxi88test
    Answered on October 11, 2017 at 06:25 AM

    This doesn't work:

    <input id="widget_settings_3" class="form-hidden form-widget-settings" type="hidden" value="[{"name":"excel","value":{"name":"Book3.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","url":"www.jotform.com","base":"Book3.731.xlsx","owner":"taxi88test"}},{"name":"codeColumn","value":"F"},{"name":"labelsRow","value":"1"},{"name":"fillBtnText","value":"Auto Complete Fields"},{"name":"loadingText","value":"Loading..."},{"name":"submitInput","value":"Yes"}]" data-version="2" />

     

    var _cFieldFrame = document.getElementById("customFieldFrame_3");

      _cFieldFrame.onload = function()

      {

        widgetFrameLoaded(3, {

          "formID": 72831450091451

        })

      };

      _cFieldFrame.src = "//data-widgets.jotform.io/spreadsheetToForm/?qid=3&ref=" + encodeURIComponent(window.location.protocol + "//" + window.location.host);

      _cFieldFrame.addClassName("custom-field-frame-rendered");


    }, 0);



    This does:

    <input id="widget_settings_3" class="form-hidden form-widget-settings" type="hidden" value="[{"name":"excel","value":{"name":"1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","url":"www.jotform.com","base":"1.357.xlsx","owner":"taxi88test"}},{"name":"codeColumn","value":"F"},{"name":"labelsRow","value":"1"},{"name":"fillBtnText","value":"%D7%94%D7%9B%D7%A0%D7%99%D7%A1%D7%95 %D7%9E%D7%A1%D7%A4%D7%A8 %D7%95%D7%9C%D7%97%D7%A6%D7%95 *%D7%9B%D7%90%D7%9F* %D7%9C%D7%94%D7%A9%D7%9C%D7%9E%D7%AA %D7%A4%D7%A8%D7%98%D7%99%D7%9D %D7%90%D7%95%D7%98%D7%95%D7%9E%D7%98%D7%99%D7%AA"},{"name":"loadingText","value":"%D7%98%D7%95%D7%A2%D7%9F %D7%A0%D7%AA%D7%95%D7%A0%D7%99%D7%9D..."},{"name":"submitInput","value":"Yes"}]" data-version="2" />

    {

      var _cFieldFrame = document.getElementById("customFieldFrame_3");

      _cFieldFrame.onload = function()

      {

        widgetFrameLoaded(3, {

          "formID": 72213870891459

        })

      };

      _cFieldFrame.src = "//data-widgets.jotform.io/spreadsheetToForm/?qid=3&ref=" + encodeURIComponent(window.location.protocol + "//" + window.location.host);

      _cFieldFrame.addClassName("custom-field-frame-rendered");


    }, 0);


  • Profile Image
    Jenny
    Answered on October 11, 2017 at 09:10 AM

    Is it possible to share the excel file with us so that we can investigate the issue further?

    You can simply send an email to jotformsupport@gmail.com with this thread's number 1269384.

    We will be waiting for your response.

  • Profile Image
    taxi88test
    Answered on October 15, 2017 at 04:33 AM

    Hi.

    As I've stated, it happens regardless of the actual Excel file content.

    I've tried it with a super simple 5 row on 5 column worksheet with the same results.

    And as i've mentioned, it works fine on my "older" form. Up to the point where I try to upload a new worksheet. 

  • Profile Image
    Jim_R
    Answered on October 15, 2017 at 06:56 AM

    Sorry for the confusion. You're correct - With an older form that I have, the widget still works. But as soon as I change the spreadsheet file, it will stop working and throw that error.

    The URL looks malformed indeed which I think is the culprit, so to be sure, I escalated this to our Devs. Although we won't be able to give you any timeframe, rest assured, we'll keep you apprised on this same thread when there's an update.

    Thanks for reporting this to us.

  • Profile Image
    taxi88test
    Answered on October 15, 2017 at 07:12 AM

    Thanks for the very prompt reply. hopefully your devs are as good as you tech support guys :-)

  • Profile Image
    John_Benson
    Answered on October 15, 2017 at 10:45 AM

    Thank you for your nice words.

    We will contact you again on this thread once we have an update.

    Cheers! :)