Hello {leadfield=customfield}

[ptcc]

This is very similar to #370, but what I need is to use a custom field i added instead of firstname.
I tried sending an email with subject: "{leadfield=mycustomfield} {leadfield=company}" company is replaced correctly, but mycustomfield is not replaced... the entire "{leadfield=mycustomfield}" placeholder appears in the inbox...

[alanhartless]

Hi @ptcc,

What version of Mautic are you using? 1.1.3 released over the weekend should have resolved that.

Thanks,
Alan

[ptcc]

I am using 1.1.3

[alanhartless]

Hi @ptcc,

I tried to reproduce this and have been unsuccessful. I must be missing a piece of the puzzle.

I created a custom lead field (with an alias of test). I then used that lead field in the subject (and body) ({leadfield=test} {leadfield=company}) of an email. Populated some leads and sent the email to those leads directly, via a campaign and via a batch list send. In all three cases, the tokens were appropriately replaced.

Can you verify that your "mycustomfield" equivalent is the actual alias of your custom field?

Thanks!
Alan

[ptcc]

Hi... I'm going to further investigate... I think something went wrong with my version upgrade.

[ptcc]

something is wrong with my instalation... do you have any idea what might cause this rendering of mautic main layout?

[alanhartless]

Can you make a dump of your notifications table from the database, post it here then truncate that table to see if it resolves the issue?

[alanhartless]

Also, what locale are you using for the language?

[ptcc]

