Is there a current problem with importing data?

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

I'm trying to import large amounts of data into a specific table and I continue to get an error stating: "some record IDs specified were not found in the table".

If I manually add a new record, the fields that get edited are the same fields that I am trying to import into to. I can't figure out what is the problem.

Please advise, thank you!

Photo of NP

NP

  • 10 Points

Posted 5 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
Are you attempting to edit existing record or add new records?  if you are attempting to edit existing records, and the [Record ID#] field is still the Key field to the table, then then records with each of those [Record ID#]'s must exist.
Photo of NP

NP

  • 10 Points
I am attempting to add new records.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
If you are adding new records, then you may not attempt to populate the [Record ID#] field.  That field auto increments up from 1 up to basically infinity as you create new records.
Photo of NP

NP

  • 10 Points
I am not inputting anything into the [Record ID#] field but I am including Record IDs to related fields, such as [Related Contract]
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
Hmmm, you will need to put in a support ticket then, if you are really sure that you are not importing into the [Record ID#] field.  My only other thought is that the field [Related Contact] is set to be a required field in Field properties, but some of your imported data is not including a value for that field in some records.  But that "cause" would not seem to match the error message that you are getting, so its more of a faint hope to look at before you go to Support.
Photo of NP

NP

  • 10 Points
Thank you.