Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
You cannot add or delete records manually on a connected table.
So your choices are to either change the source table (if that is possible) and delete them there or to adjust the filter. For example, if you change the filter to match the source records exactly, and filter the old records out, then the old records should delete. In the next refresh.
So your choices are to either change the source table (if that is possible) and delete them there or to adjust the filter. For example, if you change the filter to match the source records exactly, and filter the old records out, then the old records should delete. In the next refresh.
- BobJordan8 years agoQrew CadetHmm, ok so a little extra work may be needed here.
My understanding is that QB sync operations are limited to ~25MB files though correct? If I re-compile all the data I need manually into a single csv, it comes out to ~40MB.
So I suppose what I could do is:
1. split the csv into 2 files
2. sync the first file with the "add, update, and remove" setting selected in order to match the csv exactly
3. sync the second file with the "add, update, but do not remove" setting selected
Can you see any problems arising with that approach? I really don't want to mess anything up in the database and wiping all the newer records makes me a bit nervous.
Thanks for the reply! - QuickBaseCoachD8 years agoQrew CaptainYou may be perfectly correct, but let me ask some questions. I'm not aware of a 25 MB limit for Sync files. Do you recall why you think that?
If you split the file in half, why is it that you would set the Sync settings differently for the 2nd half - your Step 3. - BobJordan8 years agoQrew CadetWell I noticed some special conditions discussed for 25MB files here: http://www.quickbase.com/downloads/sync/QuickBase_Sync_for_Cloud_Apps.pdf
Additionally in my own use of it, I noticed that I kept getting substantially more errors in the sync operation as the file size was closer to 25MB (operation time out errors and spools failing).
For the file split, my thought of changing the settings is so that the table in QB retains all the data. Meaning that the first half of the import would basically wipe the DB and make it match that first half of the CSV while the second half would simply append to it on the table without removing anything (essentially re-combining the file prior to the split).
If you believe the split may not even be necessary though, then that might save some work. - QuickBaseCoachD8 years agoQrew CaptainI have no particular expertise on that 25 MB on that limit, so you may be correct!
- BobJordan8 years agoQrew CadetThanks for the help!