JP2016057690A - Client device, server device, and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a client device, a server device, and a program with which it is possible to perform a document output process performed in such a way as not to pose a load on the server device.SOLUTION: The client device according to an embodiment comprises: transmission means for transmitting, to the server device, request information requesting the downloading of symbol delimiter data created by delimiting a value included in a document with a symbol and the format data of the document; reception means for receiving the format data and the symbol delimiter data as a response from the server device to the request information transmitted by the transmission means; conversion means for converting the format of the symbol delimiter data received by the reception means into an add-in file; execution means for executing spreadsheet software; and add-in execution means for expanding, when the add-in file is opened while the spreadsheet software is being run, the data included in the add-in file into the spreadsheet in the format indicated by the format data.SELECTED DRAWING: Figure 2

Description

  Embodiments described herein relate generally to a client device, a server device, and a program.

  Conventionally, in a system for displaying form data such as a sales list and an invoice, several systems have been proposed in which various form data are created on the server device side and displayed on the client device side.

  In such a system, various types of form data are created on the server device side, so a great load is concentrated on the CPU of the server device. If this server device provides other services in addition to the distribution of form data, the server device cannot process these services normally and an error occurs on the client device side. Yes. For example, in a credit inquiry or the like, processing may not be completed and an error may occur.

In addition, there is the following aspect of the system in which the load is concentrated on the server device.
In the shopping center, a shopping center management system that visually displays the arrangement and sales of each tenant on the same floor on a screen is described. In this system, the floor is divided into grids, and layout information indicating the tenant arrangement is set according to the grids. When the layout of each tenant is called, the tenant arrangement and the sales data of the tenant are displayed on the screen. Even in such a case, if all processing is performed by the server device, a large load is applied to the CPU of the server device.

  Therefore, it is an issue to reduce the load on the server device and perform various services without hindrance.

  The problem to be solved by the present invention is to provide a client device, a server device, and a program capable of performing a form output process that does not cause a load on the server device.

  The client device according to the embodiment transmits, to the server device, request information for requesting download of symbol-separated data obtained by separating values included in the form with symbols and format data of the form, and the transmission means transmits the request information. Receiving means for receiving the format data and the symbol delimiter data as a response from the server device to the requested information, conversion means for converting the format of the symbol delimiter data received by the receiving means into an add-in file, and a table Execution means for executing calculation software, and add-in execution means for expanding data contained in the add-in file into a spreadsheet in a format indicated by the format data when the add-in file is opened during execution of the spreadsheet software And comprising.

FIG. 1 is a schematic configuration diagram of a form output system according to an embodiment. FIG. 2 is a block diagram illustrating a hardware configuration of the server apparatus. FIG. 3 is a functional block diagram of the server device. FIG. 4 is a block diagram illustrating a hardware configuration of the client device. FIG. 5 is a functional block diagram of the client device. FIG. 6 is a process flow diagram during the setup program download process. FIG. 7 is a processing flow diagram when downloading the actual data. FIG. 8 is a diagram illustrating a configuration example of a form selection screen. FIG. 9 is a diagram illustrating a configuration example of the extraction range designation screen. FIG. 10 is a diagram illustrating a configuration example of the form format data. FIG. 11 is a diagram illustrating a display example of a form screen. FIG. 12 is a functional block diagram of the client device of the first modification. FIG. 13 is a hardware configuration diagram of the client apparatus according to the second modification. FIG. 14 is a display example of the customized form data. FIG. 15 is a diagram showing form format data corresponding to the form data for customization shown in FIG. FIG. 16 is a functional block diagram of a client device according to the second modification. FIG. 17 is a processing flowchart from custom form format data creation processing to upload processing. FIG. 18 is a process flow diagram for custom form format data download processing.

  Hereinafter, embodiments of a client device, a server device, and a program will be described in detail with reference to the accompanying drawings.

  FIG. 1 is a schematic configuration diagram of a form output system 1. The form output system 1 includes a server apparatus 10 that accumulates various data for form output and client apparatuses 15-1, 15-2,..., 15-N (N is a positive integer) that outputs forms. Consists of a network system including

  The server apparatus 10 and the client apparatuses 15-1, 15-2,..., 15-N are connected by a connection line 19 such as a LAN (Local Area Network) or a VPN (Virtual Private Network).

  The client devices 15-1, 15-2,..., 15 -N each access the server device 10 via the connection line 19 and acquire various data for form output from the server device 10. Various data acquired from the server device 10 is output to a display screen using spreadsheet software. In addition, each of the client devices 15-1, 15-2,..., 15-N is connected to a printer (not shown), and can output a form from the printer.

  The client apparatuses 15-1, 15-2,..., 15-N are information processing apparatuses that function as clients, provided in individual developer offices E1, E2,. is there. The other server device 10 is an information processing device provided in the data center F or the like that functions as a server.

Next, various devices will be described in detail.
First, the server device 10 will be described.
FIG. 2 is a block diagram illustrating a hardware configuration of the server device 10. The server device 10 mainly includes a control unit 100, a storage unit 101, and a communication I / F 102. Each unit is interconnected by a bus 103.

  The control unit 100 is a computer that performs various operations and overall control of each unit of the server device 10 and performs arithmetic processing, data input / output control, and the like. The control unit 100 includes a CPU (Central Processing Unit), a ROM (Read Only Memory) that stores various programs and data, and a RAM (Work Memory that expands various programs and stores data in a rewritable manner). Random Access Memory), an RTC (Real-Time Clock) unit that measures the current date and time, and the like.

  The storage unit 101 is a built-in memory or a detachable external storage device (for example, an HDD (Hard Disk Drive) or a flash ROM).

  The storage unit (including first and second storage means) 101 includes a setup program SET for form output, a database DB for storing result data for form output, and software P for extracting the result data. Remember.

  The setup program SET is a setup program that is executed as a preparation for outputting a form in the client apparatuses 15-1, 15-2,..., 15-N. The setup program SET includes form format data DA1, conversion program P1, add-in program P2, and the like.

