Substitution not working for teamsite-extended-att

cliffhanger

Hi,
I am trying to convert the TeamSite path to URL.

Here's my DD config:

<?xml version="1.0"?>
<data-deploy-configuration>
<external-tuple-processor class-name="com.datadeploy.MktgPreProcess" interface-version="2.0" />
<data-deploy-elements filepath="/opt/datadeploy/conf/database.xml" />
<client>
<deployment name = "dd_keywords">
<source>
<!-- Pull data tuples from TeamSite Templating DCR's -->
<teamsite-extended-attributes
options = "differential,wide"
custom = "yes"
area = "/default/main/Mktg_US/STAGING"
base-area = "/default/main/Mktg_US/EDITION/INITIAL">
<path name = "templatedata/Content" visit-directory = "deep" />
</teamsite-extended-attributes >
</source>
<substitution>
<field name = "URL" match = "^(templatedata)/Content/(.*)/data.*/(\w*)\.dcr" replace = "sites/$2/$3.html"/>
</substitution>
<destinations>
<database use="IWUI"
update-type = "standalone"
delete-tracker = "yes"
log-level = "3"
real-update = "yes">

<dbschema>
<group name="pageKeywords" table="PAGE_METADATA" root-group="yes">
<attrmap>
<column name = "URL" data-type="VARCHAR2(500)" value-from-field="path" allows-null="no"/>
<column name="NAME" data-type="VARCHAR2(100)" value= "KEYWORDS" allows-null="no"/>
<column name="VALUE" data-type="VARCHAR2(2000)" value-from-field="TeamSite/Metadata/KEYWORDS" allows-null="no"/>
<column name = "SORT_ORDER" data-type="INTEGER" value="-1" allows-null="no" />

<column name = "TEAMSITE_PATH" data-type="VARCHAR2(500)" value-from-field="path" allows-null="no"/>
<column name="DATE_CREATED" data-type="DATE" value-from-field="TeamSite/Metadata/Creation_Date_Time" data-format="EEE MMM dd HH:mm:ss yyyy" allows-null="no" db-datetime-format="DY MON DD HH24:MIS YYYY" />
<column name="CREATED_BY" data-type="VARCHAR2(500)" value-from-field="TeamSite/Metadata/Creation_Who" allows-null="yes"/>
<column name="DATE_MODIFIED" data-type="DATE" value-from-field="TeamSite/Metadata/Update_Date_Time" data-format="EEE MMM dd HH:mm:ss yyyy" allows-null="yes" db-datetime-format="DY MON DD HH24:MIS YYYY"/>
<column name="MODIFIED_BY" data-type="VARCHAR2(500)" value-from-field="TeamSite/Metadata/Update_Who" allows-null="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="NAME"/>
<key-column name="URL"/>
<key-column name="SORT_ORDER"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

I don't see any reason for it not to work, but it's inserting TeamSite Path to URL column, meaning the subsitution rule is not taking effect.
Any idea, why?

Thanks!
-cliff

cliffhanger

Update:

if I change <field name = "URL" match = "^(templatedata)/Content/(.*)/data.*/(\w*)\.dcr" replace = "sites/$2/$3.html"/> to

<field name = "path" match = "^(templatedata)/Content/(.*)/data.*/(\w*)\.dcr" replace = "sites/$2/$3.html"/>, it substitutes the TeamSite_PATH with the URL. Problem is, I have two columns in the same table whose value-from-field=path.
So, apparently the problem is not with teamsite-extended-attributes, rather with <field name, which is not recognizing the column name when provided as field name.

I also tried <field name = "path" column="URL" match = "^(templatedata)/Content/(.*)/data.*/(\w*)\.dcr" replace = "sites/$2/$3.html"/>, that does not work either...

Any suggestion...?