table to table import too long
Hi All, Trying to import from sync'd table into local table using a table-to-table import. The source sync table has 68,000 records, and only about 24 fields.
Request URL Too Long HTTP Error 414....
Forum Discussion
Thats crazy. Are you calling the API from a formula URL button or running it manually? if you run it manually does it give the error? If a button, what is your button code?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Hi Mark,
New to the community here and was told by my coworker Ryan that you'd be the first to respond :-) !
We are manually hitting the import. We have been successful with many other sync'd table to table imports.
Just not sure why we're having difficulty with this one.
thanks much!
-pete
------------------------------
Pete MacKenzie
------------------------------
New to the community here and was told by my coworker Ryan that you'd be the first to respond :-) !
We are manually hitting the import. We have been successful with many other sync'd table to table imports.
Just not sure why we're having difficulty with this one.
thanks much!
-pete
------------------------------
Pete MacKenzie
------------------------------
- Pete,
I remember having an issue with imports with a large number of records, at the time it was a restriction. I believe you'll need to break the import into multiple smaller imports. I'd suggest creating a support ticket to QB, but pretty sure that's the problem.
Neil
------------------------------
Neil Schneider
------------------------------- All right, got 'em all now....was an issue of in correctly specific one of the fields as unique....when it wasn't. This wasn't showing the correct error until I limited the import to just the last weeks of data. Case closed....thanks all!!
------------------------------
Pete MacKenzie
------------------------------ - I agree with Neil. That would be the next trouble shooting step, even though to me that is not a large import. One way to split the table is even / odd on Record ID#.
IF(REM([Record ID#],2)=1, "Odd","Even")
If that does not solve the problem, I'm wondering if you have any fields with obscenely large amounts on data in then, like a huge amount of text in some record's text field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
