system fields lastclick_date and lastopen_date are empty

[e.mail.guru]

With several tests and openings (Outlook data downloaded) the fields lastclick_date and lastopen_date remain empty. Why does openemm not write any information in these fields? I am using version 20.10.000.107. Thanks for the answer.

[mdoerschmidt]

Writing the last open and last click date is disabled by default.

To enable it, execute this SQL statement on your database:
INSERT INTO config_tbl (class, name, value) VALUES ('measure', 'writecustomeropenorclickfield', 'true');

After inseting this configuration key, you either have to wait 5 minutes or restart your OpenEMM.

[e.mail.guru]

Thanks for the answer. It works. Nearly.

If you click after opening, the value in the lastopen_date field is overwritten. The values ​​are then identical (lastopen_date = lastclick_date).

A mistake or intent?

[maschoff]

You may activate the writing of these fields with

Code: Select all

INSERT INTO company_info_tbl (company_id, cname, cvalue) VALUES (0, 'measure.writecustomeropenorclickfield', 'true')

But be aware that this costs some database performance.