plugin or what so ever to convert from whmcs to blesta?

[Morningstar]

Any tool to do a clean conversion from whmcs to blesta ?  I use latest Blesta

[Michael]

Blesta has a whmcs importer built in.

https://docs.blesta.com/display/user/WHMCS+5.2+-+7.2

[locthb]

 

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

[Morningstar]

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]

The whmcs and blesta databases are utf8.

[Morningstar]

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.     

[locthb]

 

I view in phpmyadmin and exported to sql file. use whmcs admin to extract the csv file, import it successfully.

[Tiny]

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

 

[Paul]

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.

 

[Morningstar]

Most diffiuclt part is how to convert them ! 

[Morningstar]

If utf8_general_ci  is used instead of using  ÀÁÅåāă simply A is substituted 

[Tiny]

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

[Morningstar]

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.