JP5420317B2 - Conversion parameter generation system and conversion program - Google Patents

Description

  The present invention relates to a conversion parameter generation system and a conversion program for generating conversion parameter information for converting data created based on a preset data format into another data format. Conversion parameters that can easily generate conversion parameter information for converting XML format data into CSV format data in EDI (Electronic Data Interchange) for standardized formatting and electronic exchange between companies The present invention relates to a generation system and the conversion program.

  In inter-enterprise electronic commerce such as EDI, the data format used in communication is often standardized, but the data used in the enterprise is often unique, and for example, the JCA procedure ( Standard communication control procedure for customer data exchange defined by Japan Chain Store Association), ebXML procedure (international standard specification for business-to-business electronic commerce utilizing XML), JX procedure (message exchange procedure for EDI between companies) (Based on guidelines established based on the international standard [SOAP-RPC]), distribution business message standard (distribution BMS) Ver1.0, distribution BMSVer1. 1. Set up the distribution BMS Ver1.0 to meet the business practices and transactions unique to fresh foods. Distribution BMS fresh Ver was. 1.0, and the data format includes four types of CSV / XML / fixed length / distributed BMS, but is not limited thereto.

  In this way, the EDI system, which is an information exchange computer system for exchanging commercial transaction information, often has different data exchange procedures (communication protocols) and business messages to be used (ordering, payment, etc.) for each company. It is known that there are many cases where messages are exchanged via a relay center called an EDI center rather than a method in which companies directly exchange messages.

  The EDI center according to the prior art includes a data format conversion system for converting the commercial transaction information of the different data formats described above into a data format handled by each company. References describing such data format conversion systems include the following: Patent document 1 is mentioned. This Patent Document 1 describes a technique in which conversion parameters for converting fixed-length data into variable-length data are prepared as layout parameters, and data format conversion is performed using the layout parameters.

Japanese Patent Laid-Open No. 11-296510

  Although the above-described conventional data conversion technology can perform conversion rules when performing data conversion using conversion parameters called layout parameters, it is assumed that these conversion parameters are prepared. Had to be created according to various data conversion rules. In particular, data conversion in the EDI system has a problem in that there are various combinations of data types handled by various companies, and various data conversion parameters must be created in accordance with these types of combinations.

  An object of the present invention is to eliminate the problems caused by the prior art described above, and to provide a conversion parameter generation system and a conversion parameter generation program that can easily generate conversion parameters.

In order to achieve the above object, the present invention surrounds CSV data in which a plurality of data is stored using a delimiter identifier in order of item number values corresponding to predetermined item name information, and a tag corresponding to the item name information. A conversion parameter generation system for generating, with a computer, conversion parameter information for performing data conversion between the CSV data and the markup language data.
A markup language definition information table memory storing markup language definition information indicating the correspondence between the markup language format tag and item name information;
A CSV definition information table memory storing CSV definition information indicating correspondence between item number values in CSV format and item name information;
A conversion parameter information table memory for storing the conversion parameter information;
Markup language data analysis work table memory for storing markup language data analysis result information obtained by analyzing markup language data;
A CSV data analysis work table memory for storing CSV data analysis result information obtained by analyzing CSV data;
The computer is
A first step of inputting markup language data describing predetermined information based on markup language definition information and CSV data describing the predetermined information based on CSV definition information;
A tag and data included in the markup language data input in the first step are extracted, item name information corresponding to the extracted tag is extracted from the markup language definition information table memory, and the tag and item name information are extracted. A second step of storing the corresponding information in the markup language data analysis work table memory;
The data included in the CSV data input in the first step and the item number value which is the order in which the data appears are extracted, and the item number value is supported from the CSV definition information table memory based on the extracted item number value A third step of extracting item name information to be stored, and storing correspondence information between the extracted item number value and item name information in a CSV data analysis work table memory;
Correspondence information between the tag and item name information stored in the markup language data analysis work table memory in the second step and correspondence between the item number value and item name information stored in the CSV data analysis work table memory in the third step Based on the information, the first feature is to execute a fourth step of extracting the correspondence between the item number value of the CSV data and the tag of the markup language data as the conversion parameter information.

  According to the present invention, in the conversion parameter generation system having the first feature, the computer uses the same item name as the item name information stored in the markup language data analysis work table memory in the second step in the fourth step. A second feature is to include a step of extracting an item number value corresponding to the information from the CSV data analysis work table memory and setting the correspondence between the extracted item number value and item name information as the conversion parameter information.

In the conversion parameter generation system according to the first or second feature of the present invention, the markup language definition information includes a data type indicating a data format corresponding to the item name information and a digit indicating the number of digits of the data. The CSV definition information includes a data type indicating the data format corresponding to the item name information and the number of digits indicating the number of digits of the data;
The computer is
In the second step, the item name information corresponding to the tag is retrieved from the markup language definition information table memory based on the tag extracted from the markup language data and the data type and the number of data digits of the data surrounded by the tag. Extract and
The item name corresponding to the item number value from the CSV definition information table memory based on the item number value extracted from the CSV data and the data type and the number of data digits set in the item number value in the third step The third feature is to extract information.

