CN108959202A - Handle the device of non-electronic data switched data - Google Patents
Handle the device of non-electronic data switched data Download PDFInfo
- Publication number
- CN108959202A CN108959202A CN201710369009.3A CN201710369009A CN108959202A CN 108959202 A CN108959202 A CN 108959202A CN 201710369009 A CN201710369009 A CN 201710369009A CN 108959202 A CN108959202 A CN 108959202A
- Authority
- CN
- China
- Prior art keywords
- edi
- macro
- customer data
- data
- user terminal
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
- G06F40/154—Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
- H04L69/08—Protocols for interworking; Protocol conversion
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Artificial Intelligence (AREA)
- Computer Security & Cryptography (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Information Transfer Between Computers (AREA)
Abstract
This disclosure relates to the device for handling non-EDI data, including non-EDI customer data being integrated into the EDI system an of entity and utilizing the non-EDI customer data of EDI network analysis.The device loads customer profile, and for user provides user interface with the relational graph between the EDI data that input in non-EDI customer data and non-EDI data and EDI system, to generate the input of EDI data as EDI system.
Description
Technical field
The present disclosure generally relates to the data exchange between different device, more particularly to it is a kind of for will not be via EDI system
(electronic data interchange system) and the information of inbound is integrated into EDI system and/or handles information is adapted to analysis/statistical
The device of analysis.
Background technique
EDI (electronic data interchange) is to provide the electronic communication side of standard for exchanging data via any electronically
Method.By can even be handed in two different countries according to identical standard, two different companies or tissue electronicly
Exchange of notes part (such as purchase order, bill, shipping note and many other files).Have many EDI standards (including X12EDI,
EDIFACT etc.), some of which solves the needs of specific industry or area.Standard is for making EDI become " stringent format
The machine of message-machine interaction ".It then can be by EDI formal definition are as follows: by the message criteria of agreement, be not necessarily to manual intervention from one
A computer system to another computer system structural data transmitting.
Any means of sender and recipient's agreement can be used to transmit EDI.This includes multiple technologies, including modulation
Demodulator (asynchronous and synchronous), Email (e-mail), File Transfer Protocol (FTP), hypertext transfer protocol (HTTP),
AS1, AS2, AS4 etc..More and more trading partners are used for transmission using network, it is, transmitting EDI text via e-mail
Part.Trading partner can directly interact, or be interacted by intermediaries such as value-added networks (VAN).
EDI file generally comprises identical information, which would generally can be in the papery for identical function of organization
It is found in file.For example, manufacturer tells retailer warehouse to the product of ship using order of the EDI 940 from warehouse to ship.
Usually with " ship arrives " address, " paying party " address and product number (usually Universial Product Code (UPC)) and quantity
List.Another example is the setting of message between the seller and buyer, such as RFQ Request for Quotation (RFQ), respond RFQ bid,
Purchase order, shipping note, receives notice, bill and payment notice at purchase order confirmation.But EDI be not limited to be only
Business data relevant to trade but include all fields, such as medicine (such as patient record and experimental result), transport
(such as container and transit information), engineering and construction etc..
The example of traditional EDI framework is shown with reference to Fig. 1, Fig. 1, for using EDI system respectively between Liang Ge trading company
EDI file is exchanged, there is value-added network (abbreviation VAN) between them.The EDI system of each company includes for receiving EDI text
The communication device of part, for by EDI file translation and being converted into that the format of the insider information system of company oneself can be input to
EDI conversion equipment.
For " outbound " file, the insider information system of EDI system meeting subsidiary company or ERP (Enterprise Resources Planning) output
File (or reading database), and file is converted to the suitable format of translater.Translater (usually translation software) will
" verify " file then to ensure that it meets the standard that trading partner reaches, translating the file into " EDI " format, (it is suitable to increase
Identifier and control structure) and file is sent to trading partner using suitable communication protocol, indirectly via VAN or directly
Use the agreements such as FTP or AS2.
For " inbound " file, EDI system can be received via VAN or directly using agreements such as FTP or AS2 indirectly
EDI file obtains received EDI file, and the trading partner that verifying sends EDI file is effective trading partner, EDI file
Structure meets EDI standard, the respective field of information conversion meets the agreement of agreement.In general, first step be by translater from
Mailbox receives EDI file, will create the file of regular length or variable-length or with the format of XML tag.Next step
It suddenly is conversion/transformed document, translater is by document creation at the lattice for the insider information system or ERP that can be input to company oneself
Formula.This can be made by using custom program, integrated proprietary " mapper " or figure " mapper " based on integration standard
It is realized with the normal data transfer language of such as XSLT.Last step is that the file of conversion is input to the interior of company oneself
Portion's information system.
For example, upper part referring to figs. 2 and 3, for " inbound " process, the translater of company can be IBM Corporation
Product, i.e. Sterling B2B integrator (referred to as SI), will be from the received EDI lattice of EDI mail server/file server
The file of formula, X12, TXT, XML, CSV etc. are converted into SAP IDOC format.Then, the switching software of company, such as SAP
The file of SAP IDOC format is converted into that the internal information system of company oneself can be input to by the product SAP system of AG company
The file of conversion is finally input in the insider information system of company oneself by the format of system.
One very important advantage of EDI system is that trading partner receives the information from EDI file and its is whole
Close the speed of the built-in system of their own.
But considerable trading partner is unwilling to change to EDI platform, then they still send non-EDI file, cause
Their affiliate integrates information slowly and the probability height that malfunctions.
As an example, order is common for the trading partners such as supplier and its client.Order includes purchase
Buy order, modification order and prediction order etc..
Commonly client company has original (based on Excel's) foundation structure, and employee gets used to sending Excel
Order to use EDI system supplier.It is responsible for the people of order, such as Customer Service Representative (referred to as CSR) in supplier
Deng, it has to manual read and the information handled in Excel order and the built-in system for entering information into supplier oneself.
Artificial treatment means inefficient and high-repetition-rate and means high error rate.
Further, since it is very convenient using the hand-held devices such as any PC or mobile phone transmission mail, so many clients
CSR of the order into supplier is sent by mail, this causes to integrate, and information is slow and error rate is high.
In addition, the CSR in supplier will not because client can change order many times by mail or only by phone
It obtains the not information of manual read's mail or records the content of phone, and change these letters in the system of supplier oneself every time
Breath and content.Moreover, they must not often can reflect without recourse to EDI/ research and development department/IT team of themselves company to change
Penetrating (mapping) enables them to change these information.
Regardless of the format of non-EDI order is Excel, other table procedures or mail, or even only from call
Deng needing to be input in the system of supplier oneself, including arrange between client and supplier there are many customer demand of multiplicity
Content/layout/format term and condition.
Increasing in addition, making business analysis/statistical analysis demand using various data.It is input to via EDI system
Data/information in the system of supplier oneself can be readily used for analyze/statistically analyze, without via EDI system
Data/information it is really not so.
Summary of the invention
The selection that summary of the invention in brief introduces concept is provided, is further described through in the description below described
The selection of concept.Summary of the invention is not intended to the key feature or important feature for determining claimed theme.It is intended to be used to limit
Make the range of claimed theme.
In one embodiment, a kind of user terminal is disclosed, for non-EDI customer data to be integrated into an entity
In EDI system, the user terminal includes: processor；Display；And memory, it can be by processor execution for storing
Instruction.The processor is configured to execute: logging on to server；The macro of server offer is provided；By macro, on the subscriber terminal
Create macro local example；Pass through macro reception customer profile data；In macro local example on the subscriber terminal, by macro,
The EDI visitor for obtaining the format of non-EDI customer data and non-EDI customer data and being used by the first EDI system component of EDI system
Relational graph between the format of user data；By macro, EDI customer data is generated based on relational graph and non-EDI customer data；It will
EDI customer data is sent to server, and EDI customer data is integrated into the first EDI component of the EDI system by server.
In another embodiment, a kind of server is disclosed, for non-EDI customer data to be integrated into the EDI of an entity
In system, the server includes: processor；And memory, for storing the instruction that can be executed by processor.The processing
Device is configured to execute: receiving the logging request for carrying out user terminal；The macro of server offer is provided；By macro, in user terminal
The macro local example of upper creation；By macro, reception customer profile data；It, will be objective based on customer profile login ID by described macro
Family file data is loaded into the macro local example on the user terminal from file store；In the user terminal base
After non-EDI customer data generates EDI customer data, EDI customer data is received from the user terminal；And it will be described
EDI customer data is integrated into the first EDI component of EDI system.
In another embodiment, a kind of user terminal is disclosed, for non-EDI customer data to be integrated into an entity
In EDI system comprising: processor；Display；And memory, for storing the instruction that can be executed by processor.The place
Reason device is configured to execute: logging on to server；The macro of the server offer is provided；By it is macro create on the subscriber terminal it is macro
Local example；Macro customer profile data are loaded into from file store by the user terminal based on customer profile login ID by described
On macro local example；Non- EDI customer data and non-EDI client are obtained in the macro local example of user terminal by macro
Relational graph between the format of data and the format of the EDI customer data used by the 2nd EDI component of EDI system；By macro
EDI customer data is generated based on relational graph and non-EDI customer data；And directly the update of non-EDI customer data is arrived by macro
2nd EDI component of EDI system.
In another embodiment, a kind of server is disclosed, for non-EDI customer data to be integrated into the EDI of an entity
In system, server includes: processor；And memory, for storing the instruction that can be executed by processor.Processor is configured to
It executes: receiving the logging request for carrying out user terminal；The macro of server offer is provided；By it is macro create on the subscriber terminal it is macro
Local example；By it is macro based on customer profile login ID customer profile data are loaded into from file store it is macro on user terminal
Local example；After user terminal is based on non-EDI customer data generation EDI customer data, connect by macro from server terminal
Receive EDI customer data；And pass through macro the 2nd EDI component directly EDI customer data updated to EDI system.
In another embodiment, a kind of use for the non-EDI customer data of EDI network analysis using an entity is disclosed
Family terminal comprising: processor；Display；And memory, for storing the instruction that can be executed by processor.Processor is matched
It is set to execution: logging on to server；The macro of server offer is provided；Macro local example is created on the subscriber terminal by macro；
Pass through the macro macro local example based on customer profile login ID being loaded into customer profile data from file store on user terminal；
By the input for receiving non-EDI customer data in the macro macro local example in custom system on user terminal；It is logical
Cross macro generation EDI customer data；And EDI system is sent to using EDI customer data as analysis result by macro.
In another embodiment, the server for disclosing a kind of entity, for non-using the EDI network analysis of an entity
EDI customer data, the server include: processor；And memory, for storing the instruction that can be executed by processor.Place
Reason device is configured to execute: receiving the logging request for carrying out user terminal；The macro of server offer is provided；By macro, at user's end
Macro local example is created on end；By macro, customer profile data are loaded into from file store by use based on customer profile login ID
Macro local example in the terminal of family；And after user terminal is based on non-EDI customer data generation EDI customer data, lead to
It crosses macro be used as from user terminal reception EDI customer data and analyzes result.
It should be understood that above general description and following detailed description are merely exemplary, it is not intended to limit this public affairs
It opens.
Detailed description of the invention
Attached drawing includes in the description and to constitute part of specification, and attached drawing is shown and the consistent implementation of the disclosure
Example, and together with the description for explaining the principles of this disclosure.
Fig. 1 shows the example of traditional EDI framework between Liang Ge trading company.
Fig. 2 shows the examples of the internal network of the company with EDI system.
Fig. 3 show in company's internal network inbound and outbound process how to translate and convert the EDI of different-format
The example of file.
Fig. 4 A is the example of the overall structure block diagram of OAS accoding to exemplary embodiment.
Fig. 4 B is to design in the SAP of EDI system accoding to exemplary embodiment in order to create new purchase order (PO)
The example of the overall structure block diagram of OAS.
Fig. 4 C is in the SAP of EDI system accoding to exemplary embodiment, in order to which order changes (recasting) and confirmation and designs
OAS overall structure block diagram example.
Fig. 4 D is the example of the overall structure block diagram of the OAS designed to make prediction accoding to exemplary embodiment.
Fig. 5 A-5B is user circle of the OAS designed to create new purchase order (PO) accoding to exemplary embodiment
The example in face.
Fig. 6 A-6D be show it is according to the exemplary embodiment of the disclosure in order to create new purchase order (PO) and by user
The flow chart for the step of terminal executes.
Fig. 7 is to show according to the exemplary embodiment of the disclosure to be held to create new purchase order (PO) by server
The flow chart of capable step.
Fig. 8 A-8B is the user for changing the OAS of (recasting) and confirmation and design for order accoding to exemplary embodiment
The example at interface.
Fig. 9 A-9C be show it is according to the exemplary embodiment of the disclosure in order to order change (recasting) and confirm and by with
The flow chart for the step of family terminal executes.
Figure 10 A-10B be show it is according to the exemplary embodiment of the disclosure in order to order change (recasting) and confirm and by
The flow chart for the step of server executes.
Figure 11 A-11B is to show the step according to the exemplary embodiment of the disclosure executed to predict by user terminal
Rapid flow chart.
Figure 12 is the stream for showing the step of being executed to predict by server according to the exemplary embodiment of the disclosure
Cheng Tu.
Figure 13 be show it is according to the exemplary embodiment of the disclosure for non-EDI customer data to be integrated into EDI system
In or using the non-EDI customer data of EDI network analysis device block diagram.
Figure 14 be show it is according to the exemplary embodiment of the disclosure for non-EDI customer data to be integrated into EDI system
In and/or using the non-EDI customer data of EDI network analysis device block diagram.
Specific embodiment
Example embodiments are described in detail here, and the example is illustrated in the accompanying drawings.Following description is related to
When attached drawing, unless otherwise indicated, otherwise the same numbers in different drawings indicate the same or similar elements.In following exemplary
The embodiment illustrated in the description of embodiment does not represent all implementations consistent with this disclosure.On the contrary, they
It is only the example of the device and method consistent with some aspects as detailed in the attached claim, the disclosure.
The disclosure provides a kind of system and method, and being used for will not be via the inbound of EDI system (electronic data interchange system)
Information is integrated into EDI system, or information is made to be suitable for analysis.
It is connect automatically for example, the applying date discloses one kind for No. 091108929 Taiwan Patent application on April 30th, 2002
The order processing method receiving the order data of client and being confirmed by production scheduling situation to order data, generallys include down
It states step: receiving EDI prediction order, EDI prediction order is formatted, generates prediction order data, and prediction is ordered
Single data storage is in data bank；Prediction order data is obtained by access profile library, and confirmation work is carried out to prediction order
Industry；Production scheduling operation is carried out to prediction order, generates production scheduling information, and production scheduling information is stored in data bank
In；It formats to generate official order data, and by official order data storage in data bank；Etc..
It is created in addition, the U.S. Patent Publication of Patent No. US 7,984,373B2 is a kind of according to the description of EDI mode
Build EDI transaction method, specifically include: receive EDI mode description and EDI mode the format for indicating description other
Document, it is received description be non-EDI structuring document；The document of non-EDI structuring is separated with other EDI documents；Know
It does not include multiple data cells in the document of separated non-EDI structuring；The multiple data cells identified are classified
For data type；The multiple data cells classified are to determine the content of EDI mode；Generate the document definition of EDI mode；
And EDI transaction is created according to EDI mode using the document definition of generation.
EDI system in the prior art is only capable of processing EDI file.For the disclosure, be not from the data of EDI file/
Information can be also integrated into EDI system.
In general, EDI data refer to the universal information reference format (for example, X12EDI, EDIFACT etc.) according to agreement
The data for exchanging and automatically processing between electronic computer system via communication network transmission.For example, EDI data can be it is all
Such as the data of PDF, X12, TXT, XML, CSV or the like, but the disclosure is not necessarily limited to this.Non- EDI data refer to not in accordance with about
The data that fixed universal information reference format exchanges between electronic computer system via communication network transmission.For example, non-EDI
Data can be the data from mail or Excel, but the disclosure is not necessarily limited to this.
Using the data/information about order as example, the order of non-EDI file can be integrated into EDI system by the disclosure.
In other words, non-EDI order can be changed to EDI order, then can be input into EDI system.For simplicity, exist
System processing order is referred to as order automated server application program (referred to as OAS) in the disclosure.
But the present disclosure is not limited to processing about the data/information of order and then would be integrated into EDI system,
The disclosure can be applied to processing data/information and then be integrated into any other situation of EDI system.
According to an example, order is divided primarily into two classes-spread order and blanket order.OAS is made of multiple applications, this
Multiple applications keep a variety of order types in the life cycle of entire sales order semi-automatic.Multiple applications include: that creation is ordered
Single, recasting order, acknowledgement of orders, forecast analysis, prediction clearing, prediction recasting and prediction confirmation.
According to an example, in order to implement above-mentioned application, OAS includes that following application is used as part of it:
010_CSV ORDERS to IDOC Macro, for creating order；
020_PO Update and CFM Macro changes (recasting) for order and confirms；
030_SA Macro, for forecast analysis, prediction clearing, prediction recasting and prediction confirmation.
CSR is the end user for handling order/prediction OAS application of client, the result of OAS forecast analysis and fulfils SE
(three-dimensional computer Autocad) is shared to understand/estimate the business needs that & meets client.
OAS application keeps the various demands with non-EDI/ based on spreadsheet from client consistent and integrates them
Into individual tool, and client can be contained and be unwilling to change to EDI platform, therefore OAS is applied and (is based on the original of them
Excel's) foundation structure raising business continuance.
Every time when needing to change, client/CSR can make variation in the map, thus minimize to EDI/ research and development department/
The dependence of IT team.
Since data-driven decision is current business needs, when being related to business analysis/statistical analysis, OAS application
It is the counter-measure for lacking EDI.
In one example, OAS, which is applied, has following one or more features, these features can be by art technology
Personnel are based on actual needs and modify.
Since user/CSR is only capable of seeing macro (Macro), so being single access point for server.
Code is formed only to allow the mode that server application interacts.This plays the role of additional safe floor.
It is easily scalable and understandable for a user.Macro is also backwards-compatible.
The application of the tool, i.e. OAS, it is widely compatible with all enterprises with Microsoft Excel license.
The tool can generate the data entered for EDI.
Since the tool uses the system resource of user rather than the resource of server, the tool is very fast, weight
Light and resource is friendly.
The tool design still is able to that multiple users is made simultaneously to work to it at running in a read-only mode.
The complex logic in macro is directly safeguarded due to user/analyst, so the reference in some OAS application/reflect
Penetrate the standard drawing that feature allows EDI team only to need maintenance sale (SoldTo) degree.
In one example, with reference to/mappings characteristics accommodate 12 operators (include, be equal to, start, end up) and
Most 3 conditions, can any field and an entity in customer data data (such as Molex (not bodyguard) data)
Match.This give user, such as CSR, it is unlimited a possibility that create relational graph.
File store (Profile Bank) on server is used as the knowledge base comprising client requirement information.This removes by
The dependence of any particular customer data of CSR processing.
Replace multiple EDI for each customer demand to scheme, all demands can using single application and directly by with
The file store that family is kept is handled.Which save plenty of time and money, otherwise just need to invest EDI/IT research and development department.
With reference to Fig. 4 A, Fig. 4 A shows the overall structure block diagram of OAS accoding to exemplary embodiment, be substantially Fig. 4 B extremely
010_CSV order is shown respectively to macro (the 010_CSV ORDERS to IDOC of IDOC in the combination of Fig. 4 D, Fig. 4 B to Fig. 4 D
Macro) and 020_PO updates and CFM macro (020_PO Update and CFM Macro) and the macro (030_SA of 030_SA
Macro)。
Above-mentioned three are broad-minded to be placed on server, according to an example, is placed on file server, and above-mentioned
Three macro to be accessed.
Using above-mentioned macro, the EDI system of supplier is able to respond logical by mail or other means in client
The case where crossing the EDI system transmission non-EDI order of supplier integrates non-EDI order.
In one embodiment, OAS processing when client directly transmit non-EDI order to supplier CSR private mailbox of oneself
The case where, either only oral offer order or change existing order the case where.
As naming convention, the target client usually to be sold is used as the logon name that archives or output file create
(LoginId).In the case where a target client to be sold needs multiple customer profile, then logon name can be used
[SoldTo] -1, [SoldTo] -2, [SoldTo] -3 etc..
Archives storage is in the OAS file store that can be located on file server and can use such as CSR_Order_
The titles such as Automation_profiles enter.Customer profile is by the information of all client-awares and logic/mapping with electronic watch
Case form is stored on file store.The main purpose that archives are created for each client is that different clients are configured different/reflected
It penetrates and is loaded into identical application.Archives are usually hiding to user, but have R/W (read/write) privilege and can be only
It is modified by application by load/preservation.The structure of archives is identical as the structure of macro electronic data sheet.Saving archives is that will work as
Preceding movable worksheet is saved into archives catalog.Load archives are by each configuration (" initial (Init) " screen) and from shelves
All data of other tables of case copy to the worksheet of the current active for the particular customer.File name can be <
MacroName>_<LoginId>.xlsm。
Be described in more detail below three it is macro.
With reference to Fig. 4 B, using 010_CSV order to the macro creation come for non-EDI purchase order/determine order of IDOC/from
Dynamicization.
Following label is provided to the macro user terminal for CSR of IDOC with reference to Fig. 5 A and Fig. 5 B, 010_CSV order
(tabs)/screen:
Instruction label/screen
The screen includes the guide for use of tool.CSR can be simply in accordance with the non-EDI for instructing and being provided using client
Data obtain the new order in SAP to be placed in.
Initial labels/screen
The screen includes that the data that provide user are mapped to the data format of supplier (such as to be referred to as Molex general
Data) and required parameter.As an example, Molex general data can be comma separated value (CSV) format.In the screen
Field value can be stored in column B, G and H of screen.Field can generally store two kinds of value:
Default value (DVAL)-this be when client not yet provide data when " CSV order to IDO (CSV ORDER to
IDO) " it is worth used in screen.
First is directed toward the first cell of the column in customer data referring to (the FREE)-field.For example, if " connection
Be the-the first reference of people " value be D2 in " initial " screen, then it refers to client from the Row (row) 2 in " new PO " screen
It enters in the contact data of D column.If referring to FREF, there is priority to DVAL.
Note: the value can be enforceable (red) or washability (black).
In " initial " screen, if 5 enforceable value-marketing teams first, order team, delivery ground, order
Any of type and batch are with multiple values, then corresponding field should keep blank and necessary in " reference " screen
Define relational graph.As an example, user has selection to provide three conditions so that each record matching from customer data is arrived it
It is recorded accordingly in Molex general data.
Referring to label/screen
When same client uses multiple card Nos, delivery ground, paying party, marketing team, buyer, order type and batch
When the screen can be used.It is general each record from client is translated into its corresponding Molex that this create relational graphs
Data.The general data is the standard drawing " FES_CSV-ORDERS_Inbound_Generic " in EDI Sterling integrator
Or the input of " FES_CSV-ORDERS_OneSOPerLine_Inbound_Generic ".Relational graph is directly kept by CSR.
New PO label/screen
It must be placed herein by CSR from the received data of client.
CSV order is to IDOC (CSV ORDERS to IDOC) label/screen
Data of the 010_CSV order to the macro use of IDOC from new PO, initial table and the screen is generated referring to table.?
The data generated in the screen be saved in export folders as csv file and later by mail be sent to SI with
Order is created in system.
Once all mandatory informations are filled automatically/are inputted for the first time by CSR using existing archives, then button is clicked
" prepare CVS order to create new PO in SAP ", and client's proprietary data in " new PO " screen is translated into " CVS is ordered
Single Molex general data in IDOC " screen.
With reference to Fig. 5 A and Fig. 5 B, once the data preparation on " CVS order to IDOC " screen is sent to Sterling integral
Device (SI), then CSR selective value " system update ", clicks button " sending CSV order file as mail " then to send data
To the SI of EDI system.
Fig. 6 A-6D be show it is according to the exemplary embodiment of the disclosure in order to create new purchase order (PO) and by CSR
User terminal execute the step of flow chart.
User terminal can be the intelligent apparatus with universal serial bus (USB), such as smart phone, notebook electricity
Brain, personal digital assistant (PDA) etc..User terminal is by being integrated into one for non-EDI customer data (non-EDI purchase order data)
New EDI purchase order (PO) is created in EDI system in the EDI system of a entity (such as supplier), user terminal includes:
Processor；
Display；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute a method, this method comprises:
Step 101: logging on to server；
Step 103: opening macro (order creation is macro (Order Creation Macro)) that server provides；
Step 105: creating macro local example on the subscriber terminal by macro；
Step 107: passing through the macro data for receiving customer profile；
Step 109: in macro local example on the subscriber terminal, passing through the non-EDI customer data of macro acquisition and non-EDI visitor
Relational graph between the format of user data and the format of EDI customer data, the EDI customer data by EDI system the first EDI group
Part (SI) uses (according to an example, the format of EDI customer data is CSV format, i.e. " Molex general data ")；
Step 111: EDI customer data being generated based on relational graph and non-EDI customer data by macro；
Step 113: sending server for EDI customer data, EDI customer data is integrated into EDI system by server
In first EDI component (SI).
Entity is supplier, and non-EDI customer data is the non-EDI order from mail or Excel, and EDI customer data is
CSV format.
It include: that CSV order is saved in server by macro by the step 113 that EDI customer data is sent to server, clothes
Business device sends CSV order to by mail the first EDI component (SI) of EDI system.
According to an example, macro local example is provided with user interface；Pass through the macro non-EDI customer data and non-of obtaining
The step 109 of relational graph between the format for the EDI customer data that the format of EDI customer data and the first EDI component use is wrapped
It includes:
Step 109-1: the input of user is received, via the INIT screen shown on a user interface to create relational graph；
Step 109-3: non-EDI customer data from the user is received via the new PO screen shown on a user interface
Input；And
Include: by the macro step 111 for generating EDI customer data based on relational graph and non-EDI customer data
Step 111-1: via the CVS order shown on a user interface to IDOC screen, based on relational graph and non-EDI visitor
User data generates CSV order.
According to another example, macro local example is provided with user interface, passes through the macro non-EDI customer data and non-of obtaining
The step 109 of relational graph between the format for the EDI customer data that the format of EDI customer data and the first EDI component use is wrapped
It includes:
Step 109-1 ': receiving the input of user via the INIT screen shown on a user interface, to create non-EDI visitor
The first relational graph between the format of user data and the format of EDI customer data；
Step 109-2 ': if the mandatory field of INIT screen has more than one value, via in user interface
Upper display reference screen receive user input, with create non-EDI customer data format and EDI customer data format it
Between the second relational graph；
Step 109-3 ': the non-EDI customer data of user's input is received via the new PO screen shown on a user interface；
And
By macro, the step of EDI customer data is generated based on the relational graph between non-EDI customer data and EDI customer data
Rapid 111 include:
Step 111-1 ': via the CVS order shown on a user interface to IDOC screen, the first and second relationships are based on
Figure and non-EDI customer data generate CSV order.
According to another example, include: by the macro step 107 for receiving customer profile data
Step 107-1: user is received about the option for using existing customer profile to be configured and be configured manually
Selection；
Step 107-2: whether ready-made customer profile is found in file store；
Step 107-3: if it is, being loaded into data on user terminal from file store based on customer profile login ID
Macro local example；And
Step 107-5: if it is not, then receiving the macro local example that user inputs on the subscriber terminal.
Fig. 7 is to show according to the exemplary embodiment of the disclosure to be held to create new purchase order (PO) by server
The flow chart of capable step.
Server is by being integrated into an entity (such as supplier) for non-EDI customer data (non-EDI purchase order data)
EDI system in and new EDI purchase order (PO) is created in EDI system, server includes:
Processor；
Display；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute a method, this method comprises:
Step S201: the logging request for carrying out user terminal is received；
Step S203: it opens macro (order creation is macro) that server provides；
Step S205: by macro, macro local example is created on the subscriber terminal；
Step S207: by macro, customer profile data are loaded into from file store by user's end based on customer profile login ID
Macro local example on end；
Step S209: after user terminal is based on non-EDI customer data generation EDI customer data, by macro, reception is used
The EDI customer data of family terminal；
Step S211: EDI customer data is integrated into the first EDI component (SI) of EDI system.
With reference to Fig. 4 C, 020_PO updates and the macro recasting/confirmation for non-EDI purchase order/determine order of CFM.
020_PO updates and the macro user terminal for CSR of CFM provides following screen:
Init label/screen
The screen includes for parameter needed for mapping the data and Molex SAP system data of client's offer.Field value
It can be stored in column B, G and H of screen.Note: value can be (black) of enforceable (red) or washability.
Screen is divided into four parts:
1) control reference: the part includes the major parameter that can make using the output demand for understanding user.
According to an example, the field found under the part is:
VA02 is updated using SO#? (Yes/No)-uses SO# if it is, SAP updates, otherwise using PO# and
SoldTO。
Order-is prevented to can choose CSR to apply or remove the transmitting for all rows that it wants to update in SAP prevention.
2) client opens backlog reference: the part includes column instruction/reference to client's backlog data.
For example, it is the first PO value " A2 " that field, which will include in customer data, if user provides PO# in " A " column.
3) Molex backlog reference: the part includes column instruction/reference for Molex backlog.Example
Such as, if Molex SAP data extract (extract) has PO# in " A " column, field, which will be included in Molex data, is
" A2 " of first PO value.
4) client opens backlog reference before: the part includes to refer to the column of client's backlog data last week
Show/reference.For example, it is the first PO value that field, which will be included in customer data, if user provides PO# in " A " column
" A2 ".
Molex opens backlog label/screen
The real data presented in Molex SAP for client is extracted by CSR.
Client opens backlog label/screen
It must be placed herein by CSR from the received data of client.
Client opens backlog label/screen before
Last week must be placed herein from the received data of client by CSR.Label/the screen is selectable.
VA02 label/screen
This can be macro output but is not required.Once " execution " button is clicked, then will generate on the screen
Data update to SAP.
Steps are as follows.Load customer profile.By with it is all other it is macro it is identical in a manner of load archives.
Nearest one week available data on " client open backlog " screen is copied to that " client beats before by CSR
Open backlog " screen, but not is necessary.
Non- EDI customer data is input in " client opens backlog " screen by CSR.
CSR extracts the available data for being used for client in " Molex opens backlog " screen from SAP.
With reference to Fig. 8 A, all information needed-client that CSR inputs all parts about " initial " screen, which opens, not to be completed
Order reference, control reference, the reference of Molex backlog and client's opening backlog reference before are (in presentation data
And in the case where having the business needs for analysis in PO confirmation).
Once completing all of above step, CSR clicks " PO changes macro " on initial screen and/or clicks " PO later
Confirm macro " button.This starts PO change and/or subsequent PO confirmation executes.According to further example, pivot is generated
Table (Pivot table).It is opened in backlog screen in client and completes all analyses and update mark.Analysis and
After update mark, and their own Molex record matching and meets the client of standard selected in initial screen and beat
These arrows opened in backlog are moved to VA02, to update in SAP.
With reference to Fig. 8 B, once CSR clicks the executive button on VA02 screen, if existing SAP session is open,
Upgrading purchase order/sales order script is performed in SAP.If the corresponding SAP session being not turned on application to
It makes mistake.After updating SAP to all table rows in VA02 screen, control, which returns to, has the application of successfully/inspection message.
Fig. 9 A-9C be show it is according to the exemplary embodiment of the disclosure in order to order change (recasting) and confirm and by
The flow chart for the step of user terminal of CSR executes.
User terminal can be the intelligent apparatus with universal serial bus (USB), such as smart phone, notebook electricity
Brain, personal digital assistant (PDA) etc..User terminal is by being integrated into one for non-EDI customer data (non-EDI purchase order data)
Implement order in the EDI system of a entity to change (recasting) and confirm.
Order creation above can be implemented in user terminal and order described below changes (recasting) and confirmation.
User terminal includes:
Processor；
Display；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute a method, this method comprises:
Step 301: logging on to server；
Step 303: opening macro (order changes and confirms macro) that server provides；
Step 305: creating macro local example on the subscriber terminal by macro；
Step 307: by macro, customer profile data being loaded into from file store by user terminal based on customer profile login ID
On macro local example；
Step 309: in macro local example on the subscriber terminal, by macro, obtaining non-EDI customer data and non-EDI
Relationship between the format of customer data and the format of the EDI customer data used by the 2nd EDI component (SAP) of EDI system
Figure；
Step 311: by macro, EDI customer data being generated based on relational graph and non-EDI customer data；
Step 313: by macro, EDI customer data directly being updated to the 2nd EDI component (SAP) to EDI system.
By macro, the step 313 for directly updating EDI customer data includes:
Step 313-1: by macro, open and be connected to the second of the EDI system of the insider information system of supplier oneself
The session (SAP session) of EDI component.
Step 313-2: by macro, directly EDI customer data is changed or is confirmed the 2nd EDI component of EDI system
(SAP)。
The EDI visitor used by the format and the 2nd EDI component of the non-EDI customer data of macro acquisition and non-EDI customer data
The step 309 of relational graph between the format of user data includes:
Step 309-1: the input of user is received, via the INIT screen shown on a user interface to create relational graph；
Step 309-3: via the opening backlog screen shown on a user interface, (Molex is opened not completing and be ordered
The EDI customer data of existing EDI order singly) is received from the 2nd EDI component (SAP)；
Step 309-5: backlog screen is opened via the client shown on a user interface and receives non-EDI client's number
According to；And
Include: by the macro step 311 for generating EDI customer data based on relational graph and non-EDI customer data
Step 311-1: macro or PO is changed by PO on INIT screen and confirms macro, executes EDI customer data to correspond to
Change or confirms.
Figure 10 A-10B be show it is according to the exemplary embodiment of the disclosure in order to order change (recasting) and confirm and by
The flow chart for the step of server executes.
Order creation above can be implemented in server and order described below changes (recasting) and confirmation.
Server includes:
Processor；
Display；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute a method, this method comprises:
Step 401: receiving the logging request for carrying out user terminal；
Step 403: opening macro (order changes and confirms macro) that server provides；
Step 405: by macro, creating macro local example on the subscriber terminal；
Step 407: by macro, customer profile data being loaded into from file store by user terminal based on customer profile login ID
On macro local example；
Step 409: after user terminal is based on non-EDI customer data generation EDI customer data, by macro, reception comes
The EDI customer data of user terminal；
Step 411: by macro, directly updating EDI customer data into the 2nd EDI component of EDI system.
Include: by the step of macro direct update EDI customer data
Step 411-1: by macro, open and be connected to the second of the EDI system of the insider information system of supplier oneself
The session (SAP session) of EDI component；And
Step 411-3: by macro, directly EDI customer data is changed or is confirmed the 2nd EDI component of EDI system.
With reference to Fig. 4 D, 030_SA macro (prediction) be used for make forecast analysis, clearing, management, non-EDI batch SA order promise
Automation.Its tendency for being analyzed, being tracked client proposes the plan with quantity and finally upload the data to SAP.
Figure 11 A-11B is to show according to the exemplary embodiment of the disclosure to be executed to predict order by user terminal
The step of flow chart.
Order creation above can be implemented in user terminal, order changes (recasting) and confirms and described below pre-
It surveys.
User terminal includes:
Processor；
Display；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute a method, this method comprises:
Step 501: logging on to server；
Step 503: opening macro (SA is macro) that server provides；
Step 505: creating macro local example on the subscriber terminal by macro；
Step 507: customer profile data being loaded into from file store by user terminal based on customer profile login ID by macro
On macro local example；
Step 509: in the macro local example in custom system, passing through the non-EDI client of macro reception on user terminal
The input of data；
Step 511: passing through macro generation EDI customer data；
Step 513: being sent to EDI system for EDI customer data as analysis result by macro.
Included the following steps by the macro step 513 for sending EDI system as analysis result for EDI customer data
At least one:
Step 513-1: EDI customer data is saved in server by macro；And
Step 513-3: pass through macro the 2nd EDI component (SAP) for directly sending EDI customer data to EDI system.
Figure 12 be show it is according to the exemplary embodiment of the disclosure in order to predict order and be executed by server the step of
Flow chart.
Order creation, order change (recasting) and confirmation and prediction described below above can be implemented in server.
Server includes:
Processor；
Display；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute a method, this method comprises:
Step 601: receiving the logging request for carrying out user terminal；
Step 603: opening macro (SA is macro) that server provides；
Step 605: by macro, creating the macro local example on the subscriber terminal；
Step 607: by macro, customer profile data being loaded into from file store by user terminal based on customer profile login ID
On macro local example；
Step 609: after user terminal is based on non-EDI customer data generation EDI customer data, by macro, reception comes
The EDI customer data of user terminal.
Referring to Fig.1 3, device 1300 can be the user terminal included one or more of the following components: processing component 1302,
Memory 1304, multimedia component 1308, audio component 1310, input/output (I/O) interface 1312, passes power supply module 1306
Sensor component 1314 and communication component 1316.
The integrated operation of the usual control device 1300 of processing component 1302, such as with display, call, data communication,
Camera operation and record operate associated operation.Processing component 1302 may include one or more processors 1320 to execute
Instruction, to perform all or part of the steps of the methods described above.In addition, processing component 1302 may include one or more moulds
Block, convenient for the interaction between processing component 1302 and other assemblies.For example, processing component 1302 may include multi-media module,
To facilitate the interaction between multimedia component 1308 and processing component 1302.
Memory 1304 is configured as storing various types of data to support the operation in device 1300.These data
Example include the instruction of any application or method for being operated on device 1300, contact data, telephone book data,
Message, picture, video etc..Memory 1304 can by any kind of volatibility or non-volatile memory device or they
Combination realize, as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), it is erasable can
Program read-only memory (EPROM), programmable read only memory (PROM), read-only memory (ROM), magnetic memory, flash memory
Reservoir, disk or CD.
Power supply module 1306 provides electric power for the various assemblies of device 1300.Power supply module 1306 may include power management
System, one or more power supply and any other associated group is generated, managed, and distributed with the electric power in device 1300
Part.
Multimedia component 1308 includes that the screen of output interface is provided between device 1300 and user.In some embodiments
In, screen may include liquid crystal display (LCD) and touch panel (TP).If screen includes touch panel, screen can be with
It is implemented as touch screen, to receive input signal from the user.Touch panel includes one or more touch sensors to feel
Survey the gesture on touch, slide, and touch panel.The touch sensor can not only sense the boundary of a touch or slide action,
But also detect duration and pressure associated with the touch or slide operation.In some embodiments, multimedia component
1308 include front camera and/or rear camera.When equipment 1300 is in operation mode, such as screening-mode or video mode
When, front camera and/or rear camera can receive external multi-medium data.Each front camera and postposition camera shooting
Head can be fixed optical lens system or have focusing and optical zoom capabilities.
Audio component 1310 is configured as output and/or input audio signal.For example, audio component 1310 includes microphone
(MIC), when device 1300 is in operation mode, when such as call mode, recording mode, and voice recognition mode, microphone is configured
To receive external audio signal.The received audio signal can be further stored in memory 1304 or via communication set
Part 1316 is sent.In some embodiments, audio component 1310 further includes the loudspeaker for output audio signal.
I/O interface 1312 provides the interface between processing component 1302 and peripheral interface module, above-mentioned peripheral interface module
It can be keyboard, click wheel, button etc..These buttons may include, but are not limited to: home button, volume button, start button and
Locking press button.
Sensor module 1314 includes one or more sensors, and the state for providing various aspects for device 1300 is commented
Estimate.For example, sensor module 1314 can detecte equipment 1300 open/close state, the component of device 1300 (such as is shown
Device and keypad) relative positioning, the position change of component of device 1300 or device 1300, user contact with device 1300
The temperature change of existence or non-existence, the orientation of device 1300 or acceleration/deceleration and device 1300.Sensor module 1314 can be with
Including proximity sensor, it is configured to detect the presence of nearby objects in the case where no any physical contact.Sensing
Device assembly 1314 can also include optical sensor, such as CMOS or ccd image sensor, for using in imaging applications.One
In a little embodiments, which can also include acceleration transducer, gyro sensor, Magnetic Sensor, pressure
Sensor or temperature sensor.
Communication component 1316 is configured to facilitate the communication of wired or wireless way between device 1300 and other equipment.Dress
The wireless network based on communication standard can be accessed by setting 1300, such as WiFi, 2G, 3G or 4G cellular technology or their combination.?
In one exemplary embodiment, communication component 1316 receives the broadcast singal from external broadcasting management system via broadcast channel
Or broadcast related information.In one exemplary embodiment, communication component 1316 further includes near-field communication (NFC) module, to promote
Into short range communication.For example, radio frequency identification (RFID) technology, Infrared Data Association (IrDA) technology, ultra-wide can be based in NFC module
It is realized with (UWB) technology, bluetooth (BT) technology and other technologies.
In the exemplary embodiment, device 1300 can use one or more application specific integrated circuit (ASIC), number
Signal processor (DSP), digital signal processing appts (DSPD), programmable logic device (PLD), field programmable gate array
(FPGA), controller, microcontroller, microprocessor or other electronic components are realized, for executing the above method.
In the exemplary embodiment, a kind of non-transitorycomputer readable storage medium including instruction, example are additionally provided
It such as include the memory 1304 of instruction, above-metioned instruction can be executed by the processor 1320 of device 1300 to complete the above method.Example
Such as, the non-transitorycomputer readable storage medium can be ROM, random access memory (RAM), CD-ROM, tape, soft
Disk and optical data storage devices etc..
Figure 14 is the block diagram of another device 400 according to the exemplary embodiment of the disclosure for suggesting being wirelessly connected.
For example, device 1400 can be server.With reference to Figure 14, device 1400 includes processing component 1422, which further includes
One or more processors and the storage resource indicated by memory 1432 are used to storing and can be executed by processing component 1422
Instruction, such as application program.The application program being stored in memory 1432 may include one or more modules, each module
Corresponding one group of instruction.Moreover, processing component 1422 is configured to execute instruction to execute for non-EDI customer data to be integrated into
In EDI system and/or with the above method of the non-EDI customer data of EDI network analysis.
Device 1400 can also include be configured to executive device 1400 power management power supply module 1426, be configured to by
Device 1400 is connected to the network interface 1450 and input/output (I/O) interface 1478 of network or another device.Device
1400 can be run based on the operating system stored in memory, for example, Windows ServerTM, Mac OS XTM,
UnixTM, LinuxTM, FreeBSDTM etc..
It should be understood that the present invention is not limited to the precise structure already described above and shown in the accompanying drawings, and
And various modifications and changes may be made without departing from the scope thereof.The scope of the present invention is only limited to the appended claims.
Claims (20)
1. a kind of user terminal, for non-EDI customer data to be integrated into the EDI system an of entity, the user terminal
Include:
Processor；
Display；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute:
Log on to server；
The macro of server offer is provided；
By described macro, the macro local example is created on the user terminal；
By described macro, the data of customer profile are received；
In the macro local example on the user terminal, by described macro, non-EDI customer data and non-EDI are obtained
Relationship between the format of customer data and the format of the EDI customer data used by the first EDI component of the EDI system
Figure；
By macro, EDI customer data is generated based on the relational graph and the non-EDI customer data；And
The server is sent by the EDI customer data, the EDI customer data is integrated into described by the server
In the first EDI component of EDI system.
2. user terminal as described in claim 1, wherein
The entity is supplier, and the non-EDI customer data is the non-EDI order from mail or Excel, the EDI visitor
User data is CSV order.
3. user terminal as claimed in claim 2, wherein sending the server for the EDI customer data includes:
By it is described it is macro the CSV order is saved in the server, the server is sent out the CSV order by mail
It is sent to the first EDI component of the EDI system.
4. user terminal as claimed in claim 3, wherein
The macro local example is provided with user interface；
It is used by the macro format for obtaining non-EDI customer data and the non-EDI customer data and the first EDI component
EDI customer data format between relational graph include:
Via the INIT screen shown in the user interface, the input of user is received, to create the relational graph；
Via the new PO screen shown in the user interface, the non-EDI customer data of user's input is received；And
It include: via described by the macro relational graph and the non-EDI customer data generation EDI customer data of being based on
The CVS order shown in user interface is to IDOC screen, based on described in the relational graph and the non-EDI customer data generation
CSV order.
5. user terminal as claimed in claim 3, wherein
The macro local example is provided with user interface；
It is used by the macro format for obtaining non-EDI customer data and the non-EDI customer data and the first EDI component
Relational graph between the format of EDI customer data includes:
Via the INIT screen shown in the user interface, the input of user is received, to create the non-EDI customer data
Format and EDI customer data format between the first relational graph；
If the mandatory field of the INIT screen has more than one value, via what is shown in the user interface
Referring to screen, the input of user is received, to create between the format of the non-EDI customer data and the format of EDI customer data
The second relational graph；
Via the new PO screen shown in the user interface, the non-EDI customer data of user's input is received；And
EDI client's number is generated by the macro relational graph based between the non-EDI customer data and the EDI customer data
According to including: CVS order by being shown in the user interface to IDOC screen, based on first relational graph and described the
Two relational graphs and the non-EDI customer data generate the CSV order.
6. user terminal as described in claim 1, wherein described to include: by the macro data for receiving customer profile
User is received about the selection of option for using existing customer's archives to be configured and be configured manually；
If finding ready-made customer profile in file store, it is based on customer profile login ID, data are loaded from file store
The macro local example on to the user terminal；And
If not finding ready-made customer profile in file store, the input of user is received on the user terminal
The macro local example.
7. a kind of server, for non-EDI customer data to be integrated into the EDI system an of entity, the server includes:
Processor；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute:
Receive the logging request for carrying out user terminal；
The macro of the server offer is provided；
By described macro, the macro local example is created on the user terminal；
By described macro, customer profile data are loaded on the user terminal from file store based on customer profile login ID
The macro local example；
It is based on after non-EDI customer data generates EDI customer data in the user terminal, by described macro, receives the use
The EDI customer data of family terminal；And
The EDI customer data is integrated into the first EDI component of EDI system.
8. server as claimed in claim 7, wherein
The entity is supplier, and the non-EDI customer data is the non-EDI order from mail or Excel, the EDI visitor
User data is CSV order.
9. server as claimed in claim 8, wherein the EDI customer data is integrated into EDI system includes:
The CSV order is sent to by mail the first EDI component of the EDI system.
10. a kind of user terminal, for non-EDI customer data to be integrated into the EDI system an of entity, the user terminal
Include:
Processor；
Display；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute:
Log on to server；
The macro of the server offer is provided；
By described macro, the macro local example is created on the user terminal；
By described macro, customer profile data are loaded on the user terminal from file store based on customer profile login ID
The macro local example；
By described macro, in the macro local example on the user terminal, non-EDI customer data and non-is obtained
Relational graph between the format of EDI customer data and the format of the EDI customer data used by the 2nd EDI component of EDI system；
By described macro, EDI customer data is generated based on the relational graph and the non-EDI customer data；And
By described macro directly by EDI customer data update into the 2nd EDI component of the EDI system.
11. user terminal as claimed in claim 10, wherein
The entity is supplier；And
It macro directly update the EDI customer data by described and includes:
By described macro, the session of opening and the 2nd EDI component of the EDI system, the EDI system is connected to described
The insider information system of supplier oneself；And
By described macro, directly the EDI customer data is changed or is confirmed the 2nd EDI component of the EDI system.
12. user terminal as claimed in claim 11, wherein
The macro local example is provided with user interface；
Pass through the macro format and the 2nd EDI component for obtaining the non-EDI customer data and the non-EDI customer data
Relational graph between the format of the EDI customer data used includes:
Via the INIT screen shown in the user interface, the input of user is received, to create the relational graph；
Via the opening backlog screen shown in the user interface, existing EDI is received from the 2nd EDI component
The EDI customer data of order；
Via the opening backlog screen shown in the user interface, the non-EDI customer data is received；And
By described macro, generating EDI customer data based on the relational graph and the non-EDI customer data includes: via in institute
Stating PO on INIT screen, to change macro or PO confirmation macro, to correspond to the change or confirmation that execute EDI customer data.
13. a kind of server, for non-EDI customer data to be integrated into the EDI system an of entity, the server packet
It includes:
Processor；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute:
Receive the logging request for carrying out user terminal；
The macro of the server offer is provided；
By described macro, the macro local example is created on the user terminal；
By described macro, customer profile data are loaded on the user terminal from file store based on customer profile login ID
The macro local example；
After the user terminal is based on the non-EDI customer data generation EDI customer data, by described macro, from
The user terminal receives EDI customer data；And
By described macro, directly the EDI customer data is updated into the 2nd EDI component of EDI system.
14. server as claimed in claim 13, wherein
The entity is supplier；And
It macro directly update the EDI customer data by described and includes:
By described macro, the session of opening and the 2nd EDI component of the EDI system, the EDI system is connected to supplier certainly
Oneself insider information system；And
By described macro, the EDI customer data is directly changed or is confirmed the 2nd EDI component.
15. a kind of user terminal, using the non-EDI customer data of the EDI network analysis of an entity, the user terminal includes:
Processor；
Display；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute:
Log on to server；
The macro of the server offer is provided；
Macro macro local example is created on the user terminal by described；
By described macro, customer profile data are loaded on the user terminal from file store based on customer profile login ID
The macro local example；
By described macro on the user terminal, in the macro local example in the custom system, receive
The non-EDI customer data of input；
Pass through the macro generation EDI customer data；And
By it is described it is macro using the EDI customer data as analysis result be sent to EDI system.
16. user terminal as claimed in claim 15, wherein
The entity is supplier, and the non-EDI customer data is non-EDI batch SA order, and the EDI customer data is CSV
Format.
17. user terminal as claimed in claim 16, wherein by described macro, tied the EDI customer data as analysis
Fruit is sent to EDI system and at least one of includes the following steps:
By described macro, the EDI customer data is saved in the server；And
By described macro, directly it sends the EDI customer data to the 2nd EDI component of the EDI system.
18. a kind of server, for the non-EDI customer data of EDI network analysis using an entity, the server includes:
Processor；And
Memory, for storing the instruction that can be executed by processor；
Wherein the processor is configured to execute:
Receive the logging request for carrying out user terminal；
The macro of server offer is provided；
By macro, macro local example is created on the subscriber terminal；
By described macro, customer profile data are loaded on the user terminal from file store based on customer profile login ID
The macro local example；And
After the user terminal is based on non-EDI customer data generation EDI customer data, by described macro, from the user
Terminal receives EDI customer data as analysis result.
19. server as claimed in claim 18, wherein
The entity is supplier, and the non-EDI customer data is the non-EDI order from mail or Excel, the EDI visitor
User data is CSV format.
20. server as claimed in claim 19, wherein by described macro from user terminal reception EDI client's number
Further include at least one of following step after as analysis result:
By described macro, the EDI customer data is sent in mail, which will issue client by user；
By described macro, the non-EDI customer data is automatically extracted in the report of the main fluctuation in shared platform；And
By described macro, the EDI customer data is received to the first EDI component of the EDI system；
By described macro, directly the EDI customer data is uploaded in the 2nd EDI component of the EDI system.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710369009.3A CN108959202B (en) | 2017-05-23 | 2017-05-23 | Device for processing non-electronic data exchange data |
| TW106120352A TWI651949B (en) | 2017-05-23 | 2017-06-19 | Device and server for processing non-electronic data exchange data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710369009.3A CN108959202B (en) | 2017-05-23 | 2017-05-23 | Device for processing non-electronic data exchange data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108959202A true CN108959202A (en) | 2018-12-07 |
| CN108959202B CN108959202B (en) | 2023-02-14 |
Family
ID=64462679
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710369009.3A Active CN108959202B (en) | 2017-05-23 | 2017-05-23 | Device for processing non-electronic data exchange data |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN108959202B (en) |
| TW (1) | TWI651949B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110825797A (en) * | 2019-10-25 | 2020-02-21 | 烨链（上海）科技有限公司 | Data exchange method and device |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5202977A (en) * | 1990-07-13 | 1993-04-13 | Premenos Corp. | Edi translation system using plurality of communication processes and de-enveloping procedure corresponding to transmitted communication process |
| US20070203928A1 (en) * | 2006-02-24 | 2007-08-30 | Microsoft Corporation | EDI instance based transaction set definition |
| US20080222517A1 (en) * | 2007-03-09 | 2008-09-11 | Task Performance Group, Inc. | Applying Patterns to XSD for Extending Functionality to Both XML and non-XML Data Data Structures |
| US20080294645A1 (en) * | 2007-05-22 | 2008-11-27 | Sybase, Inc. | System, method and computer program product for EDI-to-EDI translations |
| US20130070276A1 (en) * | 2005-09-02 | 2013-03-21 | Ecmarket Inc. | Method and system for exchanging business documents |
| US20140222712A1 (en) * | 2013-02-01 | 2014-08-07 | Sps Commerce, Inc. | Data acquisition, normalization, and exchange in a retail ecosystem |
| US20140237353A1 (en) * | 2011-09-23 | 2014-08-21 | Ecmarket Inc. | Systems, methods and articles to automatically transform documents transmitted between senders and recipients |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5758126A (en) * | 1996-03-19 | 1998-05-26 | Sterling Commerce, Inc. | Customizable bidirectional EDI translation system |
| TWI571747B (en) * | 2011-10-28 | 2017-02-21 | Ｌｘｍ公司 | Data interchange system |
| CN103996105A (en) * | 2014-06-13 | 2014-08-20 | 上海珉智信息科技有限公司 | Image file electronic data management system |
-
2017
- 2017-05-23 CN CN201710369009.3A patent/CN108959202B/en active Active
- 2017-06-19 TW TW106120352A patent/TWI651949B/en active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5202977A (en) * | 1990-07-13 | 1993-04-13 | Premenos Corp. | Edi translation system using plurality of communication processes and de-enveloping procedure corresponding to transmitted communication process |
| US20130070276A1 (en) * | 2005-09-02 | 2013-03-21 | Ecmarket Inc. | Method and system for exchanging business documents |
| US20070203928A1 (en) * | 2006-02-24 | 2007-08-30 | Microsoft Corporation | EDI instance based transaction set definition |
| US20080222517A1 (en) * | 2007-03-09 | 2008-09-11 | Task Performance Group, Inc. | Applying Patterns to XSD for Extending Functionality to Both XML and non-XML Data Data Structures |
| US20080294645A1 (en) * | 2007-05-22 | 2008-11-27 | Sybase, Inc. | System, method and computer program product for EDI-to-EDI translations |
| US20140237353A1 (en) * | 2011-09-23 | 2014-08-21 | Ecmarket Inc. | Systems, methods and articles to automatically transform documents transmitted between senders and recipients |
| US20140222712A1 (en) * | 2013-02-01 | 2014-08-07 | Sps Commerce, Inc. | Data acquisition, normalization, and exchange in a retail ecosystem |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110825797A (en) * | 2019-10-25 | 2020-02-21 | 烨链（上海）科技有限公司 | Data exchange method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| TWI651949B (en) | 2019-02-21 |
| CN108959202B (en) | 2023-02-14 |
| TW201902184A (en) | 2019-01-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Langley et al. | The platform political economy of FinTech: Reintermediation, consolidation and capitalisation | |
| US11886693B2 (en) | System and method for application program interface or page processing | |
| TWI730524B (en) | Identity authentication method, device and system | |
| US8738454B2 (en) | Transferring digital receipt data to mobile devices | |
| US9092773B2 (en) | Generating and categorizing transaction records | |
| CN103065211B (en) | For the method and apparatus providing Enterprise Resources Planning function from e-mail | |
| US20150088676A1 (en) | Point of sale normalization and extension services | |
| Falcone et al. | Supply chain technologies, interorganizational network and firm performance: A case study of Alibaba Group and Cainiao | |
| US9842333B2 (en) | Transferring digital receipt data to mobile devices | |
| KR101996798B1 (en) | Method for providing qr code based payments service | |
| CN105096156A (en) | Content providing system, server, and program | |
| CN109859415B (en) | Library system and method thereof | |
| US9591611B2 (en) | Apparatus and method for providing interaction service for kids, system using the same | |
| AU2017326638B2 (en) | Thing machine | |
| US20120316993A1 (en) | Method and system for pricing and exchange of streams of data stored on tags readable by electronic means, streams of data in digital messages, and streams of data from electronic devices | |
| US20120158583A1 (en) | Automated bank transfers using identifier tokens | |
| Sung et al. | Internet of Things–based smart home system using a virtualized cloud server and mobile phone app | |
| KR20130017676A (en) | Server for supplying private goods management function and trading second hand goods function and system for second hand goods trading using the same | |
| KR102374035B1 (en) | System for providing business-to-busniess based online wholesale distribution management service | |
| CN102930401A (en) | Technology providing enterprise resource planning (ERP) function from customer relation management (CRM) client side application | |
| TW200844881A (en) | System for matching transaction of intellectual property with self-searching, self-enlarge and amending classification characters and method of the same | |
| CN108959202A (en) | Handle the device of non-electronic data switched data | |
| KR20170092516A (en) | Cyber bigdata trade system and method | |
| KR102212628B1 (en) | Tangiable asset management system and method established to improve companywide asset management | |
| US20150088764A1 (en) | One-stop comprehensive product warranty computerized management system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |