Hi,
which kind of calculation I need in order to import records from one
external file (*.tab) with 3 different record category:
"new" - should be added to my database
"change" - should to update record already exist
"delete" - should identify record ID and then delete it from my database

The original records it's looks like:

new,23,44,42,667,Peter,Rozen
new,24,44,32,667,Sarah,Setterfield
change,25,44,42,669,Sthephan,Lesler
delete,26,44,32,667,Sandra,Hoppkings

TIA

Shai


--

shai Ben Mordechai (Rosenblum) wrote:

It's not a calculation.

You need to map the import: create a script with the Import Records step
specifying new records and map the fields to be imported (click and drag
the elements in the dialog to match them with the destination field). Then
do the Import Records step again, this time specifying it at an update,
for which you will need to be able to specify a match field as you are
mapping.

For the deletion, you may want to import it as part of the update routine,
then find the updated record (by the word "delete"?) and delete it.

Matt

Matt Wills wrote:

I should mention that new records and those to be updated should be in
separate files, or FM will import all of them as new on the first go.

Matt

In article <o5dHe.13684$QX2.5451@trndny01>, "Matt Wills" <I'm (AT) Witz (DOT) end> wrote:


When you choose the "update matching records in current found set" option
during import mapping, a checkbox below it becomes ungrayed: "add
remaining records." (Please note, the is FM 6. If 7 has changed all
this, I'd be curious to know.)

By checking this, and careful field mapping & selection of match field,
the poster should be able to update thodse needing updating, then
automatically make newe records for all "new" in one operation.

If the poster makes a control text field that will map in the words "new",
"update" and "delete", then it would be simple for a script to find &
delete those needing deletion. The entire operation, new, update &
delete, could be reduced to a single button click.

Steve Brown