The form format data DA1 is reference data that defines a format for expanding the above-mentioned record data into a spreadsheet, and is used as a template.
Further, the conversion program P1 is a program for converting the format of the record data into an add-in file.

  The add-in program P2 is a program that is executed when an add-in file is opened by spreadsheet software. When executed, the add-in program P2 expands the performance data included in the add-in file into a spreadsheet in a format defined in the form format data DA1.

  The database DB is a database that stores company performance data. The record data includes record data indicating sales information such as the number of customers and sales per square meter, record data indicating various fee breakdowns, and the like.

  The software P includes a management program P3, SQL (Structured Query Language) data DA2, an extraction program P4, a server program P5, selection screen data DA3, a transmission / reception program P6, and the like.

  The management program P3 is a database DB management program such as a DBMS (DataBase Management System).

  The SQL data DA2 is a data file in which an SQL sentence is associated with each request information, and is used for reference.

  The extraction program P4 is a program for extracting target performance data from the database DB. When executed, the extraction program P4 acquires an SQL statement from the SQL data DA2 based on the download request information transmitted from the client device, and issues the SQL statement to the management program P3. Then, the performance data returned from the management program P3 (for example, symbol-separated data such as a TSV (Tab Separated Values) file) is passed to the server program P5.

  The server program P5 is a program for performing communication (HTTP communication, FTP communication, etc.) with a browser of the client device. For example, when receiving an HTTP request from a designated port, the server program P5 generates an HTTP response and passes it to the lower layer. If the HTTP request is a request for performance data, the extraction program P4 is requested to process it. And the acquired performance data are acquired, an HTTP response is produced | generated, and it passes to a lower layer.

  The server program P5 accepts a request for uploading or downloading a file. When the server program P5 receives a file upload request from the designated port, the server program P5 stores the file in a predetermined directory. When a file download request is received from the designated port, the file is acquired from a predetermined directory and passed to the lower layer.

  The selection screen data DA3 is screen data displayed on the client device side during HTTP communication with the client device. The selection screen data DA3 includes a selection item for the user of the client device to select the setup program SET and the type of result data, a button for specifying download and upload, and the like.

  The transmission / reception program P6 is a program for transmitting / receiving a request command and data. When the transmission / reception program P6 receives a packet through the communication I / F 102, the transmission / reception program P6 checks, for example, the transmission source IP address and the destination IP address. Then, when the data is addressed to the own device, the data in the packet is passed to the designated port. When data is acquired from an application such as a server, the data is stored in a packet by changing the transmission source IP address to the destination IP address, and the packet is transmitted from the communication I / F 102.

  The communication I / F 102 is a communication interface unit including a NIC (Network Interface Card) for communicating with an external device.

FIG. 3 is a functional block diagram of the server device 10.
In the hardware configuration of FIG. 2, the CPU of the control unit 100 loads various programs such as the storage unit 101 into the main storage device (RAM) and executes these programs. Thereby, the server apparatus 10 functions as the transmission / reception means 200, the extraction means 201, the database management means 202, and the like.

  The transmission / reception means 200 is based on the server program P5, the transmission / reception program P6, and the like. When the communication I / F 102 receives a request for downloading the setup program SET, the transmission / reception means 200 acquires the setup program SET from the storage unit 101 and transmits it to the transmission source client apparatus. When the communication I / F 102 receives a request for downloading the record data, the extraction unit 201 is requested to extract the record data, and the extracted data is acquired. The acquired extracted data is transmitted to the transmission source client device.

  When there is a request to extract the performance data from the transmission / reception means 200, the extraction means 201 issues an SQL statement or the like to inquire the database management means 202. The database management unit 202 extracts performance data from the database DB based on the SQL sentence or the like. The extraction unit 201 acquires the performance data extracted by the database management unit 202.

  The database management unit 202 manages the database DB. For example, in accordance with a command such as an SQL statement, processing such as extraction / deletion / addition / update of performance data in the database DB is performed.

  Next, the client devices 15-1, 15-2,..., 15-N will be described. The client apparatuses 15-1, 15-2, ..., 15-n (n = 1, 2, ...), ..., 15-N have the same main configuration and operation. Therefore, in the following description, the client device 15-n will be described as an example.

  FIG. 4 is a block diagram illustrating a hardware configuration of the client device 15-n. The client device 15-n mainly includes a control unit 150, an input unit 151, a display unit 152, a printing unit 153, a storage unit 154, and a communication I / F 155. Each part is interconnected by a bus 156.

  The control unit 150 is a computer that performs various operations and overall control of each unit of the client device 15-n to perform calculation processing, data input / output control, and the like. The control unit 150 includes a CPU (Central Processing Unit), a ROM for storing various programs and data, a RAM as a work memory for developing various programs and storing data in a rewritable manner, and measuring the current date and time. Configured by an RTC unit or the like.

  The input unit 151 is an input device such as a keyboard or a mouse, converts a user input instruction into predetermined data, and outputs the data to the control unit 150. For example, when a predetermined key is pressed on the keyboard, it is converted into a character code or an instruction code assigned to the key and output to the control unit 150. In addition, a signal indicating the amount of movement from the mouse, a lick operation, and the like is output to the control unit 150.

  The display unit 152 is a display device including a display such as a liquid crystal. Display data stored in the storage unit 154, display data generated by the control unit 150, and the like are displayed on the display. The display data is a UI (User Interface) screen, data such as text input by the input unit 151, a cursor, and the like.

  The printing unit 153 is a printer that prints data. The data displayed in the form format on the display is printed on the printing paper in the form form.

  The storage unit 154 is a built-in memory or a removable external storage device (for example, an HDD or a flash ROM).

  The storage unit 154 stores data and programs for form output installed by executing the spreadsheet software P10, the execution of the setup program SET (see FIG. 2), and the like. Data and programs for form output are mainly form format data DA1, conversion program P1, add-in program P2, and the like. The add-in program P2 is associated as an add-in program in the spreadsheet software and operates in conjunction with the spreadsheet software P10.

  In addition, the storage unit 154 stores software PK for acquiring performance data from the server device 10.

