synchro Posted August 11, 2007 Share Posted August 11, 2007 Hello I have 500 or so clients which I manage manually through a accounting system. Is there a way that I can manually import all the details into the database to save manually inputing every client? Even if I could import the client details would be a start. I can output the client details into a txt or excel file if that would help. Anything to avoid inputing all that info would be a great help Regards Paul 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted August 11, 2007 Share Posted August 11, 2007 add one client manually use phpmyadmin to dump the clients table - that will give you INSERT INTO line create an equivalent text file with your client data run it in phpmyadmin worked for us 0 Quote Link to comment Share on other sites More sharing options...
synchro Posted August 12, 2007 Author Share Posted August 12, 2007 Thanks Rob I will give it a try Regards Paul 0 Quote Link to comment Share on other sites More sharing options...
vivaciti Posted September 4, 2007 Share Posted September 4, 2007 add one client manuallyuse phpmyadmin to dump the clients table - that will give you INSERT INTO line create an equivalent text file with your client data run it in phpmyadmin worked for us Would that work if we also had 3 custom feilds we need to import (customer feilds already created in WHMCS) 0 Quote Link to comment Share on other sites More sharing options...
ffeingol Posted September 4, 2007 Share Posted September 4, 2007 add one client manuallyuse phpmyadmin to dump the clients table - that will give you INSERT INTO line create an equivalent text file with your client data run it in phpmyadmin I'm still pretty new to WHMCS but wouldn't you also need (at least) the hosting table also? The hosting table seems to tie the client + domain + hosting package + payment method. Frank 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted September 4, 2007 Share Posted September 4, 2007 add one client manuallyuse phpmyadmin to dump the clients table - that will give you INSERT INTO line create an equivalent text file with your client data run it in phpmyadmin I'm still pretty new to WHMCS but wouldn't you also need (at least) the hosting table also? The hosting table seems to tie the client + domain + hosting package + payment method. Frank We only imported the clients - we created new orders for them and used it as a time to redesign the packages and generally tidy up a bit 0 Quote Link to comment Share on other sites More sharing options...
ffeingol Posted September 4, 2007 Share Posted September 4, 2007 Sounds perfect, but from reading synchro's post, I think they want to bring in all the details so it just gets a bit more complicated. Frank 0 Quote Link to comment Share on other sites More sharing options...
vivaciti Posted September 4, 2007 Share Posted September 4, 2007 We just wanted to know if the same procces would work if we had to import some custom feilds and were in the database these would be. 0 Quote Link to comment Share on other sites More sharing options...
synchro Posted September 4, 2007 Author Share Posted September 4, 2007 We just wanted to know if the same procces would work if we had to import some custom feilds and were in the database these would be. Your right Frank, we had all our reoccuring transactions in an accounting package so it would be great if we can import Client details and hosting packages and dates all at the same time. We have imported the client details but its a huge task to import the rest of the client details Has anybody else got any tips? Regards Paul 0 Quote Link to comment Share on other sites More sharing options...
synchro Posted September 4, 2007 Author Share Posted September 4, 2007 Sorry wrong quote, I will try again We just wanted to know if the same procces would work if we had to import some custom feilds and were in the database these would be. Your right Frank, we had all our reoccuring transactions in an accounting package so it would be great if we can import Client details and hosting packages and dates all at the same time. We have imported the client details but its a huge task to import the rest of the client details Has anybody else got any tips? Regards Paul 0 Quote Link to comment Share on other sites More sharing options...
synchro Posted September 4, 2007 Author Share Posted September 4, 2007 I did it again - too late at night !! Sounds perfect, but from reading synchro's post, I think they want to bring in all the details so it just gets a bit more complicated. Frank Thats what I meant to quote !! 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.