Importing a csv file. Matching records and updating fields.

Importing a csv file. Matching records and updating fields.

Hi,

I have a 'Contacts' Form in Creator from which I export the following CSV file to email marketing software.

Export File:      ID,Title,Name,Email

It returns a report after the marketing is done in the form, Email,Date,Status as below.

example1@gmail.co.uk

2012-12-17 22:47:00

Email opened

example2@tiscali.co.uk

2012-12-17 23:47:07

Email opened

example3@btinternet.com

2012-12-18 21:18:26

Email opened

example4@btinternet.com

2012-12-19 12:06:50

Email opened

example4@btinternet.com

2012-12-19 15:34:21

Email opened


I would like to import this information back to Creator, run through the file matching the contact for each row and incrementing a field for the number of times opened



Can you point me in the direction of a help file or a block of code that could handle this import.

Thank you,