The software PK includes a browser P11, a transmission / reception program P12, and the like.
The browser P11 is a Web browser and includes an FTP communication function in addition to an HTTP communication function.

  The transmission / reception program P12 is a program for transmitting / receiving request information and data. When the transmission / reception program P12 receives the packet through the communication I / F 155, the transmission / reception program P12 checks the source IP address and the destination IP address, for example. Then, when the packet is addressed to itself, the data in the packet is passed to the designated port. When data is acquired from the browser (HTTP client, FTP client) P11, the source IP address and the destination IP address are added to the packet, and the data is transmitted from the communication I / F 155 as a packet.

The storage unit 154 also includes a storage area M1 for storing actual data (TSV data) downloaded from the server device 10, and a storage area M2 for storing an add-in format file after converting actual data. .
The communication I / F 155 is a communication interface unit that includes a NIC for communicating with an external device.

FIG. 5 is a functional block diagram of the client device 15-n.
In the hardware configuration of FIG. 4, the CPU of the control unit 150 loads various programs in the storage unit 154 to the main storage device (RAM) and executes the various programs, so that the client device 15-n has the transmission / reception means 250. , Function as setup unit 251, selection unit 252, conversion unit 253, spreadsheet unit 254, and the like.

  The transmission / reception means 250 is based on the browser P11, the transmission / reception program P12, and the like. The transmission / reception means 250 performs HTTP communication with the server device 10 via the communication I / F 155 and acquires the selection screen data DA3 (see FIG. 2) of the server device 10 from the communication I / F 155. Also, a request for downloading the setup program SET (see FIG. 2) is output to the communication I / F 155. When the setup program SET is received by the communication I / F 155, the setup program SET is stored in the storage unit 154. Also, a request for downloading performance data of a company corresponding to the own device is output to the communication I / F 155. And if the performance data is received by communication I / F155, it will preserve | save in the memory area M1 of the memory | storage part 154. FIG.

  The setup unit 251 receives a user execution instruction from the input unit 151, and uses this as a trigger to read and execute the setup program SET in the storage unit 154. As a result of this execution, the setup unit 251 installs data and programs necessary for the form output in its own device. For example, the form format data DA1, the conversion program P1, the add-in program P2, and the like are stored in a predetermined folder. The add-in program P2 is associated with the spreadsheet software as an add-in program.

  The selection unit 252 outputs the selection screen data DA3 acquired by the transmission / reception unit 250 to the display unit 152, and accepts a setup program SET and a request for downloading actual data on the selection screen. When the user presses a selection button on the selection screen or a download execution button, the setup program SET and the result data are downloaded via the transmission / reception means 250.

  The conversion unit 253 converts the format of the record data stored in the storage unit 154 into an add-in format file.

  The spreadsheet unit 254 includes a main body execution unit 254a that executes a main body of the spreadsheet software and an add-in execution unit 254b that executes an add-in program. Specifically, the add-in execution means 254b is a spreadsheet in which the result data included in the add-in file is set in the form format data when opening of the add-in format file is designated during execution of the spreadsheet software. Expand to.

6 and 7 are diagrams illustrating a communication flow between the server device 10 and the client device 15-n.
First, the flow of processing for downloading the setup program SET in the client device 15-n will be described.
FIG. 6 is a diagram illustrating a communication flow between the server device 10 and the client device 15-n during the download process of the setup program SET.

  The user interface unit UI (including the selection unit 252) in FIG. 6 provides an operation screen as an input interface to the user of the client device 15-n. In the following description, it is assumed that the browser input interface is displayed on the display unit 152 when the browser program P11 is started in the client device 15-n.

  First, the user inputs the URL or IP address of the server device 10 in the address bar of the browser screen, and requests the top index screen (hereinafter referred to as the TOP screen) (S1). The request signal is transmitted from the transmission / reception means 250 of the client apparatus 10 toward the server apparatus 10 and received by the transmission / reception means 200 of the server apparatus 10 (S2).

  The transmission / reception means 200 of the server device 10 acquires the TOP screen data in the selection screen data DA3 of the storage unit 101 (S3, S4), and transmits it to the transmission / reception means 250 of the requesting client device 15-n (S5). . In the client device 15-n, the transmission / reception unit 250 passes the TOP screen to the user interface unit UI, and the user interface unit UI displays the TOP screen on the display unit 152 (S6). The TOP screen has buttons for downloading and uploading. When the user presses the download button on the TOP screen, a request signal for the next screen is generated, and processing is performed in the same flow as the display on the TOP screen (S7 to S12). Therefore, the user interface means UI displays the next screen (form selection screen) of the TOP screen in the selection screen data DA3 on the display unit 152.

