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
    taxi88test
    Answered on October 23, 2017 at 07:05 AM

    hey guys, it's been a week, any news? it's pretty critical for my business use case. thanks.

  • Profile Image
    John_Benson
    Answered on October 23, 2017 at 11:02 AM

    Sorry for the inconvenience.

    We still do not have any update from our developers regarding this issue. Upon checking the ticket, the priority is set to "Important". We'll message you on this thread once we have an update.

    Thank you for your patience.

  • Profile Image
    taxi88test
    Answered on October 31, 2017 at 07:36 AM

    Another week has passed, still waiting. Surely it can't be THAT difficult... 1509449764QXKyMry.jpg

  • Profile Image
    Rose
    Answered on October 31, 2017 at 08:44 AM

    We are really sorry for this inconvenience and the delay. 

    I will send a reminder to the assigned developer to see if there is any update on this ticket. 

    We thank you in advance for your understanding and cooperation.

  • Profile Image
    taxi88test
    Answered on November 07, 2017 at 06:31 AM

    And another week has passed. My patience is starting to wear thin...

  • Profile Image
    Rose
    Answered on November 07, 2017 at 07:38 AM

    We are sorry for this inconvenience. 

    The developer who has assigned to this ticket has already informed about your urgency and I'm sure he will do his best to solve this problem. On the other hand, we unfortunately can not give you an exact time interval about when this problem will be fixed due to our developers workload. However, I'm raising ticket priority from Important to VeryImportant. 

    Thank you again for your understanding. 

  • Profile Image
    taxi88test
    Answered on November 28, 2017 at 05:38 AM

    Hi, still waiting for a solution

  • Profile Image
    John_Benson
    Answered on November 28, 2017 at 10:22 AM

    Sorry for this inconvenience.

    Unfortunately, we still do not have any update from our developers regarding on this issue. We will message you again on this thread once we have any updates from our developer.

    Thank you.

  • Profile Image
    taxi88test
    Answered on December 17, 2017 at 08:15 AM

    come on guys, over 2 months and counting to solve a small issue.

  • Profile Image
    TREVON
    Answered on December 17, 2017 at 08:23 AM

    Our sincere apologies for any inconveniences caused. Our developer assigned this task is still working o a solution and we will update you once issue is resolved.

    Once again our sincere apologies for any inconveniences caused.

  • Profile Image
    taxi88test
    Answered on December 25, 2017 at 08:38 AM

    Happy holidays!

    still waiting.

  • Profile Image
    Richie_P
    Answered on December 25, 2017 at 08:45 AM

    Sorry for this inconvenience.

    Unfortunately, we still do not have any update from our developers regarding on this issue. Your issue has been flagged as very important, I am sure our developers are doing their best to solve it.

    We will message you again on this thread once we have any updates from our developer.

    Thank you for your understanding.

  • Profile Image
    taxi88test
    Answered on January 26, 2018 at 04:14 AM

    still waiting. this is absurd.

  • Profile Image
    TREVON
    Answered on January 26, 2018 at 06:47 AM

    Unfortunately we still do not have any update from our developer on this issue at the moment. I have also notified the developer on the same and they will update on this thread once the issue is resolved.

  • Profile Image
    taxi88test
    Answered on February 11, 2018 at 06:42 AM

    October - November - December - January

    still no solution?

  • Profile Image
    BDAVID
    Answered on February 11, 2018 at 10:46 AM

    We have heard from our developer. I will request for any updates on this.

  • Profile Image
    taxi88test
    Answered on February 27, 2018 at 06:15 AM

    It has been a further 2 weeks. This inability to fix the issue is costing me a lot. As a paying customer I think I can expect a fix in less than 5 months (and counting). 

  • Profile Image
    tina
    Answered on February 27, 2018 at 08:26 AM

    Unfortunately, since it is highly related to our developers workload, we cannot promise you any time frame when the issue will get fixed.

    Please accept our sincere apologies for this inconvenience and delay.


  • Profile Image
    widgets
    Answered on February 28, 2018 at 05:16 AM

    Hi we apologize for the late response. We could not replicate the error. We also tried your form But it seems to be working normal. However based on your report the url where the file is served was missing so we made a patch to make sure this will not come empty. Please try it again and let us know if the problem persist.

    Regards,
    Widget Team

  • Profile Image
    taxi88test
    Answered on March 07, 2018 at 07:00 AM

    It appears the issue has finally been fixed. I will continue testing for any anomalies and report if I find anything.

    Thank you!

  • Profile Image
    TREVON
    Answered on March 07, 2018 at 08:53 AM

    Thank you for your response. W will appreciate any feedback incase you face an challenges.