Copying custom fields to a list on a separate Vicibox server

All installation and configuration problems and questions

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

Copying custom fields to a list on a separate Vicibox server

Postby RemByte » Tue Sep 23, 2014 9:36 pm

I'm trying to figure out what I would need to do to copy custom fields from a list on one server to a list on another server (each are independent Vicibox servers).

For example, if on Server A i have a list with several custom fields, and if on Server B, I just created a new list where I'd like to add the Server A's list's custom fields to it, I'm not sure how I would go about doing this and which tables I should be copying data from.

I know that when creating custom fields it creates a SQL table called custom_XXXX (where XXXX is the list name), but I'm not sure what else I should be copying over to get it to work properly.

Thanks
RemByte
 
Posts: 1
Joined: Mon Aug 25, 2014 1:14 pm

Re: Copying custom fields to a list on a separate Vicibox se

Postby williamconley » Wed Sep 24, 2014 9:57 am

1) Welcome to the Party! 8-)

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) There's also a table containing the custom field definitions. You'd want to copy the fields in that table marked for the original list into the target machine. Then you'd probably also need to create that list in the target machine and use the web interface to copy those fields from that (now duplicated structure) into your target list. Of course you could also toy with altering the list id in transit.
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

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