JP2002222102A - Data transcription processing method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a data transcription processing method capable of easily changing contents of transcription without any change in a program dedicated for transcription processing and performing complicated transcription to a plurality of setting files without any change in the transcription processing program. SOLUTION: A transcription source file 1 includes transcription source data 3. A transcription destination file 2 includes transcription destination data 4. The setting file 5 stores information necessary for transcribing the transcription source data 3 to the transcription destination data 4. By the transcription processing program 6, inputting process 8 of a transcription source data 3 is carried out for reading the transcription source data 3, a reading process 7 for obtaining information necessary for transcription processing is carried out, a storage position of the transcription destination data 4 is set after performing necessary processing on the read data, and then, an output process 9 is carried out.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data transfer processing method, and more particularly, to a data transfer processing method for performing data arithmetic processing on a computer, including a transfer operation of a transfer place linked to a date and time.

[0002]

2. Description of the Related Art Generally, as a method of transferring data on a personal computer, data transfer is realized by creating a dedicated program specialized for the contents of the transfer.

FIG. 8 is a block diagram showing a conventional data transfer processing system.

A conventional data transfer processing method includes a transfer source file 11 including transfer source data 13 and a transfer destination data 14.
The input processing 18 for reading the transfer destination file 12 and the transfer source data 13 is performed, and after performing necessary processing on the read data, the storage position of the transfer destination data 14 is set and the output processing 19 is executed. Processing-only program 16
It is composed of

Next, the operation will be described.

The transfer source file 11 and the transfer destination file 12
Is created by arbitrary application software operating on a personal computer, and has transfer source data 13 and transfer destination data 14, respectively. Posting source data 1
In order to transfer 3 to the transfer destination data 14, the transfer processing dedicated program 16 sets the storage location of the transfer source data 13 in the transfer source file 11, executes the input process 18, and reads the transfer source data 13. After performing necessary processing on the read data, the storage location of the destination data 14 is set, and the output processing 19 is executed.

[0007]

In the conventional data transfer processing method described above, since the information for executing the transfer processing is incorporated in the program dedicated to the transfer processing, the contents of the transfer source file and the transfer destination file are stored. There is a drawback in that when it is changed, it is necessary to change the program exclusively for the posting process at the same time.

[0008] Further, when the transfer processing is described in a plurality of setting files, it is necessary to change a program dedicated to the transfer processing, and there is a drawback that a technician having specialized knowledge of program creation cannot quickly respond. .

An object of the present invention is to arrange information necessary for the transcription process in a setting file separated from the transcription processing program, and to read and process the information of the configuration file at the start of the transcription process, thereby executing the transcription processing program. To provide a data transfer processing method capable of easily changing the contents of the transfer processing without making a change, and realizing complicated transfer processing without changing the transfer processing program even when transferring to a plurality of setting files. It is in.

[0010]

The data transfer processing method according to the present invention is a processing for transferring data on a computer, which is used when executing processing including four arithmetic operations on the transferred data and moving the transfer place in accordance with the date. The transfer processing is performed by using a setting file storing information for the transfer processing.

A transfer source file including transfer source data; a transfer destination file including transfer destination data; a setting file storing information for performing a transfer process of transferring the transfer source data to the transfer destination data; After performing the input process of the transfer source data and reading the transfer source data, performing the read process for obtaining information for performing the transfer process from the setting file, performing the transfer process on the read data, A transfer processing program for setting a storage location of the transfer destination data and executing output processing.

In order to transfer the transfer source data to the transfer destination data, the transfer processing program executes the read processing for acquiring information for performing the transfer processing from the setting file. Based on the information read from the setting file, execute the input process to set the storage location of the transcription source data in the transcription source file, read the transcription source data, and read the read data After performing the transfer processing by the program, the storage location of the transfer destination data in the transfer destination file is set, and the output processing is executed to write the transfer destination data.

The transfer source spreadsheet of the transfer source file, the transfer destination spreadsheet of the transfer destination file, a group of setting files having a plurality of the setting files, a reference spreadsheet storing reference data, and the transfer processing program. , And are constructed on the spreadsheet application so that data can be smoothly transmitted and received.

Since the transfer processing program has a calculation function and performs a calculation process based on the information set in the setting file group, the data obtained from the transfer source spreadsheet and the data obtained from the reference spreadsheet are obtained. Data is calculated according to a calculation formula.

A storage device for mounting the transfer source file, the transfer destination file, and the setting file; an installed input processing program, an installed output processing program,
A data processing device that executes a transfer process by using a read process program and a transfer process program; and a storage medium that stores these programs, and is characterized in that the transfer process is performed.

Further, the data processing apparatus is provided with a program for executing an input process, an output process, a read process, and a transcription process.

[0017]

Next, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing one embodiment of a data transfer processing system according to the present invention.

In the embodiment shown in FIG. 1, a transfer source file 1 including transfer source data 3, a transfer destination file 2 including transfer destination data 4, and a transfer that transfers the transfer source data 3 to the transfer destination data 4 A setting file 5 for storing information necessary for performing the process, and a read process for executing the input process 8 of the transfer source data 3 to read the transfer source data 3 and acquire information necessary for performing the transfer process 7 is executed, and the read destination data 4
And a transfer processing program 6 for setting the storage position of the data and executing the output processing 9.

FIG. 2 is a system block diagram using the data transfer processing system of FIG.

Referring to FIG. 2, a storage device 6 for mounting a transfer source file 1, a transfer destination file 2, and a setting file 5
1, a data processing device 60 that executes processing by the installed input processing program 63, output processing program 64, read processing program 65, and transcription processing program 66, and a storage medium 62 storing these programs. Have been.

The input processing program 63, the output processing program 64, the read processing program 65, and the transcription processing program 66 execute the input processing 8, the output processing 9, and the reading processing 7 of FIG. Execute.

The data processing device is a CPU, RAM, RO
It is a personal computer including an M / I / O interface, and executes the operation of FIG. 1 by an input processing program 63, an output processing program 64, a read processing program 65, and a transcription processing program 66 loaded from a storage medium 62.

Hereinafter, the operation based on the configuration shown in FIG. 1 will be described.

Transfer source file 1 and transfer destination file 2
Is transcription source data 3 created by any application software operating on a personal computer.
And transfer destination data 4. In order to transfer the transfer source data 3 to the transfer destination data 4, the transfer processing program 6 executes a read processing 7 for acquiring information necessary for performing the transfer processing from the setting file 5. Based on the information read from the setting file 5 by the reading process 7,
An input process 8 for setting the storage location of the transcription source data 3 in the transcription source file 1 is executed, and the transcription source data 3 is read. The read data is subjected to necessary transcription processing by the transcription processing program 6, and then the storage location of the transcription destination data 4 in the transcription destination file 2 is set and the output processing 9 is executed.
The transfer destination data 4 is written.

FIG. 3 is a diagram showing the configuration of the spreadsheet application.

Referring to FIG. 3, the transfer source spreadsheet 21, the transfer destination spreadsheet 22, and the setting file group 25 are all formed by the same spreadsheet application 30 file so that data can be transferred smoothly. are doing.

The transcription processing program 26 also uses the macro function provided in the spreadsheet application 30, and uses the spreadsheet application 30
Build on top of.

The file of the spreadsheet application 30 stores data in a table format, and is composed of a plurality of columns and rows. Column numbers are represented in alphabetical order, such as "A" for the first column and "B" for the second column, and row numbers are "1" for the first row, "2" for the second row, and so on. Line numbers are shown in numerical order.

Therefore, for example, "A1" representing the data position
Indicates the data position arranged in the first row of the first column, and various transcription processes can be performed according to the contents of the information of the setting file group 25.

FIG. 4 is a diagram showing an example of the setting of the transcription process.

Referring to FIG. 4, the transfer process is performed in accordance with the contents described by the process line 40. By describing a plurality of lines, a plurality of transfer processes can be described. Further, by arranging a plurality of setting files, it is possible to describe a more complicated transcription process.

FIG. 5 is a diagram showing the positional relationship between the files arranged according to the settings shown in FIG. 4 and the flow of the transfer data.

Next, the operation of this embodiment will be described in more detail with reference to FIG. 1, FIG. 3, FIG. 4, and FIG.

