CN110489251A - A kind of anti-weighing method of data importing, equipment and system based on information system - Google Patents
A kind of anti-weighing method of data importing, equipment and system based on information system Download PDFInfo
- Publication number
- CN110489251A CN110489251A CN201910752208.1A CN201910752208A CN110489251A CN 110489251 A CN110489251 A CN 110489251A CN 201910752208 A CN201910752208 A CN 201910752208A CN 110489251 A CN110489251 A CN 110489251A
- Authority
- CN
- China
- Prior art keywords
- data
- identifying code
- data file
- information system
- file
- 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
- 238000000034 method Methods 0.000 title claims abstract description 54
- 238000005303 weighing Methods 0.000 title claims abstract description 18
- 230000008676 import Effects 0.000 claims abstract description 77
- 238000004590 computer program Methods 0.000 claims description 6
- 238000004364 calculation method Methods 0.000 claims 1
- 238000012545 processing Methods 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 11
- 230000006870 function Effects 0.000 description 10
- 230000008569 process Effects 0.000 description 10
- 230000006872 improvement Effects 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 230000008439 repair process Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 239000000470 constituent Substances 0.000 description 1
- 239000013078 crystal Substances 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 229920001296 polysiloxane Polymers 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 239000010979 ruby Substances 0.000 description 1
- 229910001750 ruby Inorganic materials 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/004—Error avoidance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Human Resources & Organizations (AREA)
- General Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Databases & Information Systems (AREA)
- Computer Security & Cryptography (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides that a kind of data based on information system import anti-weighing method, the data based on information system import anti-heavy equipment, system, computer equipment and computer readable storage medium, is related to technical field of data processing.The described method includes: obtaining the data file imported by information system；It is read from the data file and reports and submits the phase time；Phase time acquisition from the information system is reported and submitted to prestore identifying code according to described；Data importing is carried out according to the data file and the identifying code that prestores.The present invention, which can be avoided practitioner and mislead during currently report and submit, reported and submitted data into a upper phase, causes covering or the rollback of reporting and submitting data to the current period, causes great convenience to the work of business personnel.
Description
Technical field
The present invention is about technical field of data processing, especially with regard to the leading-in technique of data of information system, concretely
Be a kind of data based on information system import anti-weighing method, the data based on information system import anti-heavy equipment, information system,
Computer equipment and computer readable storage medium.
Background technique
Background that this section is intended to provide an explanation of the embodiments of the present invention set forth in the claims or context.Herein
Description recognizes it is the prior art not because not being included in this section.
Currently, managing the needs for closing rule with the increasingly complexity of financial industry supervision environment in order to meet, each finance machine
Structure all have developed in succession for customer information, Transaction Information, account information acquisition and report and submit system.It is reported and submitted to meet information
Timeliness requirement, in specific operation process, practitioner need by means of EXCEL complete big data quantity data record
Enter operation, is then introduced into and reports and submits in system to carry out subsequent data examination & approval and report and submit process.
In above-mentioned operation process, it often will appear practitioner and misled reporting and submitting into a upper phase during currently reporting and submitting
Data cause covering or rollback that data are reported and submitted to the current period.
Therefore, a kind of new scheme how is provided, being able to solve above-mentioned technological deficiency is this field skill urgently to be resolved
Art problem.
Summary of the invention
In view of this, the present invention provides a kind of, the data based on information system import anti-weighing method, are based on information system
Data import anti-heavy equipment, information system, computer equipment and computer readable storage medium, obtain the number of importing first
According to file, the phase time is reported and submitted in reading, reports and submits phase time acquisition from the information system to prestore identifying code according to described, works as data file
Identifying code and prestore timestamp and unanimously then allow to import, it is inconsistent, refuse to import, so avoid practitioner and working as
Before report and submit during mislead and reported and submitted data into a upper phase, covering or rollback that data are reported and submitted to the current period are caused, to business personnel's
Work causes great convenience.
To achieve the goals above, the data based on information system that the present invention provides a kind of import anti-weighing method, described
Method includes:
Obtain the data file imported by information system；
Read that the data file is corresponding to report and submit phase time from the data file；
Phase time acquisition from the information system is reported and submitted to prestore identifying code according to described；
Data importing is carried out according to the data file and the identifying code that prestores.
In a preferred embodiment of the invention, the data file is EXCEL file, including customer information, account are believed
Breath and Transaction Information.
In a preferred embodiment of the invention, it is described prestore identifying code by the information system according to report and submit phase time according to
Preset operation rule is generated and is recorded.
In a preferred embodiment of the invention, it is led according to the data file and the identifying code progress data that prestore
Enter and includes:
Read the identifying code stored in the file attribute of the data file；
Compare the identifying code and it is described prestore identifying code, obtain comparison result；
Data importing is carried out according to the comparison result.
In a preferred embodiment of the invention, carrying out data importing according to the comparison result includes:
When the comparison result show the identifying code and prestore identifying code it is consistent when, record the data file；
Load the data file.
In a preferred embodiment of the invention, carrying out data importing according to the comparison result includes:
When the comparison result show the identifying code and prestore identifying code it is inconsistent when, export prompting message, it is described
Prompting message downloads newest user logging for reminding from the information system.
It is an object of the invention to provide a kind of, and the data based on information system import anti-heavy equipment, comprising:
Data file obtains module, for obtaining the data file imported by information system；
Phase time read module is reported and submitted, reports and submits the phase time for reading from the data file；
It prestores identifying code and obtains module, prestore verifying for reporting and submitting the phase time to obtain according to from the information system
Code；
Data import modul, for carrying out data importing according to the data file and the identifying code that prestores.
In a preferred embodiment of the invention, the data import modul includes:
Identifying code read module, the identifying code stored in the file attribute for reading the data file；
Identifying code comparison module obtains comparison result for comparing the identifying code and prestoring identifying code；
Data file import modul, for carrying out data importing according to the comparison result.
In a preferred embodiment of the invention, the mark data file import modul includes:
Data file module, for showing the identifying code and to prestore identifying code consistent when the comparison result
When, record the data file；
Data file loading module, for loading the data file.
In a preferred embodiment of the invention, the data file import modul includes:
Prompting message output module, for showing the identifying code and to prestore identifying code inconsistent when the comparison result
When, prompting message is exported, the prompting message downloads newest user logging for reminding from the information system.
It is an object of the invention to provide a kind of information systems, import including a kind of data based on information system anti-
Heavy equipment.
It is an object of the invention to provide a kind of computer equipment, including memory, processor and it is stored in storage
On device and the computer program that can run on a processor, the processor realize that one kind is based on when executing the computer program
The data of information system import anti-weighing method.
It is an object of the invention to provide a kind of computer readable storage medium, the computer-readable storage medium
Matter, which is stored with, executes a kind of anti-weighing method of data importing based on information system.
The beneficial effects of the present invention are provide a kind of data based on information system and import anti-weighing method, based on letter
The data of breath system import anti-heavy equipment, information system, computer equipment and computer readable storage medium, obtain lead first
Phase time is reported and submitted in the data file entered, reading, reports and submits the phase time to obtain from the information system to prestore identifying code according to described, when testing
Demonstrate,proving code and prestoring timestamp unanimously then allows to import, inconsistent, refuses to import, so avoids practitioner and report currently
It is misled during sending and reported and submitted data into a upper phase, covering or the rollback of reporting and submitting data to the current period are caused, to the work of business personnel
Cause great convenience.
For above and other objects, features and advantages of the invention can be clearer and more comprehensible, preferred embodiment is cited below particularly,
And cooperate institute's accompanying drawings, it is described in detail below.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
It obtains other drawings based on these drawings.
Fig. 1 is the structural representation that a kind of data based on information system provided in an embodiment of the present invention import anti-heavy equipment
Figure；
Fig. 2 is that a kind of data based on information system provided in an embodiment of the present invention import data importing mould in anti-heavy equipment
The structural schematic diagram of block；
Fig. 3 is that data file is led in a kind of anti-heavy equipment of data importing based on information system provided in an embodiment of the present invention
Enter the structural schematic diagram of the embodiment one of module；
Fig. 4 is that data file is led in a kind of anti-heavy equipment of data importing based on information system provided in an embodiment of the present invention
Enter the structural schematic diagram of the embodiment two of module；
Fig. 5 is the flow chart that a kind of data based on information system provided in an embodiment of the present invention import anti-weighing method；
Fig. 6 is the flow chart of the step S104 in Fig. 5；
Fig. 7 is the flow chart of the embodiment one of the step S203 in Fig. 6；
Fig. 8 is the flow chart of the embodiment two of the step S203 in Fig. 6；
Fig. 9 is to carry out data in specific embodiment provided by the invention to import anti-heavy flow diagram.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
Those skilled in the art will understand that embodiments of the present invention can be implemented as a kind of system, device, method or
Computer program product.Therefore, disclose can be with specific implementation is as follows by the present invention, it may be assumed that complete hardware, complete software
The form that (including firmware, resident software, microcode etc.) or hardware and software combine.
In the prior art, with the increasingly complexity of financial industry supervision environment, the needs for closing rule are managed in order to meet, it is each
Financial institution all have developed in succession for customer information, Transaction Information, account information acquisition and report and submit system.In order to meet letter
The requirement for ceasing the timeliness reported and submitted, in specific operation process, practitioner needs to complete big data quantity by means of EXCEL
Data inputting operation, is then introduced into and reports and submits in system to carry out subsequent data examination & approval and report and submit process.
In above-mentioned operation process, it often will appear practitioner and misled reporting and submitting into a upper phase during currently reporting and submitting
Data cause covering or rollback that data are reported and submitted to the current period.
Based on this, the present invention provides a kind of information system, the information system includes information system ontology and one kind
Data based on information system import anti-heavy equipment.In the present invention, information system ontology refers to information in the prior art
The all constituents of system.A kind of number based on information system that information system provided by the invention includes is introduced below
According to the anti-heavy equipment of importing.
Fig. 1 is the structural representation that a kind of data based on information system provided in an embodiment of the present invention import anti-heavy equipment
Figure, referring to Fig. 1, the equipment includes:
Data file obtains module 100, for obtaining the data file imported by information system.
In one embodiment of the invention, the data file is EXCEL file, including customer information, account are believed
Breath and Transaction Information.
In one embodiment of the invention, the source of data file is generally as follows: practitioner is first from information system
The data to amended record are exported in system into EXCEL file, to complete to customer information, account information, the increasing newly of Transaction Information, repair
Change, delete etc. and filling up work.Complete it is current report and submit the amended record of data after, using EXCEL file as data file import information
System.
In one embodiment of the invention, data file can also source it is as follows: practitioner's maloperation will mend in the past
The EXCEL file recorded is as data file import information system.
Phase time read module 200 is reported and submitted, reports and submits the phase time for reading from the data file.
In one embodiment of the invention, the data file is EXCEL file, describes report in EXCEL file
Send the phase time.
It prestores identifying code and obtains module 300, tested for reporting and submitting the phase time to obtain to prestore from the information system according to
Demonstrate,prove code.
In one embodiment of the invention, prestore identifying code by the information system according to report and submit phase time according to default
Operation rule generate and record.Specifically, system reports and submits the phase time to give birth to respectively according to certain operation rule, according to different
At identifying code with uniqueness and it is recorded in system.Practitioner exports when the data of amended record to EXCEL file, automatically
It obtains and currently reports and submits identifying code with uniqueness corresponding to the phase and be written in the file attribute of EXCEL file.
Data import modul 400, for carrying out data importing according to the data file and the identifying code that prestores.
Fig. 2 is the structural schematic diagram of data import modul 400 in the embodiment of the present invention, referring to Fig. 2, the data import
Module 400 includes:
Identifying code read module 410, the identifying code stored in the file attribute for reading the data file.
In one embodiment of the invention, practitioner's export obtains automatically when the data of amended record to EXCEL file
It takes and currently reports and submits identifying code with uniqueness corresponding to the phase, and be written in the file attribute of EXCEL file.
Identifying code comparison module 420 obtains comparison result for comparing the identifying code and prestoring identifying code；
Data file import modul 430, for carrying out data importing according to the comparison result.
Fig. 3 is the structural schematic diagram of the embodiment one of data file import modul 430 in the embodiment of the present invention, is please referred to
Fig. 3, in embodiments of the present invention one, the data file import modul 430 includes:
Modification time logging modle 431, for when the comparison result shows the identifying code and prestores identifying code one
When cause, the data file is recorded；
Data file loading module 432, for loading the data file.
Fig. 4 is the structural schematic diagram of the embodiment two of data file import modul 430 in the embodiment of the present invention, is please referred to
Fig. 4, in embodiments of the present invention two, the data file import modul 430 further include:
Prompting message output module 433, for when the comparison result shows the identifying code and prestores identifying code not
When consistent, prompting message is exported, the prompting message downloads newest user logging for reminding from the information system.
That is, in the present invention, equipment reads importing data film, and reads the identifying code of data file, then be
The identifying code that prestores stored in system compares, and unanimously then allows to import, system log data file, data are loaded onto report and submit are
System；It is inconsistent, refuse to import, and practitioner is reminded to download newest user logging in systems, and carry out based on this
It is imported after amended record.
It as above is that a kind of data based on information system provided by the invention import anti-heavy system and equipment, for every
A that the phase time is reported and submitted to generate unique identifying code, practitioner chooses the record to amended record in systems and exports to EXCEL file
When, this identifying code is recorded in this document attribute and is not easy arbitrarily to be distorted, and is imported after this reports and submits the phase time to complete data amended record
System, system verify the consistency of the identifying code recorded in the identifying code and EXCEL file of storage automatically, are consistent, allow to lead
Enter, be not inconsistent, refuse to import, and prompt to download newest user logging and carry out amended record based on this, so avoids working
Personnel mislead during currently reporting and submitting and reported and submitted data into a upper phase, cause covering or rollback that data are reported and submitted to the current period, give industry
The work of business personnel causes great convenience.
In addition, although being referred to several unit modules of system in the above detailed description, it is this to divide only simultaneously
Non-imposed.In fact, embodiment according to the present invention, the feature and function of two or more above-described units can
To embody in a unit.Equally, the feature and function of an above-described unit can also be served as reasons with further division
Multiple units embody.Terms used above " module " and " unit ", can be realize predetermined function software and/or
Hardware.Although module described in following embodiment is preferably realized with software, the group of hardware or software and hardware
The realization of conjunction is also that may and be contemplated.
The data based on information system for describing exemplary embodiment of the invention import anti-heavy system, equipment it
Afterwards, next, being introduced with reference to method of the attached drawing to exemplary embodiment of the invention.The implementation of this method may refer to
Whole implementation is stated, overlaps will not be repeated.
Fig. 5 is the process signal that a kind of data based on information system provided in an embodiment of the present invention import anti-weighing method
Figure, referring to Fig. 5, this method comprises:
S101: the data file imported by information system is obtained.
In one embodiment of the invention, the data file is EXCEL file, including customer information, account are believed
Breath and Transaction Information.
In one embodiment of the invention, the source of data file is generally as follows: practitioner is first from information system
The data to amended record are exported in system into EXCEL file, to complete to customer information, account information, the increasing newly of Transaction Information, repair
Change, delete etc. and filling up work.Complete it is current report and submit the amended record of data after, using EXCEL file as data file import information
System.
In one embodiment of the invention, data file can also source it is as follows: practitioner's maloperation will mend in the past
The EXCEL file recorded is as data file import information system.
S102: it is read from the data file and reports and submits the phase time.
In one embodiment of the invention, the data file is EXCEL file, describes report in EXCEL file
Send the phase time.
S103: phase time acquisition from the information system is reported and submitted to prestore identifying code according to described.
In one embodiment of the invention, prestore identifying code by the information system according to report and submit phase time according to default
Operation rule generate and record.Specifically, system reports and submits the phase time to give birth to respectively according to certain operation rule, according to different
At identifying code with uniqueness and it is recorded in system.Practitioner exports when the data of amended record to EXCEL file, automatically
It obtains and currently reports and submits identifying code with uniqueness corresponding to the phase and be written in the file attribute of EXCEL file.
S104: data importing is carried out according to the data file and the identifying code that prestores.
Fig. 6 is the flow diagram of step S104 in the embodiment of the present invention, referring to Fig. 6, step S104 includes:
S201: the identifying code stored in the file attribute of the data file is read.
In one embodiment of the invention, practitioner's export obtains automatically when the data of amended record to EXCEL file
It takes and currently reports and submits identifying code with uniqueness corresponding to the phase, and be written in the file attribute of EXCEL file.
S202: compare the last modification time and it is described prestore timestamp, obtain comparison result；
S203: data importing is carried out according to the comparison result.
Fig. 7 is the flow diagram of the embodiment one of step S203 in the embodiment of the present invention, referring to Fig. 7, in this hair
In bright embodiment one, which includes:
S301: when the comparison result show the identifying code and prestore identifying code it is consistent when, record data text
Part；
S302: the data file is loaded.
Fig. 8 is the flow diagram of the embodiment two of step S203 in the embodiment of the present invention, referring to Fig. 8, in this hair
In bright embodiment two, which includes:
S401: when the comparison result show the identifying code and prestore identifying code it is inconsistent when, export prompting message；
S402: newest user logging is downloaded in the prompting message prompting from the information system.
That is, reading importing data film in the present invention, and read the identifying code of data file, then with deposited in system
The identifying code that prestores of storage compares, and unanimously then allows to import, data are loaded onto system by system log data file；It is inconsistent
Then refuse to import, and practitioner is reminded to download newest user logging in systems, and is led after carrying out amended record based on this
Enter.
As above it is that a kind of data based on information system provided by the invention import anti-weighing method, reports and submits the phase for each
Secondary to generate unique identifying code, practitioner is chosen in systems when the record of amended record and when exporting to EXCEL file, this document
This identifying code is recorded in attribute and is not easy arbitrarily to be distorted, import system after this reports and submits the phase time to complete data amended record, system
The consistency of the identifying code recorded in the identifying code and EXCEL file of automatic verifying storage, is consistent, allows to import, not be inconsistent, refuse
It imports absolutely, and prompts to download newest user logging and carry out amended record based on this, so avoid practitioner current
It is misled during reporting and submitting and reported and submitted data into a upper phase, covering or the rollback of reporting and submitting data to the current period are caused, to the work of business personnel
Cause great convenience.
The present invention also provides a kind of computer equipment, including memory, processor and storage are on a memory and can be
The computer program run on processor, the processor are realized a kind of based on information system when executing the computer program
Data import anti-weighing method.
The present invention also provides a kind of computer readable storage medium, the computer-readable recording medium storage has execution
A kind of anti-weighing method of data importing based on information system.
It should be noted that although describing the operation of the method for the present invention in the accompanying drawings with particular order, this is not required that
Or hint must execute these operations in this particular order, or have to carry out operation shown in whole and be just able to achieve the phase
The result of prestige.Additionally or alternatively, it is convenient to omit multiple steps are merged into a step and executed by certain steps, and/or will
One step is decomposed into execution of multiple steps.After describing exemplary embodiment of the invention, next, with reference to attached drawing pair
The system of exemplary embodiment of the invention is introduced.The implementation of the system may refer to above-mentioned whole implementation, repetition
Place repeats no more.
Below with reference to specific embodiment, technical solution of the present invention is discussed in detail.
In financial field, the needs for closing rule are managed in order to meet, each mechanism has developed in succession for customer information, hands over
Easy information, account information acquisition and report and submit system.To meet the requirement for reporting and submitting timeliness, need to be completed by means of EXCEL big
The data inputting of data volume operates, and is then introduced into and system is reported and submitted to carry out subsequent data examination & approval and report and submit process.The present invention is
Customer manager misleads during currently reporting and submitting and reported and submitted data into a upper phase in order to prevent, causes the covering that data are reported and submitted to the current period
Or it retracts.
Fig. 9 imports anti-heavy flow diagram to carry out data in specific embodiment provided by the invention, referring to Fig. 9,
Data import anti-heavy process and include: in this embodiment
S1: generating and stores current identifying code.
It reports and submits system according to certain operation rule, reports and submits the phase time to generate verifying with uniqueness respectively according to different
Code is simultaneously recorded in system.
S2: export is to amended record data to EXCEL file.
In the present embodiment, customer manager exports the data to amended record to EXCEL file, to complete to customer information, account
Work is filled up in family information, the newly-increased of Transaction Information, modification, deletion etc..In export when the data of amended record, system obtains automatically to be worked as
Before report and submit identifying code with uniqueness corresponding to the phase and be written in the attribute of EXCEL file.
S3: data are reported and submitted in importing.
In this embodiment, customer manager complete it is current report and submit the amended record of data after, by EXCEL file import system；
Or customer manager's maloperation, by the EXCEL file import system of former period amended record.
S4: verifying code check.
The identifying code stored in system Read EXCEL Document attribute, and compare with the current identifying code stored in system,
Consistent then allow to import, system records EXCEL file, and data are loaded onto and report and submit system；It is inconsistent, refuse to import, and remind
Customer manager downloads newest user logging in systems, and imports after carrying out amended record based on this.
Therefore, in the present invention, for unique identifying code is generated during each report and submit, customer manager is in reporting and submitting system
Choose when the user logging of amended record and when exporting to EXCEL file, recorded in this document attribute this identifying code and be not easy by with
Meaning is distorted, import system after current completion data amended record, the identifying code recorded in the automatic service for checking credentials end of system and EXCEL file
Consistency, be consistent, allow to import, not be inconsistent, refuse to import, and prompt to download newest user logging and based on this into
Row amended record.
In conclusion the present invention provides a kind of, the data based on information system import anti-weighing method, are based on information system
Data import anti-heavy equipment, information system, computer equipment and computer readable storage medium, obtain the number of importing first
According to file, the phase time is reported and submitted in reading, reports and submits the phase time to obtain from the information system to prestore identifying code according to described, when identifying code with
And prestore timestamp and unanimously then allow to import, it is inconsistent, refuse to import, so avoids practitioner during currently reporting and submitting
It misleads and reported and submitted data into a upper phase, cause covering or the rollback of reporting and submitting data to the current period, caused to the work of business personnel
It greatly facilitates.
It is improvement on hardware (for example, to diode, crystal that the improvement of one technology, which can be distinguished clearly,
Pipe, switch etc. circuit structures improvement) or software on improvement (improvement for method flow).However, with technology
The improvement of development, current many method flows can be considered as directly improving for hardware circuit.Designer is almost
All corresponding hardware circuit is obtained by the way that improved method flow to be programmed into hardware circuit.
Therefore, it cannot be said that the improvement of a method flow cannot be realized with hardware entities module.For example, programmable patrol
Volume device (Programmable Logic Device, PLD) (such as field programmable gate array (Field Programmable
Gate Array, FPGA)) it is exactly such a integrated circuit, logic function determines device programming by user.By designing
Personnel, which voluntarily program, to come a digital display circuit " integrated " on a piece of PLD, designed without asking chip maker and
Make dedicated IC chip.Moreover, nowadays, substitution manually makes IC chip, and this programming also changes mostly
It is realized with " logic compiler (logic compiler) " software, software compiler phase used when it writes with program development
It is similar, and the source code before compiling also write by handy specific programming language, this is referred to as hardware description language
(Hardware Description Language, HDL), and HDL is also not only a kind of, but there are many kind, such as ABEL
(Advanced Boolean Expression Language)、AHDL(Altera Hardware Description
Language)、Confluence、CUPL(Cornell University Programming Language)、HDCal、JHDL
(Java Hardware Description Language)、Lava、Lola、MyHDL、PALASM、RHDL(Ruby
Hardware Description Language) etc., VHDL (Very-High-Speed is most generally used at present
Integrated Circuit Hardware Description Language) and Verilog2.
Those skilled in the art, which also will be apparent to the skilled artisan that, only to need with above-mentioned several hardware description languages slightly to patrol method flow
It collects and programs and be programmed into integrated circuit, so that it may be readily available the hardware circuit for realizing the logical method process.
Controller can be implemented in any suitable manner, for example, controller can take such as microprocessor or processing
The computer for the computer readable program code (such as software or firmware) that device and storage can be executed by (micro-) processor can
Read medium, logic gate, switch, specific integrated circuit (Application Specific Integrated Circuit,
ASIC), the form of programmable logic controller (PLC) and insertion microcontroller, the example of controller includes but is not limited to following microcontroller
Device: ARC625D, Atmel AT91SAM, Microchip PIC18F26K20 and Silicone Labs C8051F320 are deposited
Memory controller is also implemented as a part of the control logic of memory.
It is also known in the art that other than realizing controller in a manner of pure computer readable program code, it is complete
Entirely can by by method and step carry out programming in logic come so that controller with logic gate, switch, specific integrated circuit, programmable
Logic controller realizes identical function with the form for being embedded in microcontroller etc..Therefore this controller is considered one kind
Hardware component, and the structure that the device for realizing various functions for including in it can also be considered as in hardware component.Or
Even, can will be considered as realizing the device of various functions either the software module of implementation method can be Hardware Subdivision again
Structure in part.
System, device, module or the unit that above-described embodiment illustrates can specifically realize by computer chip or entity,
Or it is realized by the product with certain function.
For convenience of description, it is divided into various units when description apparatus above with function to describe respectively.Certainly, implementing this
The function of each unit can be realized in the same or multiple software and or hardware when application.
As seen through the above description of the embodiments, those skilled in the art can be understood that the application can
It realizes by means of software and necessary general hardware platform.Based on this understanding, the technical solution essence of the application
On in other words the part that contributes to existing technology can be embodied in the form of software products, the computer software product
It can store in storage medium, such as ROM/RAM, magnetic disk, CD, including some instructions are used so that a computer system
(can be personal computer, server or network system etc.) executes the certain of each embodiment of the application or embodiment
Method described in part.
All the embodiments in this specification are described in a progressive manner, same and similar portion between each embodiment
Dividing may refer to each other, and each embodiment focuses on the differences from other embodiments.Especially for system reality
For applying example, since it is substantially similar to the method embodiment, so being described relatively simple, related place is referring to embodiment of the method
Part explanation.
The application can be used in numerous general or special purpose computing system environments or configuration.Such as: personal computer, clothes
Business device computer, hand system or portable system, plate system, multicomputer system, microprocessor-based system, set
Top box, programmable consumer electronics system, network PC, minicomputer, mainframe computer including any of the above system or system
Distributed computing environment etc..
The application can describe in the general context of computer-executable instructions executed by a computer, such as program
Module.Generally, program module includes routines performing specific tasks or implementing specific abstract data types, programs, objects, group
Part, data structure etc..The application can also be practiced in a distributed computing environment, in these distributed computing environments, by
Task is executed by the connected teleprocessing system of communication network.In a distributed computing environment, program module can be with
In the local and remote computer storage media including storage system.
Although depicting the application by embodiment, it will be appreciated by the skilled addressee that the application there are many deformation and
Variation does not depart from spirit herein, it is desirable to which the attached claims include the essence of these deformations and variation without departing from the application
Mind.
Claims (15)
1. a kind of data based on information system import anti-weighing method, which is characterized in that the described method includes:
Obtain the data file imported by information system；
Read that the data file is corresponding to report and submit phase time from the data file；
Phase time acquisition from the information system is reported and submitted to prestore identifying code according to described；
Data importing is carried out according to the data file and the identifying code that prestores.
2. the method according to claim 1, wherein the data file is EXCEL file, including client believes
Breath, account information and Transaction Information.
3. according to the method described in claim 2, it is characterized in that, described prestore identifying code by the information system according to reporting and submitting
What the phase time generated and recorded according to preset operation rule.
4. according to the method described in claim 3, it is characterized in that, according to the data file and it is described prestore identifying code into
Row data import
Read the identifying code stored in the file attribute of the data file；
Compare the identifying code and it is described prestore identifying code, obtain comparison result；
Data importing is carried out according to the comparison result.
5. according to the method described in claim 4, it is characterized in that, including: according to comparison result progress data importing
When the comparison result show the identifying code and prestore identifying code it is consistent when, record the data file；
Load the data file.
6. according to the method described in claim 4, it is characterized in that, including: according to comparison result progress data importing
When the comparison result show the identifying code and prestore identifying code it is inconsistent when, export prompting message, the prompting
Information downloads newest user logging for reminding from the information system.
7. a kind of data based on information system import anti-heavy equipment, which is characterized in that the equipment includes:
Data file obtains module, for obtaining the data file imported by information system；
Phase time read module is reported and submitted, reports and submits the phase time for reading from the data file；
It prestores identifying code and obtains module, prestore identifying code for reporting and submitting the phase time to obtain according to from the information system；
Data import modul, for carrying out data importing according to the data file and the identifying code that prestores.
8. equipment according to claim 7, which is characterized in that the data file is EXCEL file, including client believes
Breath, account information and Transaction Information.
9. equipment according to claim 8, which is characterized in that described to prestore identifying code by the information system according to reporting and submitting
What the phase time generated and recorded according to preset operation rule.
10. equipment according to claim 9, which is characterized in that the data import modul includes:
Identifying code read module, the identifying code stored in the file attribute for reading the data file；
Identifying code comparison module obtains comparison result for comparing the identifying code and prestoring identifying code；
Data file import modul, for carrying out data importing according to the comparison result.
11. equipment according to claim 10, which is characterized in that the data file import modul includes:
Data file module, for when the comparison result show the identifying code and prestore identifying code it is consistent when, note
Record the data file；
Data file loading module, for loading the data file.
12. equipment according to claim 10, which is characterized in that the data file import modul includes:
Prompting message output module, for when the comparison result show the identifying code and prestore identifying code it is inconsistent when,
Prompting message is exported, the prompting message downloads newest user logging for reminding from the information system.
13. a kind of information system, which is characterized in that the information system includes as described in claim 7 to 12 any one
Data based on information system import anti-heavy equipment.
14. a kind of computer equipment including memory, processor and stores the meter that can be run on a memory and on a processor
Calculation machine program, which is characterized in that the processor realizes claim 1 to 6 any one institute when executing the computer program
The data based on information system stated import anti-weighing method.
15. a kind of computer readable storage medium, which is characterized in that the computer-readable recording medium storage has perform claim
It is required that the data described in 1 to 6 any one based on information system import anti-weighing method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910752208.1A CN110489251A (en) | 2019-08-15 | 2019-08-15 | A kind of anti-weighing method of data importing, equipment and system based on information system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910752208.1A CN110489251A (en) | 2019-08-15 | 2019-08-15 | A kind of anti-weighing method of data importing, equipment and system based on information system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110489251A true CN110489251A (en) | 2019-11-22 |
Family
ID=68551179
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910752208.1A Pending CN110489251A (en) | 2019-08-15 | 2019-08-15 | A kind of anti-weighing method of data importing, equipment and system based on information system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110489251A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080126869A1 (en) * | 2006-09-26 | 2008-05-29 | Microsoft Corporaion | Generating code to validate input data |
| CN107665195A (en) * | 2016-07-27 | 2018-02-06 | 北京京东尚科信息技术有限公司 | Import the method, apparatus and system of mass data |
| CN107798128A (en) * | 2017-11-14 | 2018-03-13 | 泰康保险集团股份有限公司 | Data lead-in method, device, medium and electronic equipment |
| CN108491475A (en) * | 2018-03-08 | 2018-09-04 | 平安科技（深圳）有限公司 | Data rapid batch introduction method, electronic device and computer readable storage medium |
-
2019
- 2019-08-15 CN CN201910752208.1A patent/CN110489251A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080126869A1 (en) * | 2006-09-26 | 2008-05-29 | Microsoft Corporaion | Generating code to validate input data |
| CN107665195A (en) * | 2016-07-27 | 2018-02-06 | 北京京东尚科信息技术有限公司 | Import the method, apparatus and system of mass data |
| CN107798128A (en) * | 2017-11-14 | 2018-03-13 | 泰康保险集团股份有限公司 | Data lead-in method, device, medium and electronic equipment |
| CN108491475A (en) * | 2018-03-08 | 2018-09-04 | 平安科技（深圳）有限公司 | Data rapid batch introduction method, electronic device and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108268253B (en) | Interface code generation method and terminal equipment | |
| EP3433732B1 (en) | Converting visual diagrams into code | |
| CN107644286A (en) | Workflow processing method and device | |
| CN106776515A (en) | The method and device of data processing | |
| CN111858371A (en) | Software testing method, system, storage medium and computer equipment | |
| CN107329899A (en) | A kind of application compatibility method of testing and device | |
| CN110336814A (en) | A kind of analytic method, equipment and the system of SWIFT message | |
| US7203671B1 (en) | System and method for validating the technical correctness of an OLAP reporting project | |
| CN109284225A (en) | A kind of quality determining method and electronic equipment of multi-person synergy exploitation programming code | |
| CN107273300A (en) | A kind of applied program testing method and device | |
| CN109033124A (en) | A kind of method and device of Data Migration | |
| CN111190814B (en) | Method and device for generating software test case, storage medium and terminal | |
| US8510714B2 (en) | Implementing integrated documentation and application testing | |
| CN109885290B (en) | Application program service description information generation and release method, device and storage medium | |
| CN114185791A (en) | Method, device and equipment for testing data mapping file and storage medium | |
| CN112650673A (en) | Method and device for creating test case in transaction tracking system and electronic equipment | |
| CN110489251A (en) | A kind of anti-weighing method of data importing, equipment and system based on information system | |
| CN110471745A (en) | A kind of service orchestration method and device | |
| CN110471973A (en) | A kind of anti-weighing method of data importing, equipment and system based on information system | |
| US11947938B2 (en) | Application development platform | |
| CN116301856A (en) | Design method, device, equipment and medium of visual form designer | |
| CN115599679A (en) | Test rule base updating method and device, electronic equipment and storage medium | |
| CN110597862A (en) | Data entry method, equipment and system based on information system | |
| CN110427417A (en) | A kind of anti-weighing method of data importing, equipment and system based on information system | |
| CN114995728A (en) | Rule configuration method and device, electronic equipment and storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191122 |
|
| RJ01 | Rejection of invention patent application after publication |