subigo Posted August 8, 2009 Share Posted August 8, 2009 Maybe I'm missing it, but is there an easy way to export all of the client information for certain servers only? I'm thinking of selling 3 servers to another company with a total of about 300 clients on them all together. The other company also uses whmcs. Basically, I need a way to export all of the client information for them... plan details, packages, customer addresses, etc... Even if it's just a spreadsheet or something, what would be the easiest way to extract just this information for them? Keep in mind that I can't just give them a dump of the whmcs database, we have thousands of clients and they are just getting a few hundred of them. 0 Quote Link to comment Share on other sites More sharing options...
bear Posted August 8, 2009 Share Posted August 8, 2009 You can probably do a dump from phpmyadmin by using a where clause. Select * FROM * WHERE `table.server` = 'server number' (table names and fields will vary, obviously) Once you get this displayed in phpmyadmnin and the data is correct, export it as CSV. 0 Quote Link to comment Share on other sites More sharing options...
keliix06 Posted August 8, 2009 Share Posted August 8, 2009 That's how you'd have to do it, but I imagine it would need to be a much more complex query joining tables in based on client ids, package ids, etc. 0 Quote Link to comment Share on other sites More sharing options...
UH-Matt Posted September 8, 2009 Share Posted September 8, 2009 It would certainly be cool to come up with a script for this purpose (able to export and import to the database of whmcs based on selection criteria (package names or groups or server names or groups). 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted September 10, 2009 Share Posted September 10, 2009 Maybe I'm missing it, but is there an easy way to export all of the client information for certain servers only? Yes, copy the db, then delete the servers you're not selling, delete the tblhosting records from the db that were on those servers, delete the clients that dont have a package, delete the emails that donthave a client, delete the tickets that dont have a client ... 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.