for those of you with duplicate entry errors uploading the xml - I finally gave up on keeping the old data and wiped the following form my db
BACKUP EVERYTHING BEFORE YOU START -
CALL SOMEONE WHO KNOWS WHAT THEY ARE DOING
NO warranty is implied or expected here - this is what I did after waitibg for 18 months to get this working correctly. No I have one error left - above
from settings table remove the
tdsliprequired
'allowtimeslipupload',
'tdmaxwidth',
'tdmaxheight',
tdmaxsize
from profilefield
remove rows 50 and above
remove table
customfile
from usertable
remove tdban
from user field
remove columns 50 and above