I have my parameter values in a SQLite table. I am able to access each value though a Python scripted parameter that opens the table and retrieves the value. However, this means that I have to open and close the SQL table one time for each parameter. Is there a way to make multiple parameters that can be read by the readers and transformers, perhaps in the Python startup script?
Solved
Create Multiple Parameters in Scripted Python Parameters
Best answer by takashi
Hack. You can define the dictionary as a global variable which can be accessed while FME is configuring user parameters. e.g.
First scripted (Python) parameter:
global a
a = {'ap':'apple','ba':'banana','ch':'cherry'}
return a['ap']
Second scripted (Python) parameter:
return a['ba']Third scripted (Python) parameter:
return a['ch']Note: A global variable defined in a scripted (Python) parameter can be used only in scripted (Python) parameters. It cannot be used in the Startup/Shutdown Python script, PythonCreator, and PythonCaller in the workspace.
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.
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.
Hi @jimo
you could create one helper Python scripted parameter that would carry e.g. comma separated values for all your parameters. Then every parameter would be a scripted parameter as well and would retrieve its part from the comma separated helper parameter value. Please find a very simplified example attached.
I get the concept. Now instead of returning a string from the helper scripted parameter, I can return a dictionary that I create from my SQLite query:
a = {'ap':'apple','ba':'banana','ch':'cherry'}
return aThen in the second scripted parameter I do an eval() on what is returned by the first scripted parameter to turn it back into a dictionary, then extract the key:
dictParam = eval(fme.macroValues['PARAM3'])
return dictParam["ap"]The value of PARAM4 is therefore "apple"!
I get the concept. Now instead of returning a string from the helper scripted parameter, I can return a dictionary that I create from my SQLite query:
a = {'ap':'apple','ba':'banana','ch':'cherry'}
return aThen in the second scripted parameter I do an eval() on what is returned by the first scripted parameter to turn it back into a dictionary, then extract the key:
dictParam = eval(fme.macroValues['PARAM3'])
return dictParam["ap"]The value of PARAM4 is therefore "apple"!
I get the concept. Now instead of returning a string from the helper scripted parameter, I can return a dictionary that I create from my SQLite query:
a = {'ap':'apple','ba':'banana','ch':'cherry'}
return aThen in the second scripted parameter I do an eval() on what is returned by the first scripted parameter to turn it back into a dictionary, then extract the key:
dictParam = eval(fme.macroValues['PARAM3'])
return dictParam["ap"]The value of PARAM4 is therefore "apple"!
- Best Answer
Hack. You can define the dictionary as a global variable which can be accessed while FME is configuring user parameters. e.g.
First scripted (Python) parameter:
global a
a = {'ap':'apple','ba':'banana','ch':'cherry'}
return a['ap']
Second scripted (Python) parameter:
return a['ba']Third scripted (Python) parameter:
return a['ch']Note: A global variable defined in a scripted (Python) parameter can be used only in scripted (Python) parameters. It cannot be used in the Startup/Shutdown Python script, PythonCreator, and PythonCaller in the workspace.
Hack. You can define the dictionary as a global variable which can be accessed while FME is configuring user parameters. e.g.
First scripted (Python) parameter:
global a
a = {'ap':'apple','ba':'banana','ch':'cherry'}
return a['ap']
Second scripted (Python) parameter:
return a['ba']Third scripted (Python) parameter:
return a['ch']Note: A global variable defined in a scripted (Python) parameter can be used only in scripted (Python) parameters. It cannot be used in the Startup/Shutdown Python script, PythonCreator, and PythonCaller in the workspace.
Hack. You can define the dictionary as a global variable which can be accessed while FME is configuring user parameters. e.g.
First scripted (Python) parameter:
global a
a = {'ap':'apple','ba':'banana','ch':'cherry'}
return a['ap']
Second scripted (Python) parameter:
return a['ba']Third scripted (Python) parameter:
return a['ch']Note: A global variable defined in a scripted (Python) parameter can be used only in scripted (Python) parameters. It cannot be used in the Startup/Shutdown Python script, PythonCreator, and PythonCaller in the workspace.