TeamSite 6.5
OpenDeploy 6.0.2
Windows 2003 Server
Oracle 10g (on Linux Server)
When deploying a nested replicant, DataDeploy correctly deploys my root table row and my replicant rows, however, it will not deploy (at all) my nested replicant rows.
----------------------------
----------------------------
----------------------------
----------------------------
----------------------------
Database logic
handset
OID: varchar(255) Key field
Active: varchar(255)
replicant:
OID: varchar(255) Foriegn Key from handset
GUID: varchar(255) Primary key
nested replicant:
type: varchar(255) Primary Key
path: varchar(255)
GUID: varchar(255) Foriegn Key from replicant
OID: varchar(255) Foriegn Key from replicant
Note: I have tried with and without this field
If I have this field in place, then my replicant has the
OID column set to be part of the primary key.
----------------------------
----------------------------
----------------------------
----------------------------
----------------------------
DCT:
-----
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE data-capture-requirements SYSTEM "datacapture6.0.dtd">
<data-capture-requirements type="content" name="handset">
<ruleset name="dct">
<script language="javascript" location="template-type" src="form.js"/>
<root-container location="handset" name="handset">
<item name="offering" pathid="offering" rowcontinue="t">
<label>Offering</label>
<description>Product Offering</description>
<select required="t">
<inline command="C:\Interwoven\TeamSite\iw-perl\bin\iwperl.exe C:\Interwoven\TeamSite\local\bin\DB_Query.ipl" />
</select>
</item>
<item name="active" pathid="active" rowcontinue="f">
<label>Offering Active Flag</label>
<description>Offering Active Flag</description>
<radio required="t">
<option label="Active" value="active" selected="t"/>
<option label="Inactive" value="inactive"/>
</radio>
</item>
<container name="replicant" location="replicant" min="0" max="unbounded" default="0" combination="and">
<label>replicant</label>
<item name="GUID" pathid="GUID" rowcontinue="f">
<label>GUID</label>
<description>GUID</description>
<text required="t" size="53" >
<inline command="C:\Interwoven\TeamSite\iw-perl\bin\iwperl.exe C:\Interwoven\TeamSite\local\bin\GUIDgen.ipl" />
</text>
</item>
<container name="nestedreplicant" location="nestedreplicant" min="0" max="unbounded" default="0" combination="and">
<item name="type" pathid="type" rowcontinue="t">
<label>Type</label>
<description>Type</description>
<text required="t" size="53" />
</item>
<item name="path" pathid="path" rowcontinue="f">
<label>Path</label>
<description>Path</description>
<text required="t" size="53" />
</item>
</container>
</container>
</root-container>
</ruleset>
</data-capture-requirements>
----------------------------
----------------------------
----------------------------
----------------------------
----------------------------
----------------------------
----------------------------
Datadeploy Config File:
----------------------------
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<data-deploy-configuration>
<data-deploy-elements filepath="C:\Interwoven\OpenDeployNG\etc\database.xml" />
<client>
<deployment name="deployment">
<source>
<teamsite-templating-records custom="yes" options="wide" area="/default/main/Internet/IDE/WORKAREA/Content">
<path name="templatedata/item/handset/data" visit-directory = "deep" />
</teamsite-templating-records>
</source>
<destinations>
<database use = "ide-cms-cmspreview-oracle-db" update-type="standalone" delete-tracker="yes">
<dbschema>
<group name="handset" table="handset" root-group="yes">
<attrmap>
<column name="offering" data-type="VARCHAR2(255)" value-from-element="handset/0/offering/0" allows-null="no" is-url="no"/>
<column name="active" data-type="VARCHAR2(255)" value-from-element="handset/0/active/0" allows-null="yes" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="offering"/>
</primary-key>
</keys>
</group>
<group name="replicant" table="replicant" root-group="no">
<attrmap>
<column name="GUID" data-type="VARCHAR2(255)" value-from-element="handset/0/replicant/[0-50]/GUID/0" allows-null="no" is-url="no" is-replicant="yes" />
<column name="offering" data-type="VARCHAR2(255)" value-from-element="handset/0/offering/0" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="GUID"/>
<key-column name="offering"/>
</primary-key>
<foreign-key parent-group="handset">
<column-pair parent-column="offering" child-column="offering"/>
</foreign-key>
</keys>
</group>
<group name="nestedreplicant" table="nestedreplicant" root-group="no">
<attrmap>
<column name="type" data-type="VARCHAR2(255)" value-from-element="handset/0/replicant/[0-50]/snippets/[0-50]/type/0" is-replicant="yes" allows-null="no" is-url="no"/>
<column name="path" data-type="VARCHAR2(255)" value-from-element="handset/0/replicant/[0-50]/snippets/[0-50]/path/0" is-replicant="yes" allows-null="yes" is-url="no"/>
<column name="GUID" data-type="VARCHAR2(255)" value-from-element="handset/0/replicant/[0-50]/GUID/0" is-replicant="yes" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="type"/>
<key-column name="GUID"/>
</primary-key>
<foreign-key parent-group="replicant">
<column-pair parent-column="GUID" child-column="GUID"/>
</foreign-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>
-------------------------------
E-Mail :
farnsaw@stonedoor.com
