Client import data issues

[rabx]

Hello,

 

I am seeing issues after importing my clients into the tblclients table under my WHMCS database. By mapping the fields properly, I am able to produce an xls (MS Excel) file that contains my existing clients. As you know, to get a tab delimited file form XLS you save it as a .txt file.

 

When viewing the .txt file using 'cat' the file is clean.

 

Here is my import script:

 

LOAD DATA INFILE '/home/whmcs/WHMCS_full-client-filtered.txt' INTO TABLE tblclients

FIELDS TERMINATED BY '\t'

LINES TERMINATED BY '\n'

 

When viewing this file in phpmyadmin, this data looks clean.

 

Here is the issue: When I log into WHMCS > Clients > View. Everything looks good. When I click on a client and see the summary, everything looks good. When I go to edit the client's details, I see strange symbols before and after every character.

 

Bug?

[rabx]

Resolved the issue but importing the tblclients data and then exporting it to SQL. When exporting it to SQL I noticed /0 in front of everything. Did a find/replace in notepad and re-imported.

[othellotech]

Character encoding problem, or something odd about your import script - we pull in clients from over a dozen external systems and other WHMCS installs and never have an issue.