vicidial.org

Every night I am running the AST_VDsales_export.pl script and it is uploading all of the SALE from vicidial_log.
However it has been missing some.
I noticed the missing recordings are in vicidial_closer_log where status='SALE'
How do I get the script to include the victual_closer_log?
I don't see any parameters

Vicibox cluster install. Database, web, 3 dialers and an archive server.
VERSION: 2.14-615a
BUILD: 170516-0632

vicidial_closer_log entries means you have in-group calls being handled, so you would need to use the following parameter to specify which in-groups to look for sales in:

[--with-inbound=XXX-XXY] = include the following inbound groups

Yes I tried adding that but still it is not grabbing the SALE.
I think I figured it out.
I have to add the --campaign='XXX' in order to get all of them. Without the campaign it uploaded 348. With the campaign it uploaded 395
I had left the campaign out thinking it would grab all but maybe not.

Interesting even with --campaign it is uploading all recordings from all campaigns

- AST_VDsales_export.pl --

This program is designed to gather sales from a VICIDIAL outbound-only campaign and post them to a file.

Campaign: RX1 vicidial_log.campaign_id IN('RX1')
Sale Statuses: SALE-UPSELL and vicidial_log.status IN('SALE','UPSELL')
Output Format: pipe-standard
With Inbound: 10000 vicidial_closer_log.campaign_id IN('10000')


----- SQL CONVERT_TZ: -5:00|-5:00 '-5:00','-5:00' -----

Sending File Over FTP: RX1_20171102_SALE-UPSELL.txt (mp3PN1_Sales @ 104.156.62.234)
Sending Audio Over FTP: 307
SALES EXPORT FOR 2017-11-01: RX1_20171102_SALE-UPSELL.txt
TOTAL SALES: 70
TOTAL EXCLUDED BY CALLTIME:
script execution time in seconds: 88 minutes: 1.46666666666667

See total sales is 70? There are 307 files in the FTP