公开(公告)号：KR20070080564A

公开(公告)日：2007-08-10

申请号：KR20070011360

申请日：2007-02-05

Applicant: IBM

Inventor： OLIVIERI RICARDO N ,  WHELAN MARK B

IPC: G06F17/30 ,  G06F9/06 ,  G06F17/00

CPC classification number: G06F17/246

Abstract: A system, a method, and a medium for processing a spreadsheet to store the spreadsheet to a database are provided to process/store the spreadsheet to the database by automatically processing records of the spreadsheet and applying a conventional validation/business process logic. A request for processing the spreadsheet including a plurality of records to store the spreadsheet to the database is received(502). A configuration file related to the spreadsheet is generated by receiving more than one name of a business object related to the record of the spreadsheet, metadata for more than one column of the spreadsheet, and the name of a back-end business component related to the spreadsheet. The generated configuration file is accessed(508). A new business object is generated for each record of the spreadsheet, and is populated based on the records and the configuration file(514). Each new business object is transferred to a back-end business application(516).

Abstract translation: 提供用于处理电子表格以将电子表格存储到数据库的系统，方法和介质，用于通过自动处理电子表格的记录并应用常规的验证/业务流程逻辑来将该电子表格处理/存储到数据库。 接收用于处理包括多个记录以将该电子表格存储到数据库的电子表格的请求（502）。 通过接收与电子表格的记录相关的业务对象的多个名称，电子表格的多个列的元数据以及与该电子表格相关的后端业务组件的名称，生成与电子表格相关的配置文件 电子表格。 生成的配置文件被访问（508）。 为电子表格的每个记录生成一个新的业务对象，并根据记录和配置文件（514）进行填充。 每个新的业务对象被转移到后端业务应用程序（516）。

公开(公告)号：CA2577537A1

公开(公告)日：2007-08-07

申请号：CA2577537

申请日：2007-02-07

Applicant: IBM

Inventor： OLIVIERI RICARDO N ,  WHELAN MARK B

IPC: G06F17/30

Abstract: Generally speaking, systems, methods and media for processing a spreadsheet for storage in a database are disclosed. Embodiments may include a method for processing records of a spreadsheet by receiving a request to process a spreadsheet having a plurality of records for storage in a database. Embodiments may also include accessing a configuratio n file associated with the spreadsheet and, for each record of the spreadsheet, creating a new business object and populating the new business object based on the record and the configuration file associated with the spreadsheet. Embodiments may also include passing each new business obje ct to a back-end business component for processing. The configuration file may include a name of a business object associated with a record of the spreadsheet, metadata for one or more columns of the spreadsheet, and/or a name of a back-end business component associated with the spreadsheet.