Problems importing a Box.com dataset with non-unique IDs...is there a way to do a complete refresh of the data set, meaning delete existing data and completely overwrite?

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

I've got a .csv file in Box.com that contains tons of information that I want to make dashboards and pivots and reports from. However, it does not contain a unique field that can act as a key field to act as a refresh field.

I can't create a unique field because the only thing that would differ between two lines would be a shipment date, which will vary by daily report.

Is there a way to force a complete refresh of the data or use a native Record ID# to prevent overwriting and just let the reports do their magic without the key field?

Thanks very much

Photo of Larbi

Larbi

  • 20 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ryan KJ

Ryan KJ

  • 0 Points
From my experience with Quickbase Sync for CSV, the CSV file does need to originate the key field (s).  That is the only way that the data will be able to link to existing data.  Would you be able to pull multiple fields together to make a unique key?

If you have the newest CSV file overwrite exist data, one way I have cleared out the table is by making a CSV with column headers and no data.  Then when I sync the integration it syncs it to have no records.  Then I make the changes I want to, and re-sync the full data set.
Photo of Larbi

Larbi

  • 20 Points
Thanks, Ryan. It's a brute force method that I'd prefer not to do, but I appreciate that it gets the job done. For automated syncing, it slows things down a bit. You'd need to somehow schedule alternating pushes to your data source (say, Box.com) where it first pushed a blank, waits for the QB sync, then pushes the replacement 'real' data, wait for sync, etc. Or....manual.