Export Lists to CSV

Re: Export Lists to CSV

by mflorell » Fri Nov 04, 2016 5:14 am

You'll have to do that from the MySQL commandline. Something like this:

SELECT * from vicidial_list INTO OUTFILE "lead_data.txt";


Then you can grab the file from your database's data directory and import it as tab-delimited(which is the default when you do "into outfile" in mysql).

VICIDIAL API

audio_playback - 

DESCRIPTION:
Basic play/stop/pause/resume/restart audio in agent session

NOTE: PAUSE/RESUME/RESTART features only work with Asterisk 1.8 and higher
       (In Asterisk versions earlier than 1.8 you can replicate RESTART using PLAY and dial_override=Y)

VALUES:
 stage - 
  REQUIRED, choices are below:
   PLAY - starts playing of new audio file in agent session
   STOP - kills playback of audio in agent session
   PAUSE - pauses playing of audio
   RESUME - resumes playing of audio after pause
   RESTART - restarts playback at beginning of audio
 value - 
  REQUIRED for stage of 'PLAY', name of audio file in audio store to play, must NOT have extension
 dial_override - 
  OPTIONAL, (Y or N), default is N. Allows you to PLAY without issuing a STOP to a currently playing audio file


EXAMPLE URLS:
http://server/agc/api.php?source=test&user=6666&pass=1234&agent_user=1000&function=audio_playback&value=ss-noservice&stage=PLAY
http://server/agc/api.php?source=test&user=6666&pass=1234&agent_user=1000&function=audio_playback&stage=STOP
http://server/agc/api.php?source=test&user=6666&pass=1234&agent_user=1000&function=audio_playback&stage=PAUSE
http://server/agc/api.php?source=test&user=6666&pass=1234&agent_user=1000&function=audio_playback&stage=RESUME
http://server/agc/api.php?source=test&user=6666&pass=1234&agent_user=1000&function=audio_playback&stage=RESTART
http://server/agc/api.php?source=test&user=6666&pass=1234&agent_user=1000&function=audio_playback&value=ss-noservice&stage=PLAY&dial_override=Y

RESPONSES:
ERROR: no user found - 6666
ERROR: agent_user is not logged in - PLAY|6666 
ERROR: audio_playback not valid - ss-noservice|PLAY|6666
ERROR: audio_playback error - entry is empty - PLAY|6666
ERROR: audio_playback error - no session data - PLAY|6666
ERROR: audio_playback error - no audio playing in agent session - 8600051|10.10.10.15|PAUSE|6666
ERROR: audio_playback error - audio already playing in agent session - 8600051|10.10.10.15|PLAY|6666
NOTICE: audio_playback previous playback stopped - PLAY|Y|6666
SUCCESS: audio_playback function sent - ss-noservice|PLAY|6666

http://www.vicidial.org/docs/NON-AGENT_API.txt

http://vicidial.org/docs/AGENT_API.txt

Playing a sound

http://104.156.245.213/agc/api.php?source=test&user=6666&pass=12446&agent_user=agent100&function=audio_playback&value=demo-congrats&stage=RESUME




adding a user

http://104.156.245.213/vicidial/non_agent_api.php?source=test&function=add_user&user=6666&pass=10446&agent_user=1000&agent_pass=9999&agent_user_level=1&agent_full_name=Testing+Person&agent_user_group=AGENTS