JP2006268136A - Edi information conversion device, edi conversion method and its program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To automatically generate a source program for the reference and update of EDI data in an EDI site whose language block is different. <P>SOLUTION: Respective items described in each language in a screen display section and a database access section included in a source program and EDI data in respective EDI sites 2a to 2d of an EDI system are stored with item numbers common to each language. Then, this EDI information conversion device is provided with a source program template generating means 7 for generating a source program template where each item described in belonging language included in the source program under execution in an EDI site are replaced with item numbers and a source program compounding means 8 for generating a source program for a designated language block where the item numbers of the respective items of the generated source program template are replaced with the items described in the language in the pertinent language block. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

   The present invention relates to an EDI system in which a plurality of EDI (Electronic Data Interchange) sites having different linguistic spheres are connected to a network, and particularly refers to and updates EDI data transmitted and received at each EDI site. The present invention relates to an EDI information conversion apparatus, an EDI information conversion method, and an EDI information conversion program that generate and convert EDI data.

  For example, in an EDI system in which a plurality of EDI sites are connected to a network such as the Internet, in order to conduct electronic commerce using EDI data between the EDI sites, EDI data transmitted and received at each EDI site A source program (application program) having the same content is incorporated in all EDI sites to be referred to or updated.

  Therefore, in order to expand the scope of electronic commerce using the EDI data, a source program having the same contents for referring to or updating the EDI data transmitted / received to the EDI site newly joined to the EDI system. (Application program) needs to be newly incorporated.

  If the newly subscribed EDI site belongs to the same language area, for example, in Japan, the source program (application program) currently in use is written to the newly subscribed EDI site via the network (download) Only need.

  However, when trying to spread the scope of electronic commerce using EDI data to foreign countries with different language spheres, this EDI site is the source program (application program) to be incorporated into EDI sites newly joined in different language spheres. It was necessary to be described in the language of the designated language area.

  When sending EDI data to EDI sites belonging to different currency zones and different time zones (time zones), the amount, currency unit, and time included in this EDI data are sent to the destination amount, currency unit, It is preferable to change the time.

  However, there are many languages. For this reason, the number of types of source programs (application programs) that must be newly created increases, and development and creation of source programs (application programs) to be incorporated into each EDI site cause a great deal of time and money. .

  Furthermore, it is complicated for the person in charge that the person in charge manually changes the amount, currency unit, and time included in the EDI data to the amount, currency unit, and time of the destination in the sender EDI site. In addition, the EDI data transmission work efficiency decreases.