Further, the present invention stores CSV data in which a plurality of data is stored in a comma-separated order in the order of item number values corresponding to predetermined item name information, and a plurality of data surrounded by tags corresponding to the item name information. A conversion parameter generation system for generating conversion parameter information for performing data conversion between the CSV data and the XML data, using XML data as an input,
An XML definition information table memory storing XML definition information indicating correspondence between XML format tags and item name information;
A CSV definition information table memory storing CSV definition information indicating correspondence between item number values in CSV format and item name information;
A conversion parameter information table memory for storing the conversion parameter information;
XML data analysis work table memory for storing XML data analysis result information obtained by analyzing XML data;
A CSV data analysis work table memory for storing CSV data analysis result information obtained by analyzing CSV data;
The computer is
A first step of inputting XML data describing predetermined information based on XML definition information and CSV data describing the predetermined information based on CSV definition information;
Tag and data included in the XML data input in the first step are extracted, item name information corresponding to the extracted tag is extracted from the XML definition information table memory, and correspondence information between the tag and item name information A second step of storing the data in the XML data analysis work table memory;
The data included in the CSV data input in the first step and the item number value which is the order in which the data appears are extracted, and the item number value is supported from the CSV definition information table memory based on the extracted item number value A third step of extracting item name information to be stored, and storing correspondence information between the extracted item number value and item name information in a CSV data analysis work table memory;
Correspondence information between the tag and item name information stored in the XML data analysis work table memory in the second step and correspondence information between the item number value and item name information stored in the CSV data analysis work table memory in the third step. Based on this, the fourth feature is that a fourth step of extracting the correspondence between the item number value of the CSV data and the tag of the XML data as the conversion parameter information is performed.

  According to the present invention, in the conversion parameter generation system having the fourth feature, the item name information is the same as the item name information stored in the XML data analysis work table memory by the second step in the fourth step. A fifth feature is that a corresponding item number value is extracted from the CSV data analysis work table memory, and the correspondence between the extracted item number value and item name information is used as the conversion parameter information.

In the conversion parameter generation system according to the fourth or fifth feature, the XML definition information includes a data type indicating a data format corresponding to the item name information and a number of digits indicating the number of digits of the data. The CSV definition information includes a data type indicating a data format corresponding to the item name information and a number of digits indicating the number of digits of the data;
The computer is
In the second step, based on the tag extracted from the XML data and the data type and the number of data digits of the data surrounded by the tag, the item name information corresponding to the tag is extracted from the XML definition information table memory,
The item name corresponding to the item number value from the CSV definition information table memory based on the item number value extracted from the CSV data and the data type and the number of data digits set in the item number value in the third step The sixth feature is to extract information.

Furthermore, the present invention provides a markup language definition information table memory storing markup language definition information indicating a correspondence between a markup language format tag and an item name, and a correspondence between an item number value in CSV format and item name information. CSV definition information table memory storing CSV definition information, conversion parameter information table memory storing conversion parameter information for data conversion between CSV data and markup language data, and mark analyzed markup language data Markup language data analysis work table memory for storing up-language data analysis result information, CSV data analysis work table memory for storing CSV data analysis result information obtained by analyzing CSV data, and predetermined item names for a plurality of data Delimiter identifiers in the order of item number values corresponding to information Conversion of the conversion parameter generation system provided with a computer that generates the conversion parameter information by using the CSV data stored in the table and the markup language data storing a plurality of data surrounded by tags corresponding to the item name information A parameter generation program,
In the computer,
A first function for inputting markup language data describing predetermined information based on markup language definition information and CSV data describing the predetermined information based on CSV definition information;
The tag and data included in the markup language data input by the first function are extracted, item name information corresponding to the tag is extracted from the markup language definition information table memory based on the extracted tag, and the tag And a second function for storing correspondence information between the item name information and the markup language data analysis work table memory;
The data included in the CSV data input by the first function and the item number value which is the order of appearance of the data are extracted, and the item number value is supported from the CSV definition information table memory based on the extracted item number value A third function that extracts item name information to be stored, and stores correspondence information between the extracted item number value and item name information in a CSV data analysis work table memory;
Based on the correspondence information between the tag and the item name stored in the markup language data analysis work table memory by the second function and the correspondence information between the item number and the item name stored in the CSV data analysis work table memory by the third function. The seventh feature is that a fourth function for extracting the correspondence between the item number value of the CSV data and the tag of the markup language data as the conversion parameter information is realized.

  According to the present invention, in the conversion parameter generation program of the seventh feature, the same item name as the item name information stored in the markup language data analysis work table memory by the second function in the computer in the fourth function. An eighth feature is that an item number value corresponding to the information is extracted from the CSV data analysis work table memory, and a function of extracting the correspondence between the extracted item number value and the item name information as the conversion parameter information is realized. .

