|
|||
|
|||
Hello,
I am trying to import files however I need getting the below error, however I am not sure why it is failing when that name is in the list? Record 2 Not imported Fields with illegal values: Account: 20 20 CCTV Operation cancelled. Field: "Account Manager" has invalid data - "Stewart McCone". Anyone know a way round as I don't want to manually have to set the account manager for 400+ accounts Thanks Dan |
|
|||
|
|||
Thank you for posting this.
The 'Account Manager' field value has to be taken from the list of Employees, it means that the Account Manager is an employee responsible for this customer. In order to set the Account Manager when importing Accounts, you should first add Employee records. During the import the system will then match between 'Stewart McCone', found in the imported file, and employee name - just verify that the name in RangerMSP matches - exactly - the name in the file you import. Hope this helps. |
|
|||
|
|||
Oh, sorry for misleading you here. After further checking, unlike with Tickets import, while importing Accounts, the Manager field should contain the Employee Record ID - this can be found and copied from the Preview or Notes tab under the Employee (you can access the Notes tab from the All Tabs dropdown.
Please copy the Record ID and replace the Manager name in the Excel file before importing. Hope this helps. Please let us know how it goes. |
«
Previous Thread
|
Next Thread
»
Thread Tools | Search this Thread |
|
All times are GMT -6. The time now is 09:52 AM.