Patent Document 1 discloses a technique for improving the efficiency of file conversion processing and file exchange processing required when exchanging EDI data between a plurality of systems.
JP 2002-342593 A

  In this way, when trying to spread the scope of electronic commerce using EDI data to foreign countries with different language spheres, development and creation of source programs (application programs) to be incorporated into EDI sites newly joined in different language spheres A great deal of time and money is incurred. In addition, since the person in charge manually changes the amount, currency unit, and time included in the EDI data to the destination amount, currency unit, and time, the transmission work efficiency of the EDI data decreases.

  The present invention has been made in view of such circumstances, and pays attention to the ease and versatility of a source program (application program) for referring to and updating EDI data transmitted and received at each EDI site. To provide an EDI information conversion apparatus, an EDI information conversion method, and an EDI information conversion program that can efficiently and efficiently implement a source program associated with the addition of an EDI site in a service area, and that can efficiently operate an EDI system. Objective.

  In order to solve the above problems, in the EDI information conversion apparatus of the present invention, EDI data is transmitted / received between a plurality of EDI sites having different language spheres, and each EDI site is described in the language of the affiliation language sphere. In each EDI system for referring to and updating EDI data transmitted and received using a source program, items described in each language in the screen display portion and database access portion included in the source program and EDI data are common to each language. Item definition means for storing an item number, and a source program in which each item described in a language included in a source program already implemented at an arbitrary EDI site incorporated in the EDI system is replaced with the item number Source program template generation means for generating a template and language In response to the source program generation command that specifies, the item number of each item of the source program template generated by the source program template generation means is replaced with the item described in the language of the specified language area. Source program synthesis means for generating a source program and source program transmission means for transmitting the source program generated by the source program synthesis means to the EDI site in the designated language area.

  In the EDI information conversion apparatus configured as described above, in an EDI system that transmits and receives EDI data between a plurality of EDI sites having different language spheres, a screen display portion and a database access portion included in the source program and EDI data. Each item described in each language is stored with an item number common to each language. Further, a source program template common to each language area is stored in advance by storing an item number common to each language.

  Then, when creating a source program for referencing and updating EDI data to be incorporated in each EDI site, the item number of each item of the source program template is replaced with an item described in the language of the designated language area. As a result, a source program for each language area can be automatically generated.

  Further, another invention further stores conversion information such as the time zone, character code, currency unit, currency rate, etc. of the area to which each EDI site of the EDI system belongs in the EDI information conversion apparatus of the invention described above. The conversion information storage means and the EDI data designating the destination EDI site output from each EDI site of the EDI system are fetched, each item to be converted is referred to from the EDI data by referring to the item stored in the item definition means Data extraction means for extracting data, and each data in the area to which the EDI site of the transmission destination belongs using the conversion information stored in the conversion information storage means for each data to be converted extracted by this data extraction means Data conversion means for converting to EDI, and EDI data in which the data converted by the data conversion means is incorporated is transmitted to the destination EDI site It is added to the I data transmission means.

  In the EDI information conversion apparatus configured as described above, conversion information such as a time zone, a character code, a currency unit, and a currency rate of an area to which each EDI site of the EDI system belongs is stored and held. When EDI data designating a transmission destination is input from the transmission source EDI site, each data to be converted included in the EDI data is specified, and each data belongs to an area to which the transmission destination EDI site belongs. Are transmitted to the EDI site of the transmission destination.

  In another EDI information conversion method according to the present invention, EDI data is transmitted / received between a plurality of EDI sites having different language spheres, and each EDI site uses a source program described in the language of the affiliation language sphere. In the EDI system that refers to and updates EDI data to be sent and received, the item numbers described in each language in the screen display part and the database access part included in the source program and EDI data are assigned item numbers common to each language. The item definition step to be stored, and the source for generating the source program template in which each item described in the affiliation language included in the source program already implemented in any EDI site incorporated in the EDI system is replaced with the item number A program template generation step and a source with a specified language range Generates a source program for the corresponding language area by replacing the item number of each item of the source program template generated in the source program template generation step with the item described in the language of the specified language area according to the program generation command And a source program transmission step for transmitting the source program generated in the source program synthesis step to an EDI site in a designated language area.

  Also in the EDI information conversion method configured as described above, it is possible to achieve substantially the same operational effects as the EDI information conversion apparatus described above.

