Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6869 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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!

Posted (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.' :wink2:

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 by Guest
Added UPDATE
  • Newbies
Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.