How to convert dynamic Unix timestamps to date?

At a glance

The community member is using HyvorBlogs as a CMS for their Webstudio Blog, and the XML Sitemap is generating dynamic URLs from the connected data. However, HyvorBlogs sends the date as a Unix timestamp, which is not a formatted date. This causes issues with Google Search Console, which can read the data but with failures. The community members discuss various ways to fix this, including using the Time component, converting the time format dynamically in the template, and opening an issue with HyvorBlogs. Eventually, they find a solution by using the XML Time Component, which is made possible with the help of another community member.

Useful resources

SSteve Baka

Hello together. I use HyvorBlogs as a CMS for my Webstudio Blog. The XML Sitemap ist generating dynamic URL's from the connected Data ${Post Item["updated_at"]}, but HyvorBlogs sends the Date as Unix timestamp. So the <lastmod> ist a Unix Code, not a formatted date. Google Search Console can read it, but with failures. Is there any way to fix/translate this inside expression Editor?

Attachment

38 comments

OOleg Isonen

Time component

SSteve Baka

I see. But if the Page is document type "XML" there are no components like the time component available. Edit: I was not smart enough to copy/paste it...;-) THX

OOleg Isonen

hmm, indeed this is an interesting oversight

OOleg Isonen

normally though the right format should already come from the API

OOleg Isonen

so hyvor blog is supposed to send it in the right format actually

SSteve Baka

@Oleg Isonen But they don't. The Time component is not working because we need the ISO 8601 standard like YYYY-MM-DD. And i've found no country which is formatting like this...

OOleg Isonen

sounds like a problem, can you open an issue with HyvorBlogs and see what they say?

SSteve Baka

@Oleg Isonen Hyvor says, i have speak to you "Usually, you should be able to convert the time format dynamically in the template" LOL

SSteve Baka

"According to their docs (https://docs.webstudio.is/university/foundations/expression-editor), it looks like the expression editor only supports some basic operations."

SSteve Baka

In our API, unfortunately, there's currently no way to get a different datetime format in the output.

OOleg Isonen

@Ivan Starkov wdyt

IIvan Starkov

Did copy-paste time component works?

IIvan Starkov

If yes lets allow it in xml

SSteve Baka

Only if we be able to format the date in W3C format, actually not

IIvan Starkov

Attachment