In addition, another invention stores conversion information such as a time zone, a character code, a currency unit, a currency rate, etc. of an area to which each EDI site of the EDI system belongs, in addition to the EDI information conversion method of the invention described above. The conversion information storage step and the EDI data specifying the destination EDI site output from each EDI site of the EDI system are fetched, and the items to be converted are referred to from the EDI data by referring to the items stored in the item definition step. Data extraction step for extracting data, and each data in the area to which the EDI site of the transmission destination belongs using the conversion information stored in the conversion information storage step for each data to be converted extracted in this data extraction step Data conversion step for converting to EDI data and EDI data incorporating the data converted in this data conversion step is transmitted It is added and EDI data transmission step of transmission to the EDI site.

  Also in the EDI information conversion method configured as described above, it is possible to achieve substantially the same operational effects as the EDI information conversion apparatus described above.

  An EDI information conversion program according to another invention causes a computer to realize each means in the above-described EDI information conversion apparatus. Therefore, the EDI information conversion program configured as described above can achieve substantially the same operational effects as the EDI information conversion apparatus described above.

  The EDI information conversion apparatus, EDI information conversion method, and EDI information conversion program configured as described above support each language for reference and update for EDI data transmitted and received at a plurality of EDI sites belonging to different language areas. Since each source program to be developed can be expanded by automatically generating for each language area using a source program that is already being implemented at any one EDI site, the EDI site can be easily expanded.

  In addition, since processing related to data exchange of EDI data can be centrally performed by the EDI information conversion apparatus, the EDI data between multiple EDI sites can be efficiently processed without affecting the EDI data transmission / reception processing at each EDI site. Transmission and reception are possible. Also, the accuracy of the currency conversion value based on the currency rate is unified without depending on the specifications of each EDI site by performing calculation with the EDI information conversion device.

  Hereinafter, an embodiment of the present invention will be described with reference to the drawings.

  FIG. 1 is a schematic diagram showing an entire EDI system in which an EDI information conversion method according to an embodiment of the present invention and an EDI information conversion apparatus to which an EDI information conversion program is applied are incorporated.

  In the EDI system, for example, a plurality of EDI sites 2a, 2b, 2c, and 2d and an EDI information conversion apparatus 40 are connected to a network 1 such as the Internet. The EDI information conversion device 40 is roughly composed of a source program automatic creation device 3 and an EDI data conversion device 4. Each EDI site 2a, 2b, 2c, 2d is installed in a different language zone, a different currency zone, and a different time zone (time zone).

  At the present time, a source program (application program) written in Japanese for referring to and updating EDI data to be transmitted and received is written only in the EDI site 2a arranged in the Japanese-speaking region. . The source program written in Japanese is called “original source program” for convenience.

  For example, in the source program automatic creation device 3 configured by a computer, provided in the EDI information conversion device 40, a data definition creation unit 5, an original source program division unit 6, and a source formed on an application program are provided. A program template generation unit 7, an EDI site source program synthesis unit 8, and a data storage unit 9 for storing various files are provided.

  Then, the source program automatic creation device 3 reads the original source program written in the EDI site 2a arranged in the Japanese-speaking region, and is common to all language regions from this “original source program”. Two “source program templates” are created, and character information described in each language is written (replaced) in each “source program template”, so that each EDI site 2b to 2d in each language area A “source program” is created and transmitted to the EDI sites 2b to 2d.

  On the other hand, in the EDI data conversion device 4 provided in the EDI information conversion device 40, for example, constituted by a computer, the data extraction unit 10, the data conversion unit 11, and various files formed on the application program are formed. Is stored.

  When the EDI data conversion device 4 receives the EDI data designating the transmission destination from each of the EDI sites 2a to 2d in which the “source program” has been written, the EDI data includes the amount, currency unit, and time included in the EDI data. The transmission amount is changed to the destination amount, currency unit, and time, and transmitted to the destination EDI sites 2a to 2d.

  Next, the detailed configuration and detailed operation of the source program automatic creation device 3 provided in the EDI information conversion device 40 will be described.

  As shown in FIGS. 2 and 4, the standard EDI message item definition information file 13 of the data storage unit 9 includes data types and sizes for each item of EDI message formats of various standards included in the source program and EDI data. And the like are stored with item numbers common to each language.

  As shown in FIGS. 2 and 5, in the site information file 14 of the data storage unit 9, for each EDI site to be constructed, a usage EDI standard, a usage EDI message, and a message unique to the EDI site. Source site ("reception range"), destination site ("transmission range"), screen display language ("language area") for inputting the message at the site, and the site storing message item data Database table name and column name information is defined.

  When the information for identifying the EDI site for which the source program is to be constructed is input, the data definition creation unit 5 identifies the EDI message (in this example, an estimate response message) to be used on the site from the site information file 14. The necessary EDI message information (standard, data item name, data type, size, required attribute, input / output attribute, etc.) is acquired from the standard EDI message item definition information file 13.

  Then, the data definition creation unit 5 adds to the corresponding EDI site (corresponding language area) of the information necessary for screen display processing (item name, full width, required attributes, input / output attributes, etc.) together with the acquired site information. Necessary screen display item definition information is created and written into the screen display item definition information file 16 shown in FIG. Further, database item definition information of information (column name, non-null attribute, data type, size, etc.) necessary for database access processing of the corresponding EDI site is generated and written to the database item definition information file 17 shown in FIG. Include. Further, code table definition information for the code stored as EDI message item data is created from the standard EDI message item definition information stored in the standard EDI message item definition information file 13, and the code shown in FIG. Write to the table definition information file 15.

  Therefore, the screen display item definition information file 16, the database item definition information file 17, and the code table definition information file 15 are created by the data definition creation unit 5 as many as the number of EDI sites for which the source program is to be constructed.

  FIG. 9 is a flowchart showing the data definition processing of the above-described screen display item definition information, database item definition information, and code table definition information performed by the data definition creation unit 5.

  First, the EDI standards and message names used by the EDI sites 2b to 2d in which the source program to be generated is written are acquired from the site information file 14 (S1). The definition of the code information related to the EDI message standard is acquired from the standard EDI message item definition information file 13, and a code table for managing codes and names is generated and written into the code table definition information file 15 (S2).

  Next, EDI standard message information used by the EDI sites 2b to 2d in which the source program to be generated is written is read from the site information file 14 (S3). Then, message information to be used is acquired from the standard EDI message item definition information file 13 (S6), and the screen display item definition information and the number of languages of the EDI site that receives the messages and all the messages to be used on the site are displayed. Database item definition information is generated (S8) and written to the screen display item definition information file 16 and the database item definition information file 17 (S9).

  Next, the original source program dividing unit 6 and the source program template generating unit 7 in FIGS. 1 and 3 will be described.

  In the SQL reserved word definition information file 20 in FIGS. 3 and 10, a plurality of SQL reserved words predicted to be included in the source program are stored as SQL reserved word definition information. In addition, in the HTML tag definition information file 21 in FIGS. 3 and 11, a plurality of HTML tags predicted to be included in the source program are stored as HTML tag definition information.

  The original source program file 22 shown in FIGS. 3 and 12 stores an original source program that has already been created and is in operation as a source program for referring to and updating EDI data read from the EDI site 2a. As shown in FIG. 12, this original source program is a program including database logic and HTML output logic. In the example of FIG. 12, lines 1 to 3 of the original source program are database logic, lines 101 to 102 are HTML display logic, and lines 100 and 250 are other statements.

  The original source program dividing unit 6 reads the original source program stored in the original source program file 22, SQL reserved word definition information in the SQL reserved word definition information file 20, and HTML tag definition information in the HTML tag definition information file 21. From this, it is determined for each line of the original source program whether it is database logic, HTML display logic, or other statements.

  Then, the original source program dividing unit 6 writes the classification result for each line of the original source program in the source program dividing information file 23 shown in FIG. Further, the original source program dividing unit 6 writes the database logic included in the original source program into the database logic unit information file 24 shown in FIG. 14, and the HTML display logic included in the original source program is shown in FIG. The information file 25 is written and other statements included in the original source program are written into the other source program information file 26 shown in FIG.

  The source program template generation unit 7 in FIG. 3 reads the database logic of each row of the database logic part information file 24, refers to the SQL reserved word definition information in the SQL reserved word definition information file 20, and stores database objects and column names from the SQL sentence. Is replaced with the parameter (item number) of the item. In the example of FIG. 14, “jp0005, jp00072” on the second line is replaced with “$ COL_1_0302, $ COL_2_0302” with reference to the database item definition information in the database item definition information file 19 of FIG.

  Further, the source program template generation unit 7 reads the HTML display logic of each line of the HTML display logic part information file 25, refers to the HTML tag definition information of the HTML tag definition information file 21, and displays the part of the display character string from the HTML sentence. Judgment and replacement with the parameter (item number) of the item. In the example of FIG. 15, “answer unit price” on the first line is replaced with “SLABBL_4” with reference to the screen display item definition information in the screen display item definition information file 16 shown in FIG.

  Then, the source program template generation unit 7 uses the information obtained by replacing the variable part in the original source program with the parameter (item number) in this way and the other information stored in the other source program information file 26 as the source. Based on the division information in the program division information file 23, the source program template is created by merging line by line in the order of the line numbers of the original source program, and written in the source program template file 18 shown in FIG.

  In the example of the source program template shown in FIG. 17, “$ COL_1_0302”, “$ COL_2_0302”, and the like are parameters (item numbers) as described above.

  Next, the operation of the source program synthesis unit 8 for the EDI site in FIG. 2 will be described.

  The source program synthesis unit 8 for the EDI site automatically generates a source program for the EDI sites 2b to 2d to be constructed from the source program template stored in the source program template file 18, and the source program file 19 shown in FIG. Write to.

  Specifically, first, each unconfirmed character string ($ TABLE_0302, $ COL_1_0302, $ COL_2_0302, $ COL_3_0302, $ LABEL_4, $ SIZE_4) including parameters (item numbers) is extracted from the source program template shown in FIG. , A source program capable of compiling and determining a definite value of the character string from the screen display item definition information stored in the screen display item definition information file 16 and the database item definition information stored in the database item definition information file 17 Is generated.

  Here, the above-mentioned undetermined character string in the source program template is "" $ "+" object name "+" _ "+ identification number" or "" $ "+" COL "+" _ "+ column identification number For example, $ TABLE_0302 indicates the table of the identification number “0302”, and $ COL_1_0302 indicates the column of the identification number “1” of the table of the identification number “0302”. Based on the database item definition information in the database item definition information file 17 shown in FIG. 8, the table whose identification number (table number) is “0302” is identified as the estimate response table and the table name is “EIAJ_estimate response”. it can.

  Further, $ COL_1_0302 is a column of serial number 1 in the EIAJ_estimate response table, and it can be specified from the database item definition information that the column name is “jp00005”. Further, $ LABEL_4 represents a screen display item character string, and it is possible to specify that the screen display item of serial number 4 is “answer unit price” from the screen display item definition information of the screen display item definition information file 16 shown in FIG. .

  FIG. 18 is a flowchart for creating a source program for each EDI site from the source program template performed by the above-described EDI site source program synthesis unit 8.

  First, unconfirmed items described in the source program template stored in the source program template file 18 are extracted (Q1), and whether each item is the size of the screen display character string (label) and the screen display field, or otherwise (Q3).

  In the case of the size of the screen display character string and the screen display field, the specific value is determined from the screen display item definition information in the screen display item definition information file 16 (Q4), otherwise the database item definition in the database item definition information file 17 is determined. A specific value is determined from the information (Q5). After the specific values of all unconfirmed items have been determined, the relevant part of the source program template is replaced with the specific values to generate a compilable source program, which is written into the source program file 19 (Q7).

  In this way, when the source programs for the EDI sites 2b to 2d having different linguistic spheres are written in the source program files 19, the source program automatic creation device 3 supports the source programs via the network 1. Send to each EDI site 2b-2d. As a result, each of the EDI sites 2b to 2d can refer to and update the EDI data transmitted and received by using a source program described in the language of the language area to which it belongs.

  Next, the EDI data conversion device 4 shown in FIG. 20 will be described.

  1 and FIG. 20, a database item definition information file 17 shown in FIG. 8 provided from the source program automatic creation device 3 is stored. Further, in the data storage unit 12, the EDI data of the transmission source described in a predetermined format designating the transmission destination inputted from any EDI sites 2a to 2d via the network 1 is stored in FIG. A received EDI file 27 is provided.

  Further, in the data storage unit 12, as shown in FIG. 23, conversion data definition information such as time zone, daylight saving time, character code, currency unit (base currency), currency rate, etc. is stored for each EDI site 2a to 2d. A conversion data definition information file 29 to be stored is provided.

  Then, the data extraction unit 19 uses the fixed-length transmission source EDI data stored in the reception EDI file 27 as the data length and essentiality of each item in the database item definition information stored in the database item definition information file 17. Using the information, the extracted data divided into data items is generated and written into the extracted data file 28 shown in FIG.

  FIG. 26 is a flowchart for generating extraction data from the EDI data of the transmission source performed by the data extraction unit 10 described above.

  First, information on the target message is acquired from the database item definition information in the database item definition information file 17 based on the message type of the EDI data of the transmission source in the received EDI file 27 (R1). After reading the header information of the EDI data of the transmission source (R2), each data is acquired from the EDI data of the transmission source based on the size information of each data item by the number of data items of the message, and the extracted data file Write to 28 (R3 to R5).

  Next, the data conversion unit 11 uses the converted data definition information such as the time zone, character code, and currency rate for each EDI site stored in the converted data definition information file 29 to extract the data of the extracted data in the extracted data file 28. Is converted, EDI data of the transmission destination of the character code suitable for the transmission destination EDI sites 2a to 2d is created and written into the transmission EDI file 30 shown in FIG. Then, the transmission destination EDI data is transmitted to the transmission destination EDI sites 2 a to 2 d via the network 1.

  A specific example will be described. In this example, the site ID of the source EDI site is “JP001”, and the site ID of the destination EDI site is “EN002”. First, among the extracted data of the extracted data file 28, “0000008186000” represents the estimated answer unit price, the data type is 9 (10) V (3), that is, the integer part 10 digits decimal part 3 digits data, and the data is “ 8186 ”.

  The estimated answer currency is “JPY” in the extracted data, and the estimated answer unit price can be read as 8,186 yen from these. On the other hand, the currency unit of the destination EDI site is USD, and currency conversion is performed from JPY to USD, that is, from Japanese yen to US dollars. The conversion rate at that time is the rate value (JPY, USD, GBP, etc.) of other currencies based on the rate standard of the currency unit in the conversion data definition information file 29 regarding the EDI site “EN001” of the transmission destination. XEU ...) is used.

