Extreme Networks

DeVoID · ‎02-07-2023

HI,

Here is a question about when i export the device management device list in XIQ.

So im in the XIQ interface >> Devices. I click on download, and get a .csv file. When i open the .csv file in Excel i have noticed that there are a lot of MAC addresses that are messed up. Like this export/download (ive erased some of the info obviously):

No matter what you change the cell to (number, text, etc), they stay messed up. I really needed a few MAC addresses for some troubleshooting, and figured the best way is to download the device list. Well, i got lucky with some of the MAC addresses, they were not messed up, but i had a handful that i needed and instead of being able to use the .csv file, i had to go back into XIQ, highlight and copy it. When i tried to paste it into Excel it messed it up again, so i had to paste it into a text file instead.

Whats going on? and is this fixable?

thanks much,

Jason.

wwillingham · ‎01-04-2024

I know this is an old thread, but I came across this when searching for something else and thought I would provide the solution for anyone else that may come across this. The issue is in how Excel handles what appears to it to be very large numbers. This is because the default formatting of cells is set to General. The work around to this to change the formatting of the cell from General to Text. The easy way to do this is instead of directly opening the csv file with Excel, open Excel first and then import the csv. When you import the csv, you can change the needed column(s) to Text during import. I haven't had this issue with MACs before, but I have had to do this with serial numbers for years. Depending upon your version of Office and your preference, the process can be a little different. Older versions of Excel (2016 and older), you use the Text Import Wizard (which I prefer). Newer versions (365 and 2019 and newer), you can re-enable the Legacy Text Import Wizard or use the new Power Query.

View solution in original post

Christoph_S · ‎02-07-2023

Hello Jason,

Please try opening the same file in Notepad++, do you still encounter this issue?

Tested it in Notepad++ and all formatting previously seen in Excel was removed. Should even work with basic notepad.

BR

Christoph S.

DeVoID · ‎02-10-2023

Hi,

No problem if I open them in Notepad++

But it would be better to have non-messed up data in Excel, so i can manipulate the data.

Any idea's?

Jason.

Extreme Networks

Devicemanagement-Devicelist download

Devicemanagement-Devicelist download