[GH-ISSUE #1042] BUG: Autopilot import csv #553

Closed
opened 2026-03-02 12:43:11 +03:00 by kerem · 5 comments
Owner

Originally created by @jeroenraus on GitHub (Jul 27, 2022).
Original GitHub issue: https://github.com/KelvinTegelaar/CIPP/issues/1042

When we use the autopilot add device function and we use a csv file (Template downloaded from Microsoft) It won't show the device(s) it's going to upload. and it returns the following error
tenant.onmicrosoft.com: Failed to create autopilot devices. Response status code does not indicate success: 400 (Bad Request).

If we manually fill in the serial and hash from the csv it works, only with one issue It creates a group tag by itself if you leave it blank. see below
Created Autopilot devices group for tenant.onmicrosoft.com. Group ID is 23cacd44-1266-4948-b94d-8203a0d06661

Regards Jeroen

Originally created by @jeroenraus on GitHub (Jul 27, 2022). Original GitHub issue: https://github.com/KelvinTegelaar/CIPP/issues/1042 When we use the autopilot add device function and we use a csv file (Template downloaded from Microsoft) It won't show the device(s) it's going to upload. and it returns the following error tenant.onmicrosoft.com: Failed to create autopilot devices. Response status code does not indicate success: 400 (Bad Request). If we manually fill in the serial and hash from the csv it works, only with one issue It creates a group tag by itself if you leave it blank. see below Created Autopilot devices group for tenant.onmicrosoft.com. Group ID is 23cacd44-1266-4948-b94d-8203a0d06661 Regards Jeroen
kerem 2026-03-02 12:43:11 +03:00
Author
Owner

@KelvinTegelaar commented on GitHub (Jul 27, 2022):

You'll need to use the template that's in the partner portal, did you use that one? the issue is case sensitivity. :).

<!-- gh-comment-id:1196763240 --> @KelvinTegelaar commented on GitHub (Jul 27, 2022): You'll need to use the template that's in the partner portal, did you use that one? the issue is case sensitivity. :).
Author
Owner

@jeroenraus commented on GitHub (Jul 27, 2022):

Yes, I used that one. The problem I guess is the import rule is empty when selecting the csv see screenshot

@.***

@.***
Met vriendelijke groet,​​​
Jeroen

Raus
CCT Engineer (teamleider)
@.***
@.https://www.linkedin.com/company/tredion-ict-&-telecom
@.
https://twitter.com/tredion
@.https://www.facebook.com/TredionICTenTelecom
@.
https://www.youtube.com/channel/UCB1IJPVVaklzLSivZBo8etw
telefoon
e‑mail
​adres
+31 183610550
@.@.>
Avelingen‑West 11
​4202 MS Gorinchem

Disclaimer: Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is uitsluitend bestemd voor de geadresseerde. ​Als u dit bericht per abuis hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te informeren. ​Wij adviseren u om bij twijfel over de juistheid of de volledigheid van de e-mail contact met de afzender op te nemen.

Van: KelvinTegelaar @.>
Verzonden: woensdag 27 juli 2022 15:28
Aan: KelvinTegelaar/CIPP @.
>
CC: Jeroen Raus | Tredion @.>; Author @.>
Onderwerp: Re: [KelvinTegelaar/CIPP] BUG: Autopilot import csv (Issue #1042)

You'll need to use the template that's in the partner portal, did you use that one? the issue is case sensitivity. :).


Reply to this email directly, view it on GitHubhttps://github.com/KelvinTegelaar/CIPP/issues/1042#issuecomment-1196763240, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AL3YLTF4FK5OUIMMEQU4YN3VWE2NTANCNFSM54ZTJATQ.
You are receiving this because you authored the thread.Message ID: @.@.>>

Dit document is geclassificeerd als: Voor vertrouwde partijen.