According to the present invention, in the conversion parameter generation program according to the seventh or eighth feature, the markup language definition information includes a data type indicating a data format corresponding to the item name information and a digit indicating the number of digits of the data. The CSV definition information includes a data type indicating the data format corresponding to the item name information and the number of digits indicating the number of digits of the data;
In the computer,
In the second function, the tag and data included in the markup language data are extracted, and the item corresponding to the tag from the markup language definition information table memory based on the extracted tag and the data type and number of data digits of the data Realizing the extraction of name information,
In the third function, the item name corresponding to the item number value from the CSV definition information table memory based on the item number value extracted from the CSV data and the data type and the number of data digits of the data set in the item number value The ninth feature is to realize the extraction of information.

Furthermore, the present invention stores an XML definition information table memory storing XML definition information indicating the correspondence between XML tags and item names, and CSV definition information indicating correspondence between item number values in CSV format and item name information. CSV definition information table memory, conversion parameter information table memory for storing conversion parameter information for data conversion between CSV data and XML data, and XML data analysis for storing XML data analysis result information obtained by analyzing XML data Work table memory, CSV data analysis work table memory storing CSV data analysis result information obtained by analyzing CSV data, and CSV storing a plurality of data separated by commas in order of item number values corresponding to predetermined item name information Data and a copy enclosed by tags corresponding to the item name information A data storing as input and XML data, transformation parameter generation program transformation parameter generation system provided with a computer for generating said transformation parameter information,
In the computer,
A first function for inputting XML data in which predetermined information is described based on XML definition information, and CSV data in which the predetermined information is described based on CSV definition information;
A tag and data included in the XML data input by the first function are extracted, item name information corresponding to the tag is extracted from the XML definition information table memory based on the extracted tag, and the tag and item name information are extracted. A second function for storing the correspondence information in the XML data analysis work table memory;
The data included in the CSV data input by the first function and the item number value which is the order of appearance of the data are extracted, and the item number value is supported from the CSV definition information table memory based on the extracted item number value A third function that extracts item name information to be stored, and stores correspondence information between the extracted item number value and item name information in a CSV data analysis work table memory;
Based on the correspondence information between the tag and the item name stored in the XML data analysis work table memory by the second function and the correspondence information between the item number and the item name stored in the CSV data analysis work table memory by the third function, A tenth feature is that a fourth function of extracting correspondence between item number values of CSV data and tags of XML data as the conversion parameter information is realized.

  According to the present invention, in the conversion parameter generation program of the tenth feature, the same item name information as the item name information stored in the XML data analysis work table memory by the second function is stored in the computer in the fourth function. An eleventh feature is to realize a function of extracting a corresponding item number value from the CSV data analysis work table memory and extracting a correspondence between the extracted item number value and item name information as the conversion parameter information.

According to the present invention, in the conversion parameter generation program of the tenth or eleventh feature, the XML definition information includes a data type indicating a data format corresponding to the item name information and a number of digits indicating the number of digits of the data. The CSV definition information includes a data type indicating a data format corresponding to the item name information and a number of digits indicating the number of digits of the data;
In the computer,
In the second function, the tag and data included in the XML data are extracted, and the item name information corresponding to the tag is extracted from the XML definition information table memory based on the extracted tag and the data type and number of data digits of the data. To realize that
In the third function, the item name corresponding to the item number value from the CSV definition information table memory based on the item number value extracted from the CSV data and the data type and the number of data digits of the data set in the item number value The twelfth feature is to realize the extraction of information.

  The conversion parameter generation system and the conversion parameter generation program according to the present invention include markup language data in which predetermined information is described in a markup language format according to markup language (for example, XML format) definition information, and the predetermined information is CSV-defined. Preparing CSV data described in CSV format according to information, analyzing markup language data and CSV data converted based on the same predetermined information, and tags in markup language data included in the analysis result The correspondence information between the name and the item name is stored in the markup language data analysis work table, and the correspondence between the item number value in the CSV data and the item name information is stored in the CSV data analysis work table. Based on the item name information, the item number order and the mark By extracting the correspondence between the tag name in the flop language form as the conversion parameter information, it is possible to easily generate a conversion parameter information.

1 is a schematic configuration diagram of a conversion parameter generation system according to an embodiment of the present invention. Explanatory drawing of the whole operation | movement of the conversion parameter generation by this embodiment. Explanatory drawing of the XML data analysis process by this embodiment. Explanatory drawing of the CSV data analysis process by this embodiment. Explanatory drawing of the link | linking process of the XML / CSV data by this embodiment. The figure which shows the example of XML definition information by this embodiment. The figure which shows the CSV definition information example by this embodiment. The figure which shows the example of the conversion parameter information by this embodiment. The figure which shows the example of XML data by this embodiment. The figure which shows the data example (1) after the XML analysis by this embodiment. The figure which shows the data example (2) after the XML analysis by this embodiment. The figure which shows the CSV data example by this embodiment. The figure which shows the example of data after CSV analysis by this embodiment. The figure which shows the example of an XML and CSV matching result by this embodiment. The figure which shows the example of the conversion parameter information by this embodiment. The figure which shows the XML data analysis work table by this embodiment. The figure which shows the CSV data analysis work table by this embodiment.

Hereinafter, an embodiment of a conversion parameter generation system employing a conversion parameter generation method according to the present invention will be described with reference to the drawings.
[Constitution]
The conversion parameter generation system 300 according to this embodiment includes input data 302 in XML format in which predetermined information (for example, electronic commerce information) is described according to the XML definition of the XML definition information 303, and the predetermined information is CSV in the CSV definition information 305. A conversion parameter generation engine 301 is provided that individually prepares output data 304 in CSV format described according to the definition, inputs both the input data 302 in XML format and the output data 304 in CSV format, and outputs them as conversion parameter information 305. The conversion parameter generation engine 301 is configured by software or hardware that operates on a computer, and various tables and definition information described later are stored in a hard disk, memory, or the like. The input data 302 in the XML format and the output data 304 in the CSV format describe the same predetermined information (electronic commerce information) separately according to each data format rule (definition information).

  For example, as shown in FIG. 6, the XML definition information 303 includes a sender ID indicating a data transmission source, a receiver ID indicating a data reception destination, a transmission date and time indicating the date and time when the data is transmitted, and the data. The delivery slip number, the delivery destination code indicating the delivery destination of the product, the delivery destination name of the delivery destination, the delivery destination name Kana which is the kana notation of the delivery destination name, the item number indicating the details of the product, The product code of the product, the product name of the product, the product name Kana written in kana for the product, the original unit price of the product, the selling unit price of the product, and a quantity (rose) indicating the quantity of the product For example, as a tag name (epath) corresponding to each item name, data / sender ID, data / receiver ID, data / sendDate, data / list / tradeN mber, data / list / shipToCode, data / list / shipToName, data / list / shipToNameKana, data / list / item / lineNumber, data / list / item / item / it / data / it / data / it / data / it / data / it / date / it / it / data / it / itemNameKana, data / list / item / netPrice, data / list / item / sellingPrice, data / list / item / quantity are set, and the data type of each item is number, number, date, number, number, character, character ( Kana), numbers, alphanumeric characters, letters, letters (kana), numbers, numbers, numbers, and the number of digits in each item is 8, 8, 8, 6, 8. It has been set is 20,20,3,13,20,20,8,2,8,2,6.

  On the other hand, the CSV data definition information 306 described above includes, for example, an item name (information) for each item number value as a sender ID, a recipient ID, a transmission date / time, a slip number, a delivery destination code, a description, as shown in FIG. Number, product code, original unit price, selling unit price, quantity (rose) are set, and the data type for each item name (information) is a number (number of digits 8), a number (number of digits 8), a date ( Number of digits 8), number (number of digits 6), number (number of digits 8), number (number of digits 3), alphanumeric (number of digits 13), number (number of digits 8, 2), number (number of digits 10), It is defined as a quantity (6 digits).

  Further, the conversion parameter information 305 is a comparison between the tag that is the conversion source of the XML format data and the item number value after the conversion in the CSV format. For example, as shown in FIG. As tags corresponding to 1 to 10, data / senderID, data / receiverID, data / sendDate, data / list / tradeNumber, data / list / shipToCode, data / list / item / lineNumber, data / list / itm, data / list / it / / List / item / netPrice, data / list / item / sellingPrice, and data / list / item / quantity are set. For example, the tag in which the appearance order included in the CSV data is set to the first item number value “1” is “data / senderID”, and the tag set to the next item number “1” is “data / receiverID”. Is set.

  The input data 302 in the XML format is described so as to enclose the data with a predefined tag. For example, in the example of FIG. 9, the data is started by the tag <data>, and the tag </ data> In the data range that ends with>, data “00012345” surrounded by the tags <sendID> and </ sendID> is the sender ID, and data “00054321” surrounded by <receiveID> and </ receiveID> is received. And other information indicating that the value enclosed by the tags <tradwNumber> and </ tradwNumber> is the slip number “00000001”. This description rule is determined by the XML definition information described above. It has been.

  Furthermore, the conversion parameter generation engine 301 according to the present embodiment includes an XML data analysis work table (FIG. 16), a CSV data analysis work table (FIG. 17), and a matching result work table (FIG. 14) in a computer memory or the like. The XML data analysis work table is a work table used when analyzing input data in the XML format. In this embodiment, as shown in FIG. 16, a plurality of item names (information) included in the commercial transaction information. For example, sender ID, receiver ID, transmission date and time, slip number, delivery destination code, delivery destination name, delivery destination name Kana, item number, product code, product name, product name Kana, original unit price, unit price, quantity (Rose) is set in advance, and for each item name (information), a tag name (xpath) that is a path character string in the XML language, Item is over data string data [1] and Data [2] is one that has been set in advance. Note that the plurality of item names (information) in the XML data analysis work table may be generated by extracting a tag included in the input XML language and referring to the XML definition information.

  As shown in FIG. 17, the CSV data analysis work table includes, as item names, a sender ID, a receiver ID, a transmission date and time, a slip number, a delivery destination code, a detail number, a product code, an original unit price, a selling price, and a quantity ( Rose) The items of the item number (value), data type, and number of digits in the CSV set in advance and set in advance for commercial transactions for each item are set in advance. The plurality of item names in the CSV data analysis work table may be generated by counting and extracting item number values included in the input CSV data in the order of data appearance and referring to the CSV definition information.

  As shown in FIG. 14, the matching result work table includes item number values in CSV format extracted from the above CSV data, item name correspondence information corresponding to the item numbers, item names analyzed from XML data, and the items. The correspondence information with the tag name corresponding to the name is stored.

[Operation]
The conversion parameter generation engine 301 according to the present embodiment is based on XML-formatted input data 302 described based on predetermined information (electronic commerce information) and based on the same predetermined information (electronic commerce information) as the input data 302. The conversion data information 305 is generated and output based on the output data 304 in CSV format described as input, and the generation procedure of the conversion parameter information 305 will be described below.

  First, as shown in FIG. 2, the conversion parameter generation engine 301 according to the present embodiment reads the XML format input data 302, and refers to the XML definition information 303 for the description content of the read XML format input data 302. Then, step S402 for analyzing is executed.

  As shown in FIG. 3, the conversion parameter generation engine 301 clears the memory space for storing the above-mentioned path character string and data character string as shown in FIG. Step S502 for reading the XML data shown in FIG. 9 in line units from the first line, Step S503 for determining whether the XML data read in Step S502 is a tag or data with reference to the XML definition information, and a tag in Step S503 It is determined whether it is a start tag or an end tag (the first tag that appears is the start, and then the end when the same name tag appears with “/”) is determined. Step S504 returns to step S501, and the start tag is determined in step S504. At this time, the determined path character string and tag name are substituted into the tag name (xpath) column of the XML data analysis work table, and the process returns to step S501 and the read XML is determined to be data in step S503. At step S506, the determined data is substituted into the data [1] column of the XML data analysis work table, as shown in FIG. 10, and the XML definition information (FIG. 6) is searched. A process of storing a data character string (for example, “00012345”) in the data [1] column of a row (record) that matches a “path character string” (for example, “data / senderID”) in “data [2]” in the next column. By repeating, the tag name and data are displayed in each column of the XML data analysis work table (FIG. 16). The stored as shown in FIG. 11 executes the step S507 returns to step S507.

  As described above, the analysis method according to the present embodiment uses the start tag (for example, “data” of the path character string and “senderID” of the tag name of the next line) determined in step S504 as the tag of the XML data analysis work table in step S505. The data stored in the name (epath) field, the data determined in step S503 is stored in the data [1] field of the XML data analysis work table, and the data stored in the data [1] field in step S507 is stored in the data [2] field. By repeating the storing process, the analysis result (2) of the XML data as shown in FIG. 11 is acquired.

  Now, the conversion parameter generation engine 301 according to the present embodiment returns to step S402 in FIG. 2 described above, and reads the CSV data shown in FIG. 12, and the CSV data read in step S403 is converted into CSV definition information. Step S404 of analyzing based on (FIG. 7) is executed.

As shown in FIG. 4, the CSV data analysis method in step S <b> 404 determines that the conversion parameter generation engine 301 reads one line of CSV data and whether all data has been read in step S <b> 601. When it is determined that all the data has been read, step S602 that terminates the processing, and when it is determined that the data reading has not ended in step S602, 1 is divided by the comma in the read one-line data. Step S603 for reading item data (eg, “00012345”), step S604 for storing the data read in step S603 in the corresponding item column of the CSV analysis work table with reference to the CSV definition information, and data in one row Determine whether reading is complete When it is determined that the reading is completed, the process returns to step S601 to read the next line data. When it is determined that the reading is not completed, the process returns to step S603 and the next item data in one line (for example, “00054321”). ) Is read and step S605 is returned to step S601.
Through these series of steps, the conversion parameter generation engine 301 according to the present embodiment can store the CSV analysis result as shown in FIG. 13 in the CSV data analysis table.

  Now, the conversion parameter generation engine 301 according to the present embodiment that has performed XML and CSV format data analysis as described above returns to the step of FIG. 2, and the XML data analysis result shown in FIG. 11 and the CSV data shown in FIG. Step S405 for matching the analysis result and linking (linking) the XML data and the CSV data, and storing the result of linking in step S406 in the matching result work table shown in FIG. Next, conversion is performed by executing step S406 of outputting the conversion parameter shown in FIG. 15 in which the item number of CSV and the tag name of the XML data corresponding to the item number are extracted from the correspondence information stored in the matching result work table. Conversion parameters in the parameter generation system can be easily generated

  As shown in FIG. 5, the details of the process of associating the XML data and the CSV data in the step S405 are as follows. As shown in FIG. 5, the CSV analysis result data shown in FIG. It is determined whether or not the reading has been completed. When it is determined that the reading has been completed, step S702 is completed. When it is determined that the reading has not been completed in step S702, the analysis result data read in step S701 is, for example, Step S703 for searching the XML analysis result data (FIG. 11) based on the “sender ID” of the item name of the first item in the item order, and whether or not it matches the XML analysis result data searched in step S703 Step S704 for determining the item name, and CSV data of the item name matched in Step S704 Step S705 for storing the item number and the item name corresponding to the item number, the matched XML data item name, and the tag name (expath) corresponding to the item name in the matching result work table shown in FIG. 14 is executed. To do. The information stored in step S705 will be specifically described. Correspondence information between item numbers in the CSV extracted from CSV data and item names corresponding to the item numbers (for example, item number “1” and item name “sender ID”) ), Correspondence information between the item name analyzed from the XML data and the tag name corresponding to the item name (for example, the item name “sender ID” and the tag name “data / senderID”). Note that the match with the analysis result data in step S704 is not limited to determining whether only the item name matches, but it may be determined whether all of the item name, data type, and number of data digits match.

  In this way, the conversion parameter generation system adopting the conversion parameter generation method in the present embodiment reads both the XML data obtained by converting the same information (electronic transaction information) into the XML format and the CSV data converted into the CSV format. , Analyzing the XML data with reference to the XML definition information, generating a correspondence between the item name and the tag name corresponding to the item name as an XML data analysis work table, and referring to the CSV data with the CSV definition information And comparing the step of generating the correspondence between the item number and the item name corresponding to the item number as a CSV data analysis table, and the analyzed XML data analysis work table and the CSV data analysis work table. Conversion parameter information indicating the correspondence with the XML format tag corresponding to the item name (information) Door can be.

For example, in the EDI system in the business-to-business electronic commerce, the generated conversion parameter information is generated by using the XML data and the CSV data of the same commodity transaction information, and then the generated conversion parameter information. By performing data conversion using a conversion program (not shown) using, mutual conversion between XML data and CSV data in electronic commerce between the same company and the same product can be easily performed. Moreover, the conversion parameter generation system in this embodiment can further learn the conversion parameter information described above by inputting a plurality of XML data and CSV data in electronic commerce between the same companies and the same products. Note that the data conversion by the conversion program described above includes, for example, a first step of reading XML data when converting XML data to CSV data, a second step of analyzing the XML data using XML definition information, and FIG. The third step of reading the conversion parameter information shown in FIG. 5 and converting the analyzed data into CSV data based on the conversion parameter information (the data written in the tags in the order of the item numbers defined in the CSV definition information are separated by commas). This is performed by executing the fourth step of conversion or the like as described.
Further, in the EDI system, an identifier is assigned in advance to a conversion parameter in electronic commerce between a plurality of companies, and conversion parameter information is obtained based on the identifier described above according to the combination of the input source company and the receiving company. By selecting and performing data conversion, electronic commerce between companies can be easily performed regardless of the data format difference between companies.

  In the above-described embodiment, an example in which conversion between comma-delimited CSV data and XML data has been described. However, the present invention is not limited to conversion between these data formats, but other data formats. Conversion parameters in between can also be generated. For example, the present invention changes the data format derived from the CSV format using an arbitrary delimiter identifier such as a double quote "" ", tab, space, etc. as a data delimiter in place of the CSV format, and changes to the XML format to tag data. HTML (HyperText Markup Language) HTML (HyperText Markup Language), HTML (Hyper Text Markup Language), HTML format developed from SGML (Hyper Text Markup Language), SGML (Standard Generalized Markup Language), etc. In between conversion parameters can also be generated. In this case, the conversion parameter generation engine extracts data using a delimiter identifier such as double quotes, tabs, or spaces in the CSV data analysis process shown in FIG. 4, and stores the data in the CSV data analysis table shown in FIG. By storing the extracted data, conversion parameters can be generated by operating to analyze the data. In this specification, the data format including the above-described delimiter identifier is also referred to as a CSV format.

  300: Conversion parameter generation system, 301: Conversion parameter generation engine, 302: Input data in XML format, 303: XML definition information, 304: Output data in CSV format, 305: Conversion parameter information, 306: CSV definition information.

Claims (12)

A markup language for storing CSV data storing a plurality of data using a delimiter identifier in order of item number values corresponding to predetermined item name information, and a plurality of data surrounded by tags corresponding to the item name information A conversion parameter generation system for generating conversion parameter information for performing data conversion between the CSV data and the markup language data by using a computer as input,
A markup language definition information table memory storing markup language definition information indicating the correspondence between the markup language format tag and item name information;
A CSV definition information table memory storing CSV definition information indicating correspondence between item number values in CSV format and item name information;
A conversion parameter information table memory for storing the conversion parameter information;
Markup language data analysis work table memory for storing markup language data analysis result information obtained by analyzing markup language data;
A CSV data analysis work table memory for storing CSV data analysis result information obtained by analyzing CSV data;
The computer is
A first step of inputting markup language data describing predetermined information based on markup language definition information and CSV data describing the predetermined information based on CSV definition information;
A tag and data included in the markup language data input in the first step are extracted, item name information corresponding to the extracted tag is extracted from the markup language definition information table memory, and the tag and item name information are extracted. A second step of storing the corresponding information in the markup language data analysis work table memory;
The data included in the CSV data input in the first step and the item number value which is the order in which the data appears are extracted, and the item number value is supported from the CSV definition information table memory based on the extracted item number value A third step of extracting item name information to be stored, and storing correspondence information between the extracted item number value and item name information in a CSV data analysis work table memory;
Correspondence information between the tag and item name information stored in the markup language data analysis work table memory in the second step and correspondence between the item number value and item name information stored in the CSV data analysis work table memory in the third step A conversion parameter generation system that executes a fourth step of extracting a correspondence between an item number value of CSV data and a tag of markup language data as the conversion parameter information based on the information.   In the fourth step, the computer extracts, from the CSV data analysis work table memory, item number values corresponding to the same item name information as the item name information stored in the markup language data analysis work table memory in the second step. The conversion parameter generation system according to claim 1, further comprising a step of using correspondence between the extracted item number value and item name information as the conversion parameter information. The markup language definition information includes a data type indicating a data format corresponding to the item name information and a number of digits indicating the number of digits of the data;
The CSV definition information includes a data type indicating the data format corresponding to the item name information and the number of digits indicating the number of digits of the data,
The computer is
In the second step, the item name information corresponding to the tag is retrieved from the markup language definition information table memory based on the tag extracted from the markup language data and the data type and the number of data digits of the data surrounded by the tag. Extract and
The item name corresponding to the item number value from the CSV definition information table memory based on the item number value extracted from the CSV data and the data type and the number of data digits set in the item number value in the third step The conversion parameter generation system according to claim 1, wherein information is extracted. Input CSV data that stores a plurality of data in a comma-separated order in the order of item number values corresponding to predetermined item name information, and XML data that stores a plurality of data surrounded by tags corresponding to the item name information A conversion parameter generation system for generating conversion parameter information for performing data conversion between the CSV data and XML data by a computer,
An XML definition information table memory storing XML definition information indicating correspondence between XML format tags and item name information;
A CSV definition information table memory storing CSV definition information indicating correspondence between item number values in CSV format and item name information;
A conversion parameter information table memory for storing the conversion parameter information;
XML data analysis work table memory for storing XML data analysis result information obtained by analyzing XML data;
A CSV data analysis work table memory for storing CSV data analysis result information obtained by analyzing CSV data;
The computer is
A first step of inputting XML data describing predetermined information based on XML definition information and CSV data describing the predetermined information based on CSV definition information;
Tag and data included in the XML data input in the first step are extracted, item name information corresponding to the extracted tag is extracted from the XML definition information table memory, and correspondence information between the tag and item name information A second step of storing the data in the XML data analysis work table memory;
The data included in the CSV data input in the first step and the item number value which is the order in which the data appears are extracted, and the item number value is supported from the CSV definition information table memory based on the extracted item number value A third step of extracting item name information to be stored, and storing correspondence information between the extracted item number value and item name information in a CSV data analysis work table memory;
Correspondence information between the tag and item name information stored in the XML data analysis work table memory in the second step and correspondence information between the item number value and item name information stored in the CSV data analysis work table memory in the third step. A conversion parameter generation system that executes a fourth step of extracting the correspondence between the item number value of CSV data and the tag of XML data as the conversion parameter information.   In the fourth step, the computer extracts an item number value corresponding to the item name information identical to the item name information stored in the XML data analysis work table memory in the second step from the CSV data analysis work table memory, The conversion parameter generation system according to claim 4, further comprising a step of setting the correspondence between the extracted item number value and item name information as the conversion parameter information. The XML definition information includes a data type indicating a data format corresponding to the item name information and a number of digits indicating the number of digits of the data;
The CSV definition information includes a data type indicating the data format corresponding to the item name information and the number of digits indicating the number of digits of the data,
The computer is
In the second step, based on the tag extracted from the XML data and the data type and the number of data digits of the data surrounded by the tag, the item name information corresponding to the tag is extracted from the XML definition information table memory,
The item name corresponding to the item number value from the CSV definition information table memory based on the item number value extracted from the CSV data and the data type and the number of data digits set in the item number value in the third step 6. The conversion parameter generation system according to claim 4, wherein information is extracted. Markup language definition information table memory storing markup language definition information indicating correspondence between markup language format tags and item names, CSV definition information indicating correspondence between item number values in CSV format and item name information Stored CSV definition information table memory, conversion parameter information table memory for storing conversion parameter information for performing data conversion between CSV data and markup language data, and markup language data analysis results obtained by analyzing markup language data Markup language data analysis work table memory for storing information, CSV data analysis work table memory for storing CSV data analysis result information obtained by analyzing CSV data, and items corresponding to predetermined item name information Stored using delimited identifiers in numerical value order Conversion parameter generation program for a conversion parameter generation system comprising a computer that receives SV data and markup language data storing a plurality of data surrounded by tags corresponding to the item name information, and generates the conversion parameter information Because
In the computer,
A first function for inputting markup language data describing predetermined information based on markup language definition information and CSV data describing the predetermined information based on CSV definition information;
The tag and data included in the markup language data input by the first function are extracted, item name information corresponding to the tag is extracted from the markup language definition information table memory based on the extracted tag, and the tag And a second function for storing correspondence information between the item name information and the markup language data analysis work table memory;
The data included in the CSV data input by the first function and the item number value which is the order of appearance of the data are extracted, and the item number value is supported from the CSV definition information table memory based on the extracted item number value A third function that extracts item name information to be stored, and stores correspondence information between the extracted item number value and item name information in a CSV data analysis work table memory;
Based on the correspondence information between the tag and the item name stored in the markup language data analysis work table memory by the second function and the correspondence information between the item number and the item name stored in the CSV data analysis work table memory by the third function. And a conversion parameter generation program that realizes a fourth function of extracting the correspondence between the item number value of the CSV data and the tag of the markup language data as the conversion parameter information.   In the fourth function, the item number value corresponding to the item name information stored in the markup language data analysis work table memory by the second function is extracted from the CSV data analysis work table memory. The conversion parameter generation program according to claim 7, wherein a function for extracting the correspondence between the extracted item number value and item name information as the conversion parameter information is realized. The markup language definition information includes a data type indicating a data format corresponding to the item name information and a number of digits indicating the number of digits of the data;
The CSV definition information includes a data type indicating the data format corresponding to the item name information and the number of digits indicating the number of digits of the data,
In the computer,
In the second function, the tag and data included in the markup language data are extracted, and the item corresponding to the tag from the markup language definition information table memory based on the extracted tag and the data type and number of data digits of the data Realizing the extraction of name information,
In the third function, the item name corresponding to the item number value from the CSV definition information table memory based on the item number value extracted from the CSV data and the data type and the number of data digits of the data set in the item number value The conversion parameter generation program according to claim 7 or 8, which realizes the extraction of information. XML definition information table memory storing XML definition information indicating correspondence between XML format tags and item names; CSV definition information table storing CSV definition information indicating correspondence between item number values in CSV format and item name information A memory, a conversion parameter information table memory for storing conversion parameter information for performing data conversion between CSV data and XML data, an XML data analysis work table memory for storing XML data analysis result information obtained by analyzing the XML data, CSV data analysis work table memory for storing CSV data analysis result information obtained by analyzing CSV data, CSV data storing a plurality of data in a comma-separated order in accordance with item number values corresponding to predetermined item name information, and the item name Multiple data surrounded by tags corresponding to information are stored. To as input and XML data, a transformation parameter generation program transformation parameter generation system provided with a computer for generating said transformation parameter information,
In the computer,
A first function for inputting XML data in which predetermined information is described based on XML definition information, and CSV data in which the predetermined information is described based on CSV definition information;
A tag and data included in the XML data input by the first function are extracted, item name information corresponding to the tag is extracted from the XML definition information table memory based on the extracted tag, and the tag and item name information are extracted. A second function for storing the correspondence information in the XML data analysis work table memory;
The data included in the CSV data input by the first function and the item number value which is the order of appearance of the data are extracted, and the item number value is supported from the CSV definition information table memory based on the extracted item number value A third function that extracts item name information to be stored, and stores correspondence information between the extracted item number value and item name information in a CSV data analysis work table memory;
Based on the correspondence information between the tag and the item name stored in the XML data analysis work table memory by the second function and the correspondence information between the item number and the item name stored in the CSV data analysis work table memory by the third function, A conversion parameter generation program for realizing a fourth function of extracting correspondence between item number values of CSV data and tags of XML data as the conversion parameter information.   In the fourth function, in the fourth function, the item number value corresponding to the same item name information as the item name information stored in the XML data analysis work table memory by the second function is extracted from the CSV data analysis work table memory, 11. The conversion parameter generation program according to claim 10, which realizes a function of extracting a correspondence between the extracted item number value and item name information as the conversion parameter information. The XML definition information includes a data type indicating a data format corresponding to the item name information and a number of digits indicating the number of digits of the data;
The CSV definition information includes a data type indicating the data format corresponding to the item name information and the number of digits indicating the number of digits of the data,
In the computer,
In the second function, the tag and data included in the XML data are extracted, and the item name information corresponding to the tag is extracted from the XML definition information table memory based on the extracted tag and the data type and number of data digits of the data. To realize that
In the third function, the item name corresponding to the item number value from the CSV definition information table memory based on the item number value extracted from the CSV data and the data type and the number of data digits of the data set in the item number value The conversion parameter generation program according to claim 10 or 11, which realizes extraction of information.

Images