Move contats fast

[Julio Cunha]

It has some fast method to move contacts from one list to another? I tried to give an update directly in the MySql(update in list_id), but does not appear no contact information on the target list.

 

[SQLIK]

You can use "Sync subscribers" tool
/customer/lists/tools/index

 

[Julio Cunha]

You can use "Sync subscribers" tool
/customer/lists/tools/index

I want move only @gmail.com, so, the data volume is very high to segment...

I think in use UPDATE sql comand, but, don't work fine.

 

[twisted1919]

You just have to update the mw_list_subscriber table, from phpmyadmin, like:

UPDATE mw_list_subscriber SET list_id = X WHERE list_id = Y and email LIKE '%@gmail.com';

 

[Julio Cunha]

I try this, but the subscriber after change stay invisible on the new list... What is wrong?

I use: UPDATE mw_list_subscriber SET list_id = 58 WHERE list_id < 58 and email LIKE '%@gmail.com' limit 10 (for test I limited ;

 

[twisted1919]

@Julio Cunha - Are those subscribers confirmed? (look at the status column)

 

[Julio Cunha]

@Julio Cunha - Are those subscribers confirmed? (look at the status column)

Is "confirmed"

But don't show subscriber after change on the panel, but in BD is ok...

 

[twisted1919]

Right, because you also have to update the list_field table and set the right list_id. So do that and let's see afterwards.

 

[Julio Cunha]

What is wrong?

 

[Julio Cunha]

I can try other method, export All Subscriber with SQL in CSV, after DELETE from mw_list_subscriber ? But the table mw_list_field_value have some values?!

 

[twisted1919]

I'd say you stick to the tools in mailwizz, as you see there's more to it than it looks like...

 

[Julio Cunha]

I'd say you stick to the tools in mailwizz, as you see there's more to it than it looks like...

Ok, I need separe only domains, that gmail, yahoo, How?

 

[twisted1919]

Why not use a tool like open office or the like, separate the subscribers there based on the domain, split them on lists, then import them in different lists in mailwizz.
Or, create a single list in mailwizz, and create segments for each domain you need to.

 

[Julio Cunha]

The Mailwizz is very good to manage the lists. We have several projects and I'm using it for the very large volume of data. Only in this respect he sinned. I did not make it to segment a list with 1 million entries by the tool, for example.

 

[twisted1919]

@Julio Cunha - Then the only option is to split those subscribers externally, in a Office tool (MS Office / open Office / ETC) then import them in mailwizz as you wish.