i-hotspots Posted March 13, 2012 Share Posted March 13, 2012 Hello to all, i want to import customer datas from my localy pc prog to my WHMCS database. (OR ANY OTHER DATAS) I saw that I can EXPORT as a csv file, BUT HOW TO IMPORT. Its not so complicated, just basicly files, customers name, email, address........... no Domains or hosting plans Thanks a lot Andy ;P 0 Quote Link to comment Share on other sites More sharing options...
tripler Posted March 13, 2012 Share Posted March 13, 2012 How many do you have Andy? It is possible to create a script to do this but if you dont have that many customers I would just do it by hand =) 0 Quote Link to comment Share on other sites More sharing options...
Sitepearl Posted March 25, 2012 Share Posted March 25, 2012 You can always import it through your DBMS, but you'll have to line the columns up with the table. 0 Quote Link to comment Share on other sites More sharing options...
laszlof Posted March 25, 2012 Share Posted March 25, 2012 I'd advise against importing into WHMCS using any method other than the API. Theres a number of things to consider when directly importing into the database, and you'll likely break something doing it that way if you're not experience with how WHMCS operates internally. 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted March 26, 2012 Share Posted March 26, 2012 I'd advise against importing into WHMCS using any method other than the API Good advice 0 Quote Link to comment Share on other sites More sharing options...
i-hotspots Posted March 22, 2013 Author Share Posted March 22, 2013 How many do you have Andy? It is possible to create a script to do this but if you dont have that many customers I would just do it by hand =) Thanks tripler, they are not so many, about 1500, BUT by hand a bit horrible ;P I´ve tried by download the table file, but I dont get it with the "``-Signs" in excel that I can upload correct. BETTER to ask here or find another solution that is 100% SURE and fine, I not want my database get broken 0 Quote Link to comment Share on other sites More sharing options...
Shalomc Posted July 9, 2013 Share Posted July 9, 2013 I do our integrations and uploads to WHMCS via the itduzzit.com integration service. To import customers, I created a custom "duzzit" (a unit of API work) that accepts as inputs the WHMCS API fields, and executes a single API call for a new customer account. Then, there is an option to map a CSV file to the inputs and run it for all of the CSV records. 0 Quote Link to comment Share on other sites More sharing options...
mburtis Posted January 8, 2014 Share Posted January 8, 2014 I know this is an older message, but I wonder if you (shalomc) would be willing to share some more info about how you set up the duzzit to do this. I've been experimenting with duzzit and whmcs' api, but I'm having trouble figuring out exactly how to build this within duzzit's system. 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.