limit on import

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • Answered
I am trying to import  220 K rows of data but I got the following message.  I cut down to 100 K rows and I still get the message.  What is the limit?  

We cannot get the status of your upload at this time.  Please refresh the page. Error: Internal Error. 
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb

Posted 2 years ago

  • 1
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
The unknown (well at least to me) limit is based on the amount of data, not the number of rows.  So it will depend on the # of columns and the amount of data in each column (sort of the field width as to a lot or a little text).

I suggest that you cut the # of rows in half and try again and it will likely work unless you have a ginormous number of columns.

Basically its trial and error to see what amount of data it will take.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks Mark. I have on;y 18 columns.  Cut it down to 50 K and still getting error that file must be less than 5 mb.  File is 3 mb only.   So kind of stuck.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Do you think changing to CSV will make a difference?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
Hmmmm, I really don't know. Maybe.  Maybe a CSV file is smaller in size than the same data in Excel format,
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
It did work with CSV. I could transfer 220 K rows.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
Ok, good to know!!
Photo of Akhilesh

Akhilesh

  • 12 Points
Thank you Arshad Khwaja. This helped a lot !!
Photo of Logan Amster

Logan Amster

  • 90 Points 75 badge 2x thumb
I think the largest file size you can import is around 575KB. I uploaded a file of 575KB but a 600KB file was too large.