Support > Forums > OpenBots Studio > DataRow in (text to set) is not acceptable.

DataRow in (text to set) is not acceptable.

Nishant sharma

  • Reporter
  • Calender Icon August 04,2021 at 7:23 PM

while using for each loop i added Output collection variable as vDataRow as Type DataRow which is not acceptable under Action Parameter the section Text to set do not accept/acknowledge {vDataRow.Emp ID}--> coming from DataTable vData. By any chance the version is unstable, because i had looked in tutorial videos its working fine i am using version 1.5.

Thanks in advance.

This forum has 172 topics, 459 replies, and was last updated 1 hours ago by Poornima Malv

Nataly Alvarado

  • Participant
  • Calender Icon August 06,2021 at 5:34 PM

Nishant,

OpenBots Studio v1.5.2 uses C# programming language syntax and formatting across all fields. For example, in order to extract a value from a datarow variable, you'll need to use the following C# expression:

vDataRow["Emp ID"]

If the cell value is not a string, you can convert it by using the following expression:

vDataRow["Emp ID"].ToString()

Also, keep in mind that strings should be concatenated using C# rules as well. For instance:

"this is a hardcoded string " + vData

Let me know if you have further questions!

Nishant sharma

  • Participant
  • Calender Icon August 06,2021 at 4:31 PM

Hello Nataly, i am using version OpenBotsStudio_v1.5.2.exe and the format says |"data" || vData || vOutputVariable| "data" works fine. in case of VOutputVariable as {vDataRow.Emp ID} from Excel it is not accepting and the box flashes in red. i am stuck.

Nataly Alvarado

  • Participant
  • Calender Icon August 05,2021 at 6:16 PM

Hi Nishant,

which version of Studio are you using? The input format will vary depending on the version, since updates where included after v1.5.0.

Nishant sharma

  • Participant
  • Calender Icon August 05,2021 at 7:10 AM

i am woking on FrontEnd, and it is in openbot.exe. need a viable solution. this is the latest version after 1.5.2 need support

Jan Renec

  • Participant
  • Calender Icon August 04,2021 at 8:49 PM

In version 1.5.1 I have


"$type": "OpenBots.Core.Script.ScriptAction, OpenBots.Core",
      "ScriptCommand": {
        "$type": "OpenBots.Commands.Loop.LoopCollectionCommand, OpenBots.Commands.Core",
        "v_LoopParameter": "vDataTable.Rows",
        "v_OutputUserVariableName": "vDataRow",
        "CommandName": "LoopCollectionCommand",
        "SelectionName": "Loop Collection",
  	...
      },

where type of vDatatable is DataTable VdataRow is DataRow

You are not authorized to reply, please click here to login and add your reply to this topic.