Newbies drichar Posted February 21, 2006 Newbies Posted February 21, 2006 So I came back from lunch today to find that my idiot of a parter had imported an excel file into 5 fields in our database. The problem is that he did it incorrectly and it replaced the 5 fields with the new data (which he meant to add to it) AND it also replaced some first name/last name things incorrectly! Of course our backup copy is more than a month old and would require HOURS and HOURS of re-entering the data to fix it on our own. Any help as to being able to recover a version that we saved this AM would be eternally grateful!
LaRetta Posted February 21, 2006 Posted February 21, 2006 (edited) I hope you are using a unique ID? If so, do this: Show All Records Import (UpDate Matching Records In Found Set] ... do NOT select Add remaining records. Match ID to ID and select 'Match Records Based on this field' Select ONLY the fields you need to replace for the import - the ones messed up Back up first in case you have a problem and have to re-do it. And repeat three times ... 'Never let Users import unless it's scripted and protected.' vs. 8 is wonderful because you can provide Users with ONLY fields to map to according to what is on a layout. In the 'old days' they had access to EVERY field including the unique ID. Now you can restrict what they see. But I STILL use an intermediate import table so I can control what happens. It is far too easy for them to map to incorrect fields. Usually, I script the import and lock them totally out. UPDATE: Old backup? Oh dear. Well, any changes to firstName, lastName since then will be lost unless you can isolate WHICH records were changed. LaRetta Edited February 21, 2006 by Guest Added UPDATE
Newbies drichar Posted February 21, 2006 Author Newbies Posted February 21, 2006 Thanks LaRetta!! One more question... How can I UNSELECT the auto save option that my idiot partner selected the first time he used FM? I want to be able to see the mistakes before it is automatically saved when we close it, etc.
Recommended Posts
This topic is 6869 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now