I am working on migrating our product catalog into NS from our old SQL database and am debating which approach is best for our needs. For the most part the import assistant is the desired approach but we have one field that is long text that contains line breaks/carriage returns in the data so including that field in the CSV export is not an option (i want to avoid removing line breaks from the data to preserve its original format). For this reason im considering the smbXML method even though NS advises against it. I have ruled out a straight up webservices import due to poor performance.
The other option (not really an option in my opinion) is to use the import assistant and omit the long text field. Then use webservices or smbXML to update those records with the long text field information. I don't like this approach because increasing the number of operations increases the chances of error. So mostly I have ruled this option out.
I'm hoping those of you with this experience behind you can offer some wisdom on this topic?