For some reason when I dumped my data from the sniffer in WPP, most columns (90%) of them are labeled ‘UNKNOWN’.
Why is this? It gives me errors when inserting the SQL obviously.
wouldn’t recommend this but if you still want to execute the sql just change all unknown to 0 i would suggest to backup you core before doing so first 
It’s to stop you to fill database with incorrect data.