Morningstar Posted July 21, 2018 Report Share Posted July 21, 2018 Any tool to do a clean conversion from whmcs to blesta ? I use latest Blesta Quote Link to comment Share on other sites More sharing options...
0 Michael Posted July 21, 2018 Report Share Posted July 21, 2018 Blesta has a whmcs importer built in. https://docs.blesta.com/display/user/WHMCS+5.2+-+7.2 Quote Link to comment Share on other sites More sharing options...
0 locthb Posted July 22, 2018 Report Share Posted July 22, 2018 After convert Whmcs to Blesta: - All customer names are marked with utf8 errors. (tried importing with csv successfully) - All domain names of clients are not added. Import with csv Import with WHMCS 5.2 Quote Link to comment Share on other sites More sharing options...
0 Morningstar Posted July 22, 2018 Author Report Share Posted July 22, 2018 Go to your phpmyadmin and look to see how the charecters look like there. Is your database charecterset in whmcs same as blesta ? look in both whmcs and blesta in phpmyadmin and check to see. I think Blesta guys are not experienced with different languages and mostly work in English but hopefully in future things will change locthb 1 Quote Link to comment Share on other sites More sharing options...
0 locthb Posted July 22, 2018 Report Share Posted July 22, 2018 The whmcs and blesta databases are utf8. Quote Link to comment Share on other sites More sharing options...
0 Morningstar Posted July 22, 2018 Author Report Share Posted July 22, 2018 Yes but it is possible that the words and charecters in the database is not exactly utf To make sure try to find the word that does not look correct in your blesta then try to find the same word inside your WHMCS database inside phpmyadmin table see if that charecter is showing correctly inside phpmyadmin of whmcs database. Quote Link to comment Share on other sites More sharing options...
0 locthb Posted July 22, 2018 Report Share Posted July 22, 2018 I view in phpmyadmin and exported to sql file. use whmcs admin to extract the csv file, import it successfully. Quote Link to comment Share on other sites More sharing options...
0 Tiny Posted July 23, 2018 Report Share Posted July 23, 2018 22 hours ago, HoangLoc said: After convert Whmcs to Blesta: - All customer names are marked with utf8 errors. (tried importing with csv successfully) - All domain names of clients are not added. Import with csv Import with WHMCS 5.2 I had the same. Also with vietnamese characters. There is a live update tool, called srdb, which can replace the scrambled characters. Due to the dangers and damages, the tool can cause, please find it yourself. Alternative, export you DB as sq/ or tzt or whatever and do a simple replace, after import it again Quote Link to comment Share on other sites More sharing options...
0 Paul Posted July 23, 2018 Report Share Posted July 23, 2018 Blesta collation is utf8_unicode_ci and I think whmcs is slightly different, but not sure if that would cause the issue. I suspect they are doing something non-standard. Quote Link to comment Share on other sites More sharing options...
0 Morningstar Posted July 24, 2018 Author Report Share Posted July 24, 2018 Most diffiuclt part is how to convert them ! Quote Link to comment Share on other sites More sharing options...
0 Morningstar Posted July 24, 2018 Author Report Share Posted July 24, 2018 If utf8_general_ci is used instead of using ÀÁÅåāă simply A is substituted Quote Link to comment Share on other sites More sharing options...
0 Tiny Posted July 27, 2018 Report Share Posted July 27, 2018 On 7/22/2018 at 6:17 PM, Morningstar said: Go to your phpmyadmin and look to see how the charecters look like there. Is your database charecterset in whmcs same as blesta ? look in both whmcs and blesta in phpmyadmin and check to see. I think Blesta guys are not experienced with different languages and mostly work in English but hopefully in future things will change I am afraid, that happens also with correct settings inside the DB. utf-8 bin to utf-8 bin. I have done with srdb. It's a tool, good for live search/replace and other within the database. It's still an endless job Quote Link to comment Share on other sites More sharing options...
0 Morningstar Posted July 27, 2018 Author Report Share Posted July 27, 2018 I do not think there is a way you can resolve your issue , sorry and as you see no body here have enough knowledge with this charecter issues. Quote Link to comment Share on other sites More sharing options...
Question
Morningstar
Any tool to do a clean conversion from whmcs to blesta ? I use latest Blesta
Link to comment
Share on other sites
12 answers to this question
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.