It seems that through reading other posts that this causes a problem, but I did not see if there was a work around or not. If this is the case, what is the best suggestion you have to use this tool? I have nearly 2,000 articles that I need to import.
Yes it may be the word punctuation.
Do you get any other error messages when attempting to install the import data component, showing where it found a problem in the sql
As a test just to make sure it is nothing else causing problems you could try compiling just a couple of items with a bit of dummy content and see if that installs as it should.
A few other things it may be is the file size, the server might have a low upload limit.
It might also be timing out if the server is only set to 30 seconds.
If the above test works ok, you could try compiling just one section and see how it goes.
Basically break it up into smaller installs which will get around all the above issues other than the process stopping on a certain character.