FIG. 8 is a diagram illustrating a configuration example of a form selection screen.
The form selection screen G1 in FIG. 8 includes “form output setup” g1, “sales list” g2, “credit fee breakdown list” g3, and the like as selection items g. “XXX1, XXX2, XXX3 (X is an arbitrary number)” written together with the item name is an identification code.

  Further, the form selection screen G1 includes update date / time h and size s (“...” In FIG. 8 indicates data) as additional information of the selection item g. In addition, an execution button B1 for executing processing of the item selected by the user is included. When the user selects the “form output setup” g1 of the selection item g and presses the execution button B1, the client device 15-n performs a process of acquiring setup data for performing the form output from the server device 10. When the user selects “sales list” g2 or “credit fee breakdown list” g3 and presses the execution button B1, the client apparatus 15-n stores the actual data of the type corresponding to the selected one. Processing to be acquired from the apparatus 10 is performed.

  Here, in order to explain the flow of setup, the user selects “form output setup” g1 on the form selection screen G1.

Here, returning to FIG. 6, the continuation will be described.
The item information “form output setup” g1 selected by the user in step S13 is acquired by the transmission / reception means 250 and the item information is transmitted to the server device 10 (S14). In the server device 10, the transmission / reception means 200 acquires the item information, and further acquires the setup program SET corresponding to the item information from the storage unit 101 (S15, S16). The transmission / reception means 200 transmits the setup program SET to the client device 15-n (S17). In the client device 15-n, the transmission / reception means 250 receives the setup program SET and stores the setup program SET in the storage unit 154 (S18).

  In the client device 15-n, the internal system (operating system) appropriately displays a screen for specifying a storage location, a screen for indicating a download execution state, and the like after the execution button B1 is pressed.

  Subsequently, the user designates the setup program SET in the storage unit 154 on the display screen of the file management system provided by the internal system (a screen showing hierarchical arrangement of folders and files) (S19). As a result, the setup program SET rises as the setup processing unit 251 (S20), and the setup unit 251 executes the setup process (S21). The setup unit 251 installs various data and programs for outputting the form by arranging the form format data DA1, the conversion program P1, the add-in program P2, and the like included in the setup program SET in the designated folder of the storage unit 154 (S22). ). By this installation, the add-in program P2 is associated with the spreadsheet software P10.

After the installation is finished, the display screen of the internal system is closed, and the display screen becomes a browser TOP screen.
Thus, the preparation for outputting the form by installing the setup program SET is completed.

  Next, the flow of processing when the client device 15-n outputs the result data in a predetermined display format will be described.

This process also starts with a flow similar to that shown in FIG. 6, and the user requests the download form selection screen G1 and causes the display unit 152 to display it.
Note that the form selection screen G1 is displayed on the display unit 152 after the completion of all the processes in FIG. For this reason, when this process is performed following the process shown in FIG. 6, the processes until the form selection screen G1 is acquired are omitted.

FIG. 7 is a diagram showing a flow of communication between the server device 10 and the client device 15-n during the process of outputting the result data in a predetermined display format.
FIG. 7 shows the flow of processing after display of the form selection screen G1.
First, from the selection item g on the form selection screen G1, the user selects “sales list” g2 or “credit fee breakdown list” g3 as a request for performance data. Here, as an example, “sales list” g2 is selected.

  When the user selects the “sales list” g2 of the selection item g and presses the execution button B1, a request signal for the next screen is generated and processed in the same flow as the display of the form selection screen G1 (S7 to S12). (S30 to S35) are performed. Therefore, the user interface means UI displays the next screen (extraction range designation screen) of the form selection screen G1 in the selection screen data DA3 on the display unit 152.

FIG. 9 is a diagram illustrating a configuration example of the extraction range designation screen.
The extraction range designation screen G2 in FIG. 9 includes “date” m1, “account date” m2, “contrast date” m3, “classification management code” m4, and “password” m5 as input items m. Moreover, the input fields m11-m15 of each input item m1-m5 are included. Furthermore, an execution button B2 for executing processing under the extraction conditions set by the user in the input fields m11 to m15 is included.

In the “date” m1 input field m11, a date is set as the range of the sales list to be extracted.
The range of the sales list to be extracted is specified by setting “start date” to “end date” of the account date in the input column m12 of “account date” m2.
The range of the sales list to be extracted is specified by setting “start date” to “end date” of the comparison date in the input column m13 of “contrast date” m3.
A classification management code is set in the input field m14 of “classification management code” m4.
A password for authentication is set in the input field m15 of “password” m5.

