Reading archive data

[DavidMarek]

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

[johannes.foidl]

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

[DavidMarek]

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

[alexf]

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

[DavidMarek]

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

[alexf]

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

[DavidMarek]

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

[alexf]

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

[DavidMarek]

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