Toggle navigation

数据文件

Odoo是数据驱动的,因此模块定义的很大一部分是它管理的各种记录的定义:UI(菜单和视图),安全性(访问权限和访问规则),报告和普通数据都是通过记录定义的。

结构体

在Odoo中定义数据的主要方法是通过XML数据文件:XML数据文件的广泛结构如下:

  • 根元素odoo中的任意数量的操作元素
<!-- the root elements of the data file -->
<odoo>
  <operation/>
  ...
</odoo>

数据文件按顺序执行,操作只能参考先前定义的操作结果

核心操作

record

record适当地定义或更新数据库记录,它具有以下属性:

model (required)
要创建(或更新)的模型的名称
id

此记录的外部标识符 强烈建议提供一个

  • 对于记录创建,允许后续定义修改或引用此记录
  • 对于记录修改,要修改的记录
context
创建记录时使用的上下文
forcecreate

在更新模式下,是否应该创建记录(如果它不存在)

需要外部id,默认为True

field

每条记录都可以由field标记组成,定义创建记录时要设置的值。 没有fieldrecord将使用所有默认值(创建)或不执行任何操作(更新)。

field具有必需的name属性,要设置的字段的名称以及定义值本身的各种方法:

Nothing
如果没有为字段提供值,则将在字段上设置隐式False 可用于清除字段,或避免使用字段的默认值。
search

对于关系字段,应该是字段模型上的

将评估域,使用它搜索字段的模型,并将搜索结果设置为字段的值。 如果字段是Many2one,则仅使用第一个结果

ref

如果提供了ref属性,则其值必须是有效的外部标识,将其查找并设置为字段的值。

主要用于Many2oneReference字段

type

如果提供了type属性,则它用于解释和转换字段的内容。 字段的内容可以使用file属性通过外部文件提供,也可以通过节点的主体提供。

可用的类型有:

xml, html
field的子项作为单个文档提取,计算以%(external_id)s形式指定的任何external id%%可用于输出实际的符号。
file
确保字段内容是当前模型中的有效文件路径,将对模块路径保存为字段值
char
将字段内容直接设置为字段的值而不进行任何更改
base64
base64 - 对字段的内容进行编码,与文件 属性一起用于加载,例如将图像数据转换为附件
int
将字段的内容转换为整数并将其设置为字段的值
float
将字段的内容转换为浮点数并将其设置为字段的值
list, tuple
应包含任意数量的value元素,其属性与字段相同,每个元素解析为生成的元组或列表的项,生成的集合设置为字段的值
eval

对于以前的方法不适合的情况,eval属性只是评估它提供的任何Python表达式,并将结果设置为字段的值。