<!-- gh-comment-id:1196766948 --> @jeroenraus commented on GitHub (Jul 27, 2022): Yes, I used that one. The problem I guess is the import rule is empty when selecting the csv see screenshot ***@***.*** ***@***.*** Met vriendelijke groet,​​​ Jeroen Raus CCT Engineer (teamleider) ***@***.*** ***@***.***<https://www.linkedin.com/company/tredion-ict-&-telecom> ***@***.***<https://twitter.com/tredion> ***@***.***<https://www.facebook.com/TredionICTenTelecom> ***@***.***<https://www.youtube.com/channel/UCB1IJPVVaklzLSivZBo8etw> telefoon e‑mail ​adres +31 183610550 ***@***.******@***.***> Avelingen‑West 11 ​4202 MS Gorinchem Disclaimer: Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is uitsluitend bestemd voor de geadresseerde. ​Als u dit bericht per abuis hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te informeren. ​Wij adviseren u om bij twijfel over de juistheid of de volledigheid van de e-mail contact met de afzender op te nemen. Van: KelvinTegelaar ***@***.***> Verzonden: woensdag 27 juli 2022 15:28 Aan: KelvinTegelaar/CIPP ***@***.***> CC: Jeroen Raus | Tredion ***@***.***>; Author ***@***.***> Onderwerp: Re: [KelvinTegelaar/CIPP] BUG: Autopilot import csv (Issue #1042) You'll need to use the template that's in the partner portal, did you use that one? the issue is case sensitivity. :). — Reply to this email directly, view it on GitHub<https://github.com/KelvinTegelaar/CIPP/issues/1042#issuecomment-1196763240>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AL3YLTF4FK5OUIMMEQU4YN3VWE2NTANCNFSM54ZTJATQ>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>> Dit document is geclassificeerd als: Voor vertrouwde partijen.
Author
Owner

@KelvinTegelaar commented on GitHub (Jul 27, 2022):

Hi Jeroen, there was no screenshot included but I'm pretty sure you're using the wrong file. Using the included partner portal template I get the following result:
image

Just to be sure I also attached MS's template. Its important when creating this file yourself to use the same file as a template and make sure the headers are set correctly. They are case sensitive.

