adding a new customer directly into the mysql database

Hi I have added a new client directly in the mysql Customer table but it is not showing in the admin panel.
I need this as i am trying to migrate from NopCommerce 4.0 mssql site that is heavily customised and that does not allow me to transfer the information directly.

" but it is not showing in the admin panel"
Did you link them a Customer Role?   The admin search dialog has "Registered" defaulted.

Yes i did