Skip to main content
Solved

Is there a way to store attribute references in text that is stored in another attribute

M

Got a situation where I would like the store attribute values, @Value(attribute_name), in some HTML code which itself is stored in a SQL table. The idea is that the @Value(attribute_name) will be different for each of our clients, sending them a personalised email based on their own data.

imageimageCurrently FME reads the table in and keeps everything as plain text, @Value(attribute_name) does not get replaced with the appropiate attribute value. Is there a way to get FME to recognise the attribute names in the HTML code and replace it with the appropiate attribute values?

 

if I copy and paste the HTML code into atttributecreator then it works as expected, however we would like to manage all this in SQL server - saving us having to update the workbench everytime there is a change required to the HTML

 

Thanks

Best answer by takashi

michaelz wrote:

Hi @Takashi Iijima​ that is precisely what I’m after 

Thank you for confirmation.

A possible way I can think of is, extract pairs of "@Value(attribute name)" and "attribute name" as list attributes from the string literal with StringSearcher, and replace expression "@Value(attribute name)" with the value of an attribute called "attribute name" using a Python script (PythonCaller).

 

For example, if the input feature has attributes "html", "client_name", and "insight_id", and the "html" contains an HTML template containing the expressions "@Value(client_name)" and "@Value(insight_id)", the workflow looks like this.

evaluate_at_value_function 

StringSearcher setting:

  • Search In: html
  • Contains Regular Expression: @Value\((.+?)\)
  • Case Sensitive: Yes
  • All Matches List Name: _all
  • Subexpression Matches List Name: _sub

 

PythonCaller script setting:

import fme
import fmeobjects
 
class FeatureProcessor(object):
    def __init__(self):
        pass
 
    def input(self, feature):
        html = feature.getAttribute('html')
        expr = feature.getAttribute('_all{}.match')
        attr = feature.getAttribute('_sub{}.part')
        for e, a in zip(expr, attr):
            html = html.replace(e, str(feature.getAttribute(a)))
        feature.setAttribute('html', html)
        self.pyoutput(feature)
 
    def close(self):
        pass

 

View original
Did this help you find an answer to your question?

5 replies

takashi
Influencer
  • takashiInfluencer
  • November 8, 2023

Hi @michaelz​ ,

Do you mean that a string literal like <p>@Value(insight_id)</p> is stored in a column of a DB record, and FME will read it then should replace with <p>123</p> if "insight_id" attribute stores 123 at run time?

M
  • michaelz
  • Author
  • November 8, 2023
takashi wrote:

Hi @michaelz​ ,

Do you mean that a string literal like <p>@Value(insight_id)</p> is stored in a column of a DB record, and FME will read it then should replace with <p>123</p> if "insight_id" attribute stores 123 at run time?

Hi @Takashi Iijima​ that is precisely what I’m after

takashi
Influencer
  • takashiInfluencer
  • Best Answer
  • November 8, 2023
michaelz wrote:

Hi @Takashi Iijima​ that is precisely what I’m after 

Thank you for confirmation.

A possible way I can think of is, extract pairs of "@Value(attribute name)" and "attribute name" as list attributes from the string literal with StringSearcher, and replace expression "@Value(attribute name)" with the value of an attribute called "attribute name" using a Python script (PythonCaller).

 

For example, if the input feature has attributes "html", "client_name", and "insight_id", and the "html" contains an HTML template containing the expressions "@Value(client_name)" and "@Value(insight_id)", the workflow looks like this.

evaluate_at_value_function 

StringSearcher setting:

  • Search In: html
  • Contains Regular Expression: @Value\((.+?)\)
  • Case Sensitive: Yes
  • All Matches List Name: _all
  • Subexpression Matches List Name: _sub

 

PythonCaller script setting:

import fme
import fmeobjects
 
class FeatureProcessor(object):
    def __init__(self):
        pass
 
    def input(self, feature):
        html = feature.getAttribute('html')
        expr = feature.getAttribute('_all{}.match')
        attr = feature.getAttribute('_sub{}.part')
        for e, a in zip(expr, attr):
            html = html.replace(e, str(feature.getAttribute(a)))
        feature.setAttribute('html', html)
        self.pyoutput(feature)
 
    def close(self):
        pass

 

geomancer
Evangelist
Forum|alt.badge.img+48
  • geomancerEvangelist
  • Evangelist
  • November 8, 2023
michaelz wrote:

Hi @Takashi Iijima​ that is precisely what I’m after

Alternatively, this is a nice use case for the AttributeDereferencer.

imageThe StringSearcher uses a regex subexpression to get the attribute name 'insight_id' in _SubResults{0}.part

I tried using StringReplacers or a StringPairReplacer, as it would make the process more clear, but the presence of '@Value' in the literal string makes it difficult to use those transformers.

M
  • michaelz
  • Author
  • November 8, 2023
michaelz wrote:

Hi @Takashi Iijima​ that is precisely what I’m after

Thanks @Takashi Iijima​ works perfectly 😁

Reply


Helpful Members This Week

Community Stats

31,325
Posts
118,843
Replies
38,954
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.