How to get list with statuses for migrating!

[GDelkos]

Hi there

i would like to get my list from a vicibox that i have and migrate to another without loosing my statuses!
is there any way to acomplish that ?
#thank you in advance!

[paolo]

Hi,

I know that my suggestion might be tedious depending on the amount of Data we are talking about, but why not get the vicidial_lists from your database and export it and import it on the new database. Or you can export your database and zip it and create your new database from the exported database.

Regards,

Paolo

[GDelkos]

Hello and thanks for the quick reply but i have like a big amount of data that i would like to migrate, plus i have 3 different servers that i would like to migrate to a big one!
we are talking about loads of list from different servers!
i loss on the status would mean a lot of trouble!
is there any way to get a list with the status in them? so i can migrate them and continue to work?

[paolo]

Yeah that sounds like a big headache. you might want to merge the data into one database and see if theres its distinct data to see if there could be a possibility of merging your 3 database into one.

[GDelkos]

SELECT * FROM table AND status FROM vicidial_list FOR list_id = xxxx;

i am trying to get something like that but cant seem to get it working!

any help?

[GDelkos]

No one had the same problem? i am wondering!
Bump!

[paolo]

No one had the same problem? i am wondering!
Bump!

Here's the query that you wanted I think

select * from vicidial_list where list_id in (select list_id from vicidial_lists where campaign_id = ?);

just replace the questionmark at the end with the campaign id

[mav2287]

Why not just go to the list detail page and click download at the bottom. Then on your never servers you just do an import? You can even create a template on the never servers that lines up with CSV so all you have to do is download and upload. Unless you have a ton of lists to do this seems like the easy way to do this.

[paolo]

I think I found a way to get this rolling.

serverip/vicidial/lead_tools_advanced.php

is the advance lead tools management

you can move all you list to a specific list so that it can be downloaded in one file.

I believe this will retain the status of the leads.

Once you have merged the leads into one list download them and re-import on new server.


Good Luck with your project and I hope this helps

[GDelkos]

thank you so much paolo for the help!

i am now stuck on how to upload them since i do it from the load new leads and it dosent keep the status...it makes all leads as new leads!

/usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl --help

i know this can be helpfull but i have no idea how that works even with the help!

any help would be awesome!

[paolo]

Do an insert statement directly into the database on the vicidial_list table

[GDelkos]

will it then also show on my webform?i mean the inserted lists!

[paolo]

will it then also show on my webform?i mean the inserted lists!

I believe it should. If you extracted the data off the database directly andinserted them directly the mapping should still be there.

[GDelkos]

paolo u are a lifesaver any chance to give me some light onthe insert command for mysql?
>>>> total n00b here on mysql!

[paolo]

Please be reminded that it's not just the vicidial_list that you will need to import since the table is linked to other tables and fields you will need to insert other data as well. Now for the SQL tips I would suggest w3schools.com