Here, the continuation of FIG. 7 will be described.
The user sets the input fields m11 to m15 and presses the execution button B2. Then, the transmission / reception means 250 acquires the data (extraction conditions) set in the input fields m11 to m14 and the password of the input field m15 (S36), and transmits them to the server device 10. In the server device 10, the transmission / reception means 200 acquires such information (S37). Then, the transmission / reception means 200 performs a password authentication process.

  The password authentication process (restriction means) is for restricting the extraction of performance data for the client device 15-n. Depending on the password, it rejects the extraction of performance data and restricts the type and range of performance data that can be accessed. For example, if the password has the authority to access all data, the data is acquired by accessing all data in the database DB in the processing (steps S42 and S43) described later. If the password is authorized to access only a part of the data, the data is acquired from the restricted range in the database DB.

  When the authentication process is completed and the password has an access right, the transmission / reception unit 200 passes search conditions to the extraction unit 201 and extracts execution data (hereinafter referred to as sales result data) for the “sales list”. Is requested (S38). It is assumed that the transmission / reception means 200 requests the extraction of sales performance data of a company to which the requesting client device 15-n belongs. The company is identified by the terminal information of the client device 15-n. Alternatively, the client device 15-n transmits the identification information of the company together with the search condition to the server device 10, and the server device 10 identifies the company based on the identification information.

  Next, the extraction unit 201 reads the SQL data DA2 from the storage unit 101 (S39, S40). Then, the SQL sentence and the search condition corresponding to the request content are passed to the database management unit 202 (S41). The database management unit 202 accesses the database DB of the storage unit 101 (S42), and extracts sales performance data from the database DB based on the SQL statement and the search condition (S43). Then, the extracted sales performance data (TSV data) is transferred to the extracting means 201 (S44). The extraction unit 201 passes the sales result data to the transmission / reception unit 200 as a response to the request (S45). The transmission / reception means 200 transmits the sales result data to the client device 15-n (S46). In the client device 15-n, the transmission / reception means 250 receives the sales record data and stores the sales record data in the storage unit 154 (S47).

  Here, the sales performance data (TSV data) is a text file in which values (items and data such as “tenant name”, “net sales”, “number of customers”, “customer unit price”) are separated by tabs. In addition to tabs, they may be separated by other symbols such as spaces.

  Subsequently, the user executes the conversion program P1 by designating an icon of the conversion program P1 in the storage unit 154 on the display screen of the file management system provided by the internal system (S48). With this execution, the conversion program P1 reads the sales record data from the storage unit 154 (S49, S50), converts the sales record data into an add-in format file (S51), and stores the add-in format file in the storage unit 154 (S52). ). The conversion process to the add-in format file specifically refers to a batch process in which the conversion program P1 renames the TSV format extension of the sales record data to the add-in format extension.

  Next, the user executes the conversion program P1 by designating an icon of the spreadsheet software P10 in the storage unit 154 on the display screen of the file management system provided by the internal system (S53). The main body execution unit 254a reads the spreadsheet software P10 from the storage unit 154 according to an execution command from the user, and performs startup processing such as initialization (S54). Then, the dedicated screen of the spreadsheet software P10 is transferred to the user interface means UI (S55).

  Next, the user designates a file to be opened (opened) on the dedicated screen of the spreadsheet software P10 (S56). Specifically, the user presses an open button on the dedicated screen to display the display screen of the file management system of the internal system. Specify the spreadsheet file on this display screen. Here, in particular, an add-in format file is designated as a spreadsheet file. Based on this designation, the main body execution unit 254a reads the add-in format file in the storage unit 154 to the add-in execution unit 254b (S57, S58). Subsequently, the add-in execution means 254b reads the form format data DA1 in the storage unit 154 (S59, S60).

FIG. 10 is a diagram showing a configuration example of the form format data DA1 that defines the display format of sales performance data.
In the form format data DA1-1 shown in FIG. 10, the name of an item in the form, the position of a cell (row number, column number) on the spreadsheet on which the item is arranged, and the like are defined. In addition, the position (row number, column (A, B, C...)) And data format (formula) where TSV data included in the add-in format file is arranged on the spreadsheet are determined.

After step S60 in FIG. 7, the add-in execution means 254b expands the sales result data included in the add-in format file on the spreadsheet in the format defined in the form format data DA1-1 (S61). Then, the main body execution unit 254a reads the information (S62) and passes it to the user interface unit UI as a form screen (S63).
The user interface means UI displays a form screen and waits for input from the user.

FIG. 11 is a diagram showing a display example when the form screen is displayed on the display unit 152 of the client device 15-n.
A form Q in FIG. 11 is a display example of the form screen. The sales result data downloaded from the server device 10 is not displayed simply as a list of data, but is displayed according to the form format of the form format data DA1-1 provided by the server apparatus 10.

  As described above, the client device 15-n downloads the form format data from the server device 10 together with the setup program for outputting the form, and then the client device 15-n downloads only the record data from the server device 10. Therefore, the CPU load on the server device 10 side can be distributed to the client devices 15-n.

After outputting the result data on the display screen, the client device 15-n can transfer the data to the printing unit and output the form with a printer.
In addition, the user can process the display mode of the data by using the function of the main body processing unit 254a. For example, the data order such as ascending order or descending order can be rearranged.
That is, the user can process the data display mode on the client device 15-n and output the form.

(Modification 1)
In the first modification, in the form output system 1 shown as one aspect of the embodiment, an aspect of the client device 15-n that allows the user to process the data display aspect of the form screen is shown.

FIG. 12 is a functional block diagram of the client device of the first modification.
The functional block diagram shown in FIG. 12 is the functional block diagram of the client device 15-n in FIG. 5 in which an editing accepting means 350 and a saving means 351 are further added to the main body executing means 254a.

  The edit accepting means 350 maintains the editing function of the spreadsheet software P10 in the on state and displays the operation element as operable in the operation area of the spreadsheet software P10. For example, the editing accepting unit 350 maintains the function of rearranging in ascending order or descending order and displays the ascending order button or descending order button on the ribbon as operable. Also, the function for editing the data display format (font, style, etc.) and cell layout is maintained in the on state, and various buttons for operating the layout are displayed as operable on the ribbon. Note that the cell layout editing target may be determined as appropriate, such as color, row width, and column width.

  The storage unit 351 stores the form data (edited form data or unedited form data) displayed on the display unit 152 with a standard extension or the like by executing a save instruction. Save to 154.

  As a result, the user can edit the order and the data format of the record data included in the form data of the display unit 152 by operating the operation buttons of the spreadsheet software P10. Further, by saving the form data in the storage unit 154, the form data can be expanded into a spreadsheet by the main body executing unit 254a from the next time without using the add-in executing unit 254b.

