more quick actions
minimize quick actions
12.0
5
Posts
2
Users
0
Likes
27
Views
Topic starter
Hi all
Thinking about new Excel functions in AA expression, I ask me a question about synchronization.
If I use Excel function in order to address variable in AA (I look for each variable address in my excel file). If the mapping/Excel file is updated I think I have to do a Full synchronisation in order to recalculate each address which could have been updated... a fast synchronisation will not work because no update on the template
If application is running full synchronization is for me not a good idea so how to do this ?
An option like "recalculate only expression with Excel function" or something like that could be a solution....
What do you think about it ?
Posted : 12/07/2018 3:06 pm
Hi Nico P,
Yes it could be a good idea.
It reminds me that we have quite the reverse in AA settings:
- Skip reference calculation for generation
Nico
Posted : 13/07/2018 8:52 am
Topic starter
Hi all,
i did a trial, and the result is :
- if the Excel file have no changes, so if i do a synchronization there is no change for any properties.
- If the Excel file have changes, so after a fast synchronization properties are synchronize.
So it means that, by default, the recalculation is done if the file is updated. Is it really a good idea?
For now, i never understand how this AA expression detect that the file is updated without restart PcVue (is there a timer ? because sometimes it works whitout restart). For this trial, i restart PcVue.
Posted : 13/07/2018 6:04 pm
OK let me explain how it is supposed to work. First of all the behavior you have described is normal. That's the behavior by default.
Check out the Advanced tab / Allow usage section of the file reference object
To understand, the question is: When the file is loaded/unloaded?
By default, it is loaded on memory during pcvue startup and unloaded on pcvue stop. That means any changes done in the file is not taken in account.
This behavior is used when you know that your file will never change during the runtime.
But if it is more dynamic then you need to switch in another mode: "Load on call"
Using this mode you can specify when to unload it. The best is to use "after a delay". 10mn is the minimum.
Nico
Posted : 18/07/2018 8:23 am
Topic starter
Thanks for theses explanations, specially about the reference file.
Posted : 18/07/2018 11:59 am