Data Drive Loop: text checkpoint problem
Hi everyone,
we are having trouble setting a check point in a textbox containing some text that has a strange formatting.
Te use case is like that, we have a tab with different text boxes and a tab with this strange text, changing something on one of the textboxes change a part of this text.
So we recorded a test in which we are changing something on one of those textboxes and then we created a checkpoint on this object containing the final text.
The checkpoint it's self is working good. The problem is when we are trying to create dataloop.
The text of the test in the final object is something like this:
%A.Name = "%A"
%B.Name = "%B"
%C.Name = "%C"
%D.Name = "%D"
GradientFrequencyMode = LFM
Pressure.LowerLimit = 200 [bar]
Pressure.UpperLimit = 400 [bar]
0.000 PumpFlow.Nominal = 0.000 [ml/min]
%B.Nominal = 0.0 [%]
%C.Nominal = 0.0 [%]
%D.Nominal = 0.0 [%]
Event1 = Off
Event2 = Off
Event3 = Off
Event4 = Off
End
(Notice the tabulator at the begginning of each line, and an escape charater after the "End")
To create the data drive loop we create an excel file with two colums, one contains only the "lowerpressure limit" and the other one the whole text. The first column is used to change the value of that textbox the second column is used in the final checkpoint. It's not working because excel is changing the formatting of the text and so the text is always failing.
We tried also an access table but you cannot end a field with an escape character.
We cannot use a csv file because of the escapes.
Anyone knows how to solve this?
Thanks!
we are having trouble setting a check point in a textbox containing some text that has a strange formatting.
Te use case is like that, we have a tab with different text boxes and a tab with this strange text, changing something on one of the textboxes change a part of this text.
So we recorded a test in which we are changing something on one of those textboxes and then we created a checkpoint on this object containing the final text.
The checkpoint it's self is working good. The problem is when we are trying to create dataloop.
The text of the test in the final object is something like this:
%A.Name = "%A"
%B.Name = "%B"
%C.Name = "%C"
%D.Name = "%D"
GradientFrequencyMode = LFM
Pressure.LowerLimit = 200 [bar]
Pressure.UpperLimit = 400 [bar]
0.000 PumpFlow.Nominal = 0.000 [ml/min]
%B.Nominal = 0.0 [%]
%C.Nominal = 0.0 [%]
%D.Nominal = 0.0 [%]
Event1 = Off
Event2 = Off
Event3 = Off
Event4 = Off
End
(Notice the tabulator at the begginning of each line, and an escape charater after the "End")
To create the data drive loop we create an excel file with two colums, one contains only the "lowerpressure limit" and the other one the whole text. The first column is used to change the value of that textbox the second column is used in the final checkpoint. It's not working because excel is changing the formatting of the text and so the text is always failing.
We tried also an access table but you cannot end a field with an escape character.
We cannot use a csv file because of the escapes.
Anyone knows how to solve this?
Thanks!