(Modification 2)
In the second modification, in the form output system 1 of the embodiment, custom form format data (second form data) customized by the user can be used in each of the client devices 1, 2,..., 15-N. The form of the form output system to make is shown. In this mode, first, the user uniquely customizes the display mode of the form on the client device 15-n. Then, the client device 15-n uploads the customized custom form format data to the server device 10. When the client apparatus 1, 2,..., 15-N downloads the actual data from the server apparatus 10, the user can select and download the custom form format data and use the custom form format data. To.

First, differences in configuration from the server device 10 of the embodiment will be described.
The server device of Modification 2 differs in the storage form of the form format data DA1 in the configuration of the server device 10 of the embodiment (see FIG. 2).

  The server device 10 according to the embodiment stores, in the storage unit 101, the form program data DA1 incorporated into the setup program SET.

  On the other hand, the server device of the second modification stores the form format data DA1 in the storage unit 101 separately from the setup program SET. Specifically, a predetermined directory for form format data is provided, and form form data DA1 is stored in the directory. In the second modification, the custom form format data is also stored in the directory separately from the form format data DA1.

Hereinafter, the form format data DA1 is referred to as “standard form format data DA1” and is distinguished from “custom form format data”.
In addition, the server device of the modification 2 further includes a screen for selecting standard form format data DA1 and custom form format data in the selection screen data DA3 (see FIG. 2).

  On the premise of the transmission / reception means 200 (see FIG. 3), the server device of the second modification example receives the custom form format data upload request in the communication I / F 102, and the custom device transmitted from the client device. The form format data is stored in a predetermined directory in the storage unit 101. When the communication I / F 102 receives a request for downloading the standard form format data DA1 or custom form format data, the standard form format data DA1 or custom form format data is acquired from a predetermined directory in the storage unit 101 and transmitted. Sent to the original client device.

Next, differences in configuration from the client device 15-n according to the embodiment will be described.
FIG. 13 is a hardware configuration diagram of the client apparatus according to the second modification.
The client device 15B-n of Modification 2 shown in FIG. 13 is different from the configuration of the client device 15-n of the embodiment (see FIG. 4) in the following points.

  First, the client device 15-B of the second modification differs in the storage area setting of the form format data (that is, standard form format data) DA1 shown in the configuration diagram (see FIG. 4) of the client device 15-n of the embodiment. . In the client device 15B-n of the second modification, the storage area is provided as an area for additionally storing the custom form format data DA5 in addition to storing the standard form format data DA1 at the time of installation. This area is shown as a form format data storage area M3 in FIG.

  Further, the client device 15-B of the second modification further includes form data (customization form data) DA5 used by the user to customize the form format data on the screen.

  Further, when the user displays the customized form data DA5 on the screen and edits the display mode on the screen, the form format data (later custom form format data) DA6 in which the edited contents are directly reflected as data is further added. Prepare.

FIG. 14 shows a display example when the customized form data DA5 is displayed on the spreadsheet of the spreadsheet software.
FIG. 15 shows form format data DA6 indicating the display mode of the customized form data DA5 shown in FIG.

  The form format data DA6 in FIG. 15 defines the names of items in the form shown in FIG. 14, the cell positions (row numbers, column numbers) on the spreadsheet where the items are arranged, and the like. In addition, the position (row number, column (A, B, C...)) And data format (formula) where TSV data included in the add-in format file is arranged on the spreadsheet are determined. For example, in the form format data DA6, the “order” Y1 is determined to be assigned to the cell having the row number “1” and the column number “1”. This information corresponds to what is shown as “rank” in the cell Y2 in the first column of the first row of the area indicating the header in the customizing form data DA5 in FIG. 14 is changed from “rank” to “ascending order”, the “rank” Y1 in FIG. 15 is edited to “ascending order”.

  The client device 15B-n of the second modification differs from the configuration of the client device 15-n of the embodiment (see FIG. 4) in that it has a storage area for storing edited custom form format data. This storage area is shown as a custom format storage area M4 in FIG.

FIG. 16 is a functional block diagram of the client device 15B-n according to the second modification.
The function of the client device 15B-n according to the modified example 2 differs from the function of the client device 15-n according to the embodiment (see FIG. 5) in the following points.

  The transmission / reception means 250B of the client device 15B-n further outputs a request for uploading custom form data to the communication I / F 155 (uploading means 450) as compared with the transmission / reception means 250 (see FIG. 5). Also, a request for downloading standard form data or custom form data is output to the communication I / F 155. When the standard form data or custom form data is received by the communication I / F 155, it is stored in the storage area M3 of the storage unit 154B (form data receiving means 451).

  Further, as compared with the selection unit 252, the selection unit 252B further outputs the selection screen data DA3 acquired by the transmission / reception unit 250 to the display unit 152, and accepts a request for uploading custom form data. When the user presses the selection button on the selection screen or the upload execution button, the custom form data is uploaded via the transmission / reception means 250.

  The selection unit 252B outputs the selection screen data DA3 acquired by the transmission / reception unit 250 to the display unit 152, and accepts download of standard or custom form data on the selection screen. When the user presses the selection button on the selection screen or the download execution button, standard or custom form data is downloaded via the transmission / reception means 250.