INSERT INTO `notifications` (`id`, `user_id`, `type`, `header`, `message`, `date_added`, `icon_class`, `is_read`)
VALUES
    (1,1,NULL,NULL,'Configuration successfully updated','2015-07-09 18:41:37','fa-info-circle',1),
    (2,1,NULL,NULL,'Configuration successfully updated','2015-07-09 18:49:00','fa-info-circle',1),
    (3,1,NULL,NULL,'4 addons were added, 0 updated, and 0 disabled.','2015-07-09 18:49:19','fa-info-circle',1),
    (4,1,NULL,NULL,'CRM must be enabled to view associated integrations.','2015-07-09 18:49:25','text-danger fa-exclamation-circle',1),
    (5,1,NULL,NULL,'Email Marketing must be enabled to view associated integrations.','2015-07-09 18:49:35','text-danger fa-exclamation-circle',1),
    (6,1,NULL,NULL,'<a href=\'/s/leads/lists/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadlist_index\'><strong>teste (teste)</strong></a> has been created!','2015-07-09 19:01:04','fa-info-circle',1),
    (7,1,NULL,NULL,'<a href=\'/s/emails/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>teste</strong></a> has been created!','2015-07-09 19:01:27','fa-info-circle',1),
    (8,1,NULL,NULL,'A test email has been sent to your email.','2015-07-09 19:01:33','fa-info-circle',1),
    (9,1,NULL,NULL,'<a href=\'/s/leads/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_lead_index\'><strong>Tiago Coelho</strong></a> has been created!','2015-07-09 19:02:23','fa-info-circle',1),
    (10,1,NULL,NULL,'<a href=\'/s/leads/lists/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadlist_index\'><strong>teste (teste)</strong></a> has been updated!','2015-07-09 19:03:17','fa-info-circle',1),
    (11,1,NULL,NULL,'1 lists have been deleted!','2015-07-09 19:03:25','fa-info-circle',1),
    (12,1,NULL,NULL,'<a href=\'/s/leads/lists/edit/2\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadlist_index\'><strong>teste (teste)</strong></a> has been created!','2015-07-09 19:03:39','fa-info-circle',1),
    (13,1,NULL,NULL,'&quot;olá {firstname}, {leadfield=firstname}&quot; sent to XXXXXX@gmail.com','2015-07-09 19:04:37','fa-info-circle',1),
    (14,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/23\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>estado</strong></a> has been created!','2015-07-10 09:04:07','fa-info-circle',1),
    (15,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/23\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>estado</strong></a> has been updated!','2015-07-10 09:04:36','fa-info-circle',1),
    (16,1,NULL,NULL,'<a href=\'/s/emails/edit/2\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>Email 1 - Chamariz</strong></a> has been created!','2015-07-10 10:06:04','fa-info-circle',1),
    (17,1,NULL,NULL,'2 emails have been deleted!','2015-07-10 10:15:41','fa-info-circle',1),
    (18,1,NULL,NULL,'<a href=\'/s/leads/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_lead_index\'><strong>Tiago Coelho</strong></a> has been updated!','2015-07-10 10:21:09','fa-info-circle',1),
    (19,1,NULL,NULL,'<a href=\'/s/emails/edit/3\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>Email</strong></a> has been created!','2015-07-10 10:23:30','fa-info-circle',1),
    (20,1,NULL,NULL,'4 leads have been deleted!','2015-07-10 12:09:23','fa-info-circle',1),
    (21,1,NULL,NULL,'<a href=\'/s/emails/edit/4\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>problema</strong></a> has been created!','2015-07-10 12:32:11','fa-info-circle',1),
    (22,1,NULL,NULL,'<a href=\'/s/emails/edit/5\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>problema</strong></a> has been updated!','2015-07-10 12:40:45','text-warning fa-exclamation-triangle',1),
    (23,1,NULL,NULL,'4 leads have been deleted!','2015-07-10 15:51:55','fa-info-circle',1),
    (24,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/6\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>Email</strong></a> has been updated!','2015-07-11 16:31:22','fa-info-circle',1),
    (25,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/24\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>cae</strong></a> has been created!','2015-07-11 17:04:53','fa-info-circle',1),
    (26,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/2\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>First Name</strong></a> has been updated!','2015-07-11 17:05:23','fa-info-circle',1),
    (27,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/3\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>Last Name</strong></a> has been updated!','2015-07-11 17:05:36','fa-info-circle',1),
    (28,1,NULL,NULL,'1 leads have been deleted!','2015-07-11 17:50:47','fa-info-circle',1),
    (29,1,NULL,NULL,'<a href=\'/s/leads/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_lead_index\'><strong>Tiago Coelho</strong></a> has been updated!','2015-07-11 17:51:23','fa-info-circle',1),
    (30,1,NULL,NULL,'1 lists have been deleted!','2015-07-11 17:51:35','fa-info-circle',1),
    (31,1,NULL,NULL,'<a href=\'/s/leads/lists/edit/3\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadlist_index\'><strong>teste1 (teste1)</strong></a> has been created!','2015-07-11 17:52:00','fa-info-circle',1),
    (32,1,NULL,NULL,'<a href=\'/s/emails/edit/6\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>email de pesca</strong></a> has been created!','2015-07-11 17:58:13','fa-info-circle',1),
    (33,1,NULL,NULL,'<a href=\'/s/emails/edit/7\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>puxa por ele</strong></a> has been created!','2015-07-11 18:02:23','fa-info-circle',1),
    (34,1,NULL,NULL,'<a href=\'/s/campaigns/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_campaign_index\'><strong>Teste1</strong></a> has been created!','2015-07-11 18:06:42','fa-info-circle',1),
    (35,1,NULL,NULL,'<a href=\'/s/campaigns/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_campaign_index\'><strong>Teste1</strong></a> has been updated!','2015-07-11 18:07:14','fa-info-circle',1),
    (36,1,NULL,NULL,'<a href=\'/s/leads/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_lead_index\'><strong>Tiago Coelho</strong></a> has been updated!','2015-07-11 18:08:18','fa-info-circle',1),
    (37,1,NULL,NULL,'CRM must be enabled to view associated integrations.','2015-07-13 14:05:06','text-danger fa-exclamation-circle',1),
    (38,1,NULL,NULL,'2 emails have been deleted!','2015-07-13 15:34:40','fa-info-circle',1),
    (39,1,NULL,NULL,'<a href=\'/s/emails/edit/8\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>email capta empresas</strong></a> has been created!','2015-07-17 10:09:44','fa-info-circle',1),
    (40,1,NULL,NULL,'<a href=\'/s/emails/edit/8\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>email capta empresas</strong></a> has been updated!','2015-07-17 10:11:05','text-warning fa-exclamation-triangle',1),
    (41,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/25\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>serviço</strong></a> has been created!','2015-07-17 16:04:21','fa-info-circle',1),
    (42,1,NULL,NULL,'<a href=\'/s/emails/edit/8\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>email capta empresas</strong></a> has been updated!','2015-07-20 09:32:00','text-warning fa-exclamation-triangle',1),
    (43,1,NULL,NULL,'<strong>email capta empresas</strong> has been deleted!','2015-07-20 09:33:01','fa-info-circle',1),
    (44,1,NULL,NULL,'<a href=\'/s/emails/edit/9\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>teste td vazios</strong></a> has been created!','2015-07-20 15:36:38','fa-info-circle',1),
    (45,1,NULL,NULL,'4 emails have been deleted!','2015-07-20 21:40:06','fa-info-circle',1),
    (46,1,NULL,NULL,'1 campaigns have been deleted!','2015-07-20 21:40:20','fa-info-circle',1),
    (47,1,NULL,NULL,'<strong>Profissionais</strong> has been created!','2015-07-20 21:41:42','fa-info-circle',1),
    (48,1,NULL,NULL,'<strong>Profissionais</strong> has been updated!','2015-07-20 21:41:50','fa-info-circle',1),
    (49,1,NULL,NULL,'<strong>Profissionais</strong> has been updated!','2015-07-20 21:41:53','fa-info-circle',1),
    (50,1,NULL,NULL,'<strong>Prestadores</strong> has been created!','2015-07-20 21:42:26','fa-info-circle',1),
    (51,1,NULL,NULL,'1 categories have been deleted!','2015-07-20 21:42:55','fa-info-circle',1),
    (52,1,NULL,NULL,'<strong>Clientes</strong> has been created!','2015-07-20 21:43:26','fa-info-circle',1),
    (53,1,NULL,NULL,'<a href=\'/s/emails/edit/10\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>1. chamariz by cae</strong></a> has been created!','2015-07-20 22:09:43','fa-info-circle',1),
    (54,1,NULL,NULL,'No email with an id of {leadfield=websiteimage} was found!','2015-07-20 22:25:08','text-danger fa-exclamation-circle',1),
    (55,1,NULL,NULL,'No email with an id of {leadfield=service2image} was found!','2015-07-20 22:25:09','text-danger fa-exclamation-circle',1),
    (56,1,NULL,NULL,'No email with an id of {leadfield=service3_image} was found!','2015-07-20 22:25:10','text-danger fa-exclamation-circle',1),
    (57,1,NULL,NULL,'No email with an id of {leadfield=service1image} was found!','2015-07-20 22:25:10','text-danger fa-exclamation-circle',1),
    (58,1,NULL,NULL,'<a href=\'/s/emails/edit/10\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>1. chamariz by cae</strong></a> has been updated!','2015-07-20 22:26:01','text-warning fa-exclamation-triangle',1),
    (59,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/26\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>subject por CAE</strong></a> has been created!','2015-07-20 22:27:29','fa-info-circle',1),
    (60,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/27\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>website example image</strong></a> has been created!','2015-07-20 22:30:51','fa-info-circle',1),
    (61,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/28\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>website example image owner profileid</strong></a> has been created!','2015-07-20 22:32:18','fa-info-circle',1),
    (62,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/29\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service1 for email1</strong></a> has been created!','2015-07-20 22:32:51','fa-info-circle',1),
    (63,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/30\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service1 for email1 title</strong></a> has been created!','2015-07-20 22:33:22','fa-info-circle',1),
    (64,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/31\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service1 for email1 teaser</strong></a> has been created!','2015-07-20 22:33:43','fa-info-circle',1),
    (65,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/32\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service1image_owner</strong></a> has been created!','2015-07-20 22:34:02','fa-info-circle',1),
    (66,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/33\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service1image</strong></a> has been created!','2015-07-20 22:34:18','fa-info-circle',1),
    (67,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/34\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service2</strong></a> has been created!','2015-07-20 22:34:34','fa-info-circle',1),
    (68,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/35\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service2_title</strong></a> has been created!','2015-07-20 22:34:44','fa-info-circle',1),
    (69,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/36\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service2_teaser</strong></a> has been created!','2015-07-20 22:34:53','fa-info-circle',1),
    (70,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/37\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service2image_owner</strong></a> has been created!','2015-07-20 22:35:03','fa-info-circle',1),
    (71,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/38\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service2image</strong></a> has been created!','2015-07-20 22:35:14','fa-info-circle',1),
    (72,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/39\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service3</strong></a> has been created!','2015-07-20 22:35:24','fa-info-circle',1),
    (73,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/40\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service3_title</strong></a> has been created!','2015-07-20 22:35:33','fa-info-circle',1),
    (74,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/41\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service3_teaser</strong></a> has been created!','2015-07-20 22:35:45','fa-info-circle',1),
    (75,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/42\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service3image_owner</strong></a> has been created!','2015-07-20 22:35:55','fa-info-circle',1),
    (76,1,NULL,NULL,'<a href=\'/s/leads/fields/edit/43\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadfield_index\'><strong>service3image</strong></a> has been created!','2015-07-20 22:36:07','fa-info-circle',1),
    (77,1,NULL,NULL,'<a href=\'/s/leads/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_lead_index\'><strong>Tiago Coelho</strong></a> has been updated!','2015-07-20 22:41:39','fa-info-circle',1),
    (78,1,NULL,NULL,'<a href=\'/s/leads/lists/edit/3\' data-toggle=\'ajax\' data-menu-link=\'mautic_leadlist_index\'><strong>teste1 (teste1)</strong></a> has been updated!','2015-07-20 22:42:35','fa-info-circle',1),
    (79,1,NULL,NULL,'<a href=\'/s/campaigns/edit/2\' data-toggle=\'ajax\' data-menu-link=\'mautic_campaign_index\'><strong>campanha por CAE para Portugal</strong></a> has been created!','2015-07-20 22:45:46','fa-info-circle',1),
    (80,1,NULL,NULL,'No email with an id of <strong contenteditable= was found!','2015-07-20 23:02:01','text-danger fa-exclamation-circle',1),
    (81,1,NULL,NULL,'No email with an id of {leadfield=service3_image} was found!','2015-07-20 23:02:02','text-danger fa-exclamation-circle',1),
    (82,1,NULL,NULL,'<a href=\'/s/emails/edit/10\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>1. chamariz by cae</strong></a> has been updated!','2015-07-20 23:02:42','text-warning fa-exclamation-triangle',1),
    (83,1,NULL,NULL,'&quot;{leadfield=caesubject}&quot; sent to XXX@XXXX.com','2015-07-20 23:27:15','fa-info-circle',1),
    (84,1,NULL,NULL,'<a href=\'/s/leads/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_lead_index\'><strong>Tiago Coelho</strong></a> has been updated!','2015-07-21 11:50:47','fa-info-circle',1),
    (85,1,NULL,NULL,'<strong>Tiago Coelho</strong> has been deleted!','2015-07-21 12:02:24','fa-info-circle',1),
    (86,1,NULL,NULL,'<a href=\'/s/leads/edit/1024\' data-toggle=\'ajax\' data-menu-link=\'mautic_lead_index\'><strong>Tiago Coelho</strong></a> has been created!','2015-07-21 12:06:33','fa-info-circle',1),
    (87,1,NULL,NULL,'No email with an id of <strong contenteditable= was found!','2015-07-21 13:48:27','text-danger fa-exclamation-circle',1),
    (88,1,NULL,NULL,'No email with an id of {leadfield=service3_image} was found!','2015-07-21 13:48:28','text-danger fa-exclamation-circle',1),
    (89,1,NULL,NULL,'No email with an id of {leadfield=websiteimage} was found!','2015-07-21 13:50:09','text-danger fa-exclamation-circle',1),
    (90,1,NULL,NULL,'No email with an id of {leadfield=service1image} was found!','2015-07-21 13:50:10','text-danger fa-exclamation-circle',1),
    (91,1,NULL,NULL,'No email with an id of {leadfield=service2image} was found!','2015-07-21 13:50:10','text-danger fa-exclamation-circle',1),
    (92,1,NULL,NULL,'No email with an id of {leadfield=service3_image} was found!','2015-07-21 13:50:12','text-danger fa-exclamation-circle',1),
    (93,1,NULL,NULL,'<a href=\'/s/emails/edit/10\' data-toggle=\'ajax\' data-menu-link=\'mautic_email_index\'><strong>1. chamariz by cae</strong></a> has been updated!','2015-07-21 13:50:56','text-warning fa-exclamation-triangle',1),
    (94,1,NULL,NULL,'<a href=\'/s/pages/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_page_index\'><strong>5 dicas para aumentar imediatamente o volume de negócios</strong></a> has been created!','2015-07-22 17:12:11','fa-info-circle',1),
    (95,1,NULL,NULL,'<a href=\'/s/pages/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_page_index\'><strong>5 dicas para aumentar imediatamente o volume de negócios</strong></a> has been updated!','2015-07-22 17:17:10','fa-info-circle',1),
    (96,1,NULL,NULL,'<a href=\'/s/forms/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_form_index\'><strong>Captura de emails com ebooks</strong></a> has been created!','2015-07-22 17:24:37','fa-info-circle',1),
    (97,1,NULL,NULL,'<a href=\'/s/pages/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_page_index\'><strong>5 dicas para aumentar imediatamente o volume de negócios</strong></a> has been updated!','2015-07-22 17:26:14','fa-info-circle',1),
    (98,1,NULL,NULL,'<a href=\'/s/pages/edit/1\' data-toggle=\'ajax\' data-menu-link=\'mautic_page_index\'><strong>5 dicas para aumentar imediatamente o volume de negócios</strong></a> has been updated!','2015-07-22 17:27:13','fa-info-circle',1);

truncating those weird entries did resolve the issue, but new similar entries are created again

[ptcc]

locale: English US

[alanhartless]

Can you think of where you encountered the "email with an id of...was not found" error? That's the cause of it but I can't find the reason for it.

[alanhartless]

(the reason for the broken HTML included in that message) It seems that it's appending it to the URL which obviously isn't right.

[alanhartless]

One more question ;) Are you using the {leadfield} tokens in URLs?

[ptcc]

I managed to find the root cause for the field not being replaced.
It has nothing to do with being custom...
If the field does not appear in the email body, then it is not replaced in the subject.
If it appears in the body, then it is correctly replaced.

[ptcc]

yes, i am using {leadfield} in urls... for links and for images

[alanhartless]

Okay; I think that's the problem for that. There's a catch to prevent the editor from converting tokens that leverage visual placeholders, or HTML representation of the token, from being converted to those visual placeholders when used in links. However, I don't think there's the same catch applied to image sources. Will try to fix these ASAP.