I have been trying to import records into CRM for weeks now with no success. I have a .csv file with a list of accounts data, including the primary contact name.
I have used the import wizard to successfully import the account data into the relevant fields in the account table. However almost no data is imported into the contact table, despite assigning the data to be imported to the correct fields. The records are created and linked to each account by the 'Parent Account' field, which is the only data on the record. The correct number of records are being imported but each field is completely blank.
I have tried creating a new contact in CRM, exporting it, and importing it again. Same problem.
I have pasted the data into the Contacts import template spreadsheet from CRM. Same problem.
I have restarted the CRM server and am still having the same issue.
Here is the completed import job showing the contacts imported. The parent customers and relevant data were imported successfully.
Here is the first record from that list, as you can see it is linked to one of the accounts, but the rest of the fields are blank.
How is it creating the records when a required field, last name, is left blank in the import?
