AST_VDsales_export.pl vicidial_closer_log status

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

AST_VDsales_export.pl vicidial_closer_log status

Postby jpwalsh75 » Wed Nov 01, 2017 5:25 pm

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
jpwalsh75
 
Posts: 6
Joined: Fri Jun 09, 2017 8:45 am

Re: AST_VDsales_export.pl vicidial_closer_log status

Postby mflorell » Wed Nov 01, 2017 7:30 pm

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
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: AST_VDsales_export.pl vicidial_closer_log status

Postby jpwalsh75 » Thu Nov 02, 2017 8:29 am

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.
jpwalsh75
 
Posts: 6
Joined: Fri Jun 09, 2017 8:45 am

Re: AST_VDsales_export.pl vicidial_closer_log status

Postby jpwalsh75 » Thu Nov 02, 2017 12:07 pm

Interesting even with --campaign it is uploading all recordings from all campaigns
jpwalsh75
 
Posts: 6
Joined: Fri Jun 09, 2017 8:45 am

Re: AST_VDsales_export.pl vicidial_closer_log status

Postby jpwalsh75 » Thu Nov 02, 2017 12:14 pm

- 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
jpwalsh75
 
Posts: 6
Joined: Fri Jun 09, 2017 8:45 am


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 91 guests