In this example, a plurality of transfer source spreadsheets 21 are arranged for each month, and the file name is “aaa.xls” as indicated by the transfer source file name 33. In the plurality of transfer source spreadsheets 21, the transfer source data 23 has the same position (in this example, "A" as indicated by the transfer source cell 37).
1)).

As shown in FIG. 5, "100" is set as the transfer source data 23 in the transfer source spread sheet 21 for April.
However, “120” is stored as the transfer source data 23 in the transfer source spreadsheet 21 for May. Optional data 3 in the destination spreadsheet 22
With the option of “Year horizontal automatic” specified in No. 9, the April data is set to the position “B1” and the May data is set to the position “C1” starting from “B1” shown in the destination cell 38. Post in monthly order. Posting spreadsheet 22
Is designated by "bbb.xls" as indicated by the transfer destination file name 36.

The transcription operation will be described in detail below, taking the case of April as an example.

At the beginning of the month, after the transcription source data 23 is written in the transcription source spreadsheet 21, the transcription source spreadsheet 21 is arranged at a predetermined position for April.

Here, the transfer processing program 26 performs the following processing based on the information set in the setting file group 25 in order to set the file storage position information of the arranged transfer source spreadsheet 21.

First, from the transfer source file reference position 31,
Refer to “c: {data}”. By specifying "Month Auto" in the transfer source file offset 32,
A character string “April” representing this month is generated. By referring to “aaa.xls” from the transfer source file name 33, the file position information “c: \ data \ April \ aaa.xls” of the transfer source spreadsheet 21 to be read in April is obtained.
The data “100” at the position “A1” is read from the transfer source cell 37.

The transfer processing program 26 for setting the file storage position information of the transfer destination spreadsheet 22 includes:
The following processing is performed based on the information set in the setting file group 25.

First, from the destination file reference position 34,
Refer to “c: {data}”. "No designation" is referred from the transfer destination file offset 35. Since it is "unspecified", no special character creation processing is performed. After referring to "bbb.xls" from the destination file name 36 and obtaining the file position information "c: \ data \ bbb.xls" of the destination spreadsheet 22 to be written, the destination cell 38 "B1" is used as a reference. Then, a write position suitable for the April data is determined by the optional function 39 “Yearly Horizontal Automatic”, and the data “100” is written.

Here, the function of "yearly horizontal automatic" of the optional function 39 is a function for correcting the data writing position according to the current month, and moves rightward by (current month-April) to write data. Years begin in April, May, June, 7
Month: 12 months of March. In the present function, when the current month is April, the current month (4) −4 = 0, so the data write position is “B1” itself of the transfer destination cell 38. If the current month is May, the current month (5) -4 =
1 and the data write position is "B" of the transfer destination cell 38.
"C1" is obtained by shifting "1" to the right by one. As a result, 5
“120” is written as the monthly transfer source data 23.

FIG. 6 is a diagram showing an example of a setting file group having a calculation function.

This embodiment is also an embodiment constructed on the spreadsheet application 30 shown in FIG. 3, and transcribes a calculation result of obtaining a monthly usage fee from a monthly usage amount and a unit price.

FIG. 7 is a diagram showing the positional relationship between the files arranged according to the settings shown in FIG. 6 and the flow of the transfer data.

Next, the operation of this embodiment will be described in more detail with reference to FIG. 3, FIG. 6, and FIG.

In this example, a plurality of transfer source spreadsheets 21 are arranged for each month, and the file name is “aaa.xls” as indicated by the transfer source file name 43. In the plurality of transfer source spreadsheets 21, the transfer source data 23 is arranged at the same position (in this example, “A1” as indicated by the transfer source cell 51), and usage data used every month is arranged. The transfer source spreadsheet 21 for April has “100” as the transfer source data 23, and the transfer source spreadsheet 21 for May has “12” as the transfer source data 23.
"0" is stored.

A reference spreadsheet 21 a storing unit price data is arranged, and the file name is “ccc.xls” as indicated by a reference file name 49. Reference spreadsheet 21a has reference data 23a.
Is stored as “1.5”. The result of the calculation based on the calculation formula (element × reference) specified by the calculation formula 54 is calculated based on “B1” indicated in the destination cell 52 by the “yearly vertical automatic” option specified in the option function 53. In April, the data for April is located at position “B1”, and for May the data is located in position “B”.
Posting destination spreadsheet 22 in monthly order like "2"
Post to

The file name is “bbb.xls” as indicated by the transfer destination file name 46.

Hereinafter, the transcription operation will be described in detail taking the case of April as an example.

At the beginning of the month, after the transfer source data 23 is written in the transfer source spread sheet 21, the transfer source spread sheet 21 is arranged at a predetermined position for April. In this example, a transfer processing program 26 for setting file storage position information of the arranged transfer source spreadsheet 21 is set.
Performs the following processing based on the information set in the setting file group 25.

First, from the transfer source file reference position 41,
Refer to “c: {data}”. By specifying "Month Auto" in the transfer source file offset 42,
A character string “April” representing this month is generated. With reference to "aaa.xls" from the transfer source file name 43, the file position information "c: \ data \ April \ aaa.xls" of the transfer source spreadsheet 21 to be read in April is obtained, and the transfer source cell 51 is obtained. Then, the data “100” at the position “A1” is read, and the usage amount for April is acquired.

The transfer processing program 26 for setting the file storage position information of the reference spreadsheet 21a to obtain the unit price performs the following processing based on the information set in the setting file group 25.

First, from the reference file reference position 47,
Refer to “c: {data}”. "Unspecified" is referred from the reference file offset 48. Since it is "unspecified", no special character string is generated. Reference file name 4
9, the reference spreadsheet 21a to read “ccc.xls” and file position information “c: @da”
ta @ ccc. After obtaining “xls”, the data “1.5” at the position “D1” is read from the reference cell 55.

The transfer processing program 26 performs the following processing based on the information set in the setting file group 25 to perform the calculation processing. “Gen × San” specified in calculation formula 54
The transfer processing program 26 executes the calculation of 100 × 1.5 = 150 according to the calculation formula of “4.
Get. In the above formula, “source” indicates data “100” obtained from the transfer source spreadsheet 21, and “reference” indicates data “1.5” obtained from the reference spreadsheet 21 a.
Represents

A posting processing program 26 for storing the April usage fee obtained above in the destination spreadsheet 22
Performs the following processing based on the information set in the setting file group 25. First, from the destination file reference position 44,
Refer to “c: {data}”. "No designation" is referred from the transfer destination file offset 45. Since "unspecified", no special character creation processing is performed. With reference to “bbb.xls” from the transfer destination file name 46, file position information “c:
\ Data \ bbb. xls ", and the destination cell 5
Based on “B1” of No. 2 as a reference, the writing position appropriate for the April data is determined by the “yearly vertical automatic” of the optional function 53, and the above calculation result “150” is written.

The "yearly vertical automatic" function of the optional function 53 is a function for correcting the data writing position according to the current month.
(Current month-April) Move down by the amount to write data. The year begins in April, May, June, July, ...
It consists of 12 months of March.

In the present function, when the current month is April, since the current month is (4) -4 = 0, the data write position is "B1" itself of the transfer destination cell 52. On the other hand, if the current month is May, the current month (5) −4 = 1, and the data writing position is “B1”, which is “B1” of the transfer destination cell 52 shifted downward by one
2 ". As a result, 1
20 × 1.5 = 180 calculation results are written.

As described above, in the process of transcribing data on the computer, the setting for storing the information necessary for the transcribing process at the time of executing the process including the four arithmetic operations of the transcribing data and the process of moving the transcribing location linked to the date. Since the transfer processing is performed using a file, the contents of the transfer processing can be changed without changing the transfer processing program, and complicated transfer processing can be performed by providing a plurality of setting files.

[0061]

As described above, according to the data transfer processing method of the present invention, information necessary for the transfer processing is separated from the transfer processing program and placed in the setting file, and the information of the setting file is read at the start of the transfer processing. Since the processing can be performed, there is an effect that the contents of the transfer processing can be easily changed without changing the transfer processing program.

Further, since the transfer processing can be described in a plurality of setting files, there is an effect that a complicated transfer processing can be realized without changing the transfer processing program.

[Brief description of the drawings]

FIG. 1 is a block diagram showing one embodiment of a data transfer processing method according to the present invention.

