A quick way to edit Autopilot .csv file

-
I have come across many instances online where people have struggled dealing and working with multiple csv files. If you have to upload multiple rows or simply add an attribute, then it is not a straight forward task. Formatting of Autopilot csv files is highly sensitive. If you try to edit them directly in Excel and then save them as .csv, the file will be rendered useless. 


By the way, if you are looking for a quick way to create the .csv files then here is the code -

New-Item -Type Directory -Path "C:\HWID"
Set-Location -Path "C:\HWID"
Set-ExecutionPolicy -Scope Process -ExecutionPolicy Unrestricted
Install-Script -Name Get-WindowsAutoPilotInfo
Get-WindowsAutoPilotInfo.ps1 -OutputFile AutoPilotHWID.csv

You can use -append parameter to add multiple rows, but if you want to do it using a GUI or add additional attributes, then you can use the method below which I have found to be effective.

1. Rename the exported .csv file to .txt
2. Open Excel and open the .txt file from Open->Browse-><.txt file> (Enable All Files *.*)
3. Excel will open the .txt file in Text editor.
4. Select the Delimited option.


5. Select the Comma option only.


6. Set Text for each of the columns.




7. Click Finish.
8. Edit in Excel as necessary. In this case, I am adding a Group Tag. (Note: The headers are case sensitive so use it in the right format)


9. Save as .csv and Import as normal. (Note: Save in default ANSI and not UTF-8)


That's all to it. Happy days..



Comments

  1. RagJuly 28, 2022 at 4:52 PM

    Cool, thanks!

    ReplyDelete
  2. MMRAugust 18, 2022 at 10:31 AM

    Hello, thanks for the detailed instruction, I followed as described, but I cannot import the resulting modified .csv, as it returns a formatting error (incorrect header). The original ( not modified csv )works perfectly. Please advise. Thanks

    ReplyDelete
  3. MihaiAugust 18, 2022 at 2:44 PM

    Hello, thanks for the detailed information, I tried to follow the described steps, in an attempt to add Group Tag column. When I try to upload the csv to the autopilot devices, it returns an error ( "Incorrect headers, cannot proceed further
    " ). With default columns ( no GroupTag added), the .csv loads just fine. Please advise, thank you.

    ReplyDelete
    Replies
    1. Rahul JindalAugust 18, 2022 at 10:50 PM

      Sounds like the csv is corrupt. Does the unedited csv work?

      Delete
    2. AnonymousJune 21, 2023 at 9:14 PM

      i have 2k device that needed to have Group tag - i tried all your steps but its giving me error when Impoting - Error is" 806-ZtdDevicealreadyAssigned- CSVline numbers addected"

      How can i solve this sir

      Thank you so much for all your articals

      Delete
  4. Naveed PCSeptember 18, 2022 at 3:45 PM

    Great set of tips from the master himself. Very nice post, Excellent Ideas blogger
    https://naveedpc.org/

    modern csv keygen crack

    chrispc videotube downloader pro crack

    treesize professional crack

    mixpad crack

    tekla structures crack

    traktor pro crack

    flowers pro crack</a

    ReplyDelete
  5. Naveed PCSeptember 18, 2022 at 3:48 PM

    Great set of tips from the master himself. Very nice post, Excellent Ideas blogger
    https://naveedpc.org/

    modern csv keygen crack

    ReplyDelete
  6. mubashirDecember 7, 2022 at 5:31 PM

    I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot.I hope to have many more entries or so from you.
    Very interesting blog.
    wstmania.org
    Picture Merge Genius Crack
    Overloud TH-U crack
    SnapGene crack
    TreeSize Professional crack

    ReplyDelete
  7. horainJanuary 12, 2023 at 1:24 PM

    I am very happy to read this article. Thanks for giving us Amazing info. Fantastic post.
    Thanks For Sharing such an informative article, Im taking your feed also, Thanks.
    picture-merge-genius-crack
    chessbase-crack

    ReplyDelete
  8. MonaFebruary 10, 2023 at 6:54 PM

    Very good article! We will be linking to this particularly great post on our website. Keep up the good writing.
    vstcrackfull.com
    MKVToolNix Crack
    Neuratron AudioScore Ultimate Crack
    Excel Merger Pro Crack

    ReplyDelete
  9. tamiFebruary 15, 2023 at 11:57 AM

    I am very thankful for the effort put on by you, to help us, Thank you so much for the post it is very helpful, keep posting such type of Article.
    picture-merge-genius-crack
    beecut-crack

    ReplyDelete
  10. AnonymousMay 12, 2023 at 8:13 AM

    Really great article, helped me a lot for bunch of users.

    ReplyDelete
  11. Albert EinsteinMarch 16, 2024 at 1:09 AM

    Good Work.Keep it Up.

    BeeCut Crack

    DVD Audio Extractor Crack

    SpyHunter Crack

    ReplyDelete
  12. Albert EinsteinOctober 30, 2024 at 4:02 PM

    I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot.
    Autodesk Revit Crack
    DVD Audio Extractor Crack
    BeeCut Crack

    ReplyDelete

Post a Comment

Popular posts from this blog

How to force escrowing of BitLocker recovery keys using Intune

-
Image
Every now and then it so happens that BitLocker recovery keys do not escrow in AAD. The usual culprits are incorrect BitLocker policies and\or the device hardware configuration failing to meet the minimum requirements. The other scenario and something I recently experienced is when everything is setup right and still the recovery key doesn’t escrow in AAD. As I understand, this can happen if the escrow process got interrupted the first time due to network or local devices related issues and the process could not resume. To circumvent this issue, one can simply push a PowerShell script to the devices to force the escrow of the recovery keys to AAD. Here is a script to do so. try{ $BitlockerVol = Get-BitLockerVolume -MountPoint $env:SystemDrive         $KPID=""         foreach($KP in $BitlockerVol.KeyProtector){             if($KP.KeyProtectorType -eq "RecoveryPassword"){              ...
Read more

Prevent users from running certain programs or applications on Windows endpoints using Intune

-
Image
  When it comes to blocking or preventing users from running an application on Windows devices, one normally uses App locker policy, Windows Defender Application Control and not so new but pretty useful method called Defender Vulnerability management within Microsoft 365 Defender Portal. A recent question on the Tech Community Microsoft forum prompted me to look for all possible alternatives. I started reminiscing over the legacy GPO policies and that is when I stumbled upon the policy  Don’t run specified Windows applications  located under User Administrative Templates - The policy setting does come with its own caveat - " This policy setting only prevents users from running programs that are started by the File Explorer process. It does not prevent users from running programs, such as Task Manager, which are started by the system process or by other processes. Also, if users have access to the command prompt (Cmd.exe), this policy setting does not prevent them from st...
Read more

Intune: Configure Printers for Non-Administrative Users

-
Image
Configuring printers for end users or giving them the ability to do it themselves is a normal requirement for organizations. Now if your users are Administrators, then the configuration can be straight forward, but in case of Non-Administrators there are additional steps required as Non-Administrators will not be able to add a driver in the driver store despite being able to install a printer. In this blog, I will cover the steps that I took to address this requirement using Intune. The setup involves 2 steps -  1. Setup registries. 2. Install the driver and configure the printer Setting up registries – The registries that need to be configured are actually part of a GPO setting – Allow non-administrators to install drivers for these device setup classes It can be found under: Computer Configuration -> Policies -> Administrative Templates -> System -> Driver Installation I used a Powershell script to set the values and wrapped it in a Win32 application. $P...
Read more