Error when importing from CSV
CSM/CAM Version : CSM 9.60

Hey guys,

I figured someone here might have an idea on how to solve this issue! The error received when importing from the CSV file is:

"Incorrect number of values in import file! Line 23043 has 1 value(s) but 2 column(s) were defined"

The issue is that in the CSV file, it is wrapping the text from my PowerShell script.


Cherwell is treating this as 2 values between commas, which isn't the case. Does anyone know of a way to ensure the output from the script doesn't wrap text, or have any other ways of getting around this issue automatically? 

The script I'm using in this instance (to grab customer's group memberships) is: 

Import-Module Activedirectory
Get-ADUser -Filter * -Properties SamAccountName,memberof | % {
$Name = $_.SamAccountName
$_.memberof | Get-ADGroup | Select @{N="User";E={$Name}},Name
} | Export-Csv D:\Imports\GroupMembershipsLookup.csv -nti