Page 1 of 1
system fields lastclick_date and lastopen_date are empty
Posted: Thu Jan 28, 2021 8:59 pm
by 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.
Re: system fields lastclick_date and lastopen_date are empty
Posted: Fri Jan 29, 2021 12:00 pm
by 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.
Re: system fields lastclick_date and lastopen_date are empty
Posted: Fri Jan 29, 2021 7:14 pm
by 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?
Re: system fields lastclick_date and lastopen_date are empty
Posted: Fri Jan 29, 2021 7:28 pm
by 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.