Update by import/export

[CommiC]

Trying to make my idea work but still don't succeed in it, allthough I've posted a similar question before.

- I have a FM database that will be distributed to users as an executable.

- Every record has 20 fields.

- The first 10 fields will be edited by me.

- New records will be added by me.

- The second 10 fields of every record wil be edited by the user with data that only concirns him.

After I have edited records (the first 10 fields of every) or add new records (with the last 10 fields empty) to the database, I want to sent the users an update.

The user must be able to import the (changed) first 10 fields of every record that is already in his version of the database AND the newly created records that I added (wich will result in 10 empty fields in each record).

I have tryed to do this with import/export (as *.WK1 file) of selected fields, but that does not seem to work because the last 10 fields of every changed record are overwriten with empty fields at the user end.

Thinking of the use of a portal but wonder if that will work with a executable.

Anyone a suggestions?

Thanks,

John

[kenneth2k1]

Hi:

The user can run an update script that has an import function. This import script should use a match field and select update current records. Once you run the import manually, create the import script with restore.

If this is a solution that has already been distributed, you might want to look into Update Genie. It looks like it is the easiest to use for the end user. I can't remember the link, maybe just do a search for Update Genie.

Ken

[CommiC]

The match field did the trick. Seems to work fine now, thanks

The Update Genie is more a software version update application. DOn't know if it would work with data too. Can be found at:

http://hi-voltage.com.au/updategenie.php

Thanks Ken