Showing results 1 to 9 of 9

Thread: Reading archive data

  1. #1
    Join Date
    29.01.2016
    Posts
    19

    Default Reading archive data

    Hello.

    Can I read data form archive server? I have data in archive server in .arx format, but if it si some problem I can set on dBase or CSV.

    Thank you

  2. #2
    Join Date
    18.07.2011
    Posts
    136

    Default AW: Reading archive data

    Hi DavidMarek.

    You can chose if the historian should create arx, dbf, txt or XML files when creating the local archives. Only our internal format, arx can be used in zenon then.
    If you evacuate the archives you have again the same formats available plus evacuation to SQL database. SQL and arx evacuated data can be reused in zenon!

    You can then use the data in a Report or a trend. If you chose other file formats than arx or SQL evacuation you cannot reuse that data in zenon then.

    hope that helps!
    Johannes

  3. #3
    Join Date
    29.01.2016
    Posts
    19

    Default Re: AW: Reading archive data

    Hi johannes.foidl

    I know, that I can use archive data in reports,...

    But I want to know, if I can read data form archive again in zenon logic for example. I want to work with data in archive server.

    Thank you

  4. #4
    Join Date
    27.06.2011
    Posts
    96

    Default AW: Reading archive data

    Hello DavidMarek,

    I believe it is not possible to access single values from an archive with zenon logic. You can use the API to do that. Another way is to use Report Generator to copy archive values to a variable and then use this variable.

    kind regards,
    Alexander

     

     

     


  5. #5
    Join Date
    29.01.2016
    Posts
    19

    Default Re: AW: Reading archive data

    Thank you alexf for your answer.

    Could you send me how can I do that? I am trying Report Generator way, but it doesnt work for now. Could you show here how do that by first and second way(API)?

    Thank you

  6. #6
    Join Date
    27.06.2011
    Posts
    96

    Default AW: Reading archive data

    to be honest, I am not a specialost with the API. But for the report generator you need to
    1. create a report
    2. use the "archive" function to read the archive you are interested in (Manual -> Reporting -> Report Generator -> Engineering in the Editor -> Report functions -> Archive and logging functions -> archive)
    3. use the "variablerw" function to write a value from (2) into a varaible (Manual -> Reporting -> Report Generator -> Engineering in the Editor -> Report functions -> Other functions -> variablerw)
    4. create a screen and screenswitch function (includes the time filter)
    5. run the report in the runtime

    I hope I didn´t forget a step

    kind regards,
    Alex

     

     

     


  7. #7
    Join Date
    29.01.2016
    Posts
    19

    Default Re: AW: Reading archive data

    Thank you.

    I did it how you said. Reading archive is ok in report generator, but I Cant set the zenon logic variable. I have:

    =variablerw("JK_ZS/Global/ArchivniPromenna","value","write")

    it's ok, but I have 0 there. How Can I set this variable from archive?

    I can see value from archive, but how Can I get this value to =variablerw("JK_ZS/Global/ArchivniPromenna","value","write")

    Thank you

  8. #8
    Join Date
    27.06.2011
    Posts
    96

    Default AW: Re: AW: Reading archive data

    it seems you´re usign a wrong syntax.
    Look at the example at the very bottom of the help page. There you can see that the last parameter of the functino should not be "read" but the cell from which you want to take the value.

    =variablerw(variable name,"value",cell)
    Example: =variablerw("internal variable","value",A2)

    kind regards

     

     

     


  9. #9
    Join Date
    29.01.2016
    Posts
    19

    Default Re: AW: Re: AW: Reading archive data

    Thank you.

    Is this mean, that I can get just the first value from the variable of archive?

    One more question: Can I show time in report? For example: I have time in zenon logic and I show it in report. But in report I can see just seconds(120s). I dont want 120s, but I want 0H,2M,0S. Can I convert it in report?

    Thank you

Similar Threads

  1. Reading DB from S7-318
    By allyd in forum Drivers
    Replies: 1
    Last Post: 9th June 2015, 13:21
  2. Extended trend - archive data
    By kavya in forum zenon Supervisor
    Replies: 1
    Last Post: 12th May 2015, 07:41
  3. Get data from aggregated archive
    By yitlilee in forum zenon Supervisor
    Replies: 2
    Last Post: 13th June 2014, 07:05
  4. Reading Excel
    By navaneet in forum zenon Supervisor
    Replies: 1
    Last Post: 27th September 2013, 17:09
  5. Zenon archive issue (archive inactive)
    By eugenius in forum zenon Supervisor
    Replies: 9
    Last Post: 24th August 2012, 08:19

Tags for this Thread

Posting Rules

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