CN101350074A - Method for comparing and recording product number simultaneously - Google Patents
Method for comparing and recording product number simultaneously Download PDFInfo
- Publication number
- CN101350074A CN101350074A CNA2007100441038A CN200710044103A CN101350074A CN 101350074 A CN101350074 A CN 101350074A CN A2007100441038 A CNA2007100441038 A CN A2007100441038A CN 200710044103 A CN200710044103 A CN 200710044103A CN 101350074 A CN101350074 A CN 101350074A
- Authority
- CN
- China
- Prior art keywords
- identification symbol
- data
- input
- write down
- database
- 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.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a method for comparing and recording product numbers simultaneously, in particular to a method for comparing the product numbers, which is used to guarantee that the product numbers are input into a system correctly, and the method for comparing at least comprises: inputting the product numbers to a data management program manually. The method also comprises: inputting the product numbers, then, comparing the product numbers which are input with a data base by the data management program, wherein the data base is provided with the product numbers of all products, displaying that a correct result is input by the data management program when the product numbers which are input exist in the data base, simultaneously, recording the correct result into the system, but displaying that an error result is input by the data management program when the product numbers which are input do not exist in the data base, and simultaneously recording the error result into the system. The method can judge whether the product numbers which are input are correct or not in time, personnel who input the product numbers can adopt modified actions immediately, the method can guarantee that the product numbers can be input into the system correctly, and the product numbers can be a serial number.
Description
Technical field
The present invention relates to the method that a kind of identification symbol is compared simultaneously and write down, particularly relating to a kind of being applied in the identification symbol loading routine compares and record simultaneously, can guarantee that identification symbol correctly inputs in the system, taken place when in time finding the input product serial number wrong and can revising immediately can avoid saving the method that the identification symbol of follow-up compares simultaneously and write down of makeing mistakes fully.
Background technology
When a product turnout when the market is started selling, portioned product can be retracted in the shipment factory because of various factors unavoidably.Because to product requirement attractive in appearance or be subject to product size, for example the surface of portable electric device can't print additional bar code, so only sequence number can be engraved on the shell of product with very little font.After product is return, problematic product is carried out before the process step of subsequent detection, need be with the sequence number input of each problematic product, in order to the keyholed back plate of subsequent product in testing process.The sequence number of each product (a for example electronic product) is as importing in the mode (for example bar code) of autoscan input, then must use the mode of artificial input, each product serial number is inputed to data, and (data is data, information, below all be called data) in the middle of the management system, because the font of sequence number is very little, sequence number itself has comprised English alphabet and numeral again, do not know so usually when artificial input, make a mistake, for example 0 and 0,2 and Z, 1 and 1 be exactly the input error of normal generation.
Seeing also shown in Figure 1ly, is the process flow diagram of existing known return of goods sequence number input.Existing known product testing process mainly may further comprise the steps: at first manually import return of goods sequence number (step 102) by the entry personnel.The sequence number of being imported then is recorded in the middle of the system, and according to the product serial number of input problematic product is detected, with the place of finding problem and reparation may (step 104).The mistake (for example, the word of misplaying) of product serial number input generally all will arrive after testing process begins, and just might be found.At this moment, this product must be taken out, again with artificial input sequence number, the testing result of deleting original sequence number and having carried out is restarted testing process (step 106).If the product serial number input is wrong undiscovered, the testing staff then can't so will cause the management system confusion with testing result and problematic product correspondence, and effort is consuming time on subsequent treatment, thereby consumes many times and energy.
This shows that above-mentioned existing product testing process obviously still has inconvenience and defective, and demands urgently further being improved in detection method and use.In order to solve the problem of above-mentioned existence, relevant manufacturer there's no one who doesn't or isn't seeks solution painstakingly, but do not see always that for a long time suitable design finished by development, and general detection method does not have appropriate method to address the above problem, this obviously is the problem that the anxious desire of relevant dealer solves.Therefore, how to found the method that a kind of new identification symbol is compared simultaneously and write down, whether the product serial number that can in time judge input is correct, and make the personnel that import product serial number can take the action of revising immediately, real one of the current important research and development problem that belongs to, also becoming the current industry utmost point needs improved target.
Because the defective that above-mentioned existing product testing process exists, the inventor is based on being engaged in this type of product design manufacturing abundant for many years practical experience and professional knowledge, and the utilization of cooperation scientific principle, actively studied innovation, in the hope of founding the method that a kind of new identification symbol is compared simultaneously and write down, can improve general existing product testing process, make it have more practicality.Through constantly research, design, and after studying repeatedly and improving, create the present invention who has practical value finally.
Summary of the invention
The objective of the invention is to, overcome the defective that existing product testing process exists, and the method that provides a kind of new identification symbol to compare simultaneously and write down, technical matters to be solved is to make it can guarantee that identification symbol correctly inputs in the system, this identification symbol can be very suitable for practicality for a sequence number.
The object of the invention to solve the technical problems realizes by the following technical solutions.A kind of identification symbol comparison method according to the present invention's proposition, be in order to guarantee that an identification symbol correctly inputs in the system, this comparison method comprises following step at least: receive an identification symbol by a data administrator (program is a formula, below all be called program); In a database, compare this identification symbol and produce a comparison result; When this comparison result when being present in this database, this data administrator shows that then input is correct, and writes down this comparison result simultaneously for correctly to this system; And when this comparison result when not being present in this database, this data administrator then shows input error, and write down simultaneously this comparison result for wrong to this system.
The object of the invention to solve the technical problems also can be applied to the following technical measures to achieve further.
Aforesaid identification symbol comparison method, wherein said product are hand-held electronic installations.
Aforesaid identification symbol comparison method, wherein said data administrator are the huge collection application software of data.
Aforesaid identification symbol comparison method, the huge collection application software of wherein said data are the Excel of a Microsoft (Microsoft) application software.
Aforesaid identification symbol comparison method, the wherein said method of comparing this identification symbol in this database are included in and search this identification symbol in the tables of data.
Aforesaid identification symbol comparison method, wherein said tables of data are that return of goods are authorized (ReturnMerchandise Authorization) tables of data.
Aforesaid identification symbol comparison method, wherein said tables of data are that return of goods are authorized temporary transient tables of data.
Aforesaid identification symbol comparison method, show that wherein this comparison result comprises: when the identification symbol of input is confirmed to be present in this database after comparing, this data administrator promptly provides the product relevent information, and when the identification symbol of input was confirmed not to be present in this database after comparing, this data administrator promptly provided the message of an input error.
Aforesaid identification symbol comparison method, the message of wherein said input error are to represent to change Show Color.
Aforesaid identification symbol comparison method, wherein said identification symbol are product serial numbers.
The present invention compared with prior art has tangible advantage and beneficial effect.As known from the above, for achieving the above object, the method that foundation identification symbol provided by the invention is compared simultaneously and write down, at least comprise that manual input identification symbol is to data administrator, data administrator is then compared to the identification symbol of being imported in a database with all identification symbols, and shows comparison result.This data administrator can be Microsoft Excel.The data management function that in the program of Microsoft Excel, has Visual Basic for Applications (VBA).Input method is manually to import sequence number singly to data administrator.Through after the data administrator comparison, the entry personnel can learn immediately whether the sequence number of input exists in the database, and the data of being imported can be recorded in the system simultaneously, and can be with data query and record data by the data administrator synchronization.
By technique scheme, the method that identification symbol of the present invention is compared simultaneously and write down has following advantage and beneficial effect at least: the present invention can guarantee correct the inputing in the system of identification symbol, and identification symbol can be a sequence number.Therefore, the present invention is connected by data administrator and database, the mistake that is taken place when the entry personnel can in time find to import product serial number, and can revise immediately.Identification symbol comparison method of the present invention can be reduced to 0 with the error rate of identification symbol input, can avoid saving the follow-up that makes mistakes fully, is very suitable for practicality.
In sum, the present invention is the method that relevant a kind of identification symbol is compared simultaneously and write down, method for a kind of identification symbol is compared simultaneously and write down correctly inputs in the system in order to guarantee identification symbol, and this comparison method comprises that at least manual input identification symbol is to data administrator.After the identification symbol input, the identification symbol that data administrator is promptly compared and imported with database, wherein database has the identification symbol of all products.When the identification symbol of input was present in the database, data administrator then showed the correct result of input, and writes down correct result simultaneously to system.Yet when the identification symbol of input was not present in this database, data administrator showed the input error result, and while misregistration result is to system.
The present invention can guarantee that identification symbol correctly inputs in the system, this identification symbol can be a sequence number, by being connected of data administrator and database, the mistake that is taken place when the entry personnel can in time find to import product serial number, and can revise immediately, the error rate of identification symbol input can be reduced to 0, can avoid saving the follow-up that makes mistakes fully.The present invention has above-mentioned plurality of advantages and practical value, no matter it all has bigger improvement on method or function, obvious improvement is arranged technically, and produced handy and practical effect, and more existing product testing process has the outstanding effect of enhancement, thereby being suitable for practicality more, really is a new and innovative, progressive, practical new design.
Above-mentioned explanation only is the general introduction of technical solution of the present invention, for can clearer understanding technological means of the present invention, and can be implemented according to the content of instructions, and for above-mentioned and other purposes, feature and advantage of the present invention can be become apparent, below especially exemplified by preferred embodiment, and conjunction with figs., be described in detail as follows.
Description of drawings
Fig. 1 is the process flow diagram that existing known return of goods sequence number is imported.
Fig. 2 is the identification symbol comparison process flow diagram that illustrates method one embodiment that compares simultaneously and write down according to a kind of identification symbol of the present invention.
Fig. 3 is that the data administrator that illustrates method one embodiment that compares simultaneously and write down according to a kind of identification symbol of the present invention is imported the system flowchart that data are judged.
202: step 204: step
206: step 208 step
210 step 302 steps
304 step 306 steps
308 step 310 steps
312 steps
Embodiment
Reach technological means and the effect that predetermined goal of the invention is taked for further setting forth the present invention, below in conjunction with accompanying drawing and preferred embodiment, its embodiment of method, method, step, feature and effect thereof that a kind of identification symbol that foundation the present invention is proposed is compared simultaneously and write down, describe in detail as after.
Seeing also shown in Figure 2ly, is the identification symbol comparison process flow diagram that illustrates method one preferred embodiment of comparing simultaneously and writing down according to identification symbol of the present invention.The identification symbol comparison flow process of the method that the identification symbol of a preferred embodiment of the present invention is compared simultaneously and write down is applicable to that identification symbol is to be imported under the demand of identification symbol by manual work.The product that embodiment provided of the method that identification symbol of the present invention is compared simultaneously and write down can be a kind of hand-hold electronic device, for example mobile phone, GPS navigation system, MP3 player, PDA(Personal Digital Assistant) or the like.The volume of above-mentioned hand-hold electronic device is little, and external form all passes through the design of moulding, and bar code can influence whole visual aesthetic feeling in the printing, so can add product serial number in more unconspicuous position when dispatching from the factory.When a collection of hand-hold electronic device is return because flaw or existing problems are arranged, the sequence number of each electronic installation must be by inputing to manually in the system, with data such as the shipment information (information data) that obtains this electronic installation, Product Status, and then enter testing process.
See also shown in Figure 2ly, the method that the identification symbol of preferred embodiment of the present invention is compared simultaneously and write down mainly may further comprise the steps:
At first, import number to a data administrator (step 202) of hand-held electronic installation to be measured by the entry personnel.This data administrator is the number (step 204) of comparison hand-hold electronic device in a database then.Whether the number that can judge the hand-hold electronic device of being imported after comparison wrong (step 206).At last, when the identification symbol of input when being present in the database, data administrator then shows the correct result of input, and this correct result of record (step 208) to this system simultaneously.When the identification symbol of input was not present in the database, data administrator then showed the input error result, and while misregistration result (step 210) to system.
The number of the present invention's hand-hold electronic device described herein can be sequence number or any code name in order to the identification hand-hold electronic device of hand-hold electronic device.The sequence number of this hand-hold electronic device can be imported in the data administrator with keyboard, button or the mode that clicks by the entry personnel.At this moment, data administrator compares the product serial number of input and the product serial number in the database via linking to database.The correct sequence number that has product in the database described here.Therefore, when the product serial number of input and the product serial number in the database when not being inconsistent, data administrator can judge that then the product serial number of being imported is wrong.After getting the wrong sow by the ear, data administrator then display reminding information is given the entry personnel, informs that the product serial number of being imported is wrong.So, the entry personnel can in time make an amendment the product serial number of input.
The described data administrator of present embodiment can be a huge collection application software of data, for example Excel of Microsoft (Microsoft) application software.Excel has the function of Visual Basic for Applications (VBA), can utilize this function to reach the purpose of present embodiment comparison product serial number.The ExcelVBA user that can leave chooses the data (for example in the data bank all product serial number) of a set product number, and the built-in Data Processing function of sharp VBA, and the function made by oneself of user, searches and the data of record product number.
For example, seeing also shown in Figure 3ly, is that the data administrator that illustrates method one embodiment that compares simultaneously and write down according to identification symbol of the present invention is imported the system flowchart that data are judged.The data administrator of present embodiment is imported the system that data are judged, mainly may further comprise the steps: the entry personnel can inquire about the interface input hand-hold electronic device sequence number of (step 302) in sequence number.After the input of hand-hold electronic device sequence number, search hand-hold electronic device sequence number (step 304) in the tables of data that Microsoft Excel VBA is then set up in database, whether be present in the tables of data to assert the hand-hold electronic device sequence number of being imported.This tables of data can be that return of goods are authorized (Return MerchandiseAuthorization) tables of data.If the product serial number of being imported is to be present in the return of goods authorization data table, data administrator then shows the relevent information (step 306) of product.If the product serial number of being imported is not present in the return of goods authorization data table, data administrator is then to another tables of data, for example return goods and authorize in the temporary transient tables of data, search the product serial number of being imported (step 308), and whether definite hand-hold electronic device is present in the temporary transient tables of data of mandate of returning goods.As search product serial number in the temporary transient tables of data of mandate of returning goods, data administrator then shows the relevent information of product and replenishes prompting, for example sequence number shown (step 310) with anti-Huang.Be not present in as the product serial number of being imported and return goods authorize in the temporary transient tables of data, data administrator then shows miscue, for example with sequence number with anti-red demonstration (step 312).
Utilize the function of Microsoft Excel VBA, the user all can inquire about different hand-hold electronic device related datas in Excel VBA.For example can in Excel VBA, add the batch query function that hand-hold electronic device is abused (Abuse), help the user can more fully understand the keyholed back plate of hand-hold electronic device.
In addition, by the function of Excel VBA, the data of being imported can be recorded in data administrator simultaneously, that is in the middle of the system.Because recorded data is confirmed through the inquiry comparison, so the data of synchronous recording will be for entirely true.
Therefore, by being connected of data administrator and database, the mistake that is taken place when the entry personnel can in time find to import product serial number, and can revise immediately.The identification symbol comparison method of present embodiment can be reduced to 0 with the error rate of identification symbol input, can avoid saving the follow-up that makes mistakes fully.
The above, it only is preferred embodiment of the present invention, be not that the present invention is done any pro forma restriction, though the present invention discloses as above with preferred embodiment, yet be not in order to limit the present invention, any those skilled in the art, in not breaking away from the technical solution of the present invention scope, when the technology contents that can utilize above-mentioned announcement is made a little change or is modified to the equivalent embodiment of equivalent variations, in every case be not break away from the technical solution of the present invention content, according to technical spirit of the present invention to any simple modification that above embodiment did, equivalent variations and modification all still belong in the scope of technical solution of the present invention.
Claims (10)
1, a kind of identification symbol method of comparing simultaneously and writing down is in order to guaranteeing that an identification symbol correctly inputs in the system, it is characterized in that this comparison method comprises following steps at least:
Receive an identification symbol by a data administrator;
In a database, compare this identification symbol and produce a comparison result;
When this comparison result when being present in this database, this data administrator shows that then input is correct, and writes down this comparison result simultaneously for correctly to this system; And
When this comparison result when not being present in this database, this data administrator then shows input error, and write down simultaneously this comparison result for wrong to this system.
2, the identification symbol according to claim 1 method comparing simultaneously and write down is characterized in that wherein said product is a hand-held electronic installation.
3, the identification symbol according to claim 1 method comparing simultaneously and write down is characterized in that wherein said data administrator is the huge collection application software of data.
4, the identification symbol according to claim 3 method comparing simultaneously and write down is characterized in that the huge collection application software of wherein said data is the Exce l of a Microsoft application software.
5, the identification symbol according to claim 1 method comparing simultaneously and write down, it is characterized in that wherein said in this database the method for this identification symbol of comparison be included in and search this identification symbol in the tables of data.
6, the identification symbol according to claim 5 method comparing simultaneously and write down is characterized in that wherein said tables of data is a return of goods authorization data table.
7, the identification symbol according to claim 5 method comparing simultaneously and write down is characterized in that wherein said tables of data is one to return goods and authorize temporary transient tables of data.
8, the identification symbol according to claim 1 method comparing simultaneously and write down, it is characterized in that wherein showing that this comparison result comprises when the identification symbol of input is confirmed to be present in this database after comparing, this data administrator promptly provides the product relevent information, and when the identification symbol of input was confirmed not to be present in this database after comparing, this data administrator promptly provided the message of an input error.
9, the identification symbol according to claim 8 method comparing simultaneously and write down, the message that it is characterized in that wherein said input error are to represent to change Show Color.
10, the identification symbol according to claim 1 method comparing simultaneously and write down is characterized in that wherein said identification symbol is a product serial number.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100441038A CN101350074A (en) | 2007-07-20 | 2007-07-20 | Method for comparing and recording product number simultaneously |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100441038A CN101350074A (en) | 2007-07-20 | 2007-07-20 | Method for comparing and recording product number simultaneously |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101350074A true CN101350074A (en) | 2009-01-21 |
Family
ID=40268856
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2007100441038A Pending CN101350074A (en) | 2007-07-20 | 2007-07-20 | Method for comparing and recording product number simultaneously |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101350074A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105335427A (en) * | 2014-08-08 | 2016-02-17 | 阿里巴巴集团控股有限公司 | Input box state presentation method and apparatus |
| CN106648566A (en) * | 2015-10-30 | 2017-05-10 | 北京国双科技有限公司 | Input content check method and apparatus |
-
2007
- 2007-07-20 CN CNA2007100441038A patent/CN101350074A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105335427A (en) * | 2014-08-08 | 2016-02-17 | 阿里巴巴集团控股有限公司 | Input box state presentation method and apparatus |
| CN106648566A (en) * | 2015-10-30 | 2017-05-10 | 北京国双科技有限公司 | Input content check method and apparatus |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107204184B (en) | Audio recognition method and system | |
| CN107291783B (en) | Semantic matching method and intelligent equipment | |
| CN110909548A (en) | Chinese named entity recognition method and device and computer readable storage medium | |
| TWI736535B (en) | Information input method, device and smart terminal | |
| CN101876878A (en) | Word prediction input system and method | |
| CN108595519A (en) | Focus incident sorting technique, device and storage medium | |
| CN110020422A (en) | The determination method, apparatus and server of Feature Words | |
| CN106528759B (en) | The information processing method and device of intelligent Answer System | |
| CN103200293A (en) | Method of automatically combining tautonomy contacts in process of guiding contacts into contact list | |
| CN109358766A (en) | The progress of handwriting input is shown | |
| CN112328761A (en) | Intention label setting method and device, computer equipment and storage medium | |
| CN110489424A (en) | A kind of method, apparatus, storage medium and the electronic equipment of tabular information extraction | |
| CN111552704A (en) | Data report generation method and device, computer equipment and storage medium | |
| CN114595686A (en) | Knowledge extraction method, and training method and device of knowledge extraction model | |
| CN112395390A (en) | Training corpus generation method of intention recognition model and related equipment thereof | |
| CN105894072B (en) | Quick Response Code mixing generation system | |
| CN107783953A (en) | Information input method and terminal device | |
| CN107451036A (en) | Input reminding method, device and equipment | |
| CN101893960B (en) | Direction vector-based character recognition method and device | |
| CN103971679A (en) | Linkman voice searching method and device and mobile terminal | |
| CN110134721A (en) | Data statistical approach, device and electronic equipment based on bitmap | |
| JP2012199871A (en) | Information terminal device, information display method and information display program | |
| CN101350074A (en) | Method for comparing and recording product number simultaneously | |
| CN105912723A (en) | Storage method of custom field | |
| CN113360685A (en) | Method, device, equipment and medium for processing note content |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20090121 |