innovaphone Forum

You are here

Help with Search (new window)
Picture of Gabriele 1254
Registered 12 years 59 days
Gabriele 1254 Friday, 5 February 2021, 09:18 AM
PBX Export XML to Excel
Exporting a pbx.xml file and importing it on Excel many parameters are not imported like CFU, Groups, Fork. It is very useful for getting an overview of the system.

Anyone know some Excel settings that permit to import all the informations?
Or any other way to make "readeable" a pbx.xml file?

Thanks ammiccante
Picture of Achim 1648
Registered 11 years 225 days
Achim 1648 Thursday, 11 February 2021, 02:01 PM
Re: PBX Export XML to Excel
Hi,

i'm facing the same problem. Import to Excel is not the best way because some Elements have Child-Elements like Keys and so on. If you do an import to Excel you will have many rows for the same user, because i.e. the Keys are placed in the same column.

The imho only way to get readable Data is to import the xml-data into a sql-database with multiple tables, like user, keys, group,cf and so on with the guid as index in all tables.

Greetings,

Achim
Picture of Benjamin
Registered 14 years 60 days
Benjamin Tuesday, 16 February 2021, 02:41 PM in response to Gabriele 1254
1 of 1 users consider this post helpful
Re: PBX Export XML to Excel
Hi Gabriele,

in case you don't need the features of a spreadsheet application, then maybe notepad++ might do the trick for you.
It should be able to identify the file as xml, and highlight the entries accordingly. For a more readable layout, you could use the plugin XML tools, and switch the view to Pretty print [Ctrl+Alt+Shift+A] or Pretty print (indent attributes) [Ctrl+Alt+Shift+A].


Kind regards,
Benjamin
← You can define your color theme preference here