Therefore, currency conversion is
8186 × 0.009051 ≒ 0.741
Becomes US $ 0.741.

  In consideration of the fact that the destination EDI site requires not only the converted value in the currency unit of the destination EDI site but also the converted value in other currencies, the converted value for other currencies as well Is written in the supplementary information file 31 shown in FIG. 25 as supplementary information together with the currency rate used at that time, and then transmitted together with the supplementary information file 31 to the destination EDI site.

  Next, in the extracted data, “040907” and “14:00” indicate that the response deadline is the sender's time, which is 17:00 on September 7, 2004, and this is the EDI of the destination. Convert to site time. The time zone of the source EDI site and the destination EDI site are JST and MST (Daylight Saving Time MDT), respectively, and if the estimate response is made when daylight saving time is applied, the time difference between MDT and JST is -15 hours. Therefore, the date and time at the destination EDI site will be September 6, 2004, 23:00 (DST).

  FIG. 27 is a flowchart for generating EDI data of a transmission destination from the extracted data performed by the data conversion unit 11 described above.

  The data converter 11 reads the extracted data from the extracted data file 28 (P1), determines whether each data is a conversion target (date data, price data) (P3), and if conversion is not necessary, The data is written as it is to the transmission EDI file 31 (P10).

  When the data is conversion target and date data (P4), it is determined whether the transmission destination site is in the daylight saving time application time (P5). In the case of daylight saving time application time, the daylight saving time zone of the destination EDI site is acquired from the conversion data definition information in the conversion data definition information file 29, and date / time conversion is performed (P6).

  In P5, when the EDI site of the transmission destination is not the daylight saving time application time, the time zone of the normal time is acquired from the conversion data definition information, and the date and time are converted (P7).

  In P4, if the conversion target is price data, the currency rate information and currency unit information of the transmission destination EDI site are acquired from the conversion data definition information, and the price data is acquired from the acquired currency rate information. Convert to site currency unit (P8). Then, the data of the currency rate and the conversion price for each currency is written as supplementary information into the supplementary information file 31 (P9). In any of the above cases, the converted data is written to the transmission destination EDI file 30 (P11).

  When the EDI data conversion apparatus 4 configured as described above receives EDI data designating a transmission destination from each of the EDI sites 2a to 2d in which the “source program” has been written, the amount and currency unit included in the EDI data The time is changed to the amount of money, currency unit, and time at the EDI sites 2a to 2d, and transmitted to the destination EDI sites 2a to 2d.

  Therefore, the person in charge of each EDI site does not need to manually change the amount, currency unit, and time included in the EDI data to the destination amount, currency unit, and time, and the EDI data transmission work efficiency is improved. To do.

  In addition, this invention is not limited to embodiment mentioned above. In the EDI system of the embodiment, the source program automatic creation device 3 and the EDI data conversion device 4 are incorporated in one EDI information conversion device 40. However, it is also possible to connect the source program automatic creation device 3 and the EDI data conversion device 4 individually to the Internet 1 as independent individual devices.

