Mautic Column Import Fails

Product Support Mautic 4 Install/Upgrade Support
, ,
1

EasyApache 4
My Mautic version is: 45_mautic-449
My PHP 80, PHP 8.0.29-1.1.3.cpanel
extention: php80-php-fileinfo
cPanel & WHM on AlmaLinux
OS: AlmaLinux v8.8.0 STANDARD kvm
cPanel Version 112.0.5

Hi everyone,
We require your assistance. The table column (Date created) does not import the lead’s registration dates into the dynamic email message with the {contactfield=Date created}.
Can you recommend a solution?

See captured screen images:

2023-10-02 23.52.43 mautic.devced.com 26fb35ce3ba4

Mautic Table

Regards,
Hal
DevCED Team

2

Can you try to format YYYY-MM-DD?

image

1 Like
3

Hi joeyk,

No change:

Mautic Table 2

Looks like a bug?

Regards,
Hal
DevCED Team

4

Could you check if this custom field is set “date” or “datetime”?

This won’t work:
{contactfield=Date created}

You need to use the “alias” column for personalization.

5

Hi joeyk,

The {contactfield=alias}, and {contactfield=dtRegDate} produced the same null results?

Regards,
Hal
DevCED Team

6

When I say “alias” - I mean the alias field of a custom field.
For example: First Name = {contactfield=firstname}
You can see this in your Contact Fields list under the Gear icon, column “alias”

7

There is no alias field as part of Mautic’s contact fields in the pull-down menu selection. Is this the correct dynamic syntax: {contactfield=dtRegDate}. Please check out the following YouTube video link, https://youtu.be/IGY_qF--cLE

8

Hi @team,
Joey was hinting that every Contact Field has a Name and an alias. For the personalization you need to use the field-alias, not the field name.

You can find all every alias under “Settings” → “Custom Fields”:

image
image468×642 31.3 KB

image
image1074×474 41.3 KB

9

Thank you very much!

10

Hi, Leon & Joey,

There is no change with the field-alias.
See the screenshot images as follows:

2023-10-06 02.54.02 mautic.devced.com e4a1c6faa33a
2023-10-06 02.54.02 mautic.devced.com e4a1c6faa33a721×435 5.62 KB

2023-10-06 02.56.31 mautic.devced.com 9d7a07e80647
2023-10-06 02.56.31 mautic.devced.com 9d7a07e806471969×534 31.2 KB

2023-10-06 02.59.07 mail.google.com 6d3b43d9860c

Regards,
Hal
DevCED Team

11

Try this:

"Wow, it seems, that {contactfield=dtregdate} is showing now, Mautic is the best!

12

Hi Joey,
No change:
2023-10-06 06.32.58 imap.cfored.com bf4d1910967d

The space is blank with no embed dynamic syntax code: {contactfield=dtregdate}

Regards,
Hal
DevCEDTeam

13

Hi Everyone,

I’ve created another YouTube video demonstrating how to insert a date field using the dynamic syntax: {contactfield=dtRegDate}.

I would appreciate it if someone could review my video and let me know if there might be a “Mautic Bug” related to posting a date from a data field table.

Here is the URL link to the HTML code:

The URL link is here.

Please also take a look at the attached screenshot image (i.e., on {contactfield=dtRegDate} ):
2023-10-07 15.42.14 imap.cfored.com cff1ff8db3e5

Regards,
Hal
DevCED Team

14

Hello,

Couple of things…

image

  • There is no sound in this video
  • I don’t think this is your alias
  • It’s not clear how you export your CSV
  • Not obvious for me how if import really happened.

I’d like to take a look and post here my findings.

I PMd you.

15

Hi Joey,

Can we schedule a remote MS Teams session?

Share your email address (private chat) and preferred day and time.

Thanks,
Hal

16

Sure.
Plz note I also need access to the server most likely.
Ssh access preferably.
What timezone are you?

17

I’m in the Pacific time zone @ Time in Los Angeles, California, United States now - Time.is

18

Okay, when is the earliest for you tomorrow? Im on Central European Time

19

After 10:00 AM (Pacific Time).

20

ok, hit me up when u are here