Skip to Content
Former Member
Sep 07, 2007 at 10:18 PM

Upload notes for Opportunities through program



In one of the data migration activities, we need to upload opportunities along with the notes for each opportunity. The problem is with reading the notes from the text file into the program using GUI_UPLOAD. Each notes has several new line characters with in it. As a result when I convert the excel into a tab delimited file to upload the data into the program, the notes appears in several lines because of the new line characters. When the program reads the data from the text file, it treats each line as a new record. As a result we don't have the correct data in the system.

Can anyone please suggest a better way of reading the entire note into a single field with the new line characters using a program?

Thanks & Regards,