Discussions

Expand all | Collapse all

Anybody have any ideas on how to import data into a synced table?

  • 1.  Anybody have any ideas on how to import data into a synced table?

    Posted 04-17-2019 21:04
    We are bringing basic info from one app into this one, but we have additional detail workflow that we need to import into the synced table.  It appears that both import/export and pasting into a grid edit report do not work.  Any ideas?


  • 2.  RE: Anybody have any ideas on how to import data into a synced table?

     
    Posted 04-17-2019 21:13
    I've created a spreadsheet with the new additional data (with the key field), then saved as a CSV and dumped in my Google Drive sync folder. QB will grab all csv files for importing. This assumes you're sync settings are for 'add and update'. Does this help?


  • 3.  RE: Anybody have any ideas on how to import data into a synced table?

    Posted 04-18-2019 00:31
    I don't think so--this is a QB to QB sync.  You can't change the sync type, right?


  • 4.  RE: Anybody have any ideas on how to import data into a synced table?

    Posted 04-18-2019 00:34
    QB to QB Sync means that the source of truth is the original Sync source QB table.  So the only place to add record is at the source.