Is anyone aware of a way to export the IFS navigator to for example Excel?
Solved
Export navigator to excel
Best answer by Darius Gafron
Hi Jur,
unzip the GZ-File, open Excel → File open → choose the Navigator.xml. You will get it in this Format:
Is this helpful?
Best regards,
Darius
+3The navigator is a compressed xml (xml.gz) file in the client folder on the MWS.
You need 7 zip or equivalent to uncompress it but I’m not sure how you would then get it in to Excel in a friendly format. Hope this helps.
PeteShakespeare wrote:
The navigator is a compressed xml (xml.gz) file in the client folder on the MWS.
You need 7 zip or equivalent to uncompress it but I’m not sure how you would then get it in to Excel in a friendly format. Hope this helps.
Thanks for your response. I’m aware of this XML existing but I haven’t been able to get it into a friendly format. 
Hi Jur,
unzip the GZ-File, open Excel → File open → choose the Navigator.xml. You will get it in this Format:
Is this helpful?
Best regards,
Darius
/Darius
1 person likes this
+1M1SS Melissa Imsirovic wrote:
I have this
However do not have 7 ZIP
maybe this is my issue :(
Hi.
Probably solved the issue, but it looks like you try to open the compressed file. You need to exctract it before you do the import. I have not tried it yet, but i would recommend to use Power Query (part of Excel) where you could manipulate the import file.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.