Timewarp

Status
Not open for further replies.

twisted1919

Administrator
Staff member
Hi guys,

I am happy to announce that starting with mailwizz 1.5.2 (next release) we added support for sending campaigns in using the timezones specific to each subscriber, so we can now send the campaign at a given time and schedule so that subscribers receive it at their local time.

For more details about requirements and how this works, see:
https://kb.mailwizz.com/articles/timewarp/

Because of implementing this feature, we had to alter the database a bit, in special, we had to add and alter some columns, so please, at upgrade, if you have a larger database, do the upgrade from command line (or let the auto-updater do it for you).

Screenshot 2018-01-08 14.59.43.png
 

frm.mwz

Well-Known Member
Hi guys,

I am happy to announce that starting with mailwizz 1.5.2 (next release) we added support for sending campaigns in using the timezones specific to each subscriber, so we can now send the campaign at a given time and schedule so that subscribers receive it at their local time.

For more details about requirements and how this works, see:
https://kb.mailwizz.com/articles/timewarp/

Because of implementing this feature, we had to alter the database a bit, in special, we had to add and alter some columns, so please, at upgrade, if you have a larger database, do the upgrade from command line (or let the auto-updater do it for you).

View attachment 4636
Great stuff!
Will this work even if temp queue tables are not enabled?
 

gsonline

New Member
Will the timewarp also work with lists I manually import? (for example, it can take the IP address from the user once the email is opened for the first time)
 

Priti

New Member
Wonderful update.
@twisted1919 I came across an issue with XML feed campaign, the 'postpone-campaign' feature did not worked when no post was found here is my code.

[XML_FEED_BEGIN url='feed-url' count='5' days-back='1' no-item-action='postpone-campaign']

Though it was supposed to not send the campaign when there is no post in contrast the campaign executed with original xml tags template.

please look into this.

thanks
 

Priti

New Member
@Priti - Open a support ticket with the actual xml content you used so i can try it ;)
I suppose i have resolve the issue. I think the problem was in subject line where I had put something like

[XML_FEED_BEGIN url='XML-FEED-URL' count='1'] [XML_FEED_ITEM_TITLE] [XML_FEED_END]

without no-item-action='postpone-campaign' and I think that was the issue?

And I also find the campaign status as 'sending' but sending time date got changed for the next date, is this how it suppose to work?

is it normal now?

thanks
 

frm.mwz

Well-Known Member
@twisted1919
This is really amazing feature.

so now we can export or segment subscribers based on their location as once @sendizo suggested ?

Great work !
You can export geoloc of subs anytime and even combine it with activity, but you might have to go to cli or phpmyadmin, depending on if the feature is available or if you like to avoid slow php queries.
 

Priti

New Member
Wonderful.

Does Mailwizz XML/JSON parser also support Google Sheet JSON/XML (as it produce xml feed entry as following rather than item as per WordPress feed).

<entry>
<gsx:sl.no.>1</gsx:sl.no.>
<gsx:title>this is title</gsx:title>
<gsx:description>this is details</gsx:description>
<gsx:link>https://google.com</gsx:link>
<gsx:image>https://google.com</gsx:image>
<gsx:content>this is content</gsx:content>
<gsx:pubdate>1/11/2018</gsx:pubdate>
</entry>

thanks
 

Priti

New Member
Wonderful.

Does Mailwizz XML/JSON parser also support Google Sheet JSON/XML (as it produce xml feed entry as following rather than item as per WordPress feed).

<entry>
<gsx:sl.no.>1</gsx:sl.no.>
<gsx:title>this is title</gsx:title>
<gsx:description>this is details</gsx:description>
<gsx:link>https://google.com</gsx:link>
<gsx:image>https://google.com</gsx:image>
<gsx:content>this is content</gsx:content>
<gsx:pubdate>1/11/2018</gsx:pubdate>
</entry>

thanks
I assume CampaignXmlFeedParser.php file at this location apps/common/components/utils/ is responsible for this though I tried but its not working could you please guide in this regards.

parsing google sheet XML/JSON can bring immense possibility also it will help in MW customizing the XML feed metas.

thanks
 

Priti

New Member
Code:
<?xml version='1.0' encoding='UTF-8'?>
<feed xmlns="http://www.w3.org/2005/Atom" xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/" xmlns:gsx="http://schemas.google.com/spreadsheets/2006/extended">
    <id>https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values</id>
    <updated>2018-01-11T12:43:05.615Z</updated>
    <category scheme="http://schemas.google.com/spreadsheets/2006" term="http://schemas.google.com/spreadsheets/2006#list" />
    <title type="text">Sheet1</title>
    <link rel="alternate" type="application/atom+xml" href="https://docs.google.com/spreadsheets/d/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/pubhtml" />
    <link rel="http://schemas.google.com/g/2005#feed" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values" />
    <link rel="http://schemas.google.com/g/2005#post" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values" />
    <link rel="self" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values" />
    <author>
        <name></name>
        <email></email>
    </author>
    <openSearch:totalResults>1</openSearch:totalResults>
    <openSearch:startIndex>1</openSearch:startIndex>
    <entry>
        <id>https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values/cokwr</id>
        <updated>2018-01-11T12:43:05.615Z</updated>
        <category scheme="http://schemas.google.com/spreadsheets/2006" term="http://schemas.google.com/spreadsheets/2006#list" />
        <title type="text">1</title>
        <content type="text">title: This is title, description: This is description, image: https://google.com, link: https://google.com, pubdate: 1/11/2018</content>
        <link rel="self" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/list/1H4CbLobSFPitH4nPaF4C_JxXqNJxHvzo7v8wVQ-VPHw/od6/public/values/cokwr" />
        <gsx:sl.no.>1</gsx:sl.no.>
        <gsx:title>This is title</gsx:title>
        <gsx:description>This is description</gsx:description>
        <gsx:image>https://google.com</gsx:image>
        <gsx:link>https://google.com</gsx:link>
        <gsx:pubdate>1/11/2018</gsx:pubdate>
    </entry>
</feed>
go here to check https://goo.gl/32DekZ live feed (minify xml version).
This is the entire xml code generated from google sheet api xml feed.
 

twisted1919

Administrator
Staff member
Thank you for the examples, i'll check them in details in the morning and based on them i'll create an implementation ;)
 
Status
Not open for further replies.
Top