Skip to main content
Question

To use comma in variable of WorkspaceRunner

  • Mar 31, 2017 2:50 PM UTC
  • 10 replies
  • 86 views

Forum|alt.badge.img

Hello, would be glad to find the solution: to use comma in variable by WorkspaceRunner. For example, i have Mainprozess and subprozess. In mainprozess will be define: what IDs will be needed. And after in subprozess i Need by dataimport to Import only the data with these ID's (to Import all data takes too much time). So i need to write Comma in the WorkspaceRunner, like this:

obj_id in {'1000000000000106996011','1000000000000118176003'}

But this statement does not work as i needed. Do u have some ideas? Greetings, Anna

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

10 replies

erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • Mar 31, 2017 3:00 PM UTC

Have you tried embedding the value in double quotes:

"obj_id in {'1000000000000106996011','1000000000000118176003'}"


Forum|alt.badge.img
  • Author
  • Mar 31, 2017 3:09 PM UTC

Have you tried embedding the value in double quotes:

"obj_id in {'1000000000000106996011','1000000000000118176003'}"

Hi Erik, i tried but does not work. In LOG is for this case to see:

 

--WHERE_LTG' `obj_idin{'1000000000000106996011'' `--'1000000000000118176003'}'

 

 


david_r
Celebrity
  • Apr 3, 2017 6:36 AM UTC

Can confirm this issue, I suspect it's a bug. Can be reproduced by inserting a WorkspaceRunner into your workspace and hardcoding a comma-separated list in a parameter, e.g.

Close the dialog and re-open it, notice how the parameter has been truncated at the comma:

Surrounding the parameter values with double quotes doesn't help. Tested with FME 2017.0.

Can someone from Safe please confirm?


ebygomm
Evangelist
Forum|alt.badge.img+54
  • Evangelist
  • Apr 3, 2017 8:35 AM UTC

Forum|alt.badge.img
  • Author
  • Apr 3, 2017 1:07 PM UTC

fmelizard
Safer
Forum|alt.badge.img+22
  • Safer
  • Apr 11, 2017 5:42 PM UTC

Hi @greenroze. Please change the Type of the parameter in the child workspace from Text to Text (Multiline), then open the WorkspaceRunner in the parent workspace and re-choose the child workspace. This should fix the problem.

Setting the parameter to Text (Multiline) ensures that it is encoded when passed to the workspace being run, which is called using a command line. This prevents common delimiters from affecting the command line.


Forum|alt.badge.img
  • May 6, 2017 9:04 PM UTC

Hi @greenroze. Please change the Type of the parameter in the child workspace from Text to Text (Multiline), then open the WorkspaceRunner in the parent workspace and re-choose the child workspace. This should fix the problem.

Setting the parameter to Text (Multiline) ensures that it is encoded when passed to the workspace being run, which is called using a command line. This prevents common delimiters from affecting the command line.

Hi Natalie,

 

I tried same steps, but when i am trying to pass value `137665494,142465377', whereas it is passing '137665494<comma>142465377' resulting in child workspace failing.

 

 


oscard
Influencer
Forum|alt.badge.img+23
  • Influencer
  • Sep 21, 2017 10:17 AM UTC

Same error here using FME 2017.0. I have attached a simple workspace that shows it.

testworkspace.zip

This looks like a bug to me. Where can it be reported?


david_r
Celebrity
  • Sep 21, 2017 1:41 PM UTC

Same error here using FME 2017.0. I have attached a simple workspace that shows it.

testworkspace.zip

This looks like a bug to me. Where can it be reported?

Unfortunately this bug is also still present in FME 2018.0 Beta. @NatalieAtSafe: can you please check what the status is for this issue?

Forum|alt.badge.img

Same issue here regardless of resetting FME Workspace (child). Settings in parent workspace follow.

log outputs:

WorkspaceRunner: {C:/Program Files/FME/fme} //tfs.internal/shared/GIS/ESRIData/Scripts/FME/Server/vineyards.fmw --MAX 15000 --WhereClause fru_code<space>IN<space><openparen><apos>FEZ003BU<apos><comma><apos>FEZ004BU<apos><closeparen> >NUL: <NUL: 2>@1 &

Child: