I'm trying to fill an Active Directory group using users exported from an Entra group to a CSV file. The export works fine, and my import also shows results when the CSV hasn't been changed. However, once I edit the CSV file, I get no results upon import. I'm exporting and saving everything as UTF-8. Does anyone know what might be causing this issue?
5 Answers
Make sure your CSV is using the correct delimiter. By default, it's a comma, but if you're using something else, like a semicolon, you'll need to specify that with the `-Delimiter` switch in your import command. For example: `Import-Csv .data.csv -Delimiter ";"`.
If you're using PowerShell 5.1, be aware that the `Export-CSV` cmdlet adds a header line that could be causing problems. It includes a line like `#TYPE Your.Data.Type`, which some CSV readers may not handle properly. To fix this, you can use the `-NoTypeInformation` switch when you export the CSV to suppress that line. Just a thought since I haven't seen your actual code. Good luck!
It’s tough to diagnose without seeing your actual code and the CSV structure. If you can, share snippets of your code and a sanitized version of the CSV. There are many possibilities for what could go wrong.
Consider using Entra Cloud Connect Sync instead of exporting and importing manually. This is a built-in tool from Microsoft that can simplify the process. Here's a link that explains how to configure it for syncing with Active Directory: https://learn.microsoft.com/en-us/en...
Check if you cleaned up your export from Entra. Sometimes, you only need the User Principal Name (UPN), but the export includes a lot of extra details. You might also need to specify which column to use in your import.
Thanks for the suggestion! I'll look into that option.