Import wojob def
From Agility
<?xml version="1.0" encoding="utf-8"?>
<import>
<mappings classname="Control.GeneralInterface.XMLFileImport">
<table name="JobList" xpath="/JobList/woJob">
<field name="JobCode" xpath="JobCode"></field>
<field name="Description" xpath="Description"></field>
<field name="JobStatus" xpath="JobStatus"></field>
<field name="JobType" xpath="JobType"></field>
<field name="JobPriority" xpath="JobPriority"></field>
<field name="AssetCode" xpath="AssetCode"></field>
<field name="Craft" xpath="Craft"></field>
<field name="StartDate" xpath="StartDate"></field>
<table name="JobTask" xpath="woJobTask">
<field name="TaskCode" xpath="TaskCode"></field>
<field name="TaskDescription" xpath="Description"></field>
<field name="TaskType" xpath="TaskType"></field>
<field name="TaskStatus" xpath="TaskStatus"></field>
</table>
</table>
</mappings>
<assign classname="Control.GeneralInterface.StandardImportProcessor">
<businessobject classname="DataBO.ProcessMngt.JobBO">
<table name="woJob" sourceTable="JobList">
<mode>
<add/>
</mode>
<set>
<field name="JobTypeID">Lookup("DataBO.SystemData.JobTypeBO","syJobType","Code",#Import.JobType,"JobTypeID")</field>
<field name="PriorityID">Lookup("DataBO.SystemData.PriorityBO","syPriority","Code",#Import.JobPriority,"PriorityID")</field>
<field name="JobStatusID">Lookup("DataBO.SystemData.JobStatusBO","syJobStatus","Code",#Import.JobStatus,"JobStatusID")</field>
<field name="AssetID">Lookup("DataBO.ProcessMngt.AssetBO","pmAsset","Code",#Import.AssetCode,"AssetID")</field>
<field name="CraftID">Lookup("DataBO.Employee.CraftBO","emCraft","CraftCode",#Import.Craft,"CraftID")</field>
<field name="FullDescription">#Import.Description</field>
</set>
</table>
</businessobject>
</assign>
<resultexport>
<contents>
<const>
<![CDATA[
"<?xml version='1.0' encoding='utf-8'?>
<JobList>
"]]> </const>
<foreach table="JobList" datacontext="mappings" classname="DataBO.ProcessMngt.JobBO"> <![CDATA[ "<woJob> <CreatedJobCode>" + XmlEncode(woJob.JobCode) + "</CreatedJobCode> <JobCode>" + XmlEncode(#Import.JobCode) + "</JobCode> </woJob> " ]]> </foreach>
<const> <![CDATA[ "</JobList> " ]]> </const>
</contents> </resultexport>
</import>