1 is a schematic diagram showing an EDI system in which an EDI information conversion method according to an embodiment of the present invention and an EDI information conversion apparatus to which an EDI information conversion program is applied are incorporated. The block block diagram of the source program automatic creation apparatus in the EDI information conversion apparatus of the embodiment. The block block diagram of the source program automatic creation apparatus of the embodiment similarly. The figure which shows the memory content of the standard EDI message item definition information file formed in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the site information file formed in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the code display definition information file formed in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the screen display item definition information file formed in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the database item definition information file formed in the source program automatic creation apparatus of the embodiment. 6 is a flowchart showing the operation of a data definition creation unit provided in the source program automatic creation device of the embodiment. The figure which shows the memory content of the SQL reserved word definition information file formed in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the HTML tag definition information file formed in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the original source program file formed in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the source program division | segmentation information file formed in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the database logic part information file formed in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the HTML display logic part information file formed in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the other source program information file formed in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the source program template file formed in the source program automatic creation apparatus of the embodiment. The flowchart which shows operation | movement of the source program synthetic | combination part for EDI sites provided in the source program automatic creation apparatus of the embodiment. The figure which shows the memory content of the source program file formed in the source program automatic creation apparatus of the embodiment. The block block diagram of the EDI data converter in the EDI information converter of one Embodiment of this invention. The figure which shows the memory content of the reception EDI file formed in the EDI data converter of the embodiment. The figure which shows the memory content of the extraction data file formed in the EDI data converter of the embodiment. The figure which shows the memory content of the conversion data definition information file formed in the EDI data conversion apparatus of the embodiment. The figure which shows the memory content of the transmission EDI file formed in the EDI data converter of the embodiment. The figure which shows the memory content of the supplementary information file formed in the EDI data converter of the embodiment. The flowchart which shows operation | movement of the data extraction part provided in the EDI data converter of the embodiment. 6 is a flowchart showing the operation of a data conversion unit provided in the EDI data conversion apparatus of the embodiment.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 ... Network, 2a, 2b, 2c, 2d ... EDI site, 3 ... Source program automatic creation apparatus, 4 ... EDI data converter, 5 ... Data definition creation part, 6 ... Original source program division part, 7 ... Source program template Generation unit, 8 ... EDI site source program synthesis unit, 9, 12 ... Data storage unit, 10 ... Data extraction unit, 11 ... Data conversion unit, 13 ... Standard EDI message item definition information file, 14 ... Site information file, 15 Code display definition information file, 16 Screen display item definition information file, 17 Database object definition information file, 18 Source program template file, 19 Source program file, 20 SQL reserved word definition information file, 21 HTML tag Definition information file, 22 ... Original source pro Ram file, 23 ... source program partition information file, 24 ... database logic part information file, 25 ... HTML display logic part information file, 26 ... other source program information file, 27 ... received EDI file, 28 ... extracted data file, 29 ... Conversion data definition information file, 30 ... Send EDI file, 31 ... Supplementary information file, 40 ... EDI information conversion device

