Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to add line breaks on Message field via Project Task Import?
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