For some reason when I am pulling any information from this site it is only showing the last 5000 entries

  • CoachingConfirm
    Asked on November 14, 2018 at 1:55 PM

    Good Afternoon,

     

    For some reason when i am pulling any information from this site it is only showing my the last 5000 entries - how can i expand this for my entire portfolio??

  • Support_Management Jotform Support
    Replied on November 14, 2018 at 4:15 PM

    Hello @CoachingConfirm - Can you be more specific on what you're doing when you said, "when i am pulling any information from this site"?

    Which information are you pulling? From where were you fetching these info? Are you referring to your submission data? Are you exporting them in CSV or XLS format? If you were trying to export your submission data to Excel, you will indeed be downloading multiple Excel files with 5000 submissions each (if you have more than 5k submissions in total for that form).

    I have a feeling you're talking about the Excel download from the Submissions Page but to be sure, please provide us more info on what you're doing and what happens from your end. A screenshot of it will surely come in handy so kindly share one if possible.

    Related guide: How-to-Post-Screenshots-to-Our-Support-Forum

  • CoachingConfirm
    Replied on November 15, 2018 at 9:43 AM
    How would I go about adding it twice – I just have a couple reports build that manually pull all the data and responses from this site but it is erroring out at like 5000 I am using Excel to run these reports.
    The below is where I am pulling it from
    [cid:image001.png@01D47CC3.4882DDF0]
    Thanks
    ...
  • liyam
    Replied on November 15, 2018 at 12:12 PM

    After making tests, I was not able to replicate the issue that you have explained. I suppose what happened was a glitch or at that time, there was high traffic in the system which may have resulted to timing out and errors such as one you have experienced. Can you please try again and let us know if the problem persists?

    You may also try downloading the Excel submissions via the submissions page. You may check this guide for further information: https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

    Thanks.


  • CoachingConfirm
    Replied on November 15, 2018 at 1:43 PM
    Good Afternoon,
    The data is only loading until like 5000
    [cid:image001.png@01D47CE1.451AB110]
    [cid:image002.png@01D47CE1.451AB110]
    Every day I seem to be losing more entries
    ...
  • CoachingConfirm
    Replied on November 15, 2018 at 1:43 PM
    Here is another screen shoot from the data pull [cid:image003.png@01D47CE2.258DCC50]
    ...
  • jonathan
    Replied on November 15, 2018 at 3:53 PM

    Were not able to see the screenshot image you have provided. Please upload it again when you reply on this thread https://www.jotform.com/answers/1643247

    For some reason when I am pulling any information from this site it is only showing the last 5000 entries Image 1 Screenshot 20

    ---

    I did test also on your form but I could not reproduce the issue you described. I downloaded the submission data of the form in the View Submission page https://www.jotform.com/submissions/60914549157260

    All data were downloaded in one Excel file.

    1542315075zzz 2018 11 16 04 Screenshot 31

    1542315090zzz 2018 11 16 04 Screenshot 42