About the table calculation means 254, the structure (refer FIG. 12) shown in the modification 1 is assumed.
The spreadsheet unit 254 further develops the customized form data on the spreadsheet. Further, when closing (closing) the customized form data, the form data linked with the customized form data (that is, custom form format data) is stored in the custom format storage area of the storage unit 154B (save custom form format data) Means 452).

Next, the communication flow will be described.
17 and 18 are diagrams illustrating a communication flow between the server device and the client device 15B-n according to the second modification.
First, the flow of processing for uploading custom form format data in the client device 15B-n will be described.

FIG. 17 is a diagram illustrating a communication flow between the server apparatus 10 and the client apparatus 15B-n from the custom form format data creation process to the upload process.
This figure shows the flow after the activation of the main body execution means 254a of the spreadsheet software.

  First, the user designates a file to be opened to the main body processing means 254a (S70). Here, the customization form data DA5 in the storage unit 154B is designated.

  By this designation, the main body processing means 254a reads the customized form data DA5 and the form format data DA6 from the storage unit 154B (S71, S72), acquires the form format data DA6 by the custom data storage means 452, and customizes the form. The data DA5 is transferred to the user interface means UI side (S73).

  The user performs operations such as changing the data arrangement of the customized form data DA5, correcting the item name, and changing the layout on the screen by turning on the macro function of the spreadsheet software. This user operation is input from the user interface means UI to the edit accepting means 350 (S74), and the edit accepting means 350 updates the customizing form data DA5 based on the user operation (S75). The custom data storage 452 is linked to the update process and updates the form format data DA6 based on the update process (S76). Further, the edit accepting means 350 passes the updated information to the user interface means UI, whereby the screen is updated (S77).

  When the user finishes editing the customized form data DA5, the user performs a procedure for saving the edited data on the screen and ends the spreadsheet software. In the save procedure, the user designates a folder to be stored, a file name or extension of data to be saved, and the like. At this time, a predetermined folder for upload is designated. Further, the file name is the name included in the selection item on the form selection screen, that is, the name of the item to be selected when obtaining the actual data. For example, “sales list”. The extension is a spreadsheet extension indicating that a macro is included. For example, “.xlms” is assumed.

  In this saving procedure, the user interface means UI outputs a saving instruction to the custom data saving means 452 (S78). Then, the custom data storage unit 452 stores the edited form format data DA6 (that is, custom form format data) in the storage unit 154B (S79). Note that the customization form data DA5 is read-only, and the edited form data DA5 is not saved.

Next, the custom form format data is uploaded.
In the upload process, first, the user activates a browser, obtains a TOP screen from the server device by typing in an IP address or URL, etc., and then selects an upload button and presses an execute button. As a result, the form selection screen for upload is displayed on the display unit of the client device 15B-n. The upload form selection screen is obtained by omitting the “form output setup” g1 of the selection item g in the download form selection screen G1 (see FIG. 8).

The flow of this series of processing is substantially the same as the description of communication in the embodiment (step S1 to step S12 in FIG. 6). For this reason, further detailed explanation is omitted here.
Also in FIG. 17, the flow until obtaining the upload form selection screen is omitted, and the flow after obtaining is shown.

  In the flow shown in FIG. 17, the user first selects an item of data to be uploaded on the upload form selection screen. By this selection, the user interface means UI requests the upload means 450 to upload the data of the selection item (S80).

  The upload unit 450 causes the display screen of the file management system provided by the internal system to be output to the user interface unit UI (S81).

  The user selects and opens an upload folder from the display screen of the file management system, and selects custom form format data (for example, “sales list.xlms”). This user procedure is output as an instruction signal from the user interface means UI to the upload means 450 (S82).

  As a result, the upload unit 450 reads the custom form format data selected by the user from the storage unit 154B (S83, S84). Then, the transmission / reception means 250B transmits the custom form format data as upload data to the server device (S85).

  In the server device, the transmission / reception means 200 acquires the custom form format data and stores it in a predetermined folder (form form data folder) in the storage unit 101 (S86). If a file with the same file name exists, it is overwritten and updated.

