Massload IdResolve

[Raghavendra S]

Hi,
I am trying to add eSpot content using massloader utilities. I
can create content in the collateral and related tables, where
esmapobj .object_id is used as foreign key for collateral table.

I am using the following snippet generated by xmltransformer for
executing IdResolver.
<collateral
collateral_id="@temp_10001_@-2"
storeent_id="10001" colltype_id="1"
name="temp" />
<colldesc
collateral_id="@temp_10001_@-2"
language_id="-2"
marketingtext="&lt;li&gt;Temp"/>

<emspot emspot_id="@temp_10001_CONTENT"
storeent_id="10001" name="temp"
description="temp desc"
usagetype="CONTENT"/>

<esmapobj esmapobj_id="@temp_10001_2"
esmaptyp_id="2"
object_id="@temp_10001_@-2"/>

<intvsched intvsched_id="@intvsched_id"
initiative_id="@temp_10001_2"
emspot_id="@temp_10001_CONTENT"
startdate="2007-01-01 00:00:00.000000"
enddate="2099-01-01 00:00:00.000000"
priority="1" storeent_id="10001"/>

<atchtgt atchtgt_id="@10001_@-1000"
storeent_id="10001"
member_id="-1000"
identifier="1"
markfordelete="0"/>

<atchrel object_id="@temp_10001_-2"
atchrel_id="@temp_10001_@-***@10001_@-1000"
atchobjtyp_id="4"
atchtgt_id="@10001_@-1000"
atchrlus_id="4"
sequence="0"/>

<atchast atchast_id="@10001_@-1000_10001"
storeent_id="10001"
atchtgt_id="@10001_@-1000"
atchastpath="Attachments/dummyfile.txt"
directorypath="Attachments"
mimetype="text/plain"/>

and the output after executing idResolver is:

<collateral
COLLATERAL_ID="10510"
STOREENT_ID="10001"
COLLTYPE_ID="1"
NAME="temp"
/>
<colldesc
COLLATERAL_ID="10510"
LANGUAGE_ID="-2"
MARKETINGTEXT="&lt;li&gt;Temp"
/>
<emspot
EMSPOT_ID="10510"
STOREENT_ID="10001"
NAME="temp"
DESCRIPTION="temp desc"
USAGETYPE="CONTENT"
/>
<esmapobj
ESMAPOBJ_ID="10510"
ESMAPTYP_ID="2"
OBJECT_ID="10510"
/>
<intvsched
INTVSCHED_ID="10510"
INITIATIVE_ID="10510"
EMSPOT_ID="10510"
STARTDATE="2007-01-01 00:00:00.000000"
ENDDATE="2099-01-01 00:00:00.000000"
PRIORITY="1"
STOREENT_ID="10001"
/>
<atchtgt
ATCHTGT_ID="1451"
STOREENT_ID="10001"
MEMBER_ID="-1000"
IDENTIFIER="1"
MARKFORDELETE="0"
/>
<atchrel
OBJECT_ID="@temp_10001_-2"
ATCHREL_ID="1351"
ATCHOBJTYP_ID="4"
ATCHTGT_ID="1451"
ATCHRLUS_ID="4"
SEQUENCE="0"
/>
<atchast
ATCHAST_ID="1401"
STOREENT_ID="10001"
ATCHTGT_ID="1451"
ATCHASTPATH="Attachments/dummyfile.txt"
DIRECTORYPATH="Attachments"
MIMETYPE="text/plain"
/>

here, object_id is not getting resolved. since there is no constraint
on atchrel.OBJECT_ID, it is not getting resolved. At the same time
esmapobj.OBJECT_ID is getting resolved with the same variable. I don't
want to have any constraints to be added for atchrel.OBJECT_ID,
because it is not required to get referenced always. Please suggest me
if there is any solution.

Thanks
Raghavendra S

[Az]

ping me on my personal ID, will tell u how to fix this issue :)
whats up going man....work wise r u OK :)) enjoying D...M..

Post by Raghavendra S
Hi,
I am trying to add eSpot content using massloader utilities. I
can create content in the collateral and related tables, where
esmapobj .object_id is used as foreign key for collateral table.
I am using the following snippet generated by xmltransformer for
executing IdResolver.
<collateral
storeent_id="10001" colltype_id="1"
name="temp" />
<colldesc
language_id="-2"
storeent_id="10001" name="temp"
description="temp desc"
usagetype="CONTENT"/>
esmaptyp_id="2"
startdate="2007-01-01 00:00:00.000000"
enddate="2099-01-01 00:00:00.000000"
priority="1" storeent_id="10001"/>
storeent_id="10001"
member_id="-1000"
identifier="1"
markfordelete="0"/>
atchobjtyp_id="4"
atchrlus_id="4"
sequence="0"/>
storeent_id="10001"
atchastpath="Attachments/dummyfile.txt"
directorypath="Attachments"
mimetype="text/plain"/>
<collateral
COLLATERAL_ID="10510"
STOREENT_ID="10001"
COLLTYPE_ID="1"
NAME="temp"
/>
<colldesc
COLLATERAL_ID="10510"
LANGUAGE_ID="-2"
/>
<emspot
EMSPOT_ID="10510"
STOREENT_ID="10001"
NAME="temp"
DESCRIPTION="temp desc"
USAGETYPE="CONTENT"
/>
<esmapobj
ESMAPOBJ_ID="10510"
ESMAPTYP_ID="2"
OBJECT_ID="10510"
/>
<intvsched
INTVSCHED_ID="10510"
INITIATIVE_ID="10510"
EMSPOT_ID="10510"
STARTDATE="2007-01-01 00:00:00.000000"
ENDDATE="2099-01-01 00:00:00.000000"
PRIORITY="1"
STOREENT_ID="10001"
/>
<atchtgt
ATCHTGT_ID="1451"
STOREENT_ID="10001"
MEMBER_ID="-1000"
IDENTIFIER="1"
MARKFORDELETE="0"
/>
<atchrel
ATCHREL_ID="1351"
ATCHOBJTYP_ID="4"
ATCHTGT_ID="1451"
ATCHRLUS_ID="4"
SEQUENCE="0"
/>
<atchast
ATCHAST_ID="1401"
STOREENT_ID="10001"
ATCHTGT_ID="1451"
ATCHASTPATH="Attachments/dummyfile.txt"
DIRECTORYPATH="Attachments"
MIMETYPE="text/plain"
/>
here, object_id is not getting resolved. since there is no constraint
on atchrel.OBJECT_ID, it is not getting resolved. At the same time
esmapobj.OBJECT_ID is getting resolved with the same variable. I don't
want to have any constraints to be added for atchrel.OBJECT_ID,
because it is not required to get referenced always. Please suggest me
if there is any solution.
Thanks
Raghavendra S