Documenting C-Bus Toolkit Projects

Discussion in 'General Discussion' started by Steve Laidler, Oct 31, 2006.

  1. Steve Laidler

    Steve Laidler

    Joined:
    Oct 31, 2006
    Messages:
    20
    Likes Received:
    0
    Greetings to the C-Bus community!

    I am looking for short cut / hacks in documenting C-Bus toolkit projects. I require a listing of addresses and Tag names. Rather than do this by manual data entry, I found I could open the projects C gate XML file, hack around with the formatting, dump a lot of garbage, and then end up with an Excel spreadsheet of addresses and tag names.

    I would now like to make a list of what devices control these addresses, and this data can be viewed from within toolkit by opening the applications groups 1 by 1 and viewing the dependency relationships - this gives a list of which switches / sensors etc have a control relationship with the group being viewed.

    Does anyone know if there is an easy way to generate a spreadsheet of control relationships versus application groups? Has anyone else used the CGate XML file for documentation and project reports? I noticed a lot of hex strings in the XML file, and will get around to seeing if deciphering these codes reveals the control relationships, unless anyone else has encountered the same issues and already found a way round this.

    Thanks folks!

    Steve Laidler / Ecosystems NZ
     
    Steve Laidler, Oct 31, 2006
    #1
  2. Steve Laidler

    daniel C-Busser Moderator

    Joined:
    Jul 26, 2004
    Messages:
    766
    Likes Received:
    20
    Location:
    Adelaide
    tutorials

    Hi Steve,

    As you can imagine there's a hundred ways to pull data out of the tag database.

    The following set of tutorials demonstrates one way, using standard XSLT technology.


    http://www.cbusforums.com/forums/showthread.php?t=300

    http://www.cbusforums.com/forums/showthread.php?t=448

    http://www.cbusforums.com/forums/showthread.php?t=834

    You can also import the XML into Access or Excel or as other users have done, write your own scripts or applications to parse the data.

    Please ensure you DON'T write data back to to the project tag database, as this can make our applications rather unhappy.

    cheers,
    Daniel
     
    daniel, Nov 1, 2006
    #2
  3. Steve Laidler

    Steve Laidler

    Joined:
    Oct 31, 2006
    Messages:
    20
    Likes Received:
    0
    Thanks Daniel

    Great to get such a fast response, thanks for the help!
     
    Steve Laidler, Nov 1, 2006
    #3
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.