Next, the flow of processing for downloading custom form format data in the client device 15B-n will be described.
In the second modification, the client device 15B-n downloads the form data together with the download of the record data from the server device.

  This form data download process has the same process as the actual data download process (see FIG. 7) of the client device 15-n shown in the embodiment. In the following, description of portions common to the processing shown in FIG. 7 will be omitted as appropriate, and different portions will be mainly described.

  FIG. 18 is a diagram showing a main flow of processing for downloading form format data in the client device 15B-n.

  This figure shows processing after acquisition of the extraction range designation screen G2 (see FIG. 9) after any of the items g is selected on the form selection screen G1 (see FIG. 8) and the execution button B1 is pressed. ing. That is, it shows the processing after steps S30 to S35 in FIG. Here, it is assumed that “sales list” g2 is selected as an example on the form selection screen G1.

  The user sets input fields m11 to m15 on the extraction range designation screen G2, and presses the execute button B2. Then, the transmission / reception means 250B acquires the data (extraction conditions) set in the input fields m11 to m14 and the password of the input field m15 (S36), and transmits them to the server device (S37).

  In the server device, the transmission / reception means 200 acquires such information (S37). Then, the transmission / reception means 200 performs a password authentication process. Then, the transmission / reception means 200 passes the search condition to the extraction means 201 and requests the extraction of sales performance data for the “sales list” (S38).

  Further, the transmitting / receiving means 200 reads out the form format data corresponding to the “sales list” (in this case, the updated custom form format data) from the form directory in the storage unit 101 (S38-1, S38-2), and transmits to the client device 15B-n (S38-3).

  When receiving the custom form format data, the transmission / reception means 250B of the client device 15B-n notifies the user interface means UI (S38-4). By this notification, the user interface means UI displays a storage screen of the file management system provided by the internal system on the display unit.

  On this save screen, the user designates a predetermined save destination folder and presses the save button. By this user operation, the custom form format data acquired by the transmission / reception means 250B is stored in a predetermined folder in the storage unit 154B (S38-5, S38-6).

  On the other hand, the extraction unit 201 of the server apparatus reads the SQL data DA2 from the storage unit 101 as shown as steps S39 and S40 in FIG. 7 after step S38. Since the subsequent processing is the same as that in FIG.

  Various programs used in the client device (or server device) of the present embodiment and the modification are files in an installable or executable format, such as a CD-ROM, a flexible disk (FD), a CD-R, and a DVD (Digital The program may be provided by being recorded on a computer-readable recording medium such as a Versatile Disk and read into a flash ROM of a client device (or server device).

  Further, the program may be provided by being stored on a computer connected to a network such as the Internet and downloaded via the network.

  As described above, the client device according to the present embodiment and the modified example transmits to the server device the request information for requesting download of the symbol-separated data obtained by separating the values included in the form with symbols and the format data of the form. Means, receiving means for receiving the format data and the symbol delimiter data as a response from the server device to the request information transmitted by the transmitting means, and the symbol delimiter data received by the receiving means as an add-in file Conversion means for format conversion, execution means for executing spreadsheet software, and when the add-in file is opened during execution of the spreadsheet software, the data included in the add-in file is in the format indicated by the format data. And add-in execution means for developing the spreadsheet.

  The server device also includes a first storage unit that stores the symbol delimiter data of the form, a second storage unit that stores setup information for the form output, and a request for downloading the setup information and the symbol delimiter data. Extracted by receiving means for receiving information, extracting means for extracting the symbol delimiter data stored in the first storage means, and the setup information and the extracting means stored in the second storage means Transmitting the received symbol delimited data to the request source, and the setup information includes the form format data, a conversion program for converting the symbol delimited data into an add-in file, and the spreadsheet software. If the add-in file is opened during execution, the data contained in the add-in file is formatted Includes add-in program to expand the spreadsheet in the format shown is over data, and is intended.

  As a result, the client device creates a form, thereby reducing the load on the server device side. In this case, since the load is not concentrated on the CPU of the server device, even if the server device provides another service, the service can be operated without any trouble.

  In the above embodiments and modifications, the configurations of the client device, the server device, and the program have been described. However, these embodiments and modifications are presented as examples, and are intended to limit the scope of the invention. Not done. The novel embodiments and modifications can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the spirit of the invention. These embodiments and modifications thereof are included in the scope and gist of the invention, and are included in the invention described in the claims and the equivalents thereof.

DESCRIPTION OF SYMBOLS 1 Form output system 10 Server apparatus 15-1, 15-2, ..., 15-N Client apparatus 19 Connection line 100 Control part 101 Storage part 102 Communication I / F
103 Bus DA1 Form format data DA2 SQL data DA3 Selection screen data DB Database E1, E2,..., EN Developer office F Data center P Software P1 Conversion program P2 Add-in program P3 Management program P4 Extraction program P5 Server program P6 Transmission / reception Program SET Setup program

JP 2002-373238 A

Claims (6)

Transmission means for transmitting request information for requesting download of symbol-separated data obtained by separating values included in the form with symbols and format data of the form to the server device;
Receiving means for receiving the format data and the symbol delimiter data as a response from the server device to the request information transmitted by the transmitting means;
Conversion means for converting the format of the symbol-delimited data received by the receiving means into an add-in file;
Execution means for executing spreadsheet software;
When the add-in file is opened during the execution of the spreadsheet software, add-in execution means for expanding the data included in the add-in file into a spreadsheet in a format indicated by the format data;
A client device comprising: Edit accepting means for accepting editing of data expanded in the spreadsheet;
Storage means for storing the data after being edited by the edit reception means in a file;
The client apparatus according to claim 1, further comprising: Custom data storage means for generating user-specific second format data as the format data by the user's editing operation and storing it in the storage unit;
Upload means for uploading the second format data stored by the custom data storage means to the server device;
Further comprising
The receiving means further receives the second format data.
The client device according to claim 1, wherein the client device is a device. A first storage means for storing the symbol-separated data of the form;
Second storage means for storing setup information for form output;
Receiving means for receiving download information of the setup information and the symbol delimited data;
Extraction means for extracting the symbol delimiter data stored in the first storage means;
Transmitting means for transmitting the setup information stored in the second storage means and the symbol delimiter data extracted by the extracting means to a request source;
With
The setup information is
Format data of the form;
A conversion program for converting the symbol-delimited data into an add-in file;
When the add-in file is opened during the execution of spreadsheet software, an add-in program that expands data included in the add-in file into a spreadsheet in a format indicated by the format data;
including,
The server apparatus characterized by the above-mentioned. Limiting means for limiting acquisition of the request source data;
The server device according to claim 4, further comprising: The computer that controls the client device
Transmission means for transmitting request information for requesting download of symbol-separated data obtained by separating values included in the form with symbols and format data of the form to the server device;
Receiving means for receiving the format data and the symbol delimiter data as a response from the server device to the request information transmitted by the transmitting means;
Conversion means for converting the format of the symbol-delimited data received by the receiving means into an add-in file;
Execution means for executing spreadsheet software;
When the add-in file is opened during the execution of the spreadsheet software, add-in execution means for expanding the data included in the add-in file into a spreadsheet in a format indicated by the format data;
Program to function as.

Images