Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

审核规则支持csv格式导入导出 #2580

Closed
9 of 11 tasks
taolx0 opened this issue Sep 3, 2024 · 1 comment
Closed
9 of 11 tasks

审核规则支持csv格式导入导出 #2580

taolx0 opened this issue Sep 3, 2024 · 1 comment
Assignees
Labels
feature publish-pre2 verified the issue all pr is verified
Milestone

Comments

@taolx0
Copy link
Contributor

taolx0 commented Sep 3, 2024

背景

售前反馈审核规则导出成json格式不方便用户查看和修改

需求描述(Describe)

审核规则导入导出支持csv格式

实现方案

范围: 全局/项目审核规则导入导出页面

UI设计

审核规则导入页面增加导入类型选择下拉框,支持选择csv/json格式导入导出(默认csv格式,和数据源导入导出格式保持一致)

  • 导入审核规则页面新增审核模版下载按钮
  • 导入审核规则页面新增数据源类型下拉框
  • 导入审核规则页面新增文件类型下拉框
  • 导出审核规则页面新增导出配置弹窗

后端设计

  • 新增下载导出规则模版接口
  • 审核规则导入parser接口新增csv文件格式解析
  • 审核规则导出接口新增csv文件格式导出

注意点:

  • 导出文件中的params.key字段,对用户来说无意义,移除该字段,在导入该文件时SQLE自动填充params.key值,params.key值为常量值,不支持修改,因此SQLE可以自动填充
  • 如果审核规则导入parser接口新增csv文件格式解析失败,返回用户导入的文件,并在文件中标注错误原因

问题:

变更影响面

受影响的模块或功能

外部引用的潜在问题或风险

版本兼容性

测试建议

@taolx0
Copy link
Contributor Author

taolx0 commented Oct 11, 2024

WPS兼容性问题描述

wps保存csv文件会默认添加4个逗号,导致sqle解析csv文件出错

image

修复pr链接

#2671

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature publish-pre2 verified the issue all pr is verified
Projects
None yet
Development

No branches or pull requests

2 participants