Re-Importing Leads with Existing Statuses

[simonc]

Hey Guys,

One of our goautodial servers got hacked They have messed up everything and did some fraud calls as well.

We now have a new instance setup that is working properly ( Goautodial Base + Latest SVN for additional vicidial functionnality )

How can we re-import the Leads with Existing statuses? I do not want to loose all the Callbacks, comments as well as call codes as we have called over 10 K leads already!


Much appreciated .

[DomeDan]

you said they messed up everything, do you have a database backup?
or do you want to import what is left of the the messed up database?

[simonc]

We do have a full backup however we do not want to restore from it as it will create problems with the DB Schema and other things ( mainly that the new vicidial is SVN based and is working wonderfully so far )

I would like to re-import only the leads table if possible .

[DomeDan]

You could install the old version on a random computer and restore the backup there,
then you could upgrade that database with the sql-upgrade-script and end up with a database that you can import to your new system.

you only want the leads table you said, I think that would make a lot of headache.
and in the first post you wanted the callbacks to, for that you need at least vicidial_callbacks

[simonc]

We decided to simply download the leads, and restore them as new leads on the server based on theyr call status.

However it would be nice to have a feature were we could import new lead with a call status such as NEW, Busy, No Answer, etc

[mflorell]

The CLI lead loader has an option for loading existing leads with their existing status.

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

[simonc]

Hi Matt,

Thank you very much for this valuable information! It will help us greatly next time.

[gers55]

The CLI lead loader has an option for loading existing leads with their existing status.

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

I tried this matt in the correct format but the leads still show as new when loaded

[mflorell]

What was the exact command you issued?

Also, post one line from your input file.

[gers55]

Sorry Matt

Just noticed i had not replied to this post.

I did not have the csv in the correct format. I got it working

It would be if leads could be loaded in the same format they are downloaded under lists as it is useful if tables get corrupt and you have to get data back in quickly with existing statuses.

[williamconley]

you know, now that there is the ability to create upload templates .. if you were to create a template and post the .sql code to add that template into the issue tracker, it would be fairly easy to add that as a template.

however, it would be even better if you sponsored or paid for someone to create the code necessary to bring that data in with status and other restricted fields as a new option "standard / custom / template / reload". Then you'd get your wish and make others happy while you're doing it.