FIG. 2 is a system block diagram using the data transfer processing method of FIG. 1;

FIG. 3 is a diagram illustrating a configuration of a spreadsheet application.

FIG. 4 is a diagram illustrating an example of a transfer process setting.

FIG. 5 is a diagram showing a positional relationship between files arranged according to the settings shown in FIG. 4 and a flow of transcription data.

FIG. 6 is a diagram showing an example of a setting file group having a calculation function.

FIG. 7 is a diagram showing a positional relationship between files arranged according to the settings shown in FIG. 6 and a flow of transcription data.

FIG. 8 is a block diagram showing a conventional data transfer processing method.

[Explanation of symbols]

 1 transfer source file 2 transfer destination file 3 transfer source data 4 transfer destination data 5 setting file 6 transfer processing program 7 read processing 8 input processing 9 output processing 11 transfer source file 12 transfer destination file 13 transfer source data 14 transfer destination data 16 transfer Dedicated processing program 18 Input processing 19 Output processing 21 Transcription source spreadsheet 21a Reference spreadsheet 22 Transcription destination spreadsheet 23 Transcription source data 23a Reference data 25 Setting file group 26 Transcription processing program 30 Spreadsheet application 31 Transcription source file reference position 32 Transcription Source File Offset 33 Source File Name 34 Destination File Reference Position 35 Destination File Offset 36 Destination File Name 37 Source Cell 38 Destination Cell 39 Optional Functions 0 Processing line 41 Transfer source file reference position 42 Transfer source file offset 43 Transfer source file name 44 Transfer destination file reference position 45 Transfer destination file offset 46 Transfer destination file name 47 Reference file reference position 48 Reference file offset 49 Reference file name 51 Transfer Source cell 52 Destination cell 53 Optional function 54 Calculation formula 55 Reference cell 60 Data processing device 61 Storage device 62 Storage medium 63 Input processing program 64 Output processing program 65 Reading processing program 66 Transcription processing program

Claims (7)

[Claims] In a process of transferring data on a computer, a setting file storing information for the transfer process is used at the time of executing a process including four arithmetic operations on the transfer data and a process of moving a transfer location linked to a date. A data transfer processing method characterized in that transfer processing is performed. 2. A transfer source file including transfer source data;
A transfer destination file including the transfer destination data; a setting file for storing information for performing a transfer process of transferring the transfer source data to the transfer destination data; and executing the input process of the transfer source data and executing the transfer source data. After performing read processing for obtaining information for performing the transcription processing from the setting file, performing transcription processing on the read data, setting a storage location of the transcription destination data, and performing output processing. And a transfer processing program for executing a data transfer processing method. 3. In order to transfer the transfer source data to the transfer destination data, the transfer processing program executes the read processing for acquiring information for performing the transfer processing from the setting file, and performs the read processing. Based on the information read from the setting file, by executing the input process of setting the storage location of the transcription source data in the transcription source file to read the transcription source data, the read data is the After performing a transfer process by a transfer process program, a storage location of the transfer destination data in the transfer destination file is set, and the output process is executed to write the transfer destination data. 3. Data transfer processing method described in 3. 4. A transfer source spreadsheet included in the transfer source file, a transfer destination spreadsheet included in the transfer destination file, a set file group including a plurality of the setting files, a reference spreadsheet storing reference data, and the transfer process. 3. The program according to claim 2, wherein the program is created in the same spreadsheet application file, and is constructed on the spreadsheet application so that data can be exchanged smoothly.
Or the data transfer processing method according to claim 3. 5. The transfer processing program has a calculation function, and performs a calculation process based on information set in the setting file group, so that the data obtained from the transfer source spreadsheet and the reference spreadsheet are used. 5. The data transfer processing method according to claim 2, wherein the acquired data is calculated according to a calculation formula. 6. A storage device for mounting the transfer source file, the transfer destination file, and the setting file; an installed input processing program, an installed output processing program,
A data processing device that executes a transcription process by a read processing program and a transcription processing program; and a storage medium that stores these programs; and performs the process according to any one of claims 2 to 5. A data transfer processing method characterized by the following. 7. A data transfer processing method comprising a program for causing a data processing device to execute an input process, an output process, a read process, and a transfer process.