Messages Import
The Messages import adds message records to NetSuite. Messages are used to attach email messages to NetSuite entities and transactions.
The fields available for messages imports correspond to those on the Recipients and Messages subtabs of the Attach Message dialog. This dialog appears when a user clicks Attach on the Messages subtab of one an entity or transaction record.
For details about fields that can be mapped in the Message record, see the SOAP Schema Browser’s message reference page. You can use the field definitions as a basis for creating your own CSV import template file. For information about working with the SOAP Schema Browser, see SOAP Schema Browser.
Be aware of the following:
-
Because messages are not editable in the UI, they are not editable through CSV import. You can use CSV import to add new message records only, not to edit existing message records. For messages imports, the Update and Add or Update data handling options are grayed out on the Step 2 Import Options page of the Import Assistant.
-
Required messages fields for import are: From (the sender of the message), Attach to (the recipient of the message and the record to which the message is attached in NetSuite), and Subject (which also serves as a title). Entities provided as From and Attach to field values must already exist in NetSuite. If the From and Attach to entity records do not have email addresses, then the From Email Address and To (Email) fields are required.
-
Unlike in the user interface, the Attach to field does not default to be the logged in user. You need to include values for this field in your CSV file or set up a default on the Import Assistant Field Mapping page. See Assign Default Values during Field Mapping.
-
To attach messages to transactions, map the Transaction field, and either set a default value or include transaction values in the CSV file.
-
The Emailed field is a Boolean that indicates whether an email message was sent. Messages imports do not send any email messages.
-
Import of file attachments is not supported, although files can be attached to messages in the NetSuite user interface.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.