评估上下文包含各种模块(timedatetimetimedeltarelativedelta),一个解析的函数外部标识符ref)和当前字段的模型对象(如果适用)(obj

delete

delete标记可以删除先前定义的任意数量的记录。 它具有以下属性:

model (required)
应删除指定记录的模型
id
要删除的记录的外部标识
search
以查找要删除的模型的记录

idsearch是独立的

function

function标记使用提供的参数调用模型上的方法。 它有两个必需参数modelname,分别指定要调用的方法的模型和名称。

可以使用eval(应评估一系列参数来调用方法)或value元素(参见list值)来提供参数。

workflow

workflow标记向现有工作流发送信号。 可以通过ref属性(现有工作流的外部id)或标记指定工作流,返回工作流的ID。

标签还有两个必需属性model(链接到工作流的模型)和action(要发送到工作流的信号名称)。

快捷键

由于Odoo的一些重要结构模型很复杂且涉及,因此数据文件提供了使用记录标记定义它们的更短替代方法:

template

创建QWeb视图仅需要视图的arch部分,并允许一些可选属性:

id
视图的外部标识符
name, inherit_id, priority
ir.ui.view上相应的字段相同(nb:inherit_id应为外部标识符
primary
如果设置为True并与inherit_id组合,则将视图定义为主要
groups
逗号分隔的组外部标识符列表
page
如果设置为“True”,则模板为网站页面(可链接,可删除)
optional
启用禁用,是否可以禁用视图(在网站界面中)及其默认状态。 如果未设置,则始终启用视图。

report

使用一些默认值创建ir.actions.report.xml记录。

通常只是代理属性ir.actions.report.xml上的相应字段,但也会自动在More报告的菜单模型中创建项目。

CSV数据文件

XML数据文件具有灵活性和自描述性,但在批量创建同一模型的大量简单记录时非常冗长。

对于这种情况,数据文件也可以使用csv,这通常是访问权限的情况:

  • 文件名是model_name .csv
  • 第一行列出要写入的字段,外部标识符的特殊字段id(用于创建或更新)
  • 之后每行创建一个新记录

这是定义美国州的数据文件的第一行res.country.state.csv

"id","country_id:id","name","code"
state_au_1,au,"Australian Capital Territory","ACT"
state_au_2,au,"New South Wales","NSW"
state_au_3,au,"Northern Territory","NT"
state_au_4,au,"Queensland","QLD"
state_au_5,au,"South Australia","SA"
state_au_6,au,"Tasmania","TAS"
state_au_7,au,"Victoria","VIC"
state_au_8,au,"Western Australia","WA"
state_us_1,us,"Alabama","AL"
state_us_2,us,"Alaska","AK"
state_us_3,us,"Arizona","AZ"
state_us_4,us,"Arkansas","AR"
state_us_5,us,"California","CA"
state_us_6,us,"Colorado","CO"

以更易读的格式呈现:

idcountry_id:idnamecode
state_au_1auAustralian Capital TerritoryACT
state_au_2auNew South WalesNSW
state_au_3auNorthern TerritoryNT
state_au_4auQueenslandQLD
state_au_5auSouth AustraliaSA
state_au_6auTasmaniaTAS
state_au_7auVictoriaVIC
state_au_8auWestern AustraliaWA
state_us_1usAlabamaAL
state_us_2usAlaskaAK
state_us_3usArizonaAZ
state_us_4usArkansasAR
state_us_5usCaliforniaCA
state_us_6usColoradoCO
state_us_7usConnecticutCT
state_us_8usDelawareDE
state_us_9usDistrict of ColumbiaDC
state_us_10usFloridaFL
state_us_11usGeorgiaGA
state_us_12usHawaiiHI
state_us_13usIdahoID
state_us_14usIllinoisIL
state_us_15usIndianaIN
state_us_16usIowaIA
state_us_17usKansasKS
state_us_18usKentuckyKY
state_us_19usLouisianaLA
state_us_20usMaineME
state_us_21usMontanaMT
state_us_22usNebraskaNE
state_us_23usNevadaNV
state_us_24usNew HampshireNH
state_us_25usNew JerseyNJ
state_us_26usNew MexicoNM
state_us_27usNew YorkNY
state_us_28usNorth CarolinaNC
state_us_29usNorth DakotaND
state_us_30usOhioOH
state_us_31usOklahomaOK
state_us_32usOregonOR
state_us_33usMarylandMD
state_us_34usMassachusettsMA
state_us_35usMichiganMI
state_us_36usMinnesotaMN
state_us_37usMississippiMS
state_us_38usMissouriMO
state_us_39usPennsylvaniaPA
state_us_40usRhode IslandRI
state_us_41usSouth CarolinaSC
state_us_42usSouth DakotaSD
state_us_43usTennesseeTN
state_us_44usTexasTX
state_us_45usUtahUT
state_us_46usVermontVT
state_us_47usVirginiaVA
state_us_48usWashingtonWA
state_us_49usWest VirginiaWV
state_us_50usWisconsinWI
state_us_51usWyomingWY
state_us_asusAmerican SamoaAS
state_us_fmusFederated States of MicronesiaFM
state_us_guusGuamGU
state_us_mhusMarshall IslandsMH
state_us_mpusNorthern Mariana IslandsMP
state_us_pwusPalauPW
state_us_prusPuerto RicoPR
state_us_viusVirgin IslandsVI
state_us_aausArmed Forces AmericasAA
state_us_aeusArmed Forces EuropeAE
state_us_apusArmed Forces PacificAP
state_br_acbrAcreAC
state_br_albrAlagoasAL
state_br_apbrAmapáAP
state_br_ambrAmazonasAM
state_br_babrBahiaBA
state_br_cebrCearáCE
state_br_dfbrDistrito FederalDF
state_br_esbrEspírito SantoES
state_br_gobrGoiásGO
state_br_mabrMaranhãoMA
state_br_mtbrMato GrossoMT
state_br_msbrMato Grosso do SulMS
state_br_mgbrMinas GeraisMG
state_br_pabrParáPA
state_br_pbbrParaíbaPB
state_br_prbrParanáPR
state_br_pebrPernambucoPE
state_br_pibrPiauíPI
state_br_rjbrRio de JaneiroRJ
state_br_rnbrRio Grande do NorteRN
state_br_rsbrRio Grande do SulRS
state_br_robrRondôniaRO
state_br_rrbrRoraimaRR
state_br_scbrSanta CatarinaSC
state_br_spbrSão PauloSP
state_br_sebrSergipeSE
state_br_tobrTocantinsTO
state_ru_adruRepublic of AdygeyaAD
state_ru_alruAltai RepublicAL
state_ru_altruAltai KraiALT
state_ru_amuruAmur OblastAMU
state_ru_arkruArkhangelsk OblastARK
state_ru_astruAstrakhan OblastAST
state_ru_baruRepublic of BashkortostanBA
state_ru_belruBelgorod OblastBEL
state_ru_bryruBryansk OblastBRY
state_ru_buruRepublic of BuryatiaBU
state_ru_ceruChechen RepublicCE
state_ru_cheruChelyabinsk OblastCHE
state_ru_churuChukotka Autonomous OkrugCHU
state_ru_curuChuvash RepublicCU
state_ru_daruRepublic of DagestanDA
state_ru_inruRepublic of IngushetiaIN
state_ru_irkruIrkutsk OblastIRK
state_ru_ivaruIvanovo OblastIVA
state_ru_kamruKamchatka KraiKAM
state_ru_kbruKabardino-Balkarian RepublicKB
state_ru_kgdruKaliningrad OblastKGD
state_ru_klruRepublic of KalmykiaKL
state_ru_kluruKaluga OblastKLU
state_ru_kcruKarachay–Cherkess RepublicKC
state_ru_krruRepublic of KareliaKR
state_ru_kemruKemerovo OblastKEM
state_ru_kharuKhabarovsk KraiKHA
state_ru_kkruRepublic of KhakassiaKK
state_ru_khmruKhanty-Mansi Autonomous OkrugKHM
state_ru_kirruKirov OblastKIR
state_ru_koruKomi RepublicKO
state_ru_kosruKostroma OblastKOS
state_ru_kdaruKrasnodar KraiKDA
state_ru_kyaruKrasnoyarsk KraiKYA
state_ru_kgnruKurgan OblastKGN
state_ru_krsruKursk OblastKRS
state_ru_lenruLeningrad OblastLEN
state_ru_lipruLipetsk OblastLIP
state_ru_magruMagadan OblastMAG
state_ru_meruMari El RepublicME
state_ru_moruRepublic of MordoviaMO
state_ru_mosruMoscow OblastMOS
state_ru_mowruMoscowMOW
state_ru_murruMurmansk OblastMUR
state_ru_nizruNizhny Novgorod OblastNIZ
state_ru_ngrruNovgorod OblastNGR
state_ru_nvsruNovosibirsk OblastNVS
state_ru_omsruOmsk OblastOMS
state_ru_oreruOrenburg OblastORE
state_ru_orlruOryol OblastORL
state_ru_pnzruPenza OblastPNZ
state_ru_perruPerm KraiPER
state_ru_priruPrimorsky KraiPRI
state_ru_pskruPskov OblastPSK
state_ru_rosruRostov OblastROS
state_ru_ryaruRyazan OblastRYA
state_ru_saruSakha Republic (Yakutia)SA
state_ru_sakruSakhalin OblastSAK
state_ru_samruSamara OblastSAM
state_ru_speruSaint PetersburgSPE
state_ru_sarruSaratov OblastSAR
state_ru_seruRepublic of North Ossetia–AlaniaSE
state_ru_smoruSmolensk OblastSMO
state_ru_staruStavropol KraiSTA
state_ru_sveruSverdlovsk OblastSVE
state_ru_tamruTambov OblastTAM
state_ru_taruRepublic of TatarstanTA
state_ru_tomruTomsk OblastTOM
state_ru_tulruTula OblastTUL
state_ru_tveruTver OblastTVE
state_ru_tyuruTyumen OblastTYU
state_ru_tyruTyva RepublicTY
state_ru_udruUdmurtiaUD
state_ru_ulyruUlyanovsk OblastULY
state_ru_vlaruVladimir OblastVLA
state_ru_vggruVolgograd OblastVGG
state_ru_vlgruVologda OblastVLG
state_ru_vorruVoronezh OblastVOR
state_ru_yanruYamalo-Nenets Autonomous OkrugYAN
state_ru_yarruYaroslavl OblastYAR
state_ru_yevruJewish Autonomous OblastYEV
state_gt_avegtAlta VerapazAVE
state_gt_bvegtBaja VerapazBVE
state_gt_cmtgtChimaltenangoCMT
state_gt_cqmgtChiquimulaCQM
state_gt_eprgtEl ProgresoEPR
state_gt_escgtEscuintlaESC
state_gt_guagtGuatemalaGUA
state_gt_huegtHuehuetenangoHUE
state_gt_izagtIzabalIZA
state_gt_jalgtJalapaJAL
state_gt_jutgtJutiapaJUT
state_gt_petgtPeténPET
state_gt_quegtQuetzaltenangoQUE
state_gt_quigtQuichéQUI
state_gt_retgtRetalhuleuRET
state_gt_sacgtSacatepéquezSAC
state_gt_smagtSan MarcosSMA
state_gt_srogtSanta RosaSRO
state_gt_solgtSololáSOL
state_gt_sucgtSuchitepéquezSUC
state_gt_totgtTotonicapánTOT
state_gt_zacgtZacapaZAC
state_jp_jp-23jpAichi23
state_jp_jp-05jpAkita05
state_jp_jp-02jpAomori02
state_jp_jp-12jpChiba12
state_jp_jp-38jpEhime38
state_jp_jp-18jpFukui18
state_jp_jp-40jpFukuoka40
state_jp_jp-07jpFukushima07
state_jp_jp-21jpGifu21
state_jp_jp-10jpGunma10
state_jp_jp-34jpHiroshima34
state_jp_jp-01jpHokkaidō01
state_jp_jp-28jpHyōgo28
state_jp_jp-08jpIbaraki08
state_jp_jp-17jpIshikawa17
state_jp_jp-03jpIwate03
state_jp_jp-37jpKagawa37
state_jp_jp-46jpKagoshima46
state_jp_jp-14jpKanagawa14
state_jp_jp-39jpKōchi39
state_jp_jp-43jpKumamoto43
state_jp_jp-26jpKyōto26
state_jp_jp-24jpMie24
state_jp_jp-04jpMiyagi04
state_jp_jp-45jpMiyazaki45
state_jp_jp-20jpNagano20
state_jp_jp-42jpNagasaki42
state_jp_jp-29jpNara29
state_jp_jp-15jpNiigata15
state_jp_jp-44jpŌita44
state_jp_jp-33jpOkayama33
state_jp_jp-47jpOkinawa47
state_jp_jp-27jpŌsaka27
state_jp_jp-41jpSaga41
state_jp_jp-11jpSaitama11
state_jp_jp-25jpShiga25
state_jp_jp-32jpShimane32
state_jp_jp-22jpShizuoka22
state_jp_jp-09jpTochigi09
state_jp_jp-36jpTokushima36
state_jp_jp-31jpTottori31
state_jp_jp-16jpToyama16
state_jp_jp-13jpTōkyō13
state_jp_jp-30jpWakayama30
state_jp_jp-06jpYamagata06
state_jp_jp-35jpYamaguchi35
state_jp_jp-19jpYamanashi19
state_pt_pt-01ptAveiro01
state_pt_pt-02ptBeja02
state_pt_pt-03ptBraga03
state_pt_pt-04ptBragança04
state_pt_pt-05ptCastelo Branco05
state_pt_pt-06ptCoimbra06
state_pt_pt-07ptÉvora07
state_pt_pt-08ptFaro08
state_pt_pt-09ptGuarda09
state_pt_pt-10ptLeiria10
state_pt_pt-11ptLisboa11
state_pt_pt-12ptPortalegre12
state_pt_pt-13ptPorto13
state_pt_pt-14ptSantarém14
state_pt_pt-15ptSetúbal15
state_pt_pt-16ptViana do Castelo16
state_pt_pt-17ptVila Real17
state_pt_pt-18ptViseu18
state_pt_pt-20ptAçores20
state_pt_pt-30ptMadeira30
state_eg_dkegDakahliaDK
state_eg_baegRed SeaBA
state_eg_bhegBeheiraBH
state_eg_fymegFaiyumFYM
state_eg_ghegGharbiaGH
state_eg_alxegAlexandriaALX
state_eg_isegIsmailiaIS
state_eg_gzegGizaGZ
state_eg_mnfegMonufiaMNF
state_eg_mnegMinyaMN
state_eg_cegCairoC
state_eg_kbegQalyubiaKB
state_eg_lxegLuxorLX
state_eg_wadegNew ValleyWAD
state_eg_shregAl SharqiaSHR
state_eg_sueg6th of OctoberSU
state_eg_suzegSuezSUZ
state_eg_asnegAswanASN
state_eg_astegAsyutAST
state_eg_bnsegBeni SuefBNS
state_eg_ptsegPort SaidPTS
state_eg_dtegDamiettaDT
state_eg_huegHelwanHU
state_eg_jsegSouth SinaiJS
state_eg_kfsegKafr el-SheikhKFS
state_eg_mtegMatrouhMT
state_eg_knegQenaKN
state_eg_sinegNorth SinaiSIN
state_eg_shgegSohagSHG
state_za_eczaEastern CapeEC
state_za_fszaFree StateFS
state_za_gtzaGautengGT
state_za_nlzaKwaZulu-NatalNL
state_za_lpzaLimpopoLP
state_za_mpzaMpumalangaMP
state_za_nczaNorthern CapeNC
state_za_nwzaNorth WestNW
state_za_wczaWestern CapeWC
state_it_agitAgrigentoAG
state_it_alitAlessandriaAL
state_it_anitAnconaAN
state_it_aoitAostaAO
state_it_aritArezzoAR
state_it_apitAscoli PicenoAP
state_it_atitAstiAT
state_it_avitAvellinoAV
state_it_baitBariBA
state_it_btitBarletta-Andria-TraniBT
state_it_blitBellunoBL
state_it_bnitBeneventoBN
state_it_bgitBergamoBG
state_it_biitBiellaBI
state_it_boitBolognaBO
state_it_bzitBolzanoBZ
state_it_bsitBresciaBS
state_it_britBrindisiBR
state_it_caitCagliariCA
state_it_clitCaltanissettaCL
state_it_cbitCampobassoCB
state_it_ciitCarbonia-IglesiasCI
state_it_ceitCasertaCE
state_it_ctitCataniaCT
state_it_czitCatanzaroCZ
state_it_chitChietiCH
state_it_coitComoCO
state_it_csitCosenzaCS
state_it_critCremonaCR
state_it_kritCrotoneKR
state_it_cnitCuneoCN
state_it_enitEnnaEN
state_it_fmitFermoFM
state_it_feitFerraraFE
state_it_fiitFirenzeFI
state_it_fgitFoggiaFG
state_it_fcitForlì-CesenaFC
state_it_fritFrosinoneFR
state_it_geitGenovaGE
state_it_goitGoriziaGO
state_it_gritGrossetoGR
state_it_imitImperiaIM
state_it_isitIserniaIS
state_it_spitLa SpeziaSP
state_it_aqitL'AquilaAQ
state_it_ltitLatinaLT
state_it_leitLecceLE
state_it_lcitLeccoLC
state_it_liitLivornoLI
state_it_loitLodiLO
state_it_luitLuccaLU
state_it_mcitMacerataMC
state_it_mnitMantovaMN
state_it_msitMassa-CarraraMS
state_it_mtitMateraMT
state_it_vsitMedio CampidanoVS
state_it_meitMessinaME
state_it_miitMilanoMI
state_it_moitModenaMO
state_it_mbitMonza e BrianzaMB
state_it_naitNapoliNA
state_it_noitNovaraNO
state_it_nuitNuoroNU
state_it_ogitOgliastraOG
state_it_otitOlbia-TempioOT
state_it_oritOristanoOR
state_it_pditPadovaPD
state_it_paitPalermoPA
state_it_pritParmaPR
state_it_pvitPaviaPV
state_it_pgitPerugiaPG
state_it_puitPesaro e UrbinoPU
state_it_peitPescaraPE
state_it_pcitPiacenzaPC
state_it_piitPisaPI
state_it_ptitPistoiaPT
state_it_pnitPordenonePN
state_it_pzitPotenzaPZ
state_it_poitPratoPO
state_it_rgitRagusaRG
state_it_raitRavennaRA
state_it_rcitReggio CalabriaRC
state_it_reitReggio EmiliaRE
state_it_riitRietiRI
state_it_rnitRiminiRN
state_it_rmitRomaRM
state_it_roitRovigoRO
state_it_saitSalernoSA
state_it_ssitSassariSS
state_it_svitSavonaSV
state_it_siitSienaSI
state_it_sritSiracusaSR
state_it_soitSondrioSO
state_it_taitTarantoTA
state_it_teitTeramoTE
state_it_tritTerniTR
state_it_toitTorinoTO
state_it_tpitTrapaniTP
state_it_tnitTrentoTN
state_it_tvitTrevisoTV
state_it_tsitTriesteTS
state_it_uditUdineUD
state_it_vaitVareseVA
state_it_veitVeneziaVE
state_it_vbitVerbano-Cusio-OssolaVB
state_it_vcitVercelliVC
state_it_vritVeronaVR
state_it_vvitVibo ValentiaVV
state_it_viitVicenzaVI
state_it_vtitViterboVT
state_es_cesA Coruña (La Coruña)C
state_es_viesAraba/ÁlavaVI
state_es_abesAlbaceteAB
state_es_aesAlacant (Alicante)A
state_es_alesAlmeríaAL
state_es_oesAsturiasO
state_es_avesÁvilaAV
state_es_baesBadajozBA
state_es_pmesIlles Balears (Islas Baleares)PM
state_es_besBarcelonaB
state_es_buesBurgosBU
state_es_ccesCáceresCC
state_es_caesCádizCA
state_es_sesCantabriaS
state_es_csesCastelló (Castellón)CS
state_es_ceesCeutaCE
state_es_cresCiudad RealCR
state_es_coesCórdobaCO
state_es_cuesCuencaCU
state_es_giesGirona (Gerona)GI
state_es_gresGranadaGR
state_es_guesGuadalajaraGU
state_es_ssesGipuzkoa (Guipúzcoa)SS
state_es_hesHuelvaH
state_es_huesHuescaHU
state_es_jesJaénJ
state_es_loesLa RiojaLO
state_es_gcesLas PalmasGC
state_es_leesLeónLE
state_es_lesLleida (Lérida)L
state_es_luesLugoLU
state_es_mesMadridM
state_es_maesMálagaMA
state_es_mlesMelillaME
state_es_muesMurciaMU
state_es_naesNafarroa (Navarra)NA
state_es_oresOurense (Orense)OR
state_es_pesPalenciaP
state_es_poesPontevedraPO
state_es_saesSalamancaSA
state_es_tfesSanta Cruz de TenerifeTF
state_es_sgesSegoviaSG
state_es_seesSevillaSE
state_es_soesSoriaSO
state_es_tesTarragonaT
state_es_teesTeruelTE
state_es_toesToledoTO
state_es_vesValència (Valencia)V
state_es_vaesValladolidVA
state_es_biesBizkaia (Vizcaya)BI
state_es_zaesZamoraZA
state_es_zesZaragozaZ
state_my_jhrmyJohorJHR
state_my_kdhmyKedahKDH
state_my_ktnmyKelantanKTN
state_my_kulmyKuala LumpurKUL
state_my_lbnmyLabuanLBN
state_my_mlkmyMelakaMLK
state_my_nsnmyNegeri SembilanNSN
state_my_phgmyPahangPHG
state_my_prkmyPerakPRK
state_my_plsmyPerlisPLS
state_my_pngmyPulau PinangPNG
state_my_pjymyPutrajayaPJY
state_my_sbhmySabahSBH
state_my_swkmySarawakSWK
state_my_sgrmySelangorSGR
state_my_trgmyTerengganuTRG
state_mx_agsmxAguascalientesAGU
state_mx_bcmxBaja CaliforniaBCN
state_mx_bcsmxBaja California SurBCS
state_mx_chihmxChihuahuaCHH
state_mx_colmxColimaCOL
state_mx_campmxCampecheCAM
state_mx_coahmxCoahuilaCOA
state_mx_chismxChiapasCHP
state_mx_dfmxCiudad de MéxicoDIF
state_mx_dgomxDurangoDUR
state_mx_gromxGuerreroGRO
state_mx_gtomxGuanajuatoGUA
state_mx_hgomxHidalgoHID
state_mx_jalmxJaliscoJAL
state_mx_michmxMichoacánMIC
state_mx_mormxMorelosMOR
state_mx_mexmxMéxicoMEX
state_mx_naymxNayaritNAY
state_mx_nlmxNuevo LeónNLE
state_mx_oaxmxOaxacaOAX
state_mx_puemxPueblaPUE
state_mx_q roomxQuintana RooROO
state_mx_qromxQuerétaroQUE
state_mx_sinmxSinaloaSIN
state_mx_slpmxSan Luis PotosíSLP
state_mx_sonmxSonoraSON
state_mx_tabmxTabascoTAB
state_mx_tlaxmxTlaxcalaTLA
state_mx_tampsmxTamaulipasTAM
state_mx_vermxVeracruzVER
state_mx_yucmxYucatánYUC
state_mx_zacmxZacatecasZAC
state_nz_auknzAucklandAUK
state_nz_bopnzBay of PlentyBOP
state_nz_cannzCanterburyCAN
state_nz_gisnzGisborneGIS
state_nz_hkbnzHawke's BayHKB
state_nz_mwtnzManawatu-WanganuiMWT
state_nz_mbhnzMarlboroughMBH
state_nz_nsnnzNelsonNSN
state_nz_ntlnzNorthlandNTL
state_nz_otanzOtagoOTA
state_nz_stlnzSouthlandSTL
state_nz_tkinzTaranakiTKI
state_nz_tasnzTasmanTAS
state_nz_wkonzWaikatoWKO
state_nz_wgnnzWellingtonWGN
state_nz_wtcnzWest CoastWTC
state_ca_abcaAlbertaAB
state_ca_bccaBritish ColumbiaBC
state_ca_mbcaManitobaMB
state_ca_nbcaNew BrunswickNB
state_ca_nlcaNewfoundland and LabradorNL
state_ca_ntcaNorthwest TerritoriesNT
state_ca_nscaNova ScotiaNS
state_ca_nucaNunavutNU
state_ca_oncaOntarioON
state_ca_pecaPrince Edward IslandPE
state_ca_qccaQuebecQC
state_ca_skcaSaskatchewanSK
state_ca_ytcaYukonYT
state_ae_azaeAbu DhabiAZ
state_ae_ajaeAjmanAJ
state_ae_duaeDubaiDU
state_ae_fuaeFujairahFU
state_ae_rkaeRas al-KhaimahRK
state_ae_shaeSharjahSH
state_ae_uqaeUmm al-QuwainUQ
state_ar_carBuenos Aires CityC
state_ar_barBuenos AiresB
state_ar_karCatamarcaK
state_ar_harChacoH
state_ar_uarChobutU
state_ar_xarCórdobaX
state_ar_warCorrientesW
state_ar_earEnte RíosE
state_ar_parFormosaP
state_ar_yarJujuyY
state_ar_larLa PampaL
state_ar_farLa RiojaF
state_ar_marMendozaM
state_ar_narMisionesN
state_ar_qarNeuquénQ
state_ar_rarRío NegroR
state_ar_aarSaltaA
state_ar_jarSan JuanJ
state_ar_darSan LuisD
state_ar_zarSanta CruzZ
state_ar_sarSanta FeS
state_ar_garSantiago Del EsteroG
state_ar_varTierra del FuegoV
state_ar_tarTucumánT
state_in_aninAndaman and NicobarAN
state_in_apinAndhra PradeshAP
state_in_arinArunachal PradeshAR
state_in_asinAssamAS
state_in_brinBiharBR
state_in_chinChandigarhCH
state_in_cginChattisgarhCG
state_in_dninDadra and Nagar HaveliDN
state_in_ddinDaman and DiuDD
state_in_dlinDelhiDL
state_in_gainGoaGA
state_in_gjinGujaratGJ
state_in_hrinHaryanaHR
state_in_hpinHimachal PradeshHP
state_in_jkinJammu and KashmirJK
state_in_jhinJharkhandJH
state_in_kainKarnatakaKA
state_in_klinKeralaKL
state_in_ldinLakshadweepLD
state_in_mpinMadhya PradeshMP
state_in_mhinMaharashtraMH
state_in_mninManipurMN
state_in_mlinMeghalayaML
state_in_mzinMizoramMZ
state_in_nlinNagalandNL
state_in_orinOrissaOR
state_in_pyinPuducherryPY
state_in_pbinPunjabPB
state_in_rjinRajasthanRJ
state_in_skinSikkimSK
state_in_tninTamil NaduTN
state_in_tsinTelanganaTS
state_in_trinTripuraTR
state_in_upinUttar PradeshUP
state_in_ukinUttarakhandUK
state_in_wbinWest BengalWB
state_id_acidAcehAC
state_id_baidBaliBA
state_id_bbidBangka BelitungBB
state_id_btidBantenBT
state_id_beidBengkuluBE
state_id_goidGorontaloGO
state_id_jkidJakartaJK
state_id_jaidJambiJA
state_id_jbidJawa BaratJB
state_id_jtidJawa TengahJT
state_id_jiidJawa TimurJI
state_id_kbidKalimantan BaratKB
state_id_ksidKalimantan SelatanKS
state_id_ktidKalimantan TengahKT
state_id_kiidKalimantan TimurKI
state_id_kuidKalimantan UtaraKU
state_id_kridKepulauan RiauKR
state_id_laidLampungLA
state_id_maidMalukuMA
state_id_muidMaluku UtaraMU
state_id_nbidNusa Tenggara BaratNB
state_id_ntidNusa Tenggara TimurNT
state_id_paidPapuaPA
state_id_pbidPapua BaratPB
state_id_riidRiauRI
state_id_sridSulawesi BaratSR
state_id_snidSulawesi SelatanSN
state_id_stidSulawesi TengahST
state_id_sgidSulawesi TenggaraSG
state_id_saidSulawesi UtaraSA
state_id_sbidSumatra BaratSB
state_id_ssidSumatra SelatanSS
state_id_suidSumatra UtaraSU
state_id_yoidYogyakartaYO

对于每一行(记录):

  • 第一列是要创建或更新的记录的外部标识
  • 第二列是要链接到的国家/地区对象的外部ID(必须事先定义国家/地区对象)
  • 第三列是res.country.statename字段
  • 第四列是res.country.state代码字段