Claims (6)

EDI data is transmitted / received between multiple EDI sites in different language spheres, and each EDI site refers to and updates EDI data transmitted / received using a source program written in the language of the language affiliation Item definition means for storing each item described in each language in the screen display part and the database access part included in the source program and EDI data in the system with an item number common to each language, and
Source program template generation means for generating a source program template in which each item described in a belonging language included in a source program already being executed at an arbitrary EDI site incorporated in the EDI system is replaced with the item number;
Corresponding language in which the item number of each item of the source program template generated by the source program template generating means is replaced with the item described in the specified language-speaking language in accordance with the source program generation command specifying the language-speaking region Source program synthesis means for generating a source program for the service area,
An EDI information conversion apparatus comprising: a source program transmission means for transmitting a source program generated by the source program synthesis means to the EDI site in the designated language area. Conversion information storage means for storing conversion information such as a time zone, a character code, a currency unit, a currency rate of an area to which each EDI site of the EDI system belongs;
The EDI data specifying the destination EDI site output from each EDI site of the EDI system is fetched, and the data to be converted is extracted from the EDI data by referring to the items stored in the item definition means Data extraction means to
Data conversion means for converting each data to be converted extracted by this data extraction means into each data in the area to which the EDI site of the transmission destination belongs using the conversion information stored in the conversion information storage means;
2. The EDI information conversion apparatus according to claim 1, further comprising EDI data transmission means for transmitting EDI data in which the data converted by the data conversion means is incorporated to a destination EDI site. EDI data is transmitted / received between multiple EDI sites in different language spheres, and each EDI site refers to and updates EDI data transmitted / received using a source program written in the language of the language affiliation In the system, an item definition step for storing each item described in each language in the screen display part and database access part included in the source program and EDI data with an item number common to each language, and
A source program template generating step for generating a source program template in which each item described in a belonging language included in a source program already being executed at an arbitrary EDI site incorporated in the EDI system is replaced with the item number;
The corresponding language in which the item number of each item of the source program template generated in the source program template generation step is replaced with the item described in the specified language-speaking language in accordance with the source program generation command specifying the language-speaking region A source program synthesis step for generating a source program for the service area;
An EDI information conversion method comprising: a source program transmission step of transmitting the source program generated in the source program synthesis step to the EDI site in the designated language area. A conversion information storage step for storing conversion information such as a time zone, a character code, a currency unit, and a currency rate of an area to which each EDI site of the EDI system belongs;
The EDI data specifying the destination EDI site output from each EDI site of the EDI system is fetched, and the data to be converted is extracted from the EDI data by referring to the items stored in the item definition step A data extraction step to
A data conversion step of converting each data to be converted extracted in this data extraction step into each data of the region to which the EDI site of the transmission destination belongs using the conversion information stored in the conversion information storage step;
4. The EDI information conversion method according to claim 3, further comprising an EDI data transmission step of transmitting EDI data in which the data converted in the data conversion step is incorporated to a destination EDI site. On the computer,
EDI data is transmitted / received between multiple EDI sites in different language spheres, and each EDI site refers to and updates EDI data transmitted / received using a source program written in the language of the language affiliation Item definition means for storing each item described in each language in the screen display part and the database access part included in the source program and EDI data in the system with an item number common to each language, and
Source program template generation means for generating a source program template in which each item described in a belonging language included in a source program already being executed at an arbitrary EDI site incorporated in the EDI system is replaced with the item number;
Corresponding language in which the item number of each item of the source program template generated by the source program template generating means is replaced with the item described in the specified language-speaking language in accordance with the source program generation command specifying the language-speaking region Source program synthesis means for generating a source program for the service area,
An EDI information conversion program for realizing a source program transmitting means for transmitting the source program generated by the source program synthesizing means to the EDI site in the designated language area. On the computer,
Conversion information storage means for storing conversion information such as a time zone, a character code, a currency unit, a currency rate of an area to which each EDI site of the EDI system belongs;
The EDI data specifying the destination EDI site output from each EDI site of the EDI system is fetched, and the data to be converted is extracted from the EDI data by referring to the items stored in the item definition means Data extraction means to
Data conversion means for converting each data to be converted extracted by this data extraction means into each data in the area to which the EDI site of the transmission destination belongs using the conversion information stored in the conversion information storage means;
6. The EDI information conversion program according to claim 5, for realizing EDI data transmission means for transmitting EDI data in which data converted by the data conversion means is incorporated to a destination EDI site.

Images