Skip to content

Instantly share code, notes, and snippets.

@newbish

newbish/KM_IKM_File_Copy.xml

Created February 18, 2016 20:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save newbish/306311842d40b2ea2828 to your computer and use it in GitHub Desktop.
Save newbish/306311842d40b2ea2828 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
KM_IKM_File_Copy.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<SunopsisExport>
<Admin RepositoryVersion="04.03.04.02" />
<Object class="com.sunopsis.dwg.dbobj.SnpTrt">
<Field name="ExtVersion" type="java.lang.String">null</Field>
<Field name="FirstDate" type="java.sql.Timestamp"><![CDATA[2016-02-18 11:37:37.0]]></Field>
<Field name="FirstUser" type="java.lang.String"><![CDATA[SUPERVISOR]]></Field>
<Field name="IndChange" type="java.lang.String"><![CDATA[U]]></Field>
<Field name="IndJrnMethod" type="java.lang.String"><![CDATA[S]]></Field>
<Field name="IndSuppSetBased" type="java.lang.String">null</Field>
<Field name="IntVersion" type="com.sunopsis.sql.DbInt"><![CDATA[24]]></Field>
<Field name="IFolder" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="IProject" type="com.sunopsis.sql.DbInt"><![CDATA[1600]]></Field>
<Field name="IScBaseTrt" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="IScOrigTrt" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="IScTrt" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="IState" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="ITrt" type="com.sunopsis.sql.DbInt"><![CDATA[20600]]></Field>
<Field name="ITxtTrtTxt" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="KimMultiDserver" type="java.lang.String"><![CDATA[1]]></Field>
<Field name="KmDefault" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KmSrcTechno" type="java.lang.String"><![CDATA[FILE]]></Field>
<Field name="KmTechno" type="java.lang.String"><![CDATA[FILE]]></Field>
<Field name="KmVersion" type="java.lang.String">null</Field>
<Field name="LastDate" type="java.sql.Timestamp"><![CDATA[2016-02-18 13:28:00.0]]></Field>
<Field name="LastUser" type="java.lang.String"><![CDATA[SUPERVISOR]]></Field>
<Field name="LChecksum" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="LCode" type="java.lang.String">null</Field>
<Field name="OrdFolder" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="TrtName" type="java.lang.String"><![CDATA[IKM File Copy]]></Field>
<Field name="TrtType" type="java.lang.String"><![CDATA[KI]]></Field>
<Field name="VLastDate" type="java.sql.Timestamp">null</Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpLineTrt">
<Field name="AlwaysExe" type="java.lang.String"><![CDATA[1]]></Field>
<Field name="ColConnectId" type="java.lang.String">null</Field>
<Field name="ColContextCode" type="java.lang.String">null</Field>
<Field name="ColIndCommit" type="java.lang.String">null</Field>
<Field name="ColIsolLevel" type="java.lang.String">null</Field>
<Field name="ColITxt" type="com.sunopsis.sql.DbInt"><![CDATA[null]]></Field>
<Field name="ColLschemaName" type="java.lang.String">null</Field>
<Field name="ColPlanComp" type="java.lang.String">null</Field>
<Field name="ColTechno" type="java.lang.String">null</Field>
<Field name="DefConnectId" type="java.lang.String">null</Field>
<Field name="DefContextCode" type="java.lang.String">null</Field>
<Field name="DefIndCommit" type="java.lang.String">null</Field>
<Field name="DefIsolLevel" type="java.lang.String">null</Field>
<Field name="DefITxt" type="com.sunopsis.sql.DbInt"><![CDATA[3885600]]></Field>
<Field name="DefLschemaName" type="java.lang.String">null</Field>
<Field name="DefPlanComp" type="java.lang.String">null</Field>
<Field name="DefTechno" type="java.lang.String"><![CDATA[JYTHON]]></Field>
<Field name="FirstDate" type="java.sql.Timestamp"><![CDATA[2016-02-18 11:37:37.0]]></Field>
<Field name="FirstUser" type="java.lang.String"><![CDATA[SUPERVISOR]]></Field>
<Field name="IndErr" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="IndLogFinalCmd" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="IndLogMethod" type="java.lang.String">null</Field>
<Field name="IndLogNb" type="java.lang.String">null</Field>
<Field name="ITrt" type="com.sunopsis.sql.DbInt"><![CDATA[20600]]></Field>
<Field name="KcmAk" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KcmCond" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KcmErrDel" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KcmJoin" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KcmNull" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KcmPk" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KimDrvdSel" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KimIdx" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KimJrn" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KimJrnPop" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KjmCreate" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KjmDrop" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KjmExtend" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KjmLock" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KjmPurge" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KjmSetInstall" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KjmSetUninstall" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KjmSubscribe" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KjmTableOrder" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KjmUnlock" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KjmUnsubscribe" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KlmAfterInt" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KlmIdx" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KlmJrn" type="java.lang.String"><![CDATA[0]]></Field>
<Field name="KxmUsed" type="java.lang.String">null</Field>
<Field name="LastDate" type="java.sql.Timestamp"><![CDATA[2016-02-18 13:28:00.0]]></Field>
<Field name="LastUser" type="java.lang.String"><![CDATA[SUPERVISOR]]></Field>
<Field name="LogLevDet" type="java.lang.String"><![CDATA[3]]></Field>
<Field name="OrdTrt" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="SqlName" type="java.lang.String"><![CDATA[Copy File]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader">
<Field name="Enc" type="java.lang.String">null</Field>
<Field name="EncKey" type="java.lang.String">null</Field>
<Field name="ITxt" type="com.sunopsis.sql.DbInt"><![CDATA[3885600]]></Field>
<Field name="ITxtOrig" type="com.sunopsis.sql.DbInt"><![CDATA[102]]></Field>
<Field name="SqlIndGrp" type="java.lang.String"><![CDATA[2]]></Field>
<Field name="Txt" type="java.lang.String"><![CDATA[import os
import java.sql as sql
import java.lang as lang
import shutil
def getPath(path, item):
path = path.strip()
if path[len(path) - 1:] == "\\":
path = path[:len(path) - 1]
if item[:1] == "\\":
item = item[1:]
return os.path.join(path, item)
source = getPath(r"<%=odiRef.getSrcTablesList("", "[SCHEMA]", "", "") %> ", r"<%=odiRef.getSrcTablesList("", "[RES_NAME]", "", "") %>")
target = getPath(r"<%=odiRef.getTargetTable("SCHEMA")%> ", "<%=odiRef.getTargetTable("RES_NAME")%>")
shutil.copy(source, target)]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt">
<Field name="ITxtOrig" type="com.sunopsis.sql.DbInt"><![CDATA[102]]></Field>
<Field name="OrigineName" type="java.lang.String"><![CDATA[Target Technology]]></Field>
<Field name="SnpsCol" type="java.lang.String"><![CDATA[DEF_I_TXT]]></Field>
<Field name="SnpsTable" type="java.lang.String"><![CDATA[SNP_LINE_TRT]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[17]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1385665062489]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[501]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1407279974667]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[51]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1328567837345]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[13]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1294363114297]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[20]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1296199087891]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[11]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1256325751748]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[14]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1312409775474]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[12]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1287505566875]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[200]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1327347601978]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[1]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1328300234530]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[16]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1332534803552]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[15]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1332534721527]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[201]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1331751599144]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[600]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1441906700579]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[605]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1442436307520]]></Field>
</Object>
<Object class="com.sunopsis.dwg.dbobj.SnpImportRep">
<Field name="RepShortId" type="com.sunopsis.sql.DbInt"><![CDATA[608]]></Field>
<Field name="RepTimestamp" type="java.lang.String"><![CDATA[1442932063581]]></Field>
</Object>
<Object class="com.sunopsis.dwg.DwgExportSummary">
<Field name="ExpTxtNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="InstObjNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="JoinColNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="JoinNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="KeyColNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="KeyNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="LinkDiagNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="MorigTxtNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="MtxtNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="OrigTxtNb" type="com.sunopsis.sql.DbInt"><![CDATA[1]]></Field>
<Field name="OtherObjectsNb" type="com.sunopsis.sql.DbInt"><![CDATA[2]]></Field>
<Field name="PlanAgentNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="StepNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="TxtNb" type="com.sunopsis.sql.DbInt"><![CDATA[1]]></Field>
<Field name="UeOrigNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="UeUsedNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="VarPlanAgentNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="ScenTxtNb" type="com.sunopsis.sql.DbInt"><![CDATA[0]]></Field>
<Field name="OdiVersion" type="java.lang.String"><![CDATA[11.1.1.7.0 - 02/03/2013]]></Field>
<Field name="OriginRepositoryID" type="com.sunopsis.sql.DbInt"><![CDATA[600]]></Field>
<Field name="RepositoryVersion" type="java.lang.String"><![CDATA[04.03.04.02]]></Field>
</Object>
</SunopsisExport>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment