missing required fields: LastName

[v21networks]

Presently using sugar 6.0.1. Selected to import comma separated value file from dun & bradstreet for a campaign and click on the import button and receive:

missing required fields: LastName

The first column of the csv file is titled DunsNumber. How does one create this as an option under the database field title?

[bickart68]

Email Campaigns are sent to people (or companies). So the import must have at a minimum a Last Name.
When you perform your import you have to map the fields against the imported file.
You can at the bottom of the import screen add a new field for Last Name and enter in a default value such as TBD.

Then your list will get imported. However, that kinda defeats the purpose of an email campaign if you don't have a person's name.

[v21networks]

The field titles [names] from dun & bradstreet are different from the pre-defined fields in Sugar Crm. Suppose I changed the titles in the .csv sheet to match the pre-defined fields will this work. I did as you suggested and placed a default value as TBD and all the fields imported as TBD and nothing else.