Home

[BUG] Cannot Import Shared Connection List by CSV File

%3CLINGO-SUB%20id%3D%22lingo-sub-461015%22%20slang%3D%22en-US%22%3E%5BBUG%5D%20Cannot%20Import%20Shared%20Connection%20List%20by%20CSV%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-461015%22%20slang%3D%22en-US%22%3E%3CP%3EOn%20the%20Shared%20Connections%20page%2C%20attempts%20to%20import%20the%20CSV%20file%20exported%20by%20PowerShell%20will%20not%20work...%20the%20generated%20CSV%20file%20will%20produce%200%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20if%20I%20rename%20the%20file%20to%20TXT%2C%20it%20will%20import%20a%20line-separated%20list%20successfully...%20but%20I%20still%20have%20to%20reformat%20the%20original%20CSV%20to%20produce%20that%20line%20format.%20Simply%20renaming%20the%20CSV%20to%20TXT%20will%20import%20an%20improperly%20formatted%20list%20of%20servers%20that%20includes%20all%20the%20tags.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20such%2C%20there%20seems%20to%20be%20no%20way%20of%20exporting%20a%20list%20of%20servers%20PLUS%20tags%20and%20importing%20it%20back%20into%20the%20Shared%20Connections%20list.%20Importing%20into%20individual%20list%20by%20PowerShell%20DOES%20work...%20haven't%20tried%20from%20portal.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-461090%22%20slang%3D%22en-US%22%3ERE%3A%20%5BBUG%5D%20Cannot%20Import%20Shared%20Connection%20List%20by%20CSV%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-461090%22%20slang%3D%22en-US%22%3ESide%20note...%20why%20isn't%20there%20a%20Powershell%20cmdlet%20to%20import%20a%20shared%20connection%20list%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-476646%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20%5BBUG%5D%20Cannot%20Import%20Shared%20Connection%20List%20by%20CSV%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-476646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F213604%22%20target%3D%22_blank%22%3E%40Aaron%20Hall%3C%2FA%3E%26nbsp%3BThe%20csv%20file%20that%20is%20created%20with%20the%20PowerShell%20export%20is%20not%20compatible%20with%20%22choose%20a%20list%20of%20server%20names%20to%20import%22%20in%20the%20UI.%26nbsp%3BI%20can%20see%20how%20this%20can%20be%20misleading%20--%20I've%20added%20a%20note%20to%20clarify%20this%20in%20the%20next%20documentation%20revision.%26nbsp%3B%26nbsp%3BThe%20csv%20files%20created%20by%20the%20PowerShell%20export%20are%20intended%20for%20use%20with%20the%20corresponding%20PowerShell%20import%20function.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20manage%20the%20shared%20connections%20using%20the%20PowerShell%20import%2Fexport%2C%20use%20the%20value%20'global'%20in%20the%20last%20column%20(groupId)%20-%20this%20was%20recently%20added%20to%20the%20documentation%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fwindows-server%2Fmanage%2Fwindows-admin-center%2Fuse%2Fget-started%23csv-file-format-for-importing-connections%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECSV%20file%20format%20for%20importing%20connections%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-481924%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20%5BBUG%5D%20Cannot%20Import%20Shared%20Connection%20List%20by%20CSV%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481924%22%20slang%3D%22en-US%22%3EAppreciate%20the%20response%2C%20but%20yes%2C%20it's%20extremely%20misleading%20and%20frankly%20a%20pretty%20poor%20design%20choice.%20The%20Import%2FExport%20functions%20should%20really%20be%20the%20same%20whether%20in%20the%20GUI%20or%20PS...%20seems%20like%20a%20logical%20way%20to%20keep%20a%20consistent%20experience%20AND%20code%20base.%3C%2FLINGO-BODY%3E
Aaron Hall
Occasional Contributor

On the Shared Connections page, attempts to import the CSV file exported by PowerShell will not work... the generated CSV file will produce 0 results.

 

However, if I rename the file to TXT, it will import a line-separated list successfully... but I still have to reformat the original CSV to produce that line format. Simply renaming the CSV to TXT will import an improperly formatted list of servers that includes all the tags.

 

As such, there seems to be no way of exporting a list of servers PLUS tags and importing it back into the Shared Connections list. Importing into individual list by PowerShell DOES work... haven't tried from portal.

3 Replies
Side note... why isn't there a Powershell cmdlet to import a shared connection list?

@Aaron Hall The csv file that is created with the PowerShell export is not compatible with "choose a list of server names to import" in the UI. I can see how this can be misleading -- I've added a note to clarify this in the next documentation revision.  The csv files created by the PowerShell export are intended for use with the corresponding PowerShell import function.

 

To manage the shared connections using the PowerShell import/export, use the value 'global' in the last column (groupId) - this was recently added to the documentation: CSV file format for importing connections.

Appreciate the response, but yes, it's extremely misleading and frankly a pretty poor design choice. The Import/Export functions should really be the same whether in the GUI or PS... seems like a logical way to keep a consistent experience AND code base.
Related Conversations