How to update database from a comma delimited file
I would like some help in writing a scipt that would update our filemaker pro database from a scanner file that is comma delimited. The scanner file contain date of the scanning transaction. I only want to update the database if the date of the transaction is later than the date in the database.
The database contains the following field: Date, Employee, Location, Part Number, Serial Number, Barcode.
The scanning file contains Date of transaction, Barcode, Location, Employee.
I want to update the database when the barcode matches but only if the date of transaction is later than the Date on the database. If the date is later than update the Data, Employee, Location in the database.
thank you for your time.