How to add columns to the vicidial_list

Discussions about development of VICIDIAL and astGUIclient

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

How to add columns to the vicidial_list

Postby John Hale » Mon Aug 31, 2009 6:24 am

I need to add columns to the vicidial_list table, unfortunately, when I tried it all went pear shaped and I had to re-install. Is there a secret to doing this? Can anyone help me out please? Maybe there is a better alternative.
John Hale
 
Posts: 9
Joined: Mon Aug 31, 2009 6:09 am

Postby mflorell » Mon Aug 31, 2009 6:26 am

We usually recommend adding a new table and using the web form to access the new information.

How many fields do you need to access?

Do you need to load records into these additional fields or are they just for entry once connected?
mflorell
Site Admin
 
Posts: 18341
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby John Hale » Mon Aug 31, 2009 6:39 am

There are 66 columns in our existing survey table and we would need possibly another 10 columns for the actual lead. I guess we could create a survey table and an additional columns table and load them both from the web form. The survey columns would be populated by the canvassers. Being a complete newbie I appreciate any and all assistance. Thanks.
John Hale
 
Posts: 9
Joined: Mon Aug 31, 2009 6:09 am

Postby mflorell » Mon Aug 31, 2009 9:32 am

Since you are doing surveys, have you looked into using LimeSurvey?

It is an open-source survey tool that many companies use in conjunction with ViciDial.
mflorell
Site Admin
 
Posts: 18341
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby John Hale » Mon Aug 31, 2009 11:32 am

Thank you, I will take a look.
John Hale
 
Posts: 9
Joined: Mon Aug 31, 2009 6:09 am

Postby ykhan » Tue Oct 27, 2009 3:57 pm

Another nice open source tool is Opinio http://www.objectplanet.com/opinio/
Yousaf Khan
For installation and Support.
VoIP to North America from $0.009/min
Phone: +1 (647) 891-5426
Email: ykhan@duologuecommunications.com
ykhan
 
Posts: 352
Joined: Thu Jun 08, 2006 4:47 pm

Postby williamconley » Sat Oct 31, 2009 12:06 am

I think you lost me. I could download a "Free Evaluation Copy". Is that what you are referring to as Open Source?
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20019
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Development

Who is online

Users browsing this forum: No registered users and 13 guests