Discussions

Expand all | Collapse all

table to table import too long

  • 1.  table to table import too long

    Posted 10 days ago
    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. The request URL is too long.

    Any ideas ?

    thank you,
    -pete



    ------------------------------
    Pete MacKenzie
    ------------------------------


  • 2.  RE: table to table import too long

    Posted 10 days ago
    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
    ------------------------------



  • 3.  RE: table to table import too long

    Posted 10 days ago
    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
    ------------------------------



  • 4.  RE: table to table import too long

    Posted 10 days ago
    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
    ------------------------------



  • 5.  RE: table to table import too long

    Posted 10 days ago
    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
    ------------------------------



  • 6.  RE: table to table import too long

    Posted 10 days ago
    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
    ------------------------------