Dial statuses are specific times

[hansg]

Hi,

Is it possible to have a dial status within a campaign that will only load into the hopper between certain hours.

For example if a customer says Call back after 4pm. Disposition the call as "Evening Callback" and then the status is only loaded in after a set time.

If there isn't a way to do this using the interface, would it be possible to do via cron entry which would add a status to a campaigns dialable statuses?


Also on a totally different topic... Is it safe to delete the below files. If not how do i clear them?

/var/lib/mysql/asterisk/call_log_archive.MYD
/var/lib/mysql/asterisk/vicidial_dial_log_archive.MYD
/var/lib/mysql/asterisk/vicidial_carrier_log_archive.MYD

It is taking up a large amount of space.

[williamconley]

1) You posted the base requirement of Vicidial Version with Build. Well done. Please also try to include your installer with version (it makes a difference!).

2) Two questions in one post? Consider that the subject line will make that second question difficult to find. Two questions should be two topics each with its own subject line appropriate to the question. Hang your head in shame.

3) Campaigns have filters, filters can contain times and statuses and pretty much everything else. Start simple by having a filter disallowing all callbacks and another one allowing the one you want to fire right now. Then at 4PM, change the filter to allow evening callbacks. Later you can begin writing one that includes the present time and allows appropriate callbacks based on the present time. Best to test that against your "simple" manual ones to be sure they don't misfire.

4) Those are table data files. Delete the data from the tables and await the nightly "optimization" process and they will zero out. Assuming, of course, you no longer need that data. You can also "mysqldump" that data to disk, gzip the result, and store it on your laptop "just in case".

[hansg]

Thanks for your reply William.

When you say "Delete the data from the files". Is that any different than right clicking the .myd file and hitting delete?

[williamconley]

sorry for the error: Delete the data from the TABLES. Those are table data files. Deleting the data from the table will not reduce file size immediately, but when optimization runs the file size will drop.

of course, you won't have the data that was in the table because you deleted it.

[hansg]

Thanks for the clarification.

What is the best command to do that?

[williamconley]

"truncate TABLENAME" will empty any table.