Our Client DB to WHMCS Client DB
- or -
Post a project like this3566
$$
- Posted:
- Proposals: 2
- Remote
- #518959
- Awarded
Description
Experience Level: Intermediate
General information for the website: MySQL client table table import to WHMCS
Num. of web pages/modules: 0
Description of every page/module: We have our own php/mysql table of clients. We are migrating to WHMCS and wish to move all of the clients across with some kind of import or script. I have the MySQL dump of our current table and the structure is as follows. We simply need this in the WHMCS client table. The only things we really need is name, address fields, email, contact name (we need to split first name and surname as we have it in one field contact name but WHMCS has it in 2 fields).
CREATE TABLE IF NOT EXISTS `tbl_businessclients` (
`bcid` int(11) NOT NULL AUTO_INCREMENT,
`bname` varchar(250) NOT NULL,
`propertyname` varchar(250) NOT NULL,
`flatno` varchar(100) NOT NULL,
`doorno` varchar(100) NOT NULL,
`streetaddress1` varchar(250) NOT NULL,
`streetaddress2` varchar(250) NOT NULL,
`city` varchar(100) NOT NULL,
`state` varchar(100) NOT NULL,
`zip` varchar(100) NOT NULL,
`country` varchar(100) NOT NULL,
`phone` varchar(100) NOT NULL,
`fax` varchar(100) NOT NULL,
`contactname` varchar(250) NOT NULL,
`website` varchar(250) NOT NULL,
`email` varchar(250) NOT NULL,
`mobile` varchar(100) NOT NULL,
`prepayhrs` int(11) NOT NULL,
`hrbalance` double(10,2) NOT NULL,
`accountref` varchar(250) NOT NULL,
`accountemail` varchar(250) NOT NULL,
`expword` varchar(250) NOT NULL,
`onstop` varchar(11) NOT NULL,
`crlimit` double(10,2) NOT NULL,
`ctype` varchar(100) NOT NULL,
PRIMARY KEY (`bcid`)
) ENGINE=InnoDB AUTO_INCREMENT=442 DEFAULT CHARSET=latin1;
Both db logins can be provided.
Description of requirements/features: As above
Extra notes: Bids only from people with WHMCS experience please. Fixed price only.
Num. of web pages/modules: 0
Description of every page/module: We have our own php/mysql table of clients. We are migrating to WHMCS and wish to move all of the clients across with some kind of import or script. I have the MySQL dump of our current table and the structure is as follows. We simply need this in the WHMCS client table. The only things we really need is name, address fields, email, contact name (we need to split first name and surname as we have it in one field contact name but WHMCS has it in 2 fields).
CREATE TABLE IF NOT EXISTS `tbl_businessclients` (
`bcid` int(11) NOT NULL AUTO_INCREMENT,
`bname` varchar(250) NOT NULL,
`propertyname` varchar(250) NOT NULL,
`flatno` varchar(100) NOT NULL,
`doorno` varchar(100) NOT NULL,
`streetaddress1` varchar(250) NOT NULL,
`streetaddress2` varchar(250) NOT NULL,
`city` varchar(100) NOT NULL,
`state` varchar(100) NOT NULL,
`zip` varchar(100) NOT NULL,
`country` varchar(100) NOT NULL,
`phone` varchar(100) NOT NULL,
`fax` varchar(100) NOT NULL,
`contactname` varchar(250) NOT NULL,
`website` varchar(250) NOT NULL,
`email` varchar(250) NOT NULL,
`mobile` varchar(100) NOT NULL,
`prepayhrs` int(11) NOT NULL,
`hrbalance` double(10,2) NOT NULL,
`accountref` varchar(250) NOT NULL,
`accountemail` varchar(250) NOT NULL,
`expword` varchar(250) NOT NULL,
`onstop` varchar(11) NOT NULL,
`crlimit` double(10,2) NOT NULL,
`ctype` varchar(100) NOT NULL,
PRIMARY KEY (`bcid`)
) ENGINE=InnoDB AUTO_INCREMENT=442 DEFAULT CHARSET=latin1;
Both db logins can be provided.
Description of requirements/features: As above
Extra notes: Bids only from people with WHMCS experience please. Fixed price only.
David K.
100% (2)Projects Completed
3
Freelancers worked with
3
Projects awarded
29%
Last project
4 Aug 2014
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies