@nocobase/plugin-action-import NPM | npm.io

1.3.42-beta • Published 9 months ago

Install

Weekly downloads

-

License

AGPL-3.0

Repository

Last release

9 months ago

import

English | 中文

Excel 数据导入插件。

安装激活

内置插件无需手动安装激活。

导入说明

数字类型字段

支持数字和百分比，N/A 或 - 的文案会被过滤掉

数字1	百分比	数字2	数字3
123	25%	N/A	-

转 JSON 之后为

{
  "数字1": 123,
  "百分比": 0.25,
  "数字2": null,
  "数字3": null,
}

布尔类型字段

输入文案支持（英文不区分大小写）：

Yes Y True 1 是
No N False 0 否

字段1	字段2	字段3	字段4	字段4
否	是	Y	true	0

转 JSON 之后为

{
  "字段1": false,
  "字段2": true,
  "字段3": true,
  "字段4": true,
  "字段5": false,
}

日期类型字段

DateOnly	Local(+08:00)	GMT
2023-01-18 22:22:22	2023-01-18 22:22:22	2023-01-18 22:22:22

转 JSON 之后为

{
  "DateOnly": "2023-01-18T00:00:00.000Z",
  "Local(+08:00)": "2023-01-18T14:22:22.000Z",
  "GMT": "2023-01-18T22:22:22.000Z",
}

选择类型字段

选项值和选项标签都可作为导入文案，多个选项之间以以逗号（, ，）或顿号（、）区分

如字段 优先级 的可选项包括：

选项值	选项标签
low	低
medium	中
high	低

选项值和选项标签都可作为导入文案

优先级
高
low

转 JSON 之后为

[
  { "优先级": "high" },
  { "优先级": "low" },
]

中国行政区字段

地区1	地区2
北京市/市辖区	天津市/市辖区

转 JSON 之后为

{
  "地区1": ["11","1101"],
  "地区2": ["12","1201"]
}

附件字段

附件
https://www.nocobase.com/images/logo.png

转 JSON 之后为

{
  "附件": [
    {
      "filename": "logo.png",
      "title": "logo.png",
      "extname": ".png",
      "url": "https://www.nocobase.com/images/logo.png"
    }
  ]
}

关系类型字段

多条数据以逗号（, ，）或顿号（、）区分

部门/名称	分类/标题
开发组	分类1、分类2

转 JSON 之后为

{
  "部门": [1], // 1 为部门名称为「开发组」的记录 ID
  "分类": [1,2], // 1,2 为分类标题为「分类1」和「分类2」的记录 ID
}

JSON 类型字段

JSON1
{"key":"value"}

转 JSON 之后为

{
  "JSON": {"key":"value"}
}

地图几何图形类型

Point	Line	Polygon	Circle
1,2	(1,2),(3,4)	(1,2),(3,4),(1,2)	1,2,3

转 JSON 之后为

{
  "Point": [1,2],
  "Line": [[1,2], [3,4]],
  "Polygon": [[1,2], [3,4], [1,2]],
  "Circle": [1,2,3]
}

自定义导入格式

通过 db.registerFieldValueParsers() 方法注册自定义的 ValueParser，如：

import { BaseValueParser } from '@nocobase/database';

class PointValueParser extends BaseValueParser {
  async setValue(value) {
    if (Array.isArray(value)) {
      this.value = value;
    } else if (typeof value === 'string') {
      this.value = value.split(',');
    } else {
      this.errors.push('Value invalid');
    }
  }
}

const db = new Database();

// type=point 的字段导入时，将通过 PointValueParser 解析数据
db.registerFieldValueParsers({
  point: PointValueParser,
});

导入示例

Point
1,2

转 JSON 之后为

{
  "Point": [1,2]
}

@nocobase/preset-nocobase

1.4.0-alpha.20241027230531

9 months ago

9 months ago

1.4.0-alpha.20241031134640

9 months ago

9 months ago

1.4.0-alpha.20241025010959

9 months ago

9 months ago

9 months ago

1.4.0-alpha.20241024151311

9 months ago

9 months ago

9 months ago

1.4.0-alpha.20241024133132

9 months ago

9 months ago

1.4.0-alpha.20241023053303

9 months ago

9 months ago

9 months ago

9 months ago

1.4.0-alpha.20241020033334

9 months ago

9 months ago

1.4.0-alpha.20241017164316

9 months ago

1.4.0-alpha.20241016084738

9 months ago

1.4.0-alpha.20241020025811

9 months ago

1.4.0-alpha.20241016035453

9 months ago

9 months ago

1.4.0-alpha.20240930160619

10 months ago

9 months ago

10 months ago

1.4.0-alpha.20240928155737

10 months ago

1.4.0-alpha.20241008122235

9 months ago

9 months ago

9 months ago

10 months ago

1.4.0-alpha.20240930005110

10 months ago

9 months ago

1.4.0-alpha.20241011073807

9 months ago

1.4.0-alpha.20240930031045

10 months ago

1.4.0-alpha.20240929231156

10 months ago

10 months ago

10 months ago

1.4.0-alpha.20240923152933

10 months ago

1.4.0-alpha.20240914084300

10 months ago

1.4.0-alpha.20240919174335

10 months ago

1.4.0-alpha.20240914095808

10 months ago

10 months ago

1.4.0-alpha.20240914235554

10 months ago

1.4.0-alpha.20240918085507

10 months ago

10 months ago

10 months ago

1.4.0-alpha.20240911231734

10 months ago

1.4.0-alpha.20240910145333

10 months ago

10 months ago

10 months ago

10 months ago

10 months ago

1.4.0-alpha.20240906133133

10 months ago

10 months ago

1.4.0-alpha.20240906114411

10 months ago

11 months ago

1.4.0-alpha.20240903083725

11 months ago

1.4.0-alpha.20240903050434

11 months ago

11 months ago

1.4.0-alpha.20240903052847

11 months ago

11 months ago

1.4.0-alpha.20240902080620

11 months ago

1.4.0-alpha.20240902071446

11 months ago

1.4.0-alpha.20240902083444

11 months ago

1.4.0-alpha.20240902021325

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

1.4.0-alpha.20240828033319

11 months ago

11 months ago

11 months ago

1.4.0-alpha.20240827104423

11 months ago

11 months ago

11 months ago

1.4.0-alpha.20240826225858

11 months ago

1.4.0-alpha.20240826214041

11 months ago

11 months ago

1 year ago

1.3.0-alpha.20240710084543

1 year ago

1 year ago

1.3.0-alpha.20240724142600

12 months ago

1 year ago

1 year ago

1 year ago

1 year ago

11 months ago

11 months ago

12 months ago

1 year ago

1 year ago

1 year ago

12 months ago

1.3.0-alpha.20240710141659

1 year ago

1 year ago

1.3.0-alpha.20240721030922

12 months ago

11 months ago

1 year ago

12 months ago

12 months ago

1.3.0-alpha.20240719150832

12 months ago

1.3.0-alpha.20240807100243

11 months ago

1 year ago

11 months ago

12 months ago

1.3.0-alpha.20240814073548

11 months ago

1.3.0-alpha.20240710155619

1 year ago

12 months ago

1.4.0-alpha.20240825165425

11 months ago

11 months ago

1 year ago

12 months ago

1 year ago

1 year ago

1 year ago

1 year ago

11 months ago

1 year ago

12 months ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1.3.0-alpha.20240819011229

11 months ago

12 months ago

1.3.0-alpha.20240806102951

12 months ago

1 year ago

11 months ago

1 year ago

12 months ago

11 months ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago