JP2004021551A - System, method, program, and recording medium for file conversion - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an automatic file conversion system and method in which XML data is efficiently converted into a fixed-length file without program development by a programmer each time. <P>SOLUTION: The file conversion system and method comprises a file specification means which specifies at least 1 or more files to be converted at one time, a conversion format specification means which designates a conversion format when data of the files to be converted is stored in an output file, and a conversion means which sequentially reads the plurality of the files to be converted, converts the data based on the conversion format specification means, and then generates one output file. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to file conversion, and more particularly, to generating one output file by combining a plurality of files.
[0002]
[Prior art]
In recent years, electronic forms have been used as alternatives to conventional paper forms. The electronic form is electronic data that electronically forms an application form, an application form, and various other forms, and can be configured as, for example, XML (extensible Markup Language) data.
[0003]
XML includes a plurality of data, each of which designates a start end and an end by a predetermined identification symbol, and can describe various data structures. However, an existing system (for example, a customer management system or an application Reception system, etc.) have the following problems.
[0004]
In other words, existing systems operating on a mainframe often input data of fixed-length files, and in order to use XML data generated by an electronic form system in such an existing system, it is necessary to provide individual data for each application. It is necessary to perform a complicated and time-consuming operation of capturing each of a plurality of XML data into a RDBMS (Relational Database Management System) having a function of converting XML data and generating a fixed-length file using the RDBMS function. There is a problem.
[0005]
Furthermore, the process of importing the XML data into the RDBMS is performed by using a general-purpose development tool, for example, by creating a program according to the type of the XML data such as “application form for life insurance” and “application form for a public institution”. There is also a problem that it can be developed only by programmers who have programming skills.
[0006]
[Problems to be solved by the invention]
SUMMARY OF THE INVENTION The present invention has been made to solve the above problems, and an object of the present invention is to provide an automatic file conversion system that efficiently converts XML data into fixed-length files without the need for a programmer to develop programs each time. It is to provide a conversion system and method.
[0007]
[Means for Solving the Problems]
A first aspect of the present invention is a system for converting a computer-readable file into a file of a different format used by a different computer system, wherein at least one or more conversion source files can be collectively specified. A conversion format instructing unit for instructing a conversion format when each data of the conversion source file is stored in an output file; and sequentially converting the plurality of conversion source files to perform data conversion based on the conversion format instructing unit. And a conversion unit for generating one output file.
[0008]
According to a second aspect of the present invention, in the file conversion system according to the first aspect described above, a plurality of data and / or data each indicating a start end and an end by a predetermined identification symbol in the conversion source file. Attributes are provided.
[0009]
According to a third aspect of the present invention, in the file conversion system according to the first or second aspect, one data in the conversion source file is designated by the conversion format designating means, and the data in one record of the output file is designated. Conversion information for specifying a conversion format and fixed insertion character information for designating a character to be inserted at a fixed position to fix one record of the output file to a predetermined length or to separate items are provided. .
[0010]
According to a fourth aspect of the present invention, in the file conversion system according to the first to third aspects, the conversion information is provided with a description of a predetermined identification symbol indicating each of the data in the conversion source file. Things.
[0011]
According to a fifth aspect of the present invention, in the file conversion system according to the first to fourth aspects, the conversion information includes a list of the predetermined identification symbols indicating a nested structure of a plurality of data in the conversion source file. Is provided.
[0012]
According to a sixth aspect of the present invention, in the file conversion system according to the first to fifth aspects, the conversion information includes a data length occupied by the data of the conversion source file in the output file, and a data length of the conversion source file. When the data is shorter than the data length, the padding character for satisfying the data length by adding to the data, and whether the data of the conversion source file is stored left or right in the output file. This is provided with a filling direction designation.
[0013]
According to a seventh aspect of the present invention, in the file conversion system according to the first to sixth aspects described above, the conversion format instructing means transmits conversion information or fixed insertion character information relating to one data in the conversion file to one record. It is configured by a text-format parameter file described for each.
[0014]
An eighth aspect of the present invention is a method of converting a computer readable file into a file of a different format used by a different computer system, wherein a step of specifying conversions for a plurality of conversion source files at once is provided, Instructing a conversion format when storing in the output file of each data item in the original file, sequentially reading the plurality of conversion source files, and performing data conversion based on the instructed conversion format, Generating one output file based on the conversion format from all of the plurality of conversion source files.
[0015]
According to a ninth aspect of the present invention, there is provided a program for operating a computer as the file conversion system according to the first to seventh aspects.
[0016]
According to a tenth aspect of the present invention, a program for causing a computer to operate as the above-described first to seventh file conversion systems is provided by being recorded on a computer-readable recording medium. .
[0017]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, the present invention will be described based on an illustrated embodiment.
FIG. 1 is a schematic configuration diagram of a file conversion system 1 according to an embodiment of the present invention.
[0018]
The file conversion system 1 is actually a computer system, and from a hardware point of view, a CPU that performs calculations, a recording device for recording information (such as a magnetic disk or an optical disk), and an input that gives instructions to the computer. It comprises a device (keyboard, mouse, etc.), a display device such as a CRT for displaying the results, a printer for printing electronic forms, etc., and a communication device for exchanging data with other systems.
[0019]
The file conversion system 1 converts the XML data 2 that is the conversion source file into the fixed-length file 3 that is the output file from the viewpoint of software. And conversion means 6.
[0020]
The XML data 2 is a file describing a data structure by designating each data at a start end and a tail end by a predetermined identification symbol. FIG. 2 shows an example of an examination ticket as an example of the content of the XML data 2.
[0021]
FIG. 2 shows “test year”, “test name”, “test date and time”, and “character name” for each character string called a tag surrounded by two identification symbols of a start part “<>” and a terminal part “<//>”. It shows that the data of “test card” is composed of the five data of “test hall” and “examinee”.
[0022]
FIG. 2 shows that the data “examinee” is composed of two data “name” and “date of birth”, and “name” is “name” and “name”, and “date of birth”. Also indicates that it is composed of a nested structure of a plurality of data of "era", "year", "month", and "day".
[0023]
As shown in FIG. 3, the fixed-length file 3 is a file in which the storage position of each data in the record, the length to be used (the number of digits), and the length of one record are determined. It can be processed by existing systems that operate on frames and the like. A form in which each data item is distinguished by a character symbol such as a comma is also possible.
[0024]
The file designating means 4 designates a plurality of pieces of XML data 2 collectively. In practice, the file designating means 4 stores a predetermined folder of a file system managed by an OS (Operating System) of a computer that realizes the file conversion system 1. In this example, a plurality of pieces of XML data 2 are recorded.
[0025]
The conversion format designating means 5 is a text format parameter file in which each record (line) is composed of the conversion information 7 or the fixed insertion character information 8. FIG. 4 shows an embodiment of the conversion format instruction means 5.
[0026]
The conversion information 7 describes a conversion method for the specific data of the XML data 2 and specifies the target data in the XML data 2 and the length, the padding character, the padding direction, and the like of the data in the fixed length file 3. Things.
[0027]
In FIG. 4, for example, the description of the conversion information 7 of “<Mr.>;<Name>;<Examinee>;<Examinationticket> =” on the fifth line is the “Examination test” in the XML data 2 describing the “Examination ticket”. This is a conversion format for “name” of “name” of “person” data.
[0028]
The description of the conversion information 7 of “<address>;<examinee>;<examinationticket> =” on the seventh line is described in “<field_name” of the “examinee” data of the XML data 2 describing the “examination ticket”. > = ”, Indicating that the actual target data is“ Tokyo ”enclosed by“ <value> ”tags in the“ <field_name> ”tag.
[0029]
Further, for example, in the description of the conversion information 7 relating to “month” on the tenth line, “2,“ 0 ”, R” to the right of “=” indicates that “2” is two digits long. When "0" is a single-digit month, it indicates that "0 (zero)" is padded before, such as "01", and "R" indicates that data is stored right-justified. Is shown.
[0030]
As described above, the conversion information 7 describes specific data in the XML data 2 in the order of nested tags, such as “<Mr>;<Name>;<Examinee>;<Examinationticket>”. However, when a tag can be uniquely determined in the XML data 2 such as “era”, the enumeration of the nested structure of the tag can be omitted.
[0031]
Of course, if it is not necessary to specify whether the data is to be stored in a packed character or to the left or right due to the same length in the XML data 2 and the fixed-length file 3, the corresponding information is omitted. May be.
[0032]
The fixed insertion character information 8 specifies a character to be fixedly inserted at a specific position, for example, when the length of the record (line) is fixed or when items are separated by commas. The fixed insertion character information 8 is designated by "<<" and ">>" in FIG. 4 in order to distinguish it from normal data items.
[0033]
In the twelfth line in FIG. 4, the effective record length of the fixed-length file 3 is 80 bytes by inserting ““ ”(blank) for four characters by“ << Filer >> = 4, “”. Is shown.
[0034]
Further, “<< delimit >>> = <CR><LF>” on the thirteenth line indicates that a character code “<CR><LF>” for a line feed is inserted at the end of the record.
[0035]
The fixed insertion character information 8 is not limited to the description after the conversion information 7 such as the record length adjustment and the line feed character code. The description in the line may specify that a character code is inserted at a specific position in the fixed-length file 3. Of course, if it is not necessary to insert a fixed character, it is possible to omit it.
[0036]
The conversion unit 6 sequentially reads the plurality of XML data 2 specified by the file specification unit 4, sequentially converts the XML data 2 into the fixed-length file 3 based on the conversion format specifying unit 5, and finally converts one A long file 3 is generated.
[0037]
Next, the operation of the file conversion system 1 of the present invention will be described in detail with reference to FIG.
[0038]
The conversion unit 6 reads one piece of XML data 2 from the plurality of pieces of XML data 2 recorded by the file designating unit 4 in accordance with, for example, the order of file names.
[0039]
Next, the conversion means 6 converts the XML data 2 into the fixed-length file 3 by reading the conversion format instruction means 5 prepared in advance by editor software or word processing software and processing the XML data 2 in order from the first line.
[0040]
In the actual conversion process, first, according to the conversion information 7, while following the data structure of the XML data 2, the specified tag is searched for and the target data is specified.
[0041]
For example, in the conversion information 7 shown in the first line of FIG. 4, the tag "<test year>;<examinationticket>" is specified, so the XML data 2 in FIG. The tags are traced in the order of “<test year>” in the second line from “<test card>”, and “test year” is specified as target data.
[0042]
Also, in the conversion information 7 shown in the seventh line in FIG. 4, the tag “<address>;<examinee>;<examinationticket>” is specified, but the XML data in FIG. There is no tag. In this case, “address” is described in the field_name attribute of the tag, that is, the target data is specified by the description “<field_name =“ address ”>”.
[0043]
Next, the conversion means 6 secures a data area for the length specified by the conversion information 7, and transfers the specified data value to the output buffer area right or left justified in accordance with the instruction of the packing direction. . At this time, if the target data is less than the specified length, the character specified by the padding character is added.
[0044]
When the target data is specified by the attribute, such as the field_name attribute, the value of the data specified by the “<value>” tag included in the attribute tag is used. In the case of the XML data 2 in FIG. 2, "Tokyo" is the actual data.
[0045]
If the tag specified by the fixed insertion character information 8 or the conversion information 7 does not exist in the XML data 2, the data area of the specified length is filled with the character specified by the padding character.
[0046]
The above-described specification of the data and the transfer to the output buffer area are repeated for all the rows of the conversion format designating means 5.
[0047]
After the conversion format instructing means 5 completes the processing for all the rows, the output buffer area is written as one record of the fixed length file 3.
[0048]
For all the XML data 2 designated by the file designating unit 4, by reading from the conversion format designating unit 5 and writing it out to the fixed-length file 3 in the output buffer area, for example, the file designating unit 4 converts the XML of 10 files into XML. When data 2 is specified, a fixed-length file 3 having 10 records is generated.
[0049]
As described above, the present invention has been described in detail based on the embodiments. However, the file conversion system according to the present invention is not limited to the above-described embodiments at all, and various modifications may be made without departing from the spirit of the present invention. It is a matter of course that the change of is possible.
[0050]
【The invention's effect】
As described above, according to the file conversion system of the present invention, it is possible to efficiently convert a plurality of conversion source XML data into fixed-length files without going through an RDBMS.
[0051]
Also, by preparing a parameter file by the conversion format designating means, it is possible to convert XML data into a fixed-length file without developing a program for each XML data.
[Brief description of the drawings]
FIG. 1 is a configuration diagram showing an embodiment of the present invention.
FIG. 2 is an explanatory diagram of XML data of the present invention.
FIG. 3 is an explanatory diagram of a fixed-length file according to the present invention.
FIG. 4 is an explanatory diagram of a conversion format instruction unit according to the present invention.
FIG. 5 is a flowchart showing the operation of the embodiment of the present invention.
[Explanation of symbols]
1 file conversion system 2 XML data 3 fixed length file 4 file designation means 5 conversion format instruction means 6 conversion means 7 conversion information 8 fixed insertion character information

Claims (10)

A system for converting a computer readable file into a different format for use by different computer systems,
File designation means for collectively specifying at least one or more conversion source files, and conversion format instructing means for indicating a conversion format when storing each data of the conversion source file in an output file;
A conversion unit that sequentially reads the plurality of conversion source files, performs data conversion based on the conversion format instruction unit, and generates one output file;
A file conversion system comprising: The file conversion system according to claim 1, wherein
The conversion source file is
A plurality of data and / or data attributes each indicating a start end and an end by a predetermined identification symbol;
A file conversion system comprising: The file conversion system according to claim 1 or 2,
The conversion format instruction means,
Conversion information specifying one data in the conversion source file and specifying a conversion format of the data in one record of the output file;
Fixed insertion character information indicating a character to be inserted at a fixed location to make one record of the output file constant at a predetermined length or to separate items;
A file conversion system comprising: The file conversion system according to any one of claims 1 to 3,
The conversion information,
Description of a predetermined identification symbol indicating each of the data in the conversion source file,
A file conversion system comprising: The file conversion system according to any one of claims 1 to 4,
The conversion information,
A description of the list of the predetermined identification symbols, showing a nested structure of a plurality of data in the conversion source file,
A file conversion system comprising: The file conversion system according to any one of claims 1 to 5,
The conversion information,
The data length of the conversion source file in the output file,
When the data of the conversion source file is shorter than the data length, a padding character for satisfying the data length by adding to the data,
In the output file, the data of the conversion source file in the output file is specified to be packed left or right;
A file conversion system comprising: The file conversion system according to any one of claims 1 to 6,
The conversion format instruction means,
It is a text-format parameter file in which conversion information or fixed insertion character information relating to one data in the conversion file is described for each record.
A file conversion system, characterized in that: A method of converting a computer readable file into a different format for use by different computer systems,
A step of collectively specifying conversions for at least one or more source files;
Indicating a conversion format when storing in the output file of each data item in the conversion source file,
Reading the plurality of conversion source files sequentially;
Performing data conversion based on the instructed conversion format;
Generating an output file based on the conversion format from all of the plurality of conversion source files;
A file conversion method characterized by comprising: A program that causes a computer to function as the file conversion system according to claim 1. A computer-readable medium storing a program that causes a computer to function as the file conversion system according to claim 1.

Images