Solved

Unable to use user parameter in user attribute name with Oracle Non spatial writer

  • 12 January 2018
  • 5 replies
  • 1 view
N

When I enter $(user_parameter) as user attribute name, it will be replaced to $_user_parameter_

icon

Best answer by takashi 13 January 2018, 00:20

View original

5 replies

N
Editing the XML fine directly works, but not a good solution.

 

 

fmelizard
Rank
Userlevel 4
Badge +13

 

Hi @nlaszlo1976, where are you setting this attribute up? On the Feature Type or earlier in the workspace with an AttributeManager?
takashi
Rank
Userlevel 2
Badge +17

Hi @nlaszlo1976, I guess you have entered it to the 'Name' column in the User Attributes tab in the Oracle writer feature type.

In the User Attributes tab in a writer feature type, you will have to define an attribute name with a literal string, cannot set it referring either a user parameter value or a feature attribute value.

FME Workbench considers the string you have entered as a field name literally. However, in the Oracle naming conventions, since brackets aren't allowed to be contained in a field name, FME Workbench has replaced them with underscores automatically.

N

Hi @nlaszlo1976, I guess you have entered it to the 'Name' column in the User Attributes tab in the Oracle writer feature type.

In the User Attributes tab in a writer feature type, you will have to define an attribute name with a literal string, cannot set it referring either a user parameter value or a feature attribute value.

FME Workbench considers the string you have entered as a field name literally. However, in the Oracle naming conventions, since brackets aren't allowed to be contained in a field name, FME Workbench has replaced them with underscores automatically.

Yes exactly. However I am also using version 2016.1 in another project that do not have this User Attribute "Name escaping" feature and work perfectly. This seems to be a new feature but unfortunately we have lost some others. Editing the XML directly by a text editor works. I attached two files: the one ending manedit is what I needed to do (direct XML editing and reopen) the one ending dialog what i get after doing the same in the write parameters dialog box.

 

calc-totalroadlength-dialog.fmw

 

calc-totalroadlength-dialog.fmw

 

 

takashi
Rank
Userlevel 2
Badge +17

Hi @nlaszlo1976, I guess you have entered it to the 'Name' column in the User Attributes tab in the Oracle writer feature type.

In the User Attributes tab in a writer feature type, you will have to define an attribute name with a literal string, cannot set it referring either a user parameter value or a feature attribute value.

FME Workbench considers the string you have entered as a field name literally. However, in the Oracle naming conventions, since brackets aren't allowed to be contained in a field name, FME Workbench has replaced them with underscores automatically.

Looks like the DatabaseUpdater transformer could be more suitable.

 

Alternatively, the SQLExecutor could also be used to execute an SQL (UPDATE) statement. I think you can construct an appropriate SQL statement using the values of the feature attributes and user parameters.

 

Reply


Community Stats

28,709
Posts
109,481
Replies
36,554
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.