Powerful tool for working with XML & JSON files

Tips, Tricks and Scripts to enhance your home automation and workaround known device bugs, limitations and incompatibilities
Post Reply
User avatar
kambis
Posts: 36
Joined: 23 Jun 2014 08:06
Location: Germany
Contact:

Powerful tool for working with XML & JSON files

Post by kambis » 01 Jul 2014 14:41

During my studies to understand Z-Way I came to the point to search for a tool making my life easier while dealing with XML and JSON files. I found one tool very useful: The "XML Maker" from http://symbolclick.com/.

I can now easily parse into JSON and XML files and edit them as needed. One fantastic feature for me was to get easily and fast a table view of my actual devices in the network with all their data. For me it was so exiting, that I like to share it. Here the steps:

1. Download & Install the XML Maker http://symbolclick.com/xmlmarker_2_2_setup.exe

2. Go to your web browser and retrieve your actual device list from RaZberry. Use this command:

Code: Select all

http://IP_of_your_RaZberry:8083/ZWaveAPI/Run/devices
Note: Don't forget to replace the string <IP_of_your_RaZberry> with your actual RaZberry IP address!
The result will be something like this:
20140701 - get device list.png
20140701 - get device list.png (41.15 KiB) Viewed 10520 times
3. Now Copy the full content into the clipboard using Cntrl+a and then Cntrl+c keys.

4. Start the XML application and create a new JSON file over the menu: File --> New Json
Now click into the windows which says: (To start, type your JASON here or open existing file.) and then paste the data from clipboard into this window using Cntrl+v key. Then you should see something like this:
20140701 - create json file in xml maker.png
20140701 - create json file in xml maker.png (90.7 KiB) Viewed 10520 times
5. Now use the keys Cntrl+i or from the menu select Navigate --> Indent to format the data with line feeds.

6. Click on TreeView and enjoy reading, searching or editing the data. You can save and convert into xml and json. Here a bigger screenshot of how this could look like:
20140701 - Screenshot of Zway devices.png
20140701 - Screenshot of Zway devices.png (181.74 KiB) Viewed 10520 times
Enjoy by moving around in the data using the arrow keys.
8-)

User avatar
PoltoS
Posts: 4339
Joined: 26 Jan 2011 19:36

Re: Powerful tool for working with XML & JSON files

Post by PoltoS » 08 Jul 2014 11:02

There is a plug-in for Chrome called JSONFormatter ;)

pz1
Posts: 2053
Joined: 08 Apr 2012 13:44

Re: Powerful tool for working with XML & JSON files

Post by pz1 » 08 Jul 2014 11:29

There is a plug-in for Notepad++ called JSON viewer
Since 29-12-2016 I am no longer a moderator for this forum

islipfd19
Posts: 126
Joined: 07 Jul 2014 03:35

Re: Powerful tool for working with XML & JSON files

Post by islipfd19 » 06 Aug 2014 03:33

I found a great website that helps you build json files http://www.jsoneditoronline.org/. It helped me build my latest module, I posted it here: viewtopic.php?f=3424&t=20594.

Post Reply