Really hoping that this is an easy answer
We are trying to import about 6000 Project Tasks using
ACTIVITIES>SCHEDULING>PROJECT TASK>IMPORT
Everything works smoothly until I try to add Line Breaks to the Messages field. The field is called "Messages" in the Import Mapping. The field is called "NOTES" on the Project record. The records that are only one line with no Line Breaks in the Messages field, import perfectly. The records with Line Breaks in the Messages field do not import correctly.
So far I have tried the following
1) In the Excel file that creates the message using the CONCATENATE function, I use CHAR(10) to create the Line Breaks. When that Excel file is saved to CSV, the line break appears to remain. However, when importing the CSV into NetSuite, only the first line of the message appears in the NOTES field. All subsequent lines are dropped
2) In the Excel file I have also tried both <br/> and <br /> to insert the Line Break. The converted CSV file does not indicate that the line break exists but instead shows the <br/> or <br />. However, when importing to NetSuite, the file does not import successfully. The Error is "An unexpected error has occurred".
I do not see any SuiteAnswers or SuiteIdeas on this subject. Can anyone suggest a method to add Line Breaks to the Message (NOTES) field in a Project Task import? Thanks in advance.