集简云是什么?
软件连接最简单快捷的方式
自动化您的业务流程
利用AI技术让业务流程更高效
可以集成哪些应用?
应用中心
模板中心
解决方案
市场推广团队解决方案
销售管理团队解决方案
客户服务团队解决方案
数据分析团队解决方案
客户成功团队解决方案
产品价格
开放平台
帮助中心
登录
免费使用
进入产品
当前模板排行信息
周排行
月排行
季度排行
年度排行
案例文章
推荐的的流程模板
请稍后...
自定义您的业务流程
选择的触发与执行动作,建立自动化的业务流程。
当这个情况发生时
触发动作
做这件事情
执行动作
开始创建吧
立即创建使用
相关文章
Copyright @2021-2023 北京集简慧通互联科技有限公司
京ICP备2021032137号-2
Code
2230
钉钉审批后,同步数据到Oracle(有些系统没有API接口,可以对接数据库)
<p>当钉钉有符合条件的审批流实例结束时,使用钉钉动作查询审批实例详情,数据筛选设置筛选条件,使用维格表公式搜索数据,并用数组处理将数组转换为文本,钉钉(自建应用) 发送文本消息(发送给自己,为了确认数据是否正确),日期时间格式变更日期时间格式调整,文本处理汉字转换成拼音,文本处理汉字转换成拼音,字段查询批量设置匹配关系,通过前面4个步骤将数据转换未Oracle指定的数据类型,最终将数据写入到Oracle指定数据表</p>
zh-Hans
2023-02-01T02:09:15.000Z
2023-02-01T02:09:15.000Z
2023-04-06T06:02:52.000Z
ay4830az
当钉钉有符合条件的审批流实例结束时,使用钉钉动作查询审批实例详情,数据筛选设置筛选条件,使用维格表公式搜索数据,并用数组处理将数组转换为文本,钉钉(自建应用) 发送文本消息(发送给自己,为了确认数据是否正确),日期时间格式变更日期时间格式调整,文本处理汉字转换成拼音,文本处理汉字转换成拼音,字段查询批量设置匹配关系,通过前面4个步骤将数据转换未Oracle指定的数据类型,最终将数据写入到Oracle指定数据表
anyone
9YJVEH82iyqD
official
pc1265
passed
谢晓鸣
ay4830az
谢晓鸣
[ { "desc": "当符合条件的审批流程实例结束时(支持通过审批模板code和操作类型筛选)", "app_id": 69, "action_id": 2635, "action_type": "1", "sort": "1", "note": null }, { "desc": "使用钉钉自建应用询审批实例详情(新抹平)", "app_id": 69, "action_id": 2850, "action_type": "2", "sort": "2", "note": null }, { "desc": "设置筛选条件,只有筛选条件满足后才会继续后续流程步骤", "app_id": 7, "action_id": 15, "action_type": "2", "sort": "3", "note": null }, { "desc": "根据条件公式(包含并且,或等公式)进行数据查询", "app_id": 310, "action_id": 541, "action_type": "2", "sort": "4", "note": null }, { "desc": "将数组中的元素按照指定的符号连接成一个字符串", "app_id": 1000454, "action_id": 1003836, "action_type": "2", "sort": "5", "note": null }, { "desc": "使用钉钉自建应用指定员工或部门发送文本消息", "app_id": 69, "action_id": 402, "action_type": "2", "sort": "6", "note": null }, { "desc": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "app_id": 89, "action_id": 241, "action_type": "2", "sort": "7", "note": null }, { "desc": "根据汉字转换成拼音", "app_id": 108, "action_id": 2514, "action_type": "2", "sort": "8", "note": null }, { "desc": "根据汉字转换成拼音", "app_id": 108, "action_id": 2514, "action_type": "2", "sort": "9", "note": null }, { "desc": "批量根据字段内容进行设置匹配关系", "app_id": 148, "action_id": 3070, "action_type": "2", "sort": "10", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "11", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "12", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "13", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "14", "note": null } ]
1
false
4
{ "1": [ { "key": "process_code", "label": "模板code", "type": "string", "help_txt": "请在旧版钉钉网页端企业管理后台内编辑审批流程,当前页面的URL中process_code后即可获取, 不填将返回所有模板的审批事件" }, { "key": "result", "label": "状态", "type": "string", "dropdown": true, "choices": [ { "key": "agree", "label": "同意" }, { "key": "refuse", "label": "拒绝" } ], "help_txt": "不填将返回所有审批结果的审批事件" } ], "2": [ { "key": "process_instance_id", "label": "审批实例ID", "type": "string", "required": true, "help_txt": "可以从触发动作中或者执行动作获取审批实例ID列表中获取" }, { "key": "is_file", "label": "是否获取审批中的附件", "type": "string", "dropdown": true, "choices": [ { "key": "true", "label": "是" }, { "key": "false", "label": "否" } ], "help_txt": "获取审批实例中的附件,并提供附件的下载链接。附件在平台最多保存30天,评论中上传的附件暂时不支持获取下载链接", "defaulttext": "true" } ], "3": [], "4": [ { "key": "sheet_id", "label": "选择维格表", "dropdownTree": true, "required": true, "dynamic": true, "queryParams": [ { "label": "父节点id", "key": "node_id", "is_key": true }, { "label": "标识", "key": "flag", "defaulttext": "root_node" } ], "url": "/v1/api/application/newViKaTable/dropdownTree/nodesList", "choices": [] } ], "5": [], "6": [ { "label": "接收员工", "key": "userid_list", "help_txt": "接收消息员工的userid;可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取", "type": "string", "multiples": true }, { "key": "dept_id_list", "label": "接收部门", "dropdownTree": true, "multiplesTree": true, "queryParams": [ { "label": "父节点id", "key": "node_id", "is_key": true, "defaulttext": 1 }, { "label": "标识", "key": "flag", "defaulttext": 1 } ], "url": "/v1/api/process/dingding/dropdowntree/get_dept", "choices": [], "help_txt": "请选择接收部门,消息接收者和接收部门不能同时为空" }, { "label": "发送内容", "required": true, "help_txt": "请输入发送内容", "key": "content", "type": "string" } ], "7": [ { "label": "请输入要调整的日期时间", "key": "from_time", "required": true, "multiples": true, "help_txt": "填写一个日期时间或者选择上面步骤中的动态日期时间字段" }, { "label": "请输入当前日期时间格式", "key": "from_time_type", "required": true, "dropdown": true, "dynamic": true, "help_txt": "请选择上面输入的日期时间格式以便正确的进行格式转换", "choices": [ { "value": "auto_format", "label": "自动识别格式" }, { "value": "%Y年%m月%d日 %H:%M:%S", "label": "YYYY年MM月DD日 HH:mm:ss(2006年01月22日 13:29:54)" }, { "value": "%Y年%m月%d日", "label": "YYYY年MM月DD日(2006年01月22日)" }, { "value": "%B %d %Y %H:%M:%S", "label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)" }, { "value": "%Y-%m-%dT%H:%M:%S.%fZ", "label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)" }, { "value": "%Y-%m-%dT%H:%M:%SZ", "label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)" }, { "value": "%B %d %Y", "label": "MMMM DD YYYY (January 22 2006)" }, { "value": "%b %d %Y", "label": "MMM DD YYYY (Jan 22 2006)" }, { "value": "%m-%d-%Y", "label": "MM-DD-YYYY (01-22-2006)" }, { "value": "%m/%d/%Y", "label": "MM/DD/YYYY (01/22/2006)" }, { "value": "%m/%d/%y", "label": "MM/DD/YY (01/22/06)" }, { "value": "%d-%m-%Y", "label": "DD-MM-YYYY (22-01-2006)" }, { "value": "%d/%m/%Y", "label": "DD/MM/YYYY (22/01/2006)" }, { "value": "%d/%m/%y", "label": "DD/MM/YY (22/01/06)" }, { "value": "%Y%m%d", "label": "YYYYMMDD (20060106)" }, { "value": "timestamp", "label": "时间戳秒 (1597247662)" }, { "value": "timestamp_ms", "label": "时间戳毫秒(1597247662000)" }, { "value": "custom", "label": "自定义格式" } ], "defaulttext": "auto_format" }, { "label": "请输入要转换到的日期时间格式", "key": "to_time_type", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "value": "%Y年%m月%d日 %H:%M:%S", "label": "YYYY年MM月DD日 HH:mm:ss(2006年01月22日 13:29:54)" }, { "value": "%Y年%m月%d日", "label": "YYYY年MM月DD日(2006年01月22日)" }, { "value": "%B %d %Y %H:%M:%S", "label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)" }, { "value": "%Y-%m-%dT%H:%M:%S.%fZ", "label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)" }, { "value": "%Y-%m-%dT%H:%M:%SZ", "label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)" }, { "value": "%B %d %Y", "label": "MMMM DD YYYY (January 22 2006)" }, { "value": "%b %d %Y", "label": "MMM DD YYYY (Jan 22 2006)" }, { "value": "%m-%d-%Y", "label": "MM-DD-YYYY (01-22-2006)" }, { "value": "%m/%d/%Y", "label": "MM/DD/YYYY (01/22/2006)" }, { "value": "%m/%d/%y", "label": "MM/DD/YY (01/22/06)" }, { "value": "%d-%m-%Y", "label": "DD-MM-YYYY (22-01-2006)" }, { "value": "%d/%m/%Y", "label": "DD/MM/YYYY (22/01/2006)" }, { "value": "%d/%m/%y", "label": "DD/MM/YY (22/01/06)" }, { "value": "%Y%m%d", "label": "YYYYMMDD (20060106)" }, { "value": "timestamp", "label": "时间戳秒 (1597247662)" }, { "value": "timestamp_ms", "label": "时间戳毫秒(1597247662000)" }, { "value": "custom", "label": "自定义格式" } ] }, { "label": "调整时间", "key": "timedelta", "help_txt": "您可以在日期格式转换后进行时间增加或者减少,请输入一个整数例如1,2,-1,-2" }, { "label": "调整的时间单位", "key": "timedelta_type", "dropdown": true, "choices": [ { "value": "minutes", "label": "分钟" }, { "value": "hours", "label": "小时" }, { "value": "days", "label": "天" } ] } ], "8": [ { "key": "text", "label": "汉字内容", "type": "string", "required": true }, { "key": "trans_type", "label": "转换方式", "type": "string", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "key": "cap", "label": "首字母" }, { "key": "all_cap", "label": "全拼" } ] } ], "9": [ { "key": "text", "label": "汉字内容", "type": "string", "required": true }, { "key": "trans_type", "label": "转换方式", "type": "string", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "key": "cap", "label": "首字母" }, { "key": "all_cap", "label": "全拼" } ] } ], "10": [ { "label": "输入要查询的字段值", "help_txt": "在这里输入要查询的字段", "required": true, "multiples": true, "key": "oldfield", "type": "text" }, { "label": "请输入字段查询表", "key": "table", "help_txt": "请在左边一列输入原字段值,右边一列输入此字段值对应的新字段值", "type": "dict", "required": true }, { "label": "无查询结果时返回值", "key": "default", "help_txt": "如果没有查询到结果返回一个默认参数", "required": true, "type": "string" } ], "11": [], "12": [], "13": [], "14": [] }
[]
[ { "id": 944, "title": "集简云 x 中傲集团 丨零代码连接钉钉和Oracle,让企业业绩实现翻倍增长", "preview": "企业在数字化转型过程中采购了钉钉OA办公协同系统、Oracle数据库,每天有大量客户数据需要录入到2个系统进行维护,人工手动同步数据常耗费大量时间,且无法确保信息的准确性。现在通过集简云搭建一个自动化流程,即可实现钉钉审批后的单据信息会自动同步到Oracle数据库中存储,省去人工在两个系统中来回同步数据的麻烦,大大提高企业员工工作效率,实现业绩翻倍增长。", "content": "<h1><span style=\"color:hsl(240,75%,60%);\"><strong>客户 · 介绍</strong></span></h1><p> </p><p>中傲集团成立于2007年11月,立足互联网+非药品产业,构建专业服务、产业互联、非药品大数据、极速物流、非药品新零售为一体的非药品综合服务商。是目前国内具竞争力的非药品创新型企业。中傲以强大的管理能力,在非药品流通信息化、全国一体化、高效率以及性价比等方面的建设达到了全国领先水平。中傲已不再是单纯的商品销售的贸易公司,而是依靠创新驱动的平台型公司。 </p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>目前覆盖14个省份,近4万余家药店,每年近40%以上速度增长;有3个近万平的高标仓分仓布局,企业人员包括销售人员近300人,内勤人员100余人,现有500余家供应商,下游客户3000余个。</strong></span></p><p> </p><figure class=\"image\"><img src=\"/uploads/99_3f91b399e0.png\"></figure><p> </p><p> </p><h1><span style=\"color:hsl(240,75%,60%);\"><strong>客户 · 遇到的问题</strong></span></h1><p> </p><p>随着互联网的发展,企业数字化转型已经成为必然趋势。中傲集团也不例外,企业采购钉钉OA系统办公协同、Oracle数据库做客户管理,每天有大量客户数据需要录入到2个系统进行维护,通过数据化模式来提升其在市场中的竞争力和盈利能力。</p><p> </p><p>日常,销售人员签单后,需要手动同步到钉钉上提交审批,审批通过后,再查询公司在各个省、市、县等地方的相关资源配置信息,然后录入到Oracle数据库中存储,具体的工作流程如下:</p><p> </p><figure class=\"image\"><img src=\"/uploads/00_e118bc7a1f.png\"></figure><p> </p><p>随着企业规模的不断壮大,业务量上涨,让当前这个看似比较简单的业务流程开始频频暴露问题:</p><p> </p><p><strong>● 1条客户信息,需要在钉钉、Oracle2个系统反复录入2次以上;</strong><br><strong>● 大量复制粘贴工作,经常导致数据出错,影响订单发货;</strong><br><strong>● 数据发生偏差还需重新核对,增加不必要的工作量;</strong><br><strong>● 人工手动录入效率较低,易消耗员工工作热情;</strong><br><strong>● 单据信息有变动,一套工作流程需重新来过;</strong></p><p> </p><p>如果公司想通过自行研发特定技术接口,短期内快速实现对接,需要整个研发部门all in,投入大量时间及精力,后续还需安排专门人员进行维护,对于企业来说,成本过高;如果通过外包厂商来实现,想法产生到落地执行再到真正使用,一个环节扣着一个环节,常常需要对接多名人员,沟通成本高;</p><p> </p><p>无论哪一种方式,对于企业来说,都无法快速满足业务需求,且成本过高,也并不是一笔划算的买卖。<strong>那么,到底该如何高效、低成本地解决这个问题呢?</strong></p><p> </p><p> </p><h1><span style=\"color:hsl(240,75%,60%);\"><strong>钉钉 & 集简云解决方案</strong></span></h1><p> </p><p>集简云是一款超级软件连接器,通过集简云无需任何开发就可以将钉钉OA与Oracle系统之间的数据进行打通,让应用与应用之间的数据实现自动同步,我们只需要在集简云搭建一个数据流程即可让整个工作流程实现自动化运转。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ “钉钉自建无需API开发连接Oracle”自动化方案如下:</strong></span></p><p><br>步骤1:触发动作【钉钉自建-当符合条件的审批流实例结束时】<br>步骤2:执行动作【钉钉自建-查询审批实例详情】<br>步骤3:执行动作【数据筛选-设置筛选条件】<br>步骤4:执行动作【维格表-公式搜索数据】<br>步骤5:执行动作【数组处理-将数组转换为文本】<br>步骤6:执行动作【钉钉自建-发送文本消息】<br>步骤7:执行动作【日期时间格式变更-调整日期时间格式】<br>步骤8:执行动作【文本处理-将汉字转换成拼音】<br>步骤9:执行动作【文本处理-将汉字转换成拼音】<br>步骤10:执行动作【字段查询-批量设置匹配关系】<br>步骤11:执行动作【Oracle-新增数据到指定数据表】<br>步骤12:执行动作【Oracle-新增数据到指定数据表】<br>步骤13:执行动作【Oracle-新增数据到指定数据表】<br>步骤14:执行动作【Oracle-新增数据到指定数据表】</p><p> </p><figure class=\"image\"><img src=\"/uploads/77_e28a36fd4d.gif\"></figure><p style=\"text-align:center;\"><a href=\"https://www.jijyun.cn/apps/processes/2230\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color:hsl(210,75%,60%);\">点击此模板,立即使用</span></a></p><p style=\"text-align:center;\"> </p><p>实现效果:通过集简云搭建的自动化流程,让中傲集团实现了钉钉OA与Oracle系统之间的数据互联,审批单据信息可以在两个系统间来回流转,自动同步及更新,企业人员无需再二次同步信息,大大提高效率。</p><p> </p><p><strong>原本需要研发技术人员数十个工作日才能完成的流程对接工作,在集简云零代码集成功能的帮助下,不到1个工作日就完成了搭建,调试与上线使用。</strong></p><p> </p><p> </p><h1><strong>客户 · 反馈</strong></h1><p> </p><p>中傲集团核心业务负责人称,自动使用了集简云这款超级软件连接器,给我们最直观的感受就是,无需人工操作,钉钉OA上的一条单据录入到Oracle数据库仅需几秒钟即可完成同步。整体实现的效果如下:</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【钉钉和Oracle数据自动同步】</strong></span><br>审批通过后,数据可自动同步至Oracle数据库存储,减少不必要的流程,大大提升协作效率。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【无代码实现自动化流程】</strong></span><br>无需繁琐的工作步骤,只需一个流程,即可轻松实现两个系统自动连接。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【高效提升资源整合效率】</strong></span><br> 借助两个系统数据自动互通,公司可以充分整合在销售人员整理数据,单据审批等板块的资源。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【助力企业降本增效】</strong></span><br>无需高昂的研发费用,即可方便、快速地实现钉钉OA系统与Oracle系统之间的数据互通。</p><p> </p><p>总而言之,集简云着实是一款降本增效的工具,可以帮助企业增强创新能力,加快发展步伐,创造更多的经营效益,真正实现\"高效益\"经营目标。也正如集简云所说,业务流程自动化与智能化是企业新的增长引擎!</p><p> </p>", "sort": null, "usage": "help_doc", "published_at": "2023-02-06T07:15:42.000Z", "created_at": "2023-02-06T07:05:26.000Z", "updated_at": "2023-03-09T10:03:47.000Z", "help_collection": 6, "video_url": null, "field": null, "weight": 0, "select": false, "seo": null, "thumb": { "id": 9030, "name": "画板 – 2.png", "alternativeText": "", "caption": "", "width": 200, "height": 120, "formats": null, "hash": "2_1697e10b22", "ext": ".png", "mime": "image/png", "size": 30.1, "url": "/uploads/2_1697e10b22.png", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2023-02-06T07:10:30.000Z", "updated_at": "2023-02-06T07:10:30.000Z" }, "media": { "id": 9029, "name": "自定义大小 – 38.png", "alternativeText": "", "caption": "", "width": 1027, "height": 440, "formats": { "thumbnail": { "name": "thumbnail_自定义大小 – 38.png", "hash": "thumbnail_38_1005715449", "ext": ".png", "mime": "image/png", "width": 245, "height": 105, "size": 35.72, "path": null, "url": "/uploads/thumbnail_38_1005715449.png" }, "large": { "name": "large_自定义大小 – 38.png", "hash": "large_38_1005715449", "ext": ".png", "mime": "image/png", "width": 1000, "height": 428, "size": 465.42, "path": null, "url": "/uploads/large_38_1005715449.png" }, "medium": { "name": "medium_自定义大小 – 38.png", "hash": "medium_38_1005715449", "ext": ".png", "mime": "image/png", "width": 750, "height": 321, "size": 273.5, "path": null, "url": "/uploads/medium_38_1005715449.png" }, "small": { "name": "small_自定义大小 – 38.png", "hash": "small_38_1005715449", "ext": ".png", "mime": "image/png", "width": 500, "height": 214, "size": 129.08, "path": null, "url": "/uploads/small_38_1005715449.png" } }, "hash": "38_1005715449", "ext": ".png", "mime": "image/png", "size": 333.79, "url": "/uploads/38_1005715449.png", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2023-02-06T07:10:10.000Z", "updated_at": "2023-02-06T07:10:11.000Z" } } ]
[ { "id": 25, "name": "钉钉(自建应用)", "description": "<p>钉钉,阿里巴巴出品,专为全球企业组织打造的智能移动办公平台,含PC版,Ipad和手机版。远程视频会议,消息已读未读,DING消息任务管理,让沟通更高效;移动办公考勤,签到,审批,企业邮箱,免费企业OA,企业通讯录,钉钉教育解决方案,让工作学习更简单!</p>", "popular": 216, "published_at": "2021-10-25T03:01:37.000Z", "created_at": "2021-10-25T03:01:35.000Z", "updated_at": "2023-01-28T09:03:31.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1811, "name": "Dingding.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Dingding_ac75c3cf81", "ext": ".svg", "mime": "image/svg+xml", "size": 9.4, "url": "/uploads/Dingding_ac75c3cf81.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:46:50.000Z", "updated_at": "2022-01-26T02:46:50.000Z" } }, { "id": 9, "name": "数据筛选", "description": "<p>数据筛选是集简云的一个内置应用,用于判断数据流程中数据是否符合筛选条件,如果符合筛选条件则继续后续的流程步骤,如果不符合则不会执行后续的流程步骤。</p>", "popular": -12, "published_at": "2021-10-25T02:45:30.000Z", "created_at": "2021-10-25T02:45:27.000Z", "updated_at": "2022-04-21T08:47:17.000Z", "app_id": "7", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "设置筛选条件", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3475, "name": "windeal-filter.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "windeal_filter_0ad26bc0ae", "ext": ".svg", "mime": "image/svg+xml", "size": 0.86, "url": "/uploads/windeal_filter_0ad26bc0ae.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:47:14.000Z", "updated_at": "2022-04-21T08:47:14.000Z" } }, { "id": 631, "name": "数组处理", "description": "<p>数组处理是集简云的一款内置应用,用于将文本变量内容生成一组数组或者将一组数组转换成文本内容,以便用于后续的流程步骤中。</p>", "popular": -1, "published_at": "2022-08-25T05:54:52.000Z", "created_at": "2022-08-25T05:39:49.000Z", "updated_at": "2022-08-25T06:16:51.000Z", "app_id": "1000454", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "集简云内置应用", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 5862, "name": "shuzuchuli.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "shuzuchuli_114ea035f2", "ext": ".svg", "mime": "image/svg+xml", "size": 2.71, "url": "/uploads/shuzuchuli_114ea035f2.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-08-25T05:54:16.000Z", "updated_at": "2022-08-25T05:54:16.000Z" } }, { "id": 52, "name": "日期时间格式变更", "description": "<p>日期时间格式变更帮助解决不同应用步骤中对日期时间格式的不同要求。比如应用A中的日期格式是“年月日”的格式,应用B中的日期格式是时间戳或者其他时间格式,在这种情况下,我们可以在应用A步骤与应用B步骤之间添加一个日期时间格式变更步骤,将时间格式转换后再进行同步。</p>", "popular": 55, "published_at": "2021-10-25T03:26:32.000Z", "created_at": "2021-10-25T03:26:30.000Z", "updated_at": "2023-02-20T11:20:39.000Z", "app_id": "89", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "变更日期时间格式", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3479, "name": "datetime.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "datetime_bed27e05e9", "ext": ".svg", "mime": "image/svg+xml", "size": 1.4, "url": "/uploads/datetime_bed27e05e9.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:50:28.000Z", "updated_at": "2022-04-21T08:50:28.000Z" } }, { "id": 71, "name": "文本处理", "description": "<p>文本处理是集简云内置应用,用于对文字内容的格式进行调整,以便在后续的流程中更好的使用。</p>", "popular": -13, "published_at": "2021-10-25T03:47:29.000Z", "created_at": "2021-10-25T03:47:27.000Z", "updated_at": "2022-04-21T08:49:18.000Z", "app_id": "108", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "转换文本内容", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3476, "name": "wenbenzhuanhuan.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "wenbenzhuanhuan_0a62076317", "ext": ".svg", "mime": "image/svg+xml", "size": 2.96, "url": "/uploads/wenbenzhuanhuan_0a62076317.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:49:15.000Z", "updated_at": "2022-04-21T08:49:15.000Z" } }, { "id": 106, "name": "字段查询", "description": "<p>字段查询是集简云的一个内置应用,可做为执行应用使用。其主要功能是设置一个字段列表进行字段匹配关系查询。</p>", "popular": -20, "published_at": "2021-10-25T06:04:16.000Z", "created_at": "2021-10-25T06:04:14.000Z", "updated_at": "2022-08-10T03:32:26.000Z", "app_id": "148", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "查询预设的字段关系", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3482, "name": "ziduanchaxun.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "ziduanchaxun_1c0c5dd6d7", "ext": ".svg", "mime": "image/svg+xml", "size": 0.74, "url": "/uploads/ziduanchaxun_1c0c5dd6d7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:55:13.000Z", "updated_at": "2022-04-21T08:55:13.000Z" } }, { "id": 753, "name": "Oracle", "description": "<p>Oracle系统,即是以Oracle关系数据库为数据存储和管理作为构架基础,构建出的数据库管理系统。 Oracle,世界第一个支持SQL语言的商业数据库,定位于高端工作站,以及作为服务器的小型计算机,如IBM P系列服务器、HP的Integraty服务器、Sun Fire服务器。</p>", "popular": 138, "published_at": "2022-09-29T11:12:39.000Z", "created_at": "2022-09-29T03:27:09.000Z", "updated_at": "2022-09-29T11:12:39.000Z", "app_id": "365", "category": "Developer", "locale": "zh-Hans", "short_description": "关系数据库管理系统", "available": true, "appid": null, "website": " https://www.oracle.com", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 6485, "name": "oracle.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "oracle_679b21561d", "ext": ".svg", "mime": "image/svg+xml", "size": 0.56, "url": "/uploads/oracle_679b21561d.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-09-29T06:14:44.000Z", "updated_at": "2022-09-29T06:14:44.000Z" } }, { "id": 524, "name": "维格表", "description": "<p>维格表将过去复杂的IT数据库技术,做得像表格一样简单 ,可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一,1个维格表,满足团队协作、项目管理、数据协作等1000+场景,让所有工作连接和整合。</p>", "popular": 1, "published_at": "2022-07-25T08:32:52.000Z", "created_at": "2022-07-25T08:32:52.000Z", "updated_at": "2023-01-28T09:02:30.000Z", "app_id": "310", "category": "Teamwork", "locale": "zh-Hans", "short_description": "低代码应用表单系统", "available": true, "appid": null, "website": "https://vika.cn/", "video": null, "videos": null, "app_version": "1.0.1", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 5408, "name": "weigebiao_9542978808.svg", "alternativeText": "", "caption": "", "width": null, "height": null, "formats": null, "hash": "weigebiao_9542978808_c8cf818960", "ext": ".svg", "mime": "image/svg+xml", "size": 7.89, "url": "/uploads/weigebiao_9542978808_c8cf818960.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-07-25T08:39:11.000Z", "updated_at": "2022-07-25T08:39:11.000Z" } } ]
[ { "id": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 }, { "id": 4, "name": "客户管理", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:35.000Z", "created_at": "2022-05-20T08:12:43.000Z", "updated_at": "2022-05-30T07:29:35.000Z", "sort": 2 } ]
[ { "id": 4968, "key": null, "published_at": "2023-01-31T11:01:20.000Z", "created_at": "2023-01-31T11:01:20.000Z", "updated_at": "2023-01-31T11:01:20.000Z", "action_id": "1003836", "action_name": "将数组转换为文本", "error": null, "description": "将数组中的元素按照指定的符号连接成一个字符串", "action_type": "action", "app": null, "template": null }, { "id": 22, "key": null, "published_at": "2021-11-24T06:19:25.000Z", "created_at": "2021-11-24T06:19:22.000Z", "updated_at": "2021-11-24T06:19:25.000Z", "action_id": "15", "action_name": "设置筛选条件", "error": null, "description": "设置筛选条件,只有筛选条件满足后才会继续后续流程步骤", "action_type": "action", "app": null, "template": null }, { "id": 54, "key": null, "published_at": "2021-11-24T06:44:05.000Z", "created_at": "2021-11-24T06:44:03.000Z", "updated_at": "2021-11-24T06:44:05.000Z", "action_id": "241", "action_name": "日期时间格式调整", "error": null, "description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "action_type": "action", "app": null, "template": null }, { "id": 2753, "key": null, "published_at": "2022-07-27T08:43:55.000Z", "created_at": "2022-07-27T08:43:55.000Z", "updated_at": "2022-07-27T08:43:55.000Z", "action_id": "2514", "action_name": "汉字转换成拼音", "error": null, "description": "根据汉字转换成拼音", "action_type": "action", "app": null, "template": null }, { "id": 2933, "key": null, "published_at": "2022-08-11T04:09:25.000Z", "created_at": "2022-08-11T04:09:25.000Z", "updated_at": "2022-08-11T04:09:25.000Z", "action_id": "2635", "action_name": "当符合条件的审批流实例结束时", "error": null, "description": "当符合条件的审批流实例结束时", "action_type": "trigger", "app": null, "template": null }, { "id": 3310, "key": null, "published_at": "2022-09-15T11:16:56.000Z", "created_at": "2022-09-15T11:16:56.000Z", "updated_at": "2022-09-15T11:16:56.000Z", "action_id": "2850", "action_name": "查询审批实例详情1.0.1", "error": null, "description": "查询审批实例详情(新抹平)", "action_type": "action", "app": null, "template": null }, { "id": 3508, "key": null, "published_at": "2022-09-29T11:15:46.000Z", "created_at": "2022-09-29T11:15:46.000Z", "updated_at": "2022-09-29T11:15:46.000Z", "action_id": "2888", "action_name": "新增数据到指定数据表", "error": null, "description": "添加数据到指定Oracle数据表中", "action_type": "action", "app": null, "template": null }, { "id": 4048, "key": null, "published_at": "2022-11-11T09:57:57.000Z", "created_at": "2022-11-11T09:57:57.000Z", "updated_at": "2022-11-11T09:57:57.000Z", "action_id": "3070", "action_name": "批量设置匹配关系", "error": null, "description": "批量根据字段内容进行设置匹配关系", "action_type": "action", "app": null, "template": null }, { "id": 304, "key": null, "published_at": "2021-11-29T09:05:26.000Z", "created_at": "2021-11-29T09:05:24.000Z", "updated_at": "2021-11-29T09:05:26.000Z", "action_id": "402", "action_name": " 发送文本消息", "error": null, "description": "通过输入指定成员ID发送文本", "action_type": "action", "app": null, "template": null }, { "id": 239, "key": null, "published_at": "2021-11-26T05:46:39.000Z", "created_at": "2021-11-26T05:46:36.000Z", "updated_at": "2021-11-26T05:46:39.000Z", "action_id": "541", "action_name": "公式搜索数据", "error": null, "description": "公式搜索维格表数据", "action_type": "action", "app": null, "template": null } ]
[]
[]
100+
100+
99
100+
71
Msg
2230
钉钉审批后,同步数据到Oracle(有些系统没有API接口,可以对接数据库)
<p>当钉钉有符合条件的审批流实例结束时,使用钉钉动作查询审批实例详情,数据筛选设置筛选条件,使用维格表公式搜索数据,并用数组处理将数组转换为文本,钉钉(自建应用) 发送文本消息(发送给自己,为了确认数据是否正确),日期时间格式变更日期时间格式调整,文本处理汉字转换成拼音,文本处理汉字转换成拼音,字段查询批量设置匹配关系,通过前面4个步骤将数据转换未Oracle指定的数据类型,最终将数据写入到Oracle指定数据表</p>
zh-Hans
2023-02-01T02:09:15.000Z
2023-02-01T02:09:15.000Z
2023-04-06T06:02:52.000Z
ay4830az
当钉钉有符合条件的审批流实例结束时,使用钉钉动作查询审批实例详情,数据筛选设置筛选条件,使用维格表公式搜索数据,并用数组处理将数组转换为文本,钉钉(自建应用) 发送文本消息(发送给自己,为了确认数据是否正确),日期时间格式变更日期时间格式调整,文本处理汉字转换成拼音,文本处理汉字转换成拼音,字段查询批量设置匹配关系,通过前面4个步骤将数据转换未Oracle指定的数据类型,最终将数据写入到Oracle指定数据表
anyone
9YJVEH82iyqD
official
pc1265
passed
谢晓鸣
ay4830az
谢晓鸣
[ { "desc": "当符合条件的审批流程实例结束时(支持通过审批模板code和操作类型筛选)", "app_id": 69, "action_id": 2635, "action_type": "1", "sort": "1", "note": null }, { "desc": "使用钉钉自建应用询审批实例详情(新抹平)", "app_id": 69, "action_id": 2850, "action_type": "2", "sort": "2", "note": null }, { "desc": "设置筛选条件,只有筛选条件满足后才会继续后续流程步骤", "app_id": 7, "action_id": 15, "action_type": "2", "sort": "3", "note": null }, { "desc": "根据条件公式(包含并且,或等公式)进行数据查询", "app_id": 310, "action_id": 541, "action_type": "2", "sort": "4", "note": null }, { "desc": "将数组中的元素按照指定的符号连接成一个字符串", "app_id": 1000454, "action_id": 1003836, "action_type": "2", "sort": "5", "note": null }, { "desc": "使用钉钉自建应用指定员工或部门发送文本消息", "app_id": 69, "action_id": 402, "action_type": "2", "sort": "6", "note": null }, { "desc": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "app_id": 89, "action_id": 241, "action_type": "2", "sort": "7", "note": null }, { "desc": "根据汉字转换成拼音", "app_id": 108, "action_id": 2514, "action_type": "2", "sort": "8", "note": null }, { "desc": "根据汉字转换成拼音", "app_id": 108, "action_id": 2514, "action_type": "2", "sort": "9", "note": null }, { "desc": "批量根据字段内容进行设置匹配关系", "app_id": 148, "action_id": 3070, "action_type": "2", "sort": "10", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "11", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "12", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "13", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "14", "note": null } ]
1
false
4
{ "1": [ { "key": "process_code", "label": "模板code", "type": "string", "help_txt": "请在旧版钉钉网页端企业管理后台内编辑审批流程,当前页面的URL中process_code后即可获取, 不填将返回所有模板的审批事件" }, { "key": "result", "label": "状态", "type": "string", "dropdown": true, "choices": [ { "key": "agree", "label": "同意" }, { "key": "refuse", "label": "拒绝" } ], "help_txt": "不填将返回所有审批结果的审批事件" } ], "2": [ { "key": "process_instance_id", "label": "审批实例ID", "type": "string", "required": true, "help_txt": "可以从触发动作中或者执行动作获取审批实例ID列表中获取" }, { "key": "is_file", "label": "是否获取审批中的附件", "type": "string", "dropdown": true, "choices": [ { "key": "true", "label": "是" }, { "key": "false", "label": "否" } ], "help_txt": "获取审批实例中的附件,并提供附件的下载链接。附件在平台最多保存30天,评论中上传的附件暂时不支持获取下载链接", "defaulttext": "true" } ], "3": [], "4": [ { "key": "sheet_id", "label": "选择维格表", "dropdownTree": true, "required": true, "dynamic": true, "queryParams": [ { "label": "父节点id", "key": "node_id", "is_key": true }, { "label": "标识", "key": "flag", "defaulttext": "root_node" } ], "url": "/v1/api/application/newViKaTable/dropdownTree/nodesList", "choices": [] } ], "5": [], "6": [ { "label": "接收员工", "key": "userid_list", "help_txt": "接收消息员工的userid;可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取", "type": "string", "multiples": true }, { "key": "dept_id_list", "label": "接收部门", "dropdownTree": true, "multiplesTree": true, "queryParams": [ { "label": "父节点id", "key": "node_id", "is_key": true, "defaulttext": 1 }, { "label": "标识", "key": "flag", "defaulttext": 1 } ], "url": "/v1/api/process/dingding/dropdowntree/get_dept", "choices": [], "help_txt": "请选择接收部门,消息接收者和接收部门不能同时为空" }, { "label": "发送内容", "required": true, "help_txt": "请输入发送内容", "key": "content", "type": "string" } ], "7": [ { "label": "请输入要调整的日期时间", "key": "from_time", "required": true, "multiples": true, "help_txt": "填写一个日期时间或者选择上面步骤中的动态日期时间字段" }, { "label": "请输入当前日期时间格式", "key": "from_time_type", "required": true, "dropdown": true, "dynamic": true, "help_txt": "请选择上面输入的日期时间格式以便正确的进行格式转换", "choices": [ { "value": "auto_format", "label": "自动识别格式" }, { "value": "%Y年%m月%d日 %H:%M:%S", "label": "YYYY年MM月DD日 HH:mm:ss(2006年01月22日 13:29:54)" }, { "value": "%Y年%m月%d日", "label": "YYYY年MM月DD日(2006年01月22日)" }, { "value": "%B %d %Y %H:%M:%S", "label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)" }, { "value": "%Y-%m-%dT%H:%M:%S.%fZ", "label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)" }, { "value": "%Y-%m-%dT%H:%M:%SZ", "label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)" }, { "value": "%B %d %Y", "label": "MMMM DD YYYY (January 22 2006)" }, { "value": "%b %d %Y", "label": "MMM DD YYYY (Jan 22 2006)" }, { "value": "%m-%d-%Y", "label": "MM-DD-YYYY (01-22-2006)" }, { "value": "%m/%d/%Y", "label": "MM/DD/YYYY (01/22/2006)" }, { "value": "%m/%d/%y", "label": "MM/DD/YY (01/22/06)" }, { "value": "%d-%m-%Y", "label": "DD-MM-YYYY (22-01-2006)" }, { "value": "%d/%m/%Y", "label": "DD/MM/YYYY (22/01/2006)" }, { "value": "%d/%m/%y", "label": "DD/MM/YY (22/01/06)" }, { "value": "%Y%m%d", "label": "YYYYMMDD (20060106)" }, { "value": "timestamp", "label": "时间戳秒 (1597247662)" }, { "value": "timestamp_ms", "label": "时间戳毫秒(1597247662000)" }, { "value": "custom", "label": "自定义格式" } ], "defaulttext": "auto_format" }, { "label": "请输入要转换到的日期时间格式", "key": "to_time_type", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "value": "%Y年%m月%d日 %H:%M:%S", "label": "YYYY年MM月DD日 HH:mm:ss(2006年01月22日 13:29:54)" }, { "value": "%Y年%m月%d日", "label": "YYYY年MM月DD日(2006年01月22日)" }, { "value": "%B %d %Y %H:%M:%S", "label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)" }, { "value": "%Y-%m-%dT%H:%M:%S.%fZ", "label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)" }, { "value": "%Y-%m-%dT%H:%M:%SZ", "label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)" }, { "value": "%B %d %Y", "label": "MMMM DD YYYY (January 22 2006)" }, { "value": "%b %d %Y", "label": "MMM DD YYYY (Jan 22 2006)" }, { "value": "%m-%d-%Y", "label": "MM-DD-YYYY (01-22-2006)" }, { "value": "%m/%d/%Y", "label": "MM/DD/YYYY (01/22/2006)" }, { "value": "%m/%d/%y", "label": "MM/DD/YY (01/22/06)" }, { "value": "%d-%m-%Y", "label": "DD-MM-YYYY (22-01-2006)" }, { "value": "%d/%m/%Y", "label": "DD/MM/YYYY (22/01/2006)" }, { "value": "%d/%m/%y", "label": "DD/MM/YY (22/01/06)" }, { "value": "%Y%m%d", "label": "YYYYMMDD (20060106)" }, { "value": "timestamp", "label": "时间戳秒 (1597247662)" }, { "value": "timestamp_ms", "label": "时间戳毫秒(1597247662000)" }, { "value": "custom", "label": "自定义格式" } ] }, { "label": "调整时间", "key": "timedelta", "help_txt": "您可以在日期格式转换后进行时间增加或者减少,请输入一个整数例如1,2,-1,-2" }, { "label": "调整的时间单位", "key": "timedelta_type", "dropdown": true, "choices": [ { "value": "minutes", "label": "分钟" }, { "value": "hours", "label": "小时" }, { "value": "days", "label": "天" } ] } ], "8": [ { "key": "text", "label": "汉字内容", "type": "string", "required": true }, { "key": "trans_type", "label": "转换方式", "type": "string", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "key": "cap", "label": "首字母" }, { "key": "all_cap", "label": "全拼" } ] } ], "9": [ { "key": "text", "label": "汉字内容", "type": "string", "required": true }, { "key": "trans_type", "label": "转换方式", "type": "string", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "key": "cap", "label": "首字母" }, { "key": "all_cap", "label": "全拼" } ] } ], "10": [ { "label": "输入要查询的字段值", "help_txt": "在这里输入要查询的字段", "required": true, "multiples": true, "key": "oldfield", "type": "text" }, { "label": "请输入字段查询表", "key": "table", "help_txt": "请在左边一列输入原字段值,右边一列输入此字段值对应的新字段值", "type": "dict", "required": true }, { "label": "无查询结果时返回值", "key": "default", "help_txt": "如果没有查询到结果返回一个默认参数", "required": true, "type": "string" } ], "11": [], "12": [], "13": [], "14": [] }
[]
[ { "id": 944, "title": "集简云 x 中傲集团 丨零代码连接钉钉和Oracle,让企业业绩实现翻倍增长", "preview": "企业在数字化转型过程中采购了钉钉OA办公协同系统、Oracle数据库,每天有大量客户数据需要录入到2个系统进行维护,人工手动同步数据常耗费大量时间,且无法确保信息的准确性。现在通过集简云搭建一个自动化流程,即可实现钉钉审批后的单据信息会自动同步到Oracle数据库中存储,省去人工在两个系统中来回同步数据的麻烦,大大提高企业员工工作效率,实现业绩翻倍增长。", "content": "<h1><span style=\"color:hsl(240,75%,60%);\"><strong>客户 · 介绍</strong></span></h1><p> </p><p>中傲集团成立于2007年11月,立足互联网+非药品产业,构建专业服务、产业互联、非药品大数据、极速物流、非药品新零售为一体的非药品综合服务商。是目前国内具竞争力的非药品创新型企业。中傲以强大的管理能力,在非药品流通信息化、全国一体化、高效率以及性价比等方面的建设达到了全国领先水平。中傲已不再是单纯的商品销售的贸易公司,而是依靠创新驱动的平台型公司。 </p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>目前覆盖14个省份,近4万余家药店,每年近40%以上速度增长;有3个近万平的高标仓分仓布局,企业人员包括销售人员近300人,内勤人员100余人,现有500余家供应商,下游客户3000余个。</strong></span></p><p> </p><figure class=\"image\"><img src=\"/uploads/99_3f91b399e0.png\"></figure><p> </p><p> </p><h1><span style=\"color:hsl(240,75%,60%);\"><strong>客户 · 遇到的问题</strong></span></h1><p> </p><p>随着互联网的发展,企业数字化转型已经成为必然趋势。中傲集团也不例外,企业采购钉钉OA系统办公协同、Oracle数据库做客户管理,每天有大量客户数据需要录入到2个系统进行维护,通过数据化模式来提升其在市场中的竞争力和盈利能力。</p><p> </p><p>日常,销售人员签单后,需要手动同步到钉钉上提交审批,审批通过后,再查询公司在各个省、市、县等地方的相关资源配置信息,然后录入到Oracle数据库中存储,具体的工作流程如下:</p><p> </p><figure class=\"image\"><img src=\"/uploads/00_e118bc7a1f.png\"></figure><p> </p><p>随着企业规模的不断壮大,业务量上涨,让当前这个看似比较简单的业务流程开始频频暴露问题:</p><p> </p><p><strong>● 1条客户信息,需要在钉钉、Oracle2个系统反复录入2次以上;</strong><br><strong>● 大量复制粘贴工作,经常导致数据出错,影响订单发货;</strong><br><strong>● 数据发生偏差还需重新核对,增加不必要的工作量;</strong><br><strong>● 人工手动录入效率较低,易消耗员工工作热情;</strong><br><strong>● 单据信息有变动,一套工作流程需重新来过;</strong></p><p> </p><p>如果公司想通过自行研发特定技术接口,短期内快速实现对接,需要整个研发部门all in,投入大量时间及精力,后续还需安排专门人员进行维护,对于企业来说,成本过高;如果通过外包厂商来实现,想法产生到落地执行再到真正使用,一个环节扣着一个环节,常常需要对接多名人员,沟通成本高;</p><p> </p><p>无论哪一种方式,对于企业来说,都无法快速满足业务需求,且成本过高,也并不是一笔划算的买卖。<strong>那么,到底该如何高效、低成本地解决这个问题呢?</strong></p><p> </p><p> </p><h1><span style=\"color:hsl(240,75%,60%);\"><strong>钉钉 & 集简云解决方案</strong></span></h1><p> </p><p>集简云是一款超级软件连接器,通过集简云无需任何开发就可以将钉钉OA与Oracle系统之间的数据进行打通,让应用与应用之间的数据实现自动同步,我们只需要在集简云搭建一个数据流程即可让整个工作流程实现自动化运转。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ “钉钉自建无需API开发连接Oracle”自动化方案如下:</strong></span></p><p><br>步骤1:触发动作【钉钉自建-当符合条件的审批流实例结束时】<br>步骤2:执行动作【钉钉自建-查询审批实例详情】<br>步骤3:执行动作【数据筛选-设置筛选条件】<br>步骤4:执行动作【维格表-公式搜索数据】<br>步骤5:执行动作【数组处理-将数组转换为文本】<br>步骤6:执行动作【钉钉自建-发送文本消息】<br>步骤7:执行动作【日期时间格式变更-调整日期时间格式】<br>步骤8:执行动作【文本处理-将汉字转换成拼音】<br>步骤9:执行动作【文本处理-将汉字转换成拼音】<br>步骤10:执行动作【字段查询-批量设置匹配关系】<br>步骤11:执行动作【Oracle-新增数据到指定数据表】<br>步骤12:执行动作【Oracle-新增数据到指定数据表】<br>步骤13:执行动作【Oracle-新增数据到指定数据表】<br>步骤14:执行动作【Oracle-新增数据到指定数据表】</p><p> </p><figure class=\"image\"><img src=\"/uploads/77_e28a36fd4d.gif\"></figure><p style=\"text-align:center;\"><a href=\"https://www.jijyun.cn/apps/processes/2230\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color:hsl(210,75%,60%);\">点击此模板,立即使用</span></a></p><p style=\"text-align:center;\"> </p><p>实现效果:通过集简云搭建的自动化流程,让中傲集团实现了钉钉OA与Oracle系统之间的数据互联,审批单据信息可以在两个系统间来回流转,自动同步及更新,企业人员无需再二次同步信息,大大提高效率。</p><p> </p><p><strong>原本需要研发技术人员数十个工作日才能完成的流程对接工作,在集简云零代码集成功能的帮助下,不到1个工作日就完成了搭建,调试与上线使用。</strong></p><p> </p><p> </p><h1><strong>客户 · 反馈</strong></h1><p> </p><p>中傲集团核心业务负责人称,自动使用了集简云这款超级软件连接器,给我们最直观的感受就是,无需人工操作,钉钉OA上的一条单据录入到Oracle数据库仅需几秒钟即可完成同步。整体实现的效果如下:</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【钉钉和Oracle数据自动同步】</strong></span><br>审批通过后,数据可自动同步至Oracle数据库存储,减少不必要的流程,大大提升协作效率。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【无代码实现自动化流程】</strong></span><br>无需繁琐的工作步骤,只需一个流程,即可轻松实现两个系统自动连接。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【高效提升资源整合效率】</strong></span><br> 借助两个系统数据自动互通,公司可以充分整合在销售人员整理数据,单据审批等板块的资源。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【助力企业降本增效】</strong></span><br>无需高昂的研发费用,即可方便、快速地实现钉钉OA系统与Oracle系统之间的数据互通。</p><p> </p><p>总而言之,集简云着实是一款降本增效的工具,可以帮助企业增强创新能力,加快发展步伐,创造更多的经营效益,真正实现\"高效益\"经营目标。也正如集简云所说,业务流程自动化与智能化是企业新的增长引擎!</p><p> </p>", "sort": null, "usage": "help_doc", "published_at": "2023-02-06T07:15:42.000Z", "created_at": "2023-02-06T07:05:26.000Z", "updated_at": "2023-03-09T10:03:47.000Z", "help_collection": 6, "video_url": null, "field": null, "weight": 0, "select": false, "seo": null, "thumb": { "id": 9030, "name": "画板 – 2.png", "alternativeText": "", "caption": "", "width": 200, "height": 120, "formats": null, "hash": "2_1697e10b22", "ext": ".png", "mime": "image/png", "size": 30.1, "url": "/uploads/2_1697e10b22.png", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2023-02-06T07:10:30.000Z", "updated_at": "2023-02-06T07:10:30.000Z" }, "media": { "id": 9029, "name": "自定义大小 – 38.png", "alternativeText": "", "caption": "", "width": 1027, "height": 440, "formats": { "thumbnail": { "name": "thumbnail_自定义大小 – 38.png", "hash": "thumbnail_38_1005715449", "ext": ".png", "mime": "image/png", "width": 245, "height": 105, "size": 35.72, "path": null, "url": "/uploads/thumbnail_38_1005715449.png" }, "large": { "name": "large_自定义大小 – 38.png", "hash": "large_38_1005715449", "ext": ".png", "mime": "image/png", "width": 1000, "height": 428, "size": 465.42, "path": null, "url": "/uploads/large_38_1005715449.png" }, "medium": { "name": "medium_自定义大小 – 38.png", "hash": "medium_38_1005715449", "ext": ".png", "mime": "image/png", "width": 750, "height": 321, "size": 273.5, "path": null, "url": "/uploads/medium_38_1005715449.png" }, "small": { "name": "small_自定义大小 – 38.png", "hash": "small_38_1005715449", "ext": ".png", "mime": "image/png", "width": 500, "height": 214, "size": 129.08, "path": null, "url": "/uploads/small_38_1005715449.png" } }, "hash": "38_1005715449", "ext": ".png", "mime": "image/png", "size": 333.79, "url": "/uploads/38_1005715449.png", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2023-02-06T07:10:10.000Z", "updated_at": "2023-02-06T07:10:11.000Z" } } ]
[ { "id": 25, "name": "钉钉(自建应用)", "description": "<p>钉钉,阿里巴巴出品,专为全球企业组织打造的智能移动办公平台,含PC版,Ipad和手机版。远程视频会议,消息已读未读,DING消息任务管理,让沟通更高效;移动办公考勤,签到,审批,企业邮箱,免费企业OA,企业通讯录,钉钉教育解决方案,让工作学习更简单!</p>", "popular": 216, "published_at": "2021-10-25T03:01:37.000Z", "created_at": "2021-10-25T03:01:35.000Z", "updated_at": "2023-01-28T09:03:31.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1811, "name": "Dingding.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Dingding_ac75c3cf81", "ext": ".svg", "mime": "image/svg+xml", "size": 9.4, "url": "/uploads/Dingding_ac75c3cf81.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:46:50.000Z", "updated_at": "2022-01-26T02:46:50.000Z" } }, { "id": 9, "name": "数据筛选", "description": "<p>数据筛选是集简云的一个内置应用,用于判断数据流程中数据是否符合筛选条件,如果符合筛选条件则继续后续的流程步骤,如果不符合则不会执行后续的流程步骤。</p>", "popular": -12, "published_at": "2021-10-25T02:45:30.000Z", "created_at": "2021-10-25T02:45:27.000Z", "updated_at": "2022-04-21T08:47:17.000Z", "app_id": "7", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "设置筛选条件", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3475, "name": "windeal-filter.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "windeal_filter_0ad26bc0ae", "ext": ".svg", "mime": "image/svg+xml", "size": 0.86, "url": "/uploads/windeal_filter_0ad26bc0ae.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:47:14.000Z", "updated_at": "2022-04-21T08:47:14.000Z" } }, { "id": 631, "name": "数组处理", "description": "<p>数组处理是集简云的一款内置应用,用于将文本变量内容生成一组数组或者将一组数组转换成文本内容,以便用于后续的流程步骤中。</p>", "popular": -1, "published_at": "2022-08-25T05:54:52.000Z", "created_at": "2022-08-25T05:39:49.000Z", "updated_at": "2022-08-25T06:16:51.000Z", "app_id": "1000454", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "集简云内置应用", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 5862, "name": "shuzuchuli.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "shuzuchuli_114ea035f2", "ext": ".svg", "mime": "image/svg+xml", "size": 2.71, "url": "/uploads/shuzuchuli_114ea035f2.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-08-25T05:54:16.000Z", "updated_at": "2022-08-25T05:54:16.000Z" } }, { "id": 52, "name": "日期时间格式变更", "description": "<p>日期时间格式变更帮助解决不同应用步骤中对日期时间格式的不同要求。比如应用A中的日期格式是“年月日”的格式,应用B中的日期格式是时间戳或者其他时间格式,在这种情况下,我们可以在应用A步骤与应用B步骤之间添加一个日期时间格式变更步骤,将时间格式转换后再进行同步。</p>", "popular": 55, "published_at": "2021-10-25T03:26:32.000Z", "created_at": "2021-10-25T03:26:30.000Z", "updated_at": "2023-02-20T11:20:39.000Z", "app_id": "89", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "变更日期时间格式", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3479, "name": "datetime.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "datetime_bed27e05e9", "ext": ".svg", "mime": "image/svg+xml", "size": 1.4, "url": "/uploads/datetime_bed27e05e9.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:50:28.000Z", "updated_at": "2022-04-21T08:50:28.000Z" } }, { "id": 71, "name": "文本处理", "description": "<p>文本处理是集简云内置应用,用于对文字内容的格式进行调整,以便在后续的流程中更好的使用。</p>", "popular": -13, "published_at": "2021-10-25T03:47:29.000Z", "created_at": "2021-10-25T03:47:27.000Z", "updated_at": "2022-04-21T08:49:18.000Z", "app_id": "108", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "转换文本内容", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3476, "name": "wenbenzhuanhuan.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "wenbenzhuanhuan_0a62076317", "ext": ".svg", "mime": "image/svg+xml", "size": 2.96, "url": "/uploads/wenbenzhuanhuan_0a62076317.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:49:15.000Z", "updated_at": "2022-04-21T08:49:15.000Z" } }, { "id": 106, "name": "字段查询", "description": "<p>字段查询是集简云的一个内置应用,可做为执行应用使用。其主要功能是设置一个字段列表进行字段匹配关系查询。</p>", "popular": -20, "published_at": "2021-10-25T06:04:16.000Z", "created_at": "2021-10-25T06:04:14.000Z", "updated_at": "2022-08-10T03:32:26.000Z", "app_id": "148", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "查询预设的字段关系", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3482, "name": "ziduanchaxun.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "ziduanchaxun_1c0c5dd6d7", "ext": ".svg", "mime": "image/svg+xml", "size": 0.74, "url": "/uploads/ziduanchaxun_1c0c5dd6d7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:55:13.000Z", "updated_at": "2022-04-21T08:55:13.000Z" } }, { "id": 753, "name": "Oracle", "description": "<p>Oracle系统,即是以Oracle关系数据库为数据存储和管理作为构架基础,构建出的数据库管理系统。 Oracle,世界第一个支持SQL语言的商业数据库,定位于高端工作站,以及作为服务器的小型计算机,如IBM P系列服务器、HP的Integraty服务器、Sun Fire服务器。</p>", "popular": 138, "published_at": "2022-09-29T11:12:39.000Z", "created_at": "2022-09-29T03:27:09.000Z", "updated_at": "2022-09-29T11:12:39.000Z", "app_id": "365", "category": "Developer", "locale": "zh-Hans", "short_description": "关系数据库管理系统", "available": true, "appid": null, "website": " https://www.oracle.com", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 6485, "name": "oracle.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "oracle_679b21561d", "ext": ".svg", "mime": "image/svg+xml", "size": 0.56, "url": "/uploads/oracle_679b21561d.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-09-29T06:14:44.000Z", "updated_at": "2022-09-29T06:14:44.000Z" } }, { "id": 524, "name": "维格表", "description": "<p>维格表将过去复杂的IT数据库技术,做得像表格一样简单 ,可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一,1个维格表,满足团队协作、项目管理、数据协作等1000+场景,让所有工作连接和整合。</p>", "popular": 1, "published_at": "2022-07-25T08:32:52.000Z", "created_at": "2022-07-25T08:32:52.000Z", "updated_at": "2023-01-28T09:02:30.000Z", "app_id": "310", "category": "Teamwork", "locale": "zh-Hans", "short_description": "低代码应用表单系统", "available": true, "appid": null, "website": "https://vika.cn/", "video": null, "videos": null, "app_version": "1.0.1", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 5408, "name": "weigebiao_9542978808.svg", "alternativeText": "", "caption": "", "width": null, "height": null, "formats": null, "hash": "weigebiao_9542978808_c8cf818960", "ext": ".svg", "mime": "image/svg+xml", "size": 7.89, "url": "/uploads/weigebiao_9542978808_c8cf818960.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-07-25T08:39:11.000Z", "updated_at": "2022-07-25T08:39:11.000Z" } } ]
[ { "id": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 }, { "id": 4, "name": "客户管理", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:35.000Z", "created_at": "2022-05-20T08:12:43.000Z", "updated_at": "2022-05-30T07:29:35.000Z", "sort": 2 } ]
[ { "id": 4968, "key": null, "published_at": "2023-01-31T11:01:20.000Z", "created_at": "2023-01-31T11:01:20.000Z", "updated_at": "2023-01-31T11:01:20.000Z", "action_id": "1003836", "action_name": "将数组转换为文本", "error": null, "description": "将数组中的元素按照指定的符号连接成一个字符串", "action_type": "action", "app": null, "template": null }, { "id": 22, "key": null, "published_at": "2021-11-24T06:19:25.000Z", "created_at": "2021-11-24T06:19:22.000Z", "updated_at": "2021-11-24T06:19:25.000Z", "action_id": "15", "action_name": "设置筛选条件", "error": null, "description": "设置筛选条件,只有筛选条件满足后才会继续后续流程步骤", "action_type": "action", "app": null, "template": null }, { "id": 54, "key": null, "published_at": "2021-11-24T06:44:05.000Z", "created_at": "2021-11-24T06:44:03.000Z", "updated_at": "2021-11-24T06:44:05.000Z", "action_id": "241", "action_name": "日期时间格式调整", "error": null, "description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "action_type": "action", "app": null, "template": null }, { "id": 2753, "key": null, "published_at": "2022-07-27T08:43:55.000Z", "created_at": "2022-07-27T08:43:55.000Z", "updated_at": "2022-07-27T08:43:55.000Z", "action_id": "2514", "action_name": "汉字转换成拼音", "error": null, "description": "根据汉字转换成拼音", "action_type": "action", "app": null, "template": null }, { "id": 2933, "key": null, "published_at": "2022-08-11T04:09:25.000Z", "created_at": "2022-08-11T04:09:25.000Z", "updated_at": "2022-08-11T04:09:25.000Z", "action_id": "2635", "action_name": "当符合条件的审批流实例结束时", "error": null, "description": "当符合条件的审批流实例结束时", "action_type": "trigger", "app": null, "template": null }, { "id": 3310, "key": null, "published_at": "2022-09-15T11:16:56.000Z", "created_at": "2022-09-15T11:16:56.000Z", "updated_at": "2022-09-15T11:16:56.000Z", "action_id": "2850", "action_name": "查询审批实例详情1.0.1", "error": null, "description": "查询审批实例详情(新抹平)", "action_type": "action", "app": null, "template": null }, { "id": 3508, "key": null, "published_at": "2022-09-29T11:15:46.000Z", "created_at": "2022-09-29T11:15:46.000Z", "updated_at": "2022-09-29T11:15:46.000Z", "action_id": "2888", "action_name": "新增数据到指定数据表", "error": null, "description": "添加数据到指定Oracle数据表中", "action_type": "action", "app": null, "template": null }, { "id": 4048, "key": null, "published_at": "2022-11-11T09:57:57.000Z", "created_at": "2022-11-11T09:57:57.000Z", "updated_at": "2022-11-11T09:57:57.000Z", "action_id": "3070", "action_name": "批量设置匹配关系", "error": null, "description": "批量根据字段内容进行设置匹配关系", "action_type": "action", "app": null, "template": null }, { "id": 304, "key": null, "published_at": "2021-11-29T09:05:26.000Z", "created_at": "2021-11-29T09:05:24.000Z", "updated_at": "2021-11-29T09:05:26.000Z", "action_id": "402", "action_name": " 发送文本消息", "error": null, "description": "通过输入指定成员ID发送文本", "action_type": "action", "app": null, "template": null }, { "id": 239, "key": null, "published_at": "2021-11-26T05:46:39.000Z", "created_at": "2021-11-26T05:46:36.000Z", "updated_at": "2021-11-26T05:46:39.000Z", "action_id": "541", "action_name": "公式搜索数据", "error": null, "description": "公式搜索维格表数据", "action_type": "action", "app": null, "template": null } ]
[]
[]
100+
100+
99
100+
71
Data
2230
钉钉审批后,同步数据到Oracle(有些系统没有API接口,可以对接数据库)
<p>当钉钉有符合条件的审批流实例结束时,使用钉钉动作查询审批实例详情,数据筛选设置筛选条件,使用维格表公式搜索数据,并用数组处理将数组转换为文本,钉钉(自建应用) 发送文本消息(发送给自己,为了确认数据是否正确),日期时间格式变更日期时间格式调整,文本处理汉字转换成拼音,文本处理汉字转换成拼音,字段查询批量设置匹配关系,通过前面4个步骤将数据转换未Oracle指定的数据类型,最终将数据写入到Oracle指定数据表</p>
zh-Hans
2023-02-01T02:09:15.000Z
2023-02-01T02:09:15.000Z
2023-04-06T06:02:52.000Z
ay4830az
当钉钉有符合条件的审批流实例结束时,使用钉钉动作查询审批实例详情,数据筛选设置筛选条件,使用维格表公式搜索数据,并用数组处理将数组转换为文本,钉钉(自建应用) 发送文本消息(发送给自己,为了确认数据是否正确),日期时间格式变更日期时间格式调整,文本处理汉字转换成拼音,文本处理汉字转换成拼音,字段查询批量设置匹配关系,通过前面4个步骤将数据转换未Oracle指定的数据类型,最终将数据写入到Oracle指定数据表
anyone
9YJVEH82iyqD
official
pc1265
passed
谢晓鸣
ay4830az
谢晓鸣
[ { "desc": "当符合条件的审批流程实例结束时(支持通过审批模板code和操作类型筛选)", "app_id": 69, "action_id": 2635, "action_type": "1", "sort": "1", "note": null }, { "desc": "使用钉钉自建应用询审批实例详情(新抹平)", "app_id": 69, "action_id": 2850, "action_type": "2", "sort": "2", "note": null }, { "desc": "设置筛选条件,只有筛选条件满足后才会继续后续流程步骤", "app_id": 7, "action_id": 15, "action_type": "2", "sort": "3", "note": null }, { "desc": "根据条件公式(包含并且,或等公式)进行数据查询", "app_id": 310, "action_id": 541, "action_type": "2", "sort": "4", "note": null }, { "desc": "将数组中的元素按照指定的符号连接成一个字符串", "app_id": 1000454, "action_id": 1003836, "action_type": "2", "sort": "5", "note": null }, { "desc": "使用钉钉自建应用指定员工或部门发送文本消息", "app_id": 69, "action_id": 402, "action_type": "2", "sort": "6", "note": null }, { "desc": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "app_id": 89, "action_id": 241, "action_type": "2", "sort": "7", "note": null }, { "desc": "根据汉字转换成拼音", "app_id": 108, "action_id": 2514, "action_type": "2", "sort": "8", "note": null }, { "desc": "根据汉字转换成拼音", "app_id": 108, "action_id": 2514, "action_type": "2", "sort": "9", "note": null }, { "desc": "批量根据字段内容进行设置匹配关系", "app_id": 148, "action_id": 3070, "action_type": "2", "sort": "10", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "11", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "12", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "13", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "14", "note": null } ]
1
false
4
{ "1": [ { "key": "process_code", "label": "模板code", "type": "string", "help_txt": "请在旧版钉钉网页端企业管理后台内编辑审批流程,当前页面的URL中process_code后即可获取, 不填将返回所有模板的审批事件" }, { "key": "result", "label": "状态", "type": "string", "dropdown": true, "choices": [ { "key": "agree", "label": "同意" }, { "key": "refuse", "label": "拒绝" } ], "help_txt": "不填将返回所有审批结果的审批事件" } ], "2": [ { "key": "process_instance_id", "label": "审批实例ID", "type": "string", "required": true, "help_txt": "可以从触发动作中或者执行动作获取审批实例ID列表中获取" }, { "key": "is_file", "label": "是否获取审批中的附件", "type": "string", "dropdown": true, "choices": [ { "key": "true", "label": "是" }, { "key": "false", "label": "否" } ], "help_txt": "获取审批实例中的附件,并提供附件的下载链接。附件在平台最多保存30天,评论中上传的附件暂时不支持获取下载链接", "defaulttext": "true" } ], "3": [], "4": [ { "key": "sheet_id", "label": "选择维格表", "dropdownTree": true, "required": true, "dynamic": true, "queryParams": [ { "label": "父节点id", "key": "node_id", "is_key": true }, { "label": "标识", "key": "flag", "defaulttext": "root_node" } ], "url": "/v1/api/application/newViKaTable/dropdownTree/nodesList", "choices": [] } ], "5": [], "6": [ { "label": "接收员工", "key": "userid_list", "help_txt": "接收消息员工的userid;可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取", "type": "string", "multiples": true }, { "key": "dept_id_list", "label": "接收部门", "dropdownTree": true, "multiplesTree": true, "queryParams": [ { "label": "父节点id", "key": "node_id", "is_key": true, "defaulttext": 1 }, { "label": "标识", "key": "flag", "defaulttext": 1 } ], "url": "/v1/api/process/dingding/dropdowntree/get_dept", "choices": [], "help_txt": "请选择接收部门,消息接收者和接收部门不能同时为空" }, { "label": "发送内容", "required": true, "help_txt": "请输入发送内容", "key": "content", "type": "string" } ], "7": [ { "label": "请输入要调整的日期时间", "key": "from_time", "required": true, "multiples": true, "help_txt": "填写一个日期时间或者选择上面步骤中的动态日期时间字段" }, { "label": "请输入当前日期时间格式", "key": "from_time_type", "required": true, "dropdown": true, "dynamic": true, "help_txt": "请选择上面输入的日期时间格式以便正确的进行格式转换", "choices": [ { "value": "auto_format", "label": "自动识别格式" }, { "value": "%Y年%m月%d日 %H:%M:%S", "label": "YYYY年MM月DD日 HH:mm:ss(2006年01月22日 13:29:54)" }, { "value": "%Y年%m月%d日", "label": "YYYY年MM月DD日(2006年01月22日)" }, { "value": "%B %d %Y %H:%M:%S", "label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)" }, { "value": "%Y-%m-%dT%H:%M:%S.%fZ", "label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)" }, { "value": "%Y-%m-%dT%H:%M:%SZ", "label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)" }, { "value": "%B %d %Y", "label": "MMMM DD YYYY (January 22 2006)" }, { "value": "%b %d %Y", "label": "MMM DD YYYY (Jan 22 2006)" }, { "value": "%m-%d-%Y", "label": "MM-DD-YYYY (01-22-2006)" }, { "value": "%m/%d/%Y", "label": "MM/DD/YYYY (01/22/2006)" }, { "value": "%m/%d/%y", "label": "MM/DD/YY (01/22/06)" }, { "value": "%d-%m-%Y", "label": "DD-MM-YYYY (22-01-2006)" }, { "value": "%d/%m/%Y", "label": "DD/MM/YYYY (22/01/2006)" }, { "value": "%d/%m/%y", "label": "DD/MM/YY (22/01/06)" }, { "value": "%Y%m%d", "label": "YYYYMMDD (20060106)" }, { "value": "timestamp", "label": "时间戳秒 (1597247662)" }, { "value": "timestamp_ms", "label": "时间戳毫秒(1597247662000)" }, { "value": "custom", "label": "自定义格式" } ], "defaulttext": "auto_format" }, { "label": "请输入要转换到的日期时间格式", "key": "to_time_type", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "value": "%Y年%m月%d日 %H:%M:%S", "label": "YYYY年MM月DD日 HH:mm:ss(2006年01月22日 13:29:54)" }, { "value": "%Y年%m月%d日", "label": "YYYY年MM月DD日(2006年01月22日)" }, { "value": "%B %d %Y %H:%M:%S", "label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)" }, { "value": "%Y-%m-%dT%H:%M:%S.%fZ", "label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)" }, { "value": "%Y-%m-%dT%H:%M:%SZ", "label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)" }, { "value": "%B %d %Y", "label": "MMMM DD YYYY (January 22 2006)" }, { "value": "%b %d %Y", "label": "MMM DD YYYY (Jan 22 2006)" }, { "value": "%m-%d-%Y", "label": "MM-DD-YYYY (01-22-2006)" }, { "value": "%m/%d/%Y", "label": "MM/DD/YYYY (01/22/2006)" }, { "value": "%m/%d/%y", "label": "MM/DD/YY (01/22/06)" }, { "value": "%d-%m-%Y", "label": "DD-MM-YYYY (22-01-2006)" }, { "value": "%d/%m/%Y", "label": "DD/MM/YYYY (22/01/2006)" }, { "value": "%d/%m/%y", "label": "DD/MM/YY (22/01/06)" }, { "value": "%Y%m%d", "label": "YYYYMMDD (20060106)" }, { "value": "timestamp", "label": "时间戳秒 (1597247662)" }, { "value": "timestamp_ms", "label": "时间戳毫秒(1597247662000)" }, { "value": "custom", "label": "自定义格式" } ] }, { "label": "调整时间", "key": "timedelta", "help_txt": "您可以在日期格式转换后进行时间增加或者减少,请输入一个整数例如1,2,-1,-2" }, { "label": "调整的时间单位", "key": "timedelta_type", "dropdown": true, "choices": [ { "value": "minutes", "label": "分钟" }, { "value": "hours", "label": "小时" }, { "value": "days", "label": "天" } ] } ], "8": [ { "key": "text", "label": "汉字内容", "type": "string", "required": true }, { "key": "trans_type", "label": "转换方式", "type": "string", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "key": "cap", "label": "首字母" }, { "key": "all_cap", "label": "全拼" } ] } ], "9": [ { "key": "text", "label": "汉字内容", "type": "string", "required": true }, { "key": "trans_type", "label": "转换方式", "type": "string", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "key": "cap", "label": "首字母" }, { "key": "all_cap", "label": "全拼" } ] } ], "10": [ { "label": "输入要查询的字段值", "help_txt": "在这里输入要查询的字段", "required": true, "multiples": true, "key": "oldfield", "type": "text" }, { "label": "请输入字段查询表", "key": "table", "help_txt": "请在左边一列输入原字段值,右边一列输入此字段值对应的新字段值", "type": "dict", "required": true }, { "label": "无查询结果时返回值", "key": "default", "help_txt": "如果没有查询到结果返回一个默认参数", "required": true, "type": "string" } ], "11": [], "12": [], "13": [], "14": [] }
[]
[ { "id": 944, "title": "集简云 x 中傲集团 丨零代码连接钉钉和Oracle,让企业业绩实现翻倍增长", "preview": "企业在数字化转型过程中采购了钉钉OA办公协同系统、Oracle数据库,每天有大量客户数据需要录入到2个系统进行维护,人工手动同步数据常耗费大量时间,且无法确保信息的准确性。现在通过集简云搭建一个自动化流程,即可实现钉钉审批后的单据信息会自动同步到Oracle数据库中存储,省去人工在两个系统中来回同步数据的麻烦,大大提高企业员工工作效率,实现业绩翻倍增长。", "content": "<h1><span style=\"color:hsl(240,75%,60%);\"><strong>客户 · 介绍</strong></span></h1><p> </p><p>中傲集团成立于2007年11月,立足互联网+非药品产业,构建专业服务、产业互联、非药品大数据、极速物流、非药品新零售为一体的非药品综合服务商。是目前国内具竞争力的非药品创新型企业。中傲以强大的管理能力,在非药品流通信息化、全国一体化、高效率以及性价比等方面的建设达到了全国领先水平。中傲已不再是单纯的商品销售的贸易公司,而是依靠创新驱动的平台型公司。 </p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>目前覆盖14个省份,近4万余家药店,每年近40%以上速度增长;有3个近万平的高标仓分仓布局,企业人员包括销售人员近300人,内勤人员100余人,现有500余家供应商,下游客户3000余个。</strong></span></p><p> </p><figure class=\"image\"><img src=\"/uploads/99_3f91b399e0.png\"></figure><p> </p><p> </p><h1><span style=\"color:hsl(240,75%,60%);\"><strong>客户 · 遇到的问题</strong></span></h1><p> </p><p>随着互联网的发展,企业数字化转型已经成为必然趋势。中傲集团也不例外,企业采购钉钉OA系统办公协同、Oracle数据库做客户管理,每天有大量客户数据需要录入到2个系统进行维护,通过数据化模式来提升其在市场中的竞争力和盈利能力。</p><p> </p><p>日常,销售人员签单后,需要手动同步到钉钉上提交审批,审批通过后,再查询公司在各个省、市、县等地方的相关资源配置信息,然后录入到Oracle数据库中存储,具体的工作流程如下:</p><p> </p><figure class=\"image\"><img src=\"/uploads/00_e118bc7a1f.png\"></figure><p> </p><p>随着企业规模的不断壮大,业务量上涨,让当前这个看似比较简单的业务流程开始频频暴露问题:</p><p> </p><p><strong>● 1条客户信息,需要在钉钉、Oracle2个系统反复录入2次以上;</strong><br><strong>● 大量复制粘贴工作,经常导致数据出错,影响订单发货;</strong><br><strong>● 数据发生偏差还需重新核对,增加不必要的工作量;</strong><br><strong>● 人工手动录入效率较低,易消耗员工工作热情;</strong><br><strong>● 单据信息有变动,一套工作流程需重新来过;</strong></p><p> </p><p>如果公司想通过自行研发特定技术接口,短期内快速实现对接,需要整个研发部门all in,投入大量时间及精力,后续还需安排专门人员进行维护,对于企业来说,成本过高;如果通过外包厂商来实现,想法产生到落地执行再到真正使用,一个环节扣着一个环节,常常需要对接多名人员,沟通成本高;</p><p> </p><p>无论哪一种方式,对于企业来说,都无法快速满足业务需求,且成本过高,也并不是一笔划算的买卖。<strong>那么,到底该如何高效、低成本地解决这个问题呢?</strong></p><p> </p><p> </p><h1><span style=\"color:hsl(240,75%,60%);\"><strong>钉钉 & 集简云解决方案</strong></span></h1><p> </p><p>集简云是一款超级软件连接器,通过集简云无需任何开发就可以将钉钉OA与Oracle系统之间的数据进行打通,让应用与应用之间的数据实现自动同步,我们只需要在集简云搭建一个数据流程即可让整个工作流程实现自动化运转。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ “钉钉自建无需API开发连接Oracle”自动化方案如下:</strong></span></p><p><br>步骤1:触发动作【钉钉自建-当符合条件的审批流实例结束时】<br>步骤2:执行动作【钉钉自建-查询审批实例详情】<br>步骤3:执行动作【数据筛选-设置筛选条件】<br>步骤4:执行动作【维格表-公式搜索数据】<br>步骤5:执行动作【数组处理-将数组转换为文本】<br>步骤6:执行动作【钉钉自建-发送文本消息】<br>步骤7:执行动作【日期时间格式变更-调整日期时间格式】<br>步骤8:执行动作【文本处理-将汉字转换成拼音】<br>步骤9:执行动作【文本处理-将汉字转换成拼音】<br>步骤10:执行动作【字段查询-批量设置匹配关系】<br>步骤11:执行动作【Oracle-新增数据到指定数据表】<br>步骤12:执行动作【Oracle-新增数据到指定数据表】<br>步骤13:执行动作【Oracle-新增数据到指定数据表】<br>步骤14:执行动作【Oracle-新增数据到指定数据表】</p><p> </p><figure class=\"image\"><img src=\"/uploads/77_e28a36fd4d.gif\"></figure><p style=\"text-align:center;\"><a href=\"https://www.jijyun.cn/apps/processes/2230\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color:hsl(210,75%,60%);\">点击此模板,立即使用</span></a></p><p style=\"text-align:center;\"> </p><p>实现效果:通过集简云搭建的自动化流程,让中傲集团实现了钉钉OA与Oracle系统之间的数据互联,审批单据信息可以在两个系统间来回流转,自动同步及更新,企业人员无需再二次同步信息,大大提高效率。</p><p> </p><p><strong>原本需要研发技术人员数十个工作日才能完成的流程对接工作,在集简云零代码集成功能的帮助下,不到1个工作日就完成了搭建,调试与上线使用。</strong></p><p> </p><p> </p><h1><strong>客户 · 反馈</strong></h1><p> </p><p>中傲集团核心业务负责人称,自动使用了集简云这款超级软件连接器,给我们最直观的感受就是,无需人工操作,钉钉OA上的一条单据录入到Oracle数据库仅需几秒钟即可完成同步。整体实现的效果如下:</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【钉钉和Oracle数据自动同步】</strong></span><br>审批通过后,数据可自动同步至Oracle数据库存储,减少不必要的流程,大大提升协作效率。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【无代码实现自动化流程】</strong></span><br>无需繁琐的工作步骤,只需一个流程,即可轻松实现两个系统自动连接。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【高效提升资源整合效率】</strong></span><br> 借助两个系统数据自动互通,公司可以充分整合在销售人员整理数据,单据审批等板块的资源。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【助力企业降本增效】</strong></span><br>无需高昂的研发费用,即可方便、快速地实现钉钉OA系统与Oracle系统之间的数据互通。</p><p> </p><p>总而言之,集简云着实是一款降本增效的工具,可以帮助企业增强创新能力,加快发展步伐,创造更多的经营效益,真正实现\"高效益\"经营目标。也正如集简云所说,业务流程自动化与智能化是企业新的增长引擎!</p><p> </p>", "sort": null, "usage": "help_doc", "published_at": "2023-02-06T07:15:42.000Z", "created_at": "2023-02-06T07:05:26.000Z", "updated_at": "2023-03-09T10:03:47.000Z", "help_collection": 6, "video_url": null, "field": null, "weight": 0, "select": false, "seo": null, "thumb": { "id": 9030, "name": "画板 – 2.png", "alternativeText": "", "caption": "", "width": 200, "height": 120, "formats": null, "hash": "2_1697e10b22", "ext": ".png", "mime": "image/png", "size": 30.1, "url": "/uploads/2_1697e10b22.png", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2023-02-06T07:10:30.000Z", "updated_at": "2023-02-06T07:10:30.000Z" }, "media": { "id": 9029, "name": "自定义大小 – 38.png", "alternativeText": "", "caption": "", "width": 1027, "height": 440, "formats": { "thumbnail": { "name": "thumbnail_自定义大小 – 38.png", "hash": "thumbnail_38_1005715449", "ext": ".png", "mime": "image/png", "width": 245, "height": 105, "size": 35.72, "path": null, "url": "/uploads/thumbnail_38_1005715449.png" }, "large": { "name": "large_自定义大小 – 38.png", "hash": "large_38_1005715449", "ext": ".png", "mime": "image/png", "width": 1000, "height": 428, "size": 465.42, "path": null, "url": "/uploads/large_38_1005715449.png" }, "medium": { "name": "medium_自定义大小 – 38.png", "hash": "medium_38_1005715449", "ext": ".png", "mime": "image/png", "width": 750, "height": 321, "size": 273.5, "path": null, "url": "/uploads/medium_38_1005715449.png" }, "small": { "name": "small_自定义大小 – 38.png", "hash": "small_38_1005715449", "ext": ".png", "mime": "image/png", "width": 500, "height": 214, "size": 129.08, "path": null, "url": "/uploads/small_38_1005715449.png" } }, "hash": "38_1005715449", "ext": ".png", "mime": "image/png", "size": 333.79, "url": "/uploads/38_1005715449.png", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2023-02-06T07:10:10.000Z", "updated_at": "2023-02-06T07:10:11.000Z" } } ]
[ { "id": 25, "name": "钉钉(自建应用)", "description": "<p>钉钉,阿里巴巴出品,专为全球企业组织打造的智能移动办公平台,含PC版,Ipad和手机版。远程视频会议,消息已读未读,DING消息任务管理,让沟通更高效;移动办公考勤,签到,审批,企业邮箱,免费企业OA,企业通讯录,钉钉教育解决方案,让工作学习更简单!</p>", "popular": 216, "published_at": "2021-10-25T03:01:37.000Z", "created_at": "2021-10-25T03:01:35.000Z", "updated_at": "2023-01-28T09:03:31.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1811, "name": "Dingding.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Dingding_ac75c3cf81", "ext": ".svg", "mime": "image/svg+xml", "size": 9.4, "url": "/uploads/Dingding_ac75c3cf81.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:46:50.000Z", "updated_at": "2022-01-26T02:46:50.000Z" } }, { "id": 9, "name": "数据筛选", "description": "<p>数据筛选是集简云的一个内置应用,用于判断数据流程中数据是否符合筛选条件,如果符合筛选条件则继续后续的流程步骤,如果不符合则不会执行后续的流程步骤。</p>", "popular": -12, "published_at": "2021-10-25T02:45:30.000Z", "created_at": "2021-10-25T02:45:27.000Z", "updated_at": "2022-04-21T08:47:17.000Z", "app_id": "7", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "设置筛选条件", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3475, "name": "windeal-filter.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "windeal_filter_0ad26bc0ae", "ext": ".svg", "mime": "image/svg+xml", "size": 0.86, "url": "/uploads/windeal_filter_0ad26bc0ae.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:47:14.000Z", "updated_at": "2022-04-21T08:47:14.000Z" } }, { "id": 631, "name": "数组处理", "description": "<p>数组处理是集简云的一款内置应用,用于将文本变量内容生成一组数组或者将一组数组转换成文本内容,以便用于后续的流程步骤中。</p>", "popular": -1, "published_at": "2022-08-25T05:54:52.000Z", "created_at": "2022-08-25T05:39:49.000Z", "updated_at": "2022-08-25T06:16:51.000Z", "app_id": "1000454", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "集简云内置应用", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 5862, "name": "shuzuchuli.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "shuzuchuli_114ea035f2", "ext": ".svg", "mime": "image/svg+xml", "size": 2.71, "url": "/uploads/shuzuchuli_114ea035f2.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-08-25T05:54:16.000Z", "updated_at": "2022-08-25T05:54:16.000Z" } }, { "id": 52, "name": "日期时间格式变更", "description": "<p>日期时间格式变更帮助解决不同应用步骤中对日期时间格式的不同要求。比如应用A中的日期格式是“年月日”的格式,应用B中的日期格式是时间戳或者其他时间格式,在这种情况下,我们可以在应用A步骤与应用B步骤之间添加一个日期时间格式变更步骤,将时间格式转换后再进行同步。</p>", "popular": 55, "published_at": "2021-10-25T03:26:32.000Z", "created_at": "2021-10-25T03:26:30.000Z", "updated_at": "2023-02-20T11:20:39.000Z", "app_id": "89", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "变更日期时间格式", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3479, "name": "datetime.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "datetime_bed27e05e9", "ext": ".svg", "mime": "image/svg+xml", "size": 1.4, "url": "/uploads/datetime_bed27e05e9.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:50:28.000Z", "updated_at": "2022-04-21T08:50:28.000Z" } }, { "id": 71, "name": "文本处理", "description": "<p>文本处理是集简云内置应用,用于对文字内容的格式进行调整,以便在后续的流程中更好的使用。</p>", "popular": -13, "published_at": "2021-10-25T03:47:29.000Z", "created_at": "2021-10-25T03:47:27.000Z", "updated_at": "2022-04-21T08:49:18.000Z", "app_id": "108", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "转换文本内容", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3476, "name": "wenbenzhuanhuan.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "wenbenzhuanhuan_0a62076317", "ext": ".svg", "mime": "image/svg+xml", "size": 2.96, "url": "/uploads/wenbenzhuanhuan_0a62076317.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:49:15.000Z", "updated_at": "2022-04-21T08:49:15.000Z" } }, { "id": 106, "name": "字段查询", "description": "<p>字段查询是集简云的一个内置应用,可做为执行应用使用。其主要功能是设置一个字段列表进行字段匹配关系查询。</p>", "popular": -20, "published_at": "2021-10-25T06:04:16.000Z", "created_at": "2021-10-25T06:04:14.000Z", "updated_at": "2022-08-10T03:32:26.000Z", "app_id": "148", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "查询预设的字段关系", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3482, "name": "ziduanchaxun.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "ziduanchaxun_1c0c5dd6d7", "ext": ".svg", "mime": "image/svg+xml", "size": 0.74, "url": "/uploads/ziduanchaxun_1c0c5dd6d7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:55:13.000Z", "updated_at": "2022-04-21T08:55:13.000Z" } }, { "id": 753, "name": "Oracle", "description": "<p>Oracle系统,即是以Oracle关系数据库为数据存储和管理作为构架基础,构建出的数据库管理系统。 Oracle,世界第一个支持SQL语言的商业数据库,定位于高端工作站,以及作为服务器的小型计算机,如IBM P系列服务器、HP的Integraty服务器、Sun Fire服务器。</p>", "popular": 138, "published_at": "2022-09-29T11:12:39.000Z", "created_at": "2022-09-29T03:27:09.000Z", "updated_at": "2022-09-29T11:12:39.000Z", "app_id": "365", "category": "Developer", "locale": "zh-Hans", "short_description": "关系数据库管理系统", "available": true, "appid": null, "website": " https://www.oracle.com", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 6485, "name": "oracle.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "oracle_679b21561d", "ext": ".svg", "mime": "image/svg+xml", "size": 0.56, "url": "/uploads/oracle_679b21561d.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-09-29T06:14:44.000Z", "updated_at": "2022-09-29T06:14:44.000Z" } }, { "id": 524, "name": "维格表", "description": "<p>维格表将过去复杂的IT数据库技术,做得像表格一样简单 ,可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一,1个维格表,满足团队协作、项目管理、数据协作等1000+场景,让所有工作连接和整合。</p>", "popular": 1, "published_at": "2022-07-25T08:32:52.000Z", "created_at": "2022-07-25T08:32:52.000Z", "updated_at": "2023-01-28T09:02:30.000Z", "app_id": "310", "category": "Teamwork", "locale": "zh-Hans", "short_description": "低代码应用表单系统", "available": true, "appid": null, "website": "https://vika.cn/", "video": null, "videos": null, "app_version": "1.0.1", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 5408, "name": "weigebiao_9542978808.svg", "alternativeText": "", "caption": "", "width": null, "height": null, "formats": null, "hash": "weigebiao_9542978808_c8cf818960", "ext": ".svg", "mime": "image/svg+xml", "size": 7.89, "url": "/uploads/weigebiao_9542978808_c8cf818960.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-07-25T08:39:11.000Z", "updated_at": "2022-07-25T08:39:11.000Z" } } ]
[ { "id": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 }, { "id": 4, "name": "客户管理", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:35.000Z", "created_at": "2022-05-20T08:12:43.000Z", "updated_at": "2022-05-30T07:29:35.000Z", "sort": 2 } ]
[ { "id": 4968, "key": null, "published_at": "2023-01-31T11:01:20.000Z", "created_at": "2023-01-31T11:01:20.000Z", "updated_at": "2023-01-31T11:01:20.000Z", "action_id": "1003836", "action_name": "将数组转换为文本", "error": null, "description": "将数组中的元素按照指定的符号连接成一个字符串", "action_type": "action", "app": null, "template": null }, { "id": 22, "key": null, "published_at": "2021-11-24T06:19:25.000Z", "created_at": "2021-11-24T06:19:22.000Z", "updated_at": "2021-11-24T06:19:25.000Z", "action_id": "15", "action_name": "设置筛选条件", "error": null, "description": "设置筛选条件,只有筛选条件满足后才会继续后续流程步骤", "action_type": "action", "app": null, "template": null }, { "id": 54, "key": null, "published_at": "2021-11-24T06:44:05.000Z", "created_at": "2021-11-24T06:44:03.000Z", "updated_at": "2021-11-24T06:44:05.000Z", "action_id": "241", "action_name": "日期时间格式调整", "error": null, "description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "action_type": "action", "app": null, "template": null }, { "id": 2753, "key": null, "published_at": "2022-07-27T08:43:55.000Z", "created_at": "2022-07-27T08:43:55.000Z", "updated_at": "2022-07-27T08:43:55.000Z", "action_id": "2514", "action_name": "汉字转换成拼音", "error": null, "description": "根据汉字转换成拼音", "action_type": "action", "app": null, "template": null }, { "id": 2933, "key": null, "published_at": "2022-08-11T04:09:25.000Z", "created_at": "2022-08-11T04:09:25.000Z", "updated_at": "2022-08-11T04:09:25.000Z", "action_id": "2635", "action_name": "当符合条件的审批流实例结束时", "error": null, "description": "当符合条件的审批流实例结束时", "action_type": "trigger", "app": null, "template": null }, { "id": 3310, "key": null, "published_at": "2022-09-15T11:16:56.000Z", "created_at": "2022-09-15T11:16:56.000Z", "updated_at": "2022-09-15T11:16:56.000Z", "action_id": "2850", "action_name": "查询审批实例详情1.0.1", "error": null, "description": "查询审批实例详情(新抹平)", "action_type": "action", "app": null, "template": null }, { "id": 3508, "key": null, "published_at": "2022-09-29T11:15:46.000Z", "created_at": "2022-09-29T11:15:46.000Z", "updated_at": "2022-09-29T11:15:46.000Z", "action_id": "2888", "action_name": "新增数据到指定数据表", "error": null, "description": "添加数据到指定Oracle数据表中", "action_type": "action", "app": null, "template": null }, { "id": 4048, "key": null, "published_at": "2022-11-11T09:57:57.000Z", "created_at": "2022-11-11T09:57:57.000Z", "updated_at": "2022-11-11T09:57:57.000Z", "action_id": "3070", "action_name": "批量设置匹配关系", "error": null, "description": "批量根据字段内容进行设置匹配关系", "action_type": "action", "app": null, "template": null }, { "id": 304, "key": null, "published_at": "2021-11-29T09:05:26.000Z", "created_at": "2021-11-29T09:05:24.000Z", "updated_at": "2021-11-29T09:05:26.000Z", "action_id": "402", "action_name": " 发送文本消息", "error": null, "description": "通过输入指定成员ID发送文本", "action_type": "action", "app": null, "template": null }, { "id": 239, "key": null, "published_at": "2021-11-26T05:46:39.000Z", "created_at": "2021-11-26T05:46:36.000Z", "updated_at": "2021-11-26T05:46:39.000Z", "action_id": "541", "action_name": "公式搜索数据", "error": null, "description": "公式搜索维格表数据", "action_type": "action", "app": null, "template": null } ]
[]
[]
100+
100+
99
100+
71
permission
2230
钉钉审批后,同步数据到Oracle(有些系统没有API接口,可以对接数据库)
<p>当钉钉有符合条件的审批流实例结束时,使用钉钉动作查询审批实例详情,数据筛选设置筛选条件,使用维格表公式搜索数据,并用数组处理将数组转换为文本,钉钉(自建应用) 发送文本消息(发送给自己,为了确认数据是否正确),日期时间格式变更日期时间格式调整,文本处理汉字转换成拼音,文本处理汉字转换成拼音,字段查询批量设置匹配关系,通过前面4个步骤将数据转换未Oracle指定的数据类型,最终将数据写入到Oracle指定数据表</p>
zh-Hans
2023-02-01T02:09:15.000Z
2023-02-01T02:09:15.000Z
2023-04-06T06:02:52.000Z
ay4830az
当钉钉有符合条件的审批流实例结束时,使用钉钉动作查询审批实例详情,数据筛选设置筛选条件,使用维格表公式搜索数据,并用数组处理将数组转换为文本,钉钉(自建应用) 发送文本消息(发送给自己,为了确认数据是否正确),日期时间格式变更日期时间格式调整,文本处理汉字转换成拼音,文本处理汉字转换成拼音,字段查询批量设置匹配关系,通过前面4个步骤将数据转换未Oracle指定的数据类型,最终将数据写入到Oracle指定数据表
anyone
9YJVEH82iyqD
official
pc1265
passed
谢晓鸣
ay4830az
谢晓鸣
[ { "desc": "当符合条件的审批流程实例结束时(支持通过审批模板code和操作类型筛选)", "app_id": 69, "action_id": 2635, "action_type": "1", "sort": "1", "note": null }, { "desc": "使用钉钉自建应用询审批实例详情(新抹平)", "app_id": 69, "action_id": 2850, "action_type": "2", "sort": "2", "note": null }, { "desc": "设置筛选条件,只有筛选条件满足后才会继续后续流程步骤", "app_id": 7, "action_id": 15, "action_type": "2", "sort": "3", "note": null }, { "desc": "根据条件公式(包含并且,或等公式)进行数据查询", "app_id": 310, "action_id": 541, "action_type": "2", "sort": "4", "note": null }, { "desc": "将数组中的元素按照指定的符号连接成一个字符串", "app_id": 1000454, "action_id": 1003836, "action_type": "2", "sort": "5", "note": null }, { "desc": "使用钉钉自建应用指定员工或部门发送文本消息", "app_id": 69, "action_id": 402, "action_type": "2", "sort": "6", "note": null }, { "desc": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "app_id": 89, "action_id": 241, "action_type": "2", "sort": "7", "note": null }, { "desc": "根据汉字转换成拼音", "app_id": 108, "action_id": 2514, "action_type": "2", "sort": "8", "note": null }, { "desc": "根据汉字转换成拼音", "app_id": 108, "action_id": 2514, "action_type": "2", "sort": "9", "note": null }, { "desc": "批量根据字段内容进行设置匹配关系", "app_id": 148, "action_id": 3070, "action_type": "2", "sort": "10", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "11", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "12", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "13", "note": null }, { "desc": "添加数据到指定Oracle数据表中", "app_id": 365, "action_id": 2888, "action_type": "2", "sort": "14", "note": null } ]
1
false
4
{ "1": [ { "key": "process_code", "label": "模板code", "type": "string", "help_txt": "请在旧版钉钉网页端企业管理后台内编辑审批流程,当前页面的URL中process_code后即可获取, 不填将返回所有模板的审批事件" }, { "key": "result", "label": "状态", "type": "string", "dropdown": true, "choices": [ { "key": "agree", "label": "同意" }, { "key": "refuse", "label": "拒绝" } ], "help_txt": "不填将返回所有审批结果的审批事件" } ], "2": [ { "key": "process_instance_id", "label": "审批实例ID", "type": "string", "required": true, "help_txt": "可以从触发动作中或者执行动作获取审批实例ID列表中获取" }, { "key": "is_file", "label": "是否获取审批中的附件", "type": "string", "dropdown": true, "choices": [ { "key": "true", "label": "是" }, { "key": "false", "label": "否" } ], "help_txt": "获取审批实例中的附件,并提供附件的下载链接。附件在平台最多保存30天,评论中上传的附件暂时不支持获取下载链接", "defaulttext": "true" } ], "3": [], "4": [ { "key": "sheet_id", "label": "选择维格表", "dropdownTree": true, "required": true, "dynamic": true, "queryParams": [ { "label": "父节点id", "key": "node_id", "is_key": true }, { "label": "标识", "key": "flag", "defaulttext": "root_node" } ], "url": "/v1/api/application/newViKaTable/dropdownTree/nodesList", "choices": [] } ], "5": [], "6": [ { "label": "接收员工", "key": "userid_list", "help_txt": "接收消息员工的userid;可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取", "type": "string", "multiples": true }, { "key": "dept_id_list", "label": "接收部门", "dropdownTree": true, "multiplesTree": true, "queryParams": [ { "label": "父节点id", "key": "node_id", "is_key": true, "defaulttext": 1 }, { "label": "标识", "key": "flag", "defaulttext": 1 } ], "url": "/v1/api/process/dingding/dropdowntree/get_dept", "choices": [], "help_txt": "请选择接收部门,消息接收者和接收部门不能同时为空" }, { "label": "发送内容", "required": true, "help_txt": "请输入发送内容", "key": "content", "type": "string" } ], "7": [ { "label": "请输入要调整的日期时间", "key": "from_time", "required": true, "multiples": true, "help_txt": "填写一个日期时间或者选择上面步骤中的动态日期时间字段" }, { "label": "请输入当前日期时间格式", "key": "from_time_type", "required": true, "dropdown": true, "dynamic": true, "help_txt": "请选择上面输入的日期时间格式以便正确的进行格式转换", "choices": [ { "value": "auto_format", "label": "自动识别格式" }, { "value": "%Y年%m月%d日 %H:%M:%S", "label": "YYYY年MM月DD日 HH:mm:ss(2006年01月22日 13:29:54)" }, { "value": "%Y年%m月%d日", "label": "YYYY年MM月DD日(2006年01月22日)" }, { "value": "%B %d %Y %H:%M:%S", "label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)" }, { "value": "%Y-%m-%dT%H:%M:%S.%fZ", "label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)" }, { "value": "%Y-%m-%dT%H:%M:%SZ", "label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)" }, { "value": "%B %d %Y", "label": "MMMM DD YYYY (January 22 2006)" }, { "value": "%b %d %Y", "label": "MMM DD YYYY (Jan 22 2006)" }, { "value": "%m-%d-%Y", "label": "MM-DD-YYYY (01-22-2006)" }, { "value": "%m/%d/%Y", "label": "MM/DD/YYYY (01/22/2006)" }, { "value": "%m/%d/%y", "label": "MM/DD/YY (01/22/06)" }, { "value": "%d-%m-%Y", "label": "DD-MM-YYYY (22-01-2006)" }, { "value": "%d/%m/%Y", "label": "DD/MM/YYYY (22/01/2006)" }, { "value": "%d/%m/%y", "label": "DD/MM/YY (22/01/06)" }, { "value": "%Y%m%d", "label": "YYYYMMDD (20060106)" }, { "value": "timestamp", "label": "时间戳秒 (1597247662)" }, { "value": "timestamp_ms", "label": "时间戳毫秒(1597247662000)" }, { "value": "custom", "label": "自定义格式" } ], "defaulttext": "auto_format" }, { "label": "请输入要转换到的日期时间格式", "key": "to_time_type", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "value": "%Y年%m月%d日 %H:%M:%S", "label": "YYYY年MM月DD日 HH:mm:ss(2006年01月22日 13:29:54)" }, { "value": "%Y年%m月%d日", "label": "YYYY年MM月DD日(2006年01月22日)" }, { "value": "%B %d %Y %H:%M:%S", "label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)" }, { "value": "%Y-%m-%dT%H:%M:%S.%fZ", "label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)" }, { "value": "%Y-%m-%dT%H:%M:%SZ", "label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)" }, { "value": "%B %d %Y", "label": "MMMM DD YYYY (January 22 2006)" }, { "value": "%b %d %Y", "label": "MMM DD YYYY (Jan 22 2006)" }, { "value": "%m-%d-%Y", "label": "MM-DD-YYYY (01-22-2006)" }, { "value": "%m/%d/%Y", "label": "MM/DD/YYYY (01/22/2006)" }, { "value": "%m/%d/%y", "label": "MM/DD/YY (01/22/06)" }, { "value": "%d-%m-%Y", "label": "DD-MM-YYYY (22-01-2006)" }, { "value": "%d/%m/%Y", "label": "DD/MM/YYYY (22/01/2006)" }, { "value": "%d/%m/%y", "label": "DD/MM/YY (22/01/06)" }, { "value": "%Y%m%d", "label": "YYYYMMDD (20060106)" }, { "value": "timestamp", "label": "时间戳秒 (1597247662)" }, { "value": "timestamp_ms", "label": "时间戳毫秒(1597247662000)" }, { "value": "custom", "label": "自定义格式" } ] }, { "label": "调整时间", "key": "timedelta", "help_txt": "您可以在日期格式转换后进行时间增加或者减少,请输入一个整数例如1,2,-1,-2" }, { "label": "调整的时间单位", "key": "timedelta_type", "dropdown": true, "choices": [ { "value": "minutes", "label": "分钟" }, { "value": "hours", "label": "小时" }, { "value": "days", "label": "天" } ] } ], "8": [ { "key": "text", "label": "汉字内容", "type": "string", "required": true }, { "key": "trans_type", "label": "转换方式", "type": "string", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "key": "cap", "label": "首字母" }, { "key": "all_cap", "label": "全拼" } ] } ], "9": [ { "key": "text", "label": "汉字内容", "type": "string", "required": true }, { "key": "trans_type", "label": "转换方式", "type": "string", "required": true, "dropdown": true, "dynamic": true, "choices": [ { "key": "cap", "label": "首字母" }, { "key": "all_cap", "label": "全拼" } ] } ], "10": [ { "label": "输入要查询的字段值", "help_txt": "在这里输入要查询的字段", "required": true, "multiples": true, "key": "oldfield", "type": "text" }, { "label": "请输入字段查询表", "key": "table", "help_txt": "请在左边一列输入原字段值,右边一列输入此字段值对应的新字段值", "type": "dict", "required": true }, { "label": "无查询结果时返回值", "key": "default", "help_txt": "如果没有查询到结果返回一个默认参数", "required": true, "type": "string" } ], "11": [], "12": [], "13": [], "14": [] }
[]
[ { "id": 944, "title": "集简云 x 中傲集团 丨零代码连接钉钉和Oracle,让企业业绩实现翻倍增长", "preview": "企业在数字化转型过程中采购了钉钉OA办公协同系统、Oracle数据库,每天有大量客户数据需要录入到2个系统进行维护,人工手动同步数据常耗费大量时间,且无法确保信息的准确性。现在通过集简云搭建一个自动化流程,即可实现钉钉审批后的单据信息会自动同步到Oracle数据库中存储,省去人工在两个系统中来回同步数据的麻烦,大大提高企业员工工作效率,实现业绩翻倍增长。", "content": "<h1><span style=\"color:hsl(240,75%,60%);\"><strong>客户 · 介绍</strong></span></h1><p> </p><p>中傲集团成立于2007年11月,立足互联网+非药品产业,构建专业服务、产业互联、非药品大数据、极速物流、非药品新零售为一体的非药品综合服务商。是目前国内具竞争力的非药品创新型企业。中傲以强大的管理能力,在非药品流通信息化、全国一体化、高效率以及性价比等方面的建设达到了全国领先水平。中傲已不再是单纯的商品销售的贸易公司,而是依靠创新驱动的平台型公司。 </p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>目前覆盖14个省份,近4万余家药店,每年近40%以上速度增长;有3个近万平的高标仓分仓布局,企业人员包括销售人员近300人,内勤人员100余人,现有500余家供应商,下游客户3000余个。</strong></span></p><p> </p><figure class=\"image\"><img src=\"/uploads/99_3f91b399e0.png\"></figure><p> </p><p> </p><h1><span style=\"color:hsl(240,75%,60%);\"><strong>客户 · 遇到的问题</strong></span></h1><p> </p><p>随着互联网的发展,企业数字化转型已经成为必然趋势。中傲集团也不例外,企业采购钉钉OA系统办公协同、Oracle数据库做客户管理,每天有大量客户数据需要录入到2个系统进行维护,通过数据化模式来提升其在市场中的竞争力和盈利能力。</p><p> </p><p>日常,销售人员签单后,需要手动同步到钉钉上提交审批,审批通过后,再查询公司在各个省、市、县等地方的相关资源配置信息,然后录入到Oracle数据库中存储,具体的工作流程如下:</p><p> </p><figure class=\"image\"><img src=\"/uploads/00_e118bc7a1f.png\"></figure><p> </p><p>随着企业规模的不断壮大,业务量上涨,让当前这个看似比较简单的业务流程开始频频暴露问题:</p><p> </p><p><strong>● 1条客户信息,需要在钉钉、Oracle2个系统反复录入2次以上;</strong><br><strong>● 大量复制粘贴工作,经常导致数据出错,影响订单发货;</strong><br><strong>● 数据发生偏差还需重新核对,增加不必要的工作量;</strong><br><strong>● 人工手动录入效率较低,易消耗员工工作热情;</strong><br><strong>● 单据信息有变动,一套工作流程需重新来过;</strong></p><p> </p><p>如果公司想通过自行研发特定技术接口,短期内快速实现对接,需要整个研发部门all in,投入大量时间及精力,后续还需安排专门人员进行维护,对于企业来说,成本过高;如果通过外包厂商来实现,想法产生到落地执行再到真正使用,一个环节扣着一个环节,常常需要对接多名人员,沟通成本高;</p><p> </p><p>无论哪一种方式,对于企业来说,都无法快速满足业务需求,且成本过高,也并不是一笔划算的买卖。<strong>那么,到底该如何高效、低成本地解决这个问题呢?</strong></p><p> </p><p> </p><h1><span style=\"color:hsl(240,75%,60%);\"><strong>钉钉 & 集简云解决方案</strong></span></h1><p> </p><p>集简云是一款超级软件连接器,通过集简云无需任何开发就可以将钉钉OA与Oracle系统之间的数据进行打通,让应用与应用之间的数据实现自动同步,我们只需要在集简云搭建一个数据流程即可让整个工作流程实现自动化运转。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ “钉钉自建无需API开发连接Oracle”自动化方案如下:</strong></span></p><p><br>步骤1:触发动作【钉钉自建-当符合条件的审批流实例结束时】<br>步骤2:执行动作【钉钉自建-查询审批实例详情】<br>步骤3:执行动作【数据筛选-设置筛选条件】<br>步骤4:执行动作【维格表-公式搜索数据】<br>步骤5:执行动作【数组处理-将数组转换为文本】<br>步骤6:执行动作【钉钉自建-发送文本消息】<br>步骤7:执行动作【日期时间格式变更-调整日期时间格式】<br>步骤8:执行动作【文本处理-将汉字转换成拼音】<br>步骤9:执行动作【文本处理-将汉字转换成拼音】<br>步骤10:执行动作【字段查询-批量设置匹配关系】<br>步骤11:执行动作【Oracle-新增数据到指定数据表】<br>步骤12:执行动作【Oracle-新增数据到指定数据表】<br>步骤13:执行动作【Oracle-新增数据到指定数据表】<br>步骤14:执行动作【Oracle-新增数据到指定数据表】</p><p> </p><figure class=\"image\"><img src=\"/uploads/77_e28a36fd4d.gif\"></figure><p style=\"text-align:center;\"><a href=\"https://www.jijyun.cn/apps/processes/2230\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color:hsl(210,75%,60%);\">点击此模板,立即使用</span></a></p><p style=\"text-align:center;\"> </p><p>实现效果:通过集简云搭建的自动化流程,让中傲集团实现了钉钉OA与Oracle系统之间的数据互联,审批单据信息可以在两个系统间来回流转,自动同步及更新,企业人员无需再二次同步信息,大大提高效率。</p><p> </p><p><strong>原本需要研发技术人员数十个工作日才能完成的流程对接工作,在集简云零代码集成功能的帮助下,不到1个工作日就完成了搭建,调试与上线使用。</strong></p><p> </p><p> </p><h1><strong>客户 · 反馈</strong></h1><p> </p><p>中傲集团核心业务负责人称,自动使用了集简云这款超级软件连接器,给我们最直观的感受就是,无需人工操作,钉钉OA上的一条单据录入到Oracle数据库仅需几秒钟即可完成同步。整体实现的效果如下:</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【钉钉和Oracle数据自动同步】</strong></span><br>审批通过后,数据可自动同步至Oracle数据库存储,减少不必要的流程,大大提升协作效率。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【无代码实现自动化流程】</strong></span><br>无需繁琐的工作步骤,只需一个流程,即可轻松实现两个系统自动连接。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【高效提升资源整合效率】</strong></span><br> 借助两个系统数据自动互通,公司可以充分整合在销售人员整理数据,单据审批等板块的资源。</p><p> </p><p><span style=\"color:hsl(240,75%,60%);\"><strong>➢ 【助力企业降本增效】</strong></span><br>无需高昂的研发费用,即可方便、快速地实现钉钉OA系统与Oracle系统之间的数据互通。</p><p> </p><p>总而言之,集简云着实是一款降本增效的工具,可以帮助企业增强创新能力,加快发展步伐,创造更多的经营效益,真正实现\"高效益\"经营目标。也正如集简云所说,业务流程自动化与智能化是企业新的增长引擎!</p><p> </p>", "sort": null, "usage": "help_doc", "published_at": "2023-02-06T07:15:42.000Z", "created_at": "2023-02-06T07:05:26.000Z", "updated_at": "2023-03-09T10:03:47.000Z", "help_collection": 6, "video_url": null, "field": null, "weight": 0, "select": false, "seo": null, "thumb": { "id": 9030, "name": "画板 – 2.png", "alternativeText": "", "caption": "", "width": 200, "height": 120, "formats": null, "hash": "2_1697e10b22", "ext": ".png", "mime": "image/png", "size": 30.1, "url": "/uploads/2_1697e10b22.png", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2023-02-06T07:10:30.000Z", "updated_at": "2023-02-06T07:10:30.000Z" }, "media": { "id": 9029, "name": "自定义大小 – 38.png", "alternativeText": "", "caption": "", "width": 1027, "height": 440, "formats": { "thumbnail": { "name": "thumbnail_自定义大小 – 38.png", "hash": "thumbnail_38_1005715449", "ext": ".png", "mime": "image/png", "width": 245, "height": 105, "size": 35.72, "path": null, "url": "/uploads/thumbnail_38_1005715449.png" }, "large": { "name": "large_自定义大小 – 38.png", "hash": "large_38_1005715449", "ext": ".png", "mime": "image/png", "width": 1000, "height": 428, "size": 465.42, "path": null, "url": "/uploads/large_38_1005715449.png" }, "medium": { "name": "medium_自定义大小 – 38.png", "hash": "medium_38_1005715449", "ext": ".png", "mime": "image/png", "width": 750, "height": 321, "size": 273.5, "path": null, "url": "/uploads/medium_38_1005715449.png" }, "small": { "name": "small_自定义大小 – 38.png", "hash": "small_38_1005715449", "ext": ".png", "mime": "image/png", "width": 500, "height": 214, "size": 129.08, "path": null, "url": "/uploads/small_38_1005715449.png" } }, "hash": "38_1005715449", "ext": ".png", "mime": "image/png", "size": 333.79, "url": "/uploads/38_1005715449.png", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2023-02-06T07:10:10.000Z", "updated_at": "2023-02-06T07:10:11.000Z" } } ]
[ { "id": 25, "name": "钉钉(自建应用)", "description": "<p>钉钉,阿里巴巴出品,专为全球企业组织打造的智能移动办公平台,含PC版,Ipad和手机版。远程视频会议,消息已读未读,DING消息任务管理,让沟通更高效;移动办公考勤,签到,审批,企业邮箱,免费企业OA,企业通讯录,钉钉教育解决方案,让工作学习更简单!</p>", "popular": 216, "published_at": "2021-10-25T03:01:37.000Z", "created_at": "2021-10-25T03:01:35.000Z", "updated_at": "2023-01-28T09:03:31.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1811, "name": "Dingding.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Dingding_ac75c3cf81", "ext": ".svg", "mime": "image/svg+xml", "size": 9.4, "url": "/uploads/Dingding_ac75c3cf81.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:46:50.000Z", "updated_at": "2022-01-26T02:46:50.000Z" } }, { "id": 9, "name": "数据筛选", "description": "<p>数据筛选是集简云的一个内置应用,用于判断数据流程中数据是否符合筛选条件,如果符合筛选条件则继续后续的流程步骤,如果不符合则不会执行后续的流程步骤。</p>", "popular": -12, "published_at": "2021-10-25T02:45:30.000Z", "created_at": "2021-10-25T02:45:27.000Z", "updated_at": "2022-04-21T08:47:17.000Z", "app_id": "7", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "设置筛选条件", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3475, "name": "windeal-filter.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "windeal_filter_0ad26bc0ae", "ext": ".svg", "mime": "image/svg+xml", "size": 0.86, "url": "/uploads/windeal_filter_0ad26bc0ae.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:47:14.000Z", "updated_at": "2022-04-21T08:47:14.000Z" } }, { "id": 631, "name": "数组处理", "description": "<p>数组处理是集简云的一款内置应用,用于将文本变量内容生成一组数组或者将一组数组转换成文本内容,以便用于后续的流程步骤中。</p>", "popular": -1, "published_at": "2022-08-25T05:54:52.000Z", "created_at": "2022-08-25T05:39:49.000Z", "updated_at": "2022-08-25T06:16:51.000Z", "app_id": "1000454", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "集简云内置应用", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 5862, "name": "shuzuchuli.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "shuzuchuli_114ea035f2", "ext": ".svg", "mime": "image/svg+xml", "size": 2.71, "url": "/uploads/shuzuchuli_114ea035f2.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-08-25T05:54:16.000Z", "updated_at": "2022-08-25T05:54:16.000Z" } }, { "id": 52, "name": "日期时间格式变更", "description": "<p>日期时间格式变更帮助解决不同应用步骤中对日期时间格式的不同要求。比如应用A中的日期格式是“年月日”的格式,应用B中的日期格式是时间戳或者其他时间格式,在这种情况下,我们可以在应用A步骤与应用B步骤之间添加一个日期时间格式变更步骤,将时间格式转换后再进行同步。</p>", "popular": 55, "published_at": "2021-10-25T03:26:32.000Z", "created_at": "2021-10-25T03:26:30.000Z", "updated_at": "2023-02-20T11:20:39.000Z", "app_id": "89", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "变更日期时间格式", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3479, "name": "datetime.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "datetime_bed27e05e9", "ext": ".svg", "mime": "image/svg+xml", "size": 1.4, "url": "/uploads/datetime_bed27e05e9.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:50:28.000Z", "updated_at": "2022-04-21T08:50:28.000Z" } }, { "id": 71, "name": "文本处理", "description": "<p>文本处理是集简云内置应用,用于对文字内容的格式进行调整,以便在后续的流程中更好的使用。</p>", "popular": -13, "published_at": "2021-10-25T03:47:29.000Z", "created_at": "2021-10-25T03:47:27.000Z", "updated_at": "2022-04-21T08:49:18.000Z", "app_id": "108", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "转换文本内容", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3476, "name": "wenbenzhuanhuan.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "wenbenzhuanhuan_0a62076317", "ext": ".svg", "mime": "image/svg+xml", "size": 2.96, "url": "/uploads/wenbenzhuanhuan_0a62076317.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:49:15.000Z", "updated_at": "2022-04-21T08:49:15.000Z" } }, { "id": 106, "name": "字段查询", "description": "<p>字段查询是集简云的一个内置应用,可做为执行应用使用。其主要功能是设置一个字段列表进行字段匹配关系查询。</p>", "popular": -20, "published_at": "2021-10-25T06:04:16.000Z", "created_at": "2021-10-25T06:04:14.000Z", "updated_at": "2022-08-10T03:32:26.000Z", "app_id": "148", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "查询预设的字段关系", "available": true, "appid": null, "website": null, "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3482, "name": "ziduanchaxun.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "ziduanchaxun_1c0c5dd6d7", "ext": ".svg", "mime": "image/svg+xml", "size": 0.74, "url": "/uploads/ziduanchaxun_1c0c5dd6d7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:55:13.000Z", "updated_at": "2022-04-21T08:55:13.000Z" } }, { "id": 753, "name": "Oracle", "description": "<p>Oracle系统,即是以Oracle关系数据库为数据存储和管理作为构架基础,构建出的数据库管理系统。 Oracle,世界第一个支持SQL语言的商业数据库,定位于高端工作站,以及作为服务器的小型计算机,如IBM P系列服务器、HP的Integraty服务器、Sun Fire服务器。</p>", "popular": 138, "published_at": "2022-09-29T11:12:39.000Z", "created_at": "2022-09-29T03:27:09.000Z", "updated_at": "2022-09-29T11:12:39.000Z", "app_id": "365", "category": "Developer", "locale": "zh-Hans", "short_description": "关系数据库管理系统", "available": true, "appid": null, "website": " https://www.oracle.com", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 6485, "name": "oracle.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "oracle_679b21561d", "ext": ".svg", "mime": "image/svg+xml", "size": 0.56, "url": "/uploads/oracle_679b21561d.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-09-29T06:14:44.000Z", "updated_at": "2022-09-29T06:14:44.000Z" } }, { "id": 524, "name": "维格表", "description": "<p>维格表将过去复杂的IT数据库技术,做得像表格一样简单 ,可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一,1个维格表,满足团队协作、项目管理、数据协作等1000+场景,让所有工作连接和整合。</p>", "popular": 1, "published_at": "2022-07-25T08:32:52.000Z", "created_at": "2022-07-25T08:32:52.000Z", "updated_at": "2023-01-28T09:02:30.000Z", "app_id": "310", "category": "Teamwork", "locale": "zh-Hans", "short_description": "低代码应用表单系统", "available": true, "appid": null, "website": "https://vika.cn/", "video": null, "videos": null, "app_version": "1.0.1", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 5408, "name": "weigebiao_9542978808.svg", "alternativeText": "", "caption": "", "width": null, "height": null, "formats": null, "hash": "weigebiao_9542978808_c8cf818960", "ext": ".svg", "mime": "image/svg+xml", "size": 7.89, "url": "/uploads/weigebiao_9542978808_c8cf818960.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-07-25T08:39:11.000Z", "updated_at": "2022-07-25T08:39:11.000Z" } } ]
[ { "id": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 }, { "id": 4, "name": "客户管理", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:35.000Z", "created_at": "2022-05-20T08:12:43.000Z", "updated_at": "2022-05-30T07:29:35.000Z", "sort": 2 } ]
[ { "id": 4968, "key": null, "published_at": "2023-01-31T11:01:20.000Z", "created_at": "2023-01-31T11:01:20.000Z", "updated_at": "2023-01-31T11:01:20.000Z", "action_id": "1003836", "action_name": "将数组转换为文本", "error": null, "description": "将数组中的元素按照指定的符号连接成一个字符串", "action_type": "action", "app": null, "template": null }, { "id": 22, "key": null, "published_at": "2021-11-24T06:19:25.000Z", "created_at": "2021-11-24T06:19:22.000Z", "updated_at": "2021-11-24T06:19:25.000Z", "action_id": "15", "action_name": "设置筛选条件", "error": null, "description": "设置筛选条件,只有筛选条件满足后才会继续后续流程步骤", "action_type": "action", "app": null, "template": null }, { "id": 54, "key": null, "published_at": "2021-11-24T06:44:05.000Z", "created_at": "2021-11-24T06:44:03.000Z", "updated_at": "2021-11-24T06:44:05.000Z", "action_id": "241", "action_name": "日期时间格式调整", "error": null, "description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "action_type": "action", "app": null, "template": null }, { "id": 2753, "key": null, "published_at": "2022-07-27T08:43:55.000Z", "created_at": "2022-07-27T08:43:55.000Z", "updated_at": "2022-07-27T08:43:55.000Z", "action_id": "2514", "action_name": "汉字转换成拼音", "error": null, "description": "根据汉字转换成拼音", "action_type": "action", "app": null, "template": null }, { "id": 2933, "key": null, "published_at": "2022-08-11T04:09:25.000Z", "created_at": "2022-08-11T04:09:25.000Z", "updated_at": "2022-08-11T04:09:25.000Z", "action_id": "2635", "action_name": "当符合条件的审批流实例结束时", "error": null, "description": "当符合条件的审批流实例结束时", "action_type": "trigger", "app": null, "template": null }, { "id": 3310, "key": null, "published_at": "2022-09-15T11:16:56.000Z", "created_at": "2022-09-15T11:16:56.000Z", "updated_at": "2022-09-15T11:16:56.000Z", "action_id": "2850", "action_name": "查询审批实例详情1.0.1", "error": null, "description": "查询审批实例详情(新抹平)", "action_type": "action", "app": null, "template": null }, { "id": 3508, "key": null, "published_at": "2022-09-29T11:15:46.000Z", "created_at": "2022-09-29T11:15:46.000Z", "updated_at": "2022-09-29T11:15:46.000Z", "action_id": "2888", "action_name": "新增数据到指定数据表", "error": null, "description": "添加数据到指定Oracle数据表中", "action_type": "action", "app": null, "template": null }, { "id": 4048, "key": null, "published_at": "2022-11-11T09:57:57.000Z", "created_at": "2022-11-11T09:57:57.000Z", "updated_at": "2022-11-11T09:57:57.000Z", "action_id": "3070", "action_name": "批量设置匹配关系", "error": null, "description": "批量根据字段内容进行设置匹配关系", "action_type": "action", "app": null, "template": null }, { "id": 304, "key": null, "published_at": "2021-11-29T09:05:26.000Z", "created_at": "2021-11-29T09:05:24.000Z", "updated_at": "2021-11-29T09:05:26.000Z", "action_id": "402", "action_name": " 发送文本消息", "error": null, "description": "通过输入指定成员ID发送文本", "action_type": "action", "app": null, "template": null }, { "id": 239, "key": null, "published_at": "2021-11-26T05:46:39.000Z", "created_at": "2021-11-26T05:46:36.000Z", "updated_at": "2021-11-26T05:46:39.000Z", "action_id": "541", "action_name": "公式搜索数据", "error": null, "description": "公式搜索维格表数据", "action_type": "action", "app": null, "template": null } ]
[]
[]
100+
100+
99
100+
71