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

  • Profile Image
    CoachingConfirm
    Asked on November 14, 2018 at 01: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??

  • Profile Image
    Jim_R
    Answered on November 14, 2018 at 04: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

  • Profile Image
    CoachingConfirm
    Answered on November 15, 2018 at 09: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
    ...
  • Profile Image
    liyam
    Answered 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.


  • Profile Image
    CoachingConfirm
    Answered on November 15, 2018 at 01: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
    ...
  • Profile Image
    CoachingConfirm
    Answered on November 15, 2018 at 01:43 PM
    Here is another screen shoot from the data pull [cid:image003.png@01D47CE2.258DCC50]
    ...
  • Profile Image
    jonathan
    Answered on November 15, 2018 at 03: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

    ---

    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.48.32.png

    1542315090zzz 2018-11-16 04.47.57.png