Email-Collector Variables

Using my Dolibarr CRM/SRM Modules
1

Good evening!

Does anyone know what variables the email-collector supports?

I want to create leads AND contacts from emails.
In the text of the lead mail is a table:

  • First name
  • Surname
  • Mail
  • phone
  • ZIP
  • messages
  • GDPR

A lead is automatically created (works fine), but I want dolibarr automatically create a contact with the Data, too (first name, last name, mail and phone).

Does anybody have an idea how this works?

Best regards,
Mike

(using dolibarr 18.0.0, php 8.1.x, Mails in html-style from typo3 cms)

2

I’m using this Variables:
tmp_from=EXTRACT:HEADER:^From:(.);
tmp_subject=EXTRACT:HEADER:^Subject:(.);
usage_opportunity=SET:1;
socid=SETIFEMPTY:1;
description=EXTRACT:BODY:(.*);
title=SET:tmp_subject from tmp_from by Mail

Formaly it woked several times but now I get the following error advice:

Failed to create project: Cannot add or update a child row: a foreign key constraint fails (d03dad2f.llx_projet, CONSTRAINT fk_projet_fk_soc FOREIGN KEY (fk_soc) REFERENCES llx_societe (rowid))