I can’t see the data there, so looks like I will try to figure out why the script is not working correctly and try to do a proper import. Who maintains the script? Maybe I could get in contact with them to try debug the issue
If anyone else runs into similar issues… my issue the sub/addon domain not being added by the import script. I manually created an user with the same name as cpanel user and details and added the missing subdomain and allowed mail/dns on it, I then modified the script to not add the user and ignore there is an existing user. The script added my main domain and all files/sites and database and emails etc I now have my site up and running, I would like to thank @sahsanu for all the help.