# Mautic Column Import Fails **URL:** \ **Category:** Mautic 4 Install/Upgrade Support\ **Tags:** community, discussion, development\ **Created:** [October 3, 2023, 7:01am UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522 "2023-10-03T07:01:07Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![team](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@team](https://forum.mautic.org/u/team)\ **Post date:** [October 3, 2023, 7:01am UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/1 "2023-10-03T07:01:07Z")
**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](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/e/e4a74515c6ccafc18aae8e63c44cc5bfa59f1f22.png) ![Mautic Table](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/9/93e0de0e970a947f05ab484328a9b548c7d4e016.png) Regards, Hal DevCED Team ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [October 3, 2023, 8:23am UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/2 "2023-10-03T08:23:59Z")
Can you try to format YYYY-MM-DD? ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/a/a13806b80f55aba093b374f01af66e2759aae190.jpeg) ---
**Author:** ![team](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@team](https://forum.mautic.org/u/team)\ **Post date:** [October 3, 2023, 3:53pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/3 "2023-10-03T15:53:24Z")
Hi joeyk, No change: ![Mautic Table 2](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/0/0e51b9b6e986e300812346af5ff4df3f5fdd333c.png) Looks like a bug? Regards, Hal DevCED Team ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [October 4, 2023, 8:34am UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/4 "2023-10-04T08:34:15Z")
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. ---
**Author:** ![team](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@team](https://forum.mautic.org/u/team)\ **Post date:** [October 4, 2023, 5:05pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/5 "2023-10-04T17:05:00Z")
Hi joeyk, The {contactfield=alias}, and {contactfield=dtRegDate} produced the same null results? Regards, Hal DevCED Team ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [October 5, 2023, 11:07am UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/6 "2023-10-05T11:07:14Z")
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” ---
**Author:** ![team](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@team](https://forum.mautic.org/u/team)\ **Post date:** [October 5, 2023, 1:09pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/7 "2023-10-05T13:09:15Z")
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](https://youtu.be/IGY_qF--cLE) ---
**Author:** ![Leon\_Oltmanns](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/leon_oltmanns/32/10629_2.png) [@Leon\_Oltmanns](https://forum.mautic.org/u/Leon_Oltmanns)\ **Post date:** [October 5, 2023, 1:18pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/8 "2023-10-05T13:18:42Z")
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](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/4/4f2b7a23ee23d7f653873060b9d4e8421485f302.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/f/fdb784dbab842388bc22baffa91f81868fc08f03.png) ---
**Author:** ![team](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@team](https://forum.mautic.org/u/team)\ **Post date:** [October 5, 2023, 2:50pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/9 "2023-10-05T14:50:14Z")
Thank you very much! ---
**Author:** ![team](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@team](https://forum.mautic.org/u/team)\ **Post date:** [October 6, 2023, 10:09am UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/10 "2023-10-06T10:09:17Z")
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](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/e/e614f995a6a77fbeca53dbcf1cc94ffcd454aaa4.png) ![2023-10-06 02.56.31 mautic.devced.com 9d7a07e80647](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/4/424e786a9552924a76e4d05365fc6f60eaa8c1a9.png) ![2023-10-06 02.59.07 mail.google.com 6d3b43d9860c](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/e/e5df9eb18200b057ee6c47f53b268808b4d9d5ec.png) Regards, Hal DevCED Team ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [October 6, 2023, 11:28am UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/11 "2023-10-06T11:28:41Z")
Try this: "Wow, it seems, that {contactfield=dtregdate} is showing now, Mautic is the best! ---
**Author:** ![team](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@team](https://forum.mautic.org/u/team)\ **Post date:** [October 6, 2023, 1:37pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/12 "2023-10-06T13:37:52Z")
Hi Joey, No change: ![2023-10-06 06.32.58 imap.cfored.com bf4d1910967d](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/6/62f8be84b994ef5bdba1cabf1234737ea238abdc.png) The space is blank with no embed dynamic syntax code: {contactfield=dtregdate} Regards, Hal DevCEDTeam ---
**Author:** ![team](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@team](https://forum.mautic.org/u/team)\ **Post date:** [October 7, 2023, 10:59pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/13 "2023-10-07T22:59:50Z")
Hi Everyone, I’ve created another [YouTube video demonstrating how to insert a date field using the dynamic syntax](https://youtu.be/YgfYVbBn-Cc): {contactfield=dtRegDate}. I would appreciate it if someone could review [my video](https://youtu.be/YgfYVbBn-Cc) 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](https://email.cfored.com/nbc-003). 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](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/c/cf89c9d399b7a0cff3c8bb96ed379cd89853dda3.png) Regards, Hal DevCED Team ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [October 8, 2023, 9:28am UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/14 "2023-10-08T09:28:24Z")
Hello, Couple of things… ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/5/5da5182b33f49c3383b51e5f2c4efefff92ac161.png) - 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. ---
**Author:** ![team](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@team](https://forum.mautic.org/u/team)\ **Post date:** [October 8, 2023, 5:14pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/15 "2023-10-08T17:14:13Z")
Hi Joey, Can we schedule a remote MS Teams session? Share your email address (private chat) and preferred day and time. Thanks, Hal ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [October 8, 2023, 5:19pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/16 "2023-10-08T17:19:39Z")
Sure. Plz note I also need access to the server most likely. Ssh access preferably. What timezone are you? ---
**Author:** ![team](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@team](https://forum.mautic.org/u/team)\ **Post date:** [October 8, 2023, 6:35pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/17 "2023-10-08T18:35:15Z")
I’m in the Pacific time zone @ [Time in Los Angeles, California, United States now - Time.is](https://time.is/Los_Angeles) ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [October 8, 2023, 6:56pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/18 "2023-10-08T18:56:01Z")
Okay, when is the earliest for you tomorrow? Im on Central European Time ---
**Author:** ![team](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@team](https://forum.mautic.org/u/team)\ **Post date:** [October 8, 2023, 7:34pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/19 "2023-10-08T19:34:36Z")
After 10:00 AM (Pacific Time). ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [October 8, 2023, 9:08pm UTC](https://forum.mautic.org/t/mautic-column-import-fails/29522/20 "2023-10-08T21:08:01Z")
ok, hit me up when u are here [Next page](https://forum.mautic.org/t/mautic-column-import-fails/29522.md?page=2)