6.1、从旧Jyj.Bmp导入教师到学在上城

从旧Jyj.Bmp导入教师到学在上城

1、从 Jyj.Bmp 下载

curl --location --request POST 'https://jyj.bmp.91118.com/api/apis-user/jzgjbsjzlb/exportJzgData' \
--header 'authority: jyj.bmp.91118.com' \
--header 'authorization: 5805b304-3d48-4de9-a794-ddad5516ed6d' \
--header 'x-authorization: eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsInppcCI6IkRFRiJ9.eJx9kb1OwzAUhd_Fc9wmbmI73kFlBlTBliZO4yZ1otguTasOIDEw8QQwMrVSN_pADbwGbhESKj-j_R3dc-65C2BEAhjwMHFx2OsF2CeUesjDCDhASKFFVACma8MdMCyNTL4eVV2mouCALUAUx5bos6NBlCDXJTi0g2azZAKYNEXhAKWt7PwCWhjCwTQbmQm91qMTBG8u-1fzQQ6zfiNPc-ssGyFhHCmY8KooG0gwoT7BCRlCP6ZSHSKm5d74c7ZIuNRCN4co2GIp4lxGExsTvD2t29fndnu3296295v31Wq3fWg3j-36xQqN4vXxAt-aKOvREcVBgBAiFIOlA6a8FmkDWBoVynZjfpT6rYuxFpbViWJ7T6bLnEv2u6sywz8TReafuyllWaZ1pVi3O8-qMdRc6U7oeR7txOVkr4nsHTwSuD5yaYgdwGfV4cNzUYBDvPwAdCqhkA.E1Ccarmp9oGO4Y2ursSY3voUPu5n2weB0FsLw3OV5mwgWLos5w4gq6IxmK9XGvWNOmNP0FJsfy2R6mU1kIRiMtFgsYxl5XA_Myb6yH6EK1_Tq_ePB0oFXoI5ctkQUE7RNLEFKeiGLaSj1n8UpLYsWpaEC2H3w9yKOLV3hz4DRbzlGzZWWxBPKxV1Zfa0JA9aEXovrJ9tq5V0Gpe7EjxL6sj3Jtyj38e4eWv-LR4g4rHSEmq27sueufgey4lQMgSv4uGFBer2x1K3hJIVSoS5envAMR4zavf8HXLvyltY03YtKJr29L0NfE1Evg52odjmnFsn72GsJ8oK6zAxIxTskA' \
--header 'x-device-imei: 1feec2b4-a3ef-4f59-9a2d-4c409b8e2b54' \
--header 'x-language: zh-CN' \
--header 'x-os: Win32' \
--header 'Cookie: Admin-Token=eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsInppcCI6IkRFRiJ9.eJx9kb1OwzAUhd_Fc9wmbmI73kFlBlTBliZO4yZ1otguTasOIDEw8QQwMrVSN_pADbwGbhESKj-j_R3dc-65C2BEAhjwMHFx2OsF2CeUesjDCDhASKFFVACma8MdMCyNTL4eVV2mouCALUAUx5bos6NBlCDXJTi0g2azZAKYNEXhAKWt7PwCWhjCwTQbmQm91qMTBG8u-1fzQQ6zfiNPc-ssGyFhHCmY8KooG0gwoT7BCRlCP6ZSHSKm5d74c7ZIuNRCN4co2GIp4lxGExsTvD2t29fndnu3296295v31Wq3fWg3j-36xQqN4vXxAt-aKOvREcVBgBAiFIOlA6a8FmkDWBoVynZjfpT6rYuxFpbViWJ7T6bLnEv2u6sywz8TReafuyllWaZ1pVi3O8-qMdRc6U7oeR7txOVkr4nsHTwSuD5yaYgdwGfV4cNzUYBDvPwAdCqhkA.E1Ccarmp9oGO4Y2ursSY3voUPu5n2weB0FsLw3OV5mwgWLos5w4gq6IxmK9XGvWNOmNP0FJsfy2R6mU1kIRiMtFgsYxl5XA_Myb6yH6EK1_Tq_ePB0oFXoI5ctkQUE7RNLEFKeiGLaSj1n8UpLYsWpaEC2H3w9yKOLV3hz4DRbzlGzZWWxBPKxV1Zfa0JA9aEXovrJ9tq5V0Gpe7EjxL6sj3Jtyj38e4eWv-LR4g4rHSEmq27sueufgey4lQMgSv4uGFBer2x1K3hJIVSoS5envAMR4zavf8HXLvyltY03YtKJr29L0NfE1Evg52odjmnFsn72GsJ8oK6zAxIxTskA; Admin-UserInfo={%22id%22:%221651773429433245697%22%2C%22nickname%22:%22%E6%9D%AD%E5%B7%9E%E5%B8%82%E6%BE%8E%E5%8D%9A%E5%B0%8F%E5%AD%A6%22%2C%22avatar%22:%22%22%2C%22phone%22:%22%22%2C%22dingPhone%22:%22%22%2C%22email%22:%22%22%2C%22idType%22:1%2C%22idcard%22:%223412****9152%22%2C%22idCardNot%22:%22%22%2C%22identityId%22:6%2C%22userId%22:%221651773429433245697%22%2C%22initial%22:true%2C%22bound%22:true%2C%22verify%22:false%2C%22defaultPass%22:false%2C%22loginType%22:%22password%22%2C%22type%22:0%2C%22userType%22:2%2C%22account%22:%22Hzspbxx010%22%2C%22orgId%22:%221651773429667872770%22}; JSESSIONID=9Yq5EFchOjDtbAtTgLbZWwTjfg9iYVhc7ccMsQbz; JSESSIONID=7fWccxuT6m5gGGwQPCTdU5NfbhJjs8UQlcrBl6u_' \
--header 'User-Agent: Apifox/1.0.0 (https://apifox.com)' \
--header 'content-type: application/json' \
--header 'Accept: */*' \
--header 'Host: jyj.bmp.91118.com' \
--header 'Connection: keep-alive' \
--data-raw '{
    "searchCondition": [],
    "columnNames": [
        "xm",
        "xb",
        "sjh",
        "sfzjlx",
        "sfzjh",
        "jgmc",
        "adminDeptName",
        "mzmc",
        "zzmmmc",
        "jkzk",
        "csrq",
        "jg"
    ],
    "orgId": "1670693356655222786",
    "orgName": "018 杭州市丁兰第三小学",
    "sourceType": "05"
}'

• 校管，登录学在上城，获取 Token , 替换 x-authorization
• 在教职工管理，获取 orgId、orgName，进行替换
  

2、替换后的内容导入到 PostMan

3、导出文件

模板表格

4、从学在上城，在编教师下载模板

从下载的模板

5、把数据复制到下载的模板，并导入系统