查询的批量导出与导入-肖杰——

1、查询的批量导出与导入作者：肖杰 审校：林文杰测试系统：TeamcenterlO.1.5从查询构建器中只能单个导出和导入，当自定义查询太多时，占 用较多的时间进行查询的迁移。所以希望能够批量导出查询，然后批 量导入到正式系统中。首先使用导出命令，将查询批量导出：plmxml_export u = i nfodba -p=infodba -g=dba class=Ima nQuery xml_file=c:all_the_queries3.xmlo 如图 lo图1打开导出命令生成的xml文件可以看出所有系统查询和定制查询已经导出。如图2 , 3O了 害、4】读万卷书行万里路encodiryj-ut

2、f-8少P 1 (TJOQ JX13: FDOK1&J81M 8 打亦 8Mil,gciw“ttrs：plrxr.l fjj-*m：/vy.nlExnl .cr5chCFM/FWMlRH.*MM.*hcrvVF) s-hexav*ts 1 an-*6 ianquage-*en-ur date-r2D18-10-10 =n”20:36:49 auther-Teaabenter VI000D .1.0.3120160206.00 - mfodbaGINC E nn(l Tad Assignuents for a Resource Pool Aj51icacionRer vcr3icri-AmT3A

3、CJUxzTO ar pln,aal_fias：CpffryClai：3e id-id2* 3tring*/alue- SSUSCT qid rHH ResourceAisignncnt aHERZ (quot, ResourcePool:secondsryobcct.groupE Find Tad Asslanuentd for a Resource Pool AT?llcaUonRef veralen-AmTSAoanxzTD pllcax.loc-rTeacenUr, latelAbtTaAgaGxzTDx/Applicaclo-nRe nrwl Task Asslonoentd ror

4、 a Resource PooltT3Avaax2TD, 11 wLion-rTeacenUr loljel-rAm73Avjax27l,M/AppllcaDlonRef pln,joxl_lyjs:QperyClauae id-id6r 3tring,；alo*-*SBlJ5CT qid !TCH ResourceAjisignaent aHEHZ iquot:ResourcePool: secFind Schedule Task (s) AT?llcaUonRef veraleA4bt73CMOHxzTD applLcax.loc-rreaocenUr, laUel-mTSCManxzTD

5、x/AppUcaclonRe pln,xl_fcas：CperyClau3eatrirg*/aId*- SSLECT qid rFEN ScbeduleTask aHERZ fcquot .ScbeduleTaiMRemionfcltitanstag. InanRet Finds Active group xeobers for project adcinstration appXxcatJ.on use tT；alQ- SILECT qid FROM Grouptfeaber WHEP3 Srot;Grojp:groyp. r*a84iuot: - Souot;$ (Group -plmxr

6、l_bi：3:Sev*Dff3eripriD 2薑于斛轉扳本居性立询轴椁改本ECXPO2iFlL=ati.:aRe ver5L=a= ATWtLjdDJOxzTD* applicationsTeancenter* label=*AT-plzuxl_tua:Quexy21ause xd=*xdd0 szriaw;aLu= S2LEX2T qid FROM SS AccessorrRevision WHERE Irquot Sfl Accessory:xteas tag.Qb;ect_Deu _plmxi51_teQ8：SaveQkierr id-ldsr narrW外跖飯立咅泡queFldg-O

7、* -xaeilaaa-SSteourclngRevislon于外轴扳之膚性咅询外购版4：/ApplieationRef plmxrl_bc3：Qi3cry?lau3e id-*1482 strinff/aId*- SELECT qid PROM SQ_OutourcingRnnion UUER2 iquot:S6_Ojtiourcing: itfcitag.obec-plmxcl_tua:Sa,.,eoer/c i3=xdfl3* an=设备职水査询，3jezyf-.aa=*0 a jezC-as5=*S8 fXrJxpacntRcvisxcn S 于设备版 * 査诲设备版* 版 llcaL

8、lonRef ve rale in- AOTtLJdDOnxzTD ppllcacion-rTea0centerr ldbl-rAXHtlj(njirx2TDr plntxrl_hc3：Qi:eryTlau3e id-*id84 strman/aio*-*SELECT qid FROM S8_Zqxiipc*entRevision WHERE tquot:SB Bqnxipbent:lteati cag.object najLplmxrl_tee3：Sav*ff 于专阳工談典具悠；* flltffc 査逾专用工 S * A HR *li.=ati.:aRef vex5L=a= AXktLdl)

9、JUxzTD apFlication=TeaxiGentcr labcl=*A)atL：jdDJUxzTO X/3pl：cm：eplmxrl_buaiQueryClauae 11186” arlnlwe-SILECT qid FMK S3_SpecialTF6vi3ion WHH5E 6eclalTF: 1 te_tagobect_naj !plmxBl_teua：Savel于适用工袋央吕废本舄性査询遇用工諛夫具股本Xxcp。：ctL7dDJ0xzTO applicatio:-Teancenter label-rAXctL3dDJUxzllD*plnuxl_tu3: Query-lause i

10、.d=*xd88 sml-s=SZLCT qid FROM Sd UjuiversalTFRxsiOD kUEBB fciuot; S8_Unxvwr5alTF: itexs taa. obec -pluxl_bu3：SttVeO?ier7er I4=,id89r 加饯iAudit - arvatdz毗：Lou Sponsored Autbentlcation Lexis quxy?laa=,Or auex.Cl3srndOOrgai plnOT51_bQ3：QueryClot33e ilTd9(r 肌用15BLBCT qid nuJM rndOOroaniMtionAndit WBRE 4quot;objcct_narcsiuot: - squot;$-ob3 * 1 nT. XK.、/4O8fJHW itf R MS Jr cc r_ 1 CO C*V*%o 1 Vr然后使用导入命令，将查询批量导入：plmxmljmportu 二 in fodba p=infodba-g=dbaxml_file二c:all_the_queries3.