AnsweredAssumed Answered

How to update database from a comma delimited file

Question asked by tran25 on Jul 14, 2009
Latest reply on Jul 15, 2009 by tran25

Title

How to update database from a comma delimited file

Post

Hi,

 

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.

 

For example:

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.

 

 

Outcomes