search

kubecub / feishu-sheet-parser

A system that monitors and tracks ESG (Environmental, Social and Governance) disclosures and ratings from various public data sources. It collects ESG data points from sources like Feishu spreadsheets and makes them available through an administrative interface.
https://kubecub.github.io/feishu-sheet-parser/
MIT License
3 stars 2 forks source link

Automation: Create background for Feishu documents #2

Closed cubxxw closed 1 year ago

cubxxw commented 1 year ago

开始

飞书的文档地址：

构建一个基于Go语言实现的后台系统，用于管理和展示某ESG标准相关的飞书表格文档中的多个sheet。

系统需具有版本管理功能，能跟踪文档各个sheet的历史修改记录并支持比较不同版本之间的变化。

系统需要能够识别并解析文档中名为“港交所”的sheet，提取其中定义的二级议题和四级议题，并通过web API或其他方式将其结构化数据展示给用户。

同时，系统需要具有 sheet 识别的通用性，如果文档中新增名为“港交所1”、“港交所2”等的 sheet，系统也需要能够识别并进行相同的解析和展示。

为完成这个需求，需要补充的知识如下:

  1. 精通Go语言，熟悉其Web框架如Gin等以开发API

  2. 熟悉飞书表格文档格式，理解 sheet、单元格等结构，能通过飞书开放API解析文档

  3. 了解版本控制系统的原理，选择合适的方案实现文档版本管理

  4. 具有一定的前端知识，能调用飞书表格API将解析结果在网页端展示

  5. 熟练使用Go测试框架并编写测试用例，确保系统关键功能的正确性

开源社的一些链接

kubbot commented 1 year ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

start

The document address of Feishu:

Construct a background system based on Go language to manage and display multiple sheets in Feishu table documents related to an ESG standard.

The system needs to have a version management function, which can track the historical modification records of each sheet of the document and support the comparison of changes between different versions.

The system needs to be able to identify and parse the sheet named "Hong Kong Stock Exchange" in the document, extract the second-level and fourth-level topics defined in it, and display its structured data to users through web API or other methods.

At the same time, the system needs to have the versatility of sheet identification. If a new sheet named "Hong Kong Stock Exchange 1", "Hong Kong Stock Exchange 2", etc. is added to the document, the system also needs to be able to recognize and perform the same analysis and analysis. exhibit.

In order to fulfill this requirement, additional knowledge is required as follows:

  1. Proficient in Go language, familiar with its web framework such as Gin to develop API

  2. Familiar with the format of Feishu table documents, understand sheet, cell and other structures, and be able to parse documents through Feishu open API

  3. Understand the principle of version control system, choose the appropriate solution to realize document version management

  4. Possess certain front-end knowledge and be able to call the Feishu form API to display the analysis results on the web page

  5. Proficiency in using the Go test framework and writing test cases to ensure the correctness of key system functions

Some links of Kaiyuanshe

kubbot commented 1 year ago

This issue is stale because it has been open 7 days with no activity. Remove stale label or comment or this will be closed in 7 days.

kubbot commented 1 year ago

This issue was closed because it has been stalled for 5 days with no activity.

kubbot commented 1 year ago

This issue is stale because it has been open 7 days with no activity. Remove stale label or comment or this will be closed in 7 days.

kubbot commented 1 year ago

This issue was closed because it has been stalled for 5 days with no activity.