Forum Discussion

MarkGlevicky's avatar
MarkGlevicky
Qrew Cadet
7 years ago

300 Emails (records) accidently deleted. Can't cut/paste from new table created from backup csv

I have a backup csv of our table.  Thought I could import the backup into a new table and just cut/paste into existing table.  Of course, no go. Why can't you do this between tables in grid edit?  Asi...
Tables and fields
EvanMartinez's avatar
EvanMartinez
Moderator
7 years ago
Hi Mark,

If you have all those records in another table with the correct values and fields if you open up a report in that table that has all the records you want to copy over (for example the List All report) and you have all the fields set up that you want to bring over there is an option in the More dropdown to 'copy these records to another table'. This will allow you to trigger an import from this table into your original table with just those records and let you chose which fields match up between the two tables. This way you can set up copying those records over all at once and make sure every field lines up where you want it to import into.



I hope this suggestion is helpful.

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    :) I beat you by 1 minute ....
  • EvanMartinez's avatar
    EvanMartinez
    Moderator
    7 years ago
    Haha that you did, not surprising given how active you are
  • MarkGlevicky's avatar
    MarkGlevicky
    Qrew Cadet
    7 years ago
    Thank you all.  :)  -Mark
  • MarkGlevicky's avatar
    MarkGlevicky
    Qrew Cadet
    7 years ago
    Ok, now a follow on to what happened above.  The "mass deletion" of certain records happened again!  I've found that it's related to import/export work we're doing and it's weird.  Here's the story...

    This issue is kind of hard to explain, but will do my best.  We have a report that filters to only certain columns.  In simple terms, lets say the columns in the main table are A B C D E F G H.  The columns we filter for the record (to display) are A B F G H, leaving out C D E.  The record ID is included as a key for re-import later.  

    So.... we modify the fields in the report as needed, then import this data back into the main table.  The process shows that all columns are correctly match up and "green", so the import is done.  Now however, the main table now shows all blanks or empty values in columns C D E!  This, even though these columns were never exported, and therefore were never modified or touched.

    I also should note that there are other columns the are filtered out or even switched in display order in this report that are further to the right in the main table, but everything in this region seems to be unaffected on the main table after this import.  I'm totally baffled.  Any ideas?

    Thx,
    Mark
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    What you are doing seems correct. I suggest that you run a controlled test on some test Record IDs to see if you duplicate the results.

    If you can�t duplicate the results then it suggests that someone did import blanks into those columns.
  • MarkGlevicky's avatar
    MarkGlevicky
    Qrew Cadet
    7 years ago
    I ended up just including columns C D E in the report that we export, even though they are not needed for our updates.  After doing this, the tests I ran showed those columns to be coming back in during import, unchanged as expected...and not blank!  

    I don't have time to run this to the ground, but I have a feeling that if you don't include a column or columns in the -middle- of the report, this happens, either sporatically or every time.  Again, not sure, but it happened twice for us.

    I'll be back if it happens again!  Thx for help.  Mark