table to table import too long

Question

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 LongHTTP Error 414. The request URL is too long.Any ideas ?thank you,-pete------------------------------Pete MacKenzie------------------------------

petemackenzie · Answer

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. &nbsp;Case closed....thanks all!!------------------------------Pete MacKenzie------------------------------

markshnier__you · Answer

Thats crazy.&nbsp; Are you calling the API from a formula URL button or running it manually?&nbsp; if you run it manually does it give the error?&nbsp; If a button, what is your button code?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

petemackenzie · Answer

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. &nbsp;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------------------------------

neilschneider · Answer

Pete,I remember having an issue with imports with a large number of records, at the time it was a restriction.&nbsp; I believe you'll need to break the import into multiple smaller imports.&nbsp; I'd suggest creating a support ticket to QB, but pretty sure that's the problem.Neil------------------------------Neil Schneider------------------------------

markshnier__you · Answer

I agree with Neil.&nbsp; That would be the next trouble shooting step, even though to me that is not a large import.&nbsp; 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

table to table import too long

Request URL Too Long
HTTP Error 414. The request URL is too long.

Any ideas ?

thank you,
-pete

Related Content

Merge Imports

Moving Fields from One Table to Another

Table is missing

How to relate two tables with the key to a third table?

Reference tables quandary