Showing results 1 to 6 of 6

Thread: creating a table in zenon

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    20.03.2017
    Posts
    8

    Default creating a table in zenon

    Hi all,

    I would like to ask you for some help. How can I create a table (spread list) with configurable columns (let's say it should look like the fragment of a table from Excel) in zenon? What kind of action should I take to do it? I'm a beginner user of zenon so many things aren't obvious for me...
    thanks for your help!
    Last edited by lmucha : 24th April 2017 at 10:27

  2. #2
    Join Date
    06.02.2012
    Posts
    72

    Default Re: creating a table in zenon

    Hi lmucha,

    welcome to the COPA-DATA Forum and thanks for your question!
    I would like to ask which functionality you want to have in this list? Would you like to display archived data? Do you want to change values of variables? Or simplay display process data?

    You may give us a small explenation!

    Cheers,
    Xandi

  3. #3
    Join Date
    20.03.2017
    Posts
    8

    Default Re: creating a table in zenon

    Hello Xandi,

    thank you very much for your reply. 

    I want to display process data but with specific functionality. I'm receiving string variables from Oracle database via ZGW-SQL (SQL Online) module in following format: “AAA;BBB;CCC;DDD”. I want to present those variables in spread-list (excel like) with scroll bar if necessary and possibility to select one line and do some action with it. For example: we get four variables:
     
    Variable1 = “23452;A1;D2;350”
    Variable2 = “14584;B2;D2;100”
    Variable3 = “77632;A2;D1;350”
    Variable4 = “34820;A1;D1;620”
     
    Now we want to present them like this:
     

     
    Then we select line 3 and click some button. Pressing button we need to know that we have Variable3 selected. Variable format like “AAA;BBB;CCC;DDD” is just example. We can control it so we may change it freely. We tried to adjust Variable Diagnosis functionality but it is way too simple for us.

    cheers,
    Łukasz
    Attached Thumbnails Attached Thumbnails tabela.png  

  4. #4
    Join Date
    06.02.2012
    Posts
    72

    Default Re: creating a table in zenon

    Dear Łukasz,

    thanks for your specific explenation.
    A direct connection from zenon to Excel is not supported anymore. We would have the DDE Driver but this Windows connection protocol is very old fashioned and not recommended anymore.
    I had a try few weeks ago with zenon Version 7.50 and Excel 2013 and I didn't get a communication running. It looks like Microsoft canceled such possibilities with newer Excel versions.

    I would suggest you to take a closer look to our three reporting possibilities.

    - Report Generator
    - Report Viewer
    - zenon Analyzer

    Serveral informations and the possibilities can be found in the documentation and on our homepage directly.

    You can also get in contact with your responsible sales department to get several informations.

    Cheers,
    Xandi

  5. #5
    Join Date
    20.03.2017
    Posts
    8

    Default Re: creating a table in zenon

    Hello Xandi, 

    thank you very much for your reply. Actually I managed this problem creating the tables (spreads) as I wanted using Blend for Visual Studio (with WPF elements). I have connection with Oracle Database, you can see it below:



    Now the question is if it is possible to add extra functions like remove or copy the selected item from the table. Do you have any idea how I could do it? 

    Thanks in advance for your help.

    cheers,
    Łukasz 



    Attached Thumbnails Attached Thumbnails spread1.PNG  

  6. #6
    Join Date
    09.06.2018
    Posts
    1

    Default Re: creating a table in zenon

    Really helpful, Joined from Sydney Australia.
    Buy Maxwell and Williams https://www.aushoppinghub.com/brand/maxwell-williams/ Online Australia.

Similar Threads

  1. Display archived data in table
    By yolovs in forum zenon Supervisor
    Replies: 1
    Last Post: 4th July 2013, 03:15
  2. Recipe table
    By scadavmesnik in forum zenon Supervisor
    Replies: 1
    Last Post: 6th August 2012, 23:20
  3. Replies: 0
    Last Post: 11th March 2010, 15:59
  4. Language Table Keywords and VBA
    By jhines in forum VBA
    Replies: 2
    Last Post: 18th September 2008, 14:52
  5. rapidly creating Zenon functions using import/export
    By mattsd in forum zenon Supervisor
    Replies: 3
    Last Post: 10th January 2008, 10:20

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •