受欢迎的博客标签

微信小程序云开发-云数据库交互- 在云控制台手工导入数据到云数据库

Published

1.必须有ID字段

导入JSON格式的要求
1,JSON文件必须是 UTF-8 的编码格式,且其内容类似 MongoDB 的导出格式
2,JSON 数据不是数组,而是类似 JSON Lines,即各个记录对象之间使用 \n 分隔,而非逗号
3,JSON 数据每个键值对的键名首尾不能是 .,例如 “.a”、“abc.”,且不能包含多个连续的 .,例如 “a…b”
4,键名不能重复,且不能有歧义,例如 {“a”: 1, “a”: 2} 或 {“a”: {“b”: 1}, “a.b”: 2}
5,时间格式须为 ISODate 格式,例如 “date”: { “$date” : “2018-08-31T17:30:00.882Z” }

数据库导入格式要求-官方文档

 

step 1:存为.csv 文件,选utf-8格式

从电子表格复制1列数据

step 2:导入mongodb数据库,生成id

 

step 3:从mongodb导出数据到文本,修改id为字符串,另存为.csv 文件,选utf-8格式

导入到文本

{"_id":{"$oid":"5f262ca0b42e0af2407cfa26"},"8K2-T":"FS1"}
{"_id":{"$oid":"5f262ca0b42e0af2407cfa25"},"8K2-T":"G6����"}
{"_id":{"$oid":"5f262ca0b42e0af2407cfa24"},"8K2-T":"28-Z1"}
{"_id":{"$oid":"5f262ca0b42e0af2407cfa23"},"8K2-T":"FQ5B"}
{"_id":{"$oid":"5f262ca0b42e0af2407cfa22"},"8K2-T":"FQ5A"}
{"_id":{"$oid":"5f262ca0b42e0af2407cfa21"},"8K2-T":"L3A"}
{"_id":{"$oid":"5f262ca0b42e0af2407cfa20"},"8K2-T":"L3B"}
{"_id":{"$oid":"5f262ca0b42e0af2407cfa1f"},"8K2-T":"SQ32-S2"}
{"_id":{"$oid":"5f262ca0b42e0af2407cfa1e"},"8K2-T":"100-M6G"}
{"_id":{"$oid":"5f262ca0b42e0af2407cfa1d"},"8K2-T":"100-W2(A)"}
{"_id":{"$oid":"5f262ca0b42e0af2407cfa1c"},"8K2-T":"QJ08B-T"}
{"_id":{"$oid":"5f262ca0b42e0af2407cfa1b"},"8K2-T":"QH03B-Y"}

修改id为字符串,下面即为导入所要求地格式

{"_id":"5f262ca0b42e0af2407cfa26","Name":"FS1"}
{"_id":"5f262ca0b42e0af2407cfa25","Name":"G6����"}
{"_id":"5f262ca0b42e0af2407cfa24","Name":"28-Z1"}
{"_id":"5f262ca0b42e0af2407cfa23","Name":"FQ5B"}
{"_id":"5f262ca0b42e0af2407cfa22","Name":"FQ5A"}
{"_id":"5f262ca0b42e0af2407cfa21","Name":"L3A"}
{"_id":"5f262ca0b42e0af2407cfa20","Name":"L3B"}
{"_id":"5f262ca0b42e0af2407cfa1f","Name":"SQ32-S2"}
{"_id":"5f262ca0b42e0af2407cfa1e","Name":"100-M6G"}

 

step 4:在小程序开发工具中导入到云数据库

 

Useful links

从 MySQL/MongoDB 迁移数据至 小程序云数据库

 

 

微信小程序云开发导入json数据报错

https://www.cnblogs.com/QW-lzm/p/12432179.html