I am new to Version 7 and need some suggestions on importing records which might change weekly.

I have a .csv file that is created each week of employees.

I want to be able to import the file initially, and then each week import the new file again, and have it mark any missing records from the previous week as employees who have been released, and add any new records from new hires.

I would appreciate any suggestions on how to best handle this?

Thanks

Elliot

If you look at the import dialog of Fm7. (menu File : Import ), then you'll see there is an option for updating records.

So, the first time you import, there won't be any records updated, but if you have an index , like say a unique employee_id for each employee, which is always in the .csv, then when you import the next time, the record will be updated.

if your .csv has a field, say called, status, then you could read that in FM7 to perform some action. For example, you could write a script to delete all records which have a status of "quit".

hope that helps,

sincerely,

J__