Device serial number,Windows product ID,Hardware hash,Manufacturer name,Device Model
<!-- gh-comment-id:1197187975 --> @KelvinTegelaar commented on GitHub (Jul 27, 2022): Hi Jeroen, there was no screenshot included but I'm pretty sure you're using the wrong file. Using the included partner portal template I get the following result: ![image](https://user-images.githubusercontent.com/49186168/181344888-61a41b05-f4a4-4495-80de-a35195bde584.png) Just to be sure I also attached MS's template. Its important when creating this file yourself to use the same file as a template and make sure the headers are set correctly. They are case sensitive. ```csv Device serial number,Windows product ID,Hardware hash,Manufacturer name,Device Model ```
Author
Owner

@jeroenraus commented on GitHub (Jul 28, 2022):

Goodmorning (Goedemorgen) Kelvin,

The link you provided isn’t working. It’s all scrambled up. I attached my file and my screenshot as attachment maybe that helps. Otherwise, you can mail me directly.

@.***
Met vriendelijke groet,​​​
Jeroen

Raus
CCT Engineer (teamleider)
@.***
@.https://www.linkedin.com/company/tredion-ict-&-telecom
@.
https://twitter.com/tredion
@.https://www.facebook.com/TredionICTenTelecom
@.
https://www.youtube.com/channel/UCB1IJPVVaklzLSivZBo8etw
telefoon
e‑mail
​adres
+31 183610550
@.@.>
Avelingen‑West 11
​4202 MS Gorinchem

Disclaimer: Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is uitsluitend bestemd voor de geadresseerde. ​Als u dit bericht per abuis hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te informeren. ​Wij adviseren u om bij twijfel over de juistheid of de volledigheid van de e-mail contact met de afzender op te nemen.

Van: KelvinTegelaar @.>
Verzonden: woensdag 27 juli 2022 20:25
Aan: KelvinTegelaar/CIPP @.
>
CC: Jeroen Raus | Tredion @.>; Author @.>
Onderwerp: Re: [KelvinTegelaar/CIPP] BUG: Autopilot import csv (Issue #1042)

Hi Jeroen, there was no screenshot included but I'm pretty sure you're using the wrong file. Using the included partner portal template I get the following result:
[image]https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fuser-images.githubusercontent.com%2f49186168%2f181344888-61a41b05-f4a4-4495-80de-a35195bde584.png&c=E,1,KOQ3B64IP_xyw-KEfO6RlQkbpJVFCJVFIXYzmykwgO2NWePj-w1HNLS7AngDmaGuRf-FGMnnVn5T_cgnksRqzG4SifsaMDZm426PVUXf6zgU&typo=1

Just to be sure I also attached MS's template. Its important when creating this file yourself to use the same file as a template and make sure the headers are set correctly. They are case sensitive.

[data:text/csv;charset=utf-8,%EF%BB%BFDevice serial number,Windows product ID,Hardware hash,Manufacturer name,Device Model%0AR9-ZNP67,,,,,%0A,123451234567,,,,%0A,,T0FzAQEAHAAAAAoA6AOCOgEABgBgW7EdzorHH3g,,,%0A,,,,,%0A,,,,,%0A,,,,,%0ASAMPLE EXPLAINED (remove the following section before uploading),,,,,%0ALine 2 illustrates the tuple - Providing the Serial Number and Manufacturer Name and Device Model together,,,,,%0ALine 3 illustrates only providing the Windows PKID,,,,,%0ALine 4 illustrates only providing the Hardware Hash,,,,,%0A


Reply to this email directly, view it on GitHubhttps://github.com/KelvinTegelaar/CIPP/issues/1042#issuecomment-1197187975, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AL3YLTC3NASNTKUKLFZOVYTVWF5HZANCNFSM54ZTJATQ.
You are receiving this because you authored the thread.Message ID: @.@.>>

Dit document is geclassificeerd als: Voor vertrouwde partijen.

<!-- gh-comment-id:1197750319 --> @jeroenraus commented on GitHub (Jul 28, 2022): Goodmorning (Goedemorgen) Kelvin, The link you provided isn’t working. It’s all scrambled up. I attached my file and my screenshot as attachment maybe that helps. Otherwise, you can mail me directly. ***@***.*** Met vriendelijke groet,​​​ Jeroen Raus CCT Engineer (teamleider) ***@***.*** ***@***.***<https://www.linkedin.com/company/tredion-ict-&-telecom> ***@***.***<https://twitter.com/tredion> ***@***.***<https://www.facebook.com/TredionICTenTelecom> ***@***.***<https://www.youtube.com/channel/UCB1IJPVVaklzLSivZBo8etw> telefoon e‑mail ​adres +31 183610550 ***@***.******@***.***> Avelingen‑West 11 ​4202 MS Gorinchem Disclaimer: Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is uitsluitend bestemd voor de geadresseerde. ​Als u dit bericht per abuis hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te informeren. ​Wij adviseren u om bij twijfel over de juistheid of de volledigheid van de e-mail contact met de afzender op te nemen. Van: KelvinTegelaar ***@***.***> Verzonden: woensdag 27 juli 2022 20:25 Aan: KelvinTegelaar/CIPP ***@***.***> CC: Jeroen Raus | Tredion ***@***.***>; Author ***@***.***> Onderwerp: Re: [KelvinTegelaar/CIPP] BUG: Autopilot import csv (Issue #1042) Hi Jeroen, there was no screenshot included but I'm pretty sure you're using the wrong file. Using the included partner portal template I get the following result: [image]<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fuser-images.githubusercontent.com%2f49186168%2f181344888-61a41b05-f4a4-4495-80de-a35195bde584.png&c=E,1,KOQ3B64IP_xyw-KEfO6RlQkbpJVFCJVFIXYzmykwgO2NWePj-w1HNLS7AngDmaGuRf-FGMnnVn5T_cgnksRqzG4SifsaMDZm426PVUXf6zgU&typo=1> Just to be sure I also attached MS's template. Its important when creating this file yourself to use the same file as a template and make sure the headers are set correctly. They are case sensitive. [data:text/csv;charset=utf-8,%EF%BB%BFDevice serial number,Windows product ID,Hardware hash,Manufacturer name,Device Model%0AR9-ZNP67,,,,,%0A,123451234567,,,,%0A,,T0FzAQEAHAAAAAoA6AOCOgEABgBgW7EdzorHH3g,,,%0A,,,,,%0A,,,,,%0A,,,,,%0ASAMPLE EXPLAINED (remove the following section before uploading),,,,,%0ALine 2 illustrates the tuple - Providing the Serial Number and Manufacturer Name and Device Model together,,,,,%0ALine 3 illustrates only providing the Windows PKID,,,,,%0ALine 4 illustrates only providing the Hardware Hash,,,,,%0A<url> — Reply to this email directly, view it on GitHub<https://github.com/KelvinTegelaar/CIPP/issues/1042#issuecomment-1197187975>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AL3YLTC3NASNTKUKLFZOVYTVWF5HZANCNFSM54ZTJATQ>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>> Dit document is geclassificeerd als: Voor vertrouwde partijen.
Author
Owner

@KelvinTegelaar commented on GitHub (Jul 28, 2022):

I recommend checking the github post and not the email :) email formatting can get weird. As this functionality is working there's no bug. Issue closed

<!-- gh-comment-id:1197755010 --> @KelvinTegelaar commented on GitHub (Jul 28, 2022): I recommend checking the github post and not the email :) email formatting can get weird. As this functionality is working there's no bug. Issue closed
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/CIPP#553
No description provided.